public JsonResult GetMemberMisinformationData()
{
var userDetails = (CustomerLoginDetail)Session["UserSession"];
MembersInformation objMembersInformation = new MembersInformation();
objMembersInformation = KR.GetMemberMisinformationData(userDetails.GroupId, userDetails.connectionString);
return(new JsonResult()
{
Data = objMembersInformation, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = Int32.MaxValue
});
}
public MembersInformation GetMemberMisinformationData(string GroupId, string connstr)
{
MembersInformation objMembersInformation = new MembersInformation();
try
{
using (var context = new BOTSDBContext(connstr))
{
objMembersInformation = context.Database.SqlQuery <MembersInformation>("sp_BOTS_MemberInformation @pi_GroupId, @pi_Date, @pi_LoginId",
new SqlParameter("@pi_GroupId", GroupId),
new SqlParameter("@pi_Date", DateTime.Now.ToShortDateString()),
new SqlParameter("@pi_LoginId", "")).FirstOrDefault <MembersInformation>();
}
}
catch (Exception ex)
{
newexception.AddException(ex, GroupId);
}
return(objMembersInformation);
}
