public frmManageItems() { InitializeComponent(); objDB = new SL8DbDataContext(); ItemsBindingSource.DataSource = objDB.PurchasedItems; }
public frmShipClassifications() { InitializeComponent(); objDB = new SL8DbDataContext(); shipClassificationBindingSource.DataSource = objDB.ShipClassifications; }
public frmSettings() { InitializeComponent(); objDB = new SL8DbDataContext(); settingBindingSource.DataSource = objDB.Settings; }
public frmShipCarriers() { InitializeComponent(); objDB = new SL8DbDataContext(); shipCarrierBindingSource.DataSource = objDB.ShipCarriers; }
public frmCustomerLabels() { ToolTip objToolTip = new ToolTip(); InitializeComponent(); objToolTip.SetToolTip(txtCustomerNo, "0 displays labels that show for ALL Customers"); objDB = new SL8DbDataContext(); customerLabelBindingSource.DataSource = objDB.CustomerLabels; }
public TimePhasedItemList(bool SetDueDateByProjectedSchedule) : base() { SL8_WTF_DataBaseSettings objSL8_WTF_DataBaseSettings; SqlCommand objCmd; SqlDataAdapter objAdapter; DataSet objDataSet, objLoadDataSet; TimePhasedItem objTimePhasedInventoryItem; RepletionDepletionItem objRepletionDepletionItem; SL8DbDataContext objDB; int intTemp; objDB = new SL8DbDataContext(); objSL8_WTF_DataBaseSettings = new SL8_WTF_DataBaseSettings(); objSL8_WTF_DataBaseSettings.SQLConnection.Open(); objCmd = new SqlCommand("CLM_ResourceGroupScheduleSp", objSL8_WTF_DataBaseSettings.SQLConnection); objCmd.CommandType = CommandType.StoredProcedure; objCmd.Parameters.Add(new SqlParameter("@StartDate", "1/1/1753")); objCmd.Parameters.Add(new SqlParameter("@EndDate", "12/31/9999")); objCmd.Parameters.Add(new SqlParameter("@AltNum", 0)); objAdapter = new SqlDataAdapter(objCmd); objLoadDataSet = new DataSet(); objAdapter.Fill(objLoadDataSet); objCmd = new SqlCommand("SupDemBuildSp", objSL8_WTF_DataBaseSettings.SQLConnection); objCmd.CommandType = CommandType.StoredProcedure; foreach (var objItem in objDB.PurchasedItems) { objTimePhasedInventoryItem = new TimePhasedItem(); objTimePhasedInventoryItem.ItemID = objItem.ItemID; objTimePhasedInventoryItem.ItemDescription = objItem.Description; objTimePhasedInventoryItem.UnitOfMeasure = objItem.UnitOfMeasure; objCmd.Parameters.Clear(); objCmd.Parameters.Add(new SqlParameter("@Item", objTimePhasedInventoryItem.ItemID)); objCmd.Parameters.Add(new SqlParameter("@Whse", "MAIN")); objCmd.Parameters.Add(new SqlParameter("@StartingDate", DateTime.Now.AddYears(-1).ToShortDateString())); objCmd.Parameters.Add(new SqlParameter("@Filter", DBNull.Value));//This was the only way I could get null passed as a parameter to the stored proc objAdapter = new SqlDataAdapter(objCmd); objDataSet = new DataSet(); objAdapter.Fill(objDataSet); objTimePhasedInventoryItem.RepletionsAndDepletions = new SortableBindingList <RepletionDepletionItem>(); foreach (var objAnonymousRepletionDepletion in objDataSet.Tables[0].AsEnumerable()) { objRepletionDepletionItem = new RepletionDepletionItem { DueDate = objAnonymousRepletionDepletion.Field <DateTime?>("DisplayDate") ?? DateTime.MinValue,//This was how I stopped the null errors from the null dates in the db ProjectedOnHand = objAnonymousRepletionDepletion.Field <decimal>("QtyOnHand"), Qty = objAnonymousRepletionDepletion.Field <decimal>("Qty"), Status = objAnonymousRepletionDepletion.Field <string>("RcptRqmt"), ReferenceData = objAnonymousRepletionDepletion.Field <string>("Reference"), ItemID = objAnonymousRepletionDepletion.Field <string>("Parent"), Job = objAnonymousRepletionDepletion.Field <string>("RefNum") }; if (objRepletionDepletionItem.Job.ToUpper().Trim().Equals("INIT")) { objTimePhasedInventoryItem.QtyOnHand = objRepletionDepletionItem.ProjectedOnHand; objRepletionDepletionItem.DueDate = DateTime.Now; } else if (!string.IsNullOrEmpty(objRepletionDepletionItem.Status) && objRepletionDepletionItem.Status.Equals("Q"))//it is a job, so get the workcenter { var objArray = objRepletionDepletionItem.ReferenceData.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries); objRepletionDepletionItem.Job = objArray[1].Substring(0, objArray[1].IndexOf('-')); objRepletionDepletionItem.Operation = int.TryParse(objArray[2], out intTemp) ? intTemp : 0; objRepletionDepletionItem.Suffix = int.TryParse(objArray[1].Substring(objArray[1].IndexOf('-') + 1, objArray[1].Length - objArray[1].IndexOf('-') - 1), out intTemp) ? intTemp : 0; var query = objLoadDataSet.Tables[0].AsEnumerable() .Where(w => !string.IsNullOrEmpty(w.Field <string>("DerJob")) && w.Field <string>("DerJob").Equals(objRepletionDepletionItem.Job)) .Where(w => !w.IsNull("DerOperNum") && w.Field <int>("DerOperNum") == objRepletionDepletionItem.Operation) .Where(w => !w.IsNull("DerSuffix") && w.Field <Int16>("DerSuffix") == objRepletionDepletionItem.Suffix) .OrderBy(w => w.Field <DateTime>("STARTDATE")) //sort the load so I get the earliest date... .FirstOrDefault(); //I kept getting unhandled null exceptions when executing the below query. turns out that there were nulls in the stored procedure and I needed to check for them; see altered query above. //var query = objLoadDataSet.Tables[0].AsEnumerable() // .Where(w => w.Field<string>("DerJob").Equals(objRepletionDepletionItem.Job) && // w.Field<int>("DerOperNum") == objRepletionDepletionItem.Operation && // w.Field<Int16>("DerSuffix") == objRepletionDepletionItem.Suffix) // .FirstOrDefault(); if (query != null) { objRepletionDepletionItem.WorkCenter = query.Field <string>("DerWC"); //objRepletionDepletionItem.ItemID = query.Field<string>("PARTID"); if (SetDueDateByProjectedSchedule) { objRepletionDepletionItem.DueDate = query.Field <DateTime?>("STARTDATE") ?? DateTime.MinValue; //set the DueDate to the earliest operation start date... } } } objTimePhasedInventoryItem.RepletionsAndDepletions.Add(objRepletionDepletionItem); } this.Add(objTimePhasedInventoryItem); } objSL8_WTF_DataBaseSettings.SQLConnection.Close(); }