public List <T_OrderFormHead> SelectT_OrderFormHeadMulti(T_OrderFormHead objt_OrderFormHead2)
{
List <T_OrderFormHead> retval = new List <T_OrderFormHead>();
try
{
strquery = @"select * from t_OrderFormHead where DocNo = '" + objt_OrderFormHead2.DocNo + "'";
DataTable dtt_OrderFormHead = u_DBConnection.ReturnDataTable(strquery, CommandType.Text);
foreach (DataRow drType in dtt_OrderFormHead.Rows)
{
if (drType != null)
{
T_OrderFormHead objt_OrderFormHead = new T_OrderFormHead();
objt_OrderFormHead.DocNo = drType["DocNo"].ToString();
objt_OrderFormHead.Compcode = drType["Compcode"].ToString();
objt_OrderFormHead.Locacode = drType["Locacode"].ToString();
objt_OrderFormHead.TRNType = drType["TRNType"].ToString();
objt_OrderFormHead.SalesMan = drType["SalesMan"].ToString();
objt_OrderFormHead.Customer = drType["Customer"].ToString();
objt_OrderFormHead.Datex = DateTime.Parse(drType["Datex"].ToString());
objt_OrderFormHead.RecivedBy = drType["RecivedBy"].ToString();
objt_OrderFormHead.CheckedBy = drType["CheckedBy"].ToString();
objt_OrderFormHead.Approved = int.Parse(drType["Approved"].ToString());
objt_OrderFormHead.ApprovedBy = drType["ApprovedBy"].ToString();
objt_OrderFormHead.ApprovedDate = DateTime.Parse(drType["ApprovedDate"].ToString());
objt_OrderFormHead.RecivedDate = DateTime.Parse(drType["RecivedDate"].ToString());
objt_OrderFormHead.Userx = drType["Userx"].ToString();
objt_OrderFormHead.CreatedDate = DateTime.Parse(drType["CreatedDate"].ToString());
objt_OrderFormHead.CQNO = drType["CQNO"].ToString();
objt_OrderFormHead.CQDate = DateTime.Parse(drType["CQDate"].ToString());
objt_OrderFormHead.BANK = drType["BANK"].ToString();
objt_OrderFormHead.BRANCH = drType["BRANCH"].ToString();
objt_OrderFormHead.Subtotal = decimal.Parse(drType["Subtotal"].ToString());
objt_OrderFormHead.DiscountPer = decimal.Parse(drType["DiscountPer"].ToString());
objt_OrderFormHead.SubtotalDisc = decimal.Parse(drType["SubtotalDisc"].ToString());
objt_OrderFormHead.ItemdiscTotal = decimal.Parse(drType["ItemdiscTotal"].ToString());
objt_OrderFormHead.TotalDisc = decimal.Parse(drType["TotalDisc"].ToString());
objt_OrderFormHead.NetTotal = decimal.Parse(drType["NetTotal"].ToString());
objt_OrderFormHead.Remarks = drType["Remarks"].ToString();
objt_OrderFormHead.Processed = int.Parse(drType["Processed"].ToString());
objt_OrderFormHead.ProcessedDate = DateTime.Parse(drType["ProcessedDate"].ToString());
objt_OrderFormHead.ProcessedUser = drType["ProcessedUser"].ToString();
objt_OrderFormHead.InvCreated = int.Parse(drType["InvCreated"].ToString());
objt_OrderFormHead.InvCreatedDate = DateTime.Parse(drType["InvCreatedDate"].ToString());
objt_OrderFormHead.INVCreatedUser = drType["INVCreatedUser"].ToString();
retval.Add(objt_OrderFormHead);
}
}
return(retval);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Saves a record to the T_OrderFormHead table.
/// </summary>
public Boolean Savet_OrderFormHeadSP(T_OrderFormHead t_OrderFormHead, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_OrderFormHeadSave";
scom.Parameters.Add("@DocNo", SqlDbType.VarChar, 20).Value = t_OrderFormHead.DocNo;
scom.Parameters.Add("@Compcode", SqlDbType.VarChar, 20).Value = t_OrderFormHead.Compcode;
scom.Parameters.Add("@Locacode", SqlDbType.VarChar, 20).Value = t_OrderFormHead.Locacode;
scom.Parameters.Add("@TRNType", SqlDbType.VarChar, 10).Value = t_OrderFormHead.TRNType;
scom.Parameters.Add("@SalesMan", SqlDbType.VarChar, 20).Value = t_OrderFormHead.SalesMan;
scom.Parameters.Add("@Customer", SqlDbType.VarChar, 20).Value = t_OrderFormHead.Customer;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = t_OrderFormHead.Datex;
scom.Parameters.Add("@RecivedBy", SqlDbType.VarChar, 20).Value = t_OrderFormHead.RecivedBy;
scom.Parameters.Add("@CheckedBy", SqlDbType.VarChar, 20).Value = t_OrderFormHead.CheckedBy;
scom.Parameters.Add("@Approved", SqlDbType.Int, 4).Value = t_OrderFormHead.Approved;
scom.Parameters.Add("@ApprovedBy", SqlDbType.VarChar, 20).Value = t_OrderFormHead.ApprovedBy;
scom.Parameters.Add("@ApprovedDate", SqlDbType.DateTime, 8).Value = t_OrderFormHead.ApprovedDate;
scom.Parameters.Add("@RecivedDate", SqlDbType.DateTime, 8).Value = t_OrderFormHead.RecivedDate;
scom.Parameters.Add("@Userx", SqlDbType.VarChar, 20).Value = t_OrderFormHead.Userx;
scom.Parameters.Add("@CreatedDate", SqlDbType.DateTime, 8).Value = t_OrderFormHead.CreatedDate;
scom.Parameters.Add("@CQNO", SqlDbType.VarChar, 20).Value = t_OrderFormHead.CQNO;
scom.Parameters.Add("@CQDate", SqlDbType.DateTime, 8).Value = t_OrderFormHead.CQDate;
scom.Parameters.Add("@BANK", SqlDbType.VarChar, 20).Value = t_OrderFormHead.BANK;
scom.Parameters.Add("@BRANCH", SqlDbType.VarChar, 20).Value = t_OrderFormHead.BRANCH;
scom.Parameters.Add("@Subtotal", SqlDbType.Decimal, 9).Value = t_OrderFormHead.Subtotal;
scom.Parameters.Add("@DiscountPer", SqlDbType.Decimal, 9).Value = t_OrderFormHead.DiscountPer;
scom.Parameters.Add("@SubtotalDisc", SqlDbType.Decimal, 9).Value = t_OrderFormHead.SubtotalDisc;
scom.Parameters.Add("@ItemdiscTotal", SqlDbType.Decimal, 9).Value = t_OrderFormHead.ItemdiscTotal;
scom.Parameters.Add("@TotalDisc", SqlDbType.Decimal, 9).Value = t_OrderFormHead.TotalDisc;
scom.Parameters.Add("@NetTotal", SqlDbType.Decimal, 9).Value = t_OrderFormHead.NetTotal;
scom.Parameters.Add("@Remarks", SqlDbType.VarChar, 250).Value = t_OrderFormHead.Remarks;
scom.Parameters.Add("@Processed", SqlDbType.Int, 4).Value = t_OrderFormHead.Processed;
scom.Parameters.Add("@ProcessedDate", SqlDbType.DateTime, 8).Value = t_OrderFormHead.ProcessedDate;
scom.Parameters.Add("@ProcessedUser", SqlDbType.VarChar, 20).Value = t_OrderFormHead.ProcessedUser;
scom.Parameters.Add("@InvCreated", SqlDbType.Int, 4).Value = t_OrderFormHead.InvCreated;
scom.Parameters.Add("@InvCreatedDate", SqlDbType.DateTime, 8).Value = t_OrderFormHead.InvCreatedDate;
scom.Parameters.Add("@INVCreatedUser", SqlDbType.VarChar, 20).Value = t_OrderFormHead.INVCreatedUser;
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 T_OrderFormHead Selectt_OrderFormHead(T_OrderFormHead objt_OrderFormHead)
{
try
{
strquery = @"select * from T_OrderFormHead where DocNo = '" + objt_OrderFormHead.DocNo + "'";
DataRow drType = u_DBConnection.ReturnDataRow(strquery);
if (drType != null)
{
objt_OrderFormHead.DocNo = drType["DocNo"].ToString();
objt_OrderFormHead.Compcode = drType["Compcode"].ToString();
objt_OrderFormHead.Locacode = drType["Locacode"].ToString();
objt_OrderFormHead.TRNType = drType["TRNType"].ToString();
objt_OrderFormHead.SalesMan = drType["SalesMan"].ToString();
objt_OrderFormHead.Customer = drType["Customer"].ToString();
objt_OrderFormHead.Datex = DateTime.Parse(drType["Datex"].ToString());
objt_OrderFormHead.RecivedBy = drType["RecivedBy"].ToString();
objt_OrderFormHead.CheckedBy = drType["CheckedBy"].ToString();
objt_OrderFormHead.Approved = int.Parse(drType["Approved"].ToString());
objt_OrderFormHead.ApprovedBy = drType["ApprovedBy"].ToString();
objt_OrderFormHead.ApprovedDate = DateTime.Parse(drType["ApprovedDate"].ToString());
objt_OrderFormHead.RecivedDate = DateTime.Parse(drType["RecivedDate"].ToString());
objt_OrderFormHead.Userx = drType["Userx"].ToString();
objt_OrderFormHead.CreatedDate = DateTime.Parse(drType["CreatedDate"].ToString());
objt_OrderFormHead.CQNO = drType["CQNO"].ToString();
objt_OrderFormHead.CQDate = DateTime.Parse(drType["CQDate"].ToString());
objt_OrderFormHead.BANK = drType["BANK"].ToString();
objt_OrderFormHead.BRANCH = drType["BRANCH"].ToString();
objt_OrderFormHead.Subtotal = decimal.Parse(drType["Subtotal"].ToString());
objt_OrderFormHead.DiscountPer = decimal.Parse(drType["DiscountPer"].ToString());
objt_OrderFormHead.SubtotalDisc = decimal.Parse(drType["SubtotalDisc"].ToString());
objt_OrderFormHead.ItemdiscTotal = decimal.Parse(drType["ItemdiscTotal"].ToString());
objt_OrderFormHead.TotalDisc = decimal.Parse(drType["TotalDisc"].ToString());
objt_OrderFormHead.NetTotal = decimal.Parse(drType["NetTotal"].ToString());
objt_OrderFormHead.Remarks = drType["Remarks"].ToString();
objt_OrderFormHead.Processed = int.Parse(drType["Processed"].ToString());
objt_OrderFormHead.ProcessedDate = DateTime.Parse(drType["ProcessedDate"].ToString());
objt_OrderFormHead.ProcessedUser = drType["ProcessedUser"].ToString();
objt_OrderFormHead.InvCreated = int.Parse(drType["InvCreated"].ToString());
objt_OrderFormHead.InvCreatedDate = DateTime.Parse(drType["InvCreatedDate"].ToString());
objt_OrderFormHead.INVCreatedUser = drType["INVCreatedUser"].ToString();
return(objt_OrderFormHead);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
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);
}
}
