public static int DeleteAccount(tChartOfAccount account) { try { return(AccountingDataProvider.DeleteAccount(account)); } catch (Exception exception) { throw new Exception(exception.Message); } }
public static int DeleteAccount(tChartOfAccount account) { int rowsAdded; using (IDbConnection connection = DbConnectionHelper.GetConnection()) { var query = new StringBuilder("DELETE FROM tChartOfAccount WHERE CompanyID = @CompanyID and AccountCode=@AccountCode"); rowsAdded = connection.Execute(query.ToString(), account); } return(rowsAdded); }
public static int UpdateAccount(tChartOfAccount account) { int rowsAdded; using (IDbConnection connection = DbConnectionHelper.GetConnection()) { var query = new StringBuilder( "UPDATE tChartOfAccount SET AccountName = @AccountName, "); query.Append("AccountType = @AccountType, SumFrom = @SumFrom, TaxCode = @TaxCode WHERE CompanyID = @CompanyID and AccountCode=@AccountCode"); rowsAdded = connection.Execute(query.ToString(), account); } return(rowsAdded); }
public static int AddAccount(tChartOfAccount account) { int rowsAdded; using (IDbConnection connection = DbConnectionHelper.GetConnection()) { var query = new StringBuilder( "INSERT INTO tChartOfAccount(CompanyID,AccountCode, AccountName, AccountType, SumFrom, TaxCode)"); query.Append("VALUES(@CompanyID,@AccountCode, @AccountName, @AccountType, @SumFrom, @TaxCode)"); rowsAdded = connection.Execute(query.ToString(), account); } return(rowsAdded); }
private tChartOfAccount ChartOfAccountBuilder() { var chartOfAccount = new tChartOfAccount { CompanyId = ShatedData.ApplicationState.SelectedCompanyId, AccountCode = Convert.ToInt16(txtAccountCode.Text), AccountName = txtAccountText.Text, AccountType = cboAccountType.SelectedIndex, }; if (cboSummaryFrom.SelectedValue != null) { if (cboSummaryFrom.SelectedIndex != 0) { var findIndex = cboSummaryFrom.SelectedValue.ToString().IndexOf("|", 0); if (findIndex != -1) { int accountCode = Convert.ToInt16(cboSummaryFrom.SelectedValue.ToString().Substring(0, findIndex)); chartOfAccount.SumFrom = accountCode; } } } if (cboTax.SelectedValue != null) { if (cboTax.SelectedIndex != 0) { var findIndex = cboTax.SelectedValue.ToString().IndexOf("|", 0); if (findIndex != -1) { string taxCode = Convert.ToString(cboTax.SelectedValue.ToString().Substring(0, findIndex)); chartOfAccount.TaxCode = taxCode; } } } return(chartOfAccount); }