public async Task <IActionResult> Edit(string id, [Bind("SubstationId,SubstationTypeId,SubstationName,SnDCode,NominalVoltage,InstalledCapacity,MaximumDemand,PeakLoad,Location,AreaOfSubstation,Latitude,Longitude,YearOfComissioning")] TblSubstation tblSubstation) { if (id != tblSubstation.SubstationId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(tblSubstation); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TblSubstationExists(tblSubstation.SubstationId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["SubstationTypeId"] = new SelectList(_context.LookUpSubstationType, "SubstationTypeId", "SubstationTypeId", tblSubstation.SubstationTypeId); ViewData["SnDCode"] = new SelectList(_context.LookUpSnDInfo, "SnDCode", "SnDCode", tblSubstation.SnDCode); return(View(tblSubstation)); }
public async Task <IActionResult> Create([Bind("SubstationId,SubstationTypeId,SubstationName,SnDCode,NominalVoltage,InstalledCapacity,MaximumDemand,PeakLoad,Location,AreaOfSubstation,Latitude,Longitude,YearOfComissioning")] TblSubstation tblSubstation) { //if (tblSubstation.IsEmpty() != "") //{ // ViewData["Error"] = tblSubstation.IsEmpty(); // return Redirect("Create"); //} //try //{ if (ModelState.IsValid) { _context.Add(tblSubstation); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } //} //catch (Exception e) //{ // ViewData["Error"]= e; // throw; //} //ViewData["SubstationTypeId"] = new SelectList(_context.LookUpSubstationType, "SubstationTypeId", "SubstationTypeName", tblSubstation.SubstationTypeId); //ViewData["SnDCode"] = new SelectList(_context.LookUpSnDInfo, "SnDCode", "SnDCode", tblSubstation.SnDCode); var SubstationTypeInfoes = _context.LookUpSubstationType.Select(agn => new { Code = agn.SubstationTypeId, Name = agn.SubstationTypeId + " : " + agn.SubstationTypeName }); ViewData["SubstationTypeId"] = new SelectList(SubstationTypeInfoes, "Code", "Name"); //ViewData["SnDCode"] = new SelectList(_context.LookUpSnDInfo, "SnDCode", "SnDCode"); var SnDInfoes = _context.LookUpSnDInfo.Select(agn => new { Code = agn.SnDCode, Name = agn.SnDCode + " : " + agn.SnDName }); ViewData["SnDCode"] = new SelectList(SnDInfoes, "Code", "Name"); return(View(tblSubstation)); }