private static SqlParameter[] CreateSqlParameter(ARAgentRate model) { return(new SqlParameter[] { new SqlParameter("@CompanyID", model.CompanyID), new SqlParameter("@ProviderID", model.ProviderID), new SqlParameter("@RateID", model.RateID), new SqlParameter("@CustomerID", model.CustomerID), new SqlParameter("@BalanceAmt", model.BalanceAmt), new SqlParameter("@CuryBalanceAmt", model.CuryBalanceAmt), new SqlParameter("@WinLossSumAmt", model.WinLossSumAmt), }); }
public static ARAgentRate UpdateItem(ARAgentRate model) { String result = String.Empty; using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "ARAgentRate_Update", CreateSqlParameter(model))) { while (reader.Read()) { result = (String)reader[0]; } } return(GetItemByID(model.CustomerID, model.CompanyID, model.ProviderID)); }
public static ARAgentRateCollection Search(SearchFilter SearchKey) { ARAgentRateCollection collection = new ARAgentRateCollection(); using (var reader = SqlHelper.ExecuteReader("ARAgentRate_Search", SearchFilterManager.SqlSearchParam(SearchKey))) { while (reader.Read()) { ARAgentRate obj = new ARAgentRate(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
private static ARAgentRate GetItemFromReader(IDataReader dataReader) { ARAgentRate objItem = new ARAgentRate(); objItem.CompanyID = SqlHelper.GetInt(dataReader, "CompanyID"); objItem.ProviderID = SqlHelper.GetInt(dataReader, "ProviderID"); objItem.RateID = SqlHelper.GetInt(dataReader, "RateID"); objItem.CustomerID = SqlHelper.GetString(dataReader, "CustomerID"); if (SqlHelper.ColumnExists(dataReader, "TotalRecord")) { objItem.TotalRecord = SqlHelper.GetInt(dataReader, "TotalRecord"); } if (SqlHelper.ColumnExists(dataReader, "SharingPer")) { objItem.Sharing = SqlHelper.GetInt(dataReader, "SharingPer"); } if (SqlHelper.ColumnExists(dataReader, "Name")) { objItem.Name = SqlHelper.GetString(dataReader, "Name"); } if (SqlHelper.ColumnExists(dataReader, "Rate")) { objItem.Rate = SqlHelper.GetDecimal(dataReader, "Rate"); } if (SqlHelper.ColumnExists(dataReader, "BalanceAmt")) { objItem.BalanceAmt = SqlHelper.GetDecimal(dataReader, "BalanceAmt"); } if (SqlHelper.ColumnExists(dataReader, "CuryBalanceAmt")) { objItem.CuryBalanceAmt = SqlHelper.GetDecimal(dataReader, "CuryBalanceAmt"); } if (SqlHelper.ColumnExists(dataReader, "WinLossSumAmt")) { objItem.WinLossSumAmt = SqlHelper.GetDecimal(dataReader, "WinLossSumAmt"); } return(objItem); }
public static ARAgentRate AddItem(ARAgentRate model) { String result = String.Empty; try { using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "ARAgentRate_Add", CreateSqlParameter(model))) { while (reader.Read()) { result = (String)reader[0]; } } } catch (Exception ObjEx) { } return(GetItemByID(result, model.CompanyID, model.ProviderID)); }
public static ARAgentRate GetItemByID(string CustomerID, int CompanyID, int ProviderID) { ARAgentRate item = new ARAgentRate(); var sqlParams = new SqlParameter[] { new SqlParameter("@CustomerID", CustomerID), new SqlParameter("@CompanyID", CompanyID), new SqlParameter("@ProviderID", ProviderID), }; using (var reader = SqlHelper.ExecuteReader("ARAgentRate_GetByID", sqlParams)) { while (reader.Read()) { item = GetItemFromReader(reader); } } return(item); }
public static ARAgentRateCollection GetAllItem(int CompanyID, string CustomerID) { ARAgentRateCollection collection = new ARAgentRateCollection(); var sqlParams = new SqlParameter[] { new SqlParameter("@CompanyID", CompanyID), new SqlParameter("@CustomerID", CustomerID), }; using (var reader = SqlHelper.ExecuteReader("ARAgentRate_GetAll", sqlParams)) { while (reader.Read()) { ARAgentRate obj = new ARAgentRate(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }