private Boolean GenerateDeliveryScheduleByYear()
{
dbsched = new BusDeliverySchedule();
if (dbsched.GetDeliveryScheduleByYearDT(tbPartCode.Text, Convert.ToInt32(cboDSchedByYear.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.DateYear = Convert.ToInt32(cboDSchedByYear.SelectedItem.ToString());
_sched.RefreshedDeliveryScheduleByYear();
foreach (DataRow dr in dbsched.GetDeliveryScheduleByYearDT(tbPartCode.Text, Convert.ToInt32(cboDSchedByYear.SelectedItem.ToString())).Rows)
{
_sched = new BusDeliverySchedule();
_sched.PartID = tbPartCode.Text;
_sched.DeliveryDate = Convert.ToDateTime(dr["DeliveryDate"].ToString());
_sched.UpdateDeliveryData();
}
GetDeliveryScheduleByYear();
//GetDeliveryScheduleByMonthandYear();
//GetDeliveryScheduleByThisYear();
return(true);
}
}
private void GetDeliveryScheduleByYear()
{
dbsched = new BusDeliverySchedule();
int index = 0;
dgvDeliverySchedule.Rows.Clear();
if (dbsched.GetDeliveryScheduleByYearDT(tbPartCode.Text, Convert.ToInt32(cboDSchedByYear.SelectedItem.ToString())).Rows.Count == 0)
{
MessageBox.Show("No Records Found");
}
else
{
foreach (DataRow dr in dbsched.GetDeliveryScheduleByYearDT(tbPartCode.Text, Convert.ToInt32(cboDSchedByYear.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++;
}
}
}