protected override void Page_Load(object sender, EventArgs e) { EmployeeGeneralExpensesFormUI employeeGeneralExpensesFormUI = new EmployeeGeneralExpensesFormUI(); if (!Page.IsPostBack) { if (Request.QueryString["EmployeeGeneralExpensesId"] != null) { employeeGeneralExpensesFormUI.Tbl_EmployeeGeneralExpensesId = Request.QueryString["EmployeeGeneralExpensesId"]; BindDocumentTypeDropDownList(); FillForm(employeeGeneralExpensesFormUI); btnSave.Visible = false; btnClear.Visible = false; btnUpdate.Visible = true; btnDelete.Visible = true; lblHeading.Text = "Update EmployeeGeneralExpenses"; } else { BindDocumentTypeDropDownList(); btnSave.Visible = true; btnClear.Visible = true; btnUpdate.Visible = false; btnDelete.Visible = false; lblHeading.Text = "Add New EmployeeGeneralExpenses"; } } }
public int DeleteEmployeeGeneralExpenses(EmployeeGeneralExpensesFormUI employeeGeneralExpensesFormUI) { int resutl = 0; resutl = employeeGeneralExpensesFormDAL.DeleteEmployeeGeneralExpenses(employeeGeneralExpensesFormUI); return(resutl); }
public DataTable GetEmployeeGeneralExpensesListById(EmployeeGeneralExpensesFormUI employeeGeneralExpensesFormUI) { DataTable dtb = new DataTable(); dtb = employeeGeneralExpensesFormDAL.GetEmployeeGeneralExpensesListById(employeeGeneralExpensesFormUI); return(dtb); }
private void FillForm(EmployeeGeneralExpensesFormUI employeeGeneralExpensesFormUI) { try { DataTable dtb = employeeGeneralExpensesFormBAL.GetEmployeeGeneralExpensesListById(employeeGeneralExpensesFormUI); if (dtb.Rows.Count > 0) { txtVoucherNumber.Text = dtb.Rows[0]["VoucherNumber"].ToString(); chckInterCompany.Checked = Convert.ToBoolean(dtb.Rows[0]["InterCompany"].ToString()); txtBatchIdGuid.Text = dtb.Rows[0]["tbl_BatchId"].ToString(); txtBatchId.Text = dtb.Rows[0]["BatchName"].ToString(); ddlOpt_DocumentType.SelectedValue = dtb.Rows[0]["Opt_DocumentType"].ToString(); txtDocumentDate.Text = commonDateClasses.DateInTextBox(dtb.Rows[0]["DocumentDate"].ToString()); txtDescription.Text = dtb.Rows[0]["Description"].ToString(); txtPostingDate.Text = commonDateClasses.DateInTextBox(dtb.Rows[0]["PostingDate"].ToString()); txtInvoiceDate.Text = commonDateClasses.DateInTextBox(dtb.Rows[0]["InvoiceDate"].ToString()); txtReceivedDate.Text = commonDateClasses.DateInTextBox(dtb.Rows[0]["ReceivedDate"].ToString()); txtEmployeeIdGuid.Text = dtb.Rows[0]["tbl_EmployeeId"].ToString(); txtEmployeeId.Text = dtb.Rows[0]["EmployeeName"].ToString(); txtCurrencyGuid.Text = dtb.Rows[0]["tbl_CurrencyId"].ToString(); txtCurrency.Text = dtb.Rows[0]["CurrencyName"].ToString(); txtExpenses.Text = dtb.Rows[0]["Expenses"].ToString(); txtPayablesBankGuid.Text = dtb.Rows[0]["tbl_Payables_BankTransfer"].ToString(); txtPayablesBank.Text = dtb.Rows[0]["BankName"].ToString(); txtBankTransferAmount.Text = dtb.Rows[0]["BankTransferAmount"].ToString(); txtPayablesCashGuid.Text = dtb.Rows[0]["tbl_Payables_Cash"].ToString(); txtPayablesCash.Text = dtb.Rows[0]["PayablesTypeCash"].ToString(); txtCash.Text = dtb.Rows[0]["Cash"].ToString(); txtPayablesChequeGuid.Text = dtb.Rows[0]["tbl_Payables_Cheque"].ToString(); txtPayablesCheque.Text = dtb.Rows[0]["ProcessTypeCheque"].ToString(); txtCheque.Text = dtb.Rows[0]["Cheque"].ToString(); txtPayablesCreditCardGuid.Text = dtb.Rows[0]["tbl_Payables_CreditCard"].ToString(); txtPayablesCreditCard.Text = dtb.Rows[0]["CardName"].ToString(); txtCreditCard.Text = dtb.Rows[0]["CreditCard"].ToString(); txtOnAmount.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_Employee_General_Expenses_EmployeeGeneralExpensesForm.CS"; logExcpUIobj.RecordId = employeeGeneralExpensesFormUI.Tbl_EmployeeGeneralExpensesId; logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString(); logExcpDALobj.SaveExceptionToDB(logExcpUIobj); log.Error("[Finance_Accounts_Payable_Employee_General_Expenses_EmployeeGeneralExpensesForm : FillForm] An error occured in the processing of Record Details : [" + exp.ToString() + "]"); } }
public DataTable GetEmployeeGeneralExpensesListById(EmployeeGeneralExpensesFormUI employeeGeneralExpensesFormUI) { DataSet ds = new DataSet(); DataTable dtbl = new DataTable(); try { using (SqlConnection SupportCon = new SqlConnection(connectionString)) { SqlCommand sqlCmd = new SqlCommand("SP_EmployeeGeneralExpenses_SelectById", SupportCon); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandTimeout = commandTimeout; sqlCmd.Parameters.Add("@tbl_EmployeeGeneralExpensesId", SqlDbType.NVarChar); sqlCmd.Parameters["@tbl_EmployeeGeneralExpensesId"].Value = employeeGeneralExpensesFormUI.Tbl_EmployeeGeneralExpensesId; using (SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd)) { adapter.Fill(ds); } } if (ds.Tables.Count > 0) { dtbl = ds.Tables[0]; } } catch (Exception exp) { logExcpUIobj.MethodName = "GetEmployeeGeneralExpensesListById()"; logExcpUIobj.ResourceName = "EmployeeGeneralExpensesFormDAL.CS"; logExcpUIobj.RecordId = employeeGeneralExpensesFormUI.Tbl_EmployeeGeneralExpensesId; logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString(); logExcpDALobj.SaveExceptionToDB(logExcpUIobj); log.Error("[EmployeeGeneralExpensesFormDAL : GetEmployeeGeneralExpensesListById] An error occured in the processing of Record Id : " + employeeGeneralExpensesFormUI.Tbl_EmployeeGeneralExpensesId + ". Details : [" + exp.ToString() + "]"); } finally { ds.Dispose(); } return(dtbl); }
public int DeleteEmployeeGeneralExpenses(EmployeeGeneralExpensesFormUI employeeGeneralExpensesFormUI) { int result = 0; try { using (SqlConnection SupportCon = new SqlConnection(connectionString)) { SupportCon.Open(); SqlCommand sqlCmd = new SqlCommand("SP_EmployeeGeneralExpenses_Delete", SupportCon); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandTimeout = commandTimeout; sqlCmd.Parameters.Add("@tbl_EmployeeGeneralExpensesId", SqlDbType.NVarChar); sqlCmd.Parameters["@tbl_EmployeeGeneralExpensesId"].Value = employeeGeneralExpensesFormUI.Tbl_EmployeeGeneralExpensesId; result = sqlCmd.ExecuteNonQuery(); sqlCmd.Dispose(); SupportCon.Close(); } } catch (Exception exp) { logExcpUIobj.MethodName = "DeleteEmployeeGeneralExpenses()"; logExcpUIobj.ResourceName = "EmployeeGeneralExpensesFormDAL.CS"; logExcpUIobj.RecordId = employeeGeneralExpensesFormUI.Tbl_EmployeeGeneralExpensesId; logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString(); logExcpDALobj.SaveExceptionToDB(logExcpUIobj); log.Error("[EmployeeGeneralExpensesFormDAL : DeleteEmployeeGeneralExpenses] An error occured in the processing of Record Id : " + employeeGeneralExpensesFormUI.Tbl_EmployeeGeneralExpensesId + ". Details : [" + exp.ToString() + "]"); } return(result); }
public int AddEmployeeGeneralExpenses(EmployeeGeneralExpensesFormUI employeeGeneralExpensesFormUI) { int result = 0; try { using (SqlConnection SupportCon = new SqlConnection(connectionString)) { SupportCon.Open(); SqlCommand sqlCmd = new SqlCommand("SP_EmployeeGeneralExpenses_Insert", SupportCon); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandTimeout = commandTimeout; sqlCmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar); sqlCmd.Parameters["@CreatedBy"].Value = employeeGeneralExpensesFormUI.CreatedBy; sqlCmd.Parameters.Add("@tbl_OrganizationId", SqlDbType.NVarChar); sqlCmd.Parameters["@tbl_OrganizationId"].Value = employeeGeneralExpensesFormUI.Tbl_OrganizationId; sqlCmd.Parameters.Add("@VoucherNumber", SqlDbType.NVarChar); sqlCmd.Parameters["@VoucherNumber"].Value = employeeGeneralExpensesFormUI.VoucherNumber; sqlCmd.Parameters.Add("@InterCompany", SqlDbType.Bit); sqlCmd.Parameters["@InterCompany"].Value = employeeGeneralExpensesFormUI.InterCompany; sqlCmd.Parameters.Add("@tbl_BatchId", SqlDbType.NVarChar); sqlCmd.Parameters["@tbl_BatchId"].Value = employeeGeneralExpensesFormUI.Tbl_BatchId; sqlCmd.Parameters.Add("@Opt_DocumentType", SqlDbType.TinyInt); sqlCmd.Parameters["@Opt_DocumentType"].Value = employeeGeneralExpensesFormUI.Opt_DocumentType; sqlCmd.Parameters.Add("@DocumentDate", SqlDbType.DateTime); sqlCmd.Parameters["@DocumentDate"].Value = employeeGeneralExpensesFormUI.DocumentDate; //sqlCmd.Parameters.Add("@DocumentDate_Hijri", SqlDbType.BigInt); //sqlCmd.Parameters["@DocumentDate_Hijri"].Value = employeeGeneralExpensesFormUI.DocumentDate_Hijri; sqlCmd.Parameters.Add("@Description", SqlDbType.NVarChar); sqlCmd.Parameters["@Description"].Value = employeeGeneralExpensesFormUI.Description; sqlCmd.Parameters.Add("@PostingDate", SqlDbType.DateTime); sqlCmd.Parameters["@PostingDate"].Value = employeeGeneralExpensesFormUI.PostingDate; //sqlCmd.Parameters.Add("@PostingDate_Hijri", SqlDbType.BigInt); //sqlCmd.Parameters["@PostingDate_Hijri"].Value = employeeGeneralExpensesFormUI.PostingDate_Hijri; sqlCmd.Parameters.Add("@InvoiceDate", SqlDbType.DateTime); sqlCmd.Parameters["@InvoiceDate"].Value = employeeGeneralExpensesFormUI.InvoiceDate; //sqlCmd.Parameters.Add("@InvoiceDate_Hijri", SqlDbType.BigInt); //sqlCmd.Parameters["@InvoiceDate_Hijri"].Value = employeeGeneralExpensesFormUI.InvoiceDate_Hijri; sqlCmd.Parameters.Add("@ReceivedDate", SqlDbType.DateTime); sqlCmd.Parameters["@ReceivedDate"].Value = employeeGeneralExpensesFormUI.ReceivedDate; //sqlCmd.Parameters.Add("@ReceivedDate_Hijri", SqlDbType.BigInt); //sqlCmd.Parameters["@ReceivedDate_Hijri"].Value = employeeGeneralExpensesFormUI.ReceivedDate_Hijri; sqlCmd.Parameters.Add("@tbl_EmployeeId", SqlDbType.NVarChar); sqlCmd.Parameters["@tbl_EmployeeId"].Value = employeeGeneralExpensesFormUI.Tbl_EmployeeId; sqlCmd.Parameters.Add("@tbl_CurrencyId", SqlDbType.NVarChar); sqlCmd.Parameters["@tbl_CurrencyId"].Value = employeeGeneralExpensesFormUI.Tbl_CurrencyId; sqlCmd.Parameters.Add("@Expenses", SqlDbType.Decimal); sqlCmd.Parameters["@Expenses"].Value = employeeGeneralExpensesFormUI.Expenses; sqlCmd.Parameters.Add("@tbl_Payables_BankTransfer", SqlDbType.NVarChar); sqlCmd.Parameters["@tbl_Payables_BankTransfer"].Value = employeeGeneralExpensesFormUI.Tbl_Payables_BankTransfer; sqlCmd.Parameters.Add("@BankTransferAmount", SqlDbType.Decimal); sqlCmd.Parameters["@BankTransferAmount"].Value = employeeGeneralExpensesFormUI.BankTransferAmount; sqlCmd.Parameters.Add("@tbl_Payables_Cash", SqlDbType.NVarChar); sqlCmd.Parameters["@tbl_Payables_Cash"].Value = employeeGeneralExpensesFormUI.Tbl_Payables_Cash; sqlCmd.Parameters.Add("@Cash", SqlDbType.Decimal); sqlCmd.Parameters["@Cash"].Value = employeeGeneralExpensesFormUI.Cash; sqlCmd.Parameters.Add("@tbl_Payables_Cheque", SqlDbType.NVarChar); sqlCmd.Parameters["@tbl_Payables_Cheque"].Value = employeeGeneralExpensesFormUI.Tbl_Payables_Cheque; sqlCmd.Parameters.Add("@Cheque", SqlDbType.Decimal); sqlCmd.Parameters["@Cheque"].Value = employeeGeneralExpensesFormUI.Cheque; sqlCmd.Parameters.Add("@tbl_Payables_CreditCard", SqlDbType.NVarChar); sqlCmd.Parameters["@tbl_Payables_CreditCard"].Value = employeeGeneralExpensesFormUI.Tbl_Payables_CreditCard; sqlCmd.Parameters.Add("@CreditCard", SqlDbType.Decimal); sqlCmd.Parameters["@CreditCard"].Value = employeeGeneralExpensesFormUI.CreditCard; sqlCmd.Parameters.Add("@OnAccount", SqlDbType.Decimal); sqlCmd.Parameters["@OnAccount"].Value = employeeGeneralExpensesFormUI.OnAccount; result = sqlCmd.ExecuteNonQuery(); sqlCmd.Dispose(); SupportCon.Close(); } } catch (Exception exp) { logExcpUIobj.MethodName = "AddEmployeeGeneralExpenses()"; logExcpUIobj.ResourceName = "EmployeeGeneralExpensesFormDAL.CS"; logExcpUIobj.RecordId = ""; logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString(); logExcpDALobj.SaveExceptionToDB(logExcpUIobj); log.Error("[EmployeeGeneralExpensesFormDAL : AddEmployeeGeneralExpenses] An error occured in the processing of Record. Details : [" + exp.ToString() + "]"); } return(result); }