private Boolean GenerateDeliveryScheduleThisYear()
{
dbsched = new BusDeliverySchedule();
if (dbsched.GetDeliveryScheduleByThisYearDT(tbPartCode.Text).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.RefreshedDeliveryScheduleThisYear();
foreach (DataRow dr in dbsched.GetDeliveryScheduleByThisYearDT(tbPartCode.Text).Rows)
{
_sched = new BusDeliverySchedule();
_sched.PartID = tbPartCode.Text;
_sched.DeliveryDate = Convert.ToDateTime(dr["DeliveryDate"].ToString());
_sched.UpdateDeliveryData();
}
//GetDeliveryScheduleByYear();
//GetDeliveryScheduleByMonthandYear();
GetDeliveryScheduleByThisYear();
return(true);
}
}
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 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++;
}
}
}
