public bool Create(TB_HotelAvailabilityExt model, ref string Msg, Controller ctrl) { bool status = true; TB_HotelAvailability obj = new TB_HotelAvailability(); obj.ID = model.ID; obj.HotelRoomID = model.HotelRoomID; obj.DateID = model.DateID; obj.RoomCount =model.RoomCount; obj.CloseToArrival = model.CTA; obj.CloseToDeparture = model.CTD; obj.MinimumStay = model.MinimumStay; obj.Closed = model.Closed; obj.OpDateTime = DateTime.Now; obj.OpUserID = 0; db.TB_HotelAvailability.Add(obj); db.SaveChanges(); int id = Convert.ToInt32(obj.ID); return status; }
public List<TB_HotelAvailabilityExt> ReadAll(int TableID) { List<TB_HotelAvailabilityExt> list = new List<TB_HotelAvailabilityExt>(); 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_HotelAvailabilityExt model = new TB_HotelAvailabilityExt(); model.ID = Convert.ToInt32(dr["ID"]); model.HotelRoomID = Convert.ToInt32(dr["HotelRoomID"]); model.HotelRoom = dr["FK_HotelRoomID_ID"].ToString(); model.DateID = Convert.ToInt32(dr["DateID"]); model.Date = Convert.ToDateTime(dr["FK_DateID_ID"]); model.RoomCount = Convert.ToInt32(dr["RoomCount"]); model.CTA = Convert.ToBoolean(dr["CloseToArrival"]); model.CTD = Convert.ToBoolean(dr["CloseToDeparture"]); model.MinimumStay = Convert.ToInt32(dr["MinimumStay"]); model.Closed = Convert.ToBoolean(dr["Closed"]); list.Add(model); } } return list; }
public bool Update(TB_HotelAvailabilityExt model, ref string Msg, Controller ctrl) { bool status = true; var obj = db.TB_HotelAvailability.Where(x => x.ID == model.ID).FirstOrDefault(); obj.ID = model.ID; obj.HotelRoomID = model.HotelRoomID; obj.DateID = model.DateID; obj.RoomCount = model.RoomCount; obj.CloseToArrival = model.CTA; obj.CloseToDeparture = model.CTD; obj.MinimumStay = model.MinimumStay; obj.Closed = model.Closed; obj.OpDateTime = DateTime.Now; obj.OpUserID = 0; db.SaveChanges(); return status; }
public bool Delete(TB_HotelAvailabilityExt model, ref string Msg, Controller ctrl) { bool status = true; var obj = db.TB_HotelAvailability.Where(x => x.ID == model.ID).FirstOrDefault(); db.TB_HotelAvailability.Remove(obj); db.SaveChanges(); return status; }