public string InsertRoomDetails(RoomDetails Inroomdetails) { try { ServiceHotelContextCls TC = new ServiceHotelContextCls(); TC.rooms.Add(Inroomdetails); TC.SaveChanges(); return("1 Row Inserted"); } catch (DbUpdateException Ex) { SqlException sql = (SqlException)Ex.GetBaseException(); return(sql.Message); } }
public string InsertCity(City Incity) { try { ServiceHotelContextCls TC = new ServiceHotelContextCls(); TC.cities.Add(Incity); TC.SaveChanges(); return("1 Row Inserted"); } catch (DbUpdateException Ex) { SqlException sql = (SqlException)Ex.GetBaseException(); return(sql.Message); } }
public string Upadtehotel(HotelDetails UH) { //SqlConnection con = new SqlConnection("data source=LAPTOP-OIHMLL23; persist security info=True; initial catalog=HotelJBP;user id=sa;password=abhi123"); //con.Open(); //SqlCommand cmd = new SqlCommand("update tblHotelDetails set HotelName=@HotelName where HotelId=@HotelId", con); //cmd.Parameters.AddWithValue("@HotelId", UH.HotelId); //cmd.Parameters.AddWithValue("@HotelName", UH.HotelName); //cmd.ExecuteNonQuery(); //con.Close(); //return "1 Row Update"; try { var LE = from L in yy.hotels where L.HotelId == UH.HotelId select L; HotelDetails E = LE.First(); E.HotelName = UH.HotelName; E.HotelAddress = UH.HotelAddress; E.HotelDes = UH.HotelDes; E.ContactNo = UH.ContactNo; E.TotalAcRooms = UH.TotalAcRooms; E.AcRoomsAdultRate = UH.AcRoomsAdultRate; E.AcRoomsChildtRate = UH.AcRoomsChildtRate; E.NonAcRoomsAdultRate = UH.NonAcRoomsAdultRate; E.NonAcRoomsChildtRate = UH.NonAcRoomsChildtRate; yy.SaveChanges(); return("Data Update Successfully"); } catch (Exception ET) { return("Please Try Again"); } }
public string Addhotel(HotelDetails AH) { try { ServiceHotelContextCls TC = new ServiceHotelContextCls(); TC.hotels.Add(AH); TC.SaveChanges(); return("Record Saved Successfully"); } catch (DbUpdateException Ex) { SqlException sql = (SqlException)Ex.GetBaseException(); return(sql.Message); } catch (Exception EE) { return("Please Try Again"); } }
public string Removehotel(string RH) { using (ServiceHotelContextCls Delhotel = new ServiceHotelContextCls()) { try { var res = (from D1 in Delhotel.hotels where D1.HotelId == RH select D1).FirstOrDefault(); Delhotel.hotels.Remove(res); Delhotel.SaveChanges(); return("Data Deleted Successfully"); } catch (DbUpdateException Ex) { SqlException sql = (SqlException)Ex.GetBaseException(); return(sql.Message); } } }