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);
}
