protected void btnSave_Click(object sender, EventArgs e) { //save/update changed collection point & representative in database int selectColPoint = ddlCollectPoint.SelectedIndex; string repFullName = ddlRepName.SelectedItem.ToString(); if (selectColPoint == 0 || repFullName.Equals("Select---")) { lbDDLError1.Text = "Please select the required field!"; } else { //show Full Name- save username Dept_Registry depReg = context.Dept_Registry.SingleOrDefault(x => x.fullname == repFullName); string repUserName = depReg.username; var result = context.Departments.SingleOrDefault(c => c.name == sdept.name); result.rep_user = repUserName; result.collection_point = selectColPoint; context.SaveChanges(); lbDDLError1.Text = "Sucessfully Save!"; _sendEmail(User.Identity.Name, repUserName); } }
public WCFDepartment GetDeptNamebycode(string deptName) { Department dept1 = context.Departments.Where(x => x.name == deptName).First(); Dept_Registry dr = context.Dept_Registry.Where(x => x.username == dept1.rep_user).First(); WCFDepartment wd = new WCFDepartment(dept1.dept_code, dr.fullname, dept1.contact_num); return(wd); }
private void FillPage() { // need to login if (!User.Identity.IsAuthenticated) { Response.Redirect("~/login.aspx?return=Views/DepartmentHead/HeadDashboard.aspx"); } string username = User.Identity.Name.ToString(); UserModel user = new UserModel(username); string currentDept = user.Department.dept_code; var requestInfo = (from o in context.Requests where (currentDept == o.dept_code) && (o.current_status == RequestStatus.PENDING | o.current_status == RequestStatus.UPDATED) select new { o.request_id, o.username, o.date_time, o.reason }).ToList(); GridView1.DataSource = requestInfo; GridView1.DataBind(); string pendingnum = GridView1.Rows.Count.ToString(); lblPendingNum.Text = "You Have " + pendingnum + " Requests(s) to View"; string currentUser = Page.User.Identity.Name; string fullName = ""; using (SSISEntities context = new SSISEntities()) { fullName = context.Dept_Registry.Find(currentUser).fullname; } lblFullName.Text = "Welcome, " + fullName; Department dept = context.Departments.Where(x => currentDept == x.dept_code).First(); Collection_Point colpoint = context.Collection_Point.Where(y => y.collection_pt_id == dept.collection_point).First(); Dept_Registry dr = context.Dept_Registry.Where(x => x.username == dept.rep_user).First(); lblrep.Text = dr.fullname; lblcolpoint.Text = colpoint.location + " (" + colpoint.day_of_week + " - " + colpoint.date_time.ToShortTimeString() + ")"; var deldept = (from x in context.Approval_Duties select x.dept_code).ToList(); if (deldept.Contains(currentDept)) { List <Approval_Duties> ads = context.Approval_Duties.Where(x => currentDept == x.dept_code).ToList(); foreach (Approval_Duties ad in ads) { DateTime start = ad.start_date; DateTime end = ad.end_date; if ((DateTime.Now > start && DateTime.Now < end) && (ad.deleted == "N")) { lbldelegation.Text = ad.username + " (" + start + " - " + end + ")"; break; } } } }
//public static readonly string[] ROLES = { "DeptHead", "Manager", "Supervisor", "Clerk", "Employee" }; //public enum UserRoles { DeptHead, Manager, Supervisor, Clerk, Employee } public UserModel(string username) { SSISEntities context = new SSISEntities(); Dept_Registry user = context.Dept_Registry.Where(x => x.username.ToLower() == username.ToLower()).ToList().First(); Department dept = context.Departments.Where(x => x.dept_code == user.dept_code).ToList().First(); //Membership.FindUsersByName(username); this.username = user.username; // Cannot enable yet, as members do not exist in asp.net db MembershipUser thisUser = Membership.GetUser(username); this.email = thisUser != null ? thisUser.Email : "sa44ssisteamtwo+" + username + "@gmail.com"; this.department = dept; var roles = Roles.GetRolesForUser(username); if (roles.Count() > 0) { var filteredRoles = ROLES.Where(w => roles.Contains(w)); this.role = filteredRoles.Count() > 0 ? filteredRoles.First() : ROLES.Last(); } else { this.role = "Employee"; } //this.fullname = UserPrincipal.Current.DisplayName; this.fullname = user.fullname; if (user.mobile_no == null) { this.mobilenum = ""; } else { this.mobilenum = user.mobile_no; } }
protected void btnSave_Click(object sender, EventArgs e) { //show FUll Name- save username delegateFullName = ddlEmployee.SelectedItem.ToString(); //Select Dropdown List Validation try { if (delegateFullName.Equals("Select---")) { Label1.Text = "Please Choose One Delegate!"; } else { Label1.Text = ""; } //Date Validation selectStartDate = tbStartDate.Text; selectEndDate = tbEndDate.Text; if (selectStartDate == "" || selectEndDate == "") { lbDateError.Text = "Please choose the Date!"; } else { if (selectStartDate.CompareTo(currentDate) == -1 || selectEndDate.CompareTo(currentDate) == -1) { lbDateError.Text = "cannot choose previous date!"; } else if (selectEndDate.CompareTo(selectStartDate) == -1) { lbDateError.Text = "Start Date should before End Date!"; } else { lbDateError.Text = ""; Dept_Registry depReg = context.Dept_Registry.SingleOrDefault(x => x.fullname == delegateFullName); delegateUserName = depReg.username; Approval_Duties ad = new Approval_Duties { //delegateFullName username = delegateUserName, start_date = Convert.ToDateTime(tbStartDate.Text), end_date = Convert.ToDateTime(tbEndDate.Text), dept_code = currentDeptCode, created_date = Convert.ToDateTime(currentDate), deleted = "N", reason = tbReason.Text }; context.Approval_Duties.Add(ad); context.SaveChanges(); lbDateError.Text = "Successfully Saved!"; } } } catch (Exception ex) { ex.StackTrace.ToString(); } }
public Dept_Registry login(string user) { Dept_Registry dr = context.Dept_Registry.Where(x => x.username == user).First(); return(dr); }