public Object FacilityUsed([FromBody] MembersInput mi)
{
MembersFacilityUsedOutput mo = new MembersFacilityUsedOutput();
DataSet SelectedSlots = new DataSet();
string sJSONResponse = "";
DataTable dt_Members = new DataTable();
List <MembersFacilityUsedDetails> membersFacility = new List <MembersFacilityUsedDetails>();
try
{
dt_Members = getdata(string.Format("select convert(Date,FacilityStartDate) as FacilityStartDate,convert(Date,FacilityExpireDate) as FacilityExpireDate,SMFM.SubSchemName as FacilityName,CCRMMF.CreatedOn,isnull(CCRMMF.LeftOutDays,0) as NoOfDays from CCRMMembershipFacility CCRMMF,SubMembersFacilityMaster SMFM where CCRMMF.MFDID=SMFM.MFMID and CCRMMF.InvoiceID='{0}' ", mi.Invoice));
for (int i = 0; i < dt_Members.Rows.Count; i++)
{
MembersFacilityUsedDetails MembersFacilityUsedDetails = new MembersFacilityUsedDetails {
FacilityStartDate = Convert.ToDateTime(dt_Members.Rows[i]["FacilityStartDate"].ToString()), FacilityExpireDate = Convert.ToDateTime(dt_Members.Rows[i]["FacilityExpireDate"].ToString()), FacilityName = dt_Members.Rows[i]["FacilityName"].ToString(), NoOfDays = Convert.ToInt32(dt_Members.Rows[i]["NoOfDays"].ToString()), CreatedOn = Convert.ToDateTime(dt_Members.Rows[i]["CreatedOn"].ToString())
};
membersFacility.Add(MembersFacilityUsedDetails);
}
mo.status = "success";
mo.value = membersFacility;
sJSONResponse = JsonConvert.SerializeObject(mo);
}
catch (Exception ec)
{
mo.status = "fail";
sJSONResponse = JsonConvert.SerializeObject(mo);
}
return(sJSONResponse);
}
public Object GetMembersSearch([FromBody] MembersInput mi)
{
MembersOutput mo = new MembersOutput();
DataSet SelectedSlots = new DataSet();
string sJSONResponse = "";
string MembershipCode = "";
string MobileNo = "";
string Name = "";
DataTable dt_Members = new DataTable();
List <MembersDetails> dalots = new List <MembersDetails>();
//mi.MemberShipCode, mi.MobileNo, mi.UserName
if (mi.MemberShipCode == null && mi.MobileNo == null && mi.UserName == null)
{
MobileNo = "0";
Name = "0";
MembershipCode = "0";
}
else if (mi.MemberShipCode != null)
{
MobileNo = "0";
Name = "0";
MembershipCode = mi.MemberShipCode;
}
else if (mi.MobileNo != null)
{
MembershipCode = "0";
Name = "0";
MobileNo = mi.MobileNo;
}
else if (mi.UserName != null)
{
MembershipCode = "0";
MobileNo = "0";
Name = mi.UserName;
}
try
{
dt_Members = getdata(string.Format("select U.UCode as MemberShipCode, U.Firstname as UserName, U.Email, U.DateOfBirth, CCRMS.StartDate, CCRMS.MembershipExpireDate, U.MobileNo, U.Gender,U.PhotoUrl,CCRMS.BranchCode,B.BranchName from Users U, CCRMMembership CCRMS,Branch B where B.BranchCode=CCRMS.BranchCode and U.UCode= CCRMS.MembershipCode and CCRMS.MembershipCode like '{0}%' and CCRMS.MembershipCode<>'' union all select U.UCode as MemberShipCode, U.Firstname as UserName, U.Email, U.DateOfBirth, CCRMS.StartDate, CCRMS.MembershipExpireDate, U.MobileNo, U.Gender,U.PhotoUrl,CCRMS.BranchCode,B.BranchName from Users U, CCRMMembership CCRMS,Branch B where B.BranchCode=CCRMS.BranchCode and U.UCode= CCRMS.MembershipCode and U.MobileNo like '{0}%' and U.MobileNo<>'' union all select U.UCode as MemberShipCode, U.Firstname as UserName, U.Email, U.DateOfBirth, CCRMS.StartDate, CCRMS.MembershipExpireDate, U.MobileNo, U.Gender,U.PhotoUrl,CCRMS.BranchCode,B.BranchName from Users U, CCRMMembership CCRMS,Branch B where B.BranchCode=CCRMS.BranchCode and U.UCode= CCRMS.MembershipCode and U.Firstname like '{0}%' and U.Firstname<>'' ", mi.SearchItem));
for (int i = 0; i < dt_Members.Rows.Count; i++)
{
MembersDetails MembersDetails = new MembersDetails {
MemberShipCode = dt_Members.Rows[i]["MemberShipCode"].ToString(), UserName = dt_Members.Rows[i]["UserName"].ToString(), Email = dt_Members.Rows[i]["Email"].ToString(), DateOfBirth = Convert.ToDateTime(dt_Members.Rows[i]["DateOfBirth"].ToString()), MembershipStartDate = dt_Members.Rows[i]["StartDate"].ToString(), MembershipExpireDate = dt_Members.Rows[i]["MembershipExpireDate"].ToString(), MobileNo = dt_Members.Rows[i]["MobileNo"].ToString(), Gender = dt_Members.Rows[i]["Gender"].ToString(), PhotoUrl = dt_Members.Rows[i]["PhotoUrl"].ToString(), BranchCode = dt_Members.Rows[i]["BranchCode"].ToString(), BranchName = dt_Members.Rows[i]["BranchName"].ToString()
};
dalots.Add(MembersDetails);
}
mo.status = "success";
mo.value = dalots;
sJSONResponse = JsonConvert.SerializeObject(mo);
}
catch (Exception ec)
{
mo.status = "fail";
sJSONResponse = JsonConvert.SerializeObject(mo);
}
return(sJSONResponse);
}
