public List <TimeOfUse> GetTimeOfUses(string name) { List <TimeOfUse> list; using (var db = new ProductConfigurationDBContext() { Database = { Connection = { ConnectionString = _connectionStringName } } }) { var sqlParams = new List <SqlParameter> { new SqlParameter("@Name", name), }; list = db.Database.SqlQuery <TimeOfUse>("GetTimeOfUses @Name", sqlParams.ToArray()).ToList(); } return(list); }
public List <TimeOfUseViewModel> GetTimeOfUseNames() { List <TimeOfUseViewModel> list; using (var db = new ProductConfigurationDBContext() { Database = { Connection = { ConnectionString = _connectionStringName } } }) { //var sqlParams = new List<SqlParameter> // { // new SqlParameter("@Type",type), // new SqlParameter("@PlanCode",planCode) // }; list = db.Database.SqlQuery <TimeOfUseViewModel>("GetTimeOfUseNames").ToList(); } return(list); }
public List <string> GetEffectiveDates(string type, string planCode) { List <string> list; using (var db = new ProductConfigurationDBContext() { Database = { Connection = { ConnectionString = _connectionStringName } } }) { var sqlParams = new List <SqlParameter> { new SqlParameter("@Type", type), new SqlParameter("@PlanCode", planCode) }; list = db.Database.SqlQuery <string>("GetEffectiveDates @Type,@PlanCode", sqlParams.ToArray()).ToList(); } return(list); }
//type:Dolar,Percentage public List <OfferPriceMapViewModel> GetOfferPriceMaps(string type, DateTime?effectiveDate, string planCode) { List <OfferPriceMapViewModel> list; using (var db = new ProductConfigurationDBContext() { Database = { Connection = { ConnectionString = _connectionStringName } } }) { var sqlParams = new List <SqlParameter> { new SqlParameter("@Type", type), new SqlParameter("@EffectiveDate", effectiveDate), new SqlParameter("@PlanCode", planCode), }; list = db.Database.SqlQuery <OfferPriceMapViewModel>("GetOfferPriceMaps @Type,@EffectiveDate,@PlanCode", sqlParams.ToArray()).ToList(); } return(list); }