public ActionResult Assign(String mMapID) { if (Session["Login"] != null) { LoginSession loginsession = (LoginSession)Session["Login"]; ViewBag.CompanyLogo = loginsession.CompanyLogo; ViewBag.Layout1 = BAL.Common.LayoutType(loginsession.UserType); String actionName = this.ControllerContext.RouteData.Values["action"].ToString(); String controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ViewBag.Menu = BAL.Common.GetActiveMenu(controllerName, actionName, BAL.Common.LayoutType(loginsession.UserType)); ViewBag.RoleName = loginsession.RoleName; if (mMapID != null) { try { String DecMapID = BAL.Security.URLDecrypt(mMapID); DAL.DataLoggerMapping logger = new DataLoggerMapping(); logger = DAL.DALDataLogger.ViewDataLoggerMappingRecord(DecMapID); DataLoggerMapClass lg = new DataLoggerMapClass(); lg.Mapid = Convert.ToInt64(DecMapID); lg.LoggerSerial = logger.LoggerSerial; lg.ClientName = logger.Client; lg.SiteName = logger.Site; lg.CommunicationName = logger.Communication; lg.StartDate = logger.StartDate; ViewBag.MapID = DecMapID; return View(lg); } catch (Exception ex) { Console.Write(ex.Message); } } return View(); } else { return RedirectToAction("Index", "Home"); } }
public static DataLoggerMapping ViewDataLoggerMappingRecord(String MapID) { DataLoggerMapping logger = new DataLoggerMapping(); try { using (var context = new SycousCon()) { var parMapID = new SqlParameter { ParameterName = "MapID", Value = MapID, Direction = ParameterDirection.Input }; logger = context.ExecuteStoreQuery<DataLoggerMapping>("exec SYCOUS.GetAssignDataLogger @MapID", parMapID).FirstOrDefault(); } } catch (Exception ex) { throw; } return logger; }
public ActionResult UpdateLoggerMapping(List<DataLoggerInPropertyMaster> Logger) { if (Session["Login"] != null) { LoginSession loginsession = (LoginSession)Session["Login"]; try { List<DataLoggerInPropertyMaster> LoggerList = new List<DataLoggerInPropertyMaster>(); LoggerList = Logger; var MappingID = LoggerList.Select(a => a.SiteMapID).FirstOrDefault(); DAL.DataLoggerMapping _logger = new DataLoggerMapping(); _logger = DAL.DALDataLogger.ViewDataLoggerMappingRecord(MappingID); LoggerList.ToList().ForEach(u => { u.CreateBy = Convert.ToInt64(loginsession.UserID); u.LoggerID = _logger.DataloggerID; u.ClientID = _logger.ClientID; u.SiteID = _logger.SiteID; u.CommonicationID = _logger.CommunicationID; u.StartDate = _logger.StartDate; }); if (BAL.DataLoggerModel.SaveMappingLoggerInProperty(LoggerList.Cast<Object>().ToList())) { return Json(new { Result = "true" }, JsonRequestBehavior.AllowGet); } else { return Json(new { Result = "false" }, JsonRequestBehavior.AllowGet); } } catch (Exception ex) { return Content("Error:" + ex.StackTrace.ToString()); } } return View(); }
public ActionResult PropertyMap() { if (Session["Login"] != null) { LoginSession loginsession = (LoginSession)Session["Login"]; ViewBag.CompanyLogo = loginsession.CompanyLogo; ViewBag.Layout1 = BAL.Common.LayoutType(loginsession.UserType); String actionName = this.ControllerContext.RouteData.Values["action"].ToString(); String controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ViewBag.Menu = BAL.Common.GetActiveMenu(controllerName, actionName, BAL.Common.LayoutType(loginsession.UserType)); ViewBag.RoleName = loginsession.RoleName; IEnumerable<DAL.MeterDetails> MeterList = null; try { String LoggerID = Request.Form["hdLoggerID"]; String Client = Request.Form["Client"]; String Site = Request.Form["Site"]; String Type = Request.Form["hdType"]; String MapID = Request.Form["hdMapID"]; if ((loginsession.ClientID != null)&&(Client !=null)) { ViewBag.ClientList = new SelectList(BAL.ClientModel.ClientDropDownList(loginsession.ClientID), "Value", "Text", Client); ViewBag.SiteList = new SelectList(BAL.SiteModel.SiteDropDownList(loginsession.UserID.ToString(), Convert.ToInt64(Client), loginsession.UserType.ToString(), loginsession.RoleName), "Value", "Text", Site); } else { ViewBag.ClientList = new SelectList(BAL.ClientModel.ClientDropDownList(), "Value", "Text"); } ViewBag.Communication = new SelectList(BAL.CommunicationModel.CommunicationDropDownList(), "Value", "Text"); if (LoggerID != null) { ViewBag.LoggerID = LoggerID; DAL.DataLoggerlist Logger = new DataLoggerlist(); Logger = BAL.DataLoggerModel.ViewDataLogger(LoggerID); ViewBag.LoggerID = Logger.ID; ViewBag.LoogerSerial = Logger.SerialNumber; } ViewBag.TYPE = Type; ViewBag.MapID = MapID; DAL.DataLoggerMapping logger = new DataLoggerMapping(); if (Type == "Assign") { logger = DAL.DALDataLogger.ViewDataLoggerMappingRecord(MapID); MeterList = BAL.DataLoggerModel.GetMeterDeatailsRecordList(logger.DataloggerID, logger.ClientID, logger.SiteID); } else { if ((LoggerID != null) && (Client != null) && (Site != null)) { MeterList = BAL.DataLoggerModel.GetMeterDeatailsRecordList(LoggerID, Client, Site); } } return View(MeterList); } catch (Exception ex) { return Content("ErrorMessage" + ":" + ex.StackTrace.ToString()); } } else { return RedirectToAction("Index", "Home"); } }
public ActionResult PropertyMap(String mloggerID, String Type, String MapID) { if (Session["Login"] != null) { LoginSession loginsession = (LoginSession)Session["Login"]; ViewBag.CompanyLogo = loginsession.CompanyLogo; ViewBag.Layout1 = BAL.Common.LayoutType(loginsession.UserType); String actionName = this.ControllerContext.RouteData.Values["action"].ToString(); String controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ViewBag.Menu = BAL.Common.GetActiveMenu(controllerName, actionName, BAL.Common.LayoutType(loginsession.UserType)); ViewBag.RoleName = loginsession.RoleName; IEnumerable<DAL.MeterDetails> MeterList = null; try { if (loginsession.ClientID != null) { ViewBag.ClientList = new SelectList(BAL.ClientModel.ClientDropDownList(loginsession.ClientID), "Value", "Text"); } else { ViewBag.ClientList = new SelectList(BAL.ClientModel.ClientDropDownList(), "Value", "Text"); } if( (mloggerID != null)&&(Type != null)) { String _LoggerID = BAL.Security.URLDecrypt(mloggerID); String _Type = BAL.Security.URLDecrypt(Type); String _MapID = BAL.Security.URLDecrypt(MapID); ViewBag.LoggerID = _LoggerID; DAL.DataLoggerlist Logger = new DataLoggerlist(); Logger = BAL.DataLoggerModel.ViewDataLogger(_LoggerID); ViewBag.LoggerID = Logger.ID; ViewBag.LoogerSerial = Logger.SerialNumber; ViewBag.TYPE = _Type; ViewBag.MapID = _MapID; DAL.DataLoggerMapping logger = new DataLoggerMapping(); if (_Type == "Assign") { logger = DAL.DALDataLogger.ViewDataLoggerMappingRecord(_MapID); } if (_Type == "Assign") { ViewBag.ClientList = new SelectList(BAL.ClientModel.ClientDropDownList(loginsession.ClientID), "Value", "Text", logger.ClientID); ViewBag.ClientName = logger.Client; ViewBag.SiteList = new SelectList(BAL.SiteModel.SiteDropDownList(loginsession.UserID.ToString(), Convert.ToInt64(logger.ClientID), loginsession.UserType.ToString(), loginsession.RoleName), "Value", "Text", logger.SiteID); ViewBag.siteName = logger.Site; ViewBag.Communication = new SelectList(BAL.CommunicationModel.CommunicationDropDownList(), "Value", "Text", logger.CommunicationID); ViewBag.CommunicationName = logger.Communication; ViewBag.StartDatevalue = logger.StartDate; MeterList = BAL.DataLoggerModel.GetMeterDeatailsRecordList(logger.DataloggerID, logger.ClientID, logger.SiteID); return View(MeterList); } else { ViewBag.ClientName = ""; ViewBag.siteName = ""; ViewBag.CommunicationName = ""; ViewBag.StartDatevalue = ""; ViewBag.SiteList = new SelectList(BAL.Common.Default_DDR(), "Value", "Text"); ViewBag.Communication = new SelectList(BAL.CommunicationModel.CommunicationDropDownList(), "Value", "Text"); if (loginsession.ClientID != null) { ViewBag.ClientList = new SelectList(BAL.ClientModel.ClientDropDownList(loginsession.ClientID), "Value", "Text"); } else { ViewBag.ClientList = new SelectList(BAL.ClientModel.ClientDropDownList(), "Value", "Text"); } return View(); } //DataLoggerMapClass logger = new DataLoggerMapClass(); //DataLoggerMaster loggermaster = new DataLoggerMaster(); //loggermaster = BAL.DataLoggerModel.EditDataLogger(Dec_LoggerID); //logger.LoggerId = Convert.ToInt32(Dec_LoggerID); //logger.LoggerSerial = loggermaster.SerialNumber; } else { return View(); } } catch (Exception ex) { return Content("ErrorMessage" + ":" + ex.StackTrace.ToString()); } } else { return RedirectToAction("Index", "Home"); } }