public int DeleteGLAccount(GLAccountListUI gLAccountListUI) { int result = 0; result = gLAccountListDAL.DeleteGLAccount(gLAccountListUI); return(result); }
private void SearchGLAccountList() { try { GLAccountListBAL gLAccountListBAL = new GLAccountListBAL(); GLAccountListUI gLAccountListUI = new GLAccountListUI(); gLAccountListUI.Search = txtGLAccountSearch.Text; DataTable dtb = gLAccountListBAL.GetGLAccountListBySearchParameters(gLAccountListUI); if (dtb.Rows.Count > 0 && dtb != null) { gvGLAccountSearch.DataSource = dtb; gvGLAccountSearch.DataBind(); divGLAccountSearchError.Visible = false; } else { divGLAccountSearchError.Visible = true; lblGLAccountSearchError.Text = Resources.GlobalResource.msgNoRecordFound; gvGLAccountSearch.Visible = false; } } catch (Exception exp) { logExcpUIobj.MethodName = "SearchGLAccountList()"; logExcpUIobj.ResourceName = "Finance_Accounts_Payable_Non_PO_Based_Invoice_NonPOBasedInvoiceDistributionForm.CS"; logExcpUIobj.RecordId = "All"; logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString(); logExcpDALobj.SaveExceptionToDB(logExcpUIobj); log.Error("[Finance_Accounts_Payable_Non_PO_Based_Invoice_NonPOBasedInvoiceDistributionForm : SearchPaymentTermsList] An error occured in the processing of Record. Details : [" + exp.ToString() + "]"); } }
public DataTable GetGLAccountListBySearchParameters(GLAccountListUI gLAccountListUI) { DataTable dtb = new DataTable(); dtb = gLAccountListDAL.GetGLAccountListBySearchParameters(gLAccountListUI); return(dtb); }
public DataTable GetGLAccountListById(GLAccountListUI gLAccountListUI) { DataTable dtb = new DataTable(); dtb = gLAccountListDAL.GetGLAccountListById(gLAccountListUI); return(dtb); }
private void BindListBySearchParameters(GLAccountListUI gLAccountListUI) { try { DataTable dtb = gLAccountListBAL.GetGLAccountListBySearchParameters(this.gLAccountListUI); if (dtb.Rows.Count > 0 && dtb != null) { gvData.DataSource = dtb; gvData.DataBind(); divError.Visible = false; gvData.Visible = true; } else { divError.Visible = true; gvData.Visible = false; lblError.Text = Resources.GlobalResource.msgNoRecordFound; } txtSearch.Text = ""; txtSearch.Focus(); } catch (Exception exp) { logExcpUIobj.MethodName = "BindListBySearchParameters()"; logExcpUIobj.ResourceName = "Finance_General_Ledger_GL_Integration_GLAccountList.CS"; logExcpUIobj.RecordId = "All"; logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString(); logExcpDALobj.SaveExceptionToDB(logExcpUIobj); log.Error("[Finance_General_Ledger_GL_Integration_GLAccountList : BindListBySearchParameters] An error occured in the processing of Record. Details : [" + exp.ToString() + "]"); } }
private void SearchAccuralDifferedA_CList() { try { GLAccountListUI gLAccountListUI = new GLAccountListUI(); gLAccountListUI.Search = txtAccuralDifferedA_CSearch.Text; DataTable dtb = gLAccountListBAL.GetGLAccountListBySearchParameters(gLAccountListUI); if (dtb.Rows.Count > 0 && dtb != null) { gvAccuralDifferedA_CSearch.DataSource = dtb; gvAccuralDifferedA_CSearch.DataBind(); divAccuralDifferedA_CSearchError.Visible = false; } else { divAccuralDifferedA_CSearchError.Visible = true; lblAccuralDifferedA_CSearchError.Text = Resources.GlobalResource.msgNoRecordFound; gvAccuralDifferedA_CSearch.Visible = false; } } catch (Exception exp) { logExcpUIobj.MethodName = "SearchAccuralDifferedA_CList()"; logExcpUIobj.ResourceName = "Finance_Accounts_Receivable_Customer_Master_Creation_CustomerAndGroupAccount.CS"; logExcpUIobj.RecordId = "All"; logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString(); logExcpDALobj.SaveExceptionToDB(logExcpUIobj); log.Error("[Finance_Accounts_Receivable_Customer_Master_Creation_CustomerAndGroupAccount : SearchAccuralDifferedA_CList] An error occured in the processing of Record. Details : [" + exp.ToString() + "]"); } }
public DataTable GetGLAccountListById(GLAccountListUI gLAccountListUI) { DataSet ds = new DataSet(); DataTable dtbl = new DataTable(); //Boolean result = false; try { using (SqlConnection SupportCon = new SqlConnection(connectionString)) { SqlCommand sqlCmd = new SqlCommand("SP_GLAccount_SelectById", SupportCon); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandTimeout = commandTimeout; sqlCmd.Parameters.Add("@tbl_GLAccountId", SqlDbType.NVarChar); sqlCmd.Parameters["@tbl_GLAccountId"].Value = gLAccountListUI.Tbl_GLAccountId; using (SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd)) { adapter.Fill(ds); } } if (ds.Tables.Count > 0) { dtbl = ds.Tables[0]; } } catch (Exception exp) { logExcpUIobj.MethodName = "getGLAccountListById()"; logExcpUIobj.ResourceName = "GLAccountListDAL.CS"; logExcpUIobj.RecordId = gLAccountListUI.Tbl_GLAccountId; logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString(); logExcpDALobj.SaveExceptionToDB(logExcpUIobj); log.Error("[GLAccountListDAL : getGLAccountListById] An error occured in the processing of Record Id : " + gLAccountListUI.Tbl_GLAccountId + ". Details : [" + exp.ToString() + "]"); } finally { ds.Dispose(); } return(dtbl); }
public int DeleteGLAccount(GLAccountListUI gLAccountListUI) { int result = 0; try { using (SqlConnection SupportCon = new SqlConnection(connectionString)) { SupportCon.Open(); SqlCommand sqlCmd = new SqlCommand("SP_GLAccount_Delete", SupportCon); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandTimeout = commandTimeout; sqlCmd.Parameters.Add("@tbl_GLAccountId", SqlDbType.NVarChar); sqlCmd.Parameters["@tbl_GLAccountId"].Value = gLAccountListUI.Tbl_GLAccountId; result = sqlCmd.ExecuteNonQuery(); sqlCmd.Dispose(); SupportCon.Close(); } } catch (Exception exp) { logExcpUIobj.MethodName = "DeleteGLAccount()"; logExcpUIobj.ResourceName = "GLAccountListDAL.CS"; logExcpUIobj.RecordId = gLAccountListUI.Tbl_GLAccountId; logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString(); logExcpDALobj.SaveExceptionToDB(logExcpUIobj); log.Error("[GLAccountListDAL : DeleteGLAccount] An error occured in the processing of Record Id : " + gLAccountListUI.Tbl_GLAccountId + ". Details : [" + exp.ToString() + "]"); } return(result); }
private void SearchClearingList() { { try { GLAccountListUI gLAccountListUI = new GLAccountListUI(); gLAccountListUI.Search = txtClearingSearch.Text; DataTable dtb = gLAccountListBAL.GetGLAccountListBySearchParameters(gLAccountListUI); if (dtb.Rows.Count > 0 && dtb != null) { gvClearingSearch.DataSource = dtb; gvClearingSearch.DataBind(); divClearingSearchError.Visible = false; } else { divClearingSearchError.Visible = true; lblClearingSearchError.Text = Resources.GlobalResource.msgNoRecordFound; gvClearingSearch.Visible = false; } } catch (Exception exp) { logExcpUIobj.MethodName = "SearchClearingList()"; logExcpUIobj.ResourceName = "Assets_AssetAndGroupAccount_AssetAndGroupAccountForm.CS"; logExcpUIobj.RecordId = "All"; logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString(); logExcpDALobj.SaveExceptionToDB(logExcpUIobj); log.Error("[Assets_AssetAndGroupAccount_AssetAndGroupAccountForm : SearchClearingList] An error occured in the processing of Record. Details : [" + exp.ToString() + "]"); } } }