public bool Delete(TB_HotelMinumumAccommodationExt model, ref string Msg, Controller ctrl) { bool status = true; var obj = db.TB_HotelMinumumAccommodation.Where(x => x.ID == model.ID).FirstOrDefault(); db.TB_HotelMinumumAccommodation.Remove(obj); db.SaveChanges(); return status; }
public bool Create(TB_HotelMinumumAccommodationExt model, ref string Msg, Controller ctrl) { bool status = true; TB_HotelMinumumAccommodation obj = new TB_HotelMinumumAccommodation(); // obj.ID = model.ID; obj.HotelID = Convert.ToInt32(model.HotelID); obj.StartDate = Convert.ToDateTime(model.StartDate); obj.EndDate = Convert.ToDateTime(model.EndDate); obj.MinDayCount = Convert.ToInt16(model.MinDayCount); obj.OpDateTime = DateTime.Now; obj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]); db.TB_HotelMinumumAccommodation.Add(obj); db.SaveChanges(); int id = obj.ID; return status; }
public List<TB_HotelMinumumAccommodationExt> ReadAll(int TableID) { List<TB_HotelMinumumAccommodationExt> list = new List<TB_HotelMinumumAccommodationExt>(); 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_HotelMinumumAccommodationExt model = new TB_HotelMinumumAccommodationExt(); model.ID = Convert.ToInt32(dr["ID"]); model.HotelID = dr["HotelID"].ToString(); model.Hotel = dr["FK_HotelID"].ToString(); model.StartDate = Convert.ToDateTime(dr["StartDate"]); model.EndDate = Convert.ToDateTime(dr["EndDate"]); model.MinDayCount = Convert.ToInt16(dr["MinDayCount"]); list.Add(model); } } return list; }
public bool Update(TB_HotelMinumumAccommodationExt model, ref string Msg, Controller ctrl) { bool status = true; var obj = db.TB_HotelMinumumAccommodation.Where(x => x.ID == model.ID).FirstOrDefault(); obj.HotelID = Convert.ToInt32(model.HotelID); obj.StartDate = Convert.ToDateTime(model.StartDate); obj.EndDate = Convert.ToDateTime(model.EndDate); obj.MinDayCount = Convert.ToInt16(model.MinDayCount); obj.OpDateTime = DateTime.Now; obj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]); db.SaveChanges(); return status; }