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";
     }
 }