protected void GetMyAccessRights()
{
int userid = Convert.ToInt32(Session["UserId"]);
User user = new User();
user = user.GetUser(userid);
Module module = new Module();
module = module.GetModule("SetupUserRate.aspx");
myAccessRights = myAccessRights.GetRolesModuleAccess(Convert.ToInt32(user.RoleId), module.Id);
}
protected void InitializeRepeater()
{
int userid = Convert.ToInt32(Session["UserId"]);
User user = new User();
user = user.GetUser(userid);
Module module = new Module();
var list = module.GetModuleList(Convert.ToInt32(user.RoleId), "Report");
repeaterReport.DataSource = list;
repeaterReport.DataBind();
}
protected bool HasAccess()
{
int userid = Convert.ToInt32(Session["UserId"]);
bool result = false;
User user = new User();
user = user.GetUser(userid);
Module module = new Module();
var list = module.GetModuleList(Convert.ToInt32(user.RoleId), "Report");
if (list.Count > 0)
result = true;
return result;
}
protected bool hasAccess(string modulename)
{
bool result = false;
User user = new User();
user = user.GetUser(Convert.ToInt32(HttpContext.Current.Session["UserId"]));
Module module = new Module();
var list = module.GetModuleList(Convert.ToInt32(user.RoleId),modulename);
RolesModuleAccess moduleAccess = new RolesModuleAccess();
if (list.Count > 0)
result = true;
return result;
}
public TimeClock GetStartEndTime(int userid, DateTime selectedDate)
{
TimeTrackerEntities db = new TimeTrackerEntities();
TimeClock result = new TimeClock();
User user = new User();
user = user.GetUser(userid);
//DateTime stime = Convert.ToDateTime(selectedDate.ToString("yyyy-MM-dd") + " 00:00");
//DateTime etime = Convert.ToDateTime(selectedDate.ToString("yyyy-MM-dd") + " 23:59");
DateTime stime = new DateTime();
DateTime etime = new DateTime();
TimeSpan startTime = new TimeSpan();
TimeSpan endTime = new TimeSpan();
TimeSpan.TryParse(user.startTime == "" ? "08:00":user.startTime, out startTime);
TimeSpan.TryParse(user.endTime == "" ? "17:00":user.endTime, out endTime);
if (startTime > endTime)
{
}
var data = (from t in db.T_TimeClock
where t.EmployeeNumber == user.EmployeeNumber
&& t.ScanTime >= stime
&& t.ScanTime <= etime
orderby t.ScanTime ascending
select new TimeClock()
{
Id = t.Id,
EmployeeNumber = t.EmployeeNumber,
ScanTime = t.ScanTime,
CreateDate = t.CreateDate,
Filename = t.Filename
}).ToList();
db.Dispose();
result.starttime = DateTime.Now.AddYears(1);
for (int i = 0; i < data.Count; i++)
{
if (i % 2 == 0)
{
if (result.starttime == null || result.starttime > data[i].ScanTime)
result.starttime = data[i].ScanTime;
}
else
{
if (result.endtime == null || result.endtime < data[i].ScanTime)
result.endtime = data[i].ScanTime;
}
}
return data.Count < 2 ? null : result;
}
protected bool isValidUser()
{
bool isvalid = false;
if (Session["UserId"] != null)
{
int userid = Convert.ToInt32(Session["UserId"]);
User user = new User();
user = user.GetUser(userid);
if (user != null)
{
isvalid = true;
}
}
return isvalid;
}
protected void gridViewUser_Command(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
GetMyAccessRights();
modalLabelError.Text = "";
modalLabelError.Visible = false;
int index = Convert.ToInt32(e.CommandArgument);
int userid = Convert.ToInt32(((Label)gridViewUser.Rows[index].FindControl("labelUserId")).Text);
User user = new User();
user = user.GetUser(userid);
InitializeModalDropDownDepartment(user.DepartmentId.ToString());
InitializeModalDropDownRole(user.RoleId.ToString());
InitializeModalDropDownStatus(user.Status);
modalBtnSubmit.Visible = Convert.ToBoolean(myAccessRights.CanUpdate);
modalLabelUserId.Text = userid.ToString();
modalBtnSubmit.CommandArgument = "Update";
modalTxtBoxEmployeeNo.Text = user.EmployeeNumber.ToString();
modalTxtBoxFirstname.Text = user.Firstname.Trim();
modalTxtBoxLastname.Text = user.Lastname;
modalTxtBoxUsername.Text = user.Username;
modalTxtBoxPassword.Attributes.Add("value", user.Password);
modalTxtBoxPhone.Text = user.Phone;
modalTxtBoxMobile.Text = user.Mobile;
modalTxtBoxEmail.Text = user.Email;
modalTxtBoxFax.Text = user.Fax;
//InitializeModalRadBtnShift(user.Shift);
modalTxtBoxStartTime.Text = user.startTime;
modalTxtBoxEndTime.Text = user.endTime;
modalTxtBoxSalary.Text = user.currentSalary.ToString();
modalTxtBoxBreakTimeMin.Text = user.currentMinBreak.ToString();
InitializeModalDropDownOffDay(user.currentOffDay.ToString());
InitializeModalDropDownSpecialOffDay(user.currentSpecialOffDay.ToString());
modalChckBoxNoOTPay.Checked = user.noOTpay;
modalChckBoxOfficeWorker.Checked = user.isOfficeWorker;
TimeSpan cutOfTime = user.GetMyCutOfTime();
modalChkBoxUpdateRate.Checked = false;
cpeSalaryRate.ClientState = "true";
ToggleReqField(false);
this.programmaticModalPopup.Show();
}
}
protected void BtnBreak_Click(object sender, EventArgs e)
{
int userid = Convert.ToInt32(Session["UserId"]);
JobType jobtype = new JobType();
jobtype = jobtype.GetDefaultBreak();
DateTime selectedDate = DateTime.Parse(txtBoxDate.Text);
JobTracker jobtracker = new JobTracker();
bool noError = true;
User user = new User();
user = user.GetUser(userid, selectedDate);
if (jobtracker.HasPreviousUnclosedJobs(userid,DateTime.Today)) //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();
}
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)
{
if (TimeSpan.Parse(user.startTime) > TimeSpan.Parse(user.endTime)) //check if user has shifting hours
{
RunBreakButtonActionForShifting();
}
else
{
RunBreakButtonAction();
}
}
}
protected void linkBtnUserlink_Click(object sender, EventArgs e)
{
modalUserlinkChkBoxUpdate.Checked = false;
cpeUserlink.ClientState = "true"; //Collapse the panel
ToggleReqField(false);
modalUserlinkLabelError.Text = "";
modalUserlinkLabelError.Visible = false;
int userid = Convert.ToInt32(Session["UserId"]);
User user = new User();
user = user.GetUser(userid);
modalUserlinkTxtBoxFirstname.Text = user.Firstname.Trim();
modalUserlinkTxtBoxLastname.Text = user.Lastname.Trim();
modalUserlinkTxtBoxUsername.Text = user.Username.Trim();
modalUserlinkTxtBoxEmail.Text = user.Email.Trim();
modalUserlinkTxtBoxPhone.Text = user.Phone.Trim();
modalUserlinkTxtBoxMobile.Text = user.Mobile.Trim();
modalUserlinkTxtBoxFax.Text = user.Fax.Trim();
this.programmaticUserlinkModalPopup.Show();
}
private void ComputeHours()
{
User user = new User();
user = user.GetUser(Convert.ToInt32(UserId), Convert.ToDateTime(StartTime));
if (EndTime != null)
{
DateTime startdatetime = Convert.ToDateTime(StartTime);
TimeSpan stime = startdatetime.TimeOfDay;
TimeSpan etime = Convert.ToDateTime(EndTime).TimeOfDay;
int curday = (int)startdatetime.DayOfWeek;
Holiday holiday = new Holiday();
otcost = 0;
normalcost = 0;
double time = Convert.ToDateTime(EndTime).Subtract(Convert.ToDateTime(StartTime)).TotalMinutes;
if (user.shifting == false)
{
if (user.usePattern == true)
{
string[] pattern = user.offPattern.Split(',');
int patterndays = 0;
List<bool> isOffdays = new List<bool>();
for (int i = 0; i < pattern.Length; i++)
{
patterndays += Convert.ToInt32(pattern[i]);
for (int j = 0; j < Convert.ToInt32(pattern[i]); j++)
{
if (i % 2 == 0)
isOffdays.Add(true);
else
isOffdays.Add(false);
}
}
int offdayindex = 0;
offdayindex = Convert.ToInt32(Math.Floor((startdatetime.Date - user.patternStartDate.Date).TotalDays)) % patterndays;
if (TimeSpan.Parse(user.endTime) <= stime || holiday.IsHoliday(startdatetime.Date) || isOffdays[offdayindex] == true) //entry is OT
{
otmins = time;
}
else if ((etime == new TimeSpan(0, 0, 0) ? new TimeSpan(1, 0, 0, 0) : etime) > TimeSpan.Parse(user.endTime)) //entry is from normal time to OT
{
normalmins = TimeSpan.Parse(user.endTime).Subtract(stime).TotalMinutes;
otmins = (etime == new TimeSpan(0, 0, 0) ? new TimeSpan(1, 0, 0, 0) : etime).Subtract(TimeSpan.Parse(user.endTime)).TotalMinutes;
}
else //entry is within normal time
{
normalmins = time;
}
}
else
{
if (TimeSpan.Parse(user.endTime) <= stime || holiday.IsHoliday(startdatetime.Date) || curday == user.currentOffDay || curday == user.currentSpecialOffDay || curday == user.currentOptOffDay1 || curday == user.currentOptOffDay2 || curday == user.currentOptOffDay3 || curday == user.currentOptOffDay4) //entry is OT
{
otmins = time;
}
else if ((etime == new TimeSpan(0, 0, 0) ? new TimeSpan(1, 0, 0, 0) : etime) > TimeSpan.Parse(user.endTime)) //entry is from normal time to OT
{
normalmins = TimeSpan.Parse(user.endTime).Subtract(stime).TotalMinutes;
otmins = (etime == new TimeSpan(0, 0, 0) ? new TimeSpan(1, 0, 0, 0) : etime).Subtract(TimeSpan.Parse(user.endTime)).TotalMinutes;
}
else //entry is within normal time
{
normalmins = time;
}
}
}
else
{
TimeSpan cutoff = user.GetMyCutOfTime();
if (user.usePattern == true)
{
string[] pattern = user.offPattern.Split(',');
int patterndays = 0;
List<bool> isOffdays = new List<bool>();
for (int i = 0; i < pattern.Length; i++)
{
patterndays += Convert.ToInt32(pattern[i]);
for (int j = 0; j < Convert.ToInt32(pattern[i]); j++)
{
if (i % 2 == 0)
isOffdays.Add(true);
else
isOffdays.Add(false);
}
}
int offdayindex = 0;
if (stime >= cutoff)
{
offdayindex = Convert.ToInt32(Math.Floor((startdatetime.Date - user.patternStartDate.Date).TotalDays)) % patterndays;
if (holiday.IsHoliday(startdatetime.Date) || isOffdays[offdayindex] == true)
otmins = time;
else
normalmins = time;
}
else
{
offdayindex = Convert.ToInt32(Math.Floor((startdatetime.AddDays(-1).Date - user.patternStartDate.Date).TotalDays)) % patterndays;
if (TimeSpan.Parse(user.endTime) <= stime || holiday.IsHoliday(startdatetime.AddDays(-1).Date) || isOffdays[offdayindex] == true)
{
otmins = time;
}
else if ((etime == new TimeSpan(0, 0, 0) ? new TimeSpan(1, 0, 0, 0) : etime) > TimeSpan.Parse(user.endTime))
{
normalmins = TimeSpan.Parse(user.endTime).Subtract(stime).TotalMinutes;
otmins = (etime == new TimeSpan(0, 0, 0) ? new TimeSpan(1, 0, 0, 0) : etime).Subtract(TimeSpan.Parse(user.endTime)).TotalMinutes;
}
}
}
else
{
if (stime >= cutoff)
{
if (holiday.IsHoliday(startdatetime.Date) || curday == user.currentOffDay || curday == user.currentSpecialOffDay || curday == user.currentOptOffDay1 || curday == user.currentOptOffDay2 || curday == user.currentOptOffDay3 || curday == user.currentOptOffDay4)
otmins = time;
else
normalmins = time;
}
else
{
curday = (int)startdatetime.AddDays(-1).DayOfWeek;
if (TimeSpan.Parse(user.endTime) <= stime || holiday.IsHoliday(startdatetime.AddDays(-1).Date) || curday == user.currentOffDay || curday == user.currentSpecialOffDay || curday == user.currentOptOffDay1 || curday == user.currentOptOffDay2 || curday == user.currentOptOffDay3 || curday == user.currentOptOffDay4) //entry is OT
{
otmins = time;
}
else if ((etime == new TimeSpan(0, 0, 0) ? new TimeSpan(1, 0, 0, 0) : etime) > TimeSpan.Parse(user.endTime))
{
normalmins = TimeSpan.Parse(user.endTime).Subtract(stime).TotalMinutes;
otmins = (etime == new TimeSpan(0, 0, 0) ? new TimeSpan(1, 0, 0, 0) : etime).Subtract(TimeSpan.Parse(user.endTime)).TotalMinutes;
}
}
}
}
double hr = Math.Truncate(time / 60);
double min = time % 60;
totalhours = hr == 0 && min == 0 ? "0 min" : (hr > 0 ? hr > 1 ? hr + " hrs" : hr + " hr" : "") + (hr > 0 && min > 0 ? ", " : "") + (min > 0 ? min > 1 ? min + " mins" : min + " min" : "");
hr = Math.Truncate(normalmins / 60);
min = normalmins % 60;
normalhours = hr == 0 && min == 0 ? "0 min" : (hr > 0 ? hr > 1 ? hr + " hrs" : hr + " hr" : "") + (hr > 0 && min > 0 ? ", " : "") + (min > 0 ? min > 1 ? min + " mins" : min + " min" : "");
hr = Math.Truncate(otmins / 60);
min = otmins % 60;
othours = hr == 0 && min == 0 ? "0 min" : (hr > 0 ? hr > 1 ? hr + " hrs" : hr + " hr" : "") + (hr > 0 && min > 0 ? ", " : "") + (min > 0 ? min > 1 ? min + " mins" : min + " min" : "");
}
}
private void ComputeCost()
{
if (EndTime != null)
{
User user = new User();
user = user.GetUser(Convert.ToInt32(UserId), Convert.ToDateTime(StartTime));
Holiday holiday = new Holiday();
OTRateSetting otRateSetting = new OTRateSetting();
DateTime startdatetime = Convert.ToDateTime(StartTime);
//int workingdays = holiday.GetWorkingDaysInMonth(user.Id, startdatetime);
double normalRatePerMin = 0;
//double normalRatePerMin = Convert.ToDouble((user.currentSalary/workingdays) / user.minsWorkPerDay);
if (user.minsWorkPerDay < 490)
normalRatePerMin = Convert.ToDouble((user.currentSalary * 12) / (2080 * 60));
else
normalRatePerMin = Convert.ToDouble((user.currentSalary * 12) / (2184 * 60));
normalcost = normalmins * normalRatePerMin;
otRateSetting = otRateSetting.GetOTRateSettingByDate(startdatetime);
#region OT COMPUTATION
otcost = 0;
if (!user.noOTpay && otRateSetting != null)
{
if (user.currentSalary >= otRateSetting.OTExemptedSalary) //User is Exempted from Salary
{
otcost = otmins * Convert.ToDouble((otRateSetting.ExemptedSalaryIncentive / 60));
}
else
{
if (user.shifting == false)
{
if (user.usePattern == true)
{
if (holiday.IsHoliday(startdatetime.Date))
{
otcost = otmins * (normalRatePerMin * otRateSetting.OTSpecialRate);
}
else
{
otcost = otmins * (normalRatePerMin * otRateSetting.OTNormalRate);
}
}
else
{
if (holiday.IsHoliday(startdatetime.Date) || user.isOfficeWorker && user.currentSpecialOffDay == (int)startdatetime.DayOfWeek)
{
otcost = otmins * (normalRatePerMin * otRateSetting.OTSpecialRate);
}
else
{
otcost = otmins * (normalRatePerMin * otRateSetting.OTNormalRate);
}
}
}
else //For Shifting Hours
{
TimeSpan stime = startdatetime.TimeOfDay;
TimeSpan etime = Convert.ToDateTime(EndTime).TimeOfDay;
TimeSpan cutoff = user.GetMyCutOfTime();
if (user.usePattern == true)
{
if (user.offPattern.Trim() != "")
{
if (stime >= cutoff)
{
if (holiday.IsHoliday(startdatetime.Date))
{
otcost = otmins * (normalRatePerMin * otRateSetting.OTSpecialRate);
}
else
{
otcost = otmins * (normalRatePerMin * otRateSetting.OTNormalRate);
}
}
else
{
if (holiday.IsHoliday(startdatetime.AddDays(-1).Date))
{
otcost = otmins * (normalRatePerMin * otRateSetting.OTSpecialRate);
}
else
{
otcost = otmins * (normalRatePerMin * otRateSetting.OTNormalRate);
}
}
}
}
else
{
if (stime >= cutoff)
{
if (holiday.IsHoliday(startdatetime.Date) || (user.isOfficeWorker && user.currentSpecialOffDay == (int)startdatetime.DayOfWeek))
{
otcost = otmins * (normalRatePerMin * otRateSetting.OTSpecialRate);
}
else
{
otcost = otmins * (normalRatePerMin * otRateSetting.OTNormalRate);
}
}
else
{
if (holiday.IsHoliday(startdatetime.AddDays(-1).Date) || user.isOfficeWorker && user.currentSpecialOffDay == (int)startdatetime.AddDays(-1).DayOfWeek)
{
otcost = otmins * (normalRatePerMin * otRateSetting.OTSpecialRate);
}
else
{
otcost = otmins * (normalRatePerMin * otRateSetting.OTNormalRate);
}
}
}
}
}
normalcost = Math.Round(normalcost, 2, MidpointRounding.AwayFromZero);
otcost = Math.Round(otcost, 2, MidpointRounding.AwayFromZero);
}
#endregion
}
}
protected void gridViewUser_Command(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
GetMyAccessRights();
modalLabelError.Text = "";
modalLabelError.Visible = false;
int index = Convert.ToInt32(e.CommandArgument);
int userid = Convert.ToInt32(((Label)gridViewUser.Rows[index].FindControl("labelUserId")).Text);
User user = new User();
user = user.GetUser(userid);
modalBtnSubmit.Visible = Convert.ToBoolean(myAccessRights.CanUpdate);
modalLabelUserId.Text = userid.ToString();
modalLabelEmployeeNo.Text = user.EmployeeNumber.ToString();
modalLabelFirstName.Text = user.Firstname.Trim();
modalLableLastName.Text = user.Lastname;
modalTxtBoxStartTime.Text = user.startTime;
modalTxtBoxEndTime.Text = user.endTime;
modalTxtBoxSalary.Text = user.currentSalary.ToString();
modalTxtBoxBreakTimeMin.Text = user.currentMinBreak.ToString();
InitializeOffDayDropDown(modalDropDownOffDay,user.currentOffDay.ToString());
InitializeOffDayDropDown(modalDropDownSpecialOffDay, user.currentSpecialOffDay.ToString());
InitializeOffDayDropDown(modalDropDownOptionalOffDay1,user.currentOptOffDay1.ToString());
InitializeOffDayDropDown(modalDropDownOptionalOffDay2,user.currentOptOffDay2.ToString());
InitializeOffDayDropDown(modalDropDownOptionalOffDay3,user.currentOptOffDay3.ToString());
InitializeOffDayDropDown(modalDropDownOptionalOffDay4,user.currentOptOffDay4.ToString());
modalChckBoxNoOTPay.Checked = user.noOTpay;
modalChckBoxOfficeWorker.Checked = user.isOfficeWorker;
if (user.currentRateCreateDate == DateTime.Today)
{
modalTxtBoxStartDate.Text = user.currentRateStartDate.ToString("dd MMM yyyy");
calendarExtenderStartDate.SelectedDate = user.currentRateStartDate;
}
else
{
modalTxtBoxStartDate.Text = DateTime.Today.ToString("dd MMM yyyy");
calendarExtenderStartDate.SelectedDate = DateTime.Today;
}
UserRateSchedule prevUserRateSchedule= new UserRateSchedule();
prevUserRateSchedule = prevUserRateSchedule.GetPreviousUserScheduleRateByUserIdLastUpdateDate(user.Id, DateTime.Today);
if (prevUserRateSchedule != null)
{
calendarExtenderStartDate.StartDate = prevUserRateSchedule.StartDate.AddDays(1);
}
else
{
calendarExtenderStartDate.StartDate = null;
}
modalChckBoxUsePattern.Checked = user.usePattern;
ToggleReqField(user.usePattern);
modalTxtBoxPattern.Text = user.offPattern.Trim();
modalTxtBoxPatternStartDate.Text = user.patternStartDate.ToString("dd MMM yyyy");
calendarExtenderPatternStartDate.SelectedDate = user.patternStartDate;
if (modalChckBoxUsePattern.Checked == true)
{
cpeNormalUse.ClientState = "true";
cpePatternUse.ClientState = "false";
}
else
{
cpePatternUse.ClientState = "true";
cpeNormalUse.ClientState = "false";
}
this.programmaticModalPopup.Show();
}
}
public int GetWorkingDaysInMonth(int userid,DateTime curdate)
{
User user = new User();
user = user.GetUser(userid, curdate);
int days = DateTime.DaysInMonth(curdate.Year, curdate.Month);
DateTime firstDay = Convert.ToDateTime("01 "+curdate.ToString("MMM")+" "+curdate.ToString("yyyy")+" 00:00:00");
DateTime lastDay = Convert.ToDateTime(days + " " + curdate.ToString("MMM") + " " + curdate.ToString("yyyy") + " 23:00:00");
TimeTrackerEntities db = new TimeTrackerEntities();
var data = (from d in db.T_Holiday
where d.HolidayDate >= firstDay
&& d.HolidayDate <= lastDay
select new Holiday()
{
Id = d.Id,
HolidayYear = d.HolidayYear,
HolidayDate = d.HolidayDate,
Description = d.Description,
}).ToList();
db.Dispose();
int offdays = 0;
int specialdays = 0;
int optionaloffday1 = 0;
int optionaloffday2 = 0;
int optionaloffday3 = 0;
int optionaloffday4 = 0;
int count = days/7;
int remainder = days % 7;
if (user.currentOffDay != 0)
{
offdays = count;
int sincelastday = (int)(lastDay.DayOfWeek - user.currentOffDay);
if (sincelastday < 0) sincelastday += 7;
if (remainder >= sincelastday)
offdays++;
}
if (user.currentSpecialOffDay != 0)
{
specialdays = count;
int sincelastday = (int)(lastDay.DayOfWeek - user.currentOffDay);
if (sincelastday < 0) sincelastday += 7;
if (remainder >= sincelastday)
specialdays++;
}
if (user.currentOffDay != 0)
{
optionaloffday1 = count;
int sincelastday = (int)(lastDay.DayOfWeek - user.currentOffDay);
if (sincelastday < 0) sincelastday += 7;
if (remainder >= sincelastday)
optionaloffday1++;
}
if (user.currentOffDay != 0)
{
optionaloffday2 = count;
int sincelastday = (int)(lastDay.DayOfWeek - user.currentOffDay);
if (sincelastday < 0) sincelastday += 7;
if (remainder >= sincelastday)
optionaloffday2++;
}
if (user.currentOffDay != 0)
{
optionaloffday3 = count;
int sincelastday = (int)(lastDay.DayOfWeek - user.currentOffDay);
if (sincelastday < 0) sincelastday += 7;
if (remainder >= sincelastday)
optionaloffday3++;
}
if (user.currentOffDay != 0)
{
optionaloffday4 = count;
int sincelastday = (int)(lastDay.DayOfWeek - user.currentOffDay);
if (sincelastday < 0) sincelastday += 7;
if (remainder >= sincelastday)
optionaloffday4++;
}
days = days - offdays - specialdays - optionaloffday1 - optionaloffday2 - optionaloffday3 - optionaloffday4;
foreach (Holiday d in data)
{
if (d.HolidayDate.Day != user.currentOffDay && d.HolidayDate.Day != user.currentSpecialOffDay)
days--;
}
return days;
}
protected void modalBtnSubmit_Command(object sender, CommandEventArgs e)
{
if (modalLabelError.Visible == true)
this.programmaticModalPopup.Show();
else
{
int userid = Convert.ToInt32(Session["UserId"]);
User user = new User();
if (modalLabelUserId.Text.Trim() != "") //Update
{
user = user.GetUser(Convert.ToInt32(modalLabelUserId.Text));
}
UserRateSchedule userRateSchedule = new UserRateSchedule();
UserRateSchedule prevUserRateSchedule = userRateSchedule.GetPreviousUserScheduleRateByUserIdLastUpdateDate(user.Id, DateTime.Today);
userRateSchedule = userRateSchedule.GetUserScheduleRateByUserIdCreateDate(user.Id, DateTime.Today); //Checks if there is already a schedule date with the same start date
if (userRateSchedule != null)
{
userRateSchedule.StartTime = modalTxtBoxStartTime.Text.Trim();
userRateSchedule.EndTime = modalTxtBoxEndTime.Text.Trim();
userRateSchedule.MonthlySalary = userRateSchedule.EncryptSalary(modalTxtBoxSalary.Text.Trim());
userRateSchedule.OffDay = Convert.ToInt32(modalDropDownOffDay.SelectedItem.Value);
userRateSchedule.SpecialOffDay = Convert.ToInt32(modalDropDownSpecialOffDay.SelectedItem.Value);
userRateSchedule.OptionalOffDay1 = Convert.ToInt32(modalDropDownOptionalOffDay1.SelectedItem.Value);
userRateSchedule.OptionalOffDay2 = Convert.ToInt32(modalDropDownOptionalOffDay2.SelectedItem.Value);
userRateSchedule.OptionalOffDay3 = Convert.ToInt32(modalDropDownOptionalOffDay3.SelectedItem.Value);
userRateSchedule.OptionalOffDay4 = Convert.ToInt32(modalDropDownOptionalOffDay4.SelectedItem.Value);
userRateSchedule.NoOTPay = modalChckBoxNoOTPay.Checked;
userRateSchedule.IsOfficeWorker = modalChckBoxOfficeWorker.Checked;
userRateSchedule.MinsBreak = Convert.ToInt32(modalTxtBoxBreakTimeMin.Text);
userRateSchedule.StartDate = Convert.ToDateTime(modalTxtBoxStartDate.Text.Trim());
userRateSchedule.LastUpdatedDate = DateTime.Today;
userRateSchedule.IsCurrentRate = true;
userRateSchedule.UsePattern = modalChckBoxUsePattern.Checked;
userRateSchedule.OffPattern = modalTxtBoxPattern.Text.Trim();
userRateSchedule.PatternStartDate = Convert.ToDateTime(modalTxtBoxPatternStartDate.Text.Trim());
userRateSchedule.Update(userRateSchedule);
}
else
{
userRateSchedule = new UserRateSchedule();
userRateSchedule.StartTime = modalTxtBoxStartTime.Text.Trim();
userRateSchedule.EndTime = modalTxtBoxEndTime.Text.Trim();
userRateSchedule.UserId = user.Id;
userRateSchedule.MonthlySalary = userRateSchedule.EncryptSalary(modalTxtBoxSalary.Text.Trim());
userRateSchedule.OffDay = Convert.ToInt32(modalDropDownOffDay.SelectedItem.Value);
userRateSchedule.SpecialOffDay = Convert.ToInt32(modalDropDownSpecialOffDay.SelectedItem.Value);
userRateSchedule.OptionalOffDay1 = Convert.ToInt32(modalDropDownOptionalOffDay1.SelectedItem.Value);
userRateSchedule.OptionalOffDay2 = Convert.ToInt32(modalDropDownOptionalOffDay2.SelectedItem.Value);
userRateSchedule.OptionalOffDay3 = Convert.ToInt32(modalDropDownOptionalOffDay3.SelectedItem.Value);
userRateSchedule.OptionalOffDay4 = Convert.ToInt32(modalDropDownOptionalOffDay4.SelectedItem.Value);
userRateSchedule.NoOTPay = modalChckBoxNoOTPay.Checked;
userRateSchedule.IsOfficeWorker = modalChckBoxOfficeWorker.Checked;
userRateSchedule.MinsBreak = Convert.ToInt32(modalTxtBoxBreakTimeMin.Text);
userRateSchedule.StartDate = Convert.ToDateTime(modalTxtBoxStartDate.Text.Trim());
userRateSchedule.IsCurrentRate = true;
userRateSchedule.CreatedDate = DateTime.Today;
userRateSchedule.LastUpdatedDate = DateTime.Today;
userRateSchedule.UsePattern = modalChckBoxUsePattern.Checked;
userRateSchedule.OffPattern = modalTxtBoxPattern.Text.Trim();
userRateSchedule.PatternStartDate = Convert.ToDateTime(modalTxtBoxPatternStartDate.Text.Trim());
userRateSchedule.Insert(userRateSchedule);
}
if (prevUserRateSchedule != null)
{
prevUserRateSchedule.EndDate = Convert.ToDateTime(modalTxtBoxStartDate.Text.Trim()+" 23:59:59");
prevUserRateSchedule.IsCurrentRate = false;
prevUserRateSchedule.LastUpdatedDate = DateTime.Today;
prevUserRateSchedule.Update(prevUserRateSchedule);
}
}
}
protected void InitializeModalDropDownUsers(int userid = 0)
{
User user = new User();
List<User> userlist = new List<User>();
if (userid == 0)
{
if (dropDownListDepartment.SelectedItem.Text == "All")
{
userlist = user.GetActiveUsersWithoutSupervisor();
}
else
{
userlist = user.GetActiveUsersWithoutSupervisor(Convert.ToInt32(dropDownListDepartment.SelectedItem.Value));
}
}
else
{
user = user.GetUser(userid);
userlist.Add(user);
}
modalDropDownUsers.DataSource = userlist;
modalDropDownUsers.DataTextField = "fullname";
modalDropDownUsers.DataValueField = "Id";
modalDropDownUsers.DataBind();
}
//Use to get newly created jobtracker
public JobTracker GetJobTracker(int createdby, int lastupdatedby, DateTime starttime, int jobtypeid, string actionrequest, string status, bool computetime)
{
TimeTrackerEntities db = new TimeTrackerEntities();
var data = (from j in db.T_JobTracker
where j.CreatedBy == createdby
&& j.LastUpdatedBy == lastupdatedby
&& j.StartTime == starttime
&& j.JobTypeId == jobtypeid
&& j.ActionRequest == actionrequest
&& j.Status == status
select new JobTracker()
{
Id = j.Id,
UserId = j.UserId,
StartTime = j.StartTime,
EndTime = j.EndTime,
Description = j.Description,
JobTypeId = j.JobTypeId,
JobIdNumber = j.JobIdNumber,
jobtype = j.M_JobType.Description,
Remarks = j.Remarks,
ApprovedBy = j.ApprovedBy,
CreateDate = j.CreateDate,
LastUpdateDate = j.LastUpdateDate,
CreatedBy = j.CreatedBy,
LastUpdatedBy = j.LastUpdatedBy,
Status = j.Status,
SupervisorRemarks = j.SupervisorRemarks,
ActionRequest = j.ActionRequest,
ScheduleDate = j.ScheduleDate,
SWNo = j.SWNo,
HWNo = j.HWNo,
JobStatus = j.JobStatus,
fullname = j.M_User.Firstname + " " + j.M_User.Lastname,
Customer = j.Customer,
EvalNo = j.EvalNo
}).FirstOrDefault();
db.Dispose();
//if (data.JobIdNumber != null && data.JobIdNumber != "")
//{
// GetCustomer(data);
//}
if (computetime == true)
{
User user = new User();
user = user.GetUser(Convert.ToInt32(data.UserId), Convert.ToDateTime(data.StartTime));
if (data.EndTime != null)
{
TimeSpan stime = Convert.ToDateTime(data.StartTime).TimeOfDay;
TimeSpan etime = Convert.ToDateTime(data.EndTime).TimeOfDay;
double nmins = 0;
double omins = 0;
otcost = 0;
normalcost = 0;
double time = Convert.ToDateTime(data.EndTime).Subtract(Convert.ToDateTime(data.StartTime)).TotalMinutes;
if (user.shifting == false)
{
if (TimeSpan.Parse(user.endTime) <= stime) //entry is OT
{
omins = time;
}
else if ((etime == new TimeSpan(0, 0, 0) ? new TimeSpan(1, 0, 0, 0) : etime) > TimeSpan.Parse(user.endTime)) //entry is from normal time to OT
{
nmins = TimeSpan.Parse(user.endTime).Subtract(stime).TotalMinutes;
omins = (etime == new TimeSpan(0, 0, 0) ? new TimeSpan(1, 0, 0, 0) : etime).Subtract(TimeSpan.Parse(user.endTime)).TotalMinutes;
}
else //entry is within normal time
{
nmins = time;
}
}
else
{
TimeSpan cutoff = user.GetMyCutOfTime();
if (stime >= cutoff)
{
nmins = time;
}
else
{
if (TimeSpan.Parse(user.endTime) <= stime) //entry is OT
{
omins = time;
}
else if ((etime == new TimeSpan(0, 0, 0) ? new TimeSpan(1, 0, 0, 0) : etime) > TimeSpan.Parse(user.endTime))
{
nmins = TimeSpan.Parse(user.endTime).Subtract(stime).TotalMinutes;
omins = (etime == new TimeSpan(0, 0, 0) ? new TimeSpan(1, 0, 0, 0) : etime).Subtract(TimeSpan.Parse(user.endTime)).TotalMinutes;
}
}
}
double hr = Math.Truncate(time / 60);
double min = time % 60;
data.totalhours = hr == 0 && min == 0 ? "0 min" : (hr > 0 ? hr > 1 ? hr + " hrs" : hr + " hr" : "") + (hr > 0 && min > 0 ? ", " : "") + (min > 0 ? min > 1 ? min + " mins" : min + " min" : "");
hr = Math.Truncate(nmins / 60);
min = nmins % 60;
data.normalhours = hr == 0 && min == 0 ? "0 min" : (hr > 0 ? hr > 1 ? hr + " hrs" : hr + " hr" : "") + (hr > 0 && min > 0 ? ", " : "") + (min > 0 ? min > 1 ? min + " mins" : min + " min" : "");
hr = Math.Truncate(omins / 60);
min = omins % 60;
data.othours = hr == 0 && min == 0 ? "0 min" : (hr > 0 ? hr > 1 ? hr + " hrs" : hr + " hr" : "") + (hr > 0 && min > 0 ? ", " : "") + (min > 0 ? min > 1 ? min + " mins" : min + " min" : "");
}
}
return data;
}
protected void modalBtnSubmit_Command(object sender, CommandEventArgs e)
{
//if (modalChkBoxUpdateRate.Checked == true) //Checks if starttime and endtime is in correct format
//{
// TimeSpan starttime = new TimeSpan();
// TimeSpan endtime = new TimeSpan();
// if (TimeSpan.TryParse(modalTxtBoxStartTime.Text, out starttime))
// {
// }
// else
// {
// modalLabelError.Text = "Start Time not in valid format.";
// modalLabelError.Visible = true;
// }
// if (TimeSpan.TryParse(modalTxtBoxEndTime.Text, out endtime))
// {
// }
// else
// {
// modalLabelError.Text = "End Time not in valid format.";
// modalLabelError.Visible = true;
// }
//}
if (modalLabelError.Visible == true)
this.programmaticModalPopup.Show();
else
{
int userid = Convert.ToInt32(Session["UserId"]);
User user = new User();
if (modalLabelUserId.Text.Trim() != "") //Update
{
user = user.GetUser(Convert.ToInt32(modalLabelUserId.Text));
}
user.Firstname = modalTxtBoxFirstname.Text.Trim();
user.Lastname = modalTxtBoxLastname.Text.Trim();
user.RoleId = Convert.ToInt32(modalDropDownRole.SelectedItem.Value);
user.DepartmentId = Convert.ToInt32(modalDropDownDepartment.SelectedItem.Value);
user.Username = modalTxtBoxUsername.Text.Trim();
user.Password = modalTxtBoxPassword.Text.Trim();
user.Email = modalTxtBoxEmail.Text.Trim();
user.Phone = modalTxtBoxPhone.Text.Trim();
user.Fax = modalTxtBoxFax.Text.Trim();
user.Mobile = modalTxtBoxMobile.Text.Trim();
user.LastUpdatedBy = userid;
user.LastUpdateDate = DateTime.Now;
user.EmployeeNumber = Convert.ToInt32(modalTxtBoxEmployeeNo.Text);
user.Status = modalDropDownStatus.SelectedItem.Value;
//user.Shift = modalRadBtnListShift.SelectedItem.Value.Trim();
if (e.CommandArgument.ToString().Trim() == "Add")
{
user.CreateDate = DateTime.Now;
user.CreatedBy = userid;
user.Insert(user);
user = user.GetLastInsertedUser(); //assign newly created user to variable user
}
else if (e.CommandArgument.ToString().Trim() == "Update")
{
user.Update(user);
}
if (modalChkBoxUpdateRate.Checked == true) //User intends to update salary rate
{
UserRateSchedule userRateSchedule = new UserRateSchedule();
userRateSchedule = userRateSchedule.GetUserScheduleRateByUserIdStartDate(user.Id, DateTime.Today); //Checks if there is already a schedule date with the same start date
if (userRateSchedule != null)
{
userRateSchedule.StartTime = modalTxtBoxStartTime.Text.Trim();
userRateSchedule.EndTime = modalTxtBoxEndTime.Text.Trim();
userRateSchedule.OffDay = Convert.ToInt32(modalDropDownOffDay.SelectedItem.Value);
userRateSchedule.SpecialOffDay = Convert.ToInt32(modalDropDownSpecialOffDay.SelectedItem.Value);
userRateSchedule.NoOTPay = modalChckBoxNoOTPay.Checked;
userRateSchedule.Update(userRateSchedule);
userRateSchedule.IsOfficeWorker = modalChckBoxOfficeWorker.Checked;
userRateSchedule.MinsBreak = Convert.ToInt32(modalTxtBoxBreakTimeMin.Text);
}
else
{
userRateSchedule = new UserRateSchedule();
UserRateSchedule prevUserRateSchedule = userRateSchedule.GetPreviousUserScheduleRateByUserIdLastUpdateDate(user.Id, DateTime.Today);
userRateSchedule.StartTime = modalTxtBoxStartTime.Text.Trim();
userRateSchedule.EndTime = modalTxtBoxEndTime.Text.Trim();
userRateSchedule.UserId = user.Id;
userRateSchedule.OffDay = Convert.ToInt32(modalDropDownOffDay.SelectedItem.Value);
userRateSchedule.SpecialOffDay = Convert.ToInt32(modalDropDownSpecialOffDay.SelectedItem.Value);
userRateSchedule.NoOTPay = modalChckBoxNoOTPay.Checked;
userRateSchedule.IsOfficeWorker = modalChckBoxOfficeWorker.Checked;
userRateSchedule.MinsBreak = Convert.ToInt32(modalTxtBoxBreakTimeMin.Text);
userRateSchedule.StartDate = DateTime.Today;
userRateSchedule.IsCurrentRate = true;
if (prevUserRateSchedule != null)
{
prevUserRateSchedule.EndDate = Convert.ToDateTime(DateTime.Today.AddDays(-1).ToString("dd MMM yyyy") + " 23:59:59");
prevUserRateSchedule.IsCurrentRate = false;
prevUserRateSchedule.Update(prevUserRateSchedule);
}
userRateSchedule.Insert(userRateSchedule);
}
}
InitializeGridUser();
this.programmaticModalPopup.Hide();
}
}
private void RunBreakButtonActionForShifting()
{
int userid = Convert.ToInt32(Session["UserId"]);
JobType jobtype = new JobType();
jobtype = jobtype.GetDefaultBreak();
DateTime selectedDate = DateTime.Parse(txtBoxDate.Text);
JobTracker jobtracker = new JobTracker();
int jobtrackid = 0;
bool noError = true;
User user = new User();
user = user.GetUser(userid, selectedDate);
TimeSpan cutOffTime = user.GetMyCutOfTime();
if (BtnBreak.Text == "Take a break")
{
DateTime startTime = new DateTime();
if (gridJobTrack.Rows.Count > 0)
{
jobtrackid = Convert.ToInt32(((Label)gridJobTrack.Rows[gridJobTrack.Rows.Count - 1].FindControl("labelJobTrackId")).Text);
jobtracker = jobtracker.GetJobTracker(jobtrackid, false);
JobType jtype = jobtype.GetJobType(Convert.ToInt32(jobtracker.JobTypeId));
if (Convert.ToDateTime(jobtracker.StartTime).TimeOfDay < cutOffTime && DateTime.Now.TimeOfDay >= cutOffTime)
{
if (jobtracker.EndTime == null)
{
noError = false;
TimeSetting tsetting = new TimeSetting();
tsetting = tsetting.GetTimeSetting();
panelAlertHeader2.CssClass = "modalAlertHeader";
alertModalBtnOK2.CssClass = "buttonalert";
labelAlertHeader2.Text = "Error";
labelAlertMessage2.Text = "Please close all task first.";
}
else
{
GenerateStartHour();
GenerateStartMin(Convert.ToInt32(modalDropDownStartTimeHour.SelectedItem.Value));
startTime = DateTime.Parse(selectedDate.Year + "-" + selectedDate.Month + "-" + selectedDate.Day + " " + modalDropDownStartTimeHour.SelectedValue + ":" + modalDropDownStartTimeMin.SelectedValue + ":00");
}
}
else
{
if (jobtracker.EndTime == null)
{
DateTime stime = Convert.ToDateTime(jobtracker.StartTime);
GenerateEndHour(stime.Hour, stime.Minute, true);
GenerateEndMin(stime.Hour, stime.Minute, "--");
modalDropDownEndTimeHour.SelectedIndex = (modalDropDownEndTimeHour.Items.Count - 1);
GenerateEndMin(stime.Hour, stime.Minute, modalDropDownEndTimeHour.SelectedItem.Text.Trim(), modalDropDownEndTimeMin.Items.Count == 0 ? "" : modalDropDownEndTimeHour.Items[modalDropDownEndTimeHour.Items.Count - 1].Text.Trim() + ":" + modalDropDownEndTimeMin.SelectedItem.Text.Trim());
if (modalDropDownEndTimeHour.Items[modalDropDownEndTimeHour.Items.Count - 1].Text != "--")
{
if (modalDropDownEndTimeHour.SelectedValue == "24") //end date selected is 12:00 AM next day
{
jobtracker.EndTime = DateTime.Parse((selectedDate.AddDays(1)).Year + "-" + (selectedDate.AddDays(1)).Month + "-" + (selectedDate.AddDays(1)).Day + " 00:00:00");
}
else
{
jobtracker.EndTime = DateTime.Parse(selectedDate.Year + "-" + selectedDate.Month + "-" + selectedDate.Day + " " + modalDropDownEndTimeHour.Items[modalDropDownEndTimeHour.Items.Count - 1].Value + ":" + modalDropDownEndTimeMin.Items[modalDropDownEndTimeMin.Items.Count - 1].Value + ":00");
}
jobtracker.Status = "Approved";
jobtracker.ApprovedBy = userid;
jobtracker.ActionRequest = "Update";
jobtracker.Update(jobtracker);
startTime = Convert.ToDateTime(jobtracker.EndTime);
InitializeGrid();
}
else
{
noError = false;
TimeSetting tsetting = new TimeSetting();
tsetting = tsetting.GetTimeSetting();
panelAlertHeader2.CssClass = "modalAlertHeader";
alertModalBtnOK2.CssClass = "buttonalert";
labelAlertHeader2.Text = "Error";
labelAlertMessage2.Text = "Cannot take a break without spending at least " + tsetting + " minutes on the last task.";
}
}
else
{
startTime = Convert.ToDateTime(jobtracker.EndTime);
}
}
}
else
{
GenerateStartHour();
GenerateStartMin(Convert.ToInt32(modalDropDownStartTimeHour.SelectedItem.Value));
startTime = DateTime.Parse(selectedDate.Year + "-" + selectedDate.Month + "-" + selectedDate.Day + " " + modalDropDownStartTimeHour.SelectedValue + ":" + modalDropDownStartTimeMin.SelectedValue + ":00");
}
if (noError)
{
jobtracker = new JobTracker();
jobtracker.StartTime = startTime;
jobtracker.Status = "Pending";
jobtracker.JobStatus = "";
jobtracker.ApprovedBy = userid;
jobtracker.ActionRequest = "Add";
jobtracker.UserId = userid;
jobtracker.CreateDate = DateTime.Now;
jobtracker.CreatedBy = userid;
jobtracker.LastUpdateDate = DateTime.Now;
jobtracker.LastUpdatedBy = userid;
jobtracker.Description = jobtype.Description;
jobtracker.JobTypeId = jobtype.Id;
jobtracker.ScheduleDate = selectedDate;
jobtracker.Remarks = "";
jobtracker.Insert(jobtracker);
InitializeGrid();
}
else
{
programmaticAlertModalPopup2.Show();
}
}
else if (BtnBreak.Text == "End break")
{
jobtrackid = Convert.ToInt32(((Label)gridJobTrack.Rows[gridJobTrack.Rows.Count - 1].FindControl("labelJobTrackId")).Text);
jobtracker = jobtracker.GetJobTracker(jobtrackid, false);
jobtracker.LastUpdateDate = DateTime.Now;
jobtracker.LastUpdatedBy = userid;
if (jobtracker.JobTypeId == jobtype.Id)
{
DateTime stime = Convert.ToDateTime(jobtracker.StartTime);
GenerateEndHour(stime.Hour, stime.Minute, true);
GenerateEndMin(stime.Hour, stime.Minute, "--");
modalDropDownEndTimeHour.SelectedIndex = (modalDropDownEndTimeHour.Items.Count - 1);
GenerateEndMin(stime.Hour, stime.Minute, modalDropDownEndTimeHour.SelectedItem.Text.Trim(), modalDropDownEndTimeMin.Items.Count == 0 ? "" : modalDropDownEndTimeHour.Items[modalDropDownEndTimeHour.Items.Count - 1].Text.Trim() + ":" + modalDropDownEndTimeMin.SelectedItem.Text.Trim());
if (modalDropDownEndTimeHour.Items[modalDropDownEndTimeHour.Items.Count - 1].Text != "--")
{
if (modalDropDownEndTimeHour.SelectedValue == "24") //end date selected is 12:00 AM next day
{
jobtracker.EndTime = DateTime.Parse((selectedDate.AddDays(1)).Year + "-" + (selectedDate.AddDays(1)).Month + "-" + (selectedDate.AddDays(1)).Day + " 00:00:00");
}
else
{
jobtracker.EndTime = DateTime.Parse(selectedDate.Year + "-" + selectedDate.Month + "-" + selectedDate.Day + " " + modalDropDownEndTimeHour.Items[modalDropDownEndTimeHour.Items.Count - 1].Value + ":" + modalDropDownEndTimeMin.Items[modalDropDownEndTimeMin.Items.Count - 1].Value + ":00");
}
jobtracker.Status = "Approved";
jobtracker.ApprovedBy = userid;
jobtracker.ActionRequest = "Update";
jobtracker.Update(jobtracker);
InitializeGrid();
}
else//delete break if start time and end time are the same
{
jobtracker.Delete(jobtracker.Id);
InitializeGrid();
}
}
if (gridJobTrack.Rows.Count > 1) // continue the last created job
{
for (int i = gridJobTrack.Rows.Count - 1; i >= 0; i--)
{
jobtrackid = Convert.ToInt32(((Label)gridJobTrack.Rows[i].FindControl("labelJobTrackId")).Text);
JobTracker jtracker = jobtracker.GetJobTracker(jobtrackid, false);
JobType jtype = jobtype.GetJobType(Convert.ToInt32(jtracker.JobTypeId));
if (jtype.ComputeTime == true)
{
jtracker.StartTime = jobtracker.EndTime;
jtracker.UserId = userid;
jtracker.CreateDate = DateTime.Now;
jtracker.CreatedBy = userid;
jtracker.LastUpdateDate = DateTime.Now;
jtracker.LastUpdatedBy = userid;
jtracker.EndTime = null;
jtracker.ActionRequest = "Add";
jtracker.Status = "Approved";
if(Convert.ToDateTime(jobtracker.EndTime).TimeOfDay != new TimeSpan(0,0,0)) //only insert if endtime is not equal to 24:00 (next day)
jtracker.Insert(jtracker);
InitializeGrid();
break;
}
}
}
}
}
protected void modalUserlinkBtnSubmit_Command(object sender, CommandEventArgs e)
{
bool haserror = false;
int userid = Convert.ToInt32(Session["UserId"]);
User user = new User();
user = user.GetUser(userid);
if (modalUserlinkChkBoxUpdate.Checked == true)
{
if (modalUserlinkTxtBoxOldPassword.Text.Trim() != user.Password.Trim())
{
modalUserlinkLabelError.Text = "Invalid Old Password.";
modalUserlinkLabelError.Visible = true;
haserror = true;
}
else if (modalUserlinkTxtBoxPassword.Text.Trim() != modalUserlinkTxtBoxRetypePassword.Text.Trim())
{
modalUserlinkLabelError.Text = "New password and retype-password does not match.";
modalUserlinkLabelError.Visible = true;
haserror = true;
}
if (haserror == false)
{
user.Username = modalUserlinkTxtBoxUsername.Text.Trim();
user.Password = modalUserlinkTxtBoxPassword.Text.Trim();
}
}
if (haserror == false)
{
user.Firstname = modalUserlinkTxtBoxFirstname.Text.Trim();
user.Lastname = modalUserlinkTxtBoxLastname.Text.Trim();
user.Email = modalUserlinkTxtBoxEmail.Text.Trim();
user.Phone = modalUserlinkTxtBoxPhone.Text.Trim();
user.Fax = modalUserlinkTxtBoxFax.Text.Trim();
user.Mobile = modalUserlinkTxtBoxMobile.Text.Trim();
user.LastUpdatedBy = userid;
user.LastUpdateDate = DateTime.Now;
user.Update(user);
}
else
{
this.programmaticUserlinkModalPopup.Show();
}
}
private bool IsValidUserName(string username)
{
int userid = Convert.ToInt32(Session["UserId"]);
bool result = true;
User user = new User();
user = user.GetUser(username);
if (user != null)
{
var curUser = user.GetUser(userid);
if (curUser.Username != user.Username)
result = false;
}
return result;
}
public List<Analysis> GetAnalysis(DateTime startdate, DateTime enddate,int userid,string stringjobid,string customer)
{
List<Analysis> data = new List<Analysis>();
JobTracker jobtracker = new JobTracker();
List<JobTracker> joblist = new List<JobTracker>();
JobTypeDepartment jobtypeDepartment = new JobTypeDepartment();
List<JobType> jobtypelist = new List<JobType>();
User user = new User();
user = user.GetUser(userid);
int departmentid = Convert.ToInt32(user.DepartmentId);
jobtypelist = jobtypeDepartment.GetJobTypeList(departmentid);
for (int i = 0; i < jobtypelist.Count; i++)
{
Analysis newAnalysis = new Analysis();
newAnalysis.jobtype = jobtypelist[i].Description;
newAnalysis.jobtypeid = jobtypelist[i].Id.ToString();
newAnalysis.totalworktime = jobtracker.GetTotalHours(jobtypelist[i].Id, userid, startdate, enddate, "Approved", departmentid, stringjobid,customer);
newAnalysis.totalforapproval = jobtracker.GetTotalHours(jobtypelist[i].Id, userid, startdate, enddate, "For Approval", departmentid, stringjobid,customer);
newAnalysis.totaljobTime = "";
if (stringjobid.Trim() != "" || customer.Trim() != "")
{
newAnalysis.totaljobTime = jobtracker.GetTotalHours(jobtypelist[i].Id, Convert.ToDateTime("1900-01-01"), DateTime.Now, "Approved", departmentid, stringjobid, customer);
}
//newAnalysis.totalrejectedtime = jobtracker.GetTotalHours(jobtypelist[i].Id, userid, startdate, enddate, "Rejected", departmentid, stringjobid,customer);
//newAnalysis.totalunclosedjobs = jobtracker.GetTotalUnclosedJobs(jobtypelist[i].Id, userid, startdate, enddate, "Pending", departmentid, stringjobid).ToString();
data.Add(newAnalysis);
}
return data;
}
protected void Page_Load(object sender, EventArgs e)
{
string selectedTab = "";
if (HttpContext.Current.Session["UserId"] == null || HttpContext.Current.Session["UserId"].ToString() == "0")
{
linkBtnUserName.Visible = false;
}
else
{
User user = new User();
user = user.GetUser(Convert.ToInt32(HttpContext.Current.Session["UserId"]));
linkBtnUserName.Text = "Welcome " + user.Firstname + " " + user.Lastname;
linkBtnUserName.Text += " | ";
linkBtnUserName.Visible = true;
InitializeRepError();
}
Setup.Visible = hasAccess("Setup");
Settings.Visible = hasAccess("Settings");
Report.Visible = hasAccess("Report");
//if (modalUserlinkChkBoxUpdate.Checked == false)
//{
// ToggleReqField(false);
// cpeUserlink.ClientState = "true"; //Collapse
//}
//else
//{
// ToggleReqField(true);
// cpeUserlink.ClientState = "false"; //Expand
//}
if (HttpContext.Current.Session["selectedTab"] != null)
{
selectedTab = HttpContext.Current.Session["selectedTab"].ToString();
}
if (HttpContext.Current.Session["siteSubHeader"] != null)
{
subHeader.Text = HttpContext.Current.Session["siteSubHeader"].ToString();
}
SetSelectedNavLink(selectedTab);
}
private bool HasTimeClockGap(int userid, DateTime selecteddate)
{
//Checks if the user has a gap between his facetime time and the time key in, in jobtrack
bool result = false;
User user = new User();
user = user.GetUser(userid,selecteddate);
if (user.EmployeeNumber != 0)
{
if (TimeSpan.Parse(user.startTime) > TimeSpan.Parse(user.endTime)) //user with shifting hour
{
TimeClock timeclock1 = new TimeClock();
TimeClock timeclock2 = new TimeClock();
TimeSpan cutOffTime = user.GetMyCutOfTime();
timeclock2 = timeclock2.GetStartEndTimeForShifting(Convert.ToInt32(user.EmployeeNumber), Convert.ToDateTime(selecteddate.AddDays(-1).ToString("yyyy-MM-dd") + " " + cutOffTime.ToString("hh\\:mm\\:ss")), Convert.ToDateTime(selecteddate.ToString("yyyy-MM-dd") + " " + cutOffTime.ToString("hh\\:mm\\:ss")), false);
if (timeclock2 != null)
{
var data = GetJobTrackerListWithEndTimeAndNotRejected(userid, Convert.ToDateTime(selecteddate.ToString("yyyy-MM-dd") + " 00:00:00"), Convert.ToDateTime(selecteddate.ToString("yyyy-MM-dd") + " " + cutOffTime.ToString("hh\\:mm\\:ss")));
if (data.Count > 0)
{
if (timeclock2.starttime < Convert.ToDateTime(data[0].StartTime))
result = true;
if ((timeclock2.endtime.TimeOfDay < new TimeSpan(0,30,0) ? timeclock1.endtime : timeclock2.endtime.AddMinutes(-30)) > Convert.ToDateTime(data[data.Count - 1].EndTime))
result = true;
}
else
{
result = true;
}
}
if (result == false)
{
timeclock1 = timeclock1.GetStartEndTimeForShifting(Convert.ToInt32(user.EmployeeNumber), Convert.ToDateTime(selecteddate.ToString("yyyy-MM-dd") + " " + cutOffTime.ToString("hh\\:mm\\:ss")), Convert.ToDateTime(selecteddate.AddDays(1).ToString("yyyy-MM-dd") + " " + cutOffTime.ToString("hh\\:mm\\:ss")), true);
if (timeclock1 != null)
{
var data = GetJobTrackerListWithEndTimeAndNotRejected(userid, Convert.ToDateTime(selecteddate.ToString("yyyy-MM-dd") + " " + cutOffTime.ToString("hh\\:mm\\:ss")), Convert.ToDateTime(selecteddate.AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00"));
if (data.Count > 0)
{
if (timeclock1.starttime.AddMinutes(30) < Convert.ToDateTime(data[0].StartTime))
result = true;
if ((timeclock1.endtime.TimeOfDay < new TimeSpan(0, 30, 0) ? timeclock1.endtime : timeclock1.endtime.AddMinutes(-30)) > Convert.ToDateTime(data[data.Count - 1].EndTime))
result = true;
}
else
{
result = true;
}
}
}
}
else
{
TimeClock timeclock = new TimeClock();
timeclock = timeclock.GetStartEndTime(Convert.ToInt32(user.EmployeeNumber), Convert.ToDateTime(selecteddate.ToString("dd MMM yyyy") + " 00:00:00"), Convert.ToDateTime(selecteddate.ToString("dd MMM yyyy") + " 23:59:59"));
if (timeclock != null)
{
var data = GetJobTrackerListWithEndTimeAndNotRejected(userid,selecteddate);
if (data.Count > 0)
{
//TimeSetting timesetting = new TimeSetting();
//timesetting = timesetting.GetTimeSetting();
//if (timeclock.starttime.AddMinutes(timesetting.Interval) < Convert.ToDateTime(data[0].StartTime))
if (timeclock.starttime.AddMinutes(30) < Convert.ToDateTime(data[0].StartTime))
result = true;
//if (timeclock.endtime.AddMinutes(-1 * timesetting.Interval) > Convert.ToDateTime(data[data.Count - 1].EndTime))
if (timeclock.endtime.AddMinutes(-30) > Convert.ToDateTime(data[data.Count - 1].EndTime))
result = true;
}
else
{
result = true;
}
}
}
}
return result;
}
private void GenerateEndHour(int shour, int smin,bool addBlank, string selectedTime = "")
{
DateTime selectedDate = DateTime.Parse(txtBoxDate.Text);
bool isCurrentDate = false;
int userid = Convert.ToInt32(Session["UserId"]);
JobTracker jobtracker = new JobTracker();
TimeSetting timeSetting = new TimeSetting();
timeSetting = timeSetting.GetTimeSetting();
TimeSpan selTime = new TimeSpan(shour, smin, 0);
User user = new User();
user = user.GetUser(userid, selectedDate);
TimeSpan cutOffTime = user.GetMyCutOfTime();
List<TimeSpan> availableTime = new List<TimeSpan>();
for (int i = shour; i < 25; i++)
{
if (i != 24)
{
for (int j = 0; j < 60; j += timeSetting.Interval)
{
if (selTime < cutOffTime)
{
if (new TimeSpan(i, j, 0) <= cutOffTime)
{
availableTime.Add(new TimeSpan(i, j, 0));
}
else
{
break;
}
}
else
{
availableTime.Add(new TimeSpan(i, j, 0));
}
}
}
else //adding 24:00
{
if (selTime < cutOffTime)
{
if (new TimeSpan(i, 0, 0) <= cutOffTime)
{
availableTime.Add(new TimeSpan(i, 0, 0));
}
}
else
{
availableTime.Add(new TimeSpan(i, 0, 0));
}
}
}
if (selectedDate.CompareTo(DateTime.Today) == 0)
{
isCurrentDate = true;
}
Dictionary<string, string> hours = new Dictionary<string, string>();
jobtracker = jobtracker.GetNextUsedTime(userid, DateTime.Parse(selectedDate.Year + "-" + selectedDate.Month + "-" + selectedDate.Day + " " + selTime.ToString()), selectedDate);
TimeSpan stime = jobtracker == null ? new TimeSpan(24,0,0) : Convert.ToDateTime(jobtracker.StartTime).TimeOfDay;
if (Session["StartTime"] != null)
{
TimeSpan ts = TimeSpan.Parse(Session["StartTime"].ToString());
if (ts == stime)
{
jobtracker = jobtracker.GetNextUsedTime(userid, DateTime.Parse(selectedDate.Year + "-" + selectedDate.Month + "-" + selectedDate.Day + " " + Session["StartTime"].ToString()), selectedDate);
stime = jobtracker == null ? new TimeSpan(24, 0, 0) : Convert.ToDateTime(jobtracker.StartTime).TimeOfDay;
}
}
for (int j = 0; j < availableTime.Count; j++)
{
if (availableTime[j] > stime)
{
availableTime.RemoveAt(j);
--j;
}
else if (isCurrentDate == true && DateTime.Now.TimeOfDay < availableTime[j])
{
availableTime.RemoveAt(j);
--j;
}
else if (selTime >= availableTime[j])
{
availableTime.RemoveAt(j);
--j;
}
}
int curtime = 24;
if (addBlank == true)
{
hours.Add("--", "00");
}
for (int i = 0; i < availableTime.Count; i++)
{
if (curtime != Convert.ToInt32(Math.Floor(availableTime[i].TotalHours)))
{
curtime = Convert.ToInt32(Math.Floor(availableTime[i].TotalHours));
hours.Add(curtime > 9 ? curtime.ToString() : "0" + curtime.ToString(), curtime > 9 ? curtime.ToString() : "0" + curtime.ToString());
}
}
modalDropDownEndTimeHour.DataSource = hours;
modalDropDownEndTimeHour.DataTextField = "Key";
modalDropDownEndTimeHour.DataValueField = "Value";
modalDropDownEndTimeHour.DataBind();
if (selectedTime.Trim() != "")
{
string seletime = "";
if (selectedTime.Length > 10)
{
DateTime selEndDate = Convert.ToDateTime(selectedTime);
if (selectedDate.Date < selEndDate.Date)
seletime = "24:00:00";
else
seletime = selEndDate.TimeOfDay.ToString();
}
else
{
seletime = selectedTime;
}
string[] s = seletime.Split(':');
foreach (ListItem i in modalDropDownEndTimeHour.Items)
{
if (i.Text.Trim() == s[0].Trim())
i.Selected = true;
}
}
}
private bool HasTimeGap(int userid, DateTime selecteddate)
{
bool result = false;
var data = GetJobTrackerListWithEndTimeAndNotRejected(userid, selecteddate);
User user = new User();
user = user.GetUser(userid,selecteddate);
if (TimeSpan.Parse(user.startTime) > TimeSpan.Parse(user.endTime)) //for shifting hours check two time (12 midnight - cutofftime and cutooftime to 12 midnight)
{
int loop = 0;
TimeSpan cutOfTime = user.GetMyCutOfTime();
DateTime stime1 = new DateTime();
stime1 = DateTime.Parse(selecteddate.Year + "-" + selecteddate.Month + "-" + selecteddate.Day + " 00:00:00");
DateTime stime2 = new DateTime();
for (int i = 0; i < data.Count; i++)
{
if (Convert.ToDateTime(data[i].StartTime).TimeOfDay < cutOfTime)
{
if (stime1 != data[i].StartTime)
{
result = true;
break;
}
else
{
stime1 = Convert.ToDateTime(data[i].EndTime);
}
}
else
{
if (loop == 0)
{
stime2 = Convert.ToDateTime(data[i].EndTime);
}
else if (stime2 != data[i].StartTime)
{
result = true;
break;
}
else
{
stime2 = Convert.ToDateTime(data[i].EndTime);
}
}
}
}
else
{
DateTime sTime = new DateTime();
for (int i = 0; i < data.Count; i++)
{
if (i == 0)
{
sTime = Convert.ToDateTime(data[i].EndTime);
}
else if (sTime != data[i].StartTime)
{
result = true;
break;
}
else
{
sTime = Convert.ToDateTime(data[i].EndTime);
}
}
}
return result;
}
protected void InitializeBottomDropDownDepartment()
{
ddlBottomDepartment.Enabled = true;
int roleid = Convert.ToInt32(Session["RoleId"]);
RoleDepartmentAccess departmentAccess = new RoleDepartmentAccess();
var departmentlist = departmentAccess.GetRoleDepartmentList(roleid);
if (departmentlist.Count > 1)
{
departmentAccess.DepartmentId = 0;
departmentAccess.department = "All";
departmentlist.Insert(0, departmentAccess);
}
else if (departmentlist.Count < 1)
{
int userid = Convert.ToInt32(Session["UserId"]);
Department department = new Department();
User user = new User();
user = user.GetUser(userid);
department = department.GetDepartment(Convert.ToInt32(user.DepartmentId));
departmentAccess.DepartmentId = department.Id;
departmentAccess.department = department.Description;
departmentlist.Insert(0, departmentAccess);
ddlBottomDepartment.Enabled = false;
}
ddlBottomDepartment.DataSource = departmentlist;
ddlBottomDepartment.DataTextField = "department";
ddlBottomDepartment.DataValueField = "DepartmentId";
ddlBottomDepartment.DataBind();
}
private void GenerateEndMin(int shour, int smin,string ehour,string selectedTime = "")
{
Dictionary<string, string> mins = new Dictionary<string, string>();
if (modalDropDownEndTimeHour.SelectedItem.Text.Trim() == "--")
{
mins.Add("--", "00");
}
if (ehour != "--")
{
DateTime selectedDate = DateTime.Parse(txtBoxDate.Text);
int userid = Convert.ToInt32(Session["UserId"]);
bool isCurrentDate = false;
int hour = Convert.ToInt32(ehour);
JobTracker jobtracker = new JobTracker();
TimeSetting timeSetting = new TimeSetting();
timeSetting = timeSetting.GetTimeSetting();
TimeSpan selTime = new TimeSpan(shour, smin, 0);
List<TimeSpan> availableTime = new List<TimeSpan>();
User user = new User();
user = user.GetUser(userid, selectedDate);
TimeSpan cutOffTime = user.GetMyCutOfTime();
if (hour != 24)
{
for (int j = 0; j < 60; j += timeSetting.Interval)
{
if (selTime < cutOffTime)
{
if (new TimeSpan(hour, j, 0) <= cutOffTime)
{
availableTime.Add(new TimeSpan(hour, j, 0));
}
else
{
break;
}
}
else
{
availableTime.Add(new TimeSpan(hour, j, 0));
}
}
}
else
{
if (selTime < cutOffTime)
{
if (new TimeSpan(hour, 0, 0) <= cutOffTime)
{
availableTime.Add(new TimeSpan(hour, 0, 0));
}
}
else
{
availableTime.Add(new TimeSpan(hour, 0, 0));
}
}
if (selectedDate.CompareTo(DateTime.Today) == 0)
{
isCurrentDate = true;
}
jobtracker = jobtracker.GetNextUsedTime(userid, DateTime.Parse(selectedDate.Year + "-" + selectedDate.Month + "-" + selectedDate.Day + " " + selTime.ToString()), selectedDate);
TimeSpan stime = jobtracker == null ? new TimeSpan(23, 59, 59) : Convert.ToDateTime(jobtracker.StartTime).TimeOfDay;
if (Session["StartTime"] != null)
{
TimeSpan ts = TimeSpan.Parse(Session["StartTime"].ToString());
if (ts == stime)
{
jobtracker = jobtracker.GetNextUsedTime(userid, DateTime.Parse(selectedDate.Year + "-" + selectedDate.Month + "-" + selectedDate.Day + " " + Session["StartTime"].ToString()), selectedDate);
stime = jobtracker == null ? new TimeSpan(23, 59, 59) : Convert.ToDateTime(jobtracker.StartTime).TimeOfDay;
}
}
for (int j = 0; j < availableTime.Count; j++)
{
if (availableTime[j] > stime)
{
availableTime.RemoveAt(j);
--j;
}
else if (isCurrentDate == true && DateTime.Now.TimeOfDay < availableTime[j])
{
availableTime.RemoveAt(j);
--j;
}
else if (selTime >= availableTime[j])
{
availableTime.RemoveAt(j);
--j;
}
}
int curtime = 60;
for (int i = 0; i < availableTime.Count; i++)
{
if (curtime != availableTime[i].Minutes)
{
curtime = availableTime[i].Minutes;
mins.Add(curtime > 9 ? curtime.ToString() : "0" + curtime.ToString(), curtime > 9 ? curtime.ToString() : "0" + curtime.ToString());
}
}
}
modalDropDownEndTimeMin.DataSource = mins;
modalDropDownEndTimeMin.DataTextField = "Key";
modalDropDownEndTimeMin.DataValueField = "Value";
modalDropDownEndTimeMin.DataBind();
if (selectedTime.Trim() != "")
{
string[] s = selectedTime.Split(':');
foreach (ListItem i in modalDropDownEndTimeMin.Items)
{
if (i.Text.Trim() == s[1].Trim())
i.Selected = true;
}
}
}
protected void InitializeBottomDropDownPersonel()
{
int userid = Convert.ToInt32(Session["UserId"]);
int roleid = Convert.ToInt32(Session["RoleId"]);
RoleDepartmentAccess departmentAccess = new RoleDepartmentAccess();
var departmentlist = departmentAccess.GetRoleDepartmentList(roleid);
User user = new User();
List<User> userlist = new List<User>();
user = user.GetUser(userid);
if (departmentlist.Count < 1)
{
userlist.Add(user);
ddlBottomPersonel.Enabled = false;
}
else
{
int departmentid = Convert.ToInt32(ddlBottomDepartment.SelectedItem.Value);
if (departmentid == 0)
{
foreach (RoleDepartmentAccess r in departmentlist)
{
var ulist = user.GetUserList(r.DepartmentId);
userlist.AddRange(ulist);
}
userlist = userlist.Distinct().ToList();
}
else
{
userlist = user.GetUserList(departmentid);
}
if (userlist.Count > 1)
{
User alluser = new User();
alluser.fullname = "All";
alluser.Id = 0;
userlist.Insert(0, alluser);
}
ddlBottomPersonel.Enabled = true;
}
ddlBottomPersonel.DataSource = userlist;
ddlBottomPersonel.DataTextField = "fullname";
ddlBottomPersonel.DataValueField = "Id";
ddlBottomPersonel.DataBind();
}
private bool IsValidUserName(string username)
{
int userid = 0;
if (modalLabelUserId.Text.Trim() != "")
userid = Convert.ToInt32(modalLabelUserId.Text);
bool result = true;
User user = new User();
user = user.GetUser(username);
if (user != null)
{
if (userid == 0)
{
result = false;
}
else
{
var curUser = user.GetUser(userid);
if (curUser.Username != user.Username)
result = false;
}
}
return result;
}
protected void GetMyAccessRights()
{
int userid = Convert.ToInt32(Session["UserId"]);
User user = new User();
user = user.GetUser(userid);
TimeTracker.Model.Module module = new TimeTracker.Model.Module();
module = module.GetModule("ReportLaborCost.aspx");
myAccessRights = myAccessRights.GetRolesModuleAccess(Convert.ToInt32(user.RoleId), module.Id);
}