protected void modalBtnAdd_Click(object sender, EventArgs e)
{
List<SupervisorMapping> supervisors = new List<SupervisorMapping>();
if (Session["SupMap"] != null)
{
supervisors = (List<SupervisorMapping>)Session["SupMap"];
}
SupervisorMapping supmap = new SupervisorMapping();
supmap.SupervisorId = Convert.ToInt32(modalDropDownSupervisor.SelectedItem.Value);
supmap.supervisorname = modalDropDownSupervisor.SelectedItem.Text;
supmap.supdepartment = modalDropDownDepartment.SelectedItem.Text;
supmap.UserId = Convert.ToInt32(modalDropDownUsers.SelectedItem.Value);
supervisors.Add(supmap);
gridViewModal.DataSource = supervisors;
gridViewModal.DataBind();
InitializeModalDropDownSupervisor();
Session["SupMap"] = supervisors;
programmaticModalPopup.Show();
}
protected void modalBtnSubmit_Command(object sender, CommandEventArgs e)
{
int userid = Convert.ToInt32(modalDropDownUsers.SelectedItem.Value);
for (int i = 0; i < gridViewModal.Rows.Count; i++)
{
SupervisorMapping supmap = new SupervisorMapping();
CheckBox cb = (CheckBox)gridViewModal.Rows[i].FindControl("modalChkSupervisor");
Label labelSupId = (Label)gridViewModal.Rows[i].FindControl("modalLabelSupId");
int supid = Convert.ToInt32(labelSupId.Text);
supmap = supmap.GetSupervisorMapping(userid, supid);
if (cb.Checked)
{
if (supmap == null)
{
supmap = new SupervisorMapping();
supmap.UserId = userid;
supmap.SupervisorId = supid;
supmap.Insert(supmap);
}
}
else
{
if (supmap != null)
{
supmap.Delete(supmap.Id);
}
}
}
Session["SupMap"] = null;
this.programmaticModalPopup.Hide();
InitializeMainGrid();
}
protected bool isSupervisor()
{
SupervisorMapping supmap = new SupervisorMapping();
if(supmap.GetActiveSubordinates(Convert.ToInt32(Session["UserId"])).Count > 0)
return true;
else
return false;
}
protected void InitializeModalGridView()
{
int userid = Convert.ToInt32(modalDropDownUsers.SelectedItem.Value);
SupervisorMapping supmap = new SupervisorMapping();
List<SupervisorMapping> supervisors = supmap.GetActiveSupervisors(userid);
gridViewModal.DataSource = supervisors;
gridViewModal.DataBind();
for (int i = 0; i < gridViewModal.Rows.Count; i++)
{
CheckBox cb = (CheckBox)gridViewModal.Rows[i].FindControl("modalChkSupervisor");
Label labelSupId = (Label)gridViewModal.Rows[i].FindControl("modalLabelSupId");
//cb.Checked = true;
labelSupId.ToolTip = supervisors[i].Id.ToString();
}
Session["SupMap"] = supervisors;
}
//Get all available users that is not yet selected as a supervisor by a specific user
public List<User> GetAvailableSupervisors(int userid,int departmentId)
{
TimeTrackerEntities db = new TimeTrackerEntities();
SupervisorMapping supmap = new SupervisorMapping();
var data = (from u in db.T_Users
where u.DepartmentId == departmentId
&& u.Status == "Active"
select new User()
{
Id = u.Id,
Username = u.Username,
Password = u.Password,
Firstname = u.Firstname,
Lastname = u.Lastname,
Phone = u.Phone,
Mobile = u.Mobile,
Fax = u.Fax,
Email = u.Email,
DepartmentId = u.DepartmentId,
RoleId = u.RoleId,
CreateDate = u.CreateDate,
CreatedBy = u.CreatedBy,
LastUpdateDate = u.LastUpdateDate,
LastUpdatedBy = u.LastUpdatedBy,
Status = u.Status,
fullname = u.Firstname + " " + u.Lastname,
role = u.M_Role.Description,
department = u.M_Department.Description,
EmployeeNumber = u.EmployeeNumber,
currentSalary = 0,
currentOffDay = 0,
currentSpecialOffDay = 0,
currentOptOffDay1 = 0,
currentOptOffDay2 = 0,
currentOptOffDay3 = 0,
currentOptOffDay4 = 0,
noOTpay = false,
startTime = "",
endTime = "",
shifting = false,
currentRateStartDate = DateTime.Today,
currentRateCreateDate = DateTime.Today
}).ToList();
db.Dispose();
var suplist = supmap.GetActiveSupervisors(userid, departmentId);
foreach (SupervisorMapping s in suplist)
{
for (int i = 0; i < data.Count; i++)
{
if (data[i].Id == s.SupervisorId)
{
data.RemoveAt(i);
break;
}
}
}
return data;
}
public void Update(SupervisorMapping rs)
{
using (TimeTrackerEntities db = new TimeTrackerEntities())
{
try
{
T_SupervisorMapping t_rs = db.T_SupervisorMapping.FirstOrDefault(p => p.Id == rs.Id);
t_rs.UserId = rs.UserId;
t_rs.SupervisorId = rs.SupervisorId;
db.SaveChanges();
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
}
public void Insert(SupervisorMapping rm)
{
T_SupervisorMapping t_rm = new T_SupervisorMapping();
t_rm.UserId = rm.UserId;
t_rm.SupervisorId = rm.SupervisorId;
using (TimeTrackerEntities db = new TimeTrackerEntities())
{
try
{
db.T_SupervisorMapping.Add(t_rm);
db.SaveChanges();
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
}
protected void gridViewJobTrack_Command(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
modalBtnDelete.Visible = true;
DateTime date = Convert.ToDateTime(txtBoxDate.Text);
int i = Convert.ToInt32(e.CommandArgument);
int userid = Convert.ToInt32(Session["UserId"]);
int jobtrackerId = Convert.ToInt32(((Label)gridJobTrack.Rows[i].FindControl("labelJobTrackId")).Text);
bool noError = true;
if (date.CompareTo(DateTime.Today) < 0)
{
SupervisorMapping supmap = new SupervisorMapping();
if (supmap.GetActiveSupervisors(userid).Count < 1)
{
noError = false;
panelAlertHeader2.CssClass = "modalAlertHeader";
alertModalBtnOK2.CssClass = "buttonalert";
labelAlertHeader2.Text = "Error";
labelAlertMessage2.Text = "Sorry you cannot edit job on previous date without a direct supervisor. Please contact your system administrator.";
programmaticAlertModalPopup2.Show();
}
}
else
{
JobTracker jobtracker = new JobTracker();
string errMsg = "";
errMsg = jobtracker.GetError(userid, date, 7);
if (errMsg.Trim() != "")
{
noError = false;
panelAlertHeader2.CssClass = "modalAlertHeader";
alertModalBtnOK2.CssClass = "buttonalert";
labelAlertHeader2.Text = "Error";
labelAlertMessage2.Text = errMsg.Trim() + " Please settle error first.";
programmaticAlertModalPopup2.Show();
}
}
if(noError)
{
JobTracker jobtracker = new JobTracker();
jobtracker = jobtracker.GetJobTracker(jobtrackerId,false);
//List<JobTracker> datalist = new List<JobTracker>();
//datalist = jobtracker.GetJobTrackerList(userid, date);
modalLabelError.Text = "";
modalLabelError.Visible = false;
modalBtnSubmit.CommandArgument = jobtracker.Id.ToString();
modalBtnDelete.CommandArgument = jobtracker.Id.ToString();
InitializeModalJobType(jobtracker.JobTypeId.ToString());
//InitializeModalStartTime(jobtracker.StartTime.ToString());
InitializeModalJobStatus(jobtracker.JobStatus == null ? "" : jobtracker.JobStatus.Trim());
bool generateBlank = false;
if (date.CompareTo(DateTime.Today) == 0)
generateBlank = true;
Session["StartTime"] = Convert.ToDateTime(jobtracker.StartTime).TimeOfDay.ToString();
GenerateStartHour(Convert.ToDateTime(jobtracker.StartTime).TimeOfDay.ToString());
GenerateStartMin(Convert.ToInt32(modalDropDownStartTimeHour.SelectedItem.Value), Convert.ToDateTime(jobtracker.StartTime).TimeOfDay.ToString());
string endtime = "";
if (jobtracker.EndTime != null)
endtime = jobtracker.EndTime.ToString();
//InitializeModalEndTime(endtime);
GenerateEndHour(Convert.ToInt32(modalDropDownStartTimeHour.SelectedItem.Value), Convert.ToInt32(modalDropDownStartTimeMin.SelectedItem.Value), generateBlank, endtime == "" ? "" : Convert.ToDateTime(jobtracker.EndTime).ToString());
GenerateEndMin(Convert.ToInt32(modalDropDownStartTimeHour.SelectedItem.Value), Convert.ToInt32(modalDropDownStartTimeMin.SelectedItem.Value), modalDropDownEndTimeHour.SelectedItem.Text.Trim(), endtime == "" ? "" : Convert.ToDateTime(jobtracker.EndTime).TimeOfDay.ToString());
//if (datalist[i].ApprovedBy != null && datalist[i].ApprovedBy != userid && datalist[i].ApprovedBy != 0)
//{
// //InitializeModalSupervisor(datalist[i].ApprovedBy.ToString());
// //modalLabelSupervisor.Visible = true;
// //modalLabelSupColon.Visible = true;
// //modalDropDownSupervisor.Visible = true;
//}
//else if (date.CompareTo(DateTime.Today) < 0)
//{
//InitializeModalSupervisor();
//modalLabelSupervisor.Visible = true;
//modalLabelSupColon.Visible = true;
//modalDropDownSupervisor.Visible = true;
//}
//else
//{
// //modalLabelSupervisor.Visible = false;
// //modalLabelSupColon.Visible = false;
// //modalDropDownSupervisor.Visible = false;
//}
if (jobtracker.JobIdNumber != null && jobtracker.JobIdNumber.Trim() != "")
{
modalTxtBoxJobId.Text = jobtracker.JobIdNumber;
JobTracker jobTracker = new JobTracker();
jobTracker = jobTracker.GenerateHWAndSW(modalTxtBoxJobId.Text.Trim());
modallabelBoxJobDescription.Text = jobTracker.Description;
modallabelCustomer.Text = jobTracker.Customer;
modalLabelHWSW.Text = jobTracker.HWNo;
modalLabelHWSW.ToolTip = jobTracker.SWNo;
modalLabelEvalNo.Text = jobTracker.EvalNo;
}
modalTxtBoxRemarks.Text = jobtracker.Remarks == null ? "" : jobtracker.Remarks.Trim();
Page.Validate();
this.programmaticModalPopup.Show();
}
}
}
//Action triggered when the users click the add job track button
protected void linkBtnAddJobTrack_Click(object sender, EventArgs e)
{
Session["StartTime"] = null;
JobTracker jobtracker = new JobTracker();
DateTime selectedDate = DateTime.Parse(txtBoxDate.Text);
int userid = Convert.ToInt32(Session["UserId"]);
bool noError = true;
if (jobtracker.HasUnclosedJobs(userid)) //check if user has unclosed jobs
{
noError = false;
panelAlertHeader2.CssClass = "modalAlertHeader";
alertModalBtnOK2.CssClass = "buttonalert";
labelAlertHeader2.Text = "Error";
labelAlertMessage2.Text = "Please close all jobs before adding a new one.";
programmaticAlertModalPopup2.Show();
}
if (selectedDate.CompareTo(DateTime.Today) < 0)
{
SupervisorMapping supmap = new SupervisorMapping();
if (supmap.GetActiveSupervisors(userid).Count < 1)
{
noError = false;
panelAlertHeader2.CssClass = "modalAlertHeader";
alertModalBtnOK2.CssClass = "buttonalert";
labelAlertHeader2.Text = "Error";
labelAlertMessage2.Text = "Sorry you cannot add job on previous date without a direct supervisor. Please contact your system administrator.";
programmaticAlertModalPopup2.Show();
}
}
else
{
string errMsg = "";
errMsg = jobtracker.GetError(userid, selectedDate, 30); //check if there is an error
if (errMsg.Trim() != "")
{
noError = false;
panelAlertHeader2.CssClass = "modalAlertHeader";
alertModalBtnOK2.CssClass = "buttonalert";
labelAlertHeader2.Text = "Error";
labelAlertMessage2.Text = errMsg.Trim() + " Please settle error first.";
programmaticAlertModalPopup2.Show();
}
}
if(noError)
{
InitializeModalJobType();
//InitializeModalStartTime();
//InitializeModalEndTime();
InitializeModalJobStatus();
bool generateBlank = false;
if (selectedDate.CompareTo(DateTime.Today) == 0)
generateBlank = true;
GenerateStartHour();
GenerateStartMin(Convert.ToInt32(modalDropDownStartTimeHour.SelectedItem.Value));
GenerateEndHour(Convert.ToInt32(modalDropDownStartTimeHour.SelectedItem.Value), Convert.ToInt32(modalDropDownStartTimeMin.SelectedItem.Value), generateBlank);
GenerateEndMin(Convert.ToInt32(modalDropDownStartTimeHour.SelectedItem.Value), Convert.ToInt32(modalDropDownStartTimeMin.SelectedItem.Value), modalDropDownEndTimeHour.SelectedItem.Text.Trim());
modalBtnSubmit.CommandArgument = "Add";
modalBtnDelete.Visible = false;
modalTxtBoxRemarks.Text = "";
modalLabelError.Text = "";
modalLabelError.Visible = false;
modallabelBoxJobDescription.Text = "";
modallabelCustomer.Text = "";
modalTxtBoxJobId.Text = "";
modalLabelHWSW.Text = "";
modalLabelHWSW.ToolTip = "";
modalLabelEvalNo.Text = "";
//modalTxtBoxJobId.Enabled = false;
Page.Validate();
this.programmaticModalPopup.Show();
}
}