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 dataGridView1_RowEnter(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.SelectedRows.Count > 0)
{
codex = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
T_InvoiceHed cat = new T_InvoiceHed();
cat.InvID = codex.Trim();
T_InvoiceHedDL dl = new T_InvoiceHedDL();
cat = dl.Selectt_InvoiceHed(cat);
txt_DocNo.Text = cat.InvID;
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.NetAmt.ToString();
txt_Subtotal.Text = cat.GrossAmt.ToString();
txt_subtotdiscper.Text = cat.SubtotaldiscPer.ToString();
txt_TotalDisc.Text = cat.TotalDisc.ToString();
txt_subtotdisc.Text = cat.SubtotalDisc.ToString();
}
}
public T_InvoiceHed Selectt_InvoiceHed(T_InvoiceHed objt_InvoiceHed)
{
try
{
strquery = @"select * from t_InvoiceHed where InvID = '" + objt_InvoiceHed.InvID + "'";
DataRow drType = u_DBConnection.ReturnDataRow(strquery);
if (drType != null)
{
objt_InvoiceHed.InvID = drType["InvID"].ToString();
objt_InvoiceHed.CompCode = drType["CompCode"].ToString();
objt_InvoiceHed.LocaCode = drType["LocaCode"].ToString();
objt_InvoiceHed.Customer = drType["Customer"].ToString();
objt_InvoiceHed.Paymeth = drType["Paymeth"].ToString();
objt_InvoiceHed.RefNo = drType["RefNo"].ToString();
objt_InvoiceHed.ManualNo = drType["ManualNo"].ToString();
objt_InvoiceHed.OrderFormNo = drType["OrderFormNo"].ToString();
objt_InvoiceHed.DONumber = drType["DONumber"].ToString();
objt_InvoiceHed.GrossAmt = decimal.Parse(drType["GrossAmt"].ToString());
objt_InvoiceHed.SubtotaldiscPer = decimal.Parse(drType["SubtotaldiscPer"].ToString());
objt_InvoiceHed.SubtotalDisc = decimal.Parse(drType["SubtotalDisc"].ToString());
objt_InvoiceHed.ItemdiscTotal = decimal.Parse(drType["ItemdiscTotal"].ToString());
objt_InvoiceHed.TotalDisc = decimal.Parse(drType["TotalDisc"].ToString());
objt_InvoiceHed.Tax = decimal.Parse(drType["Tax"].ToString());
objt_InvoiceHed.Vatamt = decimal.Parse(drType["Vatamt"].ToString());
objt_InvoiceHed.NetAmt = decimal.Parse(drType["NetAmt"].ToString());
objt_InvoiceHed.CreditPeriod = decimal.Parse(drType["CreditPeriod"].ToString());
objt_InvoiceHed.Noofitems = decimal.Parse(drType["Noofitems"].ToString());
objt_InvoiceHed.NoOfPieces = decimal.Parse(drType["NoOfPieces"].ToString());
objt_InvoiceHed.Datex = DateTime.Parse(drType["Datex"].ToString());
objt_InvoiceHed.PrerairedBy = drType["PrerairedBy"].ToString();
objt_InvoiceHed.Checked = int.Parse(drType["Checked"].ToString());
objt_InvoiceHed.CheckedBy = drType["CheckedBy"].ToString();
objt_InvoiceHed.Approved = int.Parse(drType["Approved"].ToString());
objt_InvoiceHed.AprrovedBy = drType["AprrovedBy"].ToString();
objt_InvoiceHed.ApprovedDate = DateTime.Parse(drType["ApprovedDate"].ToString());
objt_InvoiceHed.Remarks = drType["Remarks"].ToString();
objt_InvoiceHed.CQNO = drType["CQNO"].ToString();
objt_InvoiceHed.CQDate = DateTime.Parse(drType["CQDate"].ToString());
objt_InvoiceHed.BANK = drType["BANK"].ToString();
objt_InvoiceHed.BRANCH = drType["BRANCH"].ToString();
objt_InvoiceHed.Processed = int.Parse(drType["Processed"].ToString());
objt_InvoiceHed.ProcessedDate = DateTime.Parse(drType["ProcessedDate"].ToString());
objt_InvoiceHed.ProcessedUser = drType["ProcessedUser"].ToString();
objt_InvoiceHed.Glupdated = bool.Parse(drType["Glupdated"].ToString());
objt_InvoiceHed.MultipleDO = int.Parse(drType["MultipleDO"].ToString());
objt_InvoiceHed.DueAmt = decimal.Parse(drType["DueAmt"].ToString());
objt_InvoiceHed.PaidAmt = decimal.Parse(drType["PaidAmt"].ToString());
objt_InvoiceHed.IsSettled = bool.Parse(drType["IsSettled"].ToString());
objt_InvoiceHed.Iscancelled = bool.Parse(drType["Iscancelled"].ToString());
objt_InvoiceHed.CancelledDate = DateTime.Parse(drType["CancelledDate"].ToString());
objt_InvoiceHed.CancelledUSer = drType["CancelledUSer"].ToString();
return(objt_InvoiceHed);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public static T_InvoiceHed FindExisitingInvoiceAll(string suppcode)
{
string str = "";
T_InvoiceHed cat = new T_InvoiceHed();
if (T_InvoiceHedDL.ExistingT_InvoiceHed(suppcode.Trim()))
{
cat.InvID = suppcode.Trim();
T_InvoiceHedDL dl = new T_InvoiceHedDL();
cat = dl.Selectt_InvoiceHed(cat);
str = cat.NetAmt.ToString();
}
else
{
}
return(cat);
}
public static string FindExisitingInvoice(string suppcode)
{
string str = "";
if (T_InvoiceHedDL.ExistingT_InvoiceHed(suppcode.Trim()))
{
T_InvoiceHed cat = new T_InvoiceHed();
cat.InvID = suppcode.Trim();
T_InvoiceHedDL dl = new T_InvoiceHedDL();
cat = dl.Selectt_InvoiceHed(cat);
str = cat.NetAmt.ToString();
}
else
{
str = "<Error!!!>";
}
return(str);
}
/// <summary>
/// Saves a record to the T_InvoiceHed table.
/// </summary>
public Boolean Savet_InvoiceHedSP(T_InvoiceHed t_InvoiceHed, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_InvoiceHedSave";
scom.Parameters.Add("@InvID", SqlDbType.VarChar, 20).Value = t_InvoiceHed.InvID;
scom.Parameters.Add("@CompCode", SqlDbType.VarChar, 20).Value = t_InvoiceHed.CompCode;
scom.Parameters.Add("@LocaCode", SqlDbType.VarChar, 20).Value = t_InvoiceHed.LocaCode;
scom.Parameters.Add("@Customer", SqlDbType.VarChar, 20).Value = t_InvoiceHed.Customer;
scom.Parameters.Add("@Paymeth", SqlDbType.VarChar, 10).Value = t_InvoiceHed.Paymeth;
scom.Parameters.Add("@RefNo", SqlDbType.VarChar, 20).Value = t_InvoiceHed.RefNo;
scom.Parameters.Add("@ManualNo", SqlDbType.VarChar, 20).Value = t_InvoiceHed.ManualNo;
scom.Parameters.Add("@OrderFormNo", SqlDbType.VarChar, 20).Value = t_InvoiceHed.OrderFormNo;
scom.Parameters.Add("@DONumber", SqlDbType.VarChar, 20).Value = t_InvoiceHed.DONumber;
scom.Parameters.Add("@GrossAmt", SqlDbType.Decimal, 9).Value = t_InvoiceHed.GrossAmt;
scom.Parameters.Add("@SubtotaldiscPer", SqlDbType.Decimal, 9).Value = t_InvoiceHed.SubtotaldiscPer;
scom.Parameters.Add("@SubtotalDisc", SqlDbType.Decimal, 9).Value = t_InvoiceHed.SubtotalDisc;
scom.Parameters.Add("@ItemdiscTotal", SqlDbType.Decimal, 9).Value = t_InvoiceHed.ItemdiscTotal;
scom.Parameters.Add("@TotalDisc", SqlDbType.Decimal, 9).Value = t_InvoiceHed.TotalDisc;
scom.Parameters.Add("@Tax", SqlDbType.Decimal, 9).Value = t_InvoiceHed.Tax;
scom.Parameters.Add("@Vatamt", SqlDbType.Decimal, 9).Value = t_InvoiceHed.Vatamt;
scom.Parameters.Add("@NetAmt", SqlDbType.Decimal, 9).Value = t_InvoiceHed.NetAmt;
scom.Parameters.Add("@CreditPeriod", SqlDbType.Decimal, 9).Value = t_InvoiceHed.CreditPeriod;
scom.Parameters.Add("@Noofitems", SqlDbType.Decimal, 9).Value = t_InvoiceHed.Noofitems;
scom.Parameters.Add("@NoOfPieces", SqlDbType.Decimal, 9).Value = t_InvoiceHed.NoOfPieces;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = t_InvoiceHed.Datex;
scom.Parameters.Add("@PrerairedBy", SqlDbType.VarChar, 20).Value = t_InvoiceHed.PrerairedBy;
scom.Parameters.Add("@Checked", SqlDbType.Int, 4).Value = t_InvoiceHed.Checked;
scom.Parameters.Add("@CheckedBy", SqlDbType.VarChar, 20).Value = t_InvoiceHed.CheckedBy;
scom.Parameters.Add("@Approved", SqlDbType.Int, 4).Value = t_InvoiceHed.Approved;
scom.Parameters.Add("@AprrovedBy", SqlDbType.VarChar, 20).Value = t_InvoiceHed.AprrovedBy;
scom.Parameters.Add("@ApprovedDate", SqlDbType.DateTime, 8).Value = t_InvoiceHed.ApprovedDate;
scom.Parameters.Add("@Remarks", SqlDbType.VarChar, 150).Value = t_InvoiceHed.Remarks;
scom.Parameters.Add("@CQNO", SqlDbType.VarChar, 20).Value = t_InvoiceHed.CQNO;
scom.Parameters.Add("@CQDate", SqlDbType.DateTime, 8).Value = t_InvoiceHed.CQDate;
scom.Parameters.Add("@BANK", SqlDbType.VarChar, 20).Value = t_InvoiceHed.BANK;
scom.Parameters.Add("@BRANCH", SqlDbType.VarChar, 20).Value = t_InvoiceHed.BRANCH;
scom.Parameters.Add("@Processed", SqlDbType.Int, 4).Value = t_InvoiceHed.Processed;
scom.Parameters.Add("@ProcessedDate", SqlDbType.DateTime, 8).Value = t_InvoiceHed.ProcessedDate;
scom.Parameters.Add("@ProcessedUser", SqlDbType.VarChar, 20).Value = t_InvoiceHed.ProcessedUser;
scom.Parameters.Add("@Glupdated", SqlDbType.Bit, 1).Value = t_InvoiceHed.Glupdated;
scom.Parameters.Add("@MultipleDO", SqlDbType.Int, 4).Value = t_InvoiceHed.MultipleDO;
scom.Parameters.Add("@DueAmt", SqlDbType.Decimal, 9).Value = t_InvoiceHed.DueAmt;
scom.Parameters.Add("@PaidAmt", SqlDbType.Decimal, 9).Value = t_InvoiceHed.PaidAmt;
scom.Parameters.Add("@IsSettled", SqlDbType.Bit, 1).Value = t_InvoiceHed.IsSettled;
scom.Parameters.Add("@Iscancelled", SqlDbType.Bit, 1).Value = t_InvoiceHed.Iscancelled;
scom.Parameters.Add("@CancelledDate", SqlDbType.DateTime, 8).Value = t_InvoiceHed.CancelledDate;
scom.Parameters.Add("@CancelledUSer", SqlDbType.VarChar, 20).Value = t_InvoiceHed.CancelledUSer;
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_InvoiceHed> SelectT_InvoiceHedMulti(string customercode)
{
List <T_InvoiceHed> retval = new List <T_InvoiceHed>();
try
{
strquery = @"SELECT * FROM T_InvoiceHed WHERE Processed = 1 AND Approved = 1 AND Customer = '" + customercode + "'";
DataTable dtt_InvoiceHed = u_DBConnection.ReturnDataTable(strquery, CommandType.Text);
foreach (DataRow drType in dtt_InvoiceHed.Rows)
{
if (drType != null)
{
T_InvoiceHed objt_InvoiceHed = new T_InvoiceHed();
objt_InvoiceHed.InvID = drType["InvID"].ToString();
objt_InvoiceHed.CompCode = drType["CompCode"].ToString();
objt_InvoiceHed.LocaCode = drType["LocaCode"].ToString();
objt_InvoiceHed.Customer = drType["Customer"].ToString();
objt_InvoiceHed.Paymeth = drType["Paymeth"].ToString();
objt_InvoiceHed.RefNo = drType["RefNo"].ToString();
objt_InvoiceHed.ManualNo = drType["ManualNo"].ToString();
objt_InvoiceHed.OrderFormNo = drType["OrderFormNo"].ToString();
objt_InvoiceHed.DONumber = drType["DONumber"].ToString();
objt_InvoiceHed.GrossAmt = decimal.Parse(drType["GrossAmt"].ToString());
objt_InvoiceHed.SubtotaldiscPer = decimal.Parse(drType["SubtotaldiscPer"].ToString());
objt_InvoiceHed.SubtotalDisc = decimal.Parse(drType["SubtotalDisc"].ToString());
objt_InvoiceHed.ItemdiscTotal = decimal.Parse(drType["ItemdiscTotal"].ToString());
objt_InvoiceHed.TotalDisc = decimal.Parse(drType["TotalDisc"].ToString());
objt_InvoiceHed.Tax = decimal.Parse(drType["Tax"].ToString());
objt_InvoiceHed.Vatamt = decimal.Parse(drType["Vatamt"].ToString());
objt_InvoiceHed.NetAmt = decimal.Parse(drType["NetAmt"].ToString());
objt_InvoiceHed.CreditPeriod = decimal.Parse(drType["CreditPeriod"].ToString());
objt_InvoiceHed.Noofitems = decimal.Parse(drType["Noofitems"].ToString());
objt_InvoiceHed.NoOfPieces = decimal.Parse(drType["NoOfPieces"].ToString());
objt_InvoiceHed.Datex = DateTime.Parse(drType["Datex"].ToString());
objt_InvoiceHed.PrerairedBy = drType["PrerairedBy"].ToString();
objt_InvoiceHed.Checked = int.Parse(drType["Checked"].ToString());
objt_InvoiceHed.CheckedBy = drType["CheckedBy"].ToString();
objt_InvoiceHed.Approved = int.Parse(drType["Approved"].ToString());
objt_InvoiceHed.AprrovedBy = drType["AprrovedBy"].ToString();
objt_InvoiceHed.ApprovedDate = DateTime.Parse(drType["ApprovedDate"].ToString());
objt_InvoiceHed.Remarks = drType["Remarks"].ToString();
objt_InvoiceHed.CQNO = drType["CQNO"].ToString();
objt_InvoiceHed.CQDate = DateTime.Parse(drType["CQDate"].ToString());
objt_InvoiceHed.BANK = drType["BANK"].ToString();
objt_InvoiceHed.BRANCH = drType["BRANCH"].ToString();
objt_InvoiceHed.Processed = int.Parse(drType["Processed"].ToString());
objt_InvoiceHed.ProcessedDate = DateTime.Parse(drType["ProcessedDate"].ToString());
objt_InvoiceHed.ProcessedUser = drType["ProcessedUser"].ToString();
objt_InvoiceHed.Glupdated = bool.Parse(drType["Glupdated"].ToString());
objt_InvoiceHed.MultipleDO = int.Parse(drType["MultipleDO"].ToString());
objt_InvoiceHed.DueAmt = decimal.Parse(drType["DueAmt"].ToString());
objt_InvoiceHed.PaidAmt = decimal.Parse(drType["PaidAmt"].ToString());
objt_InvoiceHed.IsSettled = bool.Parse(drType["IsSettled"].ToString());
objt_InvoiceHed.Iscancelled = bool.Parse(drType["Iscancelled"].ToString());
objt_InvoiceHed.CancelledDate = DateTime.Parse(drType["CancelledDate"].ToString());
objt_InvoiceHed.CancelledUSer = drType["CancelledUSer"].ToString();
retval.Add(objt_InvoiceHed);
}
}
return(retval);
}
catch (Exception ex)
{
throw ex;
}
}
