public ActionResult _Destroy([DataSourceRequest]DataSourceRequest request, TB_HotelPromotionExt model) { string Msg = ""; try { TB_HotelPromotionRepository modelRepo = new TB_HotelPromotionRepository(); if (modelRepo.Delete(model, ref Msg, this) == false) { return this.Json(new DataSourceResult { Errors = Msg }); } } catch (Exception ex) { string hostName1 = Dns.GetHostName(); string GetUserIPAddress = Dns.GetHostByName(hostName1).AddressList[0].ToString(); string PageName = Convert.ToString(Session["PageName"]); //string GetUserIPAddress = GetUserIPAddress1(); using (BaseRepository baseRepo = new BaseRepository()) { //BizContext BizContext1 = new BizContext(); BizApplication.AddError(baseRepo.BizDB, PageName, ex.Message, ex.StackTrace, DateTime.Now, GetUserIPAddress); } Session["PageName"] = ""; string error = ErrorHandling.HandleException(ex); return this.Json(new DataSourceResult { Errors = error }); } return Json(request); }
public bool Update(TB_HotelPromotionExt model, ref string Msg, Controller ctrl) { bool status = true; var PageObj = db.TB_HotelPromotion.Where(x => x.ID == model.ID).FirstOrDefault(); PageObj.ID = model.ID; PageObj.HotelID = model.HotelID; PageObj.PromotionID = model.PromotionID; PageObj.StartDate = model.StartDate; PageObj.EndDate = model.EndDate; PageObj.HasDiscount = model.HasDiscount; PageObj.DiscountPercentage = Convert.ToInt32(model.DiscountPercentage); PageObj.AccommodationEndDate = model.AccommodationEndDate; PageObj.AccommodationStartDate = model.AccommodationStartDate; PageObj.DayID = Convert.ToString(model.DayID); PageObj.DayCount = model.DayCount; PageObj.EarlyBookerMargin = model.EarlyBookerMargin; PageObj.LastMinuteMargin = model.LastMinuteMargin; PageObj.BookingDate = model.BookingDate; PageObj.PricePolicyID = Convert.ToString(model.PricePolicyID); PageObj.SecretDeal = model.SecretDeal; PageObj.Region = model.Region; PageObj.ValidForAllRoomTypes = model.ValidForAllRoomTypes; PageObj.Active = model.Active; PageObj.SecretDeal = model.SecretDeal; PageObj.OpDateTime = DateTime.Now; PageObj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]); ; db.SaveChanges(); return status; }
public bool Delete(TB_HotelPromotionExt model, ref string Msg, Controller ctrl) { bool status = true; var obj = db.TB_HotelPromotion.Where(x => x.ID == model.ID).FirstOrDefault(); db.TB_HotelPromotion.Remove(obj); db.SaveChanges(); return status; }
public List<TB_HotelPromotionExt> ReadAll(int TableID) { List<TB_HotelPromotionExt> list = new List<TB_HotelPromotionExt>(); DataTable dt = new DataTable(); SQLCon.Open(); SqlCommand cmd = new SqlCommand("B_DisplayTableNew_BizTbl_Table_Sp", SQLCon); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@TableID", TableID); cmd.Parameters.AddWithValue("@CultureCode", CultureCode); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dt); SQLCon.Close(); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { TB_HotelPromotionExt PageObj = new TB_HotelPromotionExt(); PageObj.ID = Convert.ToInt32(dr["ID"]); PageObj.Hotel = dr["FK_HotelID_ID"].ToString(); PageObj.Promotion = dr["FK_PromotionID_ID"].ToString(); PageObj.StartDate = Convert.ToDateTime(dr["StartDate"].ToString()); PageObj.EndDate = Convert.ToDateTime(dr["EndDate"].ToString()); PageObj.HasDiscount = Convert.ToBoolean(dr["HasDiscount"].ToString()); PageObj.DiscountPercentage = dr["DiscountPercentage"].ToString(); PageObj.AccommodationStartDate = Convert.ToDateTime(dr["AccommodationStartDate"].ToString()); PageObj.AccommodationEndDate = Convert.ToDateTime(dr["AccommodationEndDate"].ToString()); PageObj.DayID = dr["DayID"].ToString(); PageObj.DayCount = Convert.ToInt32(dr["DayCount"]); if (dr["EarlyBookerMargin"].ToString()!="") { PageObj.EarlyBookerMargin = Convert.ToInt32(dr["EarlyBookerMargin"].ToString()); } else { PageObj.EarlyBookerMargin = null; } if (dr["LastMinuteMargin"].ToString() != "") { PageObj.LastMinuteMargin = Convert.ToInt32(dr["LastMinuteMargin"].ToString()); } else { PageObj.LastMinuteMargin = null; } if (dr["BookingDate"].ToString() != "") { PageObj.BookingDate = Convert.ToDateTime(dr["BookingDate"].ToString()); } else { PageObj.BookingDate = null; } PageObj.PricePolicyID = dr["PricePolicyID"].ToString(); PageObj.SecretDeal = Convert.ToBoolean(dr["SecretDeal"].ToString()); PageObj.Region = dr["Region"].ToString(); PageObj.ValidForAllRoomTypes = Convert.ToBoolean(dr["ValidForAllRoomTypes"].ToString()); PageObj.Active = Convert.ToBoolean(dr["Active"].ToString()); PageObj.HotelID = Convert.ToInt32(dr["HotelID"].ToString()); PageObj.PromotionID = Convert.ToInt32(dr["PromotionID"].ToString()); list.Add(PageObj); } } return list; }
public bool Create(TB_HotelPromotionExt model, ref string Msg, Controller ctrl) { bool status = true; DBEntities insertentity = new DBEntities(); TB_HotelPromotion PageObj = new TB_HotelPromotion(); // PageObj.ID = model.ID; PageObj.HotelID = model.HotelID; PageObj.PromotionID = model.PromotionID; PageObj.StartDate = model.StartDate; PageObj.EndDate = model.EndDate; PageObj.HasDiscount = model.HasDiscount; PageObj.DiscountPercentage = Convert.ToInt32(model.DiscountPercentage); PageObj.AccommodationEndDate = model.AccommodationEndDate; PageObj.AccommodationStartDate = model.AccommodationStartDate; PageObj.DayID = Convert.ToString(model.DayID); PageObj.DayCount = model.DayCount; PageObj.EarlyBookerMargin = model.EarlyBookerMargin; PageObj.LastMinuteMargin = model.LastMinuteMargin; PageObj.BookingDate = model.BookingDate; PageObj.PricePolicyID = Convert.ToString(model.PricePolicyID); PageObj.SecretDeal = model.SecretDeal; PageObj.Region = model.Region; PageObj.ValidForAllRoomTypes = model.ValidForAllRoomTypes; PageObj.Active = model.Active; PageObj.SecretDeal = model.SecretDeal; PageObj.OpDateTime = DateTime.Now; PageObj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]); ; PageObj.CreateDateTime = DateTime.Now; PageObj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]); ; insertentity.TB_HotelPromotion.Add(PageObj); insertentity.SaveChanges(); return status; }