private void GetDeliveryScheduleByMonthandYear() { dbsched = new BusDeliverySchedule(); int index = 0; dgvDeliverySchedule.Rows.Clear(); if (dbsched.GetDeliveryScheduleByMonthandYearDT(tbPartCode.Text , Convert.ToInt32(cboDeliverySchedMonth.SelectedValue.ToString()) , Convert.ToInt32(cboDeliverySchedYear.SelectedItem.ToString()) ).Rows.Count == 0) { MessageBox.Show("No Records Found"); } else { foreach (DataRow dr in dbsched.GetDeliveryScheduleByMonthandYearDT(tbPartCode.Text , Convert.ToInt32(cboDeliverySchedMonth.SelectedValue.ToString()) , Convert.ToInt32(cboDeliverySchedYear.SelectedItem.ToString()) ).Rows) { dgvDeliverySchedule.Rows.Insert(index, dr["schedid"], dr["DeliveryDate"], dr["NameOfDay"], dr["DeliverySched_Qty"], dr["DeliverySched_Acc"] , dr["ActDelivery_Qty"], dr["ActDelivery_Acc"], dr["DeliveryBal"]); index++; } } }
private void button9_Click(object sender, EventArgs e) { if (tbPartCode.TextLength == 0) { MessageBox.Show("Must select parts first."); } else { dbsched = new BusDeliverySchedule(); if (dbsched.GetDeliveryScheduleByThisYearDT(tbPartCode.Text).Rows.Count > 0) { MessageBox.Show("All dates for this year have already been generated."); } else { DialogResult _result = MessageBox.Show("This function will generate dates for the whole year. Do you want to proceed?", "Message" , MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (_result == DialogResult.Yes) { if (tbPartCode.TextLength == 0) { MessageBox.Show("Must select parts first."); } else { GenerateDates(); } } } } }
private Boolean GenerateSchedule() { string minyear = string.Empty; dbsched = new BusDeliverySchedule(); foreach (DataRow dr in dbsched.SOMS_DeliveryMonitoring_GetMinimumYearDT(tbPartCode.Text).Rows) { minyear = dr["MinYear"].ToString().TrimEnd(); } _sched = new BusDeliverySchedule(); _sched.PartID = tbPartCode.Text; _sched.CusID = Convert.ToInt32(cboCustomer.SelectedValue.ToString()); _sched.DateYear = Convert.ToInt32(minyear); _sched.SOMS_CreateSchedule(); BusDeliverySchedule refreshSched = new BusDeliverySchedule(); refreshSched.PartID = tbPartCode.Text; refreshSched.SOMS_RefreshedDeliverySchedule(); return(true); }
private Boolean GenerateDeliverySchedule() { dbsched = new BusDeliverySchedule(); if (dbsched.GetDeliveryScheduleByMonthandYearDT(tbPartCode.Text, Convert.ToInt32(cboDeliverySchedMonth.SelectedValue.ToString()) , Convert.ToInt32(cboDeliverySchedYear.SelectedItem.ToString())).Rows.Count == 0) { MessageBox.Show("All dates from this year has not been created. Dates must be created first."); return(false); } else { Boolean _validate = false; _validate = _ValidateDeliverySched(); if (!_validate) { return(false); } _sched = new BusDeliverySchedule(); _sched.PartID = tbPartCode.Text; //_sched.DeliveryDate = Convert.ToDateTime(tbDateRequired.Text); _sched.DateMonth = Convert.ToInt32(cboDeliverySchedMonth.SelectedValue.ToString()); _sched.DateYear = Convert.ToInt32(cboDeliverySchedYear.SelectedItem.ToString()); _sched.RefreshedDeliverySchedule(); foreach (DataRow dr in dbsched.GetDeliveryScheduleByMonthandYearDT(tbPartCode.Text , Convert.ToInt32(cboDeliverySchedMonth.SelectedValue.ToString()) , Convert.ToInt32(cboDeliverySchedYear.SelectedItem.ToString()) ).Rows) { _sched = new BusDeliverySchedule(); _sched.PartID = tbPartCode.Text; _sched.DeliveryDate = Convert.ToDateTime(dr["DeliveryDate"].ToString()); _sched.UpdateDeliveryData(); } //GetDeliveryScheduleByYear(); GetDeliveryScheduleByMonthandYear(); return(true); } }
private void GenerateMonth() { dbsched = new BusDeliverySchedule(); cboDeliverySchedMonth.DisplayMember = "Month_Name"; cboDeliverySchedMonth.ValueMember = "Month_Number"; cboDeliverySchedMonth.DataSource = dbsched.GenerateMonthDT(); }
private void GenerateDates() { _sched = new BusDeliverySchedule(); _sched.PartID = tbPartCode.Text; _sched.CreateDeliverySchedule(); MessageBox.Show("Dates has been generated"); }
private Boolean UpdateDeliveredQty() { dbsched = new BusDeliverySchedule(); foreach (DataRow dr in dbsched.SOMS_DeliveryMonitoring_GetTotalDeliveredDT(tbPartCode.Text).Rows) { _sched = new BusDeliverySchedule(); _sched.PartID = tbPartCode.Text; _sched.DeliveryDate = Convert.ToDateTime(dr["LastUpdate"]); _sched.ActDelivery_Qty = Convert.ToInt32(dr["TotalDelivered"].ToString()); _sched.SOMS_UpdateDeliverySchedule(); } return(true); }
private Boolean UpdateQtyRequired() { dbsched = new BusDeliverySchedule(); foreach (DataRow dr in dbsched.SOMS_DeliveryMonitoring_GetQtyRequiredDT(tbPartCode.Text).Rows) { _sched = new BusDeliverySchedule(); _sched.PartID = tbPartCode.Text; _sched.DeliveryDate = Convert.ToDateTime(dr["Delivery_Date_Planned"]); _sched.DeliverySched_Qty = Convert.ToInt32(dr["Qty_Reqd"].ToString()); _sched.SOMS_UpdateQtyRequired(); } //MessageBox.Show(dbsched.SOMS_DeliveryMonitoring_GetQtyRequiredDT(tbPartCode.Text).Rows.Count); return(true); }
private void GetDeliveryScheduleByThisYear() { dbsched = new BusDeliverySchedule(); int index = 0; dgvDeliverySchedule.Rows.Clear(); if (dbsched.GetDeliveryScheduleByThisYearDT(tbPartCode.Text).Rows.Count == 0) { MessageBox.Show("No Records Found"); } else { foreach (DataRow dr in dbsched.GetDeliveryScheduleByThisYearDT(tbPartCode.Text).Rows) { dgvDeliverySchedule.Rows.Insert(index, dr["schedid"], dr["DeliveryDate"], dr["NameOfDay"], dr["DeliverySched_Qty"], dr["DeliverySched_Acc"] , dr["ActDelivery_Qty"], dr["ActDelivery_Acc"], dr["DeliveryBal"]); index++; } } }