public void cancelBooking(string id)
{
var info = context.bookinginfoes.Where(x => x.id.ToString() == id).First();
info.status = "cancelled";
context.SaveChanges();
}
public void deleteMyTravelPlace(string id)
{
int placeid = Int32.Parse(id);
var place = context.travelplaces.Where(x => x.id == placeid).First();
context.travelplaces.Remove(place);
context.SaveChanges();
}
public void deleteHotelinfo(string email)
{
var count = context.hotelinfoes.Where(x => x.hotelempmail == email).ToList();
if (count.Count > 0)
{
var info = context.hotelinfoes.Where(x => x.hotelempmail == email).First();
context.hotelinfoes.Remove(info);
context.SaveChanges();
}
}
public void createNewUser(string[] info)
{
userinfo newuserinfo = new userinfo
{
usermail = info[0],
firstname = info[1],
lastname = info[2],
address = info[3],
phoneno = info[4],
password = info[5],
usertype = info[6]
};
context.userinfoes.Add(newuserinfo);
user newuser = new user
{
usermail = info[0],
password = info[5],
usertype = info[6]
};
context.users.Add(newuser);
context.SaveChanges();
}
public void addCustCareSalary(string email, string salary)
{
customercaresalary custSalary = new customercaresalary
{
custcaremail = email,
currentsalary = salary
};
context.customercaresalaries.Add(custSalary);
context.SaveChanges();
}