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));
}
}
}
