public string GetGridData(GridSettings grid)
{
try
{
using (var ctx = new BHGroupEntities())
{
var query = ctx.DrowTokens.Include("Member").AsQueryable();
int count;
var data = query.GridCommonSettings(grid, out count);
var result = new
{
total = (int)Math.Ceiling((double)count / grid.PageSize),
page = grid.PageIndex,
records = count,
rows = (from p in data
select new
{
id = p.DrowTokenId,
Name = p.Member.Name,
Status = p.Status,
Creaton = p.Creaton,
Action = p.DrowTokenId
}).ToArray()
};
return JsonConvert.SerializeObject(result, new IsoDateTimeConverter());
}
}
catch (Exception ex)
{
throw ex;
}
}
public string GetGridData(GridSettings grid)
{
try
{
return new PayrollBAL().GetGridData(grid,null);
}
catch (Exception ex)
{
return "";
}
}
public string GetGridData(GridSettings grid)
{
try
{
return new MemberBAL().GetGridData(grid,"Member");
}
catch (Exception ex)
{
return "";
}
}
public string GetGridData(GridSettings grid)
{
try
{
return new PloatBookingBAL().GetGridData(grid);
}
catch (Exception ex)
{
return "";
}
}
public string GetGridDataReports(GridSettings grid, int id, string type)
{
try
{
return new MemberBAL().GetGridDataReports(grid, type, id);
}
catch (Exception ex)
{
return "";
}
}
public string GetGridData(GridSettings grid)
{
try
{
// var Member = _MemberBAL.GetByName(Convert.ToInt32(Session["MembershipNo"]));
var Member = _MemberBAL.GetByName(User.Identity.Name);
return new PayrollBAL().GetGridData(grid, Member.MemberId);
}
catch (Exception ex)
{
return "";
}
}
// grid for Member
public string GetGridData(GridSettings grid, int? MemberId)
{
try
{
using (var ctx = new BHGroupEntities())
{
IQueryable<MemberPayroll> query;
if (MemberId != null)
{
query = ctx.MemberPayrolls.AsQueryable().Where(x => x.MemberId == MemberId);
}
else
{
query = ctx.MemberPayrolls.AsQueryable();
}
int count;
var data = query.GridCommonSettings(grid, out count);
var result = new
{
total = (int)Math.Ceiling((double)count / grid.PageSize),
page = grid.PageIndex,
records = count,
rows = (from p in data
select new
{
id = p.PaymentId,
Name = p.Member.Name,
Installment = p.Installment,
ReceiveAmt = p.ReceiveAmt,
DueAmt = p.DueAmt,
BankName = p.BankName,
AccountNo = p.AccountNo,
PaymentType = p.PaymentType,
CreatOn = p.CreatOn,
Status = p.Status,
Action = p.PaymentId
}).ToArray()
};
return JsonConvert.SerializeObject(result, new IsoDateTimeConverter());
}
}
catch (Exception ex)
{
throw ex;
}
}
public string GetGridDataReports(GridSettings grid)
{
try
{
//var Member = _MemberBAL.GetByName(Convert.ToInt32(Session["MembershipNo"].ToString()));
var Member = _MemberBAL.GetByName(User.Identity.Name);
return new MemberBAL().GetGridDataReports(grid, Member.MemberType, Member.ParentId);
}
catch (Exception ex)
{
return "";
}
}
public string GetGridDataReports(GridSettings grid, string Type, int ParentId)
{
try
{
using (var ctx = new BHGroupEntities())
{
var query = ctx.Prc_ViewCommision(ParentId, Type).ToList().AsQueryable();
int count;
var data = query.GridCommonSettings(grid, out count);
var result = new
{
total = (int)Math.Ceiling((double)count / grid.PageSize),
page = grid.PageIndex,
records = count,
rows = (from p in data
select new
{
id = p.MemberId,
Name = p.Name,
MemberShipNo = p.MemberShipNo,
MemberType = p.MemberType,
PloatType = p.PloatType,
Qty = p.Qty,
Total_Commision = p.Total_Commision,
Action = p.MemberId
}).ToArray()
};
return JsonConvert.SerializeObject(result, new IsoDateTimeConverter());
}
}
catch (Exception ex)
{
throw ex;
}
}
// grid for Member
public string GetGridData(GridSettings grid, string Type)
{
try
{
using (var ctx = new BHGroupEntities())
{
IQueryable<Member> query;
if (Type == "Franchies")
{
query = ctx.Members.AsQueryable().Where(x => ((x.MemberType == "Franchies") || (x.MemberType == "Distributers")));
}
else
{
query = ctx.Members.AsQueryable().Where(x => ((x.MemberType == "Member") || (x.MemberType == "Broker")));
}
int count;
var data = query.GridCommonSettings(grid, out count);
var result = new
{
total = (int)Math.Ceiling((double)count / grid.PageSize),
page = grid.PageIndex,
records = count,
rows = (from p in data
select new
{
id = p.MemberId,
Name = p.Name,
MemberShipNo = p.MemberShipNo,
DOB = p.DOB,
Age = p.Age,
MobileNo = p.MobileNo,
EmailId = p.EmailId,
Password = p.Password,
MemberType = p.MemberType,
Action = p.MemberId
}).ToArray()
};
return JsonConvert.SerializeObject(result, new IsoDateTimeConverter());
}
}
catch (Exception ex)
{
throw ex;
}
}