public async Task <IActionResult> Edit(int id, [Bind("HOD_id,MobileNo,FirstName,LastName,Deparment,FreeLeave")] HOD hOD) { if (id != hOD.HOD_id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(hOD); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!HODExists(hOD.HOD_id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(hOD)); }
public async Task <IActionResult> Create([Bind("HOD_id,MobileNo,FirstName,LastName,Deparment,FreeLeave")] HOD hOD) { if (ModelState.IsValid) { _context.Add(hOD); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(hOD)); }
public static HOD GetByFacultyId(string FacultyId) { DataTable dt = Database.ExecuteQuery("SELECT * FROM HOD WHERE Faculty_Id='" + FacultyId + "'"); if (dt != null && dt.Rows.Count == 1) { HOD h = new HOD(); h.FacultyId = dt.Rows[0][0].ToString(); h.Priority = int.Parse(dt.Rows[0][1].ToString()); return h; } return null; }
public static HOD GetByPriority(String DepartmentId,int Priority) { DataTable dt = Database.ExecuteQuery("SELECT h.Faculty_Id,h.Priority FROM HOD h,Faculty f WHERE h.Faculty_Id = f.User_Name AND h.Priority=" + Priority + " AND f.Department_Id = '"+DepartmentId+"'" ); if (dt != null && dt.Rows.Count == 1) { HOD h = new HOD(); h.FacultyId = dt.Rows[0][0].ToString(); h.Priority = int.Parse(dt.Rows[0][1].ToString()); return h; } return null; }
protected void btnLogin_Click(object sender, EventArgs e) { Faculty faculty = new Faculty(); faculty = faculty.GetFacultyDetails(txtbxUsername.Text, txtbxPassword.Text); if(faculty != null) { if(chkbxRememberMe.Checked) { HttpCookie rememberMeCookie = new HttpCookie("rememberMe"); rememberMeCookie["ID"] = faculty.ID.ToString(); rememberMeCookie.Expires = DateTime.Now.AddYears(1); Response.Cookies.Add(rememberMeCookie); } if(faculty.Designation == DesignationType.HOD) { HOD hod = new HOD { ID = faculty.ID, Name = faculty.Name, Password = faculty.Password, Username = faculty.Username, Department = faculty.Department, ContactNo = faculty.ContactNo, EmailID = faculty.EmailID, ImageURL = faculty.ImageURL }; Session["HOD"] = hod; Response.Redirect("HOD/Home.aspx"); } else { Session["Faculty"] = faculty; Response.Redirect("Faculty/Home.aspx"); } } else { lblResult.Text = "Invalid Credentials"; } }