public SmartCollection<ClientPricing> GetClientPricings(int ClientId) { try { SmartCollection<ClientPricing> resultList = new SmartCollection<ClientPricing>(); using (DbConnection = new MsSqlPersistence(DbConnectionSettings)) { if (DbConnection.IsConnected()) { using (DbCommand) { dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.CommandText = "uspGetClientPricings"; dbCommand.Parameters.Clear(); dbCommand.Parameters.Add("@ClientId", System.Data.SqlDbType.Int).Value = ClientId; DataTable returnDT = DbConnection.ExecuteQuery(DbCommand); foreach (DataRow row in returnDT.Rows) { ClientPricing price = new ClientPricing(); price.ClientPricingId = Convert.ToInt32(row["ClientPricingID"]); price.ClientId = Convert.ToInt32(row["ClientID"]); if (row["MethodID"] != DBNull.Value) price.MethodId = Convert.ToInt32(row["MethodID"]); if (row["MethodNumberID"] != DBNull.Value) price.MethodNumberId = Convert.ToInt32(row["MethodNumberID"]); if (row["AnalyteID"] != DBNull.Value) price.AnalyteId = Convert.ToInt32(row["AnalyteID"]); price.Description = row["Description"].ToString(); price.Discount = row["Discount"] != DBNull.Value ? Convert.ToDouble(row["Discount"]) : 0; price.FlatRate = row["FlatRate"] != DBNull.Value ? Convert.ToDouble(row["FlatRate"]) : 0; price.CreatedBy = row["CreatedBy"] != DBNull.Value ? Convert.ToInt32(row["CreatedBy"]) : new Int32(); price.CreatedUser = row["CreatedUser"].ToString(); price.CreatedDate = row["CreatedDate"] != DBNull.Value ? (DateTime)row["CreatedDate"] : (DateTime)SqlDateTime.Null; price.ModifiedBy = row["ModifiedBy"] != DBNull.Value ? Convert.ToInt32(row["ModifiedBy"]) : new Int32(); price.ModifiedUser = row["ModifiedUser"].ToString(); price.ModifiedDate = row["ModifiedDate"] != DBNull.Value ? (DateTime)row["ModifiedDate"] : (DateTime)SqlDateTime.Null; if (price.MethodId.HasValue) price.Method = new Method { MethodId = price.MethodId, MethodName = row["MethodName"].ToString() }; else price.Method = null; if (price.MethodNumberId.HasValue) price.MethodNumber = new MethodNumber { MethodNumberId = price.MethodNumberId, MethodNumberName = row["MethodNumberName"].ToString() }; else price.MethodNumber = null; if (price.AnalyteId.HasValue) price.AnalyteItem = new Analyte { AnalyteId = price.AnalyteId, AnalyteName = row["AnalyteName"].ToString() }; else price.AnalyteItem = null; resultList.Add(price); } returnDT = null; } }else { throw new Exception("Unable to Connect"); } } return resultList; }catch { throw; } }
public ClientPricing GetClientPricing(int clientPricingId) { try { ClientPricing price = new ClientPricing(); if (dbConnection.IsConnected()) { dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.CommandText = "uspGetClientPricing"; dbCommand.Parameters.Clear(); dbCommand.Parameters.Add("@ClientPricingId", System.Data.SqlDbType.Int).Value = clientPricingId; DataTable returnDT = dbConnection.ExecuteQuery(dbCommand); if (returnDT.Rows.Count == 1) { DataRow row = returnDT.Rows[0]; price.ClientPricingId = Convert.ToInt32(row["ClientPricingID"]); price.ClientId = Convert.ToInt32(row["ClientID"]); if (row["MethodID"] != DBNull.Value) price.MethodId = Convert.ToInt32(row["MethodID"]); if (row["MethodNumberID"] != DBNull.Value) price.MethodNumberId = Convert.ToInt32(row["MethodNumberID"]); if (row["AnalyteID"] != DBNull.Value) price.AnalyteId = Convert.ToInt32(row["AnalyteID"]); price.Description = row["Description"].ToString(); price.Discount = row["Discount"] != DBNull.Value ? Convert.ToDouble(row["Discount"]) : 0.000; price.FlatRate = row["FlatRate"] != DBNull.Value ? Convert.ToDouble(row["FlatRate"]) : 0.00; price.CreatedBy = row["CreatedBy"] != DBNull.Value ? Convert.ToInt32(row["CreatedBy"]) : new Int32(); price.CreatedUser = row["CreatedUser"].ToString(); price.CreatedDate = row["CreatedDate"] != DBNull.Value ? (DateTime)row["CreatedDate"] : (DateTime)SqlDateTime.Null; price.ModifiedBy = row["ModifiedBy"] != DBNull.Value ? Convert.ToInt32(row["ModifiedBy"]) : new Int32(); price.ModifiedUser = row["ModifiedUser"].ToString(); price.ModifiedDate = row["ModifiedDate"] != DBNull.Value ? (DateTime)row["ModifiedDate"] : (DateTime)SqlDateTime.Null; if (price.MethodId.HasValue) price.Method = new Method { MethodId = price.MethodId, MethodName = row["MethodName"].ToString() }; else price.Method = null; if (price.MethodNumberId.HasValue) price.MethodNumber = new MethodNumber { MethodNumberId = price.MethodNumberId, MethodNumberName = row["MethodNumberName"].ToString() }; else price.MethodNumber = null; if (price.AnalyteId.HasValue) price.AnalyteItem = new Analyte { AnalyteId = price.AnalyteId, AnalyteName = row["AnalyteName"].ToString() }; else price.AnalyteItem = null; returnDT = null; }else { returnDT = null; return null; } }else { throw new Exception("Unable to Connect"); } return price; }catch { throw; } }