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 ActionResult Manage(int? id) { PloatBooking model = new PloatBooking(); ViewBag.MemberLookUp = new MemberBAL().GetMemberLookUp(); if (id != 0 && id != null) { model = new PloatBookingBAL().GetById(id.Value); } return PartialView(model); }
public JsonResult Save(PloatBooking model) { try { bool Add_Flag = new PloatBookingBAL().isNewEntry(model.PloatBookingId); if (Add_Flag) new PloatBookingBAL().Create(model); else new PloatBookingBAL().Update(model); return Json(new { success = true, message = CommonMsg.Success(EntityNames.PloatBooking, (Add_Flag == true ? En_CRUD.Insert : En_CRUD.Update)) }); } catch (Exception ex) { return Json(new { success = false, message = CommonMsg.Fail(EntityNames.PloatBooking, En_CRUD.Update) }); } }
public void Update(PloatBooking oPloat) { try { using (var ctx = new BHGroupEntities()) { ctx.Entry(oPloat).State = EntityState.Modified; ctx.SaveChanges(); } } catch (Exception ex) { throw ex; } }