public JsonResult ConsumerDetails(String mConsumerID) { if (Session["Login"] != null) { try { LoginSession loginsession = (LoginSession)Session["Login"]; if ((mConsumerID != null) && (mConsumerID != "")) { ConsumerList Consumer = new ConsumerList(); Consumer = BAL.SearchModel.ViewConsumer(mConsumerID); return Json(new { ConsName = Consumer.ConsumerName, ConsAddress = Consumer.ConsumerAddress, ConsCity = Consumer.City, ConsCounty = Consumer.County, ConsZipcode = Consumer.ZipCode, Owner = Consumer.OwnerName, property = Consumer.Property, ConsEmail = Consumer.Email, ConsMobile = Consumer.Mobile, ConsStartDate = Consumer.ConsumerStartDate, ConsEndDate = Consumer.ConsumerEndDate }, JsonRequestBehavior.AllowGet); } } catch (Exception ex) { return Json(null); } } return Json(null); }
public ActionResult AddConsumer(ConsumerMaster model) { 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, BAL.Common.LayoutType(loginsession.UserType)); ViewBag.RoleName = loginsession.RoleName; if (ModelState.IsValid) { try { model.CreateBy = Convert.ToInt64(loginsession.UserID); String ConsumerID = ConsumerModel.AddConsumer(model); if ((!String.IsNullOrEmpty(ConsumerID))&& (ConsumerID !="0")) { DAL.ConsumerList ConsumerObj = new ConsumerList(); ConsumerObj = BAL.ConsumerModel.ConsumerBySearchParmaterInfo(ConsumerID); if (ConsumerObj != null) { return RedirectToAction("ConsumerDetails", "Search", new { consID = BAL.Security.URLEncrypt(ConsumerObj.ID), OwnerID = BAL.Security.URLEncrypt(ConsumerObj.OwnerID), PropID = BAL.Security.URLEncrypt(ConsumerObj.PropertyID), SiteID = BAL.Security.URLEncrypt(ConsumerObj.SiteID), ClientID = BAL.Security.URLEncrypt(ConsumerObj.ClientID), MeterID = BAL.Security.URLEncrypt("0") }); } else { return RedirectToAction("Index", "Search", new { Field = BAL.Security.URLEncrypt(Convert.ToString("2")), search = "0" }); } } else { return Content("Unable to save , try again"); } } catch (Exception ex) { return Json(new { result = 0, message = "ErrorMessage" + ":" + ex.StackTrace.ToString() }); } } else { String errorMessage = String.Empty; String exception = String.Empty; foreach (var modelStateVal in ViewData.ModelState.Values) { foreach (var error in modelStateVal.Errors) { errorMessage = error.ErrorMessage; exception = error.Exception.ToString(); } } return Json(new { result = 0, message = "ErrorMessage" + ":" + exception }); } } else { return RedirectToAction("Index", "Home"); } }
public ActionResult CView(String ConsumerID) { 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 (ConsumerID != null) { String DecConsumerID = BAL.Security.URLDecrypt(ConsumerID); DAL.ConsumerList consumer = new DAL.ConsumerList(); if ((DecConsumerID != "0") && (DecConsumerID != null)) { try { consumer = BAL.ConsumerModel.ViewConsumer(DecConsumerID); } catch (Exception ex) { return Content("Execption:" + ex.Message); } } return View(consumer); } else { return RedirectToAction("Index", "Consumer"); } } else { return RedirectToAction("Index", "Home"); } }
}// AddRecord public Object RecordView(String ConsumerID) { DAL.ConsumerList consumer = new DAL.ConsumerList(); try { consumer = DAL.DALConsumerCls.ViewConsumer(ConsumerID); } catch (Exception ex) { throw; } return consumer; }//ViewRecord
public Object ViewRecord(Int64 ConsumerID) { DAL.ConsumerList consumer = new DAL.ConsumerList(); try { consumer = DAL.DALConsumer.ViewConsumer(Convert.ToInt64(ConsumerID)); } catch (Exception ex) { throw; } return consumer; }//ViewRecord
public static ConsumerList ViewConsumer(String ConsumerID) { ConsumerList Consumer = new ConsumerList(); using (var context = new SycousCon()) { try { var parID = new SqlParameter { ParameterName = "ID", Value = ConsumerID, Direction = ParameterDirection.Input }; Consumer = context.ExecuteStoreQuery<ConsumerList>("exec [SYCOUS].[GetConsumerDetails] @ID", parID).FirstOrDefault(); return Consumer; } catch (Exception ex) { context.Dispose(); throw; } } }
public static ConsumerList ViewConsumer(Int64 ConsumerID) { ConsumerList objconsumer = new ConsumerList(); using (var context = new SycousCon()) { try { objconsumer = (from Y in context.Consumers join P in context.Properties on Y.PropertyID equals P.ID join O in context.Owners on Y.OwnerID equals O.ID join S in context.SiteMasters on P.SiteID equals S.Id join C in context.ClientMasters on S.ClientID equals C.ClientID // join R in context.ConsumerRegs // on Y.ID equals R.ConsumerID //join U in context.UserREGs //on R.USERID equals U.UserID where (Y.IsDeleted == 0 && P.IsDeleted == 0 && O.IsDeleted == 0 && Y.ID == ConsumerID ) orderby Y.CreateDate descending, Y.ModifyDate descending select new ConsumerList() { ID = SqlFunctions.StringConvert((Double)Y.ID).Trim(), Property = P.PropertyNumber + " " + P.Address1 , Client = C.Name, Site = S.SiteName, Owner = ((O.FirstName.Trim() != "") ? O.FirstName.Trim() : "") + " " + ((O.LastName.Trim() == null) ? "" : O.LastName.Trim()), ConsumerName = ((Y.FirstName.Trim() != "") ? Y.FirstName.Trim() : "") + " " + ((Y.LastName.Trim() == null) ? "" : Y.LastName.Trim()), StartDate = Y.StartDate, EndDate = Y.EndDate, Address1 = Y.Address1, Address2 = Y.Address2, City = Y.City, County = Y.County, ZipCode = Y.ZipCode, Email = Y.Email, Mobile = Y.Mobile, BankName = Y.BankName, BankSortCode = Y.BankSortCode, BankAccount = Y.BankAccount, // RegistrationEmail = R.Email //FirstName= U.FirstName, //LastName = U.LastName, //Question =U.HintQuestion, //Answer =U.HintAns ClientRef=Y.ClientRefNo, Notes = Y.Notes }).FirstOrDefault(); return objconsumer; } catch (Exception ex) { context.Dispose(); throw; } } }