public List <dynamic> GetDuedate()
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
return(GetDuedates(db.RENTAL_AGREEMENT.Where(zz => zz.DepositDueDate > DateTime.Today).ToList()));
}
private List <dynamic> GetDuedates(List <RENTAL_AGREEMENT> forbros)
{
List <dynamic> dynamicduedates = new List <dynamic>();
INF370Entities db = new INF370Entities();
foreach (RENTAL_AGREEMENT dd in forbros)
{
var usr = db.RENTAL_AGREEMENT.Where(zz => zz.RENTALAGREEMENTID == dd.RENTALAGREEMENTID).FirstOrDefault();
var rent = db.RENTALAPPLICATIONs.ToList();
var clnt = db.CLIENTs.ToList();
dynamic dynamicduedate = new ExpandoObject();
dynamicduedate.RENTALAGREEMENTID = dd.RENTALAGREEMENTID;
dynamicduedate.DepositDueDate = dd.DepositDueDate;
dynamicduedate.RENTALSTATUSID = dd.RENTALSTATUSID;
//dynamicduedate.USERID = dd.USERID;
dynamicduedate.CLIENTID = dd.CLIENTID;
dynamicduedate.RENTALAPPLICATIONID = dd.RENTALAPPLICATIONID;
dynamicduedate.PROPERTYID = dd.PROPERTYID;
dynamicduedate.RENTALSTARTDATE = dd.RENTALSTARTDATE;
dynamicduedate.RENTALENDDATE = dd.RENTALENDDATE;
dynamicduedate.PAYMENTID = dd.DepositDueDate;
dynamicduedate.NAME = clnt.Where(aa => aa.CLIENTID == usr.CLIENTID).Select(a => a.NAME);
dynamicduedate.SURNAME = clnt.Where(aa => aa.CLIENTID == usr.CLIENTID).Select(a => a.SURNAME);
dynamicduedate.PHONENUMBER = clnt.Where(aa => aa.CLIENTID == usr.CLIENTID).Select(a => a.PHONENUMBER);
dynamicduedates.Add(dynamicduedate);
}
return(dynamicduedates);
}
public bool DeleteProvince(int id)
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
try
{
PROVINCE ProvinceDetails = db.PROVINCEs.Find(id);
if (ProvinceDetails == null)
{
return(false);
}
else
{
var propExist = db.CITies.Where(kk => kk.PROVINCEID == ProvinceDetails.PROVINCEID).ToList();
if (propExist.Count == 0)
{
db.PROVINCEs.Remove(ProvinceDetails);
db.SaveChanges();
}
else
{
return(false);
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}
private List <dynamic> GetApplications(List <DOCUMENT> forbros)
{
List <dynamic> dynamicapplications = new List <dynamic>();
INF370Entities db = new INF370Entities();
foreach (DOCUMENT dc in forbros)
{
var docs = db.DOCUMENTs.ToList();
var usr = db.USERs.ToList();
var clnt = db.CLIENTs.ToList();
var prop = db.PROPERTies.ToList();
dynamic dynamicapplication = new ExpandoObject();
dynamicapplication.DOCUMENTID = dc.DOCUMENTID;
dynamicapplication.IDENTITYDOCUMENT = dc.IDENTITYDOCUMENT;
dynamicapplication.RENTALAPPLICATIONID = dc.RENTALAPPLICATION.RENTALAGREEMENTID;
// dynamicapplication.USERID = dc.RENTALAPPLICATION.USERID;
dynamicapplication.CLIENTID = dc.RENTALAPPLICATION.CLIENTID;
dynamicapplication.PROPERTYID = dc.RENTALAPPLICATION.PROPERTYID;
dynamicapplication.RENTALAGREEMENTID = dc.RENTALAPPLICATION.RENTALAGREEMENTID;
dynamicapplication.RENTALAPPLICATIONSTATUSID = dc.RENTALAPPLICATION.RENTALAPPLICATIONSTATUSID;
dynamicapplication.APPLICATIONDATE = dc.RENTALAPPLICATION.APPLICATIONDATE;
dynamicapplication.PREFERREDSTARTDATE = dc.RENTALAPPLICATION.PREFERREDSTARTDATE;
dynamicapplication.NAME = clnt.Where(XX => XX.CLIENTID == dc.RENTALAPPLICATION.CLIENTID).Select(m => m.NAME);
dynamicapplication.SURNAME = clnt.Where(XX => XX.CLIENTID == dc.RENTALAPPLICATION.CLIENTID).Select(m => m.SURNAME);
dynamicapplication.EMAIL = clnt.Where(XX => XX.CLIENTID == dc.RENTALAPPLICATION.CLIENTID).Select(m => m.EMAIL);
dynamicapplication.ADDRESS = prop.Where(XX => XX.PROPERTYID == dc.RENTALAPPLICATION.PROPERTYID).Select(m => m.ADDRESS);
//dynamicapplication.USERNAME = usr.Where(XX => XX.USERID == dc.RENTALAPPLICATION.USERID).Select(m => m.USERNAME);
dynamicapplications.Add(dynamicapplication);
}
return(dynamicapplications);
}
public List <dynamic> GetRequestedJobs(int ID)
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
return(GetAssignedJobs(db.JOBs.Include(ZZ => ZZ.RENTAL_AGREEMENT).Where(zz => zz.RENTAL_AGREEMENT.CLIENTID == ID).ToList())); //zz.JOBTYPEID == 1 Maintenance guy does both repair and maintain
}
public List <dynamic> GetApprovedApplications(int ClientID)
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
return(GetApprovedApplications(db.RENTALAPPLICATIONs.Where(zz => zz.CLIENTID == ClientID && zz.RENTALAPPLICATIONSTATUSID == 1).ToList()));
}
public string ExportMySlotsCalendar(int ID)
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
try
{
var bookings = db.BOOKINGs.Where(mm => mm.USERID == ID).ToList();
var mybookings =
(from x in db.EMPLOYEEDATETIMESLOTs.AsEnumerable()
join y in bookings.AsEnumerable()
on x.BOOKINGID equals y.BOOKINGID
// where x.id.Equals(id)
select new EMPLOYEEDATETIMESLOT
{
EMPLOYEEDATETIMESLOTID = x.EMPLOYEEDATETIMESLOTID,
EMPLOYEEID = x.EMPLOYEEID,
DATETIMESLOTID = x.DATETIMESLOTID,
BOOKINGID = x.BOOKINGID
}).ToList();
return(ExportMySlotsCalendars(mybookings));
}
catch (Exception)
{
return(null);
}
}
private List <dynamic> GetAvailableSlots(List <CLIENT> forbros)
{
List <dynamic> dynamicjobs = new List <dynamic>();
INF370Entities db = new INF370Entities();
foreach (CLIENT Jb in forbros)
{
dynamic dynamicjob = new ExpandoObject();
dynamicjob.Name = db.CLIENTs.Where(zz => zz.CLIENTID == Jb.CLIENTID).Select(zz => zz.NAME).FirstOrDefault();
dynamicjob.Surname = db.CLIENTs.Where(zz => zz.CLIENTID == Jb.CLIENTID).Select(zz => zz.SURNAME).FirstOrDefault();
dynamicjob.PhoneNumber = db.CLIENTs.Where(zz => zz.CLIENTID == Jb.CLIENTID).Select(zz => zz.PHONENUMBER).FirstOrDefault();
dynamicjob.Email = db.CLIENTs.Where(zz => zz.CLIENTID == Jb.CLIENTID).Select(zz => zz.EMAIL).FirstOrDefault();
dynamicjob.Passport = db.CLIENTs.Where(zz => zz.CLIENTID == Jb.CLIENTID).Select(zz => zz.PASSPORT_NO).FirstOrDefault();
dynamicjob.Id = db.CLIENTs.Where(zz => zz.CLIENTID == Jb.CLIENTID).Select(zz => zz.ID).FirstOrDefault();
dynamicjob.Nationality = db.CLIENTs.Where(zz => zz.CLIENTID == Jb.CLIENTID).Select(zz => zz.NATIONALITY).FirstOrDefault();
dynamicjob.DateofBirth = db.CLIENTs.Where(zz => zz.CLIENTID == Jb.CLIENTID).Select(zz => zz.DATE_OF_BIRTH).FirstOrDefault();
dynamicjob.isStudent = db.CLIENTs.Where(zz => zz.CLIENTID == Jb.CLIENTID).Select(zz => zz.ISSTUDENT).FirstOrDefault();
dynamicjob.ResidentialAddress = db.CLIENTs.Where(zz => zz.CLIENTID == Jb.CLIENTID).Select(zz => zz.RESIDENTIAL_ADDRESS).FirstOrDefault();
dynamicjob.PostalAddress = db.CLIENTs.Where(zz => zz.CLIENTID == Jb.CLIENTID).Select(zz => zz.POSTAL_ADDRESS).FirstOrDefault();
dynamicjob.NameOFEmployer = db.CLIENTs.Where(zz => zz.CLIENTID == Jb.CLIENTID).Select(zz => zz.NAME_OF_EMPLOYER).FirstOrDefault();
dynamicjob.Occupation = db.CLIENTs.Where(zz => zz.CLIENTID == Jb.CLIENTID).Select(zz => zz.OCCUPATION).FirstOrDefault();
dynamicjob.WorkAddress = db.CLIENTs.Where(zz => zz.CLIENTID == Jb.CLIENTID).Select(zz => zz.WORK_ADDRESS).FirstOrDefault();
dynamicjob.WorkTel = db.CLIENTs.Where(zz => zz.CLIENTID == Jb.CLIENTID).Select(zz => zz.WORK_TEL__NO).FirstOrDefault();
dynamicjob.GrossSalary = db.CLIENTs.Where(zz => zz.CLIENTID == Jb.CLIENTID).Select(zz => zz.GROSS_SALARY).FirstOrDefault();
dynamicjobs.Add(dynamicjob);
}
return(dynamicjobs);
}
private List <dynamic> GetProperties(List <RENTAL_AGREEMENT> forbros)
{
List <dynamic> dynamicjobs = new List <dynamic>();
INF370Entities db = new INF370Entities();
foreach (RENTAL_AGREEMENT Jb in forbros)
{
dynamic dynamicjob = new ExpandoObject();
var Property = db.PROPERTies.Where(zz => zz.PROPERTYID == Jb.PROPERTYID).Select(zz => zz.ADDRESS);
dynamicjob.PropertyAddress = db.PROPERTies.Where(zz => zz.PROPERTYID == Jb.PROPERTYID).Select(zz => zz.ADDRESS);
dynamicjob.ReferenceNo = Jb.REFERENCE_NO;
dynamicjob.AmountDue = Jb.AMOUNTDUE;
dynamicjob.status = Jb.RENTALSTATUSID;
dynamicjobs.Add(dynamicjob);
//List<dynamic> RentalDetails = new List<dynamic>();
//foreach (var Details in Jb)
//{
// dynamic dynamiDetails = new ExpandoObject();
// dynamiDetails.AmountDue = Jb.AMOUNTDUE;
//}
}
return(dynamicjobs);
}
private List <dynamic> GetMySlots(List <EMPLOYEEDATETIMESLOT> forbros)
{
List <dynamic> dynamicjobs = new List <dynamic>();
INF370Entities db = new INF370Entities();
foreach (EMPLOYEEDATETIMESLOT Jb in forbros)
{
var Dateid = db.DATETIMESLOTs.Include(zz => zz.DATE).Where(zz => zz.DATETIMESLOTID == Jb.DATETIMESLOTID).Select(zz => zz.DATEID).FirstOrDefault();
var date = db.DATEs.Where(zz => zz.DATEID == Dateid).Select(zz => zz.DATEDESCRIPTION).FirstOrDefault();
var fulldate = Convert.ToDateTime(date + " " + DateTime.Today.Year).ToString("yyyy-MM-dd");
if (Convert.ToDateTime(fulldate) > DateTime.Today)
{
dynamic dynamicjob = new ExpandoObject();
dynamicjob.EmployeeDateTimeSLotID = db.EMPLOYEEDATETIMESLOTs.Where(zz => zz.EMPLOYEEDATETIMESLOTID == Jb.EMPLOYEEDATETIMESLOTID).Select(zz => zz.EMPLOYEEDATETIMESLOTID).FirstOrDefault();
dynamicjob.Name = db.EMPLOYEEs.Where(zz => zz.EMPLOYEEID == Jb.EMPLOYEEID).Select(zz => zz.NAME).FirstOrDefault();
dynamicjob.Surname = db.EMPLOYEEs.Where(zz => zz.EMPLOYEEID == Jb.EMPLOYEEID).Select(zz => zz.SURNAME).FirstOrDefault();
dynamicjob.PhoneNumber = db.EMPLOYEEs.Where(zz => zz.EMPLOYEEID == Jb.EMPLOYEEID).Select(zz => zz.PHONE_NUMBER).FirstOrDefault();
var DateID = db.DATETIMESLOTs.Include(zz => zz.DATE).Where(zz => zz.DATETIMESLOTID == Jb.DATETIMESLOTID).Select(zz => zz.DATEID).FirstOrDefault();
dynamicjob.Date = db.DATEs.Where(zz => zz.DATEID == DateID).Select(zz => zz.DATEDESCRIPTION).FirstOrDefault();
var SlotID = db.DATETIMESLOTs.Include(zz => zz.SLOT).Where(zz => zz.DATETIMESLOTID == Jb.DATETIMESLOTID).Select(zz => zz.SLOTID).FirstOrDefault();
dynamicjob.Startime = db.SLOTs.Where(zz => zz.SLOTID == SlotID).Select(zz => zz.STARTTIME).FirstOrDefault();
dynamicjob.Endtime = db.SLOTs.Where(zz => zz.SLOTID == SlotID).Select(zz => zz.ENDTIME).FirstOrDefault();
dynamicjobs.Add(dynamicjob);
}
}
return(dynamicjobs);
}
public dynamic GetAmount(string ReferenceNo)
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
return(GetAmount(db.RENTAL_AGREEMENT.Include(zz => zz.PROPERTY).Include(zz => zz.CLIENT).Where(zz => zz.REFERENCE_NO == ReferenceNo).FirstOrDefault()));
}
public dynamic GetDate(int RentalagreementID)
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
return(GetDates(db.RENTAL_AGREEMENT.Where(zz => zz.RENTALAGREEMENTID == RentalagreementID).FirstOrDefault()));
}
public dynamic getExpandoReport(List <PAYMENT> lists)
{
try
{
List <dynamic> dynamicjobs = new List <dynamic>();
dynamic total = new ExpandoObject();
INF370Entities db = new INF370Entities();
foreach (PAYMENT Jb in lists)
{
dynamic dynamicjob = new ExpandoObject();
dynamicjob.Reference = Jb.PAYMENT_REFERENCE_NO;
dynamicjob.Amount = Jb.PAYMENT_AMOUNT;
//dynamicjob.ApplicationNum = Jb.RENTALAPPLICATIONID;
dynamicjobs.Add(dynamicjob);
}
total.Sum = lists.Sum(vv => vv.PAYMENT_AMOUNT);
total.Payment = dynamicjobs;
return(total);
}
catch (Exception)
{
dynamic User = new ExpandoObject();
User.Message = "Something went wrong !";
return(User);
}
}
public IHttpActionResult PostOwner(EMPLOYEETYPE data)
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
db.EMPLOYEETYPEs.Add(data);
db.SaveChanges();
}
catch (Exception)
{
dynamic User = new ExpandoObject();
User.Message = "Something went wrong !";
return(User);
}
return(Ok(data));
}
public List <dynamic> GetExtensionRequest()
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
return(GetExtensionRequests(db.RENTAL_AGREEMENT.Where(zz => zz.RENTALSTATUSID == 3).ToList()));
}
public List <dynamic> GetAvailableClients(int ID)
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
return(GetAvailableSlots(db.CLIENTs.Where(zz => zz.CLIENTID == ID).ToList()));
}
public List <dynamic> GetUnassignedJobs()
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
return(GetUnassignedJob(db.JOBs.Include(ZZ => ZZ.RENTAL_AGREEMENT).Where(zz => zz.JOBTYPEID == 1 && zz.JOBSTATUSID == 1).ToList()));
}
// INF370Entities db = new INF370Entities();
public dynamic getExpandoReports(List <PURCHASE> lists)
{
try
{
List <dynamic> dynamicjobs = new List <dynamic>();
dynamic total = new ExpandoObject();
INF370Entities db = new INF370Entities();
foreach (PURCHASE Jb in lists)
{
var items = db.ITEMs.ToList();
var pur = db.PURCHASELINEs.Where(zz => zz.PURCHASEID == Jb.PURCHASEID).FirstOrDefault();
dynamic dynamicjob = new ExpandoObject();
dynamicjob.Name = items.Where(zz => zz.ITEMID == pur.ITEMID).Select(a => a.NAME);
dynamicjob.DESCRIPTION = items.Where(zz => zz.ITEMID == pur.ITEMID).Select(a => a.DESCRIPTION);
dynamicjob.PRICE = Jb.PRICE;
dynamicjob.DATE = Jb.DATE;
dynamicjob.QUANTITY = Jb.QUANTITY;
dynamicjobs.Add(dynamicjob);
}
total.Sums = lists.Sum(vv => vv.PRICE);
total.Payment = dynamicjobs;
return(total);
}
catch (Exception)
{
return(null);
}
}
private List <dynamic> GetExtensionRequests(List <RENTAL_AGREEMENT> forbros)
{
List <dynamic> dynamicagreements = new List <dynamic>();
INF370Entities db = new INF370Entities();
foreach (RENTAL_AGREEMENT ra in forbros)
{
var usr = db.USERs.ToList();
var clnt = db.CLIENTs.ToList();
var prop = db.PROPERTies.ToList();
dynamic dynamicagreement = new ExpandoObject();
dynamicagreement.RENTALAGREEMENTID = ra.RENTALAGREEMENTID;
dynamicagreement.RENTALSTATUSID = ra.RENTALSTATUSID;
// dynamicagreement.USERID = ra.USERID;
dynamicagreement.CLIENTID = ra.CLIENTID;
dynamicagreement.RENTALAPPLICATIONID = ra.RENTALAPPLICATIONID;
dynamicagreement.PROPERTYID = ra.PROPERTYID;
dynamicagreement.RENTALSTARTDATE = ra.RENTALSTARTDATE;
dynamicagreement.RENTALENDDATE = ra.RENTALENDDATE;
dynamicagreement.NAME = clnt.Where(XX => XX.CLIENTID == ra.CLIENTID).Select(m => m.NAME);
dynamicagreement.SURNAME = clnt.Where(XX => XX.CLIENTID == ra.CLIENTID).Select(m => m.SURNAME);
dynamicagreement.EMAIL = clnt.Where(XX => XX.CLIENTID == ra.CLIENTID).Select(m => m.EMAIL);
dynamicagreement.ADDRESS = prop.Where(XX => XX.PROPERTYID == ra.PROPERTYID).Select(m => m.ADDRESS);
//dynamicagreement.USERNAME = usr.Where(XX => XX.USERID == ra.USERID).Select(m => m.USERNAME);
dynamicagreements.Add(dynamicagreement);
}
return(dynamicagreements);
}
private List <dynamic> GetAssignedJobs(List <JOB> forbros)
{
List <dynamic> dynamicjobs = new List <dynamic>();
INF370Entities db = new INF370Entities();
foreach (JOB Jb in forbros)
{
var Rent = db.RENTAL_AGREEMENT.Where(zz => zz.RENTALAGREEMENTID == Jb.RENTALAGREEMENTID).FirstOrDefault();
//List<PROPERTY> Prop = new List<PROPERTY>();
var Prop = db.PROPERTies.ToList();
var usr = db.USERs.ToList();
var stat = db.JOBSTATUS.ToList();
var clientID = Rent.CLIENTID;
dynamic dynamicjob = new ExpandoObject();
dynamicjob.JOBID = Jb.JOBID;
dynamicjob.ADDRESS = Prop.Where(zz => zz.PROPERTYID == Rent.PROPERTYID).Select(x => x.ADDRESS).FirstOrDefault();
dynamicjob.RENTALAGREEMENTID = Jb.RENTALAGREEMENTID;
// dynamicjob.USERNAME = usr.Where(cc => cc.EMPLOYEEID == Jb.EMPLOYEEID).Select(a => a.USERNAME).FirstOrDefault();
dynamicjob.JOBTYPE = db.JOBTYPEs.Where(dd => dd.JOBTYPEID == Jb.JOBTYPEID).Select(dd => dd.JOBTYPEDESCRIPTION);
dynamicjob.EMPLOYEEID = Jb.EMPLOYEEID;
dynamicjob.JOBSTATUS = stat.Where(aa => aa.JOBSTATUSID == Jb.JOBSTATUSID).Select(c => c.DESCRIPTION).FirstOrDefault();
dynamicjob.DATEREQUESTED = Jb.DATEREQUESTED;
dynamicjob.DESCRIPTION = Jb.DESCRIPTION;
dynamicjob.DATECOMPLETED = Jb.DATECOMPLETED;
dynamicjob.CLIENTNAME = db.CLIENTs.Where(hh => hh.CLIENTID == clientID).Select(jj => jj.NAME);
dynamicjob.CLIENTSURNAME = db.CLIENTs.Where(hh => hh.CLIENTID == clientID).Select(jj => jj.SURNAME);
dynamicjob.CLIENTNUMBER = db.CLIENTs.Where(hh => hh.CLIENTID == clientID).Select(jj => jj.PHONENUMBER);
dynamicjobs.Add(dynamicjob);
}
return(dynamicjobs);
}
public List <dynamic> GetApplication()
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
return(GetApplications(db.DOCUMENTs.Include(zz => zz.RENTALAPPLICATION).Where(zz => zz.RENTALAPPLICATION.RENTALAPPLICATIONSTATUSID == 1).ToList()));
}
public List <dynamic> GetRentalAgreementdetails(int RentalApplicationID)
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
return(GetRentalAgreementdetails(db.RENTALAPPLICATIONs.Where(zz => zz.RENTALAPPLICATIONID == RentalApplicationID).Include(zz => zz.PROPERTY).ToList()));
}
public dynamic getExpandoReport(List <PAYMENT> lists)
{
try
{
List <dynamic> dynamicjobs = new List <dynamic>();
dynamic total = new ExpandoObject();
INF370Entities db = new INF370Entities();
foreach (PAYMENT Jb in lists)
{
dynamic dynamicjob = new ExpandoObject();
dynamicjob.Reference = Jb.PAYMENT_REFERENCE_NO;
dynamicjob.Amount = Jb.PAYMENT_AMOUNT;
dynamicjob.Date = Jb.PAYMENTDATETIME;
dynamicjob.PaymentType = Jb.PAYMENTTYPE.PAYMENTTYPE_NAME;
//dynamicjob.ApplicationNum = Jb.RENTALAPPLICATIONID;
dynamicjobs.Add(dynamicjob);
}
total.Payment = dynamicjobs;
return(total);
}
catch (Exception)
{
return(null);
}
}
public List <dynamic> BookedSlots()
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
return(BookedSlots(db.EMPLOYEEDATETIMESLOTs.Include(zz => zz.DATETIMESLOT).Include(zz => zz.EMPLOYEE).ToList()));
}
public bool DeleteOwner(int id)
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
try
{
CITY CityDetails = db.CITies.Find(id);
if (CityDetails == null)
{
return(false);
}
else
{
var propExist = db.AREAs.Where(kk => kk.CITYID == CityDetails.CITYID).ToList();
if (propExist.Count == 0)
{
db.CITies.Remove(CityDetails);
db.SaveChanges();
}
else
{
return(false);
}
}
return(false);
}
catch (Exception)
{
return(false);
}
}
public dynamic getExpandoReport(List <PAYMENT> lists)
{
try
{
List <dynamic> dynamicjobs = new List <dynamic>();
dynamic total = new ExpandoObject();
INF370Entities db = new INF370Entities();
foreach (PAYMENT Jb in lists)
{
dynamic dynamicjob = new ExpandoObject();
dynamicjob.Reference = Jb.RENTAL_AGREEMENT.RENTALAGREEMENTID;
dynamicjob.Amount = Jb.RENTAL_AGREEMENT.AMOUNTDUE;
dynamicjob.Date = Jb.PAYMENTDATETIME;
dynamicjob.Address = Jb.RENTAL_AGREEMENT.PROPERTY.ADDRESS;
dynamicjob.thismonthpayment = Jb.PAYMENT_AMOUNT;
dynamicjob.dateofpay = Jb.PAYMENTDATETIME;
dynamicjobs.Add(dynamicjob);
}
total.Payment = dynamicjobs;
return(total);
}
catch (Exception)
{
return(null);
}
}
public dynamic getExpandoReport(List <PAYMENT> lists)
{
dynamic oObject = new ExpandoObject();
INF370Entities db = new INF370Entities();
var clnlist = lists.GroupBy(gg => gg.RENTAL_AGREEMENT.PROPERTY.ADDRESS);
List <dynamic> clns = new List <dynamic>();
foreach (var clnGroup in clnlist)
{
dynamic cln = new ExpandoObject();
cln.Name = clnGroup.Key;
cln.Total = clnGroup.Sum(g => g.PAYMENT_AMOUNT);
clns.Add(cln);
}
oObject.Properties = clns;
//////
var clntlist = lists.GroupBy(gg => gg.RENTAL_AGREEMENT.CLIENT.NAME + " " + gg.RENTAL_AGREEMENT.CLIENT.SURNAME);
List <dynamic> cusO = new List <dynamic>();
foreach (var cus in clntlist)
{
dynamic client = new ExpandoObject();
client.Name = cus.Key;
//client.Surname ="";
List <dynamic> cusDetail = new List <dynamic>();
foreach (var customerDet in cus)
{
dynamic cusD = new ExpandoObject();
cusD.NAME = customerDet.RENTAL_AGREEMENT.CLIENT.NAME;
cusD.SURNAME = customerDet.RENTAL_AGREEMENT.CLIENT.SURNAME;
cusD.PAYMENTDATETIME = customerDet.PAYMENTDATETIME;
cusD.PAYMENTID = customerDet.PAYMENTID;
cusD.ADDRESS = customerDet.RENTAL_AGREEMENT.PROPERTY.ADDRESS;
cusD.PAYMENT_AMOUNT = customerDet.PAYMENT_AMOUNT;
cusD.ADDRESS = customerDet.RENTAL_AGREEMENT.PROPERTY.ADDRESS;
cusD.Total = cus.Sum(item => item.PAYMENT_AMOUNT);
cusDetail.Add(cusD);
}
client.Total = cus.Sum(item => item.PAYMENT_AMOUNT);
//cus.Sum(item => item.Order_Details.Sum(rr => rr.Quantity * rr.UnitPrice));
client.payments = cusDetail;
cusO.Add(client);
}
oObject.Clients = cusO;
return(oObject);
}
public List <dynamic> Getagreement(int ID)
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
return(verify(db.CLIENTs.Where(zz => zz.CLIENTID == ID && zz.verified == true).ToList()));
}
public List <dynamic> GetProperties(string ClientID)
{
var clientid = Convert.ToInt32(ClientID);
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
return(GetProperties(db.RENTAL_AGREEMENT.Include(zz => zz.PROPERTY).Include(zz => zz.CLIENT).Where(zz => zz.CLIENTID == clientid).ToList()));
}
public dynamic GetAmount(string ReferenceNo)
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
int refe = Convert.ToInt32(ReferenceNo);
return(GetAmount(db.RENTAL_AGREEMENT.Include(zz => zz.PROPERTY).Include(zz => zz.CLIENT).Where(zz => zz.RENTALAGREEMENTID == refe).FirstOrDefault()));
}
