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> Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            PVSystemMaterial pVSystemMaterial = await db.PVSystemMaterials.FindAsync(id);

            if (pVSystemMaterial == null)
            {
                return(HttpNotFound());
            }
            return(View(pVSystemMaterial));
        }
        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> Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            PVSystemMaterial pVSystemMaterial = await db.PVSystemMaterials.FindAsync(id);

            if (pVSystemMaterial == null)
            {
                return(HttpNotFound());
            }

            ViewBag.Role = "";
            string CurrentUserId = User.Identity.GetUserId();

            if (UserManager.IsInRole(CurrentUserId, "Admin"))
            {
                ViewBag.Role = "Admin";
            }

            return(View(pVSystemMaterial));
        }
        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));
        }