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 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 ActionResult GridUpdateTemp(MVCxGridViewBatchUpdateValues <TBL_ALARM_TEMP, int> updateValues)
{
//object curObj;
try
{
string curUserId = User.Identity.GetUserId();
foreach (TBL_ALARM_TEMP tag in updateValues.Insert)
{
if (updateValues.IsValid(tag))
{
DB.AlarmTemplate.Add(tag);
}
}
foreach (TBL_ALARM_TEMP tag in updateValues.Update)
{
if (updateValues.IsValid(tag))
{
TBL_ALARM_TEMP ent = DB.AlarmTemplate.FirstOrDefault(x => x.ID == tag.ID);
ent.UPDATED_DATE = DateTime.Now;
ent.UPDATE_USER = curUserId;
ent.NAME = tag.NAME;
}
}
DB.SaveChanges();
foreach (var tagIg in updateValues.DeleteKeys)
{
DB.AlarmTemplate.Where(x => x.ID == tagIg)
.Update(x => new TBL_ALARM_TEMP()
{
IS_DELETED = true
});
}
return(PartialView("AlarmTempGridPartial"));
}
catch (Exception ex)
{
//updateValues.SetErrorText( curObj, ex.Message);
return(PartialView("AlarmTempGridPartial"));
}
}
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()));
}
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));
}
