private void LoadData()
{
try
{
if (dataGridView1.SelectedRows.Count > 0)
{
getDetails(dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
codex = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
T_DIliveryHed cat = new T_DIliveryHed();
cat.DoNo = codex.Trim();
cat.LocaCode = commonFunctions.GlobalLocation;
cat = new T_DIliveryHedDL().Selectt_DIliveryHed(cat, 2);
GridPass();
txt_DocNo.Text = cat.DoNo;
txt_Locacode.Text = cat.LocaCode.Trim();
txt_locationId_name.Text = findExisting.FindExisitingLoca(txt_Locacode.Text);
txt_Customer.Text = cat.Customer.Trim();
txt_Customer_name.Text = findExisting.FindExisitingCUstomer(txt_Customer.Text);
txt_Lorry.Text = cat.Lorry.Trim();
txt_Lorry_name.Text = findExisting.FindExisitingVehicle(txt_Lorry.Text);
txt_Agent.Text = cat.Agent.Trim();
txt_Agent_name.Text = findExisting.FindExisitingAgent(txt_Agent.Text);
txt_InvNo.Text = cat.InvNo.ToString();
txt_InvoiceAmount.Text = cat.InvoiceAmount.ToString();
txt_Remarks.Text = cat.Remarks;
}
}
catch (Exception ex)
{
LogFile.WriteErrorLog(MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
}
}
private void btn_hanoverdo_Click(object sender, EventArgs e)
{
//lbl_message.Text = "";
errorProvider1.Clear();
if (head.Handedover == 1)
{
errorProvider1.SetError(btn_hanoverdo, "This delivery order already handovered.".ToUpper());
commonFunctions.SetMDIStatusMessage("This delivery order already handovered.", 1);
return;
}
if (head.Dispatched == 0)
{
errorProvider1.SetError(btn_hanoverdo, "This delivery order is not dispatched.".ToUpper());
commonFunctions.SetMDIStatusMessage("This delivery order is not dispatched.", 1);
return;
}
//if (!M_VehicleDL.ExistingM_Vehicle(txt_Lorry.Text.Trim()))
//{
// errorProvider1.SetError(txt_Lorry, "Vehicle details does not exists on the system ");
// commonFunctions.SetMDIStatusMessage("Vehicle details does not exists on the system ", 1);
// return;
//}
if (!M_AgentDL.ExistingM_Agent(txt_Agent.Text.Trim()))
{
errorProvider1.SetError(txt_Agent, "Agent does not exists on the system ");
commonFunctions.SetMDIStatusMessage("Agent does not exists on the system ", 1);
return;
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Process, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
T_DIliveryHedDL dl = new T_DIliveryHedDL();
cat = new T_DIliveryHed();
cat.DoNo = head.DONo.Trim();
cat.LocaCode = commonFunctions.GlobalLocation;
cat = new T_DIliveryHedDL().Selectt_DIliveryHed(cat, 1);
cat.Handovered = 1;
cat.HandoverDate = DateTime.Now;
cat.HandoverdUser = commonFunctions.Loginuser;
head.HandOverLorry = txt_Lorry.Text.Trim();
head.Handedover = 1;
head.HandedoverDate = DateTime.Now;
head.HandedoverUser = commonFunctions.Loginuser;
if (dl.Savet_DIliveryHedSP(cat, 3) && new T_OrderTrackingDL().Savet_OrderTrackingSP(head, 3))
{
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Save_Sucess_string, 2);
}
getProcessedOFs();
}
}
private void btn_edit_Click(object sender, EventArgs e)
{
try
{
if (codex.Trim() != "")
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Approve, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
T_DIliveryHed objt_trnsferNote = new T_DIliveryHed();
objt_trnsferNote.DoNo = txt_DocNo.Text.Trim();
objt_trnsferNote.LocaCode = commonFunctions.GlobalLocation;
objt_trnsferNote = new T_DIliveryHedDL().Selectt_DIliveryHed(objt_trnsferNote, 2);
objt_trnsferNote.Approved = 1;
objt_trnsferNote.ApprovedDate = DateTime.Now;
objt_trnsferNote.ApprovedUser = commonFunctions.Loginuser;
new T_DIliveryHedDL().Savet_DIliveryHedSP(objt_trnsferNote, 3);
T_OrderTracking track = new T_OrderTracking();
track.DONo = txt_DocNo.Text.Trim();
//track.OFNo = txt_DocNo.Text.Trim();
track = new T_OrderTrackingDL().Selectt_OrderTracking(track, xEnums.OrderTrackingTypes.DoNumber);
track.DOApproved = 1;
track.DOApprovedUser = commonFunctions.Loginuser;
track.DOApprovedDate = DateTime.Now;
new T_OrderTrackingDL().Savet_OrderTrackingSP(track, 3);
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Update_Sucess_string, 2);
getProcessedDOs();
}
}
else
{
errorProvider1.SetError(dataGridView1, "Pelase select a delivery order from the list");
commonFunctions.SetMDIStatusMessage("Pelase select a delivery order from the list", 1);
}
}
catch (Exception ex)
{
LogFile.WriteErrorLog(MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
commonFunctions.SetMDIStatusMessage("Genaral Error when approving the delivery order", 1);
}
}
private void btn_inscomplete_Click(object sender, EventArgs e)
{
errorProvider1.Clear();
try
{
//lbl_message.Text = "";
if (head.DOCreated == 1)
{
if (cat.Processed == 1)
{
errorProvider1.SetError(btn_process, "This delivery order already processed.".ToUpper());
commonFunctions.SetMDIStatusMessage("This delivery order already processed.", 2);
return;
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Process, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
T_DIliveryHedDL dl = new T_DIliveryHedDL();
cat.Processed = 1;
cat.ProcessedDate = DateTime.Now;
cat.ProcessedUser = commonFunctions.Loginuser;
head.DOProcessed = 1;
head.DOProcessedDate = DateTime.Now;
head.DOProcessedUser = commonFunctions.Loginuser;
if (dl.Savet_DIliveryHedSP(cat, 3) && new T_OrderTrackingDL().Savet_OrderTrackingSP(head, 3))
{
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Save_Sucess_string, 2);
}
}
}
else
{
commonFunctions.SetMDIStatusMessage("Delivery Order not created for this order", 1);
}
}
catch (Exception ex)
{
LogFile.WriteErrorLog(System.Reflection.MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
commonFunctions.SetMDIStatusMessage("Genaral Error", 2);
}
}
private void btn_confirmdelivery_Click(object sender, EventArgs e)
{
errorProvider1.Clear();
if (cat.Completed == 1)
{
errorProvider1.SetError(btn_hanoverdo, "This delivery order already confirmed.".ToUpper());
commonFunctions.SetMDIStatusMessage("This delivery order already confirmed.", 1);
return;
}
if (cat.Handovered == 0)
{
errorProvider1.SetError(btn_hanoverdo, "This delivery order is not handovered.".ToUpper());
commonFunctions.SetMDIStatusMessage("This delivery order is not handovered.", 1);
return;
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Process, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
T_DIliveryHedDL dl = new T_DIliveryHedDL();
cat.Completed = 1;
cat.CompletedDate = DateTime.Now;
head.Completed = 1;
head.CompletedDate = DateTime.Now;
head.CompletedUser = commonFunctions.Loginuser;
head.CompleteRemark = txt_cremarks.Text.Trim();
if (dl.Savet_DIliveryHedSP(cat, 3) && new T_OrderTrackingDL().Savet_OrderTrackingSP(head, 3))
{
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Save_Sucess_string, 2);
getProcessedOFs();
}
}
}
private void btn_edit_Click(object sender, EventArgs e)
{
errorProvider1.Clear();
try
{
if (txt_aremarks.Text.Trim() == "")
{
errorProvider1.SetError(txt_aremarks, "Audit remarks cannot be empty.");
commonFunctions.SetMDIStatusMessage("Audit remarks cannot be empty.", 1);
return;
}
if (codex.Trim() == "")
{
errorProvider1.SetError(dataGridView1, "Pelase select a delivery order from the list");
commonFunctions.SetMDIStatusMessage("Pelase select a delivery order from the list", 1);
return;
}
if (!GridPass())
{
errorProvider1.SetError(dataGridView2, "There is a variance in DO QTY and actual QTY");
commonFunctions.SetMDIStatusMessage("There is a variance in DO QTY and actual QTY", 1);
return;
}
if (!CartonChecking())
{
errorProvider1.SetError(dataGridView2, "Invalied Carton details");
commonFunctions.SetMDIStatusMessage("Invalied Carton details", 1);
return;
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Approve, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
T_DIliveryHed objt_trnsferNote = new T_DIliveryHed();
objt_trnsferNote.DoNo = txt_DocNo.Text.Trim();
objt_trnsferNote.LocaCode = commonFunctions.GlobalLocation;
objt_trnsferNote = new T_DIliveryHedDL().Selectt_DIliveryHed(objt_trnsferNote, 2);
objt_trnsferNote.AuditRemarks = txt_aremarks.Text.Trim();
objt_trnsferNote.ReportedProblems = txt_repproblems.Text.Trim();
objt_trnsferNote.Audited = 1;
objt_trnsferNote.AuditDate = DateTime.Now;
objt_trnsferNote.AuditUser = commonFunctions.Loginuser;
new T_DIliveryHedDL().Savet_DIliveryHedSP(objt_trnsferNote, 3);
T_OrderTracking track = new T_OrderTracking();
track.DONo = txt_DocNo.Text.Trim();
track = new T_OrderTrackingDL().Selectt_OrderTracking(track, xEnums.OrderTrackingTypes.DoNumber);
track.Audited = 1;
track.AuditUser = commonFunctions.Loginuser;
track.AuditDate = DateTime.Now;
new T_OrderTrackingDL().Savet_OrderTrackingSP(track, 3);
foreach (DataGridViewRow drow in dataGridView2.Rows)
{
if (drow.Cells[0].Value.ToString().Trim() != null)
{
T_DiliveryDet det = new T_DiliveryDet();
det.DoNo = txt_DocNo.Text.Trim();
det.Item = drow.Cells[0].Value.ToString().Trim();
det = new T_DiliveryDetDL().Selectt_DiliveryDet(det);
det.Carton = commonFunctions.ToDecimal(drow.Cells[5].Value.ToString().Trim());
det.ActualCartons = commonFunctions.ToDecimal(drow.Cells[5].Value.ToString().Trim());
det.Remarks = drow.Cells[7].Value.ToString().Trim();
det.Pass = true;
new T_DiliveryDetDL().Savet_DiliveryDetSP(det, 3);
}
}
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Update_Sucess_string, 2);
getProcessedDOs();
getDetails("");
}
}
catch (Exception ex)
{
LogFile.WriteErrorLog(MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
commonFunctions.SetMDIStatusMessage("Genaral Error when approving the delivery order", 1);
}
}
