Re: Keeping count of total - C# Discussion Boards

5-May-08 21:36

Hi Guys. In my app that I am working on I am importing a csv file into a FileHelpers engine. I take the one field from the res and use it to look up a description for it in another function, validate pcode.

I then write the output of the res + prov to a textbox. I then write the textbox data to a .txt file using StreamWriter.

I need to keep count of the totals of each prov I find. There are a total of 9 provinces and I need to list a total of each province. Can sombody advise me on the easiest way of doiing this? Below my code.

This is where I do the validation to find the appropriate province.

My apologies for the lengthy post

private string SearchPcode(string inputStr)
{
    string retval = "";
    int pcode = 0;
    if (!int.TryParse(inputStr, out pcode))
    {
        retval = "Invalid Integer!";
    }
    else if ((pcode >= 4731) && (pcode <= 6499))
    {
        retval = "Eastern Cape";
    }
    else if ((pcode >= 9300) && (pcode <= 9999))
    {
        retval = "Free State";
    }
    else if ((pcode >= 0001) && (pcode <= 0299)
        || (pcode >= 1400) && (pcode <= 2199))
    {
        retval = "Gauteng";
    }
    else if ((pcode >=2900) && (pcode <= 4730))
    {
        retval = "Kwazulu Natal";
    }
    else if ((pcode >= 0500) && (pcode <= 0999))
    {
        retval = "Limpopo";
    }
    else if ((pcode >= 1000) && (pcode <= 1399)
        || (pcode >= 2200) && (pcode <= 2499))
    {
        retval = "Mpumalanga";
    }
    else if ((pcode >= 0300) && (pcode <= 0499)
        || (pcode >= 2500) && (pcode <= 2899))
    {
        retval = "North West Province";
    }
    else if ((pcode >= 8100) && (pcode <= 8999))
    {
        retval = "Northern Cape";
    }
    else if ((pcode >= 6500) && (pcode <= 8099))
    {
        retval = "Western Cape";
    }
    else
    {
        retval = "Invalid PostCode";
    }
    return retval;
}

This is the import for the csv file where I instantiate the search for the province.

private void btnOpenFile_Click(object sender, EventArgs e)
{
    txtboxDisplay.Text = "";
    txtboxPcode.Text = "";
    if (openFileDialog1.ShowDialog() != DialogResult.OK)
    {
        return;
    }
    else
    {
        txtboxSelectFile.Text = openFileDialog1.FileName;
    }
    string filePath;
    filePath = txtboxSelectFile.Text;

    FileHelperEngine<CsvImp> engine = new FileHelperEngine<CsvImp>();

    engine.ErrorManager.ErrorMode = ErrorMode.SaveAndContinue;

    CsvImp[] res = engine.ReadFile(filePath);
    StreamWriter sw = new StreamWriter(@"C:\SOLZ_PROV_" +
        DateTime.Now.ToString("ddMMyyhhmmss") + ".txt");
    if (engine.ErrorManager.ErrorCount > 0)
        engine.ErrorManager.SaveErrors("Errors.txt");
    foreach (CsvImp imp in res)
    {
        string prov = SearchPcode(imp.CallComments); //Search for province
        txtboxDisplay.Text += imp.CompanyCode + "\t"
            + imp.CallType + "\t"
            + imp.CallComments.ToString()
            + "\t" + prov + Environment.NewLine;
    }

        sw.WriteLine(txtboxDisplay.Text);
        sw.Close();
    }

Please advise the easiest way of keeping track and writing the totals for each province.

Excellence is doing ordinary things extraordinarily well.

Christian Graus5-May-08 21:58

5-May-08 21:58

If you're tracking several provinces, use a dictionary that maps an enum ( because that's more reliable than a string ) to an int, and just keep adding to the number stored for each value.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

MumbleB5-May-08 23:39

5-May-08 23:39

Thanks mate. I'll go and read up on this if I can find a good article. Have not used it before. Or do you know of any article that can explain this? I haven't googled for one yet. Blush | :O

Excellence is doing ordinary things extraordinarily well.

Christian Graus6-May-08 1:13

6-May-08 1:13

Dictionary<string, int> d = new Dictionary<string, int>();

void AddItem(string key)
{
if (!d.ContainsKey(key))
{
d[key] = 1;
}
else
{
++d[key];
}
}

Then you end up with a collection of keys, each is the name of an object you were counting ( I said use an enum, but I am simplifying this example ). So you iterate over the keys, and for each key, d[key] will return the number of items records for that key.

MumbleB6-May-08 1:25

6-May-08 1:25

Thanks mate. I will give this a shot and see what I come up with. I have found a few articles on the subject as well so will readup on them. Just don't have that much time left to deliver a working demo. And the Milestones changing everytime doesn't help me much either.

Thanks again.

Excellence is doing ordinary things extraordinarily well.

Christian Graus6-May-08 1:29

6-May-08 1:29

No worries - always glad to help. Dictionaries are an awesome container to get your head around, they have all sorts of uses. Hope it helped.

I know what you mean about shifting goals tho, we all get that.

Christian Graus6-May-08 22:15

6-May-08 22:15

void AddItem(string key)
{
if (!objDict.ContainsKey(key))
{
objDict[key] = 1;
}
else
{
++objDict[key];
}
foreach (KeyValuePair<string, int> kvp in objDict)
{
txtboxTot.Text = ("Povince : " + kvp.Key + "\t" + kvp.Value);
}
}

You have two issues

1 - you're setting the textbox value inside the method that is adding them, so it's going to happen every time you add a value
2 - you set the textbox to be the last key/value pair you iterate over, because you do txtboxTot.Text = instead of txtboxTot.Text +=

Factor this code out to run when the loop that adds the values has ended, and have it add the values, instead of just showing the last one looped over. Also, use Environment.NewLine to put newlines in your textbox, if you want them ( make sure you set the textbox to be multiline )

MumbleB7-May-08 1:56

7-May-08 1:56

THanks again mate. I got it working. One last question. Can I store multiple fields in the Dictionary? I.e. store the prov field which we are currently doing plus a few others and then itterate through them as well?

Excellence is doing ordinary things extraordinarily well.

Christian Graus7-May-08 11:56

Displaying a form from en existing form

7-May-08 11:56

A dictionary maps one type to another type. Either type can be a class or struct, so you can store all the values you want in a class or struct and map to instances of it.

Berlus5-May-08 21:35

Berlus

5-May-08 21:35

Hello,

I wrote a liitle program that displays a form with a button.
Once the button is pressed the program goes over the elemnts of some collection.

I would like to dispaly this elements on diffrent form, that would function as a simplified logger, on top of the existing form.

How can i do this ? must it be on a diffrent thread ? some code snippet would be great.

Thanks,
Berlus

Re: Displaying a form from en existing form

Abhijit Jana5-May-08 21:55

Abhijit Jana

5-May-08 21:55

your prolem is not clear from me. can you be more specific?
Thanks

Best Regards
-----------------
Abhijit Jana
"Success is Journey it's not a destination"

Re: Displaying a form from en existing form

Christian Graus5-May-08 22:00

5-May-08 22:00

A second form would be on the same thread, just design it, and make an instance a member variable, then calling Show() would show it without stopping interaction with the main form. Show(this) would make it a proper child form. You can interact with it then via properties you expose, or use delegates to interact back to the main form

CheckBox in ListView

stancrm5-May-08 21:28

stancrm

5-May-08 21:28

Hello..

I have a ListView with CheckBoxes = TRUE. If I set FullRowSelect to TRUE, by DoubleClick (for example in Column 5) is the checkbox automatically set to TRUE or FALSE. How to avoid this ?

I want to use FullRowSelect (because of DoubleClick) but I don't want to change the state of CheckBox.
CheckBox state can only be changed, if user click on checkbox, not on "anywhere" in row.

Thx..

Re: CheckBox in ListView

Christian Graus5-May-08 22:09

WorkFlow Project In Visual Studio 2005

5-May-08 22:09

I assume you'd have to derive a class from teh control, handle the click and stop it from changing the state of the control if it's not in the right area.

Indexers

Steve Declerck5-May-08 20:44

Steve Declerck

5-May-08 20:44

Hi all,

I don't understand most of this "Indexer" code :

namespace UsingIndexers
{
class TestIndexers
{
private string[] MyStrings;

public TestIndexers()
{
MyStrings = new string[] { "This", "is", "an", "indexer", "test" };
}

// array like access
public string this[int index]
{
get
{
if (index < 0 || index >= MyStrings.Length)
{
throw new ArgumentOutOfRangeException();
}
return MyStrings[index];
}
set
{
if (index >= MyStrings.Length)
{
throw new ArgumentOutOfRangeException();
}
else
MyStrings[index] = value;
}
}

static void Main()
{
TestIndexers MyIndexer = new TestIndexers();

Console.WriteLine("index 1 is: {0}", MyIndexer[1]);
}
}
}

Especially I don't understand the use of indexers. Every individual element of MyStrings can be accessed through MyStrings[i]. WHy still additional code for indexing ?
And also this line of code is difficult for me :

public string this[int index]

What is the meaning of "this" ?

Any help is very much appreciated...
Many thanks in advance !!

Best regards, Steve

Re: Indexers

Vikram A Punathambekar5-May-08 20:59

Vikram A Punathambekar

5-May-08 20:59

Steve Declerck wrote:
Every individual element of MyStrings can be accessed through MyStrings[i]. WHy still additional code for indexing ?

But your data should be private. The indexer allows you to expose a public interface (don't confuse that with a C# interface) for your private data. Of course, you could do away with an indexer and use a GetXXX(int index) method, but indexers are elegant. You are not limited to integers; you can also use other types for the indexer.

Steve Declerck wrote:
public string this[int index]

What is the meaning of "this" ?

this is a keyword used to refer to the home object, i.e., the object on which the code is operating.

I don't mean to be condescending, but a good book will explain all of this in greater detail. I'd recommend Andrew Troelsen.

Cheers,
Vikram.

The hands that help are holier than the lips that pray.

Re: Indexers

Steve Declerck5-May-08 23:15

Steve Declerck

5-May-08 23:15

Hello Vikram,

Thank you very much for your fast reply ! I understand it now...

Thanks, Steve

Re: Indexers

PIEBALDconsult6-May-08 6:05

PIEBALDconsult

6-May-08 6:05

Yeah, what Vikram said.

Plus, the actual data needn't be stored in an array.

An indexer could be implemented with a database query.

The data needn't be stored anywhere at all; one could write a factorial method as an indexer:

private ulong
this
[
    ulong i
]
{
    get
    {
        for ( ulong j = i - 1 ; j > 1 ; j-- )
        {
            i *= j ;
        }

        return ( i ) ;
    }
}

(Though that's fairly silly.)

Thaer Hamael5-May-08 19:29

Thaer Hamael

5-May-08 19:29

hi all
i instaled in My PC Visual Studio 2005 and I Wount to use the WorkFlow Project , what it's need to enable the template workflow in Visual Studio 2005 .

if it need FramewWOrk 3.5 i instaled it but it is not enable .
what i can do to enable it .

thanks for all Rose | [Rose]

Thaer

John_Adams5-May-08 20:57

John_Adams

5-May-08 20:57

Hi Thaer,

If you are looking to use SharePoint WorkFlow template in VS2005 then I think the following article will be helpful to you.
http://weblog.vb-tech.com/nick/archive/2007/02/25/2207.aspx[^]

Hope this helps Smile | :)

Regards,
John Adams
ComponentOne LLC

Thaer Hamael6-May-08 1:20

Thaer Hamael

6-May-08 1:20

Thanks Mr John Adams
i instaled it . and it's Ok But the Desinger is Error
the Error Is :-

The designer could not be show for this file becouse none of the classes within it can be
designed .

what i can dot for this problem ?
Thanks Mr Rose | [Rose]

Thaer

Abhijit Jana5-May-08 22:06

Abhijit Jana

5-May-08 22:06

For VS 2005, After Installing Framework 3.0 you have to install WWF Extention .

Best Regards
-----------------
Abhijit Jana
"Success is Journey it's not a destination"

Abhijit Jana5-May-08 22:31

Abhijit Jana

5-May-08 22:31

install it from

http://www.microsoft.com/downloads/details.aspx?FamilyId=A2151993-991D-4F58-A707-5883FF4C1DC2&displaylang=en[^]

Best Regards
-----------------
Abhijit Jana
"Success is Journey it's not a destination"