private void UpdateFooter(SOReturnDetails clsSOReturnDetails)
{
lblSODiscount.Text = clsSOReturnDetails.Discount.ToString("#,##0.#0");
lblSOVatableAmount.Text = clsSOReturnDetails.VatableAmount.ToString("#,##0.#0");
txtSOFreight.Text = clsSOReturnDetails.Freight.ToString("#,##0.#0");
txtSODeposit.Text = clsSOReturnDetails.Deposit.ToString("#,##0.#0");
lblSOSubTotal.Text = Convert.ToDecimal(clsSOReturnDetails.SubTotal - clsSOReturnDetails.VAT).ToString("#,##0.#0");
lblSOVAT.Text = clsSOReturnDetails.VAT.ToString("#,##0.#0");
lblSOTotal.Text = clsSOReturnDetails.SubTotal.ToString("#,##0.#0");
}
private void UpdateSODiscount()
{
SOReturnDetails clsSOReturnDetails = new SOReturnDetails();
clsSOReturnDetails.CreditMemoID = Convert.ToInt64(lblCreditMemoID.Text);
clsSOReturnDetails.DiscountApplied = Convert.ToDecimal(txtSODiscountApplied.Text);
clsSOReturnDetails.DiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboSODiscountType.SelectedItem.Value);
SOReturns clsSOReturns = new SOReturns();
clsSOReturns.UpdateDiscount(clsSOReturnDetails.CreditMemoID, clsSOReturnDetails.DiscountApplied, clsSOReturnDetails.DiscountType);
clsSOReturns.SynchronizeAmount(Convert.ToInt64(lblCreditMemoID.Text));
clsSOReturnDetails = clsSOReturns.Details(Convert.ToInt64(lblCreditMemoID.Text));
clsSOReturns.CommitAndDispose();
UpdateFooter(clsSOReturnDetails);
}
private void UpdateDeposit()
{
SOReturnDetails clsSOReturnDetails = new SOReturnDetails();
clsSOReturnDetails.CreditMemoID = Convert.ToInt64(lblCreditMemoID.Text);
clsSOReturnDetails.Deposit = Convert.ToDecimal(txtSODeposit.Text);
SOReturns clsSOReturns = new SOReturns();
clsSOReturns.UpdateDeposit(clsSOReturnDetails.CreditMemoID, clsSOReturnDetails.Deposit);
clsSOReturns.SynchronizeAmount(clsSOReturnDetails.CreditMemoID);
clsSOReturnDetails = clsSOReturns.Details(clsSOReturnDetails.CreditMemoID);
clsSOReturns.CommitAndDispose();
UpdateFooter(clsSOReturnDetails);
}
private long SaveRecord()
{
SOReturns clsSOReturns = new SOReturns();
clsSOReturns.GetConnection();
lblReturnNo.Text = Constants.SALES_RETURN_CODE + CompanyDetails.BECompanyCode + DateTime.Now.Year.ToString() + clsSOReturns.LastTransactionNo();
SOReturnDetails clsDetails = new SOReturnDetails();
clsDetails.CNNo = lblReturnNo.Text;
clsDetails.CNDate = Convert.ToDateTime(lblReturnDate.Text);
clsDetails.CustomerID = Convert.ToInt64(cboCustomer.SelectedItem.Value);
clsDetails.CustomerCode = cboCustomer.SelectedItem.Text;
clsDetails.CustomerContact = txtCustomerContact.Text;
clsDetails.CustomerAddress = txtCustomerAddress.Text;
clsDetails.CustomerTelephoneNo = txtCustomerTelephoneNo.Text;
clsDetails.CustomerTerms = Convert.ToInt32(lblTerms.Text);
switch (lblModeOfterms.Text)
{
case "Days":
clsDetails.CustomerModeOfTerms = 0;
break;
case "Months":
clsDetails.CustomerModeOfTerms = 1;
break;
case "Years":
clsDetails.CustomerModeOfTerms = 2;
break;
}
clsDetails.RequiredPostingDate = Convert.ToDateTime(txtRequiredReturnDate.Text);
clsDetails.BranchID = Convert.ToInt16(cboBranch.SelectedItem.Value);
clsDetails.SellerID = Convert.ToInt64(Session["UID"].ToString());
clsDetails.SellerName = Session["Name"].ToString();
clsDetails.ReturnStatus = SOReturnStatus.Open;
clsDetails.Remarks = txtRemarks.Text;
long id = clsSOReturns.Insert(clsDetails);
clsSOReturns.CommitAndDispose();
return id;
}
private void SaveRecord()
{
SOReturnDetails clsDetails = new SOReturnDetails();
clsDetails.CreditMemoID = Convert.ToInt64(lblCreditMemoID.Text);
clsDetails.CNNo = lnkReturnNo.Text;
clsDetails.CNDate = Convert.ToDateTime(lblReturnDate.Text);
clsDetails.CustomerID = Convert.ToInt64(cboCustomer.SelectedItem.Value);
clsDetails.CustomerCode = cboCustomer.SelectedItem.Text;
clsDetails.CustomerContact = txtCustomerContact.Text;
clsDetails.CustomerAddress = txtCustomerAddress.Text;
clsDetails.CustomerTelephoneNo = txtCustomerTelephoneNo.Text;
switch (lblModeOfterms.Text)
{
case "Days":
clsDetails.CustomerModeOfTerms = 0;
break;
case "Months":
clsDetails.CustomerModeOfTerms = 1;
break;
case "Years":
clsDetails.CustomerModeOfTerms = 2;
break;
}
clsDetails.RequiredPostingDate = Convert.ToDateTime(txtRequiredReturnDate.Text);
clsDetails.BranchID = Convert.ToInt16(cboBranch.SelectedItem.Value);
clsDetails.SellerID = Convert.ToInt64(Session["UID"].ToString());
clsDetails.SellerName = Session["Name"].ToString();
clsDetails.ReturnStatus = SOReturnStatus.Open;
clsDetails.Remarks = txtRemarks.Text;
SOReturns clsSOReturns = new SOReturns();
clsSOReturns.Update(clsDetails);
clsSOReturns.CommitAndDispose();
}
public long Insert(SOReturnDetails Details)
{
try
{
ERPConfig clsERPConfig = new ERPConfig(base.Connection, base.Transaction);
ARLinkConfigDetails clsARLinkConfigDetails = clsERPConfig.ARLinkDetails();
string SQL = "INSERT INTO tblSOCreditMemo (" +
"CNNo, " +
"CNDate, " +
"CustomerID, " +
"CustomerCode, " +
"CustomerContact, " +
"CustomerAddress, " +
"CustomerTelephoneNo, " +
"CustomerModeOfTerms, " +
"CustomerTerms, " +
"RequiredPostingDate, " +
"BranchID, " +
"SellerID, " +
"SellerName, " +
"SOReturnStatus, " +
"CreditMemoStatus, " +
"Remarks, " +
"ChartOfAccountIDARTracking, " +
"ChartOfAccountIDARBills, " +
"ChartOfAccountIDARFreight, " +
"ChartOfAccountIDARVDeposit, " +
"ChartOfAccountIDARContra, " +
"ChartOfAccountIDARLatePayment" +
") VALUES (" +
"@CNNo, " +
"@CNDate, " +
"@CustomerID, " +
"@CustomerCode, " +
"@CustomerContact, " +
"@CustomerAddress, " +
"@CustomerTelephoneNo, " +
"@CustomerModeOfTerms, " +
"@CustomerTerms, " +
"@RequiredPostingDate, " +
"@BranchID, " +
"@SellerID, " +
"@SellerName, " +
"@SOReturnStatus, " +
"@CreditMemoStatus, " +
"@Remarks, " +
"@ChartOfAccountIDARTracking, " +
"@ChartOfAccountIDARBills, " +
"@ChartOfAccountIDARFreight, " +
"@ChartOfAccountIDARVDeposit, " +
"@ChartOfAccountIDARContra, " +
"@ChartOfAccountIDARLatePayment" +
");";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@CNNo", Details.CNNo);
cmd.Parameters.AddWithValue("@CNDate", Details.CNDate.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("@CustomerID", Details.CustomerID);
cmd.Parameters.AddWithValue("@CustomerCode", Details.CustomerCode);
cmd.Parameters.AddWithValue("@CustomerContact", Details.CustomerContact);
cmd.Parameters.AddWithValue("@CustomerAddress", Details.CustomerAddress);
cmd.Parameters.AddWithValue("@CustomerTelephoneNo", Details.CustomerTelephoneNo);
cmd.Parameters.AddWithValue("@CustomerModeOfTerms", Details.CustomerModeOfTerms);
cmd.Parameters.AddWithValue("@CustomerTerms", Details.CustomerTerms);
cmd.Parameters.AddWithValue("@RequiredPostingDate", Details.RequiredPostingDate.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("@BranchID", Details.BranchID);
cmd.Parameters.AddWithValue("@SellerID", Details.SellerID);
cmd.Parameters.AddWithValue("@SellerName", Details.SellerName);
cmd.Parameters.AddWithValue("@SOReturnStatus", Details.ReturnStatus.ToString("d"));
cmd.Parameters.AddWithValue("@CreditMemoStatus", CreditMemoStatus.Posted.ToString("d"));
cmd.Parameters.AddWithValue("@Remarks", Details.Remarks);
cmd.Parameters.AddWithValue("@ChartOfAccountIDARTracking", clsARLinkConfigDetails.ChartOfAccountIDARTracking);
cmd.Parameters.AddWithValue("@ChartOfAccountIDARBills", clsARLinkConfigDetails.ChartOfAccountIDARBills);
cmd.Parameters.AddWithValue("@ChartOfAccountIDARFreight", clsARLinkConfigDetails.ChartOfAccountIDARFreight);
cmd.Parameters.AddWithValue("@ChartOfAccountIDARVDeposit", clsARLinkConfigDetails.ChartOfAccountIDARVDeposit);
cmd.Parameters.AddWithValue("@ChartOfAccountIDARContra", clsARLinkConfigDetails.ChartOfAccountIDARContra);
cmd.Parameters.AddWithValue("@ChartOfAccountIDARLatePayment", clsARLinkConfigDetails.ChartOfAccountIDARLatePayment);
base.ExecuteNonQuery(cmd);
SQL = "SELECT LAST_INSERT_ID();";
cmd.Parameters.Clear();
cmd.CommandText = SQL;
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
Int64 iID = 0;
while (myReader.Read())
{
iID = myReader.GetInt64(0);
}
myReader.Close();
return iID;
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public SOReturnDetails Details(long CreditMemoID)
{
try
{
string SQL= SQLSelect() + "AND CreditMemoID = @CreditMemoID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@CreditMemoID", CreditMemoID);
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
SOReturnDetails Details = new SOReturnDetails();
while (myReader.Read())
{
Details.CreditMemoID = CreditMemoID;
Details.CNNo = "" + myReader["CNNo"].ToString();
Details.CNDate = myReader.GetDateTime("CNDate");
Details.CustomerID = myReader.GetInt64("CustomerID");
Details.CustomerCode = "" + myReader["CustomerCode"].ToString();
Details.CustomerContact = "" + myReader["CustomerContact"].ToString();
Details.CustomerAddress = "" + myReader["CustomerAddress"].ToString();
Details.CustomerTelephoneNo = "" + myReader["CustomerTelephoneNo"].ToString();
Details.CustomerModeOfTerms = myReader.GetInt16("CustomerModeofTerms");
Details.CustomerTerms = myReader.GetInt16("CustomerTerms");
Details.RequiredPostingDate = myReader.GetDateTime("RequiredPostingDate");
Details.BranchID = myReader.GetInt16("BranchID");
Details.BranchCode = "" + myReader["BranchCode"].ToString();
Details.BranchName = "" + myReader["BranchName"].ToString();
Details.BranchAddress = "" + myReader["BranchAddress"].ToString();
Details.SellerID = myReader.GetInt64("SellerID");
Details.SellerName = "" + myReader["SellerName"].ToString();
Details.SubTotal = myReader.GetDecimal("SubTotal");
Details.Discount = myReader.GetDecimal("Discount");
Details.DiscountApplied = myReader.GetDecimal("DiscountApplied");
Details.DiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), myReader.GetString("DiscountType"));
Details.VAT = myReader.GetDecimal("VAT");
Details.VatableAmount = myReader.GetDecimal("VatableAmount");
Details.EVAT = myReader.GetDecimal("EVAT");
Details.EVatableAmount = myReader.GetDecimal("EVatableAmount");
Details.LocalTax = myReader.GetDecimal("LocalTax");
Details.Freight = myReader.GetDecimal("Freight");
Details.Deposit = myReader.GetDecimal("Deposit");
Details.PaidAmount = myReader.GetDecimal("PaidAmount");
Details.UnpaidAmount = myReader.GetDecimal("UnpaidAmount");
Details.TotalItemDiscount = myReader.GetDecimal("TotalItemDiscount");
Details.ReturnStatus = (SOReturnStatus)Enum.Parse(typeof(SOReturnStatus), myReader.GetString("SOReturnStatus"));
Details.Remarks = "" + myReader["Remarks"].ToString();
Details.CustomerDocNo = "" + myReader["CustomerDocNo"].ToString();
Details.PostingDate = myReader.GetDateTime("PostingDate");
Details.ChartOfAccountIDARTracking = myReader.GetInt16("ChartOfAccountIDARTracking");
Details.ChartOfAccountIDARFreight = myReader.GetInt16("ChartOfAccountIDARFreight");
Details.ChartOfAccountIDARVDeposit = myReader.GetInt16("ChartOfAccountIDARVDeposit");
Details.ChartOfAccountIDARContra = myReader.GetInt16("ChartOfAccountIDARContra");
Details.ChartOfAccountIDARLatePayment = myReader.GetInt16("ChartOfAccountIDARLatePayment");
}
myReader.Close();
return Details;
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public void Update(SOReturnDetails Details)
{
try
{
ERPConfig clsERPConfig = new ERPConfig(base.Connection, base.Transaction);
ARLinkConfigDetails clsARLinkConfigDetails = clsERPConfig.ARLinkDetails();
string SQL= "UPDATE tblSOCreditMemo SET " +
"CNNo = @CNNo, " +
"CNDate = @CNDate, " +
"CustomerID = @CustomerID, " +
"CustomerCode = @CustomerCode, " +
"CustomerContact = @CustomerContact, " +
"CustomerAddress = @CustomerAddress, " +
"CustomerTelephoneNo = @CustomerTelephoneNo, " +
"CustomerModeOfTerms = @CustomerModeOfTerms, " +
"CustomerTerms = @CustomerTerms, " +
"RequiredPostingDate = @RequiredPostingDate, " +
"BranchID = @BranchID, " +
"SellerID = @SellerID, " +
"SellerName = @SellerName, " +
"Remarks = @Remarks, " +
"ChartOfAccountIDARTracking = @ChartOfAccountIDARTracking, " +
"ChartOfAccountIDARBills = @ChartOfAccountIDARBills, " +
"ChartOfAccountIDARFreight = @ChartOfAccountIDARFreight, " +
"ChartOfAccountIDARVDeposit = @ChartOfAccountIDARVDeposit, " +
"ChartOfAccountIDARContra = @ChartOfAccountIDARContra, " +
"ChartOfAccountIDARLatePayment = @ChartOfAccountIDARLatePayment " +
"WHERE CreditMemoID = @CreditMemoID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@CNNo", Details.CNNo);
cmd.Parameters.AddWithValue("@CNDate", Details.CNDate.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("@CustomerID", Details.CustomerID);
cmd.Parameters.AddWithValue("@CustomerCode", Details.CustomerCode);
cmd.Parameters.AddWithValue("@CustomerContact", Details.CustomerContact);
cmd.Parameters.AddWithValue("@CustomerAddress", Details.CustomerAddress);
cmd.Parameters.AddWithValue("@CustomerTelephoneNo", Details.CustomerTelephoneNo);
cmd.Parameters.AddWithValue("@CustomerModeOfTerms", Details.CustomerModeOfTerms);
cmd.Parameters.AddWithValue("@CustomerTerms", Details.CustomerTerms);
cmd.Parameters.AddWithValue("@RequiredPostingDate", Details.RequiredPostingDate.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("@BranchID", Details.BranchID);
cmd.Parameters.AddWithValue("@SellerID", Details.SellerID);
cmd.Parameters.AddWithValue("@SellerName", Details.SellerName);
cmd.Parameters.AddWithValue("@SOReturnStatus", Details.ReturnStatus.ToString("d"));
cmd.Parameters.AddWithValue("@CreditMemoStatus", CreditMemoStatus.Posted.ToString("d"));
cmd.Parameters.AddWithValue("@Remarks", Details.Remarks);
cmd.Parameters.AddWithValue("@ChartOfAccountIDARTracking", clsARLinkConfigDetails.ChartOfAccountIDARTracking);
cmd.Parameters.AddWithValue("@ChartOfAccountIDARBills", clsARLinkConfigDetails.ChartOfAccountIDARBills);
cmd.Parameters.AddWithValue("@ChartOfAccountIDARFreight", clsARLinkConfigDetails.ChartOfAccountIDARFreight);
cmd.Parameters.AddWithValue("@ChartOfAccountIDARVDeposit", clsARLinkConfigDetails.ChartOfAccountIDARVDeposit);
cmd.Parameters.AddWithValue("@ChartOfAccountIDARContra", clsARLinkConfigDetails.ChartOfAccountIDARContra);
cmd.Parameters.AddWithValue("@ChartOfAccountIDARLatePayment", clsARLinkConfigDetails.ChartOfAccountIDARLatePayment);
cmd.Parameters.AddWithValue("@CreditMemoID", Details.CreditMemoID);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
