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);