public List <AuditAccountType> GetAccountsTypeData() { List <AuditAccountType> accountTypesData = new List <AuditAccountType>(); try { var database = SingletonDb.Instance.GetDBConnection(); object[] parameterValues = new object[] { }; DbCommand cmd = database.GetStoredProcCommand("dbo.AccountType_sp_Select", parameterValues); using (IDataReader reader = database.ExecuteReader(cmd)) { while (reader.Read()) { AuditAccountType accountTypeInfo = new AuditAccountType(); accountTypeInfo.AccountId = reader.GetInt32(0); accountTypeInfo.AccountTypeCode = !reader.IsDBNull(reader.GetOrdinal("vc_AccountTypeCode")) ? reader.GetString(1) : string.Empty; accountTypeInfo.AccountType = !reader.IsDBNull(reader.GetOrdinal("vc_AccountType")) ? reader.GetString(2) : string.Empty; accountTypeInfo.Limit = !reader.IsDBNull(reader.GetOrdinal("dc_LimitAmount")) ? reader.GetString(3) : string.Empty; accountTypesData.Add(accountTypeInfo); } } } catch (Exception ex) { } return(accountTypesData); }
public void AddAuditAccountType(AuditAccountType accountType) { try { var database = SingletonDb.Instance.GetDBConnection(); object[] parameterValues = new object[] { accountType.AccountType, accountType.AccountTypeCode, accountType.Limit }; DbCommand cmd = database.GetStoredProcCommand("dbo.AccountType_sp_Insert", parameterValues); database.ExecuteNonQuery(cmd); } catch (Exception ex) { } }
public void AddAuditAccountType(AuditAccountType accountType) { AuditDetailsDal auditDetails = new AuditDetailsDal(); auditDetails.AddAuditAccountType(accountType); }