public static int update_priority_values(int partid, Dictionary <int, int> d) { int affected_rows = 0; ENGINEERINGDataSetTableAdapters.CUT_MACHINE_PROGRAMSTableAdapter ta = new ENGINEERINGDataSetTableAdapters.CUT_MACHINE_PROGRAMSTableAdapter(); foreach (KeyValuePair <int, int> item in d) { if (item.Value == -1) { ta.DeleteMachPart(item.Key, partid); } else if (ta.UpdatePriority((short)item.Value, item.Key, partid) < 1) { ta.InsertMachPriority(item.Key, partid, (short)item.Value); } affected_rows += 1; } return(affected_rows); }
public static Dictionary <int, int> get_priority_values_inner(int partid) { Dictionary <int, int> d = new Dictionary <int, int>(); ENGINEERINGDataSetTableAdapters.CUT_MACHINE_PROGRAMSTableAdapter ta = new ENGINEERINGDataSetTableAdapters.CUT_MACHINE_PROGRAMSTableAdapter(); ENGINEERINGDataSet.CUT_MACHINE_PROGRAMSDataTable dt1 = new ENGINEERINGDataSet.CUT_MACHINE_PROGRAMSDataTable(); ta.FillBy(dt1, partid); for (int i = 0; i < dt1.Rows.Count; i++) { int mach = 0; int prio = 0; mach = int.Parse(dt1.Rows[i][@"MACHID"].ToString()); prio = int.Parse(dt1.Rows[i][@"PRIORITY"].ToString()); try { d.Add(mach, prio); } catch (System.ArgumentException) { // Key already exists } } return(d); }