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 HttpResponseMessage Addapplication(Addbooking sd) { INF370Entities db = new INF370Entities(); db.Configuration.ProxyCreationEnabled = false; // var httpRequest = HttpContext.Current.Request; RENTALAPPLICATION application = new RENTALAPPLICATION(); //Save to DB try { application.CLIENTID = sd.ClientID; //application.USERID = 2; // booking.CLIENTID = Convert.ToInt32(httpRequest["CLIENTID"]); } catch (Exception e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error With Application ")); } try { db.RENTALAPPLICATIONs.Add(application); db.SaveChanges(); db.SaveChanges(); } catch (Exception e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error With Application ")); } //booking.BOOKINGID = getCreatedBookingID(booking.CLIENTID); return(Request.CreateResponse(HttpStatusCode.Created)); }
public dynamic Addapplication(Addbooking sd) { INF370Entities db = new INF370Entities(); db.Configuration.ProxyCreationEnabled = false; // var httpRequest = HttpContext.Current.Request; RENTALAPPLICATION application = new RENTALAPPLICATION(); //Save to DB try { application.CLIENTID = sd.ClientID; //application.USERID = 2; // booking.CLIENTID = Convert.ToInt32(httpRequest["CLIENTID"]); } catch (Exception e) { return(false); } try { db.RENTALAPPLICATIONs.Add(application); db.SaveChanges(); db.SaveChanges(); } catch (Exception e) { 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); }