Re: How to store Pivot data into List<T> - C# Discussion Boards

How to store Pivot data into List<T>

15-Sep-21 20:20

What is the meaning of forum....it is place where people discuss their problem and other give suggestion & answer if possible.

when a person do not know the answer or have negative mind or sluggish then those people come with excuse like this one.... "Now, it's time for you to get to work."

Cheers.

Mou_kol14-Sep-21 5:53

14-Sep-21 5:53

I am calling a store procedure and SP return data pivot way like below sample

+-----------------+--------------------+-------------+-------------------+----------+----------+-----------+----------+
|     Section     |      LineItem      | Broker Code |    Broker Name    | 2012 FYA | 2013 FYA | 1Q 2014A  | 2Q 2014A |
+-----------------+--------------------+-------------+-------------------+----------+----------+-----------+----------+
| Consensus Model | Net Revenue        | ZB          | B Securities      |          |          |    204.45 |   205.00 |
| Consensus Model | Net Revenue        | TU          | Cantor Fitzgerald |   101.33 |          |    204.45 |   201.00 |
| Consensus Model | Cost of Goods Sold | ZB          | B Securities      |          |          |    204.45 |   205.00 |
| Consensus Model | Cost of Goods Sold | TU          | Cantor Fitzgerald |   101.33 |          |    204.45 |   201.00 |
+-----------------+--------------------+-------------+-------------------+----------+----------+-----------+----------+

i easily can store the data into datatable but i am interested to know how could i store data into List<t> which return store procedure.

i do not want to use Datatable in the middle to hold SP return data.

this is my class where i like to store the above pivot data

public class Data
        {
            public string Section { get; set; }
            public string Lineitem { get; set; }
            public string BrokerCode { get; set; }
            public string BrokerName { get; set; }
            public string Period { get; set; }
            public string PeriodValue { get; set; }
        }

Thanks

Richard Deeming14-Sep-21 6:04

14-Sep-21 6:04

Your class is designed to store the un-pivoted data. You'll need to change your query so that it doesn't pivot the data before you load it.

The alternative would be to redesign your class:

public class Header
{
    public string Section { get; set; }
    public string LineItem { get; set; }
    public string BrokerCode { get; set; }
    public string BrokerName { get; set; }
    public List<PeriodTotal> Periods { get; set; }
}

public class PeriodTotal
{
    public string Period { get; set; }
    public decimal PeriodValue { get; set; }
}

var result = new List<Header>();

using (var reader = command.ExecuteReader())
{
    while (reader.Read())
    {
        string section = reader.GetString(0);
        string lineItem = reader.GetString(1);
        string brokerCode = reader.GetString(2);
        string brokerName = reader.GetString(3);
        
        var periods = new List<PeriodTotal>();
        for (int index = 4; index < reader.FieldCount; index++)
        {
            periods.Add(new PeriodTotal { Period = reader.GetName(index), PeriodValue = reader.GetDecimal(index) });
        }
        
        result.Add(new Header
        {
            Section = section,
            LineItem = lineItem,
            BrokerCode = brokerCode,
            BrokerName = brokerName,
            Periods = periods,
        });
    }
}

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Mou_kol14-Sep-21 6:29

14-Sep-21 6:29

Sir, i can not change the SP which return data in pivot format. please guide me how to change class design which can hold pivot data?

suppose i used to store data into datatable from SP and datatable can store pivot data and later can't we use LINQ to extrac data from datatable and populate my class which i have posted here.

if possible can you please show me the way. thanks

Richard Deeming14-Sep-21 6:49

14-Sep-21 6:49

Read my answer again. I've already shown you! D'Oh! | :doh:

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Mou_kol14-Sep-21 23:14

14-Sep-21 23:14

Sir i understand that you are trying to say change my query in store procedure of sql server as a result query should not return data in pivot style. am i correct ?

thanks

Richard Deeming14-Sep-21 23:17

Active step-two verfication telegram with c#

14-Sep-21 23:17

Yes. Your class is designed to store the un-pivoted data. Whilst you could potentially write code to take the pivoted data and convert it back to the format your class is expecting, it would be far simpler to not pivot the data in the first place.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Nader Rostamkhani8-Sep-21 6:22

Nader Rostamkhani

8-Sep-21 6:22

Hi Please guide me
How to activate the second Telegram password with C#

[REPOST] Active step-two verfication telegram with c#

Richard Deeming8-Sep-21 6:33

What is default unit of EPPlus (point, inches, pixel)

8-Sep-21 6:33

You have already posted this in QA:
Enable two-step verification telegram with C#[^]

And as Bill said there, you haven't provided anywhere near enough detail for anyone to help you.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Mou_kol8-Sep-21 4:39

Re: What is default unit of EPPlus (point, inches, pixel)

8-Sep-21 4:39

i searched lot google to know what is default measurement unit of EPPlus but found no info. anyone can tell me what is default measurement unit of EPPlus ?

is it point, inches, pixel ?

how to change default unit in EPPlus ? share some idea. thanks

Member 153296138-Sep-21 5:22

Member 15329613

8-Sep-21 5:22

If you have a valid license you can contact their support and ask them.

Re: What is default unit of EPPlus (point, inches, pixel)

Mou_kol8-Sep-21 21:22

Re: What is default unit of EPPlus (point, inches, pixel)

8-Sep-21 21:22

i am using free version.

Pete O'Hanlon21-Sep-21 0:26

Pete O'Hanlon

21-Sep-21 0:26

I assume you are talking about eMeasurementUnits[^] here. You can't change a default because it's just that, a default. If what you are after is changing the measurement unit, then that is set via ExcelVmlMeasurementUnit[^].

Advanced TypeScript Programming Projects

Other program access and data extraction

cocaya7-Sep-21 16:48

cocaya

7-Sep-21 16:48

Hello.

I'm trying to get text data from another program.

The window handle was found.
Please check the image link.
CLICK Here - Attach Image Link

But I'm not sure what to do next.

Should I use something similar to the GetDlgCtrlID method?
I do not know.

The return is -1.

Please advise.
thank you.

[REPOST] Other program access and data extraction

Richard Deeming7-Sep-21 21:24

Verification of Information at First Launch

7-Sep-21 21:24

You have already posted this in the C++ forum:
Other program access and data extraction - C / C++ / MFC Discussion Boards[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Member 141922165-Sep-21 4:50

Member 14192216

5-Sep-21 4:50

Hello, here I have finished my Super Market management application, but what worries me is that I am blocked is that after the installation of Setup on the pc when the user will start for the 1st time who has a form that he needs. '' register company information (shop, pharmacy, supermarket, etc.)
Ex: Store name, address, telephone etc. and the name & password for the system administrator. After entering this information, when the user is going to run the program again, he now goes to the "Login" form.
Please if anyone has an idea please help me

Re: Verification of Information at First Launch

jschell5-Sep-21 8:49

jschell

5-Sep-21 8:49

Your question is not clear.

I suspect what you are asking is how you differentiate the following
1. Setup
2. Application.

There are two choices.
1. The application on start up checks for completed information. If not there then ask for it. Otherwise continue.
2. The setup itself always requests the information. You cannot finish the set up without providing the information. If the information is not provided then there is no application to run (again because the set up did not complete.)

Re: Verification of Information at First Launch

OriginalGriff5-Sep-21 10:26

OriginalGriff

5-Sep-21 10:26

To be honest, if you can't work this out on your own, then I wouldn't trust your app to be of any use to anyone in the real world.

All you need to do is add a simple boolean to wherever you are storing the store information and check it when you start up. If it's set, you go to login. If it isn't, you go to the "Enter the initial info" form, and then set it to true ready for next time.

How come you can't work that out for yourself after writing a whole supermarket management app? It's trivial compared with stock management, product ordering, cash and electronic payment handling, staff monitoring, pricing control (including legal requirements on increased / decreased price display / charge order and timing), tax handling, theft prevention, and more ...

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

Re: Verification of Information at First Launch

Pete O'Hanlon5-Sep-21 10:37

Pete O'Hanlon

5-Sep-21 10:37

Is this a commercial application or a school project? If it's a commercial application, I would strongly suggest that you need to invest time in an identity management solution; my preferred choice is Keycloak.

Advanced TypeScript Programming Projects

Amplitude Meter (trackbar?)

weinerschizel4-Sep-21 6:49

weinerschizel

4-Sep-21 6:49

I am measuring voltage and passing it into a C# desktop application. I need to have a graphical representation of that voltage, something similar to a linear volume meter would be perfect.

Currently I've taken a trackbar and am writing the voltage value to it. It's not ideal though. Has some issues. Certainly there's a better way to do this?

Re: Amplitude Meter (trackbar?)

BillWoodruff5-Sep-21 14:21

BillWoodruff

5-Sep-21 14:21

There are some open-source WinForm gauge/meter controls available, as well as commercial controls.

CodeProject is your friend: [^], [^], [^], [^].

For WPF: [^]

«The mind is not a vessel to be filled but a fire to be kindled» Plutarch

C# EPPlus resize pictures to fit in the cell

Mou_kol3-Sep-21 23:40

Re: C# EPPlus resize pictures to fit in the cell

3-Sep-21 23:40

I am trying to place a picture into B1 cell. picture is getting inserted but height is getting bigger than original image. how automatically height is getting stretched?

I am using EPPlus version 4.0.6.0 & .Net version 4.5.2. using VS IDE 2013.

Here is the output screenshot link. please have a look https://i.stack.imgur.com/acavj.png[^]

Here is desired output screenshot link please have a look.
https://i.stack.imgur.com/In3jl.png[^]

here is the code sample which i used to place picture into B1 cell.

imgCompanyLogo = Image.FromFile(@"C:\Users\tridip\Desktop\Test1\www_files\image002.png");
ws.Column(2).Width = Convert.ToDouble((45 + 0.11));
ws.Row(1).Height = Convert.ToDouble((46.5 + 0.11));
ExcelPicture pic = ws.Drawings.AddPicture("Logo", imgCompanyLogo);
pic.SetPosition(0, 0, 1, 0);
pic.SetSize(316, 60);

if i commented or not commented this line

pic.SetPosition(0, 0, 1, 0);

but always getting same output where picture is getting stretched.

see the original image how it looks like. link here https://ibb.co/PCxw3v0

please tell me what is mistake in my code. please suggest a fix by which i can get my desired output.
Thanks

Richard MacCutchan4-Sep-21 1:04

Richard MacCutchan

4-Sep-21 1:04

You need to maintain the aspect ratio of the picture by keeping the height to width the same when you resize it. See How do I get the barcode images to scale properly?[^].

Re: C# EPPlus resize pictures to fit in the cell

Mou_kol4-Sep-21 2:10