public string deleteEmployee(int id)
{
try
{
var query1 = from a in connection.Emp_Tables where a.Id == id select a;
foreach (var info in query1)
{
connection.Emp_Tables.DeleteOnSubmit(info);
}
var query2 = from a in connection.Emp_Details where a.Emp_Id == id select a;
if (query2.Count() != 0)
{
foreach (var info in query2)
{
connection.Emp_Details.DeleteOnSubmit(info);
}
}
var query3 = from a in connection.Room_No_Tables where a.Emp_Id == id select a;
if (query3.Count() != 0)
{
Room_No_Table roomtable2 = query3.First();
roomtable2.Reserved = false;
roomtable2.Emp_Id = 0000;
}
connection.SubmitChanges();
return("Employee Deleted");
}
catch (Exception ex)
{
return(ex.ToString());
}
}
public string UpdateEmpRoom(int id, int room)
{
try
{
var query2 = from a in connection.Room_No_Tables where a.Emp_Id == id select a;
if (query2.Count() != 0)
{
Room_No_Table roomtable2 = query2.First();
roomtable2.Reserved = false;
roomtable2.Emp_Id = 0000;
connection.SubmitChanges();
var query = from a in connection.Room_No_Tables where a.Room_No == room select a;
Room_No_Table roomtable = query.First();
roomtable.Emp_Id = id;
roomtable.Reserved = true;
connection.SubmitChanges();
return("Employee Information Updated");
}
else
{
return("Sorry! This Employee is not exist");
}
}
catch (Exception)
{
return("Sorry Database ");
}
}
public bool setEmpRoom(int id, int room)
{
try
{
var query = from a in connection.Room_No_Tables where a.Room_No == room select a;
Room_No_Table roomtable = query.First();
roomtable.Emp_Id = id;
roomtable.Reserved = true;
connection.SubmitChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
partial void DeleteRoom_No_Table(Room_No_Table instance);
partial void UpdateRoom_No_Table(Room_No_Table instance);
partial void InsertRoom_No_Table(Room_No_Table instance);
