public static int SaveCusRegistration(CustomerRegestration insertCusreg)
{
using (HotelBookingsEntities db = new HotelBookingsEntities())
{
db.CustomerRegestrations.Add(insertCusreg);
db.SaveChanges();
return(insertCusreg.CustomerID);
}
}
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 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);
}
}