public ActionResult DeleteConfirmed(int id)
{
PropertyBooking propertyBooking = db.PropertyBookings.Find(id);
db.PropertyBookings.Remove(propertyBooking);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: PropertyBookings/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PropertyBooking propertyBooking = db.PropertyBookings.Find(id);
if (propertyBooking == null)
{
return(HttpNotFound());
}
return(View(propertyBooking));
}
// GET: PropertyBookings/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PropertyBooking propertyBooking = db.PropertyBookings.Find(id);
if (propertyBooking == null)
{
return(HttpNotFound());
}
ViewBag.PropertyID = new SelectList(db.Properties, "PropertyID", "PropertyName", propertyBooking.PropertyID);
return(View(propertyBooking));
}
public ActionResult Create([Bind(Include = "PropertyBookingID,PropertyID,Inward_No,TDate,NameOfApplicant,PhoneNo,HDate,AdvReceiptNo,AdvAmount,SecurityDepositAmt,ApplForSDRefund,FullPayReceiptNo,FullPayAmount,LuxTaxReceiptNo,RefundSDVoucherNo,PaymentOfLuxTax,Remarks")] PropertyBooking propertyBooking)
{
if (ModelState.IsValid)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var AdvRcpt = new Form4 {
CitizenID = null, Amount = propertyBooking.AdvAmount, PayDate = DateTime.Now, LedgerID = 7, SubLedgerID = 3, RecvdFrom = propertyBooking.NameOfApplicant, HouseNo = null
};
db.Form4.Add(AdvRcpt);
db.SaveChanges();
propertyBooking.AdvReceiptNo = AdvRcpt.RecieptNo;
propertyBooking.ApplForSDRefund = null;
propertyBooking.FullPayReceiptNo = null;
propertyBooking.FullPayAmount = null;
propertyBooking.LuxTaxReceiptNo = null;
propertyBooking.RefundSDVoucherNo = null;
propertyBooking.PaymentOfLuxTax = null;
propertyBooking.TDate = DateTime.Now;
db.PropertyBookings.Add(propertyBooking);
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
return(RedirectToAction("Index"));
}
}
ViewBag.PropertyID = new SelectList(db.Properties, "PropertyID", "PropertyName", propertyBooking.PropertyID);
return(View(propertyBooking));
}
public ActionResult Edit([Bind(Include = "PropertyBookingID,PropertyID,Inward_No,TDate,NameOfApplicant,PhoneNo,HDate,AdvReceiptNo,AdvAmount,SecurityDepositAmt,ApplForSDRefund,FullPayReceiptNo,FullPayAmount,LuxTaxReceiptNo,RefundSDVoucherNo,PaymentOfLuxTax,Remarks")] PropertyBooking propertyBooking)
{
if (ModelState.IsValid)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Entry(propertyBooking).State = EntityState.Modified;
if (propertyBooking.FullPayAmount != null)
{
if (!propertyBooking.FullPayReceiptNo.HasValue)//Create a receipt only if it is the initial edit
{
var fullPayRcpt = new Form4 {
CitizenID = null, Amount = propertyBooking.FullPayAmount, PayDate = DateTime.Now, LedgerID = 7, SubLedgerID = 3, RecvdFrom = propertyBooking.NameOfApplicant, HouseNo = null
};
db.Form4.Add(fullPayRcpt);
db.SaveChanges();
propertyBooking.FullPayReceiptNo = fullPayRcpt.RecieptNo;
}
}
if (propertyBooking.PaymentOfLuxTax != null)
{
if (!propertyBooking.LuxTaxReceiptNo.HasValue)
{
var LuxTax = new Form4 {
CitizenID = null, Amount = propertyBooking.PaymentOfLuxTax, PayDate = DateTime.Now, LedgerID = 7, SubLedgerID = 3, RecvdFrom = propertyBooking.NameOfApplicant, HouseNo = null
};
db.Form4.Add(LuxTax);
db.SaveChanges();
propertyBooking.LuxTaxReceiptNo = LuxTax.RecieptNo;
}
}
if (propertyBooking.ApplForSDRefund != null)
{
if (!propertyBooking.RefundSDVoucherNo.HasValue)
{
string UserID = User.Identity.GetUserName();
var pn = db.Configs.Select(x => x.VP).FirstOrDefault();
var RefundSD = new Voucher {
PassedBy = UserID, of = pn, Amount = propertyBooking.SecurityDepositAmt, ActualAmount = propertyBooking.SecurityDepositAmt, For = "Security Deposit refund of property booking", PayDate = propertyBooking.TDate, CBfolio = null, ResNo = null, HeldOn = propertyBooking.HDate, Meeting = "N/A", LedgerID = 7, SubLedgerID = 3
};
db.Vouchers.Add(RefundSD);
db.SaveChanges();
propertyBooking.RefundSDVoucherNo = RefundSD.VoucherID;
}
}
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
return(RedirectToAction("Index"));
}
ViewBag.PropertyID = new SelectList(db.Properties, "PropertyID", "PropertyName", propertyBooking.PropertyID);
return(View(propertyBooking));
}
