public object GetNonTransactingResult(string GroupId, string outletId) { if (User.Identity.IsAuthenticated) { string connectionString = CR.GetCustomerConnString(GroupId); if (outletId.Equals("All")) { outletId = ""; } NonTransactingCls objNonTransactingCls = new NonTransactingCls(); objNonTransactingCls = KR.GetNonTransactingData(GroupId, outletId, connectionString); return(new { Data = objNonTransactingCls, MaxJsonLength = Int32.MaxValue }); } return("Invalid Token or Expired"); }
public JsonResult GetNonTransactingResult(string outletId) { var userDetails = (CustomerLoginDetail)Session["UserSession"]; if (outletId.Equals("All")) { outletId = ""; } NonTransactingCls objNonTransactingCls = new NonTransactingCls(); objNonTransactingCls = KR.GetNonTransactingData(userDetails.GroupId, outletId, userDetails.connectionString); return(new JsonResult() { Data = objNonTransactingCls, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = Int32.MaxValue }); }
public NonTransactingCls GetNonTransactingData(string GroupId, string outletId, string connstr) { NonTransactingCls objNonTransacting = new NonTransactingCls(); try { using (var context = new BOTSDBContext(connstr)) { objNonTransacting = context.Database.SqlQuery <NonTransactingCls>("sp_BOTS_NonTransacting @pi_GroupId, @pi_Date, @pi_LoginId, @pi_OutletId", new SqlParameter("@pi_GroupId", GroupId), new SqlParameter("@pi_Date", DateTime.Now.ToShortDateString()), new SqlParameter("@pi_LoginId", ""), new SqlParameter("@pi_OutletId", outletId)).FirstOrDefault <NonTransactingCls>(); } } catch (Exception ex) { newexception.AddException(ex, GroupId); } return(objNonTransacting); }