public void ConstructorLosiParametri1(double ep, double price, double c, double p) { Assert.Throws <ArgumentException>(() => { UtilityModel utility = new UtilityModel(ep, price, c, p); }); }
public ActionResult ShowUtility(string utilityName) { using (var context = new TownUtilityBillSystemEntities()) { var utilityDB = context.UTILITY.Where(u => u.NAME == utilityName).FirstOrDefault(); var unitDB = context.UNIT.Find(utilityDB.UNIT_ID); var utilitiesDB = context.UTILITY.ToList(); var model = new UtilityModel(); model.Unit.Id = unitDB.ID; model.Unit.Name = unitDB.NAME; model.Utility.Id = utilityDB.ID; model.Utility.Name = utilityDB.NAME; model.Utility.Price = utilityDB.PRICE; model.Utility.ImageIconPath = CustomizedMethod.GetUtilityImage(utilityDB.ID); if (utilityDB.USAGEFORSTANDARTPRICE != null) { model.Utility.UsageForStandartPrice = (decimal)utilityDB.USAGEFORSTANDARTPRICE; } if (utilityDB.BIGUSAGEPRICE != null) { model.Utility.BigUsagePrice = (decimal)utilityDB.BIGUSAGEPRICE; } model.Utility.Unit = model.Unit; foreach (var u in utilitiesDB) { if (u.NAME != model.Utility.Name) { model.Utilities.Add(new Utility() { Name = u.NAME }); } } var meterTypesDB = context.METER_TYPE.Where(mt => mt.UTILITY_ID == model.Utility.Id).ToList(); var metersDB = context.METER.ToList(); HashSet <int> meterTypesIds = new HashSet <int>(); foreach (var m in meterTypesDB) { meterTypesIds.Add(m.ID); } foreach (var m in metersDB) { if (meterTypesIds.Contains(m.METER_TYPE_ID)) { model.MeterQty += 1; } } var view = View("~/Views/Utility/ShowUtility.cshtml", model); return(view); } }
public ActionResult ShowAllUtilitiesPrices() { using (var context = new TownUtilityBillSystemEntities()) { var model = new UtilityModel(); var utilitiesDB = context.UTILITY.ToList(); foreach (var item in utilitiesDB) { var unitDB = context.UNIT.Where(u => u.ID == item.UNIT_ID).FirstOrDefault(); var unit = new Unit() { Id = unitDB.ID, Name = unitDB.NAME }; if (item.USAGEFORSTANDARTPRICE != null && item.BIGUSAGEPRICE != null) { model.Utilities.Add(new Utility { Id = item.ID, Name = item.NAME, Price = item.PRICE, BigUsagePrice = (decimal)item.BIGUSAGEPRICE, UsageForStandartPrice = Math.Round((decimal)item.USAGEFORSTANDARTPRICE, 0), ImageIconPath = CustomizedMethod.GetUtilityImage(item.ID), Unit = unit }); } else { model.Utilities.Add(new Utility { Id = item.ID, Name = item.NAME, Price = item.PRICE, ImageIconPath = CustomizedMethod.GetUtilityImage(item.ID), Unit = unit }); } } return(View(model)); } }
public ActionResult BillingChecks(UtilityModel model) { model.Provider = Provider; model.CurrentUser = HttpContext.CurrentUser(Provider); ViewBag.FixAutoEndMessage = string.Empty; if (model.Period.HasValue) { var util = ServiceProvider.Current.Utility; int fixAutoEndCount = -1; if (model.Command == "fix-all-auto-end-problems") { fixAutoEndCount = util.AutoEnd.FixAllAutoEndProblems(model.Period.Value); } if (model.Command == "fix-auto-end-problem") { fixAutoEndCount = util.AutoEnd.FixAutoEndProblem(model.Period.Value, model.ReservationID); } if (fixAutoEndCount >= 0) { ViewBag.FixAutoEndMessage = string.Format("Auto-end problems fixed: {0}", fixAutoEndCount); } model.AutoEndProblems = util.AutoEnd.GetAutoEndProblems(model.Period.Value); } return(View(model)); }
public ViewResult ShowUtilities() { var model = new UtilityModel(); model.Utilities = utilityRepo.UTILITYs.Select(Utility.GetUtilityWithIdAndNames).ToList(); return(View(model)); }
public ActionResult ShowAllUtilitiesPrices() { var model = new UtilityModel(); model.GetAllUtilitiesPrices(); return(View(model)); }
public ActionResult ShowUtility(string utilityName) { var model = new UtilityModel(); model.GetDataForUtility(utilityName); return(View("~/Views/Utility/ShowUtility.cshtml", model)); }
public void CheckGetUtilitiesNameMethod() { var utilityModel = new UtilityModel(); utilityModel.GetUtilitiesName(); Assert.IsTrue(utilityModel.Utilities.Count > 0); }
public void CheckGetAllUtilitiesPricesMethodNoStandartPriceUsage() { var utilityModel = new UtilityModel(); utilityModel.GetAllUtilitiesPrices(); Assert.AreEqual(0, utilityModel.Utilities[3].UsageForStandartPrice); }
public ActionResult EditUtility(int utilityId) { var model = new UtilityModel(); var utilityForEdit = model.GetUtility(utilityId); return(View("~/Views/Utility/EditUtility.cshtml", utilityForEdit)); }
public ActionResult ControlResource(UtilityModel model) { model.Provider = Provider; model.CurrentUser = HttpContext.CurrentUser(Provider); model.CurrentPage = "Utility"; model.CurrentSubMenuItem = "resource"; return(View(model)); }
private static void CreateMeterModelFromMeterList(TownUtilityBillSystemV2Entities context, MeterModel model, List <METER> rndMetersDB) { foreach (var m in rndMetersDB) { var meterTypeDB = context.METER_TYPEs.Where(mt => mt.ID == m.METER_TYPE_ID).FirstOrDefault(); var utilityDB = context.UTILITYs.Where(u => u.ID == meterTypeDB.UTILITY_ID).FirstOrDefault(); var addressDB = context.ADDRESSes.Where(a => a.ID == m.ADDRESS_ID).FirstOrDefault(); var indexDB = context.INDEXes.Where(i => i.ID == addressDB.INDEX_ID).FirstOrDefault(); var townDB = context.TOWNs.Where(t => t.ID == addressDB.TOWN_ID).FirstOrDefault(); var streetDB = context.STREETs.Where(s => s.ID == addressDB.STREET_ID).FirstOrDefault(); var buildingDB = context.BUILDINGs.Where(b => b.ID == addressDB.BUILDING_ID).FirstOrDefault(); var flatPartDB = context.FLAT_PARTs.Where(fp => fp.ID == addressDB.FLAT_PART_ID).FirstOrDefault(); var utility = new Utility() { Id = utilityDB.ID, Name = utilityDB.NAME, ResourceName = UtilityModel.GetResourceNameForUtility(utilityDB.NAME) }; var meterType = new MeterType() { Id = meterTypeDB.ID, Name = meterTypeDB.NAME, Utility = utility }; var index = new Index() { Id = indexDB.ID, Value = indexDB.VALUE }; var town = new Town() { Id = townDB.ID, Name = townDB.NAME }; var street = new Street() { Id = streetDB.ID, Name = streetDB.NAME }; var building = new Building() { Id = buildingDB.ID, Number = buildingDB.NUMBER }; FlatPart flatPart = null; if (flatPartDB != null) { flatPart = FlatPart.Get(flatPartDB); } var address = new Address() { Id = addressDB.ID, Index = index, Town = town, Street = street, Building = building, FlatPart = flatPart }; model.Meters.Add(new Meter() { Id = m.ID, SerialNumber = m.SERIAL_NUMBER, ReleaseDate = m.RELEASE_DATE, VarificationDate = m.VARIFICATION_DATE, MeterType = meterType, Address = address }); } }
public void ConstructorDobriParametri(double ep, double price, double c, double p) { UtilityModel utility = new UtilityModel(ep, price, c, p); Assert.AreEqual(ep, utility.ExchangePower); Assert.AreEqual(price, utility.Price); Assert.AreEqual(c, utility.Consumption); Assert.AreEqual(p, utility.Production); }
public void ConstructorPrazan() { UtilityModel utility = new UtilityModel(); Assert.AreEqual(0, utility.ExchangePower); Assert.AreEqual(0, utility.Price); Assert.AreEqual(0, utility.Consumption); Assert.AreEqual(0, utility.Production); }
public void CheckGetAllUtilitiesPricesMethodForName() { var utilityModel = new UtilityModel(); var comparedUtility = new UtilityModel(); utilityModel.GetAllUtilitiesPrices(); comparedUtility.Utility.Name = "Gas"; Assert.AreEqual(comparedUtility.Utility.Name, utilityModel.Utilities[3].Name); }
public void CheckGetDataForUtilityMethod() { var utilityModel = new UtilityModel(); string inputName = "Water"; string correctUtilityName = InitialDBEnums.Utilities.Water.ToString(); utilityModel.GetDataForUtility(inputName); Assert.AreEqual(correctUtilityName, utilityModel.Utility.ResourceName); }
public ActionResult SaveUpdateUtility(UtilityModel model) { try { return(Json(new { result = 1, ID = model.SaveUpdateUtility(model) }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { error = ex.Message }, JsonRequestBehavior.AllowGet)); } }
private static void SaveReminders(DSModel db, KeyBinder key, DriverMedicalModel model, DriversMedical poco) { string sqlDelete = @"DELETE FROM drivers_medicals_reminders WHERE DriverMedicalID = @DriverMedicalID AND DriverMedicalReminderID NOT IN (@DriverMedicalReminderID);"; string ids = "0"; if (model.Reminders.Count > 0) { ids = string.Join <uint>(",", model.Reminders.Select(r => r.DriverMedicalReminderID)); } sqlDelete = sqlDelete.Replace("@DriverMedicalReminderID", ids); db.ExecuteNonQuery(sqlDelete, new MySqlParameter("DriverMedicalID", poco.DriverMedicalID)); string sqlInsert = @" INSERT INTO drivers_medicals_reminders (DriverMedicalID, ReminderID, ReminderType, ShouldRemind) VALUES (@DriverMedicalID, @ReminderID, @ReminderType, @ShouldRemind); SELECT LAST_INSERT_ID();"; string sqlUpdate = @" UPDATE drivers_medicals_reminders SET DriverMedicalID = @DriverMedicalID, ReminderID = @ReminderID, ReminderType = @ReminderType, ShouldRemind = @ShouldRemind WHERE DriverMedicalReminderID = @DriverMedicalReminderID;"; foreach (var rem in model.Reminders) { if (rem.DriverMedicalReminderID == 0) { rem.DriverMedicalID = poco.DriverMedicalID; UtilityModel <uint> temp = new UtilityModel <uint>(); temp.Value = db.ExecuteQuery <uint>(sqlInsert, new MySqlParameter("DriverMedicalID", rem.DriverMedicalID), new MySqlParameter("ReminderID", rem.ReminderID), new MySqlParameter("ReminderType", rem.ReminderType), new MySqlParameter("ShouldRemind", rem.ShouldRemind)) .First(); key.AddKey(temp, rem, "Value", rem.GetName(p => p.DriverMedicalReminderID)); } else { rem.DriverMedicalID = poco.DriverMedicalID; db.ExecuteNonQuery(sqlUpdate, new MySqlParameter("DriverMedicalReminderID", rem.DriverMedicalReminderID), new MySqlParameter("DriverMedicalID", rem.DriverMedicalID), new MySqlParameter("ReminderID", rem.ReminderID), new MySqlParameter("ReminderType", rem.ReminderType), new MySqlParameter("ShouldRemind", rem.ShouldRemind)); } } }
public ActionResult EditUtility(Utility utility) { if (ModelState.IsValid) { var model = new UtilityModel(); model.UpdateUtility(utility); return(RedirectToAction("ShowUtility", "Utility", new { utilityName = utility.Name })); } return(View()); }
public IActionResult Index() { UtilityModel util = new UtilityModel(_ctx); var json = getProductJson(); try { util.loadProductTables(json); } catch (Exception ex) { Console.WriteLine(ex.Message); } return(View()); }
//public async Task<IActionResult> Index() //{ // UtilityModel util = new UtilityModel(_ctx); // string msg = ""; // var json = await getMenuItemJsonFromWebAsync(); // try // { // msg = (util.loadShoesTables(json)) ? "tables loaded" : "problem loading tables"; // } // catch (Exception ex) // { // msg = ex.Message; // } // ViewBag.LoadedMsg = msg; // return View(); //} public async Task <IActionResult> Index() { UtilityModel util = new UtilityModel(_ctx); var json = await getMenuItemJsonFromWebAsync(); try { //ViewBag.LoadedMsg = (util.loadShoesTables(json)) ? "Menu and Item tables loaded" : "problem loading tables"; } catch (Exception ex) { ViewBag.LoadedMsg = ex.Message; } return(View("Index")); }
public async Task <IActionResult> Index() { UtilityModel util = new UtilityModel(_ctx); string msg = ""; var json = await getProductJsonFromWebAsync(); try { msg = (util.loadProductTables(json)) ? "tables loaded" : "problem loading tables"; } catch (Exception ex) { msg = ex.Message; } ViewBag.LoadedMsg = msg; return(View()); }
public ActionResult ActiveLog(UtilityModel model) { model.Provider = Provider; model.CurrentUser = HttpContext.CurrentUser(Provider); if (string.IsNullOrEmpty(model.TableName)) { model.TableName = "client"; } if (model.Record == 0) { model.Record = CurrentUser.ClientID; } return(View(model)); }
public ActionResult ShowUtilities() { using (var context = new TownUtilityBillSystemEntities()) { var model = new UtilityModel(); var utilitiesDB = context.UTILITY.ToList(); foreach (var item in utilitiesDB) { model.Utilities.Add(new Utility { Id = item.ID, Name = item.NAME }); } return(View(model)); } }
public void Utility_ShowUtilities_View_Does_Not_Contain_4_Utilities() { Mock <IUtilityRepository> mock = new Mock <IUtilityRepository>(); mock.Setup(m => m.UTILITYs).Returns(new UTILITY[] { new UTILITY { ID = 1, NAME = "Electricity" }, new UTILITY { ID = 2, NAME = "Water" } }.AsQueryable()); UtilityController controller = new UtilityController(mock.Object); UtilityModel actual = (UtilityModel)controller.ShowUtilities().Model; Assert.AreNotEqual(4, actual.Utilities.Count); }
public void GetAllMeterTypes() { using (var context = new TownUtilityBillSystemV2Entities()) { var meterTypesDB = context.METER_TYPEs.ToList(); foreach (var mt in meterTypesDB) { var utilityDB = context.UTILITYs.Where(u => u.ID == mt.UTILITY_ID).FirstOrDefault(); var utility = new Utility() { Id = utilityDB.ID, Name = utilityDB.NAME, ResourceName = UtilityModel.GetResourceNameForUtility(utilityDB.NAME), ImagePath = HelperMethod.GetUtilityImage(utilityDB.ID) }; MeterTypes.Add(new MeterType() { Id = mt.ID, Name = mt.NAME, VarificationPeriod = mt.VARIFICATION_PERIOD_YEARS, Utility = utility }); } } }
private static void CreateMeterModelWithOneMeter(int meterId, TownUtilityBillSystemV2Entities context, MeterItemModel model) { var meterDB = context.METERs.Where(m => m.ID == meterId).FirstOrDefault(); var meterTypeDB = context.METER_TYPEs.Where(mt => mt.ID == meterDB.METER_TYPE_ID).FirstOrDefault(); var utilityDB = context.UTILITYs.Where(u => u.ID == meterTypeDB.UTILITY_ID).FirstOrDefault(); var addressDB = context.ADDRESSes.Where(a => a.ID == meterDB.ADDRESS_ID).FirstOrDefault(); var index = context.INDEXes.Where(i => i.ID == addressDB.INDEX_ID).Select(Index.Get).FirstOrDefault(); var town = context.TOWNs.Where(t => t.ID == addressDB.TOWN_ID).Select(Town.Get).FirstOrDefault(); var street = context.STREETs.Where(s => s.ID == addressDB.STREET_ID).Select(Street.Get).FirstOrDefault(); var building = context.BUILDINGs.Where(b => b.ID == addressDB.BUILDING_ID).Select(Building.Get).FirstOrDefault(); var flatPartDB = context.FLAT_PARTs.Where(fp => fp.ID == addressDB.FLAT_PART_ID).FirstOrDefault(); var unit = context.UNITs.Where(u => u.ID == utilityDB.UNIT_ID).Select(Unit.Get).FirstOrDefault(); var utility = new Utility() { Id = utilityDB.ID, Name = utilityDB.NAME, ResourceName = UtilityModel.GetResourceNameForUtility(utilityDB.NAME), Unit = unit }; var meterType = new MeterType() { Id = meterTypeDB.ID, Name = meterTypeDB.NAME, Utility = utility }; FlatPart flatPart = null; if (flatPartDB != null) { flatPart = FlatPart.Get(flatPartDB); } var address = new Address() { Id = addressDB.ID, Index = index, Town = town, Street = street, Building = building, FlatPart = flatPart }; model.Meter = new Meter() { Id = meterDB.ID, SerialNumber = meterDB.SERIAL_NUMBER, ReleaseDate = meterDB.RELEASE_DATE, VarificationDate = meterDB.VARIFICATION_DATE, MeterType = meterType, Address = address }; }
public ValueIteration(int state_count, int action_count, double gamma = 0.9, double initial_U = 0.1) { mModel = new UtilityModel(state_count, action_count, initial_U); mModel.Gamma = gamma; }
public ActionResult Fees(UtilityModel model) { model.Provider = Provider; model.CurrentUser = HttpContext.CurrentUser(Provider); return(View(model)); }
public virtual int SelectAction(int state_id, UtilityModel model) { return(-1); }
private static void SaveReminders(DSModel db, KeyBinder key, DriverMedicalModel model, DriversMedical poco) { string sqlDelete = @"DELETE FROM drivers_medicals_reminders WHERE DriverMedicalID = @DriverMedicalID AND DriverMedicalReminderID NOT IN (@DriverMedicalReminderID);"; string ids = "0"; if (model.Reminders.Count > 0) ids = string.Join<uint>(",", model.Reminders.Select(r => r.DriverMedicalReminderID)); sqlDelete = sqlDelete.Replace("@DriverMedicalReminderID", ids); db.ExecuteNonQuery(sqlDelete, new MySqlParameter("DriverMedicalID", poco.DriverMedicalID)); string sqlInsert = @" INSERT INTO drivers_medicals_reminders (DriverMedicalID, ReminderID, ReminderType, ShouldRemind) VALUES (@DriverMedicalID, @ReminderID, @ReminderType, @ShouldRemind); SELECT LAST_INSERT_ID();"; string sqlUpdate = @" UPDATE drivers_medicals_reminders SET DriverMedicalID = @DriverMedicalID, ReminderID = @ReminderID, ReminderType = @ReminderType, ShouldRemind = @ShouldRemind WHERE DriverMedicalReminderID = @DriverMedicalReminderID;"; foreach (var rem in model.Reminders) { if (rem.DriverMedicalReminderID == 0) { rem.DriverMedicalID = poco.DriverMedicalID; UtilityModel<uint> temp = new UtilityModel<uint>(); temp.Value = db.ExecuteQuery<uint>(sqlInsert, new MySqlParameter("DriverMedicalID", rem.DriverMedicalID), new MySqlParameter("ReminderID", rem.ReminderID), new MySqlParameter("ReminderType", rem.ReminderType), new MySqlParameter("ShouldRemind", rem.ShouldRemind)) .First(); key.AddKey(temp, rem, "Value", rem.GetName(p => p.DriverMedicalReminderID)); } else { rem.DriverMedicalID = poco.DriverMedicalID; db.ExecuteNonQuery(sqlUpdate, new MySqlParameter("DriverMedicalReminderID", rem.DriverMedicalReminderID), new MySqlParameter("DriverMedicalID", rem.DriverMedicalID), new MySqlParameter("ReminderID", rem.ReminderID), new MySqlParameter("ReminderType", rem.ReminderType), new MySqlParameter("ShouldRemind", rem.ShouldRemind)); } } }