//Get Single Record public static etblPropertyCancellationPolicyMap GetSingleRecordById(int id) { etblPropertyCancellationPolicyMap eobj = new etblPropertyCancellationPolicyMap(); using (OneFineRateEntities db = new OneFineRateEntities()) { var dbobj = db.tblPropertyCancellationPolicyMaps.SingleOrDefault(u => u.iCancellationPolicyId == id); if (dbobj != null) { eobj = (etblPropertyCancellationPolicyMap)OneFineRateAppUtil.clsUtils.ConvertToObject(dbobj, eobj); } } return(eobj); }
public ActionResult Edit(int Id) { ViewBag.HeaderText = "Modify Policy"; obj = BL_tblPropertyCancellationPolicyMap.GetSingleRecordById(Id); obj.Mode = "Edit"; if (obj.dtValidFrom != null) { obj.validfrom = String.Format("{0:dd/MM/yyyy}", obj.dtValidFrom); } if (obj.dtValidTo != null) { obj.validTo = String.Format("{0:dd/MM/yyyy}", obj.dtValidTo); } return(PartialView("CancellationPolicy", obj)); }
//Add new record public static int AddRecord(etblPropertyCancellationPolicyMap eobj) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { OneFineRate.tblPropertyCancellationPolicyMap dbuser = (OneFineRate.tblPropertyCancellationPolicyMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyCancellationPolicyMap()); db.tblPropertyCancellationPolicyMaps.Add(dbuser); db.SaveChanges(); retval = 1; } catch (Exception) { throw; } } return(retval); }
//Update a record public static int UpdateRecord(etblPropertyCancellationPolicyMap eobj) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { OneFineRate.tblPropertyCancellationPolicyMap obj = (OneFineRate.tblPropertyCancellationPolicyMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyCancellationPolicyMap()); db.tblPropertyCancellationPolicyMaps.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); retval = 1; } catch (Exception) { throw; } } return(retval); }
public string UpdateStatus(int Id, bool Mode) { object result = null; string strReturn = string.Empty; try { obj = BL_tblPropertyCancellationPolicyMap.GetSingleRecordById(Id); if (Mode == true) { obj.cStatus = "A"; } else { obj.cStatus = "I"; string s = BL_tblPropertyCancellationPolicyMap.CheckPolicyMapping(Id); if (s != "") { result = new { st = 0, msg = s }; strReturn = OneFineRateAppUtil.clsUtils.ConvertToJson(result); return(strReturn); } } int i = BL_tblPropertyCancellationPolicyMap.UpdateRecord(obj); if (i == 1) { result = new { st = 1, msg = "Updated successfully." }; } else { result = new { st = 0, msg = "Kindly try after some time." }; } } catch (Exception) { result = new { st = 0, msg = "Kindly try after some time." }; } strReturn = OneFineRateAppUtil.clsUtils.ConvertToJson(result); return(strReturn); }
public ActionResult AddUpdate(etblPropertyCancellationPolicyMap eObj) { object result = null; try { if (ModelState.IsValid) { eObj.dtValidFrom = Convert.ToDateTime(eObj.validfrom); eObj.dtValidTo = Convert.ToDateTime(eObj.validTo); if (eObj.bIsNonRefundable == false) { if (eObj.dValue.Value < 0) { result = new { st = 0, msg = "Charge cannot be negative." }; return(Json(result, JsonRequestBehavior.AllowGet)); } if (eObj.dValue.Value > 100) { result = new { st = 0, msg = "Charge cannot be more than 100." }; return(Json(result, JsonRequestBehavior.AllowGet)); } if (eObj.dHrsDays.Value < 0) { result = new { st = 0, msg = "Cancellation duration cannot be negative." }; return(Json(result, JsonRequestBehavior.AllowGet)); } if (eObj.dValue.Value > 100) { result = new { st = 0, msg = "Cancellation duration cannot be more than 100." }; return(Json(result, JsonRequestBehavior.AllowGet)); } string charrgetype = eObj.bIsPercent == true ? "%" : "Nights"; string arrival = eObj.cHrsDays == "Hrs" ? "Hours" : "Days"; eObj.sPolicyName = eObj.dValue.Value.ToString().Replace(".00", "") + "" + charrgetype + " - " + eObj.dHrsDays + "" + arrival; } else { eObj.sPolicyName = "Non-Refundable"; } if (eObj.Mode == "Add") { eObj.iPropId = Convert.ToInt32(Session["PropId"]); eObj.dtActionDate = DateTime.Now; eObj.cStatus = "A"; eObj.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId; if (BL_tblPropertyCancellationPolicyMap.CheckIfPolicyNameExists(eObj.sPolicyName, eObj.iPropId)) { result = new { st = 0, msg = "Policy Name already exists." }; } else { int j = BL_tblPropertyCancellationPolicyMap.AddRecord(eObj); if (j == 1) { result = new { st = 1, msg = "Added successfully." }; } else { result = new { st = 0, msg = "Kindly try after some time." }; } } } else if (eObj.Mode == "Edit") { if (BL_tblPropertyCancellationPolicyMap.CheckIfPolicyNameExistsOnUpdate(eObj.sPolicyName.Replace(".00", ""), eObj.iCancellationPolicyId, eObj.iPropId)) { result = new { st = 0, msg = "This Policy Name already exists." }; } else { int j = BL_tblPropertyCancellationPolicyMap.UpdateRecord(eObj); if (j == 1) { result = new { st = 1, msg = "Updated successfully." }; } else { result = new { st = 0, msg = "Kindly try after some time." }; } } } } else { result = new { st = 0, msg = "Kindly try after some time." }; } } catch (Exception) { result = new { st = 0, msg = "Kindly try after some time." }; } return(Json(result, JsonRequestBehavior.AllowGet)); }