public static void DeleteRoom(object selectedValue)
{
using (HotelBookingsEntities db = new HotelBookingsEntities())
{
Room c = db.Rooms.SingleOrDefault(x => x.Room_id.ToString().Trim() == selectedValue.ToString().Trim());
if (c != null)
{
db.Rooms.Remove(c);
db.SaveChanges();
}
}
}
public static void DeleteRecord(string insertCusreg)
{
using (HotelBookingsEntities db = new HotelBookingsEntities())
{
CustomerRegestration c = db.CustomerRegestrations.SingleOrDefault(x => x.CustomerID.ToString().Trim() == insertCusreg.Trim());
if (c != null)
{
db.CustomerRegestrations.Remove(c);
db.SaveChanges();
}
}
}
public static int UpdateRoomDetails(Room insertCusreg)
{
using (HotelBookingsEntities db = new HotelBookingsEntities())
{
//Lembda expression
Room c = db.Rooms.SingleOrDefault(x => x.Room_id == insertCusreg.Room_id);
c.Roomno = insertCusreg.Roomno;
c.Beds = insertCusreg.Beds;
c.Floor = insertCusreg.Floor;
c.Type = insertCusreg.Type;
db.SaveChanges();
return(insertCusreg.Room_id);
}
}
public static int UpdateCusRegistration(CustomerRegestration insertCusreg)
{
using (HotelBookingsEntities db = new HotelBookingsEntities())
{
//Lembda expression
CustomerRegestration c = db.CustomerRegestrations.SingleOrDefault(x => x.CustomerID == insertCusreg.CustomerID);
c.FirstNAME = insertCusreg.FirstNAME;
c.LastNAME = insertCusreg.LastNAME;
c.EMAILID = insertCusreg.EMAILID;
c.PHONE = insertCusreg.PHONE;
db.SaveChanges();
return(insertCusreg.CustomerID);
}
}
public static List <Login> GetDataTable(string username, string password)
{
try
{
List <Login> lst = null;
using (HotelBookingsEntities db = new HotelBookingsEntities())
{
lst = (from u in db.Logins where u.username == username && u.password == password select u).ToList();
return(lst);
}
}
catch (Exception ex)
{
throw ex;
}
}