public dynamic UpdateBooking(UpdateBooking sd)
{
EMPLOYEEDATETIMESLOT bookingUpdate = new EMPLOYEEDATETIMESLOT();
EMPLOYEEDATETIMESLOT bookingUpdate2 = new EMPLOYEEDATETIMESLOT();
try
{
var bookingID = db.EMPLOYEEDATETIMESLOTs.Where(vvs => vvs.EMPLOYEEDATETIMESLOTID == sd.EmployeeDateTimeSlotID).Select(hh => hh.BOOKINGID).FirstOrDefault();
bookingUpdate = db.EMPLOYEEDATETIMESLOTs.Find(sd.EmployeeDateTimeSlotID);
bookingUpdate.BOOKINGID = null;
bookingUpdate.EMPLOYEESLOTSTAUSID = 1;
bookingUpdate2 = db.EMPLOYEEDATETIMESLOTs.Find(sd.newEmployeeDateTimeSlotID);
bookingUpdate2.BOOKINGID = bookingID;
bookingUpdate2.EMPLOYEESLOTSTAUSID = 2;
db.SaveChanges();
}
catch (Exception e)
{
return(false);
}
//booking.BOOKINGID = getCreatedBookingID(booking.CLIENTID);
return(true);
}
public HttpResponseMessage UpdateBooking(UpdateBooking sd)
{
EMPLOYEEDATETIMESLOT bookingUpdate = new EMPLOYEEDATETIMESLOT();
EMPLOYEEDATETIMESLOT bookingUpdate2 = new EMPLOYEEDATETIMESLOT();
try
{
var bookingID = db.EMPLOYEEDATETIMESLOTs.Where(vvs => vvs.EMPLOYEEDATETIMESLOTID == sd.EmployeeDateTimeSlotID).Select(hh => hh.BOOKINGID).FirstOrDefault();
bookingUpdate = db.EMPLOYEEDATETIMESLOTs.Find(sd.EmployeeDateTimeSlotID);
bookingUpdate.BOOKINGID = null;
bookingUpdate.EMPLOYEESLOTSTAUSID = 1;
bookingUpdate2 = db.EMPLOYEEDATETIMESLOTs.Find(sd.newEmployeeDateTimeSlotID);
bookingUpdate2.BOOKINGID = bookingID;
bookingUpdate2.EMPLOYEESLOTSTAUSID = 2;
db.SaveChanges();
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest,"Error With Booking "));
}
//booking.BOOKINGID = getCreatedBookingID(booking.CLIENTID);
return(Request.CreateResponse(HttpStatusCode.Created));
}
public IHttpActionResult PostDateSlot(EmpSlot data)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
var date = db.DATETIMESLOTs.Where(kk => kk.DATEID == data.DateID && kk.SLOTID == data.SlotID).ToList();
if (date.Count == 0)
{
DATETIMESLOT DATETIMESLOT = new DATETIMESLOT();
DATETIMESLOT.DATEID = data.DateID;
DATETIMESLOT.SLOTID = data.SlotID;
DATETIMESLOT.AREAID = data.AreaID;
db.DATETIMESLOTs.Add(DATETIMESLOT);
db.SaveChanges();
}
else
{
return(Ok(false));
}
int value = int.Parse(db.DATETIMESLOTs
.OrderByDescending(p => p.DATETIMESLOTID)
.Select(r => r.DATETIMESLOTID)
.First().ToString());
EMPLOYEEDATETIMESLOT EMPLOYEEDATETIMESLOT = new EMPLOYEEDATETIMESLOT();
EMPLOYEEDATETIMESLOT.EMPLOYEEID = data.EmployeeID;
EMPLOYEEDATETIMESLOT.EMPLOYEESLOTSTAUSID = 1;
EMPLOYEEDATETIMESLOT.DATETIMESLOTID = value;
db.EMPLOYEEDATETIMESLOTs.Add(EMPLOYEEDATETIMESLOT);
db.SaveChanges();
}
catch (Exception)
{
dynamic User = new ExpandoObject();
User.Message = "Something went wrong !";
return(null);
}
return(Ok(data));
}
public HttpResponseMessage Addbooking(Addbooking sd)
{
// var httpRequest = HttpContext.Current.Request;
BOOKING booking = new BOOKING();
EMPLOYEEDATETIMESLOT bookingUpdate = new EMPLOYEEDATETIMESLOT();
//Save to DB
try
{
booking.CLIENTID = sd.ClientID;
booking.PROPERTYID = sd.PropertyID;
booking.USERID = 2;
// booking.CLIENTID = Convert.ToInt32(httpRequest["CLIENTID"]);
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error With Booking "));
}
try
{
db.BOOKINGs.Add(booking);
db.SaveChanges();
bookingUpdate = db.EMPLOYEEDATETIMESLOTs.Find(sd.EmployeeDateTimeSlotID);
int value = int.Parse(db.BOOKINGs
.OrderByDescending(p => p.BOOKINGID)
.Select(r => r.BOOKINGID)
.First().ToString());
bookingUpdate.BOOKINGID = value;
bookingUpdate.EMPLOYEESLOTSTAUSID = 2;
db.SaveChanges();
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error With Booking "));;
}
//booking.BOOKINGID = getCreatedBookingID(booking.CLIENTID);
return(Request.CreateResponse(HttpStatusCode.Created));
}
public IHttpActionResult PostDateSlot(EMPLOYEEDATETIMESLOT data)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
data.EMPLOYEESLOTSTAUSID = 1;
db.EMPLOYEEDATETIMESLOTs.Add(data);
db.SaveChanges();
}
catch (Exception)
{
dynamic User = new ExpandoObject();
User.Message = "Something went wrong !";
return(null);
}
return(Ok(data));
}
public HttpResponseMessage Updatebooking(UpdateBooking sd)
{
EMPLOYEEDATETIMESLOT bookingUpdate = new EMPLOYEEDATETIMESLOT();
try
{
bookingUpdate = db.EMPLOYEEDATETIMESLOTs.Find(sd.BookingID);
bookingUpdate.BOOKINGID = null;
bookingUpdate.EMPLOYEESLOTSTAUSID = 1;
db.SaveChanges();
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error With Booking "));
}
//booking.BOOKINGID = getCreatedBookingID(booking.CLIENTID);
return(Request.CreateResponse(HttpStatusCode.Created));
}
public dynamic DeleteBooking(UpdateBooking sd)
{
EMPLOYEEDATETIMESLOT bookingUpdate = new EMPLOYEEDATETIMESLOT();
try
{
bookingUpdate = db.EMPLOYEEDATETIMESLOTs.Find(sd.BookingID);
bookingUpdate.BOOKINGID = null;
bookingUpdate.EMPLOYEESLOTSTAUSID = 1;
db.SaveChanges();
}
catch (Exception)
{
return(false);
}
//booking.BOOKINGID = getCreatedBookingID(booking.CLIENTID);
return(true);
}
public dynamic Addbooking(Addbooking sd)
{
// var httpRequest = HttpContext.Current.Request;
BOOKING booking = new BOOKING();
EMPLOYEEDATETIMESLOT bookingUpdate = new EMPLOYEEDATETIMESLOT();
//Save to DB
try
{ var existing = db.BOOKINGs.Where(jj => jj.CLIENTID == sd.ClientID && jj.PROPERTYID == sd.PropertyID).ToList();
if (existing.Count == 0)
{
booking.CLIENTID = sd.ClientID;
booking.PROPERTYID = sd.PropertyID;
var USERID = db.CLIENTs.Where(kk => kk.CLIENTID == sd.ClientID).Select(jj => jj.USERID).FirstOrDefault();
booking.USERID = USERID;
// booking.CLIENTID = Convert.ToInt32(httpRequest["CLIENTID"]);
}
else
{
dynamic setInvalid = new ExpandoObject();
setInvalid = false;
return(setInvalid);
} }
catch (Exception e)
{
return(false);
}
try
{
db.BOOKINGs.Add(booking);
db.SaveChanges();
bookingUpdate = db.EMPLOYEEDATETIMESLOTs.Find(sd.EmployeeDateTimeSlotID);
int value = int.Parse(db.BOOKINGs
.OrderByDescending(p => p.BOOKINGID)
.Select(r => r.BOOKINGID)
.First().ToString());
bookingUpdate.BOOKINGID = value;
bookingUpdate.EMPLOYEESLOTSTAUSID = 2;
db.SaveChanges();
var emp = db.EMPLOYEEs.Where(hh => hh.EMPLOYEEID == bookingUpdate.EMPLOYEEID).FirstOrDefault();
var theClient = db.CLIENTs.Where(hh => hh.CLIENTID == sd.ClientID).FirstOrDefault();
var prop = db.PROPERTies.Where(hh => hh.PROPERTYID == sd.PropertyID).FirstOrDefault();
var empslot = bookingUpdate.DATETIMESLOTID;
var dateid = db.DATETIMESLOTs.Find(empslot);
var date = db.DATEs.Where(kk => kk.DATEID == dateid.DATEID).Select(jj => jj.DATEDESCRIPTION).FirstOrDefault();
var slotS = db.SLOTs.Where(kk => kk.SLOTID == dateid.SLOTID).FirstOrDefault();
//send email with verification
MailMessage mail = new MailMessage();
SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com");
mail.From = new MailAddress("*****@*****.**");
mail.To.Add(emp.EMAIL);
mail.Subject = "Property Viewing Booking From: " + theClient.NAME + " " + theClient.SURNAME + " " + theClient.PHONENUMBER;
mail.Body = "Good day " + emp.NAME + " " + emp.SURNAME + "\n" + theClient.NAME + " " + theClient.SURNAME + " would love to view the property at " + prop.ADDRESS + " with the property reference number " + prop.PROPERTYID + ". \nClient Details \nClient Name : " + theClient.NAME + " " + theClient.SURNAME + "\nClient Email:" + theClient.EMAIL + "\nClient Number:" + theClient.PHONENUMBER + "\nViewing Details \nDate and Time of viewing : " + date + " " + DateTime.Now.Year.ToString() + " \nFrom: " + slotS.STARTTIME + "-" + slotS.ENDTIME + " \n\nThank you ";
SmtpServer.Port = 587;
SmtpServer.DeliveryMethod = SmtpDeliveryMethod.Network;
SmtpServer.UseDefaultCredentials = false;
SmtpServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "test123@123test");
SmtpServer.EnableSsl = true;
SmtpServer.Send(mail);
}
catch (Exception)
{
return(false);
}
//booking.BOOKINGID = getCreatedBookingID(booking.CLIENTID);
return(true);
}
public dynamic ArchivePropertyDetails(int id)
{
List <dynamic> toReturn = new List <dynamic>();
try
{
PROPERTY property = db.PROPERTies.Include(hh => hh.PROPERTYSTATU).Include(kk => kk.RENTALAPPLICATIONs).Include(mm => mm.BOOKINGs).Where(kk => kk.PROPERTYID == id && (kk.PROPERTYSTATUSID == 1 || kk.PROPERTYSTATUSID == 2)).FirstOrDefault();
if (property == null)
{
return(NotFound());
}
else
{
var propertyCheck = property.BOOKINGs.Where(jj => jj.PROPERTYID == property.PROPERTYID).ToList();
var mybookings =
(from y in propertyCheck.AsEnumerable()
join x in db.EMPLOYEEDATETIMESLOTs.AsEnumerable()
on y.BOOKINGID equals x.BOOKINGID
select new EMPLOYEEDATETIMESLOT
{
EMPLOYEEDATETIMESLOTID = x.EMPLOYEEDATETIMESLOTID,
DATETIMESLOTID = x.DATETIMESLOTID,
BOOKINGID = x.BOOKINGID
}).ToList();
List <EMPLOYEEDATETIMESLOT> list = new List <EMPLOYEEDATETIMESLOT>();
foreach (EMPLOYEEDATETIMESLOT Jb in mybookings)
{
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)
{
EMPLOYEEDATETIMESLOT newEmp = new EMPLOYEEDATETIMESLOT();
newEmp.BOOKINGID = Jb.BOOKINGID;
newEmp.EMPLOYEEDATETIMESLOTID = Jb.EMPLOYEEDATETIMESLOTID;
newEmp.DATETIMESLOTID = Jb.DATETIMESLOTID;
list.Add(newEmp);
}
}
if (list.Count != 0)
{
dynamic setInvalid = new ExpandoObject();
setInvalid.isValid = "false";
toReturn.Add(setInvalid);
}
else
{
var propertyCheckRentalApplication = property.RENTALAPPLICATIONs.Where(jj => jj.PROPERTYID == property.PROPERTYID && (jj.RENTALAPPLICATIONSTATUSID == 1 || jj.RENTALAPPLICATIONSTATUSID == 2)).ToList();
if (propertyCheckRentalApplication.Count != 0)
{
dynamic setInvalid = new ExpandoObject();
setInvalid.isValid = "false";
toReturn.Add(setInvalid);
}
else
{
var propertyCheckRentalAgreement = property.RENTAL_AGREEMENT.Where(jj => jj.PROPERTYID == property.PROPERTYID && (jj.RENTALSTATUSID == 1 || jj.RENTALSTATUSID == 3 || jj.RENTALSTATUSID == 4 || jj.RENTALSTATUSID == 5)).ToList();
if (propertyCheckRentalAgreement.Count != 0)
{
dynamic setInvalid = new ExpandoObject();
setInvalid.isValid = "false";
toReturn.Add(setInvalid);
}
else
{
property.PROPERTYSTATUSID = 3;
db.SaveChanges();
dynamic setInvalid = new ExpandoObject();
setInvalid.isValid = "true";
toReturn.Add(setInvalid);
// return true;
}
}
}
if (propertyCheck == null)
{
}
//RENTALAMOUNT amnt = db.RENTALAMOUNTs.Where(hh => hh.PROPERTYID == property.PROPERTYID).FirstOrDefault();
//if (amnt != null)
//{
// db.RENTALAMOUNTs.Remove(amnt);
// db.SaveChanges();
//}
//List<PROPERTYPHOTO> photos = db.PROPERTYPHOTOes.Where(jj => jj.PROPERTYID == property.PROPERTYID).ToList();
//if (photos.Count != 0)
//{
// foreach (PROPERTYPHOTO photo in photos)
// {
// db.PROPERTYPHOTOes.Remove(photo);
// db.SaveChanges();
// }
//}
//else
//{
//}
//db.PROPERTies.Remove(property);
//db.SaveChanges();
}
return(toReturn);
}
catch (Exception)
{
return(null);
}
}
