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