public ActionResult Update(int id) { var a = id; //DateTime reqDateParam = DateTime.Parse(beginDate); //var met = DB.Summaries.Where(a => a.STATION_ID == stationId && a.tarih.Year == reqDateParam.Year // && a.tarih.Month == reqDateParam.Month && a.tarih.Day == reqDateParam.Day) // .Select(a => new Meteoroloji_DTO // { // date = a.tarih, // irradiation = (float)Math.Round((float)a.isinim, 1), // pyranometer = (float)Math.Round((float)a.PYRANOMETER, 1), // wind = (float)Math.Round((float)a.ruzgarHizi), // cell_temp = (float)Math.Round((float)a.hucreSicakligi), // external_temp = (float)Math.Round((float)a.sicaklik) // }).OrderBy(a => a.date).ToList(); //return Json(met, JsonRequestBehavior.AllowGet); var user = User.Identity.GetUserId(); EssoEntities DBModel = new EssoEntities(); var item = DBModel.AlarmStatus.Where(x => x.ID == id).FirstOrDefault(); using (EssoEntities DB = new EssoEntities()) { if (item != null) { try { DB.Entry(new TBL_ALARM_STATUS() { ID = item.ID, START_DATE = item.START_DATE, END_DATE = item.END_DATE, ERROR_NUMBER = item.ERROR_NUMBER, STATION_ID = item.STATION_ID, INVERTER_ID = item.INVERTER_ID, STATUS = item.STATUS, PROCESS_STEP = 1, USER_ID = User.Identity.GetUserId() }).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); DB.Commit(); } catch (Exception ex) { throw; } } } return(View()); }
public JsonResult SavePanelLocation(int stationId, int stringId, string locX, string locY) { var isTherePanel = DB.PanelLocations.Where(w => w.STATION_ID == stationId && w.STRING_ID == stringId).FirstOrDefault(); if (isTherePanel == null) { DB.PanelLocations.Add(new TBL_PANEL_LOCATIONS { STATION_ID = stationId, STRING_ID = stringId, LOCATIONSX = locX, LOCATIONSY = locY, UPDATE_DATE = DateTime.Now }); DB.SaveChanges(); } else { TBL_PANEL_LOCATIONS updateItem = isTherePanel; updateItem.LOCATIONSX = locX; updateItem.LOCATIONSY = locY; updateItem.UPDATE_DATE = DateTime.Now; DB.Entry(updateItem).State = EntityState.Modified; DB.SaveChanges(); } return(Json(true, JsonRequestBehavior.AllowGet)); }
public ActionResult TagGridUpdateTemp(MVCxGridViewBatchUpdateValues <TagDTO, int> updateValues) { string curUserId = User.Identity.GetUserId(); foreach (TagDTO tagDto in updateValues.Insert) { if (updateValues.IsValid(tagDto)) { TBL_TAG tag = new TBL_TAG(); tag = Mapper.Map <TagDTO, TBL_TAG>(tagDto); tag.CREATED_DATE = DateTime.Now; if (tag.IS_DIGITAL == null) { tag.IS_DIGITAL = false; } DB.Tags.Add(tag); } } foreach (TagDTO tagDto in updateValues.Update) { if (updateValues.IsValid(tagDto)) { TBL_TAG ent = DB.Tags.FirstOrDefault(x => x.ID == tagDto.ID); //ent = Mapper.Map<TagDTO, TBL_TAG>(tagDto); ent.NAME = tagDto.NAME; ent.UPDATED_DATE = DateTime.Now; ent.UPDATE_USER = curUserId; ent.IS_DIGITAL = tagDto.IS_DIGITAL; ent.IS_INV_TAG = tagDto.IS_INV_TAG.Value; ent.IS_STRING = tagDto.IS_STRING; DB.Entry(ent).State = EntityState.Modified; DB.SaveChanges(); //DB.Tags.Attach(ent); } } foreach (var tagIg in updateValues.DeleteKeys) { TBL_TAG ent = DB.Tags.FirstOrDefault(x => x.ID == tagIg); ent.IS_DELETED = true; } DB.SaveChanges(); return(PartialView("GridTagPartial")); }
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())); }
public virtual void Update(T entity) { dbSet.Attach(entity); dataContext.Entry(entity).State = EntityState.Modified; }