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++;
}
}
}
