private void btn_edit_Click(object sender, EventArgs e)
{
if (codex.Trim() != "")
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Approve, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
T_InvoiceHed objt_trnsferNote = new T_InvoiceHed();
objt_trnsferNote.InvID = txt_DocNo.Text.Trim();
T_InvoiceHedDL dl = new T_InvoiceHedDL();
objt_trnsferNote = dl.Selectt_InvoiceHed(objt_trnsferNote);
objt_trnsferNote.Approved = 1;
objt_trnsferNote.ApprovedDate = DateTime.Now;
objt_trnsferNote.AprrovedBy = commonFunctions.Loginuser;
dl.Savet_InvoiceHedSP(objt_trnsferNote, 3);
T_OrderTracking track = new T_OrderTracking();
track.OFNo = objt_trnsferNote.OrderFormNo.Trim();
track = new T_OrderTrackingDL().Selectt_OrderTracking(track, xEnums.OrderTrackingTypes.OrderNo);
track.InvApproved = 1;
track.InvApprovedDate = DateTime.Now;
track.InvApprovedUser = commonFunctions.Loginuser;
new T_OrderTrackingDL().Savet_OrderTrackingSP(track, 3);
getProcessedInvoices();
UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Update_Sucess, commonFunctions.Softwarename.Trim());
}
}
else
{
errorProvider1.SetError(dataGridView1, "Pelase select a order form from the list");
}
}
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_edit_Click(object sender, EventArgs e)
{
if (codex.Trim() != "")
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Approve, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
T_OrderFormHead objt_trnsferNote = new T_OrderFormHead();
objt_trnsferNote.DocNo = txt_DocNo.Text.Trim();
objt_trnsferNote = new T_OrderFormHeadDL().Selectt_OrderFormHead(objt_trnsferNote);
objt_trnsferNote.DiscountPer = commonFunctions.ToDecimal(txt_subtotdiscper.Text.Trim());
objt_trnsferNote.TotalDisc = commonFunctions.ToDecimal(txt_TotalDisc.Text.Trim());
objt_trnsferNote.NetTotal = commonFunctions.ToDecimal(txt_NetTotal.Text.Trim());
objt_trnsferNote.Approved = 1;
objt_trnsferNote.ApprovedDate = DateTime.Now;
objt_trnsferNote.ApprovedBy = commonFunctions.Loginuser;
objt_trnsferNote.Remarks = txt_Remarks.Text.Trim();
new T_OrderFormHeadDL().Savet_OrderFormHeadSP(objt_trnsferNote, 3);
T_OrderTracking track = new T_OrderTracking();
track.OFNo = objt_trnsferNote.DocNo.Trim();
track = new T_OrderTrackingDL().Selectt_OrderTracking(track, xEnums.OrderTrackingTypes.OrderNo);
track.OFApproved = 1;
track.OFApprovedUser = commonFunctions.Loginuser;
track.OFApprovedDate = DateTime.Now;
new T_OrderTrackingDL().Savet_OrderTrackingSP(track, 3);
getProcessedOrderforms();
UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Update_Sucess, commonFunctions.Softwarename.Trim());
}
}
else
{
errorProvider1.SetError(dataGridView1, "Pelase select a order form from the list");
commonFunctions.SetMDIStatusMessage("Pelase select a order form from the list", 1);
}
}
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);
}
}
/// <summary>
/// Saves a record to the T_OrderTracking table.
/// </summary>
public Boolean Savet_OrderTrackingSP(T_OrderTracking t_OrderTracking, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_OrderTrackingSave";
scom.Parameters.Add("@OFNo", SqlDbType.VarChar, 20).Value = t_OrderTracking.OFNo;
scom.Parameters.Add("@CompCode", SqlDbType.VarChar, 20).Value = t_OrderTracking.CompCode;
scom.Parameters.Add("@LocaCode", SqlDbType.VarChar, 20).Value = t_OrderTracking.LocaCode;
scom.Parameters.Add("@Customer", SqlDbType.VarChar, 20).Value = t_OrderTracking.Customer;
scom.Parameters.Add("@CustomerDIscRate", SqlDbType.Decimal, 9).Value = t_OrderTracking.CustomerDIscRate;
scom.Parameters.Add("@SalesMan", SqlDbType.VarChar, 20).Value = t_OrderTracking.SalesMan;
scom.Parameters.Add("@OFApproved", SqlDbType.Int, 4).Value = t_OrderTracking.OFApproved;
scom.Parameters.Add("@OFApprovedUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.OFApprovedUser;
scom.Parameters.Add("@OFApprovedDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.OFApprovedDate;
scom.Parameters.Add("@OFNoOfPrints", SqlDbType.Decimal, 9).Value = t_OrderTracking.OFNoOfPrints;
scom.Parameters.Add("@OFPrintUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.OFPrintUser;
scom.Parameters.Add("@InvCreated", SqlDbType.Int, 4).Value = t_OrderTracking.InvCreated;
scom.Parameters.Add("@InvNo", SqlDbType.VarChar, 20).Value = t_OrderTracking.InvNo;
scom.Parameters.Add("@InvAmount", SqlDbType.Decimal, 9).Value = t_OrderTracking.InvAmount;
scom.Parameters.Add("@InvApproved", SqlDbType.Int, 4).Value = t_OrderTracking.InvApproved;
scom.Parameters.Add("@InvApprovedUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.InvApprovedUser;
scom.Parameters.Add("@InvApprovedDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.InvApprovedDate;
scom.Parameters.Add("@InvNoOfPrints", SqlDbType.Decimal, 9).Value = t_OrderTracking.InvNoOfPrints;
scom.Parameters.Add("@InvPrintUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.InvPrintUser;
scom.Parameters.Add("@DOCreated", SqlDbType.Int, 4).Value = t_OrderTracking.DOCreated;
scom.Parameters.Add("@DONo", SqlDbType.VarChar, 20).Value = t_OrderTracking.DONo;
scom.Parameters.Add("@DOAmount", SqlDbType.Decimal, 9).Value = t_OrderTracking.DOAmount;
scom.Parameters.Add("@DOMultipleNO", SqlDbType.VarChar, 20).Value = t_OrderTracking.DOMultipleNO;
scom.Parameters.Add("@DOProcessed", SqlDbType.Int, 4).Value = t_OrderTracking.DOProcessed;
scom.Parameters.Add("@DOProcessedUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.DOProcessedUser;
scom.Parameters.Add("@DOProcessedDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.DOProcessedDate;
scom.Parameters.Add("@DOApproved", SqlDbType.Int, 4).Value = t_OrderTracking.DOApproved;
scom.Parameters.Add("@DOApprovedUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.DOApprovedUser;
scom.Parameters.Add("@DOApprovedDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.DOApprovedDate;
scom.Parameters.Add("@DONoOfPrints", SqlDbType.Decimal, 9).Value = t_OrderTracking.DONoOfPrints;
scom.Parameters.Add("@DOvPrintUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.DOvPrintUser;
scom.Parameters.Add("@Audited", SqlDbType.Int, 4).Value = t_OrderTracking.Audited;
scom.Parameters.Add("@AuditDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.AuditDate;
scom.Parameters.Add("@AuditUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.AuditUser;
scom.Parameters.Add("@Dispatched", SqlDbType.Int, 4).Value = t_OrderTracking.Dispatched;
scom.Parameters.Add("@DispatchedDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.DispatchedDate;
scom.Parameters.Add("@DispatchedUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.DispatchedUser;
scom.Parameters.Add("@Handedover", SqlDbType.Int, 4).Value = t_OrderTracking.Handedover;
scom.Parameters.Add("@HandedoverUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.HandedoverUser;
scom.Parameters.Add("@HandedoverDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.HandedoverDate;
scom.Parameters.Add("@Completed", SqlDbType.Int, 4).Value = t_OrderTracking.Completed;
scom.Parameters.Add("@CompletedUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.CompletedUser;
scom.Parameters.Add("@CompletedDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.CompletedDate;
scom.Parameters.Add("@PackingListCreated", SqlDbType.Int, 4).Value = t_OrderTracking.PackingListCreated;
scom.Parameters.Add("@PackingListNo", SqlDbType.VarChar, 20).Value = t_OrderTracking.PackingListNo;
scom.Parameters.Add("@PackingListDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.PackingListDate;
scom.Parameters.Add("@PackingListUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.PackingListUser;
scom.Parameters.Add("@Remarks", SqlDbType.VarChar, 250).Value = t_OrderTracking.Remarks;
scom.Parameters.Add("@HandOverLorry", SqlDbType.VarChar, 20).Value = t_OrderTracking.HandOverLorry;
scom.Parameters.Add("@CompleteRemark", SqlDbType.VarChar, 250).Value = t_OrderTracking.CompleteRemark;
scom.Parameters.Add("@OrderDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.OrderDate;
scom.Parameters.Add("@InvoiceDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.InvoiceDate;
scom.Parameters.Add("@Dodate", SqlDbType.DateTime, 8).Value = t_OrderTracking.Dodate;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
public List <T_OrderTracking> SelectT_OrderTrackingMulti(T_OrderTracking objt_OrderTracking2)
{
List <T_OrderTracking> retval = new List <T_OrderTracking>();
try
{
strquery = @"select * from t_OrderTracking where OFNo = '" + objt_OrderTracking2.OFNo + "'";
DataTable dtt_OrderTracking = u_DBConnection.ReturnDataTable(strquery, CommandType.Text);
foreach (DataRow drType in dtt_OrderTracking.Rows)
{
if (drType != null)
{
T_OrderTracking objt_OrderTracking = new T_OrderTracking();
objt_OrderTracking.OFNo = drType["OFNo"].ToString();
objt_OrderTracking.CompCode = drType["CompCode"].ToString();
objt_OrderTracking.LocaCode = drType["LocaCode"].ToString();
objt_OrderTracking.Customer = drType["Customer"].ToString();
objt_OrderTracking.CustomerDIscRate = decimal.Parse(drType["CustomerDIscRate"].ToString());
objt_OrderTracking.SalesMan = drType["SalesMan"].ToString();
objt_OrderTracking.OFApproved = int.Parse(drType["OFApproved"].ToString());
objt_OrderTracking.OFApprovedUser = drType["OFApprovedUser"].ToString();
objt_OrderTracking.OFApprovedDate = DateTime.Parse(drType["OFApprovedDate"].ToString());
objt_OrderTracking.OFNoOfPrints = decimal.Parse(drType["OFNoOfPrints"].ToString());
objt_OrderTracking.OFPrintUser = drType["OFPrintUser"].ToString();
objt_OrderTracking.InvCreated = int.Parse(drType["InvCreated"].ToString());
objt_OrderTracking.InvNo = drType["InvNo"].ToString();
objt_OrderTracking.InvAmount = decimal.Parse(drType["InvAmount"].ToString());
objt_OrderTracking.InvApproved = int.Parse(drType["InvApproved"].ToString());
objt_OrderTracking.InvApprovedUser = drType["InvApprovedUser"].ToString();
objt_OrderTracking.InvApprovedDate = DateTime.Parse(drType["InvApprovedDate"].ToString());
objt_OrderTracking.InvNoOfPrints = decimal.Parse(drType["InvNoOfPrints"].ToString());
objt_OrderTracking.InvPrintUser = drType["InvPrintUser"].ToString();
objt_OrderTracking.DOCreated = int.Parse(drType["DOCreated"].ToString());
objt_OrderTracking.DONo = drType["DONo"].ToString();
objt_OrderTracking.DOAmount = decimal.Parse(drType["DOAmount"].ToString());
objt_OrderTracking.DOMultipleNO = drType["DOMultipleNO"].ToString();
objt_OrderTracking.DOProcessed = int.Parse(drType["DOProcessed"].ToString());
objt_OrderTracking.DOProcessedUser = drType["DOProcessedUser"].ToString();
objt_OrderTracking.DOProcessedDate = DateTime.Parse(drType["DOProcessedDate"].ToString());
objt_OrderTracking.DOApproved = int.Parse(drType["DOApproved"].ToString());
objt_OrderTracking.DOApprovedUser = drType["DOApprovedUser"].ToString();
objt_OrderTracking.DOApprovedDate = DateTime.Parse(drType["DOApprovedDate"].ToString());
objt_OrderTracking.DONoOfPrints = decimal.Parse(drType["DONoOfPrints"].ToString());
objt_OrderTracking.DOvPrintUser = drType["DOvPrintUser"].ToString();
objt_OrderTracking.Audited = int.Parse(drType["Audited"].ToString());
objt_OrderTracking.AuditDate = DateTime.Parse(drType["AuditDate"].ToString());
objt_OrderTracking.AuditUser = drType["AuditUser"].ToString();
objt_OrderTracking.Dispatched = int.Parse(drType["Dispatched"].ToString());
objt_OrderTracking.DispatchedDate = DateTime.Parse(drType["DispatchedDate"].ToString());
objt_OrderTracking.DispatchedUser = drType["DispatchedUser"].ToString();
objt_OrderTracking.Handedover = int.Parse(drType["Handedover"].ToString());
objt_OrderTracking.HandedoverUser = drType["HandedoverUser"].ToString();
objt_OrderTracking.HandedoverDate = DateTime.Parse(drType["HandedoverDate"].ToString());
objt_OrderTracking.Completed = int.Parse(drType["Completed"].ToString());
objt_OrderTracking.CompletedUser = drType["CompletedUser"].ToString();
objt_OrderTracking.CompletedDate = DateTime.Parse(drType["CompletedDate"].ToString());
objt_OrderTracking.PackingListCreated = int.Parse(drType["PackingListCreated"].ToString());
objt_OrderTracking.PackingListNo = drType["PackingListNo"].ToString();
objt_OrderTracking.PackingListDate = DateTime.Parse(drType["PackingListDate"].ToString());
objt_OrderTracking.PackingListUser = drType["PackingListUser"].ToString();
objt_OrderTracking.Remarks = drType["Remarks"].ToString();
objt_OrderTracking.HandOverLorry = drType["HandOverLorry"].ToString();
objt_OrderTracking.CompleteRemark = drType["CompleteRemark"].ToString();
objt_OrderTracking.OrderDate = DateTime.Parse(drType["OrderDate"].ToString());
objt_OrderTracking.InvoiceDate = DateTime.Parse(drType["InvoiceDate"].ToString());
objt_OrderTracking.Dodate = DateTime.Parse(drType["Dodate"].ToString());
retval.Add(objt_OrderTracking);
}
}
return(retval);
}
catch (Exception ex)
{
throw ex;
}
}
public T_OrderTracking Selectt_OrderTracking(T_OrderTracking objt_OrderTracking, SmartAnything.xEnums.OrderTrackingTypes typex)
{
try
{
switch (typex)
{
case xEnums.OrderTrackingTypes.DoNumber:
strquery = @"select * from T_OrderTracking where DONo = '" + objt_OrderTracking.DONo + "'";
break;
case xEnums.OrderTrackingTypes.InvoiceNO:
strquery = @"select * from T_OrderTracking where InvNo = '" + objt_OrderTracking.InvNo + "'";
break;
case xEnums.OrderTrackingTypes.OrderNo:
strquery = @"select * from T_OrderTracking where OFNo = '" + objt_OrderTracking.OFNo + "'";
break;
case xEnums.OrderTrackingTypes.PackingList:
strquery = @"select * from T_OrderTracking where PackingListNo = '" + objt_OrderTracking.PackingListNo + "'";
break;
}
DataRow drType = u_DBConnection.ReturnDataRow(strquery);
if (drType != null)
{
objt_OrderTracking.OFNo = drType["OFNo"].ToString();
objt_OrderTracking.CompCode = drType["CompCode"].ToString();
objt_OrderTracking.LocaCode = drType["LocaCode"].ToString();
objt_OrderTracking.Customer = drType["Customer"].ToString();
objt_OrderTracking.CustomerDIscRate = decimal.Parse(drType["CustomerDIscRate"].ToString());
objt_OrderTracking.SalesMan = drType["SalesMan"].ToString();
objt_OrderTracking.OFApproved = int.Parse(drType["OFApproved"].ToString());
objt_OrderTracking.OFApprovedUser = drType["OFApprovedUser"].ToString();
objt_OrderTracking.OFApprovedDate = DateTime.Parse(drType["OFApprovedDate"].ToString());
objt_OrderTracking.OFNoOfPrints = decimal.Parse(drType["OFNoOfPrints"].ToString());
objt_OrderTracking.OFPrintUser = drType["OFPrintUser"].ToString();
objt_OrderTracking.InvCreated = int.Parse(drType["InvCreated"].ToString());
objt_OrderTracking.InvNo = drType["InvNo"].ToString();
objt_OrderTracking.InvAmount = decimal.Parse(drType["InvAmount"].ToString());
objt_OrderTracking.InvApproved = int.Parse(drType["InvApproved"].ToString());
objt_OrderTracking.InvApprovedUser = drType["InvApprovedUser"].ToString();
objt_OrderTracking.InvApprovedDate = DateTime.Parse(drType["InvApprovedDate"].ToString());
objt_OrderTracking.InvNoOfPrints = decimal.Parse(drType["InvNoOfPrints"].ToString());
objt_OrderTracking.InvPrintUser = drType["InvPrintUser"].ToString();
objt_OrderTracking.DOCreated = int.Parse(drType["DOCreated"].ToString());
objt_OrderTracking.DONo = drType["DONo"].ToString();
objt_OrderTracking.DOAmount = decimal.Parse(drType["DOAmount"].ToString());
objt_OrderTracking.DOMultipleNO = drType["DOMultipleNO"].ToString();
objt_OrderTracking.DOProcessed = int.Parse(drType["DOProcessed"].ToString());
objt_OrderTracking.DOProcessedUser = drType["DOProcessedUser"].ToString();
objt_OrderTracking.DOProcessedDate = DateTime.Parse(drType["DOProcessedDate"].ToString());
objt_OrderTracking.DOApproved = int.Parse(drType["DOApproved"].ToString());
objt_OrderTracking.DOApprovedUser = drType["DOApprovedUser"].ToString();
objt_OrderTracking.DOApprovedDate = DateTime.Parse(drType["DOApprovedDate"].ToString());
objt_OrderTracking.DONoOfPrints = decimal.Parse(drType["DONoOfPrints"].ToString());
objt_OrderTracking.DOvPrintUser = drType["DOvPrintUser"].ToString();
objt_OrderTracking.Audited = int.Parse(drType["Audited"].ToString());
objt_OrderTracking.AuditDate = DateTime.Parse(drType["AuditDate"].ToString());
objt_OrderTracking.AuditUser = drType["AuditUser"].ToString();
objt_OrderTracking.Dispatched = int.Parse(drType["Dispatched"].ToString());
objt_OrderTracking.DispatchedDate = DateTime.Parse(drType["DispatchedDate"].ToString());
objt_OrderTracking.DispatchedUser = drType["DispatchedUser"].ToString();
objt_OrderTracking.Handedover = int.Parse(drType["Handedover"].ToString());
objt_OrderTracking.HandedoverUser = drType["HandedoverUser"].ToString();
objt_OrderTracking.HandedoverDate = DateTime.Parse(drType["HandedoverDate"].ToString());
objt_OrderTracking.Completed = int.Parse(drType["Completed"].ToString());
objt_OrderTracking.CompletedUser = drType["CompletedUser"].ToString();
objt_OrderTracking.CompletedDate = DateTime.Parse(drType["CompletedDate"].ToString());
objt_OrderTracking.PackingListCreated = int.Parse(drType["PackingListCreated"].ToString());
objt_OrderTracking.PackingListNo = drType["PackingListNo"].ToString();
objt_OrderTracking.PackingListDate = DateTime.Parse(drType["PackingListDate"].ToString());
objt_OrderTracking.PackingListUser = drType["PackingListUser"].ToString();
objt_OrderTracking.Remarks = drType["Remarks"].ToString();
objt_OrderTracking.HandOverLorry = drType["HandOverLorry"].ToString();
objt_OrderTracking.CompleteRemark = drType["CompleteRemark"].ToString();
objt_OrderTracking.OrderDate = DateTime.Parse(drType["OrderDate"].ToString());
objt_OrderTracking.InvoiceDate = DateTime.Parse(drType["InvoiceDate"].ToString());
objt_OrderTracking.Dodate = DateTime.Parse(drType["Dodate"].ToString());
return(objt_OrderTracking);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
private void dataGridView2_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dataGridView2.SelectedRows.Count > 0)
{
codex = dataGridView2.SelectedRows[0].Cells[0].Value.ToString();
head.OFNo = codex;
head = new T_OrderTrackingDL().Selectt_OrderTracking(head, xEnums.OrderTrackingTypes.OrderNo);
if (head.DONo.Trim() != "")
{
cat = new T_DIliveryHed();
cat.LocaCode = commonFunctions.GlobalLocation;
cat.DoNo = head.DONo.Trim();
cat = new T_DIliveryHedDL().Selectt_DIliveryHed(cat, 1);
}
//new T_DIliveryHedDL().Selectt_DIliveryHed(
if (head.OFApproved == 1)
{
colorswitchx(true, 0);
}
else
{
colorswitchx(false, 0);
}
if (head.InvCreated == 1)
{
colorswitchx(true, 1);
}
else
{
colorswitchx(false, 1);
}
if (head.InvApproved == 1)
{
colorswitchx(true, 2);
}
else
{
colorswitchx(false, 2);
}
if (head.DOCreated == 1)
{
colorswitchx(true, 3);
}
else
{
colorswitchx(false, 3);
}
if (head.DOApproved == 1)
{
colorswitchx(true, 4);
}
else
{
colorswitchx(false, 4);
}
if (head.Audited == 1)
{
colorswitchx(true, 5);
}
else
{
colorswitchx(false, 5);
}
if (head.PackingListCreated == 1)
{
colorswitchx(true, 6);
}
else
{
colorswitchx(false, 6);
}
if (head.Dispatched == 1)
{
colorswitchx(true, 7);
}
else
{
colorswitchx(false, 7);
}
if (head.Handedover == 1)
{
colorswitchx(true, 8);
}
else
{
colorswitchx(false, 8);
}
if (head.Completed == 1)
{
colorswitchx(true, 9);
}
else
{
colorswitchx(false, 9);
}
//if(head.OFApproved
}
}
catch (Exception ex) { }
}
