public ActionResult DeleteFtp(FtpDTO ftp) { try { DB.FtpList.Where(x => x.ID == ftp.ID).Delete(); DB.SaveChanges(); return(PartialView("FtpGridPartial", GetFtpList())); } catch (Exception ex) { ViewData["EditError"] = ex.Message; return(PartialView("FtpGridPartial", GetFtpList())); } }
public ActionResult InsertFtp(FtpDTO ftp) { if (ModelState.IsValid) { TBL_FTP _ftp = new TBL_FTP(); _ftp.ID = ftp.ID; _ftp.STATION_ID = ftp.STATION_ID; _ftp.IP_ADDRESS = ftp.IP_ADDRESS; _ftp.PORT_NO = ftp.PORT_NO; _ftp.USER_NAME = ftp.USER_NAME; _ftp.PASSWORD = ftp.PASSWORD; DB.FtpList.Add(_ftp); DB.SaveChanges(); } else { ViewData["EditError"] = "Please, correct all errors."; ViewData["EditableProduct"] = ftp; } return(PartialView("FtpGridPartial", GetFtpList())); }
List <FtpDTO> GetFtpList() { List <FtpDTO> _ftpList = new List <FtpDTO>(); List <TBL_FTP> ftp = DB.FtpList.ToList(); for (int i = 0; i < ftp.Count; i++) { FtpDTO _ftp = new FtpDTO(); _ftp.ID = ftp[i].ID; _ftp.STATION_ID = ftp[i].STATION_ID; _ftp.STATION_NAME = (from t in DB.Stations join tt in DB.FtpList on t.ID equals tt.STATION_ID where t.ID == tt.STATION_ID select t.NAME).FirstOrDefault(); _ftp.IP_ADDRESS = ftp[i].IP_ADDRESS; _ftp.PORT_NO = ftp[i].PORT_NO; _ftp.USER_NAME = ftp[i].USER_NAME; _ftp.PASSWORD = ftp[i].PASSWORD; _ftpList.Add(_ftp); } return(_ftpList); }
public ActionResult UpdateFtp(FtpDTO ftp) { if (ModelState.IsValid) { TBL_FTP _ftp = DB.FtpList.AsNoTracking().FirstOrDefault(x => x.ID == ftp.ID); _ftp.ID = ftp.ID; _ftp.STATION_ID = ftp.STATION_ID; _ftp.IP_ADDRESS = ftp.IP_ADDRESS; _ftp.PORT_NO = ftp.PORT_NO; _ftp.USER_NAME = ftp.USER_NAME; _ftp.PASSWORD = ftp.PASSWORD; DB.Entry(_ftp).State = EntityState.Modified; DB.SaveChanges(); } else { ViewData["EditError"] = "Please, correct all errors."; ViewData["EditableProduct"] = ftp; } return(PartialView("FtpGridPartial", GetFtpList())); }