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