protected void Page_Load(object sender, EventArgs e) { noContent.Visible = false; if (HttpContext.Current.User.IsInRole("Department Employee") == true) { string username = HttpContext.Current.User.Identity.Name; employee newemp = new employee(); var q = from emp in se.employees where emp.EmployeeEmail == username select emp; newemp = q.FirstOrDefault(); if(newemp.EmpIsDepRep!=true) { Response.Redirect("/Presentation/Login.aspx"); } } else { Response.Redirect("/Presentation/Login.aspx"); } if (!IsPostBack) { int eid; int.TryParse(Session["userid"].ToString(),out eid); dept = service.getDNameByEid(eid); lblDName.Text = dept.DepName; binding(); } }
public employee GetEmployeeDetailsByEmpID(int searchEmpID) { try { employee currentEmp = new employee(); currentEmp = (from e in se.employees where e.EmployeeID == searchEmpID select e).FirstOrDefault(); return currentEmp; } catch (Exception ex) { throw ex; } }
public void SendDisbEmail() { List<disbursement> disbList=new List<disbursement>(); List<String> emails = new List<string>(); MailMessage mail = new MailMessage(); //disbursement disb = new disbursement(); var q = from d in se.disbursements where d.DisbStatus == "Ready" select d; disbList = q.ToList(); foreach (disbursement disb in disbList) { employee emp = new employee(); List<employee> emps=new List<employee>(); emps = disb.department.employees.ToList(); foreach (employee e in emps) { bool ans = false; ans = e.EmpIsDepRep ?? default(bool); if (ans ==true) { emails.Add(e.EmployeeEmail); } } } var allrecipients = String.Join(",", emails); MailMessage disbmail = new MailMessage(); disbmail.To.Add(allrecipients); disbmail.Subject = "Notifications about Stationery Items Disbursement"; String msgcontent = "The Stationery Items that your Department requested are ready for Delivery, please Login to the Logic University Stationery Management System for more details"; disbmail.Body = msgcontent; disbmail.IsBodyHtml = true; disbmail.From = new MailAddress("*****@*****.**"); SmtpClient sc = new SmtpClient(); sc.Host = "smtp.gmail.com"; sc.Port = 25; sc.Credentials = new System.Net.NetworkCredential("*****@*****.**", "12345678!"); sc.EnableSsl = true; sc.Send(disbmail); }
public employee GetEmployeeDetailsByReqID(int searchReqID) { try { employee currentEmp = new employee(); currentEmp = (from r in se.requisitions join e in se.employees on r.ReqEmpId equals e.EmployeeID where r.ReqID == searchReqID select e).FirstOrDefault(); return currentEmp; } catch (Exception ex) { throw ex; } }
public string getuserempIDofemp(string email) { string empID; List<employee> empl = new List<employee>(); employee emp = new employee(); var q = from e in se.employees where e.EmployeeEmail == email select e; empl = q.ToList(); emp = empl.First(); if (emp.EmpIsDepRep == true) { empID = Convert.ToString(emp.EmployeeID); } else { empID = "false"; } return empID; }
public bool registeremployee(string empName, string empEmail, int empDepId, int roleId, string empContact) { try { employee emp = new employee(); emp.EmpIsDepRep = false; emp.EmployeeContact = Convert.ToInt32(empContact); emp.EmployeeName = empName; emp.EmployeeDepId = empDepId; emp.EmployeeEmail = empEmail; emp.EmployeeRoleID = roleId; erep.saveemployee(emp); return true; } catch (Exception e) { return false; } }
public void LoadAllGridViewWithReqStatus() { String searchStatus = ddlRequisitionList.SelectedValue; int LoginId = Convert.ToInt32(Session["userid"].ToString()); currentEmp = new employee(); currentEmp = _EmployeeService.GetEmployeeDetailsByEmpID(LoginId); if (currentEmp != null) { int curdeptID = currentEmp.EmployeeDepId ?? default(int); if (searchStatus == "All") { LoadAllGridView(curdeptID); } else { requisitionListObj = new List<object>(); requisitionListObj = _RequisitionService.GetRequisitionListByStatus(curdeptID, searchStatus); gvRequisitionList.DataSource = requisitionListObj; gvRequisitionList.DataBind(); } } }
public bool saveemployee(employee emp) { try { se.employees.Add(emp); se.SaveChanges(); return true; } catch (Exception e) { return false; } }
protected void Page_Load(object sender, EventArgs e) { bool isTempHead = false; RegistrationService rser = new RegistrationService(); string userId = HttpContext.Current.User.Identity.Name; isTempHead=rser.IsTempDepHead(userId); if ((HttpContext.Current.User.IsInRole("Department Head") != true) && (isTempHead != true)) { Response.Redirect("/Presentation/Login.aspx"); } _EmployeeService = new EmployeeService(); _DepartmentService = new DepartmentService(); _DelegationService = new DelegationService(); if (!IsPostBack) { #region ** ClearAll ClearNewAllData(); BtnEnable(false); #endregion #region ** DataBind for ddl with DeptID int LoginId = Convert.ToInt32(Session["userid"].ToString()); currentEmp = new employee(); currentEmp = _EmployeeService.GetEmployeeDetailsByEmpID(LoginId); int curdeptID = currentEmp.EmployeeDepId ?? default(int); employeeList = new List<employee>(); employeeList = _EmployeeService.GetEmployeeDetailsByDeptID(curdeptID, LoginId); ddlEmpName.DataSource = employeeList; ddlEmpName.DataBind(); #endregion searchDelegation(); } }
public string getusernameofemp(string email) { string name; List<employee> empl=new List<employee>(); employee emp = new employee(); var q = from e in se.employees where e.EmployeeEmail == email select e; empl = q.ToList(); emp = empl.First(); name = emp.EmployeeName; return name; }
public int getUseridofemp(string email) { int id; List<employee> empl = new List<employee>(); employee emp = new employee(); var q = from e in se.employees where e.EmployeeEmail == email select e; empl = q.ToList(); emp = empl.First(); id = emp.EmployeeID; return id; }
protected void btnSubmit_Click(object sender, EventArgs e) { currentDepartment = new department(); currentEmployee = new employee(); int UserId = Convert.ToInt32(Session["userid"].ToString()); currentEmployee = _EmployeeService.GetEmployeeDetailsByEmpID(UserId); if (currentEmployee!=null) { #region Update Department int DepID = currentEmployee.EmployeeDepId ?? default(int); currentDepartment = _DepartmentService.GetdepartmentDetailsByDeptID(DepID); if (currentDepartment!=null) { #region Make All Dept Rep to be 0 If there is existing employeeList = new List<employee>(); employeeList = _EmployeeService.GetEmployeeDetailsByDeptID(DepID, UserId); foreach (employee emp in employeeList) { _EmployeeService.UpdateEmployeeDetailsTobeDeptRep(emp.EmployeeID, false); } #endregion department toUpdateDept = new department(); toUpdateDept.DepID = currentDepartment.DepID; toUpdateDept.DepName = currentDepartment.DepName; toUpdateDept.DepContactName = txtDeptContactName.Text; toUpdateDept.DepContactNumber = Convert.ToInt32(txtDeptContactNum.Text); toUpdateDept.DepFax = currentDepartment.DepFax; toUpdateDept.DepCollectionPointID = int.Parse(ddlCollectionID.SelectedValue); toUpdateDept.DepHeadName = currentDepartment.DepHeadName; if (PanelDeptRepName.Visible == true) { toUpdateDept.DepRepName = ddlDeptRep.SelectedItem.Text; _EmployeeService.UpdateEmployeeDetailsTobeDeptRep(int.Parse(ddlDeptRep.SelectedValue),true); } else { toUpdateDept.DepRepName = currentDepartment.DepRepName; } _DepartmentService.UpdateDepartment(toUpdateDept); ResetAll(); PanelSubmit.Visible = true; } else { PanelError.Visible = true; } #endregion } else { PanelError.Visible = true; } //int EmpID = int.Parse(ddlDeptRep.SelectedItem.Value); //currentEmployee = new employee(); //currentEmployee = _EmployeeService.GetEmployeeDetailsByEmpID(EmpID); //if (currentEmployee != null) //{ // if (currentEmployee.EmpIsDepRep == false) // { // _EmployeeService.UpdateEmployeeDetailsTobeDeptRep(EmpID, true); // ResetAll(); // PanelSubmit.Visible = true; // } // else // { // PanelSubmit.Visible = true; // } //} //else //{ // PanelError.Visible = true; //} }
protected void Page_Load(object sender, EventArgs e) { bool isTempHead = false; RegistrationService rser = new RegistrationService(); string userId = HttpContext.Current.User.Identity.Name; isTempHead = rser.IsTempDepHead(userId); if ((HttpContext.Current.User.IsInRole("Department Head") != true) && (isTempHead != true)) { Response.Redirect("/Presentation/Login.aspx"); } _EmployeeService = new EmployeeService(); _DepartmentService = new DepartmentService(); if (!IsPostBack) { int i = Convert.ToInt32(Session["userid"].ToString()); currentEmployee = new employee(); currentEmployee = _EmployeeService.GetEmployeeDetailsByEmpID(i); if (currentEmployee!=null) { int DepID = currentEmployee.EmployeeDepId ?? default(int); currentDepartment = new department(); currentDepartment = _DepartmentService.GetdepartmentDetailsByDeptID(DepID); lblDeptName.Text = currentDepartment.DepName; txtDeptContactName.Text = currentDepartment.DepContactName; txtDeptContactNum.Text = currentDepartment.DepContactNumber.ToString(); lblCurrentDeptRep.Text = currentDepartment.DepRepName; } else { PanelError.Visible = true; } int curdeptID = currentEmployee.EmployeeDepId ?? default(int); employeeList = new List<employee>(); employeeList = _EmployeeService.GetEmployeeDetailsByDeptID(curdeptID, i); if (employeeList!=null) { ddlDeptRep.DataSource = employeeList; ddlDeptRep.DataTextField = "EmployeeName"; ddlDeptRep.DataValueField = "EmployeeID"; ddlDeptRep.DataBind(); } else { PanelError.Visible = true; } ddlCollectionID.SelectedValue = currentDepartment.DepCollectionPointID.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (HttpContext.Current.User.IsInRole("Department Employee") == true) { string username = HttpContext.Current.User.Identity.Name; employee newemp = new employee(); var q = from emp in se.employees where emp.EmployeeEmail == username select emp; newemp = q.FirstOrDefault(); if (newemp.EmpIsDepRep != true) { Response.Redirect("/Presentation/Login.aspx"); } } else { Response.Redirect("/Presentation/Login.aspx"); } if (!IsPostBack) { Binding(); } }
public bool searchDelegation() { int LoginId = Convert.ToInt32(Session["userid"].ToString()); currentEmp = new employee(); currentEmp = _EmployeeService.GetEmployeeDetailsByEmpID(LoginId); Currentdelegation = new delegation(); Currentdelegation = _DelegationService.SearchDelegationWithDelgApproveEmpId_Status_Date(LoginId, "approved"); if (Currentdelegation != null) { PanelSubmit.Visible = true; lblDelegated.Text = "You may assign a temporary Department Head."; ddlEmpName.SelectedValue = Currentdelegation.DelgEmpID.ToString(); txtEmpID.Text = Currentdelegation.DelgEmpID.ToString(); currentEmp = new employee(); currentEmp = _EmployeeService.GetEmployeeDetailsByEmpID(Currentdelegation.DelgEmpID); txtEmpContact.Text = currentEmp.EmployeeContact.ToString(); this.FromDate = Currentdelegation.DelgFromDate.ToString("MM/dd/yyyy"); this.ToDate = Currentdelegation.DelgToDate.ToString("MM/dd/yyyy"); BtnEnable(true); return true; } else { BtnEnable(false); return false; } }
//method to check Dep Rep public bool isDepRep(string email) { bool ans = false; List<employee> empl1 = new List<employee>(); employee emp1 = new employee(); var l = from e in se.employees where e.EmployeeEmail == email select e; empl1 = l.ToList(); emp1 = empl1.First(); if (emp1.EmpIsDepRep == true) { ans = true; } else ans = false; return ans; }
protected void Page_Load(object sender, EventArgs e) { if (HttpContext.Current.User.IsInRole("Department Employee") == true) { string username = HttpContext.Current.User.Identity.Name; employee newemp = new employee(); var q = from emp in se.employees where emp.EmployeeEmail == username select emp; newemp = q.FirstOrDefault(); if (newemp.EmpIsDepRep != true) { Response.Redirect("/Presentation/Login.aspx"); } } else { Response.Redirect("/Presentation/Login.aspx"); } if (!IsPostBack) { //ddlSearch.DataTextField = "itemDescription"; //ddlSearch.DataValueField = "itemID"; //itm = requisition.getAllItem(); //ddlSearch.DataSource = itm; //ddlSearch.DataBind(); //gvRequisition.DataSource = items; //gvRequisition.DataBind(); binding(); if (items.Count > 0) { btnComfirm.Visible = true; } else { btnComfirm.Visible = false; } } }
//method to check Dep Head public bool isTempDepHead(string email) { bool ans = false; int id2; delegation delg = new delegation(); List<employee> empl2 = new List<employee>(); employee emp2 = new employee(); var q = from e in se.employees where e.EmployeeEmail == email select e; emp2 = q.FirstOrDefault(); id2 = emp2.EmployeeID; //checking the delegation Table var m = from del in se.delegations where del.DelgEmpID == id2 && del.DelgToDate >= DateTime.Today && del.DelgStatus == "approved" select del; delg = m.FirstOrDefault(); if (delg != null) { ans = true; } else ans = false; return ans; }
protected void Page_Load(object sender, EventArgs e) { bool isTempHead = false; RegistrationService rser = new RegistrationService(); string userId = HttpContext.Current.User.Identity.Name; isTempHead = rser.IsTempDepHead(userId); if ((HttpContext.Current.User.IsInRole("Department Head")!= true) && (isTempHead!=true)) { Response.Redirect("/Presentation/Login.aspx"); } _RequisitionService = new RequisitionService(); _EmployeeService = new EmployeeService(); if (!IsPostBack) { int LoginId = Convert.ToInt32(Session["userid"].ToString()); currentEmp = new employee(); currentEmp = _EmployeeService.GetEmployeeDetailsByEmpID(LoginId); if (currentEmp!=null) { int curdeptID = currentEmp.EmployeeDepId ?? default(int); LoadAllGridView(curdeptID); } } }
protected void EmpName_SelectedIndexChanged(object sender, EventArgs e) { #region ** ClearAll ClearNewAllData(); BtnEnable(false); #endregion #region ** DataBindinEmployeeDetails currentEmp = new employee(); currentEmp = _EmployeeService.GetEmployeeDetailsByEmpID(int.Parse(ddlEmpName.SelectedItem.Value)); if (currentEmp != null) { txtEmpContact.Text = currentEmp.EmployeeContact.ToString(); txtEmpID.Text = ddlEmpName.SelectedItem.Value; } else { PanelError.Visible = true; } #endregion BtnEnable(true); btnResetDelegation.Enabled = false; #region ** CheckDelegationForLoginId int LoginId = Convert.ToInt32(Session["userid"].ToString()); currentEmp = new employee(); currentEmp = _EmployeeService.GetEmployeeDetailsByEmpID(int.Parse(ddlEmpName.SelectedItem.Value)); Currentdelegation = new delegation(); Currentdelegation = _DelegationService.SearchDelegationWithDelgEmpId_ApprovedID_Status_Date(int.Parse(ddlEmpName.SelectedItem.Value), LoginId,"approved"); if (Currentdelegation != null) { PanelSubmit.Visible = true; lblDelegated.Text = "You may assign a temporary Department Head."; ddlEmpName.SelectedValue = Currentdelegation.DelgEmpID.ToString(); txtEmpID.Text = Currentdelegation.DelgEmpID.ToString(); txtEmpContact.Text = currentEmp.EmployeeContact.ToString(); this.FromDate = Currentdelegation.DelgFromDate.ToString("MM/dd/yyyy"); this.ToDate = Currentdelegation.DelgToDate.ToString("MM/dd/yyyy"); btnResetDelegation.Enabled = true; btnSubmitDeligation.Enabled = true; } #endregion }