public JsonResult Confirm_Update(Nullable <int> Id, string name, string description, string photo, Nullable <int> capacity, Nullable <int> overhead_projector, Nullable <int> slide_projctor, Nullable <int> film_projctor, Nullable <int> ifp, Nullable <int> video_screen, Nullable <int> white_board, Nullable <int> microphones, Nullable <int> computer, Nullable <int> loud_speakers ) { db_trns_result new_result = new db_trns_result(); try { db.SP_Update_Meeting_Room(Id, name, description, photo, capacity, true, overhead_projector, slide_projctor, film_projctor, ifp, video_screen, white_board, microphones, computer, loud_speakers); new_result.message = name + " is Updated successfully on the database"; new_result.result = true; } catch (Exception e) { new_result.message = "an error occurred while trying to Update " + name; new_result.advanced = e.Message; new_result.result = false; } return(Json(new_result, JsonRequestBehavior.AllowGet)); }
public JsonResult Insert_Meeting_Room( string name, string description, string photo, Nullable <int> capacity, Nullable <int> overhead_projector, Nullable <int> slide_projctor, Nullable <int> film_projctor, Nullable <int> ifp, Nullable <int> video_screen, Nullable <int> white_board, Nullable <int> microphones, Nullable <int> computer, Nullable <int> loud_speakers ) { db_trns_result new_result = new db_trns_result(); try { db.SP_Insert_Meeting_Room(name, description, photo, capacity, true, User.Identity.GetUserId(), overhead_projector, slide_projctor, film_projctor, ifp, video_screen, white_board, microphones, computer, loud_speakers); new_result.message = name + " is inserted successfully on the database, now you can use it on reservation module."; new_result.result = true; } catch (Exception e) { new_result.message = "an error occurred while trying to insert " + name + " into database, please re-try to use it on reservation module."; new_result.advanced = e.Message; new_result.result = false; } return(Json(new_result, JsonRequestBehavior.AllowGet)); }
public JsonResult Update_Localization_Format(string activity_time) { db_trns_result new_result = new db_trns_result(); try { db.SP_Update_Localization_Format_Settings(activity_time); new_result.message = "Localization Format is Updated successfully...!"; new_result.result = true; } catch (Exception e) { new_result.message = "an error occurred while trying to Update "; new_result.advanced = e.Message; new_result.result = false; } return(Json(new_result, JsonRequestBehavior.AllowGet)); }
public JsonResult Update_Email_Server(string ssl, string user_name, string password, string port, string smtp, string email) { db_trns_result new_result = new db_trns_result(); try { db.SP_Update_Email_Settings(email, Settings.Encrypt(password), ssl, user_name, smtp, port); new_result.message = "Email Server is Updated successfully...!"; new_result.result = true; } catch (Exception e) { new_result.message = "an error occurred while trying to Update "; new_result.advanced = e.Message; new_result.result = false; } return(Json(new_result, JsonRequestBehavior.AllowGet)); }
public JsonResult Confirm_Delete(int Id) { db_trns_result new_result = new db_trns_result(); try { db.SP_Delete_Meeting_Room(Id); new_result.message = "Meeting Room is Deleted successfully on the database"; new_result.result = true; } catch (Exception e) { new_result.message = "an error occurred while trying to Delete "; new_result.advanced = e.Message; new_result.result = false; } return(Json(new_result, JsonRequestBehavior.AllowGet)); }
public JsonResult Update_Reservation_Configuration(string unconfirmed_cancellation, string check_in, string week_start, string week_end, string day_start, string day_end) { db_trns_result new_result = new db_trns_result(); try { db.SP_Update_Reservation_Configuration_Settings(unconfirmed_cancellation, check_in, week_start, week_end, day_start, day_end); new_result.message = "Reservation Configuration is Updated successfully...!"; new_result.result = true; } catch (Exception e) { new_result.message = "an error occurred while trying to Update "; new_result.advanced = e.Message; new_result.result = false; } return(Json(new_result, JsonRequestBehavior.AllowGet)); }
public JsonResult Confirm_Canecl_Reservation(int Id) { db_trns_result new_result = new db_trns_result(); try { db.SP_Cancel_Resevation(Id); new_result.message = " Reservationis Canceled successfully."; new_result.result = true; } catch (Exception e) { new_result.message = "an error occurred while trying to Cancel Reservation."; new_result.advanced = e.Message; new_result.result = false; } BroadCastData(); return(Json(new_result, JsonRequestBehavior.AllowGet)); }
public JsonResult New_Reservation(string created_by, DateTime from, DateTime to, int meetingroom_Id, string subject, string description) { db_trns_result new_result = new db_trns_result(); try { db.SP_Insert_Reservations_And_Attendees(created_by, from, to, null, null, null, meetingroom_Id, subject, description, true); new_result.message = " Reservation inserted successfully"; new_result.result = true; BroadCastData(); } catch (Exception e) { new_result.message = "an error occurred while trying to insert Reservation"; new_result.advanced = e.Message; new_result.result = false; } return(Json(new_result, JsonRequestBehavior.AllowGet)); }