private DataTable getProcessedOrderforms()
{
DataTable dt = new DataTable();
dataGridView1.DataSource = T_OrderFormHeadDL.SelectAllt_OrderFormHeadApproval();
return(dt);
}
private void LoadData()
{
if (dataGridView1.SelectedRows.Count > 0)
{
codex = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
cat = new T_OrderFormHead();
cat.DocNo = codex.Trim();
T_OrderFormHeadDL dl = new T_OrderFormHeadDL();
cat = dl.Selectt_OrderFormHead(cat);
txt_DocNo.Text = cat.DocNo;
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_Remarks.Text = cat.Remarks;
//dte_date.Value = cat.Datex.Value;
//dte_RecivedDate.Value = cat.RecivedDate.Value;
txt_NetTotal.Text = cat.NetTotal.ToString();
txt_Subtotal.Text = cat.Subtotal.ToString();
txt_subtotdiscper.Text = cat.DiscountPer.ToString();
txt_TotalDisc.Text = cat.TotalDisc.ToString();
txt_subtotdisc.Text = cat.SubtotalDisc.ToString();
M_Customers cusx = new M_Customers();
cusx.CusID = cat.Customer.Trim();
cusx = new M_CustomerDL().Selectm_Customer(cusx);
txt_os.Text = cusx.customerOS.ToString();
txt_creditlimit.Text = cusx.CreditLimit.ToString();
lbl_creditPeriod.Text = cusx.CreditPeriod.ToString();
dataGridView2.DataSource = T_OrderFormHeadDL.GetCreditNoteItems(cat.Customer.Trim());
dataGridView2.Columns[0].Width = 120;
dataGridView2.Columns[1].Width = 120;
dataGridView2.Columns[2].Width = 120;
dataGridView2.Columns[3].Width = 120;
dataGridView2.Refresh();
dataGridView3.DataSource = T_OrderFormHeadDL.GetInvoiceDetails(cat.Customer.Trim());
dataGridView3.Columns[0].Width = 120;
dataGridView3.Columns[1].Width = 120;
dataGridView3.Columns[2].Width = 120;
dataGridView3.Columns[3].Width = 120;
dataGridView3.Refresh();
}
}
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);
}
}
