public ActionResult UpdateWeekEndWeekDayBidding(etblPropertyWeekendBiddingMapForOverview eObj) { object result = null; try { if (ModelState.IsValid) { if (eObj.Self.dtEffectiveDate.Date < DateTime.Now.AddDays(-7).Date) { result = new { st = 0, msg = "Please provide weekend/weekday discounts for this date in Bidding => Bulk Update screen first as this screen can only update discounts." }; } else if (eObj.Self.dtEffectiveDate.Date >= DateTime.Now.AddDays(-7).Date&& eObj.Self.dtEffectiveDate.Date < DateTime.Now.Date) { result = new { st = 0, msg = "Data for past dates cannot be provided." }; } else if (eObj.Self.bWeekend == null) { result = new { st = 0, msg = "Please provide weekend/weekday discounts for this date in Bidding => Bulk Update screen first as this screen can only update discounts." }; } else { eObj.Self.iPropId = Convert.ToInt32(Session["PropId"]); eObj.Self.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId; eObj.Self.dtActionDate = DateTime.Now; int j = BL_tblPropertyWeekendBiddingMap.UpdateRecord(eObj); if (j == 1) { result = new { st = 1, msg = "Updated successfully." }; } else { result = new { st = 0, msg = "Kindly try after some time." }; } } } else { string errormsg = ""; foreach (ModelState modelState in ViewData.ModelState.Values) { foreach (ModelError error in modelState.Errors) { errormsg += error.ErrorMessage; errormsg += "</br>"; } } result = new { st = 0, msg = errormsg }; } } catch (Exception) { result = new { st = 0, msg = "Kindly try after some time." }; } return(Json(result, JsonRequestBehavior.AllowGet)); }
//Update a record public static int UpdateRecord(etblPropertyWeekendBiddingMapForOverview eobj) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { //OneFineRate.tblPropertyBasicBiddingMap objbasic = (OneFineRate.tblPropertyBasicBiddingMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyBasicBiddingMap()); DataTable BidRange = new DataTable(); DataColumn col = null; col = new DataColumn("dtEffectiveDate", typeof(DateTime)); BidRange.Columns.Add(col); col = new DataColumn("iDays", typeof(Int16)); BidRange.Columns.Add(col); col = new DataColumn("dDiscount", typeof(Decimal)); BidRange.Columns.Add(col); col = new DataColumn("iAmenityId1", typeof(Int32)); BidRange.Columns.Add(col); col = new DataColumn("iApplicabilityId1", typeof(Int16)); BidRange.Columns.Add(col); col = new DataColumn("iAmenityId2", typeof(Int32)); BidRange.Columns.Add(col); col = new DataColumn("iApplicabilityId2", typeof(Int16)); BidRange.Columns.Add(col); DataRow drBidRange = BidRange.NewRow(); drBidRange["dtEffectiveDate"] = eobj.Self.dtEffectiveDate; drBidRange["iDays"] = eobj.Self.bWeekend; drBidRange["dDiscount"] = eobj.Self.dWeekendDiscount == null ? (object)DBNull.Value : eobj.Self.dWeekendDiscount; drBidRange["iAmenityId1"] = eobj.Self.iAmenityId1 == 0 || eobj.Self.iAmenityId1 == null ? (object)DBNull.Value : eobj.Self.iAmenityId1; drBidRange["iApplicabilityId1"] = eobj.Self.iApplicabilityId1 == 0 || eobj.Self.iApplicabilityId1 == null ? (object)DBNull.Value : eobj.Self.iApplicabilityId1; drBidRange["iAmenityId2"] = eobj.Self.iAmenityId2 == 0 || eobj.Self.iAmenityId2 == null ? (object)DBNull.Value : eobj.Self.iAmenityId2; drBidRange["iApplicabilityId2"] = eobj.Self.iApplicabilityId2 == 0 || eobj.Self.iApplicabilityId2 == null ? (object)DBNull.Value : eobj.Self.iApplicabilityId2; BidRange.Rows.Add(drBidRange); SqlParameter[] MyParam = new SqlParameter[7]; MyParam[0] = new SqlParameter("@BidRange", BidRange); MyParam[0].TypeName = "[dbo].[BidRange]"; MyParam[1] = new SqlParameter("@iPropId", eobj.Self.iPropId); MyParam[2] = new SqlParameter("@bCloseOut", eobj.Self.bIsClosedweek); MyParam[3] = new SqlParameter("@bCTA", eobj.Self.bCTAweek); MyParam[4] = new SqlParameter("@bCTD", eobj.Self.bCTDweek); MyParam[5] = new SqlParameter("@iActionBy", eobj.Self.iActionBy); MyParam[6] = new SqlParameter("@typ", eobj.IsPublic ? 1 : 0); db.Database.ExecuteSqlCommand("uspSaveWeekenBidding @BidRange, @iPropId, @iActionBy, @bCloseOut, @bCTA, @bCTD, @typ", MyParam); retval = 1; } catch (Exception) { throw; } } return(retval); }
public ActionResult Week(string date, string type, string pctype) { etblPropertyWeekendBiddingMapForOverview obj = new etblPropertyWeekendBiddingMapForOverview(); obj = BL_tblPropertyWeekendBiddingMap.GetSingleRecordById(clsUtils.ConvertyyyymmddtoDateTime(date), Convert.ToInt32(Session["PropId"]), Convert.ToInt32(type), pctype); if (obj.Self.bWeekend != null) { obj.Self.EffectiveDate = String.Format("{0:dd/MM/yyyy}", obj.Self.dtEffectiveDate); } else { obj.Self.dtEffectiveDate = clsUtils.ConvertyyyymmddtoDateTime(date); obj.Self.EffectiveDate = String.Format("{0:dd/MM/yyyy}", obj.Self.dtEffectiveDate); } return(PartialView("_PropertyWeekendBiddingMap", obj)); }
//get single record public static etblPropertyWeekendBiddingMapForOverview GetSingleRecordById(DateTime Date, int PropId, int type, string corporateOrPublic) { etblPropertyWeekendBiddingMapForOverview OBJ = new etblPropertyWeekendBiddingMapForOverview(); etblPropertyWeekendBiddingMap eobjPublic = new etblPropertyWeekendBiddingMap(); etblPropertyWeekendBiddingMap eobjCorp = new etblPropertyWeekendBiddingMap(); using (OneFineRateEntities db = new OneFineRateEntities()) { // Getting Data for Public rates { var dbobj = (from c in db.tblPropertyWeekendBiddingMaps join d in db.tblPropertyBasicBiddingMaps on new { c.dtEffectiveDate, c.iPropId } equals new { d.dtEffectiveDate, d.iPropId } where c.dtEffectiveDate == Date && c.iPropId == PropId select new etblPropertyWeekendBiddingMap { iPropId = c.iPropId, dtEffectiveDate = c.dtEffectiveDate, bIsClosedweek = d.bIsClosedweek, bCTAweek = d.bCTAweek, bCTDweek = d.bCTDweek, bWeekend = c.bWeekend, dWeekendDiscount = c.dWeekendDiscount, iAmenityId1 = c.iAmenityId1, iApplicabilityId1 = c.iApplicabilityId1, iAmenityId2 = c.iAmenityId2, iApplicabilityId2 = c.iApplicabilityId2, dtActionDate = c.dtActionDate, iActionBy = c.iActionBy }).SingleOrDefault(); if (dbobj != null) { eobjPublic = (etblPropertyWeekendBiddingMap)OneFineRateAppUtil.clsUtils.ConvertToObject(dbobj, eobjPublic); } } // Getting Data for Corp rates { var dbobj = (from c in db.tblPropertyWeekendBiddingMapCorps join d in db.tblPropertyBasicBiddingMapCorps on new { c.dtEffectiveDate, c.iPropId } equals new { d.dtEffectiveDate, d.iPropId } where c.dtEffectiveDate == Date && c.iPropId == PropId select new etblPropertyWeekendBiddingMap { iPropId = c.iPropId, dtEffectiveDate = c.dtEffectiveDate, bIsClosedweek = d.bIsClosedweek, bCTAweek = d.bCTAweek, bCTDweek = d.bCTDweek, bWeekend = c.bWeekend, dWeekendDiscount = c.dWeekendDiscount, iAmenityId1 = c.iAmenityId1, iApplicabilityId1 = c.iApplicabilityId1, iAmenityId2 = c.iAmenityId2, iApplicabilityId2 = c.iApplicabilityId2, dtActionDate = c.dtActionDate, iActionBy = c.iActionBy }).SingleOrDefault(); if (dbobj != null) { eobjCorp = (etblPropertyWeekendBiddingMap)OneFineRateAppUtil.clsUtils.ConvertToObject(dbobj, eobjCorp); } } } if (corporateOrPublic == null && type == 9) { OBJ.Self = eobjPublic; OBJ.Other = eobjCorp; OBJ.IsPublic = true; } else { if (corporateOrPublic == "p") { OBJ.Self = eobjPublic; OBJ.Other = eobjCorp; OBJ.IsPublic = true; } else { OBJ.Self = eobjCorp; OBJ.Other = eobjPublic; OBJ.IsPublic = false; } } //if (type % 2 == 1) // Public discounts as main. Corporate as other. //{ // OBJ.Self = eobjPublic; // OBJ.Other = eobjCorp; // OBJ.IsPublic = true; //} //else //{ // OBJ.Self = eobjCorp; // OBJ.Other = eobjPublic; // OBJ.IsPublic = false; //} return(OBJ); }