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 void Create(PloatBooking oPloatBooking)
{
using (var scope = new TransactionScope())
{
try
{
using (var ctx = new BHGroupEntities())
{
oPloatBooking.StartDate = DateTime.Now;
oPloatBooking.EndDate = DateTime.Now.AddMonths(75);
if (oPloatBooking.PloatType == En_PloatType.WeekendHome.ToString())
{
oPloatBooking.Amt = 600000;
oPloatBooking.PlotDesc = "100 sq. yard Net (140 sq. yard Super Build Up)";
}
else if (oPloatBooking.PloatType == En_PloatType.Villa.ToString())
{
oPloatBooking.Amt = 600000 * 2;
oPloatBooking.PlotDesc = "200 sq. yard Net (280 sq. yard Super Build Up)";
}
else if (oPloatBooking.PloatType == En_PloatType.FarmHouse.ToString())
{
oPloatBooking.Amt = 600000 * 3;
oPloatBooking.PlotDesc = "400 sq. yard Net (420 sq. yard Super Build Up)";
}
oPloatBooking.NetAmt = (oPloatBooking.Amt * oPloatBooking.Qty);
ctx.PloatBookings.Add(oPloatBooking);
int token = 0;
if (oPloatBooking.PloatType == En_PloatType.WeekendHome.ToString())
token = 1;
else if (oPloatBooking.PloatType == En_PloatType.Villa.ToString())
token = 2;
else if (oPloatBooking.PloatType == En_PloatType.FarmHouse.ToString())
token = 3;
int count_token = (token * oPloatBooking.Qty);
for (int i = 0; i < count_token; i++)
{
DrowToken oDrow = new DrowToken();
oDrow.MemberId = oPloatBooking.MemberId;
oDrow.PlotBookingId = oPloatBooking.PloatBookingId;
oDrow.Status = En_DrowStatus.Active.ToString();
oDrow.Creaton = System.DateTime.Now;
oDrow.Modifiedon = System.DateTime.Now;
ctx.DrowTokens.Add(oDrow);
}
ctx.SaveChanges();
scope.Complete();
}
}
catch (Exception ex)
{
scope.Dispose();
throw ex;
}
}
}
public MemberPayroll GetById(int id)
{
try
{
using (var ctx = new BHGroupEntities())
{
return ctx.MemberPayrolls.Where(p => p.PaymentId == id).SingleOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
}
// 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 List<DrowToken> GetById(int id)
{
try
{
using (var ctx = new BHGroupEntities())
{
return ctx.DrowTokens.Where(p => p.PlotBookingId == id).ToList();
}
}
catch (Exception ex)
{
throw ex;
}
}
public AdminLogin GetByName(string Username)
{
try
{
using (var ctx = new BHGroupEntities())
{
return ctx.AdminLogins.Where(p => p.UserName == Username).SingleOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
}
public AdminLogin ValidUser()
{
try
{
using (var ctx = new BHGroupEntities())
{
return ctx.AdminLogins.Where(p => p.UserName == "Admin").SingleOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Update(AdminLogin oAdmin)
{
try
{
using (var ctx = new BHGroupEntities())
{
ctx.Entry(oAdmin).State = EntityState.Modified;
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string GetMembershipNo()
{
try
{
using (var ctx = new BHGroupEntities())
{
int? no = ctx.Members.Max(u => u.MemberId);
int mno = no == 0 ? 0 : no.Value + 1;
return "1000" + mno;
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Delete(int id)
{
try
{
using (var ctx = new BHGroupEntities())
{
MemberPayroll oMemberPayroll = ctx.MemberPayrolls.Where(p => p.PaymentId == id).FirstOrDefault();
ctx.MemberPayrolls.Remove(oMemberPayroll);
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Create(MemberPayroll oMemberPayroll)
{
try
{
using (var ctx = new BHGroupEntities())
{
oMemberPayroll.CreatOn = System.DateTime.Now;
ctx.MemberPayrolls.Add(oMemberPayroll);
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public List<SelectListItem> GetAllMemberLookUp(int? selectedId)
{
using (var ctx = new BHGroupEntities())
{
var query = ctx.Members.OrderBy(o => o.Name);
List<SelectListItem> MemberLookUp =
query.ToList().Select(s => new SelectListItem
{
Selected = (selectedId.HasValue && s.MemberId == selectedId),
Text = s.Name,
Value = s.MemberId.ToString()
}).ToList();
return MemberLookUp;
}
}
public void Update(PloatBooking oPloat)
{
try
{
using (var ctx = new BHGroupEntities())
{
ctx.Entry(oPloat).State = EntityState.Modified;
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public vw_PlotBooking GetLetterDetails(int id)
{
try
{
using (var ctx = new BHGroupEntities())
{
return ctx.vw_PlotBooking.Where(p => p.PloatBookingId == id).SingleOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
}
public PloatBooking GetById(int id)
{
try
{
using (var ctx = new BHGroupEntities())
{
return ctx.PloatBookings.Where(p => p.PloatBookingId == id).SingleOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
}
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;
}
}
public Member GetMember(int MemberShipNo)
{
try
{
using (var ctx = new BHGroupEntities())
{
return ctx.Members.Where(p => p.MemberShipNo == MemberShipNo).SingleOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Updatestatus(int id)
{
try
{
using (var ctx = new BHGroupEntities())
{
MemberPayroll oMemberpayroll = ctx.MemberPayrolls.Where(p => p.PaymentId == id).FirstOrDefault();
if (oMemberpayroll.Status == "Active")
{
oMemberpayroll.Status = "InActive";
}
else
{
oMemberpayroll.Status = "Active";
}
ctx.Entry(oMemberpayroll).State = EntityState.Modified;
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Update(MemberPayroll oMemberPayroll)
{
try
{
using (var ctx = new BHGroupEntities())
{
ctx.Entry(oMemberPayroll).State = EntityState.Modified;
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public List<SelectListItem> GetBrokerLookup()
{
using (var ctx = new BHGroupEntities())
{
var query = ctx.Members.Where(x => x.MemberType == "Broker").OrderBy(o => o.Name);
List<SelectListItem> MemberLookUp =
query.ToList().Select(s => new SelectListItem
{
Selected = (s.MemberId == 0),
Text = s.Name,
Value = s.MemberId.ToString()
}).ToList();
return MemberLookUp;
}
}
public void Delete(int id)
{
try
{
using (var ctx = new BHGroupEntities())
{
PloatBooking oPloat = ctx.PloatBookings.Where(p => p.PloatBookingId == id).FirstOrDefault();
ctx.PloatBookings.Remove(oPloat);
ctx.SaveChanges();
}
}
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;
}
}
