public async Task <ActionResult> Edit([Bind(Include = "Id,ApplianceTypeId,Power")] Appliance appliance)
{
if (ModelState.IsValid)
{
Appliance app = null;
using (var dblocal = new NpgsqlContext())
{
app = dblocal.Appliances.Where(a => a.Id == appliance.Id).FirstOrDefault();
dblocal.Dispose();
GC.Collect();
}
string comment = $"Id: {appliance.Id} ApplianceTypeId: {appliance.ApplianceTypeId} Power: {appliance.Power.ToString()}";
comment += $" -> ApplianceTypeId: {app.ApplianceTypeId} Power: {app.Power.ToString()}";
SystemLog.New("ApplianceEdit", comment, null, false);
db.Entry(appliance).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
IList <ApplianceType> appliancetypes = db.ApplianceTypes
.Where(a => true)
.ToList();
appliancetypes = appliancetypes
.OrderBy(a => a.Name)
.ToList();
ViewBag.ApplianceTypeId = new SelectList(appliancetypes, "Id", "Name", appliance.ApplianceTypeId);
return(View(appliance));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,Code,NameEN,NameKZ,NameRU")] PanelOrientation panelOrientation)
{
if (ModelState.IsValid)
{
PanelOrientation po = null;
using (var dblocal = new NpgsqlContext())
{
po = dblocal.PanelOrientations.Where(p => p.Id == panelOrientation.Id).FirstOrDefault();
dblocal.Dispose();
GC.Collect();
}
panelOrientation.Code = po.Code;
string comment = $"Id: {po.Id} Code: {po.Code} NameEN: {po.NameEN} NameKZ: {po.NameKZ} NameRU: {po.NameRU}";
comment += $" -> Code: {panelOrientation.Code} NameEN: {panelOrientation.NameEN} NameKZ: {panelOrientation.NameKZ} NameRU: {panelOrientation.NameRU}";
SystemLog.New("PanelOrientationEdit", comment, null, false);
db.Entry(panelOrientation).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(panelOrientation));
}
public async Task <ActionResult> Login(LoginViewModel model, string returnUrl)
{
if (!ModelState.IsValid)
{
return(View(model));
}
// This doesn't count login failures towards account lockout
// To enable password failures to trigger account lockout, change to shouldLockout: true
var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout : false);
switch (result)
{
case SignInStatus.Success:
SystemLog.New(null, model.Email, "Login", null, null, false);
return(RedirectToLocal(returnUrl));
case SignInStatus.LockedOut:
return(View("Lockout"));
case SignInStatus.RequiresVerification:
return(RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe }));
case SignInStatus.Failure:
ModelState.AddModelError(string.Empty, Resources.Errors.InvalidLoginAttempt);
return(View(model));
default:
ModelState.AddModelError("", Resources.Errors.InvalidLoginAttempt);
return(View(model));
}
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
SPP sPP = await db.SPPs.FindAsync(id);
string comment = $"Id: {sPP.Id}";
comment += $" Count: {sPP.Count.ToString()}";
comment += $" Power: {sPP.Power.ToString()}";
comment += $" Cost: {sPP.Cost}";
comment += $" Startup: {sPP.Startup.ToString()}";
comment += $" Link: {sPP.Link}";
comment += $" Customer: {sPP.Customer}";
comment += $" Investor: {sPP.Investor}";
comment += $" Executor: {sPP.Executor}";
comment += $" CapacityFactor: {sPP.CapacityFactor.ToString()}";
comment += $" SPPStatusId: {sPP.SPPStatusId.ToString()}";
comment += $" SPPPurposeId: {sPP.SPPPurposeId.ToString()}";
comment += $" PanelOrientationId: {sPP.PanelOrientationId.ToString()}";
comment += $" Coordinates: {sPP.Coordinates}";
SystemLog.New("SPPCreate", comment, null, false);
db.SPPs.Remove(sPP);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
MeteoDataType meteoDataType = await db.MeteoDataTypes.FindAsync(id);
string comment = $"Id: {meteoDataType.Id} MeteoDataSourceId: {meteoDataType.MeteoDataSourceId} MeteoDataPeriodicityId: {meteoDataType.MeteoDataPeriodicityId} Code: {meteoDataType.Code}";
if (!string.IsNullOrEmpty(meteoDataType.GroupEN))
{
comment += $" GroupEN: {meteoDataType.GroupEN} GroupKZ: {meteoDataType.GroupKZ} GroupRU: {meteoDataType.GroupRU}";
}
comment += $" NameEN: {meteoDataType.NameEN} NameKZ: {meteoDataType.NameKZ} NameRU: {meteoDataType.NameRU}";
if (!string.IsNullOrEmpty(meteoDataType.AdditionalEN))
{
comment += $" AdditionalEN: {meteoDataType.AdditionalEN} AdditionalKZ: {meteoDataType.AdditionalKZ} AdditionalRU: {meteoDataType.AdditionalRU}";
}
if (!string.IsNullOrEmpty(meteoDataType.DescriptionEN))
{
comment += $" DescriptionEN: {meteoDataType.DescriptionEN} DescriptionKZ: {meteoDataType.DescriptionKZ} DescriptionRU: {meteoDataType.DescriptionRU}";
}
SystemLog.New("MeteoDataTypeDelete", comment, null, false);
db.MeteoDataTypes.Remove(meteoDataType);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,Count,Power,Cost,Startup,Link,Customer,Investor,Executor,Name,CapacityFactor,SPPStatusId,SPPPurposeId,PanelOrientationId,Coordinates")] SPP sPP, HttpPostedFileBase Photo)
{
if (ModelState.IsValid)
{
SPP sPPdb = null;
using (var dblocal = new NpgsqlContext())
{
sPPdb = dblocal.SPPs.Find(sPP.Id);
}
sPP.Photo = sPPdb.Photo;
if (Photo != null && Photo.ContentLength > 0)
{
sPP.Photo = null;
MemoryStream target = new MemoryStream();
Photo.InputStream.CopyTo(target);
sPP.Photo = target.ToArray();
}
string comment = $"Id: {sPPdb.Id}";
comment += $" Count: {sPPdb.Count.ToString()}";
comment += $" Power: {sPPdb.Power.ToString()}";
comment += $" Cost: {sPPdb.Cost}";
comment += $" Startup: {sPPdb.Startup.ToString()}";
comment += $" Link: {sPPdb.Link}";
comment += $" Customer: {sPPdb.Customer}";
comment += $" Investor: {sPPdb.Investor}";
comment += $" Executor: {sPPdb.Executor}";
comment += $" CapacityFactor: {sPPdb.CapacityFactor.ToString()}";
comment += $" SPPStatusId: {sPPdb.SPPStatusId.ToString()}";
comment += $" SPPPurposeId: {sPPdb.SPPPurposeId.ToString()}";
comment += $" PanelOrientationId: {sPPdb.PanelOrientationId.ToString()}";
comment += $" Coordinates: {sPPdb.Coordinates}";
comment += $" -> Count: {sPP.Count.ToString()}";
comment += $" Power: {sPP.Power.ToString()}";
comment += $" Cost: {sPP.Cost}";
comment += $" Startup: {sPP.Startup.ToString()}";
comment += $" Link: {sPP.Link}";
comment += $" Customer: {sPP.Customer}";
comment += $" Investor: {sPP.Investor}";
comment += $" Executor: {sPP.Executor}";
comment += $" CapacityFactor: {sPP.CapacityFactor.ToString()}";
comment += $" SPPStatusId: {sPP.SPPStatusId.ToString()}";
comment += $" SPPPurposeId: {sPP.SPPPurposeId.ToString()}";
comment += $" PanelOrientationId: {sPP.PanelOrientationId.ToString()}";
comment += $" Coordinates: {sPP.Coordinates}";
SystemLog.New("SPPEdit", comment, null, false);
db.Entry(sPP).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PanelOrientationId = new SelectList(db.PanelOrientations, "Id", "Name", sPP.PanelOrientationId);
ViewBag.SPPPurposeId = new SelectList(db.SPPPurposes, "Id", "Name", sPP.SPPPurposeId);
ViewBag.SPPStatusId = new SelectList(db.SPPStatus, "Id", "Name", sPP.SPPStatusId);
return(View(sPP));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
Appliance appliance = await db.Appliances.FindAsync(id);
string comment = $"Id: {appliance.Id} ApplianceTypeId: {appliance.ApplianceTypeId} Power: {appliance.Power.ToString()}";
SystemLog.New("ApplianceDelete", comment, null, false);
db.Appliances.Remove(appliance);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
PVSystemMaterial pVSystemMaterial = await db.PVSystemMaterials.FindAsync(id);
string comment = $"Id: {pVSystemMaterial.Id} NameEN: {pVSystemMaterial.NameEN} NameKZ: {pVSystemMaterial.NameKZ} NameRU: {pVSystemMaterial.NameRU} Efficiency: {pVSystemMaterial.Efficiency} RatedOperatingTemperature: {pVSystemMaterial.RatedOperatingTemperature} ThermalPowerFactor: {pVSystemMaterial.ThermalPowerFactor}";
SystemLog.New("PVSystemMaterialDelete", comment, null, false);
db.PVSystemMaterials.Remove(pVSystemMaterial);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
ApplianceType applianceType = await db.ApplianceTypes.FindAsync(id);
string comment = $"Id: {applianceType.Id} NameEN: {applianceType.NameEN} NameKZ: {applianceType.NameKZ} NameRU: {applianceType.NameRU}";
SystemLog.New("ApplianceTypeDelete", comment, null, false);
db.ApplianceTypes.Remove(applianceType);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
PanelOrientation panelOrientation = await db.PanelOrientations.FindAsync(id);
string comment = $"Id: {panelOrientation.Id} Code: {panelOrientation.Code} NameEN: {panelOrientation.NameEN} NameKZ: {panelOrientation.NameKZ} NameRU: {panelOrientation.NameRU}";
SystemLog.New("PanelOrientationDelete", comment, null, false);
db.PanelOrientations.Remove(panelOrientation);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Create([Bind(Include = "Id,NameEN,NameKZ,NameRU,Efficiency,RatedOperatingTemperature,ThermalPowerFactor")] PVSystemMaterial pVSystemMaterial)
{
if (ModelState.IsValid)
{
db.PVSystemMaterials.Add(pVSystemMaterial);
await db.SaveChangesAsync();
string comment = $"Id: {pVSystemMaterial.Id} NameEN: {pVSystemMaterial.NameEN} NameKZ: {pVSystemMaterial.NameKZ} NameRU: {pVSystemMaterial.NameRU} Efficiency: {pVSystemMaterial.Efficiency} RatedOperatingTemperature: {pVSystemMaterial.RatedOperatingTemperature} ThermalPowerFactor: {pVSystemMaterial.ThermalPowerFactor}";
SystemLog.New("PVSystemMaterialCreate", comment, null, false);
return(RedirectToAction("Index"));
}
return(View(pVSystemMaterial));
}
public async Task <ActionResult> Create([Bind(Include = "Id,Code,NameEN,NameKZ,NameRU")] PanelOrientation panelOrientation)
{
if (ModelState.IsValid)
{
db.PanelOrientations.Add(panelOrientation);
await db.SaveChangesAsync();
string comment = $"Id: {panelOrientation.Id} Code: {panelOrientation.Code} NameEN: {panelOrientation.NameEN} NameKZ: {panelOrientation.NameKZ} NameRU: {panelOrientation.NameRU}";
SystemLog.New("PanelOrientationCreate", comment, null, false);
return(RedirectToAction("Index"));
}
return(View(panelOrientation));
}
public async Task <ActionResult> Create([Bind(Include = "Id,NameEN,NameKZ,NameRU")] ApplianceType applianceType)
{
if (ModelState.IsValid)
{
db.ApplianceTypes.Add(applianceType);
await db.SaveChangesAsync();
string comment = $"Id: {applianceType.Id} NameEN: {applianceType.NameEN} NameKZ: {applianceType.NameKZ} NameRU: {applianceType.NameRU}";
SystemLog.New("ApplianceTypeCreate", comment, null, false);
return(RedirectToAction("Index"));
}
return(View(applianceType));
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
var user = new ApplicationUser {
UserName = model.Email, Email = model.Email
};
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false);
// For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=320771
// Send an email with this link
// string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
// var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
// await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>");
SystemLog.New(null, model.Email, "Register", null, null, false);
return(RedirectToAction("Index", "Home"));
}
List <string> errors = new List <string>();
foreach (string error in result.Errors)
{
if (error.ToLower().Contains("Name".ToLower()) && error.ToLower().Contains("is already taken.".ToLower()))
{
}
else if (error.ToLower().Contains("Email".ToLower()) && error.ToLower().Contains("is already taken.".ToLower()))
{
errors.Add(error.Replace("Email", Resources.Common.Email).Replace("is already taken.", Resources.Errors.isAlreadyTaken));
}
else
{
errors.Add(error);
}
}
foreach (var error in errors)
{
ModelState.AddModelError("", error);
}
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
MapDescription mapDescription = await db.MapDescriptions.FindAsync(id);
string comment = $"Id: {mapDescription.Id} LayersCode: {mapDescription.LayersCode} DescriptionForUser: {mapDescription.DescriptionForUser}";
comment += $" NameEN: {mapDescription.NameEN} NameKZ: {mapDescription.NameKZ} NameRU: {mapDescription.NameRU}";
comment += $" DescriptionEN: {mapDescription.DescriptionEN} DescriptionKZ: {mapDescription.DescriptionKZ} DescriptionRU: {mapDescription.DescriptionRU}";
comment += $" AppointmentEN: {mapDescription.AppointmentEN} AppointmentKZ: {mapDescription.AppointmentKZ} AppointmentRU: {mapDescription.AppointmentRU}";
comment += $" SourceEN: {mapDescription.SourceEN} SourceKZ: {mapDescription.SourceKZ} SourceRU: {mapDescription.SourceRU}";
comment += $" AdditionalEN: {mapDescription.AdditionalEN} AdditionalKZ: {mapDescription.AdditionalKZ} AdditionalRU: {mapDescription.AdditionalRU}";
comment += $" ResolutionEN: {mapDescription.ResolutionEN} ResolutionKZ: {mapDescription.ResolutionKZ} ResolutionRU: {mapDescription.ResolutionRU}";
SystemLog.New("MapDescriptionDelete", comment, null, false);
db.MapDescriptions.Remove(mapDescription);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Create([Bind(Include = "Id,MeteoDataSourceId,MeteoDataPeriodicityId,Code,GroupEN,GroupKZ,GroupRU,NameEN,NameKZ,NameRU,AdditionalEN,AdditionalKZ,AdditionalRU,DescriptionEN,DescriptionKZ,DescriptionRU")] MeteoDataType meteoDataType)
{
if (ModelState.IsValid)
{
db.MeteoDataTypes.Add(meteoDataType);
await db.SaveChangesAsync();
string comment = $"Id: {meteoDataType.Id} MeteoDataSourceId: {meteoDataType.MeteoDataSourceId} MeteoDataPeriodicityId: {meteoDataType.MeteoDataPeriodicityId} Code: {meteoDataType.Code}";
if (!string.IsNullOrEmpty(meteoDataType.GroupEN))
{
comment += $" GroupEN: {meteoDataType.GroupEN} GroupKZ: {meteoDataType.GroupKZ} GroupRU: {meteoDataType.GroupRU}";
}
comment += $" NameEN: {meteoDataType.NameEN} NameKZ: {meteoDataType.NameKZ} NameRU: {meteoDataType.NameRU}";
if (!string.IsNullOrEmpty(meteoDataType.AdditionalEN))
{
comment += $" AdditionalEN: {meteoDataType.AdditionalEN}";
}
if (!string.IsNullOrEmpty(meteoDataType.AdditionalKZ))
{
comment += $" AdditionalKZ: {meteoDataType.AdditionalKZ}";
}
if (!string.IsNullOrEmpty(meteoDataType.AdditionalRU))
{
comment += $" AdditionalRU: {meteoDataType.AdditionalRU}";
}
if (!string.IsNullOrEmpty(meteoDataType.DescriptionEN))
{
comment += $" DescriptionEN: {meteoDataType.DescriptionEN} DescriptionKZ: {meteoDataType.DescriptionKZ} DescriptionRU: {meteoDataType.DescriptionRU}";
}
SystemLog.New("MeteoDataTypeCreate", comment, null, false);
return(RedirectToAction("Index"));
}
ViewBag.MeteoDataSourceId = new SelectList(db.MeteoDataSources
.ToList()
.OrderBy(m => m.Name), "Id", "Name", meteoDataType.MeteoDataSourceId);
ViewBag.MeteoDataPeriodicityId = new SelectList(db.MeteoDataPeriodicities
.ToList()
.OrderBy(m => m.Name), "Id", "Name", meteoDataType.MeteoDataPeriodicityId);
return(View(meteoDataType));
}
public async Task <ActionResult> Create([Bind(Include = "Id,LayersCode,DescriptionForUser,NameEN,NameKZ,NameRU,DescriptionEN,DescriptionKZ,DescriptionRU,AppointmentEN,AppointmentKZ,AppointmentRU,SourceEN,SourceKZ,SourceRU,AdditionalEN,AdditionalKZ,AdditionalRU,ResolutionEN,ResolutionKZ,ResolutionRU")] MapDescription mapDescription)
{
if (ModelState.IsValid)
{
db.MapDescriptions.Add(mapDescription);
await db.SaveChangesAsync();
string comment = $"Id: {mapDescription.Id} LayersCode: {mapDescription.LayersCode} DescriptionForUser: {mapDescription.DescriptionForUser}";
comment += $" NameEN: {mapDescription.NameEN} NameKZ: {mapDescription.NameKZ} NameRU: {mapDescription.NameRU}";
comment += $" DescriptionEN: {mapDescription.DescriptionEN} DescriptionKZ: {mapDescription.DescriptionKZ} DescriptionRU: {mapDescription.DescriptionRU}";
comment += $" AppointmentEN: {mapDescription.AppointmentEN} AppointmentKZ: {mapDescription.AppointmentKZ} AppointmentRU: {mapDescription.AppointmentRU}";
comment += $" SourceEN: {mapDescription.SourceEN} SourceKZ: {mapDescription.SourceKZ} SourceRU: {mapDescription.SourceRU}";
comment += $" AdditionalEN: {mapDescription.AdditionalEN} AdditionalKZ: {mapDescription.AdditionalKZ} AdditionalRU: {mapDescription.AdditionalRU}";
comment += $" ResolutionEN: {mapDescription.ResolutionEN} ResolutionKZ: {mapDescription.ResolutionKZ} ResolutionRU: {mapDescription.ResolutionRU}";
SystemLog.New("MapDescriptionCreate", comment, null, false);
return(RedirectToAction("Index"));
}
return(View(mapDescription));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,LayersCode,DescriptionForUser,NameEN,NameKZ,NameRU,DescriptionEN,DescriptionKZ,DescriptionRU,AppointmentEN,AppointmentKZ,AppointmentRU,SourceEN,SourceKZ,SourceRU,AdditionalEN,AdditionalKZ,AdditionalRU,ResolutionEN,ResolutionKZ,ResolutionRU")] MapDescription mapDescription)
{
if (ModelState.IsValid)
{
MapDescription md = null;
using (var dblocal = new NpgsqlContext())
{
md = dblocal.MapDescriptions.Where(m => m.Id == mapDescription.Id).FirstOrDefault();
dblocal.Dispose();
GC.Collect();
}
mapDescription.LayersCode = md.LayersCode;
db.Entry(mapDescription).State = EntityState.Modified;
await db.SaveChangesAsync();
string comment = $"Id: {md.Id} LayersCode: {md.LayersCode} DescriptionForUser: {md.DescriptionForUser}";
comment += $" NameEN: {md.NameEN} NameKZ: {md.NameKZ} NameRU: {md.NameRU}";
comment += $" DescriptionEN: {md.DescriptionEN} DescriptionKZ: {md.DescriptionKZ} DescriptionRU: {md.DescriptionRU}";
comment += $" AppointmentEN: {md.AppointmentEN} AppointmentKZ: {md.AppointmentKZ} AppointmentRU: {md.AppointmentRU}";
comment += $" SourceEN: {md.SourceEN} SourceKZ: {md.SourceKZ} SourceRU: {md.SourceRU}";
comment += $" AdditionalEN: {md.AdditionalEN} AdditionalKZ: {md.AdditionalKZ} AdditionalRU: {md.AdditionalRU}";
comment += $" ResolutionEN: {md.ResolutionEN} ResolutionKZ: {md.ResolutionKZ} ResolutionRU: {md.ResolutionRU}";
comment = $" -> Id: {mapDescription.Id} LayersCode: {mapDescription.LayersCode} DescriptionForUser: {mapDescription.DescriptionForUser}";
comment += $" NameEN: {mapDescription.NameEN} NameKZ: {mapDescription.NameKZ} NameRU: {mapDescription.NameRU}";
comment += $" DescriptionEN: {mapDescription.DescriptionEN} DescriptionKZ: {mapDescription.DescriptionKZ} DescriptionRU: {mapDescription.DescriptionRU}";
comment += $" AppointmentEN: {mapDescription.AppointmentEN} AppointmentKZ: {mapDescription.AppointmentKZ} AppointmentRU: {mapDescription.AppointmentRU}";
comment += $" SourceEN: {mapDescription.SourceEN} SourceKZ: {mapDescription.SourceKZ} SourceRU: {mapDescription.SourceRU}";
comment += $" AdditionalEN: {mapDescription.AdditionalEN} AdditionalKZ: {mapDescription.AdditionalKZ} AdditionalRU: {mapDescription.AdditionalRU}";
comment += $" ResolutionEN: {mapDescription.ResolutionEN} ResolutionKZ: {mapDescription.ResolutionKZ} ResolutionRU: {mapDescription.ResolutionRU}";
SystemLog.New("MapDescriptionEdit", comment, null, false);
return(RedirectToAction("Index"));
}
return(View(mapDescription));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,NameEN,NameKZ,NameRU")] ApplianceType applianceType)
{
if (ModelState.IsValid)
{
ApplianceType at = null;
using (var dblocal = new NpgsqlContext())
{
at = dblocal.ApplianceTypes.Where(a => a.Id == applianceType.Id).FirstOrDefault();
dblocal.Dispose();
GC.Collect();
}
string comment = $"Id: {at.Id} NameEN: {at.NameEN} NameKZ: {at.NameKZ} NameRU: {at.NameRU}";
comment += $" -> NameEN: {applianceType.NameEN} NameKZ: {applianceType.NameKZ} NameRU: {applianceType.NameRU}";
SystemLog.New("ApplianceTypeEdit", comment, null, false);
db.Entry(applianceType).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(applianceType));
}
public async Task <ActionResult> Create([Bind(Include = "Id,ApplianceTypeId,Power")] Appliance appliance)
{
if (ModelState.IsValid)
{
db.Appliances.Add(appliance);
await db.SaveChangesAsync();
string comment = $"Id: {appliance.Id} ApplianceTypeId: {appliance.ApplianceTypeId} Power: {appliance.Power.ToString()}";
SystemLog.New("ApplianceCreate", comment, null, false);
return(RedirectToAction("Index"));
}
IList <ApplianceType> appliancetypes = db.ApplianceTypes
.Where(a => true)
.ToList();
appliancetypes = appliancetypes
.OrderBy(a => a.Name)
.ToList();
ViewBag.ApplianceTypeId = new SelectList(appliancetypes, "Id", "Name", appliance.ApplianceTypeId);
return(View(appliance));
}
public async Task <ActionResult> Create([Bind(Include = "Id,Count,Power,Cost,Startup,Link,Customer,Investor,Executor,Name,CapacityFactor,SPPStatusId,SPPPurposeId,PanelOrientationId,Coordinates")] SPP sPP, HttpPostedFileBase Photo)
{
if (ModelState.IsValid)
{
if (Photo != null)
{
MemoryStream target = new MemoryStream();
Photo.InputStream.CopyTo(target);
sPP.Photo = target.ToArray();
}
db.SPPs.Add(sPP);
await db.SaveChangesAsync();
string comment = $"Id: {sPP.Id}";
comment += $" Count: {sPP.Count.ToString()}";
comment += $" Power: {sPP.Power.ToString()}";
comment += $" Cost: {sPP.Cost}";
comment += $" Startup: {sPP.Startup.ToString()}";
comment += $" Link: {sPP.Link}";
comment += $" Customer: {sPP.Customer}";
comment += $" Investor: {sPP.Investor}";
comment += $" Executor: {sPP.Executor}";
comment += $" CapacityFactor: {sPP.CapacityFactor.ToString()}";
comment += $" SPPStatusId: {sPP.SPPStatusId.ToString()}";
comment += $" SPPPurposeId: {sPP.SPPPurposeId.ToString()}";
comment += $" PanelOrientationId: {sPP.PanelOrientationId.ToString()}";
comment += $" Coordinates: {sPP.Coordinates}";
SystemLog.New("SPPCreate", comment, null, false);
return(RedirectToAction("Index"));
}
ViewBag.PanelOrientationId = new SelectList(db.PanelOrientations, "Id", "Name", sPP.PanelOrientationId);
ViewBag.SPPPurposeId = new SelectList(db.SPPPurposes, "Id", "Name", sPP.SPPPurposeId);
ViewBag.SPPStatusId = new SelectList(db.SPPStatus, "Id", "Name", sPP.SPPStatusId);
return(View(sPP));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,NameEN,NameKZ,NameRU,Efficiency,RatedOperatingTemperature,ThermalPowerFactor")] PVSystemMaterial pVSystemMaterial)
{
if (ModelState.IsValid)
{
PVSystemMaterial pvsm = null;
using (var dblocal = new NpgsqlContext())
{
pvsm = dblocal.PVSystemMaterials.Where(p => p.Id == pVSystemMaterial.Id).FirstOrDefault();
dblocal.Dispose();
GC.Collect();
}
db.Entry(pVSystemMaterial).State = EntityState.Modified;
await db.SaveChangesAsync();
string comment = $"Id: {pvsm.Id} NameEN: {pvsm.NameEN} NameKZ: {pvsm.NameKZ} NameRU: {pvsm.NameRU} Efficiency: {pvsm.Efficiency} RatedOperatingTemperature: {pvsm.RatedOperatingTemperature} ThermalPowerFactor: {pvsm.ThermalPowerFactor}";
comment += $" -> Id: {pVSystemMaterial.Id} NameEN: {pVSystemMaterial.NameEN} NameKZ: {pVSystemMaterial.NameKZ} NameRU: {pVSystemMaterial.NameRU} Efficiency: {pVSystemMaterial.Efficiency} RatedOperatingTemperature: {pVSystemMaterial.RatedOperatingTemperature} ThermalPowerFactor: {pVSystemMaterial.ThermalPowerFactor}";
SystemLog.New("PVSystemMaterialEdit", comment, null, false);
return(RedirectToAction("Index"));
}
return(View(pVSystemMaterial));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,MeteoDataSourceId,MeteoDataPeriodicityId,Code,GroupEN,GroupKZ,GroupRU,NameEN,NameKZ,NameRU,AdditionalEN,AdditionalKZ,AdditionalRU,DescriptionEN,DescriptionKZ,DescriptionRU")] MeteoDataType meteoDataType)
{
if (ModelState.IsValid)
{
MeteoDataType mdt = null;
using (var dblocal = new NpgsqlContext())
{
mdt = dblocal.MeteoDataTypes.Where(m => m.Id == meteoDataType.Id).FirstOrDefault();
dblocal.Dispose();
GC.Collect();
}
meteoDataType.Code = mdt.Code;
meteoDataType.AdditionalEN = mdt.AdditionalEN;
meteoDataType.GroupEN = mdt.GroupEN;
db.Entry(meteoDataType).State = EntityState.Modified;
await db.SaveChangesAsync();
string comment = $"Id: {mdt.Id} MeteoDataSourceId: {mdt.MeteoDataSourceId} MeteoDataPeriodicityId: {mdt.MeteoDataPeriodicityId} Code: {mdt.Code}";
if (!string.IsNullOrEmpty(mdt.GroupEN))
{
comment += $" GroupEN: {mdt.GroupEN} GroupKZ: {mdt.GroupKZ} GroupRU: {mdt.GroupRU}";
}
comment += $" NameEN: {mdt.NameEN} NameKZ: {mdt.NameKZ} NameRU: {mdt.NameRU}";
if (!string.IsNullOrEmpty(mdt.AdditionalEN))
{
comment += $" AdditionalEN: {mdt.AdditionalEN}";
}
if (!string.IsNullOrEmpty(mdt.AdditionalKZ))
{
comment += $" AdditionalKZ: {mdt.AdditionalKZ}";
}
if (!string.IsNullOrEmpty(mdt.AdditionalRU))
{
comment += $" AdditionalRU: {mdt.AdditionalRU}";
}
if (!string.IsNullOrEmpty(mdt.DescriptionEN))
{
comment += $" DescriptionEN: {mdt.DescriptionEN} DescriptionKZ: {mdt.DescriptionKZ} DescriptionRU: {mdt.DescriptionRU}";
}
comment += $" -> MeteoDataSourceId: {meteoDataType.MeteoDataSourceId} MeteoDataPeriodicityId: {meteoDataType.MeteoDataPeriodicityId} Code: {meteoDataType.Code}";
if (!string.IsNullOrEmpty(meteoDataType.GroupEN))
{
comment += $" GroupEN: {meteoDataType.GroupEN} GroupKZ: {meteoDataType.GroupKZ} GroupRU: {meteoDataType.GroupRU}";
}
comment += $" NameEN: {meteoDataType.NameEN} NameKZ: {meteoDataType.NameKZ} NameRU: {meteoDataType.NameRU}";
if (!string.IsNullOrEmpty(meteoDataType.AdditionalEN))
{
comment += $" AdditionalEN: {meteoDataType.AdditionalEN}";
}
if (!string.IsNullOrEmpty(meteoDataType.AdditionalKZ))
{
comment += $" AdditionalKZ: {meteoDataType.AdditionalKZ}";
}
if (!string.IsNullOrEmpty(meteoDataType.AdditionalRU))
{
comment += $" AdditionalRU: {meteoDataType.AdditionalRU}";
}
if (!string.IsNullOrEmpty(meteoDataType.DescriptionEN))
{
comment += $" DescriptionEN: {meteoDataType.DescriptionEN} DescriptionKZ: {meteoDataType.DescriptionKZ} DescriptionRU: {meteoDataType.DescriptionRU}";
}
SystemLog.New("MeteoDataTypeEdit", comment, null, false);
return(RedirectToAction("Index"));
}
ViewBag.MeteoDataSourceId = new SelectList(db.MeteoDataSources
.ToList()
.OrderBy(m => m.Name), "Id", "Name", meteoDataType.MeteoDataSourceId);
ViewBag.MeteoDataPeriodicityId = new SelectList(db.MeteoDataPeriodicities
.ToList()
.OrderBy(m => m.Name), "Id", "Name", meteoDataType.MeteoDataPeriodicityId);
return(View(meteoDataType));
}
public ActionResult LogOff()
{
SystemLog.New("LogOff", false);
AuthenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie);
return(RedirectToAction("Index", "Home"));
}
