How can I use Dictionary for my requirement?

Question

Hi all I am having a requirement like selecting multiple values and then to delete. I will have some list ofEMployee IDs along with Dates and PayID values.

I will get all this fields in multiple. Now i would like to add this to dictionary element like for particularEmpID I have to assign Date and PayID as keys.

I thought of writing like this

public struct MyValue
{
    public List<int> lst;
    public List<int> lst1;
    public List<DateTime> lstdt;
}

public class MyDictionary : Dictionary<int, MyValue>
{
    public void Add(int key, List<int> lst1, List<int> lst2, List<DateTime> lstDt1)
    {
        MyValue v1=new MyValue();
        v1.lst = lst1;
        v1.lst1 = lst2;
        v1.lstdt = lstDt1;
        this.Add(key, v1);
    }
}

But I am little bit confused in dealing with this so can any one give me an idea to implement as per my requirement.

This is my requirement if I have EmpID as 1 for this I will have Multiple PayIDs and Dates like 1 and System Date.

Even I will get Mutilple EmpIDs But if exists already in the dictionary as Key element I don't want to add it again.

(using 2.0 framework)

How can I do this?

Vulpes · Answer

The only problem I can immediately see is in this foreach statement where I've highlighted the changes you'll need for it to build: foreach (int EmpID in d.Keys) { foreach (int pID in d[EmpID] .lst ) { sb.Append(pID); } foreach (DateTime dtTimes in d[EmpID] .lstdt ) { sb1.Append(dtTimes.ToString()); } }

Dorababu Meka · Answer

Yeah Vulpes i just checked it and corrected anyway thanks for ur help

Dorababu Meka · Answer

Hi Vulpes thanks for your answer i tried as follows but i am getting error can you tell what's wrong arrEmpID . Add ( 1 ); arrEmpID . Add ( 1 ); arrEmpID . Add ( 2 ); arrEmpID . Add ( 2 ); arrPay . Add ( 1 ); arrPay . Add ( 1 ); arrPay . Add ( 2 ); arrPay . Add ( 2 ); DateTime dt = DateTime . Now ; DateTime dt1 = DateTime . Now . AddMinutes ( 1 ); DateTime dt2 = DateTime . Now . AddMinutes ( 1 ); DateTime dt3 = DateTime . Now . AddMinutes ( 1 ); arrPayID . Add ( dt ); arrPayID . Add ( dt1 ); arrPayID . Add ( dt2 ); arrPayID . Add ( dt3 ); EmpIDs = ( int []) arrEmpID . ToArray ( typeof ( int )); Dates = ( DateTime []) arrPayID . ToArray ( typeof ( DateTime )); PayIDs = ( int []) arrPay . ToArray ( typeof ( int )); for ( int i = 0 ; i EmpIDs . Length ; i ++) { if (!( d . ContainsKey ( EmpIDs [ i ]))) { List values = new List (); List DateTime > ldt = new List DateTime >(); d . Add ( EmpIDs [ i ], values , ldt ); } d [ EmpIDs [ i ]]. lst . Add ( PayIDs [ i ]); d [ EmpIDs [ i ]]. lstdt . Add ( Dates [ i ]); } foreach ( int EmpID in d . Keys ) { foreach ( int pID in d [ EmpID ]) { sb . Append ( pID ); } foreach ( DateTime dtTimes in d [ EmpID ]) { sb1 . Append ( dtTimes . ToString ()); } } Label1 . Text = sb . ToString (); Label2 . Text = sb1 . ToString (); I have my dictionary as follows public struct MyValue { public List lst ; public List DateTime > lstdt ; } public class MyDictionary : Dictionary int , MyValue > { public void Add ( int key , List lst1 , List DateTime > lstDt1 ) { MyValue v1 = new MyValue (); v1 . lst = lst1 ; v1 . lstdt = lstDt1 ; this . Add ( key , v1 ); } }

Vulpes · Answer

Rather than place Lists within the struct, I'd place a scalar PayId and Date field within each struct, create a List of the structs and then use that as the value of the Dictionary: using System; using System.Collections.Generic; struct MyValue { public int PayId; public DateTime Date; public MyValue(int payId, DateTime date) { PayId = payId; Date = date; } public override string ToString() { return String.Format("{0} : {1}", PayId, Date.ToShortDateString()); } } class Test { static void Main() { int[] empIds = new int[]{1, 2}; List [] myValues = new List [2]; DateTime dt = DateTime.Today; int[] payIds1 = new int[]{1, 2, 3}; DateTime[] dates1 = new DateTime[]{dt, dt.AddDays(1), dt.AddDays(2)}; myValues[0] = new List (); for(int i = 0; i { myValues[0].Add(new MyValue(payIds1[i], dates1[i])); } int[] payIds2 = new int[]{4, 5, 6}; DateTime[] dates2 = new DateTime[]{dt.AddDays(3), dt.AddDays(4), dt.AddDays(5)}; myValues[1] = new List (); for(int i = 0; i { myValues[1].Add(new MyValue(payIds2[i], dates2[i])); } Dictionary > dict = new Dictionary >(); // populate dictionary for(int i = 0; i { if (!dict.ContainsKey(empIds[i])) { dict.Add(empIds[i], myValues[i]); } } // retrieve foreach(int k in dict.Keys) { foreach(MyValue mv in dict[k]) Console.WriteLine(mv); Console.WriteLine(); } Console.ReadKey(); } }