public ActionResult EditBook(FormCollection form, int id)
{
tblBooking book = dc.tblBookings.SingleOrDefault(ob => ob.ConsignmentId == id);
book.VehicleId = Convert.ToInt32(form["ddVehicle"]);
book.DriverId = Convert.ToInt32(form["ddDriver"]);
book.DispatchDate = Convert.ToDateTime(form["txtDispatch"]);
book.DeliveredDate = Convert.ToDateTime(form["txtDeliver"]);
book.TotalPayment = Convert.ToInt32(form["txtPayment"]);
book.PaymentMode = form["txtPaymentMode"];
book.Remarks = form["txtRemark"];
Session["Price"] = book.TotalPayment;
dc.SaveChanges();
tblBidding bidding = dc.tblBiddings.SingleOrDefault(ob => ob.BidId == book.BidId);
bidding.IsAssigned = true;
dc.SaveChanges();
tblConsignment con = dc.tblConsignments.SingleOrDefault(ob => ob.ConsignmentId == id);
con.IsProcessed = true;
dc.SaveChanges();
return(RedirectToAction("bill", "ClientCompany", new { id = book.BookingId }));
}
public ActionResult booking1(tblBooking b1) //values of booking are bought through b1 object
{
if (ModelState.IsValid)
{
tblLogin z = (tblLogin)Session["customerid"];
string n = z.UserId;
if (n == b1.Customer_ID)
{
string s = Dbclass.Hotelbooking(b1); //validations and billamount is returned through this s
if (s.StartsWith("N") || s.StartsWith("a") || s.StartsWith("H")) //if validations are not satisfied it goes to booking view and generate which validation is missing
{
ViewBag.msg = s;
return(View("booking"));
}
else
{
ViewBag.msg = s;
Session["bill"] = s;
Session["var"] = b1; //here we are storing object of tblbooking by using sessions so that we can use this value after payment
slist = Dbclass.getstate(); //this slist consists values of bankdetails we will use it to populate dropdown values in payment view
ViewBag.bankid = slist;
return(View("payment"));
}
}
else
{
ViewBag.msg = "Please Enter Your CustomerId";
return(View("booking"));
}
}
return(View("booking"));
}
public IHttpActionResult UpdateCancellation(string username, string bit)
{
/*if (!ModelState.IsValid)
* {
* return BadRequest(ModelState);
* }*/
try
{
tblBooking newbooking = new tblBooking();
newbooking = db.tblBookings.Find(username);
if (newbooking != null)
{
newbooking.CancellationBit = bit;
db.SaveChanges();
}
else
{
return(NotFound());
}
}
catch (Exception)
{
throw;
}
return(Ok());
}
public ActionResult bookingupdate(int id) //booking update can be done here
{
tblBooking t = Dbclass.getbookingdetails(id); //which booking id we want to change that we are retrieving from database and populating in view
Session["opp"] = t; //here by using session variable we are storing the object of that bookingid which we want to edit
return(View(t));
}
///[ResponseType(typeof(tblBooking))]
public IHttpActionResult UpdateCancellation(string paymentid)
{
/*if (!ModelState.IsValid)
* {
* return BadRequest(ModelState);
* }*/
try
{
tblBooking newbooking = new tblBooking();
//newbooking = db.tblBookings.Find(paymentid);
newbooking = db.tblBookings.Where(q => q.paymentId == paymentid).FirstOrDefault();
if (newbooking != null)
{
newbooking.CancellationBit = "1";
db.SaveChanges();
}
else
{
return(NotFound());
}
}
catch (Exception)
{
throw;
}
return(Ok());
}
public IHttpActionResult PuttblBooking(string id, tblBooking tblBooking)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tblBooking.BID)
{
return(BadRequest());
}
db.Entry(tblBooking).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tblBookingExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult ViewBill(int id)
{
tblConsignment con = dc.tblConsignments.SingleOrDefault(ob => ob.ConsignmentId == id);
ViewBag.UserName = (from ob in dc.tblUsers where ob.UserId == con.UserId select ob).Take(1).SingleOrDefault().FirstName;
string Name = ViewBag.UserName;
tblBooking book = dc.tblBookings.SingleOrDefault(ob => ob.ConsignmentId == con.ConsignmentId);
tblBidding bid = dc.tblBiddings.SingleOrDefault(ob => ob.BidId == book.BidId);
ViewBag.Company = (from ob in dc.tblTransportCompanies where ob.CompanyId == bid.CompanyId select ob).Take(1).SingleOrDefault().CompanyName;
ViewBag.Weburl = (from ob in dc.tblTransportCompanies where ob.CompanyId == bid.CompanyId select ob).Take(1).SingleOrDefault().WebURL;
ViewBag.Contact = (from ob in dc.tblTransportCompanies where ob.CompanyId == bid.CompanyId select ob).Take(1).SingleOrDefault().ContactPersonNo;
ViewBag.Desc = (from ob in dc.tblBills where ob.BookingId == book.BookingId select ob).Take(1).SingleOrDefault().Desc;
ViewBag.Price = (from ob in dc.tblBills where ob.BookingId == book.BookingId select ob).Take(1).SingleOrDefault().Price;
ViewBag.Tolltax = (from ob in dc.tblBills where ob.BookingId == book.BookingId select ob).Take(1).SingleOrDefault().TollTax;
ViewBag.GST = (from ob in dc.tblBills where ob.BookingId == book.BookingId select ob).Take(1).SingleOrDefault().GST;
ViewBag.TotalPrice = (from ob in dc.tblBills where ob.BookingId == book.BookingId select ob).Take(1).SingleOrDefault().TotalPrice;
string Company = ViewBag.Company;
string weburl = ViewBag.Weburl;
string cno = ViewBag.Contact;
return(View(con));
}
public ActionResult bill(FormCollection form, int id)
{
tblBooking book = dc.tblBookings.SingleOrDefault(ob => ob.BookingId == id);
tblConsignment con = dc.tblConsignments.SingleOrDefault(ob => ob.ConsignmentId == book.ConsignmentId);
tblUser user = dc.tblUsers.SingleOrDefault(ob => ob.UserId == con.UserId);
tblBidding bid = dc.tblBiddings.SingleOrDefault(ob => ob.BidId == book.BidId);
ViewBag.UserName = (from ob in dc.tblUsers where ob.UserId == con.UserId select ob).Take(1).SingleOrDefault().FirstName;
ViewBag.Company = (from ob in dc.tblTransportCompanies where ob.CompanyId == bid.CompanyId select ob).Take(1).SingleOrDefault().CompanyName;
ViewBag.Weburl = (from ob in dc.tblTransportCompanies where ob.CompanyId == bid.CompanyId select ob).Take(1).SingleOrDefault().WebURL;
ViewBag.Contact = (from ob in dc.tblTransportCompanies where ob.CompanyId == bid.CompanyId select ob).Take(1).SingleOrDefault().ContactPersonNo;
var com = Convert.ToInt32(Session["CompanyId"]);
tblTransportCompany company = dc.tblTransportCompanies.SingleOrDefault(ob => ob.CompanyId == com);
//ViewBag.Bill = (from ob in dc.tblBookings where ob.BookingId == id select ob).Take(1).SingleOrDefault().TotalPayment;
tblBill bill = new tblBill();
bill.BookingId = id;
bill.UserId = Convert.ToInt32(user.UserId);
bill.Desc = form["txtDesc"];
bill.Price = Convert.ToInt32(book.TotalPayment);
bill.TollTax = Convert.ToInt32(form["txtToll"]);
bill.GST = (Convert.ToInt32(book.TotalPayment) * 18) / 100;
bill.TotalPrice = Convert.ToInt32(book.TotalPayment) + Convert.ToInt32(form["txtToll"]) + (Convert.ToInt32(book.TotalPayment) * 18) / 100;
bill.CompanyId = Convert.ToInt32(Session["CompanyId"]);
bill.CreatedOn = DateTime.Now;
dc.tblBills.Add(bill);
dc.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
public object ApprovalOfBooking(int BookingID, bool Approval, int ApprovedBy, decimal RatePerHour, string Reason)
{
var DC = new DataClassesDataContext();
tblBooking BookingObj = (from ob in DC.tblBookings
where ob.BookingID == BookingID
select ob).Single();
BookingObj.IsApproved = Approval;
BookingObj.ApprovedBy = ApprovedBy;
BookingObj.Status = (BookingObj.IsApproved == true) ? "Accepted" : "Rejected";
BookingObj.Reason = (BookingObj.IsApproved == true) ? Reason : null;
if (Approval)
{
tblPayment PaymentObj = new tblPayment();
var Amount = (BookingObj.EndTime.Hour - BookingObj.StartTime.Hour) * RatePerHour;
PaymentObj.Amount = Amount;
PaymentObj.DueDate = BookingObj.StartTime.Date.AddDays(-1);
PaymentObj.InitiateDate = DateTime.Now;
PaymentObj.PaymentFor = Convert.ToInt32(BookingObj.FlatNo);
PaymentObj.PaymentName = "Facility Booking";
PaymentObj.Penalty = 0;
PaymentObj.IsActive = true;
DC.tblPayments.InsertOnSubmit(PaymentObj);
}
DC.SubmitChanges();
return(true);
}
public ActionResult Updatebook(tblBooking E)
{
tblBooking s = (tblBooking)Session["opp"]; // retrieving that object by session variable so we can retrieve booking id by this
string m = Dbclass.GetbookData(E, s); //here updation is done
ViewBag.msg = m;
return(View("bookingupdate"));
}
public ActionResult bill(int id)
{
tblBooking booking = dc.tblBookings.SingleOrDefault(ob => ob.BookingId == id);
ViewBag.Price = booking.TotalPayment;
tblBill bill = dc.tblBills.SingleOrDefault(ob => ob.BookingId == id);
return(View(bill));
}
public int AddBooking(BookingEntities be)
{
var config = new MapperConfiguration(cfg => cfg.CreateMap <BookingEntities, tblBooking>());
IMapper mapper = config.CreateMapper();
tblBooking ba = mapper.Map <BookingEntities, tblBooking>(be);
int BookingId = bookingRepository.AddBooking(ba);
return(BookingId);
}
public ActionResult EditBook(int id)
{
int CompanyID = Convert.ToInt32(Session["CompanyId"]);
tblBooking book = dc.tblBookings.SingleOrDefault(ob => ob.ConsignmentId == id);
var drivers = from obDriver in dc.tblDrivers where obDriver.CompanyId == CompanyID select obDriver;
var vehicles = from obVehicle in dc.tblVehicles where obVehicle.CompanyId == CompanyID select obVehicle;
ViewBag.driver = new SelectList(drivers, "DriverId", "DriverName");
ViewBag.vehicle = new SelectList(vehicles, "VehicleId", "VehicleName");
return(View(book));
}
public ActionResult AddBid(int id, int id1)
{
tblBooking book = new tblBooking();
book.ConsignmentId = id;
book.BidId = id1;
//book.IsPaid = false;
dc.tblBookings.Add(book);
dc.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
public IHttpActionResult PosttblBooking(tblBooking tblBooking)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//db.tblBookings.Add(tblBooking);
db.proc_Booking(tblBooking.UserID);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = tblBooking.BID }, tblBooking));
}
public ActionResult Detail(int id)
{
tblBooking book = dc.tblBookings.SingleOrDefault(ob => ob.BookingId == id);
ViewBag.Vehicle = (from ob in dc.tblVehicles where ob.VehicleId == book.VehicleId select ob).Take(1).SingleOrDefault().VehicleName;
ViewBag.Driver = (from ob in dc.tblDrivers where ob.DriverId == book.DriverId select ob).Take(1).SingleOrDefault().DriverName;
ViewBag.UserName = (from ob in dc.tblUsers join ob2 in dc.tblConsignments on ob.UserId equals ob2.UserId where ob2.ConsignmentId == book.ConsignmentId select ob).Take(1).SingleOrDefault().FirstName;
ViewBag.Pic = (from ob in dc.tblUsers join ob2 in dc.tblConsignments on ob.UserId equals ob2.UserId where ob2.ConsignmentId == book.ConsignmentId select ob).Take(1).SingleOrDefault().ProfilePic;
string vehicle = ViewBag.Vehicle;
string dr = ViewBag.Driver;
return(View(book));
}
public IHttpActionResult DeletetblBooking(string id)
{
tblBooking tblBooking = db.tblBookings.Find(id);
if (tblBooking == null)
{
return(NotFound());
}
db.tblBookings.Remove(tblBooking);
db.SaveChanges();
return(Ok(tblBooking));
}
public JsonResult Active(int id)
{
tblBooking book = dc.tblBookings.SingleOrDefault(ob => ob.BookingId == id);
if (book.IsPaid == true)
{
book.IsPaid = false;
}
else
{
book.IsPaid = true;
}
dc.SaveChanges();
return(Json(book.IsPaid, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteBooking(int id)
{
if (Session["StudioID"] == null && Session["StudioName"] == null && Session["StudioPhoneNo"] == null)
{
return(RedirectToAction("Login", "Login"));
}
try
{
tblBooking booking = db.tblBookings.Find(id);
db.tblBookings.Remove(booking);
db.SaveChanges();
return(Json(new { success = true, message = "Record deleted successfully" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, message = "Record not deleted" + ex.Message }, JsonRequestBehavior.AllowGet));
}
}
/* Vendors */
/* Events */
/* Events */
/* FacilityBookings */
public object ProposeFacilityBooking(int FacilityID, string FlatNo, string StartTime, string EndTime, string Purpose, string Description)
{
var DC = new DataClassesDataContext();
tblBooking BookingObj = new tblBooking();
BookingObj.FacilityID = FacilityID;
BookingObj.FlatNo = FlatNo;
BookingObj.StartTime = Convert.ToDateTime(StartTime);
BookingObj.EndTime = Convert.ToDateTime(EndTime);
BookingObj.Status = "Panel Review Pending";
BookingObj.Purpose = Purpose;
BookingObj.Description = Description;
BookingObj.IsApproved = false;
BookingObj.IsActive = true;
DC.tblBookings.InsertOnSubmit(BookingObj);
DC.SubmitChanges();
return("True");
}
public IHttpActionResult uncreatebookings(string Source_B, string Destination_B, string StartDate, string StartTime, float TravelFare, string EmailId, string BusNo, string SelectedSeats, string TicketType, string paymentBy)
{
dbNewBusEntities8 db = new dbNewBusEntities8();
tblBooking customer = new tblBooking();
customer.Source_B = Source_B;
customer.Destination_B = Destination_B;
customer.StartDate = StartDate;
customer.StartTime = StartTime;
customer.TravelFare = TravelFare;
customer.EmailId = EmailId;
customer.BusNo = BusNo;
customer.SelectedSeats = SelectedSeats;
customer.paymentBy = paymentBy;
// customer.WalletDetails = wallet;
customer.TicketType = TicketType;
customer.CancellationBit = "0";
db.tblBookings.Add(customer);
db.SaveChanges();
return(Ok());
}
public ActionResult ApproveBooking()
{
try
{
int CustomerID = Convert.ToInt32(Request.Form["CustomerID"]);
string BookingDescription = Request.Form["BookingDescription"];
DateTime FunctionDate = Convert.ToDateTime(Request.Form["FunctionDate"]);
tblBooking booking = new tblBooking();
booking.CustomerID = CustomerID;
booking.BookingDescription = BookingDescription;
booking.FunctionDate = FunctionDate;
booking.CreatedDate = DateTime.Now;
booking.IsExposed = false;
db.tblBookings.Add(booking);
db.SaveChanges();
return(Json(new { success = true, message = "Booking Approved Successfully" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, message = "Error!" + ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteExpose(int id)
{
if (Session["StudioID"] == null && Session["StudioName"] == null && Session["StudioPhoneNo"] == null)
{
return(RedirectToAction("Login", "Login"));
}
try
{
tblExposing exposing = db.tblExposings.Find(id);
tblBooking booking = db.tblBookings.SingleOrDefault(b => b.BookingID == exposing.BookingID);
booking.IsExposed = false;
booking.UpdatedDate = DateTime.Now;
db.Entry(booking).State = EntityState.Modified;
db.tblExposings.Remove(exposing);
db.SaveChanges();
return(Json(new { success = true, message = "Record deleted successfully" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, message = "Record not deleted" + ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult payment1(tblPayment p)
{
if (ModelState.IsValid) //if validations are satisfied then it goes into model
{
tblBooking z = (tblBooking)Session["var"]; //here we are retrieving tblbooking object values that are stored in session variable
bool s = Dbclass.getpayment(p);
if (s == true) //if payment is done successfully then it goes to insertion of booking
{
string x = Dbclass.getbooking(z); //for inserting into booking
ViewBag.g = x;
}
return(View());
}
else
{
ViewBag.msg = Session["bill"].ToString();
slist = Dbclass.getstate();
ViewBag.bankid = slist;
return(View("payment")); //it will show where the validation is missing
}
}
public ActionResult Exposing()
{
try
{
int BookingID = Convert.ToInt32(Request.Form["BookingID"]);
int PhotographerID = Convert.ToInt32(Request.Form["PhotographerID"]);
string BookingDescription = Request.Form["BookingDescription"];
string Address = Request.Form["Address"];
tblExposing exposing = new tblExposing();
tblBooking booking = db.tblBookings.SingleOrDefault(b => b.BookingID == BookingID);
exposing.BookingID = BookingID;
exposing.PhotographerID = PhotographerID;
if (BookingDescription.Trim().Equals("1"))
{
exposing.Description = booking.BookingDescription;
booking.IsExposed = true;
}
else
{
exposing.Description = BookingDescription;
}
exposing.Location = Address;
exposing.CreatedDate = DateTime.Now;
db.tblExposings.Add(exposing);
db.Entry(booking).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Event exposed successfully." }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, message = "Error!" + ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public object CreateFbk(Feedback feedbk)
{
try
{
tblBooking tblBooking = new tblBooking();
tblFeedback fb = new tblFeedback();
fb.Question1 = feedbk.Question1;
fb.Question2 = feedbk.Question2;
fb.Question3 = feedbk.Question3;
fb.Question4 = feedbk.Question4;
fb.Question5 = feedbk.Question5;
db.tblFeedbacks.Add(fb);
db.SaveChanges();
return(new Response
{
Status = "Success",
Message = "SuccessFully Saved."
});
}
catch (Exception)
{
throw;
}
}
public int AddBooking(tblBooking objBooking)
{
db.tblBookings.Add(objBooking);
db.SaveChanges();
return(objBooking.ID);
}
public string SaveTheftClaim(TheftClaimModel model)
{
string path = Path.Combine(HttpContext.Current.Server.MapPath("~/PdfTemplates"), "TheftClaimPDF.html");
model.FullName = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(model.FullName.ToLower());
int bookingid;
try
{
bookingid = Convert.ToInt32(model.BookingId);
}
catch (Exception ex)
{
bookingid = 0;
}
tblBooking tblBooking = ((IQueryable <tblBooking>) this._dbEntity.tblBookings).FirstOrDefault <tblBooking>((Expression <Func <tblBooking, bool> >)(x => x.BookingId == (long)bookingid));
if (tblBooking != null)
{
tblBooking.IsTheftClaimRaised = new bool?(true);
tblBooking.IsRenterRaisedDispute = new bool?(true);
this._dbEntity.SaveChanges();
}
string str1 = System.IO.File.ReadAllText(path).Replace("{fullname}", model.FullName).Replace("{email}", model.Email);
string oldValue1 = "{dob}";
DateTime dateTime = model.DOB.Date;
string newValue1 = dateTime.ToString("MM-dd-yyyy");
string str2 = str1.Replace(oldValue1, newValue1).Replace("{booking}", model.BookingId).Replace("{address}", model.Address).Replace("{postcode}", model.PostCode).Replace("{mobilenumber}", model.MobileNumber).Replace("{circumstances}", model.Circumstances).Replace("{stolenlist}", model.ListOfStolenItems).Replace("{approxvalue}", "£ " + model.ApproxValue).Replace("{responsible}", model.WhoWasResponsible).Replace("{unattended}", model.HowLongUnattended);
string oldValue2 = "{lastseen}";
dateTime = model.TimeAndDateLastSeen;
string newValue2 = dateTime.ToString();
string str3 = str2.Replace(oldValue2, newValue2);
string oldValue3 = "{discovered}";
dateTime = model.TimeAndDateTheftDiscovered;
string newValue3 = dateTime.ToString();
string str4 = str3.Replace(oldValue3, newValue3);
bool? nullable = model.IsAnyWitness;
bool flag1 = true;
string str5 = ((nullable.GetValueOrDefault() == flag1 ? (nullable.HasValue ? 1 : 0) : 0) == 0 ? str4.Replace("{anywitness}", "No").Replace("{witnessdetails}", string.Empty) : str4.Replace("{anywitness}", "Yes").Replace("{witnessdetails}", model.WitnessDetails)).Replace("{policecontact}", model.PoliceContactNumber).Replace("{crimeincident}", model.CrimeIncidentNumber);
string str6 = !model.IsPoliceAttend ? str5.Replace("{policeattend}", "No") : str5.Replace("{policeattend}", "Yes");
string str7 = (!model.IsReportedToPoliceImmediately ? str6.Replace("{policeimmediately}", "No").Replace("{reasonforpolice}", model.ReasonForNotReportedImmediately) : str6.Replace("{policeimmediately}", "Yes").Replace("{reasonforpolice}", string.Empty)).Replace("{howsecured}", model.HowBicycleWasSecured).Replace("{locksecured}", model.DetailOfSecuredLock).Replace("{howaccess}", model.HowAccessGained).Replace("{alternatesecurity}", model.AlternativeSecurityMethod);
nullable = model.IsAnotherInsurer;
bool flag2 = true;
string str8 = ((nullable.GetValueOrDefault() == flag2 ? (nullable.HasValue ? 1 : 0) : 0) == 0 ? str7.Replace("{isanotherinsurer}", "No") : str7.Replace("{isanotherinsurer}", "Yes")).Replace("{previousinsurer}", model.PreviousInsurerName).Replace("{expirydate}", model.ExpiryDate).Replace("{anybicycleclaim}", model.PastClaimDetails);
nullable = model.IsAnyCriminalConviction;
bool flag3 = true;
string str9 = (nullable.GetValueOrDefault() == flag3 ? (nullable.HasValue ? 1 : 0) : 0) == 0 ? str8.Replace("{iscriminal}", "No") : str8.Replace("{iscriminal}", "Yes");
nullable = model.IsPolicyCancelled;
bool flag4 = true;
string str10 = (nullable.GetValueOrDefault() == flag4 ? (nullable.HasValue ? 1 : 0) : 0) == 0 ? str9.Replace("{ispolicycancelled}", "No") : str9.Replace("{ispolicycancelled}", "Yes");
nullable = model.IsRefusedRenewal;
bool flag5 = true;
string str11 = ((nullable.GetValueOrDefault() == flag5 ? (nullable.HasValue ? 1 : 0) : 0) == 0 ? str10.Replace("{isrefusedrenewal}", "No") : str10.Replace("{isrefusedrenewal}", "Yes")).Replace("{provideddetails}", model.ProvidedDetails);
StreamWriter streamWriter = new StreamWriter(HostingEnvironment.MapPath("~/Templates/dfTemplate.htm"));
streamWriter.Write(str11);
streamWriter.Close();
streamWriter.Dispose();
PdfConverter pdfConverter = new PdfConverter();
pdfConverter.LicenseKey = "elFLWktaTE9IWk9USlpJS1RLSFRDQ0ND";
pdfConverter.PdfDocumentOptions.PdfPageSize = PdfPageSize.Letter;
pdfConverter.PdfDocumentOptions.PdfCompressionLevel = PdfCompressionLevel.NoCompression;
pdfConverter.PdfDocumentOptions.PdfPageOrientation = PDFPageOrientation.Landscape;
pdfConverter.PdfDocumentOptions.BottomMargin = 20;
pdfConverter.PdfDocumentOptions.TopMargin = 20;
pdfConverter.PdfDocumentOptions.LeftMargin = 20;
pdfConverter.PdfDocumentOptions.RightMargin = 20;
pdfConverter.PdfDocumentOptions.ShowHeader = false;
pdfConverter.PdfDocumentOptions.ShowFooter = false;
pdfConverter.PdfDocumentOptions.AutoSizePdfPage = false;
pdfConverter.PdfDocumentOptions.GenerateSelectablePdf = true;
pdfConverter.PdfDocumentOptions.SinglePage = true;
string str12 = RandomString(7) + ".pdf";
byte[] pdfBytesFromUrl = pdfConverter.GetPdfBytesFromUrl(HostingEnvironment.MapPath("~/Templates/dfTemplate.htm"));
System.IO.File.WriteAllBytes(HostingEnvironment.MapPath("~/PdfTemplates/TheftClaimForms/" + str12 ?? ""), pdfBytesFromUrl);
model.PDFName = str12;
Mapper.Initialize(new MapperConfigurationExpression()
{
AllowNullCollections = true, AllowNullDestinationValues = true, CreateMissingTypeMaps = true
});
tblTheftClaim tblTheftClaim = Mapper.Instance.Map <tblTheftClaim>(model);
tblTheftClaim.IsApproved = new bool?(false);
tblTheftClaim.CreatedDate = new DateTime?(DateTime.Now);
this._dbEntity.tblTheftClaims.Add(tblTheftClaim);
this._dbEntity.SaveChanges();
return("Success");
}
public bool DeliveredTracking(int Statusid, int BookingId, int OfficeId, int Userid)
{
var data = db.Trackings.Where(m => m.BookingId == BookingId).ToList();
var bookingdata = db.tblBookings.Where(m => m.ID == BookingId).ToList();
int?CreatedBy = 0;
foreach (var item in data)
{
CreatedBy = item.CreatedBy;
break;
}
Tracking te;
tblBooking be;
foreach (var item in data)
{
te = db.Trackings.Find(item.Id);
te.IsCurrent = false;
db.Entry(te).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
te = null;
}
foreach (var item in bookingdata)
{
be = db.tblBookings.Find(item.ID);
be.IsCurrent = false;
db.Entry(be).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
be = null;
}
bool cntr = true;
int newBookingId = 0;
foreach (var item in bookingdata)
{
if (cntr)
{
tblBooking newBooking = new tblBooking();
newBooking.Amount = item.Amount;
newBooking.CreatedBy = item.CreatedBy;
newBooking.CreatedDate = item.CreatedDate;
newBooking.DestinationId = item.DestinationId;
newBooking.IsActive = true;
newBooking.Userid = CreatedBy;
newBooking.IsCurrent = true;
newBooking.IsDelivered = true;
newBooking.IsPickUp = true;
newBooking.OfficeId = OfficeId;
newBooking.PackageDetailsId = item.PackageDetailsId;
newBooking.PaymentType = item.PaymentType;
newBooking.ShipmentId = item.ShipmentId;
newBooking.SourceId = item.SourceId;
newBooking.TransactionId = item.TransactionId;
newBooking.UpdatedBy = Userid;
newBooking.UpdatedDate = DateTime.Now;
db.tblBookings.Add(newBooking);
db.SaveChanges();
newBookingId = newBooking.ID;
cntr = false;
break;
}
}
var officelist = db.Offices.Where(m => m.Id == OfficeId).FirstOrDefault();
string City = officelist.BranchLocation;
Tracking te1 = new Tracking();
te1.IsActive = true;
te1.IsCurrent = true;
te1.IsDelivered = true;
te1.UpdatedBy = Userid;
te1.CreatedBy = CreatedBy;
te1.CargoStatusTypeId = Statusid;
te1.CurrentLocation = City;
te1.BookingId = newBookingId;
db.Trackings.Add(te1);
db.SaveChanges();
return(true);
}
public string CaptureSecuirtyById(long id)
{
try
{
string host = ConfigurationManager.AppSettings["Host"];
string from = ConfigurationManager.AppSettings["FromEmail"];
string insurerEmail = ConfigurationManager.AppSettings["InsurerEmail"];
string password = ConfigurationManager.AppSettings["Password"];
int port = Convert.ToInt32(ConfigurationManager.AppSettings["Port"]);
tblBooking bookingDetails = ((IQueryable <tblBooking>) this._dbEntity.tblBookings).FirstOrDefault <tblBooking>((Expression <Func <tblBooking, bool> >)(x => x.BookingId == id));
if (bookingDetails == null)
{
return(string.Empty);
}
string str1 = string.Empty;
if (bookingDetails.IsSecurityByPaypal == true)
{
if (!string.IsNullOrEmpty(bookingDetails.SecurityId))
{
try
{
bool captureId = PayPalImplement.CaptureAuthorization(bookingDetails.SecurityId);
str1 = "ok";
bookingDetails.IsSecurityCaptureOrRefund = new bool?(true);
this._dbEntity.SaveChanges();
}
catch (Exception ex)
{
str1 = string.Empty;
}
}
}
else
{
str1 = "ok";
}
bookingDetails.IsSecurityCaptureOrRefund = new bool?(true);
this._dbEntity.SaveChanges();
if (!string.IsNullOrEmpty(str1))
{
List <tblUserDeviceMapping> list = ((IQueryable <tblUserDeviceMapping>) this._dbEntity.tblUserDeviceMappings).Where <tblUserDeviceMapping>((Expression <Func <tblUserDeviceMapping, bool> >)(x => x.UserId == bookingDetails.UserId)).ToList <tblUserDeviceMapping>();
if (list != null && list.Count > 0)
{
List <PushNotificationModel> devicelist = new List <PushNotificationModel>();
foreach (tblUserDeviceMapping userDeviceMapping in list)
{
devicelist.Add(new PushNotificationModel()
{
DeviceToken = userDeviceMapping.DeviceToken,
Message = "Security amount has been captured by BiblioVélo for your booking with Booking Id: " + (object)bookingDetails.BookingId
});
}
PushNotifications.PushToIphone(devicelist);
}
tblUser userDetails = ((IQueryable <tblUser>) this._dbEntity.tblUsers).FirstOrDefault <tblUser>((Expression <Func <tblUser, bool> >)(x => (long?)x.Id == bookingDetails.UserId));
tblLogin tblLogin = ((IQueryable <tblLogin>) this._dbEntity.tblLogins).FirstOrDefault <tblLogin>((Expression <Func <tblLogin, bool> >)(x => (long?)x.Id == userDetails.LoginId));
MailMessage message = new MailMessage();
string str2 = System.IO.File.ReadAllText(Path.Combine(HttpContext.Current.Server.MapPath("~/EmailTemplate"), "MailTemplate.html")).Replace("{UserName}", userDetails.FirstName + ",");
string empty = string.Empty;
string newValue = "Security amount has been captured/hold by BiblioVélo for your booking with Booking Id:" + (object)bookingDetails.BookingId;
string str3 = str2.Replace("{Message}", newValue);
string email = tblLogin.Email;
string str4 = "Security Amount Captured By BiblioVélo";
message.From = new MailAddress(from, "BiblioVélo Support");
message.To.Add(email);
message.Subject = str4;
message.IsBodyHtml = true;
message.Body = str3;
SmtpClient smtpClient = new SmtpClient(host, port);
smtpClient.EnableSsl = true;
smtpClient.Credentials = new NetworkCredential(from, password);
try
{
smtpClient.Send(message);
}
catch (SmtpException ex1)
{
Common.ExcepLog(ex1);
}
}
return(str1);
}
catch (Exception ex)
{
Common.ExcepLog(ex);
return(string.Empty);
}
}
