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);
}
