public ActionResult Worktype_Edit(juggle.Models.tbl_worktype work_type)
{
try
{
using (jugglecontext dbcon = new jugglecontext())
{
tbl_worktype worktype = new tbl_worktype();
worktype.name = work_type.name.Trim();
worktype.color = work_type.color;
var time = Request.Form["multiple"];
worktype.time = time;
worktype.work_id = work_type.work_id;
worktype.updated_date = DateTime.Now;
worktype.user_id = work_type.user_id;
worktype.created_date = work_type.created_date;
dbcon.Entry(worktype).State = System.Data.Entity.EntityState.Modified;
dbcon.SaveChanges();
return(RedirectToAction("Work_type", "Work_type"));
}
}
catch
{
return(View());
}
}
public ActionResult Employeeavailibility_Edit(tbl_employee_availability employee)
{
if (Session["User_Id"] != null)
{
using (jugglecontext dbcon = new jugglecontext())
{
try
{
tbl_employee_availability empl = new tbl_employee_availability();
empl.emp_id = employee.emp_id;
empl.start_date = Convert.ToDateTime(employee.start_date);
empl.end_date = Convert.ToDateTime(employee.end_date);
empl.userid = Convert.ToInt32(Session["User_Id"]);
empl.time_range_start = employee.time_range_start;
empl.time_range_end = employee.time_range_end;
empl.created_date = employee.created_date;
empl.updated_date = DateTime.Now;
empl.empavailability_id = Convert.ToInt32(employee.empavailability_id);
dbcon.Entry(empl).State = System.Data.Entity.EntityState.Modified;
dbcon.SaveChanges();
// when employee delete at that time his/her assigned appointment will be upassign
SqlConnection connection = new SqlConnection(dbcon.connectionString());
var command = new SqlCommand("[updateempavailibility]", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@startdate", Convert.ToDateTime(employee.start_date));
command.Parameters.AddWithValue("@enddate", Convert.ToDateTime(employee.end_date));
command.Parameters.AddWithValue("@StartTime", employee.time_range_start);
command.Parameters.AddWithValue("@endTime", employee.time_range_end);
command.Parameters.AddWithValue("@emp_id", Convert.ToInt32(employee.emp_id));
command.Parameters.AddWithValue("@type", "edit");
connection.Open();
SqlDataReader rdr = command.ExecuteReader();
return(RedirectToAction("EmployeeAvailability", "EmployeeAvailability"));
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
return(View());
}
public ActionResult changePassword(changePassword changepass)
{
if (Session["User_Id"] != null)
{
using (jugglecontext dbcon = new jugglecontext())
{
var old_pass = changepass.oldPassword.ToString().Trim();
var new_pass = dbcon.Encrypt(changepass.NewPassword.ToString());
tbl_user user = null;
var user_id = Convert.ToInt32(Session["User_Id"].ToString());
string password_fromdb;
var getuser_pass = dbcon.tbl_user.SingleOrDefault(user_id_db => user_id_db.user_id == user_id);
user = dbcon.tbl_user.Where(s => s.user_id == user_id).FirstOrDefault <tbl_user>();
if (getuser_pass != null)
{
password_fromdb = dbcon.Decrypt(getuser_pass.password.ToString());
if (password_fromdb == old_pass)
{
user.password = Convert.ToString(new_pass);
dbcon.tbl_user.Attach(user);
dbcon.Entry(user).State = System.Data.Entity.EntityState.Modified;
dbcon.SaveChanges();
ViewBag.message = "Your password has been changed.";
}
else
{
if (string.IsNullOrEmpty(old_pass))
{
ModelState.AddModelError("oldPassword", "Please enter old password.");
}
else
{
ModelState.AddModelError("", "Invalid old password!");
}
}
}
else
{
ViewBag.InvalidUser = "******";
}
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
return(View());
}
public ActionResult Edit_Supervisorprofile(tbl_user tbluser)
{
if (Session["User_Id"] != null)
{
using (jugglecontext dbcon = new jugglecontext())
{
tbl_user users = new tbl_user();
var userId = Convert.ToInt32(Session["User_Id"]);
users.supervisor_id = tbluser.supervisor_id;
users.user_id = tbluser.user_id;
users.firstName = tbluser.firstName;
users.lastName = tbluser.lastName;
users.address = tbluser.address;
users.phoneno = tbluser.phoneno;
users.email = tbluser.email;
users.status = tbluser.status;
users.username = tbluser.username;
users.password = tbluser.password;
users.created_date = tbluser.created_date;
users.updated_date = DateTime.Now;
users.timezoneid = "Central Standard Time";
Session["firstname"] = tbluser.firstName;
Session["profile_pict"] = tbluser.profile_pict;
if (Request.Files.Count > 0)
{
var file = Request.Files[0];
if (file != null && file.ContentLength > 0)
{
var fileName = Path.GetFileName(file.FileName);
users.profile_pict = fileName;
var path = Path.Combine(Server.MapPath("~/Profile_Picture/"), fileName);
file.SaveAs(path);
}
else
{
users.profile_pict = tbluser.profile_pict;
}
}
users.role_id = 2;
dbcon.Entry(users).State = System.Data.Entity.EntityState.Modified;
dbcon.SaveChanges();
return(RedirectToAction("Index", "SupervisorProfile"));
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public ActionResult Employee_Edit(tbl_employee_info employee)
{
if (Session["User_Id"] != null)
{
using (jugglecontext dbcon = new jugglecontext())
{
try
{
string multipleattribute = Request.Form["attribute_id_multiple"].ToString();
string multipleservice = Request.Form["emp_qualifiedservicetypes_multiple"].ToString();
tbl_employee_info empl = new tbl_employee_info();
empl.emp_id = employee.emp_id;
empl.emp_firstname = employee.emp_firstname;
empl.emp_lastname = employee.emp_lastname;
empl.emp_qualifiedservicetypes = multipleservice;
empl.user_id = employee.user_id;
empl.created_date = employee.created_date;
empl.emp_code = autogenerateid();
empl.updated_date = DateTime.Now;
empl.emp_contactinfo = employee.emp_contactinfo;
empl.attribute_id = multipleattribute;
empl.emp_transportion = employee.emp_transportion;
empl.emp_googlecalendarID = employee.emp_googlecalendarID;
empl.emp_note = employee.emp_note;
empl.emp_password = dbcon.Encrypt(employee.emp_password);
dbcon.Entry(empl).State = System.Data.Entity.EntityState.Modified;
dbcon.SaveChanges();
return(RedirectToAction("Employee", "Employee"));
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
return(View());
}
public ActionResult Edit_Workers(juggle.Models.tbl_user tbluser)
{
if (Session["User_Id"] != null)
{
using (jugglecontext dbcon = new jugglecontext())
{
var getstatusId = 0;
try
{
getstatusId = Convert.ToInt32(Request.Form["status_hidden"]);
}
catch { }
tbl_user users = new tbl_user();
var userId = Convert.ToInt32(Session["User_Id"]);
users.user_id = tbluser.user_id;
users.firstName = tbluser.firstName;
users.lastName = tbluser.lastName;
users.address = tbluser.address;
users.phoneno = tbluser.phoneno;
users.email = tbluser.email;
users.supervisor_id = userId;
users.username = tbluser.username;
users.password = tbluser.password;
if (getstatusId == 0)
{
users.status = tbluser.status;
}
else
{
users.status = Convert.ToInt32(getstatusId);
}
users.created_date = tbluser.created_date;
users.updated_date = DateTime.Now;
users.role_id = 3;
dbcon.Entry(users).State = System.Data.Entity.EntityState.Modified;
dbcon.SaveChanges();
return(RedirectToAction("ManageWorkers", "Workers"));
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public ActionResult Worktype_Category_Edit(juggle.Models.tbl_worktype_category work_type_category)
{
try
{
using (jugglecontext dbcon = new jugglecontext())
{
tbl_worktype_category worktype = new tbl_worktype_category();
worktype.worktypecategory_name = work_type_category.worktypecategory_name.Trim();
worktype.worktypecat_id = work_type_category.worktypecat_id;
worktype.updated_date = DateTime.Now;
worktype.created_date = work_type_category.created_date;
dbcon.Entry(worktype).State = System.Data.Entity.EntityState.Modified;
dbcon.SaveChanges();
return(RedirectToAction("Worktype_category", "Work_Type_Category"));
}
}
catch (Exception ex)
{
return(View());
}
}
public ActionResult attribute_Edit(juggle.Models.tbl_attribute_data work_type_category)
{
try
{
using (jugglecontext dbcon = new jugglecontext())
{
var userId = Convert.ToInt32(Session["User_Id"]);
tbl_attribute_data attribute = new tbl_attribute_data();
attribute.attribute_name = work_type_category.attribute_name.Trim();
attribute.attribute_id = work_type_category.attribute_id;
attribute.updated_date = DateTime.Now;
attribute.created_date = work_type_category.created_date;
attribute.user_id = userId;
dbcon.Entry(attribute).State = System.Data.Entity.EntityState.Modified;
dbcon.SaveChanges();
return(RedirectToAction("attribute", "Attribute"));
}
}
catch
{
return(View());
}
}
public ActionResult Client_Edit(tbl_client clientmodel)
{
if (Session["User_Id"] != null)
{
using (jugglecontext dbcon = new jugglecontext())
{
string multipleattribute = Request.Form["attribute_id_multiple"].ToString();
var x_lat = 0.0;
var y_long = 0.0;
var getScheduleId = 0;
try
{
x_lat = Convert.ToDouble(Request.Form["x_lat"]);
}
catch
{
x_lat = 0.0;
}
try
{
y_long = Convert.ToDouble(Request.Form["y_long"]);
}
catch
{
y_long = 0.0;
}
try
{
getScheduleId = Convert.ToInt32(Request.Form["schedule_hidden"]);
}
catch { }
tbl_client client_info = new tbl_client();
client_info.client_id = clientmodel.client_id;
client_info.client_firstname = clientmodel.client_firstname;
client_info.client_lastname = clientmodel.client_lastname;
client_info.client_companyname = clientmodel.client_companyname;
client_info.client_secondaryname = clientmodel.client_secondaryname;
client_info.client_email = clientmodel.client_email;
client_info.client_contact_info = clientmodel.client_contact_info;
client_info.client_address = clientmodel.client_address;
if (!string.IsNullOrEmpty(clientmodel.client_note))
{
client_info.client_note = clientmodel.client_note;
}
else
{
client_info.client_note = "N/A";
}
client_info.user_id = clientmodel.user_id;
client_info.updated_date = DateTime.Now;
client_info.created_date = clientmodel.created_date;
client_info.attribute_id = multipleattribute;
client_info.client_code = clientmodel.client_code;
if (x_lat == clientmodel.x_lat)
{
client_info.x_lat = clientmodel.x_lat;
}
else
{
client_info.x_lat = x_lat;
}
if (y_long == clientmodel.y_long)
{
client_info.y_long = clientmodel.y_long;
}
else
{
client_info.y_long = y_long;
}
dbcon.Entry(client_info).State = System.Data.Entity.EntityState.Modified;
dbcon.SaveChanges();
return(RedirectToAction("Client", "Client"));
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public ActionResult appointment_edit(juggle.Models.tbl_appointment appointment)
{
if (Session["User_Id"] == null)
{
return(RedirectToAction("Appointment", "Appointment"));
}
if (Session["User_Id"] != null)
{
try
{
using (jugglecontext dbcon = new jugglecontext())
{
tbl_appointment editappointment = new tbl_appointment();
string multipleattribute = Request.Form["attribute_iddata"].ToString();
editappointment.appointment_id = appointment.appointment_id;
editappointment.description = appointment.description;
editappointment.recurring = appointment.recurring;
editappointment.start_date = appointment.start_date;
editappointment.end_date = appointment.end_date;
editappointment.time = appointment.time;
string multiplevalue = Request.Form["multiple"];
if (appointment.recurring)
{
//appointment.end_date = null;
}
if (!string.IsNullOrEmpty(multiplevalue))
{
editappointment.day = multiplevalue;
}
else
{
multiplevalue = "0"; editappointment.day = "0";
}
editappointment.updated_date = DateTime.Now;
if (!string.IsNullOrEmpty(appointment.notes))
{
editappointment.notes = appointment.notes;
}
else
{
editappointment.notes = "N/A";
}
// editappointment.notes = appointment.notes;
editappointment.time_range_start = appointment.time_range_start;
editappointment.time_range_end = appointment.time_range_end;
// add two extra field that store the calendar start time and end time
// it is use for the event of google calendar only
// start
string startdate1 = appointment.start_date.ToString();
DateTime strstartdate1 = Convert.ToDateTime(startdate1);
string enddate1 = appointment.end_date.ToString();
DateTime strenddate1 = Convert.ToDateTime(enddate1);
DateTime cal_startdate = Convert.ToDateTime(strstartdate1.ToString("yyyy/MM/dd") + " " + appointment.time_range_start);
DateTime cal_enddate = Convert.ToDateTime(strenddate1.ToString("yyyy/MM/dd") + " " + appointment.time_range_end);
editappointment.Calendar_Start_datetime = DateTimeOffset.Parse(cal_startdate.ToString()).UtcDateTime;
editappointment.Calendar_End_datetime = DateTimeOffset.Parse(cal_enddate.ToString()).UtcDateTime;
string timezone = "West Asia Standard Time";
TimeZoneInfo targetZone = TimeZoneInfo.FindSystemTimeZoneById(timezone);
cal_startdate = TimeZoneInfo.ConvertTimeFromUtc(cal_startdate, targetZone);
cal_enddate = TimeZoneInfo.ConvertTimeFromUtc(cal_enddate, targetZone);
editappointment.Calendar_Start_datetime = cal_startdate;
editappointment.Calendar_End_datetime = cal_enddate;
// end
// get time into total minutes
string startingtime = appointment.time_range_start.ToString();
string endindtime = appointment.time_range_end.ToString();
TimeSpan starttime = TimeSpan.Parse(startingtime);
TimeSpan endatime = TimeSpan.Parse(endindtime);
TimeSpan Difflength = endatime.Subtract(starttime); // difference between start time and end time
int total = (Difflength.Hours * 60) + Difflength.Minutes; // convert difference in minutes
editappointment.length = total;
editappointment.client_id = Convert.ToInt32(appointment.client_id);
editappointment.attribute_id = multipleattribute.ToString();
editappointment.emp_id = Convert.ToInt32(appointment.emp_id);
editappointment.work_id = Convert.ToInt32(appointment.work_id);
editappointment.time_interval_id = Convert.ToInt32(appointment.time_interval_id);
editappointment.user_id = Convert.ToInt32(Session["User_Id"]);
dbcon.Entry(editappointment).State = System.Data.Entity.EntityState.Modified;
dbcon.SaveChanges();
// delete the appointment already inserted days and again insert into another table
//SqlConnection appointmentconnection = new SqlConnection(dbcon.connectionString());
//var appointmentcommand = new SqlCommand("appooint_day", appointmentconnection);
//appointmentcommand.CommandType = CommandType.StoredProcedure;
//appointmentcommand.Parameters.AddWithValue("@appointment_id", Convert.ToInt32(appointment.appointment_id));
//appointmentcommand.Parameters.AddWithValue("@type", "deleteappointmentday");
//appointmentconnection.Open();
//SqlDataReader appointmentreader = appointmentcommand.ExecuteReader();
//appointmentconnection.Close();
SqlConnection connectiondeleteday = new SqlConnection(dbcon.connectionString());
var commanddeleteday = new SqlCommand("Appointmentday", connectiondeleteday);
commanddeleteday.CommandType = CommandType.StoredProcedure;
commanddeleteday.Parameters.AddWithValue("@maxid", Convert.ToInt32(0));
commanddeleteday.Parameters.AddWithValue("@day", Convert.ToInt32(0));
commanddeleteday.Parameters.AddWithValue("@appointmentid", Convert.ToInt32(appointment.appointment_id));
commanddeleteday.Parameters.AddWithValue("@type", "deleteday");
connectiondeleteday.Open();
SqlDataReader rdrdelete = commanddeleteday.ExecuteReader();
connectiondeleteday.Close();
if (!string.IsNullOrEmpty(multiplevalue))
{
string[] values = multiplevalue.Split(',');
for (int i = 0; i < values.Length; i++)
{
values[i] = values[i].Trim();
SqlConnection connectionupdateday = new SqlConnection(dbcon.connectionString());
var commandupdateday = new SqlCommand("Appointmentday", connectionupdateday);
commandupdateday.CommandType = CommandType.StoredProcedure;
commandupdateday.Parameters.AddWithValue("@maxid", Convert.ToInt32(appointment.appointment_id));
commandupdateday.Parameters.AddWithValue("@day", Convert.ToInt32(values[i]));
commandupdateday.Parameters.AddWithValue("@appointmentid", Convert.ToInt32(0));
commandupdateday.Parameters.AddWithValue("@type", "updateday");
connectionupdateday.Open();
SqlDataReader rdrupdate = commandupdateday.ExecuteReader();
connectiondeleteday.Close();
}
}
return(RedirectToAction("Appointment", "Appointment"));
}
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
return(View());
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
