public int DeleteNonPOBasedInvoice(NonPOBasedInvoiceFormUI nonPOBasedInvoiceFormUI)
{
int resutl = 0;
resutl = nonPOBasedInvoiceFormDAL.DeleteNonPOBasedInvoice(nonPOBasedInvoiceFormUI);
return(resutl);
}
protected override void Page_Load(object sender, EventArgs e)
{
NonPOBasedInvoiceFormUI nonPOBasedInvoiceFormUI = new NonPOBasedInvoiceFormUI();
if (!Page.IsPostBack)
{
BindDocumentTypeDropDownList();
if (Request.QueryString["NonPOBasedInvoiceId"] != null)
{
nonPOBasedInvoiceFormUI.Tbl_NonPOBasedInvoiceId = Request.QueryString["NonPOBasedInvoiceId"];
BindDocumentTypeDropDownList();
FillForm(nonPOBasedInvoiceFormUI);
btnSave.Visible = false;
btnClear.Visible = false;
btnUpdate.Visible = true;
btnDelete.Visible = true;
lblHeading.Text = "Update Non PO Based Invoice";
}
else
{
BindDocumentTypeDropDownList();
btnSave.Visible = true;
btnClear.Visible = true;
btnUpdate.Visible = false;
btnDelete.Visible = false;
lblHeading.Text = "Add New Non PO Based Invoice";
}
}
}
public DataTable GetNonPOBasedInvoiceListById(NonPOBasedInvoiceFormUI nonPOBasedInvoiceFormUI)
{
DataTable dtb = new DataTable();
dtb = nonPOBasedInvoiceFormDAL.GetNonPOBasedInvoiceListById(nonPOBasedInvoiceFormUI);
return(dtb);
}
private void FillForm(NonPOBasedInvoiceFormUI nonPOBasedInvoiceFormUI)
{
try
{
DataTable dtb = nonPOBasedInvoiceFormBAL.GetNonPOBasedInvoiceListById(nonPOBasedInvoiceFormUI);
if (dtb.Rows.Count > 0)
{
txtBatchGuid.Text = dtb.Rows[0]["tbl_BatchId"].ToString();
txtBatch.Text = dtb.Rows[0]["BatchName"].ToString();
txtCurrencyGuid.Text = dtb.Rows[0]["tbl_CurrencyId"].ToString();
txtCurrency.Text = dtb.Rows[0]["CurrencyName"].ToString();
txtPayablesBankGuid.Text = dtb.Rows[0]["tbl_PayablesId_BankTransfer"].ToString();
txtPayablesBank.Text = dtb.Rows[0]["BankName"].ToString();
txtPayablesCashGuid.Text = dtb.Rows[0]["tbl_PayablesId_Cash"].ToString();
txtPayablesCash.Text = dtb.Rows[0]["PayablesTypeCash"].ToString();
txtPayablesChequeGuid.Text = dtb.Rows[0]["tbl_PayablesId_Cheque"].ToString();
txtPayablesCheque.Text = dtb.Rows[0]["PayablesTypeCheque"].ToString();
txtSupplierGuid.Text = dtb.Rows[0]["tbl_SupplierId"].ToString();
txtSupplier.Text = dtb.Rows[0]["SupplierName"].ToString();
txtPayablesCreditCardGuid.Text = dtb.Rows[0]["tbl_PayablesId_CreditCard"].ToString();
txtPayablesCreditCard.Text = dtb.Rows[0]["CardName"].ToString();
txtPaymentTermsGuid.Text = dtb.Rows[0]["tbl_PaymentTermsId"].ToString();
txtPaymentTerms.Text = dtb.Rows[0]["PaymentTermsName"].ToString();
chkInterCompany.Checked = Convert.ToBoolean(dtb.Rows[0]["InterCompany"].ToString());
txtInvoiceDate.Text = dtb.Rows[0]["InvoiceDate"].ToString();
txtVoucherNumber.Text = dtb.Rows[0]["VoucherNumber"].ToString();
ddlOpt_DocumentType.SelectedValue = dtb.Rows[0]["Opt_DocumentType"].ToString();
txtDocumentDate.Text = dtb.Rows[0]["DocumentDate"].ToString();
txtDescription.Text = dtb.Rows[0]["Description"].ToString();
txtPostingDate.Text = dtb.Rows[0]["PostingDate"].ToString();
txtReceivedDate.Text = dtb.Rows[0]["ReceivedDate"].ToString();
txtDocumentNumber.Text = dtb.Rows[0]["DocumentNumber"].ToString();
txtPONumber.Text = dtb.Rows[0]["PONumber"].ToString();
txtPurchase.Text = dtb.Rows[0]["Purchase"].ToString();
txtTradeDiscount.Text = dtb.Rows[0]["TradeDiscount"].ToString();
txtFreight.Text = dtb.Rows[0]["Freight"].ToString();
txtTotal.Text = dtb.Rows[0]["Total"].ToString();
txtBankTransferAmount.Text = dtb.Rows[0]["BankTransferAmount"].ToString();
txtCashAmount.Text = dtb.Rows[0]["CashAmount"].ToString();
txtChequeAmount.Text = dtb.Rows[0]["ChequeAmount"].ToString();
txtCreditCardAmount.Text = dtb.Rows[0]["CreditCardAmount"].ToString();
txtOnAccount.Text = dtb.Rows[0]["OnAccount"].ToString();
}
else
{
lblError.Text = Resources.GlobalResource.msgCouldNotLoadData;
divError.Visible = true;
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "FillForm()";
logExcpUIobj.ResourceName = "Finance_Accounts_Payable_Non_PO_Based_Invoice_NonPOBasedInvoiceForm.CS";
logExcpUIobj.RecordId = nonPOBasedInvoiceFormUI.Tbl_NonPOBasedInvoiceId;
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[Finance_Accounts_Payable_Non_PO_Based_Invoice_NonPOBasedInvoiceForm : FillForm] An error occured in the processing of Record Details : [" + exp.ToString() + "]");
}
}
public DataTable GetNonPOBasedInvoiceListById(NonPOBasedInvoiceFormUI nonPOBasedInvoiceFormUI)
{
DataSet ds = new DataSet();
DataTable dtbl = new DataTable();
try
{
using (SqlConnection SupportCon = new SqlConnection(connectionString))
{
SqlCommand sqlCmd = new SqlCommand("SP_NonPOBasedInvoice_SelectById", SupportCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandTimeout = commandTimeout;
sqlCmd.Parameters.Add("@tbl_NonPOBasedInvoiceId", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_NonPOBasedInvoiceId"].Value = nonPOBasedInvoiceFormUI.Tbl_NonPOBasedInvoiceId;
using (SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd))
{
adapter.Fill(ds);
}
}
if (ds.Tables.Count > 0)
{
dtbl = ds.Tables[0];
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "getNonPOBasedInvoiceListById()";
logExcpUIobj.ResourceName = "NonPOBasedInvoiceFormDAL.CS";
logExcpUIobj.RecordId = nonPOBasedInvoiceFormUI.Tbl_NonPOBasedInvoiceId;
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[NonPOBasedInvoiceFormDAL : getNonPOBasedInvoiceListById] An error occured in the processing of Record Id : " + nonPOBasedInvoiceFormUI.Tbl_NonPOBasedInvoiceId + ". Details : [" + exp.ToString() + "]");
}
finally
{
ds.Dispose();
}
return(dtbl);
}
public int DeleteNonPOBasedInvoice(NonPOBasedInvoiceFormUI nonPOBasedInvoiceFormUI)
{
int result = 0;
try
{
using (SqlConnection SupportCon = new SqlConnection(connectionString))
{
SupportCon.Open();
SqlCommand sqlCmd = new SqlCommand("SP_NonPOBasedInvoice_Delete", SupportCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandTimeout = commandTimeout;
sqlCmd.Parameters.Add("@tbl_NonPOBasedInvoiceId", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_NonPOBasedInvoiceId"].Value = nonPOBasedInvoiceFormUI.Tbl_NonPOBasedInvoiceId;
result = sqlCmd.ExecuteNonQuery();
sqlCmd.Dispose();
SupportCon.Close();
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "DeleteNonPOBasedInvoice()";
logExcpUIobj.ResourceName = "NonPOBasedInvoiceFormDAL.CS";
logExcpUIobj.RecordId = nonPOBasedInvoiceFormUI.Tbl_NonPOBasedInvoiceId;
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[NonPOBasedInvoiceFormDAL : DeleteNonPOBasedInvoice] An error occured in the processing of Record Id : " + nonPOBasedInvoiceFormUI.Tbl_NonPOBasedInvoiceId + ". Details : [" + exp.ToString() + "]");
}
return(result);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
NonPOBasedInvoiceFormUI nonPOBasedInvoiceFormUI = new NonPOBasedInvoiceFormUI();
try
{
nonPOBasedInvoiceFormUI.ModifiedBy = SessionContext.UserGuid;
nonPOBasedInvoiceFormUI.Tbl_OrganizationId = SessionContext.OrganizationId;
nonPOBasedInvoiceFormUI.Tbl_NonPOBasedInvoiceId = Request.QueryString["NonPOBasedInvoiceId"];
nonPOBasedInvoiceFormUI.Tbl_BatchId = txtBatchGuid.Text;
nonPOBasedInvoiceFormUI.Tbl_SupplierId = txtSupplierGuid.Text;
nonPOBasedInvoiceFormUI.Tbl_CurrencyId = txtCurrencyGuid.Text;
nonPOBasedInvoiceFormUI.Tbl_PayablesId_BankTransfer = txtPayablesBankGuid.Text;
nonPOBasedInvoiceFormUI.Tbl_PayablesId_Cash = txtPayablesCashGuid.Text;
nonPOBasedInvoiceFormUI.Tbl_PayablesId_Cheque = txtPayablesChequeGuid.Text;
nonPOBasedInvoiceFormUI.Tbl_PayablesId_CreditCard = txtPayablesCreditCardGuid.Text;
nonPOBasedInvoiceFormUI.Tbl_PaymentTermsId = txtPaymentTermsGuid.Text;
if (chkInterCompany.Checked)
{
nonPOBasedInvoiceFormUI.InterCompany = true;
}
else
{
nonPOBasedInvoiceFormUI.InterCompany = false;
}
nonPOBasedInvoiceFormUI.InvoiceDate = Convert.ToDateTime(txtInvoiceDate.Text);
nonPOBasedInvoiceFormUI.VoucherNumber = txtVoucherNumber.Text;
nonPOBasedInvoiceFormUI.Opt_DocumentType = int.Parse(ddlOpt_DocumentType.SelectedValue.ToString());
nonPOBasedInvoiceFormUI.DocumentDate = Convert.ToDateTime(txtDocumentDate.Text);
nonPOBasedInvoiceFormUI.Description = txtDescription.Text;
nonPOBasedInvoiceFormUI.PostingDate = Convert.ToDateTime(txtPostingDate.Text);
nonPOBasedInvoiceFormUI.ReceivedDate = Convert.ToDateTime(txtReceivedDate.Text);
nonPOBasedInvoiceFormUI.DocumentNumber = txtDocumentNumber.Text;
nonPOBasedInvoiceFormUI.PONumber = txtPONumber.Text;
nonPOBasedInvoiceFormUI.Purchase = Convert.ToDecimal(txtPurchase.Text);
nonPOBasedInvoiceFormUI.TradeDiscount = Convert.ToDecimal(txtTradeDiscount.Text);
nonPOBasedInvoiceFormUI.Freight = Convert.ToDecimal(txtFreight.Text);
nonPOBasedInvoiceFormUI.Total = Convert.ToDecimal(txtTotal.Text);
nonPOBasedInvoiceFormUI.BankTransferAmount = Convert.ToDecimal(txtBankTransferAmount.Text);
nonPOBasedInvoiceFormUI.CashAmount = Convert.ToDecimal(txtCashAmount.Text);
nonPOBasedInvoiceFormUI.ChequeAmount = Convert.ToDecimal(txtChequeAmount.Text);
nonPOBasedInvoiceFormUI.CreditCardAmount = Convert.ToDecimal(txtCreditCardAmount.Text);
nonPOBasedInvoiceFormUI.OnAccount = Convert.ToDecimal(txtOnAccount.Text);
if (nonPOBasedInvoiceFormBAL.UpdateNonPOBasedInvoice(nonPOBasedInvoiceFormUI) == 1)
{
divSuccess.Visible = true;
divError.Visible = false;
lblSuccess.Text = Resources.GlobalResource.msgRecordUpdatedSuccessfully;
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "clearform", "ClearForm();", true);
}
else
{
divError.Visible = true;
divSuccess.Visible = false;
lblError.Text = Resources.GlobalResource.msgCouldNotUpdateRecord;
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "clearform", "ClearForm();", true);
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "btnUpdate_Click()";
logExcpUIobj.ResourceName = "Finance_Accounts_Payable_Non_PO_Based_Invoice_NonPOBasedInvoiceForm.CS";
logExcpUIobj.RecordId = "";
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[Finance_Accounts_Payable_Non_PO_Based_Invoice_NonPOBasedInvoiceForm : btnUpdate_Click] An error occured in the processing of Record Id : " + nonPOBasedInvoiceFormUI.Tbl_NonPOBasedInvoiceId + ". Details : [" + exp.ToString() + "]");
}
}
public int AddNonPOBasedInvoice(NonPOBasedInvoiceFormUI nonPOBasedInvoiceFormUI)
{
int result = 0;
try
{
using (SqlConnection SupportCon = new SqlConnection(connectionString))
{
SupportCon.Open();
SqlCommand sqlCmd = new SqlCommand("SP_NonPOBasedInvoice_Insert", SupportCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandTimeout = commandTimeout;
sqlCmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar);
sqlCmd.Parameters["@CreatedBy"].Value = nonPOBasedInvoiceFormUI.CreatedBy;
sqlCmd.Parameters.Add("@tbl_OrganizationId", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_OrganizationId"].Value = nonPOBasedInvoiceFormUI.Tbl_OrganizationId;
sqlCmd.Parameters.Add("@VoucherNumber", SqlDbType.NVarChar);
sqlCmd.Parameters["@VoucherNumber"].Value = nonPOBasedInvoiceFormUI.VoucherNumber;
sqlCmd.Parameters.Add("@InterCompany", SqlDbType.Bit);
sqlCmd.Parameters["@InterCompany"].Value = nonPOBasedInvoiceFormUI.InterCompany;
sqlCmd.Parameters.Add("@tbl_BatchId", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_BatchId"].Value = nonPOBasedInvoiceFormUI.Tbl_BatchId;
sqlCmd.Parameters.Add("@Opt_DocumentType", SqlDbType.TinyInt);
sqlCmd.Parameters["@Opt_DocumentType"].Value = nonPOBasedInvoiceFormUI.Opt_DocumentType;
sqlCmd.Parameters.Add("@DocumentDate", SqlDbType.DateTime);
sqlCmd.Parameters["@DocumentDate"].Value = nonPOBasedInvoiceFormUI.DocumentDate;
//sqlCmd.Parameters.Add("@DocumentDate_Hijri", SqlDbType.BigInt);
//sqlCmd.Parameters["@DocumentDate_Hijri"].Value = nonPOBasedInvoiceFormUI.DocumentDate_Hijri;
sqlCmd.Parameters.Add("@Description", SqlDbType.NVarChar);
sqlCmd.Parameters["@Description"].Value = nonPOBasedInvoiceFormUI.Description;
sqlCmd.Parameters.Add("@PostingDate", SqlDbType.DateTime);
sqlCmd.Parameters["@PostingDate"].Value = nonPOBasedInvoiceFormUI.PostingDate;
//sqlCmd.Parameters.Add("@PostingDate_Hijri", SqlDbType.BigInt);
//sqlCmd.Parameters["@PostingDate_Hijri"].Value = nonPOBasedInvoiceFormUI.PostingDate_Hijri;
sqlCmd.Parameters.Add("@InvoiceDate", SqlDbType.DateTime);
sqlCmd.Parameters["@InvoiceDate"].Value = nonPOBasedInvoiceFormUI.InvoiceDate;
//sqlCmd.Parameters.Add("@InvoiceDate_Hijri", SqlDbType.BigInt);
//sqlCmd.Parameters["@InvoiceDate_Hijri"].Value = nonPOBasedInvoiceFormUI.InvoiceDate_Hijri;
sqlCmd.Parameters.Add("@ReceivedDate", SqlDbType.DateTime);
sqlCmd.Parameters["@ReceivedDate"].Value = nonPOBasedInvoiceFormUI.ReceivedDate;
//sqlCmd.Parameters.Add("@ReceivedDate_Hijri", SqlDbType.BigInt);
//sqlCmd.Parameters["@ReceivedDate_Hijri"].Value = nonPOBasedInvoiceFormUI.ReceivedDate_Hijri;
sqlCmd.Parameters.Add("@tbl_SupplierId", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_SupplierId"].Value = nonPOBasedInvoiceFormUI.Tbl_SupplierId;
sqlCmd.Parameters.Add("@tbl_CurrencyId", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_CurrencyId"].Value = nonPOBasedInvoiceFormUI.Tbl_CurrencyId;
sqlCmd.Parameters.Add("@DocumentNumber", SqlDbType.NVarChar);
sqlCmd.Parameters["@DocumentNumber"].Value = nonPOBasedInvoiceFormUI.DocumentNumber;
sqlCmd.Parameters.Add("@PONumber", SqlDbType.NVarChar);
sqlCmd.Parameters["@PONumber"].Value = nonPOBasedInvoiceFormUI.PONumber;
sqlCmd.Parameters.Add("@tbl_PaymentTermsId", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_PaymentTermsId"].Value = nonPOBasedInvoiceFormUI.Tbl_PaymentTermsId;
sqlCmd.Parameters.Add("@Purchase", SqlDbType.Decimal);
sqlCmd.Parameters["@Purchase"].Value = nonPOBasedInvoiceFormUI.Purchase;
sqlCmd.Parameters.Add("@TradeDiscount", SqlDbType.Decimal);
sqlCmd.Parameters["@TradeDiscount"].Value = nonPOBasedInvoiceFormUI.TradeDiscount;
sqlCmd.Parameters.Add("@Freight", SqlDbType.Decimal);
sqlCmd.Parameters["@Freight"].Value = nonPOBasedInvoiceFormUI.Freight;
sqlCmd.Parameters.Add("@Total", SqlDbType.Decimal);
sqlCmd.Parameters["@Total"].Value = nonPOBasedInvoiceFormUI.Total;
sqlCmd.Parameters.Add("@tbl_PayablesId_BankTransfer", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_PayablesId_BankTransfer"].Value = nonPOBasedInvoiceFormUI.Tbl_PayablesId_BankTransfer;
sqlCmd.Parameters.Add("@BankTransferAmount", SqlDbType.Decimal);
sqlCmd.Parameters["@BankTransferAmount"].Value = nonPOBasedInvoiceFormUI.BankTransferAmount;
sqlCmd.Parameters.Add("@tbl_PayablesId_Cash", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_PayablesId_Cash"].Value = nonPOBasedInvoiceFormUI.Tbl_PayablesId_Cash;
sqlCmd.Parameters.Add("@CashAmount", SqlDbType.Decimal);
sqlCmd.Parameters["@CashAmount"].Value = nonPOBasedInvoiceFormUI.CashAmount;
sqlCmd.Parameters.Add("@tbl_PayablesId_Cheque", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_PayablesId_Cheque"].Value = nonPOBasedInvoiceFormUI.Tbl_PayablesId_Cheque;
sqlCmd.Parameters.Add("@ChequeAmount", SqlDbType.Decimal);
sqlCmd.Parameters["@ChequeAmount"].Value = nonPOBasedInvoiceFormUI.ChequeAmount;
sqlCmd.Parameters.Add("@tbl_PayablesId_CreditCard", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_PayablesId_CreditCard"].Value = nonPOBasedInvoiceFormUI.Tbl_PayablesId_CreditCard;
sqlCmd.Parameters.Add("@CreditCardAmount", SqlDbType.Decimal);
sqlCmd.Parameters["@CreditCardAmount"].Value = nonPOBasedInvoiceFormUI.CreditCardAmount;
sqlCmd.Parameters.Add("@OnAccount", SqlDbType.Decimal);
sqlCmd.Parameters["@OnAccount"].Value = nonPOBasedInvoiceFormUI.OnAccount;
result = sqlCmd.ExecuteNonQuery();
sqlCmd.Dispose();
SupportCon.Close();
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "AddNonPOBasedInvoice()";
logExcpUIobj.ResourceName = "NonPOBasedInvoiceFormDAL.CS";
logExcpUIobj.RecordId = "";
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[NonPOBasedInvoiceFormDAL : AddNonPOBasedInvoice] An error occured in the processing of Record. Details : [" + exp.ToString() + "]");
}
return(result);
}
