protected void btnRegister_Click(object sender, EventArgs e)
    {
        #region Server Side Validation
        string strErrorMessage = "";

        if (txtUserName.Text.Trim() == "")
        {
            strErrorMessage += "-Enter User Name <br />";
        }
        if (txtPassword.Text.Trim() == "")
        {
            strErrorMessage += "-Enter Password  <br />";
        }
        if (strErrorMessage.Trim() != "")
        {
            lblMassage.Text     = strErrorMessage;
            lblMassage.CssClass = "text-danger";
            return;
        }
        #endregion Server Side Validation

        UserENT entUser = new UserENT();
        UserBAL balUser = new UserBAL();

        if (balUser.SelectByUserName(txtUserName.Text.ToString().Trim()).IsNull)
        {
            readData();

            string strOTP = GeneratePassword().ToString();
            Session["OTP"] = strOTP;

            MailMessage msg = new MailMessage();
            msg.From = new MailAddress("*****@*****.**");
            msg.To.Add(txtUserName.Text);
            msg.Subject    = "Verfiy your email account";
            msg.Body       = "Welcome to Income Expence <br/><br/>Your OTP is:<strong>" + strOTP + "</strong>";
            msg.IsBodyHtml = true;

            SmtpClient smt = new SmtpClient();
            smt.Host = "smtp.gmail.com";
            System.Net.NetworkCredential ntwd = new NetworkCredential();
            ntwd.UserName             = "******"; // Your Email ID
            ntwd.Password             = "";                     // Your Password
            smt.UseDefaultCredentials = true;
            smt.Credentials           = ntwd;
            smt.Port      = 587;
            smt.EnableSsl = true;
            smt.Send(msg);
            lblMassage.Text      = "Email Sent Successfully";
            lblMassage.ForeColor = System.Drawing.Color.ForestGreen;
            ClearControls();
            Response.Redirect("~/AdminPanel/Authentication/VerifyEmail.aspx");
        }
        else
        {
            lblMassage.Text     = "User Name is alrady Entered";
            lblMassage.CssClass = "text-danger";
            ClearControls();
        }
    }
예제 #2
0
    private void fillGridViewEmployee()
    {
        DataTable dtUser  = new DataTable();
        UserBAL   balUser = new UserBAL();
        UserENT   entUser = new UserENT();

        entUser = balUser.SelectUserCount();
        lblTotalEmployee.Text = entUser.Usercount.ToString();
        lblPendingLeave.Text  = Session["PendingLeaveRequest"].ToString();

        dtUser = balUser.SelectAll();

        if (dtUser != null && dtUser.Rows.Count > 0)
        {
            gvEmployeeDetails.DataSource = dtUser;
            gvEmployeeDetails.DataBind();
        }
        else if (dtUser.Rows.Count < 1)
        {
            gvEmployeeDetails.DataSource = null;
            gvEmployeeDetails.DataBind();
            PanelGV.Visible = false;
        }
        else
        {
            PanelErrorMesseage.Visible = true;
            lblErrorMesseage.Text      = balUser.Message;
        }
    }
    private void FillGridViewLeave()
    {
        LeaveStatusBAL balLeaveStatus = new LeaveStatusBAL();
        DataTable      dtLeaveStatus  = new DataTable();
        UserBAL        balUser        = new UserBAL();
        UserENT        entUser        = new UserENT();

        entUser = balUser.SelectUserCount();
        lblTotalEmployee.Text = entUser.Usercount.ToString();

        dtLeaveStatus = balLeaveStatus.SelectAll();
        Session["PendingLeaveRequest"] = dtLeaveStatus.Rows.Count;

        if (dtLeaveStatus != null && dtLeaveStatus.Rows.Count > 0)
        {
            lblPendingLeave.Text     = dtLeaveStatus.Rows.Count.ToString();
            gvLeaveStatus.DataSource = dtLeaveStatus;
            gvLeaveStatus.DataBind();
        }
        else if (dtLeaveStatus.Rows.Count < 1)
        {
            lblPendingLeave.Text     = 0.ToString();
            gvLeaveStatus.DataSource = null;
            gvLeaveStatus.DataBind();
            PanelGV.Visible = false;
        }
        else
        {
            PanelErrorMesseage.Visible = true;
            lblErrorMesseage.Text      = balLeaveStatus.Message;
        }
    }
예제 #4
0
    protected void btnUpdateProfileImage_Click(object sender, EventArgs e)
    {
        UserENT entUser = new UserENT();

        entUser.UserID = Convert.ToInt32(Session["UserID"].ToString());
        if (fuProfile.HasFiles)
        {
            string strPath         = "~/UserImages/";
            string strPhysicalPath = "";
            strPhysicalPath  = Server.MapPath(strPath);
            strPhysicalPath += fuProfile.FileName;
            strPath         += fuProfile.FileName;

            if (File.Exists(strPhysicalPath))
            {
                File.Delete(strPhysicalPath);
            }
            fuProfile.SaveAs(strPhysicalPath);
            entUser.UserProfileImage    = strPath;
            Session["UserProfileImage"] = strPath;
        }
        UserBAL balUser = new UserBAL();

        if (balUser.UpdateProfile(entUser))
        {
            Response.Redirect("~/AdminPanel/Profile/Profile.aspx");
        }
        else
        {
            lblMessageProfile.Text = balUser.Message;
        }
    }
예제 #5
0
    private void createNewUser()
    {
        UserENT entUser = new UserENT();

        #region Read Data
        entUser.UserName         = Session["UserName"].ToString().Trim();
        entUser.Password         = Session["Password"].ToString().Trim();
        entUser.DisplayName      = Session["DisplayName"].ToString().Trim();
        entUser.Address          = Session["Address"].ToString().Trim();
        entUser.MobileNumber     = Session["MobileNumber"].ToString().Trim();
        entUser.UserProfileImage = Session["UserProfileImage"].ToString().Trim();
        #endregion

        UserBAL balUser = new UserBAL();
        if (balUser.Insert(entUser))
        {
            lblMessage.Text         = "Insert Successfully";
            lblMessage.CssClass     = "text-success";
            Session["Password"]     = null;
            Session["MobileNumber"] = null;
            Response.Redirect("~/AdminPanel/Authentication/Login.aspx");
        }
        else
        {
            lblMessage.Text = balUser.Message;
        }
    }
예제 #6
0
    protected void btnRegister_Click(object sender, EventArgs e)
    {
        #region ServerSide Validation

        String strErrorMessage = "";

        if (txtUserName.Text == "")
        {
            strErrorMessage += "Enter User Name<br/>";
        }

        if (txtPassword.Text == "")
        {
            strErrorMessage += "Enter Password<br/>";
        }

        if (strErrorMessage != "")
        {
            lblMessage.Text    = strErrorMessage;
            divMessage.Visible = true;
            return;
        }
        #endregion ServerSide Validation

        #region Collect Form Data
        UserENT entUser = new UserENT();

        if (txtUserName.Text != "")
        {
            entUser.UserName = txtUserName.Text.Trim();
        }

        if (txtEmail.Text != "")
        {
            entUser.Email = txtEmail.Text.Trim();
        }

        if (txtPassword.Text != "")
        {
            entUser.Password = txtPassword.Text.Trim();
        }

        #endregion Collect Form Data

        UserBAL balUser = new UserBAL();

        if (balUser.Insert(entUser))
        {
            ClearControls();
            lblMessage.Text    = "Register SuccessFully";
            divMessage.Visible = true;
        }
        else
        {
            lblMessage.Text    = balUser.Message;
            divMessage.Visible = true;
        }
    }
        public UserENT SelectUserCount()
        {
            using (SqlConnection objConn = new SqlConnection(ConnectionString))
            {
                objConn.Open();
                using (SqlCommand objCmd = objConn.CreateCommand())
                {
                    try
                    {
                        #region Prepare Command
                        objCmd.CommandType = CommandType.StoredProcedure;
                        objCmd.CommandText = "PR_User_SelectUserCount";
                        #endregion Prepare Command

                        #region Read Data and Set Controls
                        UserENT entUser = new UserENT();
                        using (SqlDataReader objSDR = objCmd.ExecuteReader())
                        {
                            if (objSDR.HasRows)
                            {
                                while (objSDR.Read())
                                {
                                    if (!objSDR["Usercount"].Equals(DBNull.Value))
                                    {
                                        entUser.Usercount = Convert.ToInt32(objSDR["Usercount"]);
                                    }
                                }
                                return(entUser);
                            }
                            else
                            {
                                return(null);
                            }
                        }

                        #endregion Read Data and Set Controls
                    }
                    catch (SqlException ex)
                    {
                        Message = ex.Message;
                        return(null);
                    }
                    catch (Exception ex)
                    {
                        Message = ex.Message;
                        return(null);
                    }
                    finally
                    {
                        if (objConn.State == ConnectionState.Open)
                        {
                            objConn.Close();
                        }
                    }
                }
            }
        }
        public Boolean Insert(UserENT entUser)
        {
            using (SqlConnection objConn = new SqlConnection(ConnectionString))
            {
                objConn.Open();
                using (SqlCommand objCmd = objConn.CreateCommand())
                {
                    try
                    {
                        #region Prepare Command
                        objCmd.CommandType = CommandType.StoredProcedure;
                        objCmd.CommandText = "PR_User_Insert";

                        objCmd.Parameters.Add("@UserID", SqlDbType.Int, 4).Direction     = ParameterDirection.Output;
                        objCmd.Parameters.Add("@UserName", SqlDbType.VarChar).Value      = entUser.UserName;
                        objCmd.Parameters.Add("@Password", SqlDbType.VarChar).Value      = entUser.Password;
                        objCmd.Parameters.Add("@DisplayName", SqlDbType.VarChar).Value   = entUser.DisplayName;
                        objCmd.Parameters.Add("@MobileNo", SqlDbType.VarChar).Value      = entUser.MobileNo;
                        objCmd.Parameters.Add("@DOB", SqlDbType.VarChar).Value           = entUser.DOB;
                        objCmd.Parameters.Add("@Gender", SqlDbType.VarChar).Value        = entUser.Gender;
                        objCmd.Parameters.Add("@Email", SqlDbType.VarChar).Value         = entUser.Email;
                        objCmd.Parameters.Add("@City", SqlDbType.VarChar).Value          = entUser.City;
                        objCmd.Parameters.Add("@Qualification", SqlDbType.VarChar).Value = entUser.Qualification;
                        objCmd.Parameters.Add("@Experience", SqlDbType.VarChar).Value    = entUser.Experience;
                        objCmd.Parameters.Add("@DesignationID", SqlDbType.Int).Value     = entUser.DesignationID;
                        objCmd.Parameters.Add("@DepartmentID", SqlDbType.Int).Value      = entUser.DepartmentID;
                        objCmd.Parameters.Add("@InstituteID", SqlDbType.Int).Value       = entUser.InstituteID;
                        objCmd.Parameters.Add("@PhotoPath", SqlDbType.VarChar).Value     = entUser.PhotoPath;
                        #endregion Prepare Command

                        objCmd.ExecuteNonQuery();
                        if (objCmd.Parameters["@UserID"] != null)
                        {
                            entUser.UserID = Convert.ToInt32(objCmd.Parameters["@UserID"].Value);
                        }
                        return(true);
                    }
                    catch (SqlException ex)
                    {
                        Message = ex.Message;
                        return(false);
                    }
                    catch (Exception ex)
                    {
                        Message = ex.Message;
                        return(false);
                    }
                    finally
                    {
                        if (objConn.State == ConnectionState.Open)
                        {
                            objConn.Close();
                        }
                    }
                }
            }
        }
예제 #9
0
        public Boolean Insert(UserENT entUser)
        {
            using (SqlConnection objConn = new SqlConnection(ConnectionString))
            {
                objConn.Open();

                using (SqlCommand objCmd = objConn.CreateCommand())
                {
                    try
                    {
                        #region Prepare Command
                        objCmd.CommandType = CommandType.StoredProcedure;
                        objCmd.CommandText = "PR_User_Insert";
                        objCmd.Parameters.Add("@UserID", SqlDbType.Int, 4).Direction = ParameterDirection.Output;
                        objCmd.Parameters.Add("@UserName", SqlDbType.VarChar).Value  = entUser.UserName;
                        objCmd.Parameters.Add("@Email", SqlDbType.VarChar).Value     = entUser.Email;
                        //objCmd.Parameters.Add("@UserType", SqlDbType.VarChar, 50).Direction = ParameterDirection.Output;
                        objCmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = entUser.Password;
                        #endregion Prepare Command

                        objCmd.ExecuteNonQuery();

                        if (objCmd.Parameters["@UserID"] != null)
                        {
                            entUser.UserID = Convert.ToInt32(objCmd.Parameters["@UserID"].Value);
                        }

                        //if (objCmd.Parameters["@UserType"] != null)
                        //    entUser.UserType = Convert.ToString(objCmd.Parameters["@UserType"].Value);

                        return(true);
                    }
                    catch (SqlException sqlex)
                    {
                        Message = sqlex.InnerException.Message;
                        return(false);
                    }
                    catch (Exception ex)
                    {
                        Message = ex.InnerException.Message;
                        return(false);
                    }
                    finally
                    {
                        if (objConn.State == ConnectionState.Open)
                        {
                            objConn.Close();
                        }
                    }
                }
            }
        }
예제 #10
0
        public UserENT SelectUserName(SqlInt32 UserID)
        {
            using (SqlConnection objConn = new SqlConnection(ConnectionString))
            {
                objConn.Open();
                using (SqlCommand objCmd = objConn.CreateCommand())
                {
                    try
                    {
                        #region Prepare Command
                        objCmd.CommandType = CommandType.StoredProcedure;
                        objCmd.CommandText = "PR_User_SelectUserNameByUserID";
                        objCmd.Parameters.Add("@UserID", SqlDbType.Int).Value = UserID;
                        #endregion Prepare Command

                        #region Read Data and Set Controls
                        UserENT entUser = new UserENT();
                        using (SqlDataReader objSDR = objCmd.ExecuteReader())
                        {
                            while (objSDR.Read())
                            {
                                if (!objSDR["UserName"].Equals(DBNull.Value))
                                {
                                    entUser.UserName = Convert.ToString(objSDR["UserName"]);
                                }
                            }
                        }
                        return(entUser);

                        #endregion Read Data and Set Controls
                    }
                    catch (SqlException ex)
                    {
                        Message = ex.Message;
                        return(null);
                    }
                    catch (Exception ex)
                    {
                        Message = ex.Message;
                        return(null);
                    }
                    finally
                    {
                        if (objConn.State == ConnectionState.Open)
                        {
                            objConn.Close();
                        }
                    }
                }
            }
        }
예제 #11
0
        public SqlString SelectByUserID(SqlInt32 UserID)
        {
            using (SqlConnection objConn = new SqlConnection(ConnectionString))
            {
                objConn.Open();
                using (SqlCommand objCmd = objConn.CreateCommand())
                {
                    try
                    {
                        objCmd.CommandType = CommandType.StoredProcedure;
                        objCmd.CommandText = "PR_User_SelectByUserID";

                        objCmd.Parameters.Add("@UserId", SqlDbType.Int).Value = UserID;

                        UserENT entUser = new UserENT();
                        using (SqlDataReader objSDR = objCmd.ExecuteReader())
                        {
                            if (objSDR.HasRows)
                            {
                                while (objSDR.Read())
                                {
                                    if (!objSDR["Password"].Equals(DBNull.Value))
                                    {
                                        entUser.Password = Convert.ToString(objSDR["Password"].ToString().Trim());
                                    }
                                }
                            }
                        }
                        return(entUser.Password);
                    }
                    catch (SqlException sqlex)
                    {
                        Message = sqlex.InnerException.ToString();
                        return(null);
                    }
                    catch (Exception ex)
                    {
                        Message = ex.Message.ToString();
                        return(null);
                    }
                    finally
                    {
                        if (objConn.State == ConnectionState.Open)
                        {
                            objConn.Close();
                        }
                    }
                }
            }
        }
예제 #12
0
        public Boolean UpdateByPK(UserENT entUser)
        {
            UserDAL dalUser = new UserDAL();

            if (dalUser.UpdateByPK(entUser))
            {
                return(true);
            }
            else
            {
                Message = dalUser.Message;
                return(false);
            }
        }
예제 #13
0
        public SqlString selectByMobileNumber(SqlString MobileNo)
        {
            using (SqlConnection objConn = new SqlConnection(ConnectionString))
            {
                objConn.Open();
                using (SqlCommand objCmd = objConn.CreateCommand())
                {
                    try
                    {
                        objCmd.CommandType = CommandType.StoredProcedure;
                        objCmd.CommandText = "PR_User_SelectByMobileNo";

                        objCmd.Parameters.Add("@MobileNo", SqlDbType.VarChar).Value = MobileNo;

                        UserENT entUser = new UserENT();
                        using (SqlDataReader objSDR = objCmd.ExecuteReader())
                        {
                            if (objSDR.HasRows)
                            {
                                while (objSDR.Read())
                                {
                                    if (!objSDR["MobileNo"].Equals(DBNull.Value))
                                    {
                                        entUser.MobileNumber = objSDR["MobileNo"].ToString().Trim();
                                    }
                                }
                            }
                        }
                        return(entUser.MobileNumber);
                    }
                    catch (SqlException sqlex)
                    {
                        Message = sqlex.InnerException.ToString();
                        return(null);
                    }
                    catch (Exception ex)
                    {
                        Message = ex.InnerException.ToString();
                        return(null);
                    }
                    finally
                    {
                        if (objConn.State == ConnectionState.Open)
                        {
                            objConn.Close();
                        }
                    }
                }
            }
        }
예제 #14
0
        public Boolean Insert(UserENT entUser)
        {
            UserDAL dalUser = new UserDAL();

            if (dalUser.Insert(entUser))
            {
                return(true);
            }
            else
            {
                Message = dalUser.Message;
                return(false);
            }
        }
    protected void gvLeaveStatus_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        LeaveBAL       balLeave       = new LeaveBAL();
        LeaveENT       entLeave       = new LeaveENT();
        LeaveStatusBAL balLeaveStatus = new LeaveStatusBAL();
        UserENT        entUser        = new UserENT();
        UserBAL        balUser        = new UserBAL();

        entUser = balUser.SelectUserName(Convert.ToInt32(Session["UserID"].ToString().Trim()));

        if (e.CommandName == "Approved")
        {
            if (e.CommandArgument != null)
            {
                #region Collect Data
                entLeave.LeaveStatus     = e.CommandName.ToString().Trim();
                entLeave.LeaveResponseBy = entUser.UserName;
                #endregion Collect Data

                if (!balLeave.UpdateLeaveStatusInLeave(entLeave, Convert.ToInt32(e.CommandArgument)))
                {
                    PanelErrorMesseage.Visible = true;
                    lblErrorMesseage.Text      = balLeave.Message;
                }
            }
        }
        else if (e.CommandName == "Rejected")
        {
            if (e.CommandArgument != null)
            {
                #region Collect Data
                entLeave.LeaveStatus     = e.CommandName.ToString().Trim();
                entLeave.LeaveResponseBy = entUser.UserName;
                #endregion Collect Data

                if (!balLeave.UpdateLeaveStatusInLeave(entLeave, Convert.ToInt32(e.CommandArgument)))
                {
                    PanelErrorMesseage.Visible = true;
                    lblErrorMesseage.Text      = balLeave.Message;
                }
            }
        }
        balLeaveStatus.Delete(Convert.ToInt32(e.CommandArgument));
        FillGridViewLeave();
    }
예제 #16
0
        public Boolean Insert(UserENT entUser)
        {
            using (SqlConnection objConn = new SqlConnection(ConnectionString))
            {
                objConn.Open();
                using (SqlCommand objCmd = objConn.CreateCommand())
                {
                    try
                    {
                        objCmd.CommandType = CommandType.StoredProcedure;
                        objCmd.CommandText = "PR_User_Insert";

                        objCmd.Parameters.Add("@UserID", SqlDbType.Int).Direction           = ParameterDirection.Output;
                        objCmd.Parameters.Add("@UserName", SqlDbType.VarChar).Value         = entUser.UserName;
                        objCmd.Parameters.Add("@Password", SqlDbType.VarChar).Value         = entUser.Password;
                        objCmd.Parameters.Add("@DisplayName", SqlDbType.VarChar).Value      = entUser.DisplayName;
                        objCmd.Parameters.Add("@Address", SqlDbType.VarChar).Value          = entUser.Address;
                        objCmd.Parameters.Add("@MobileNo", SqlDbType.VarChar).Value         = entUser.MobileNumber;
                        objCmd.Parameters.Add("@UserProfileImage", SqlDbType.VarChar).Value = entUser.UserProfileImage;

                        objCmd.ExecuteNonQuery();
                        entUser.UserID = Convert.ToInt32(objCmd.Parameters.Add("@UserID", SqlDbType.Int).Value);
                        return(true);
                    }
                    catch (SqlException sqlex)
                    {
                        Message = sqlex.InnerException.ToString();
                        return(false);
                    }
                    catch (Exception ex)
                    {
                        Message = ex.InnerException.ToString();
                        return(false);
                    }
                    finally
                    {
                        if (objConn.State == ConnectionState.Open)
                        {
                            objConn.Close();
                        }
                    }
                }
            }
        }
예제 #17
0
    protected void btnLogin_Click(object sender, EventArgs e)
    {
        #region Server Side Validation
        string strErrorMessage = "";

        if (txtUserName.Text.Trim() == "")
        {
            strErrorMessage += "-Enter User Name <br />";
        }
        if (txtPassword.Text.Trim() == "")
        {
            strErrorMessage += "-Enter Password  <br />";
        }
        if (strErrorMessage.Trim() != "")
        {
            lblErrorMessage.Text = strErrorMessage;
            return;
        }
        #endregion Server Side Validation

        UserENT entUser = new UserENT();
        UserBAL balUser = new UserBAL();

        entUser = balUser.SelectByUserNameAndPassword(txtUserName.Text.Trim(), txtPassword.Text.Trim());

        if (entUser.UserID.IsNull)
        {
            ClearControls();
            lblErrorMessage.Text     = "Invalid User";
            lblErrorMessage.CssClass = "text-danger";
        }
        else
        {
            Session["UserID"]           = entUser.UserID.ToString().Trim();
            Session["UserName"]         = entUser.UserName.ToString().Trim();
            Session["DisplayName"]      = entUser.DisplayName.ToString().Trim();
            Session["Address"]          = entUser.Address.ToString();
            Session["MobileNo"]         = entUser.MobileNumber.ToString().Trim();
            Session["UserProfileImage"] = entUser.UserProfileImage.ToString().Trim();
            ClearControls();
            Response.Redirect("~/AdminPanel/Dashboard/Dashboard.aspx");
        }
    }
예제 #18
0
        public Boolean UpdateProfile(UserENT entUser)
        {
            using (SqlConnection objConn = new SqlConnection(ConnectionString))
            {
                objConn.Open();
                using (SqlCommand objCmd = objConn.CreateCommand())
                {
                    try
                    {
                        objCmd.CommandType = CommandType.StoredProcedure;
                        objCmd.CommandText = "PR_User_UpdateProfile";

                        objCmd.Parameters.Add("@UserID", SqlDbType.Int).Value = entUser.UserID;
                        objCmd.Parameters.Add("@UserProfileImage", SqlDbType.VarChar).Value = entUser.UserProfileImage;

                        objCmd.ExecuteNonQuery();

                        return(true);
                    }
                    catch (SqlException sqlex)
                    {
                        Message = sqlex.Message.ToString();
                        return(false);
                    }
                    catch (Exception ex)
                    {
                        Message = ex.Message.ToString();
                        return(false);
                    }
                    finally
                    {
                        if (objConn.State == ConnectionState.Open)
                        {
                            objConn.Close();
                        }
                    }
                }
            }
        }
예제 #19
0
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        UserENT   entUser = new UserENT();
        UserBAL   balUser = new UserBAL();
        DataTable dtUser  = new DataTable();

        entUser = balUser.SelectUserNamePasswordByEmail(txtEmail.Text);

        dtUser = balUser.SelectUserEmail();

        foreach (DataRow row in dtUser.Rows)
        {
            if (txtEmail.Text == row[0].ToString())
            {
                using (MailMessage mail = new MailMessage())
                {
                    mail.From = new MailAddress("*****@*****.**");
                    mail.To.Add(txtEmail.Text);
                    mail.Subject = "LMS - Password Reset";
                    mail.Body    =
                        "Dear " + Convert.ToString(entUser.UserName) + "," +
                        "<br><br>Your Password Is :- " + Convert.ToString(entUser.Password) +
                        "<br><br><i>Please don't reply, this is auto generated email</i>";
                    mail.IsBodyHtml = true;

                    using (SmtpClient smtp = new SmtpClient("smtp.gmail.com", 587))
                    {
                        smtp.Credentials = new NetworkCredential("*****@*****.**", "Rus@17416");
                        smtp.EnableSsl   = true;
                        smtp.Send(mail);
                    }
                }
                Response.Redirect("~/Content/Login.aspx");
            }
        }
        lblErrorMesseage.Text = "Please enter registered Email address";
        txtEmail.Text         = "";
    }
예제 #20
0
        public UserENT SelectByPK(SqlInt32 UserID)
        {
            using (SqlConnection objConn = new SqlConnection(ConnectionString))
            {
                objConn.Open();
                using (SqlCommand objCmd = objConn.CreateCommand())
                {
                    try
                    {
                        #region Prepare Command
                        objCmd.CommandType = CommandType.StoredProcedure;
                        objCmd.CommandText = "PR_User_SelectByPK";
                        objCmd.Parameters.Add("@UserID", SqlDbType.Int).Value = UserID;
                        #endregion Prepare Command

                        #region Read Data and Set Controls
                        UserENT entUser = new UserENT();
                        using (SqlDataReader objSDR = objCmd.ExecuteReader())
                        {
                            if (objSDR.HasRows)
                            {
                                while (objSDR.Read())
                                {
                                    if (!objSDR["UserName"].Equals(DBNull.Value))
                                    {
                                        entUser.UserName = Convert.ToString(objSDR["UserName"]);
                                    }

                                    if (!objSDR["Password"].Equals(DBNull.Value))
                                    {
                                        entUser.Password = Convert.ToString(objSDR["Password"]);
                                    }

                                    if (!objSDR["DisplayName"].Equals(DBNull.Value))
                                    {
                                        entUser.DisplayName = Convert.ToString(objSDR["DisplayName"]);
                                    }

                                    if (!objSDR["MobileNo"].Equals(DBNull.Value))
                                    {
                                        entUser.MobileNo = Convert.ToString(objSDR["MobileNo"]);
                                    }

                                    if (!objSDR["DOB"].Equals(DBNull.Value))
                                    {
                                        entUser.DOB = Convert.ToString(objSDR["DOB"]);
                                    }

                                    if (!objSDR["Gender"].Equals(DBNull.Value))
                                    {
                                        entUser.Gender = Convert.ToString(objSDR["Gender"]);
                                    }

                                    if (!objSDR["Email"].Equals(DBNull.Value))
                                    {
                                        entUser.Email = Convert.ToString(objSDR["Email"]);
                                    }

                                    if (!objSDR["Experience"].Equals(DBNull.Value))
                                    {
                                        entUser.Experience = Convert.ToString(objSDR["Experience"]);
                                    }

                                    if (!objSDR["Qualification"].Equals(DBNull.Value))
                                    {
                                        entUser.Qualification = Convert.ToString(objSDR["Qualification"]);
                                    }

                                    if (!objSDR["City"].Equals(DBNull.Value))
                                    {
                                        entUser.City = Convert.ToString(objSDR["City"]);
                                    }

                                    if (!objSDR["DepartmentID"].Equals(DBNull.Value))
                                    {
                                        entUser.DepartmentID = Convert.ToInt32(objSDR["DepartmentID"]);
                                    }

                                    if (!objSDR["DesignationID"].Equals(DBNull.Value))
                                    {
                                        entUser.DesignationID = Convert.ToInt32(objSDR["DesignationID"]);
                                    }

                                    if (!objSDR["InstituteID"].Equals(DBNull.Value))
                                    {
                                        entUser.InstituteID = Convert.ToInt32(objSDR["InstituteID"]);
                                    }

                                    if (!objSDR["DepartmentName"].Equals(DBNull.Value))
                                    {
                                        entUser.DepartmentName = Convert.ToString(objSDR["DepartmentName"]);
                                    }

                                    if (!objSDR["DesignationName"].Equals(DBNull.Value))
                                    {
                                        entUser.DesignationName = Convert.ToString(objSDR["DesignationName"]);
                                    }

                                    if (!objSDR["InstituteName"].Equals(DBNull.Value))
                                    {
                                        entUser.InstituteName = Convert.ToString(objSDR["InstituteName"]);
                                    }

                                    if (!objSDR["PhotoPath"].Equals(DBNull.Value))
                                    {
                                        entUser.PhotoPath = Convert.ToString(objSDR["PhotoPath"]);
                                    }
                                }
                                return(entUser);
                            }
                            else
                            {
                                return(null);
                            }
                        }
                        #endregion Read Data and Set Controls
                    }
                    catch (SqlException ex)
                    {
                        Message = ex.Message;
                        return(null);
                    }
                    catch (Exception ex)
                    {
                        Message = ex.Message;
                        return(null);
                    }
                    finally
                    {
                        if (objConn.State == ConnectionState.Open)
                        {
                            objConn.Close();
                        }
                    }
                }
            }
        }
예제 #21
0
    protected void btnLogin_Click(object sender, EventArgs e)
    {
        #region ServerSide Validatiion
        String strErrorMessage = "";

        if (txtUserName.Text == "")
        {
            strErrorMessage += "Enter User Name<br/>";
        }

        if (txtPassword.Text == "")
        {
            strErrorMessage += "Enter Password<br/>";
        }

        if (strErrorMessage != "")
        {
            lblMessage.Text    = strErrorMessage;
            divMessage.Visible = true;
            return;
        }
        #endregion ServerSide Validatiion

        #region Collect Data
        String UserName = txtUserName.Text.ToString();
        String Password = txtPassword.Text.ToString();

        UserENT entUser = new UserENT();
        UserBAL balUser = new UserBAL();

        entUser = balUser.SelectByUserPassword(UserName, Password);

        if (!entUser.UserID.IsNull)
        {
            Session["UserID"] = entUser.UserID.Value.ToString();
        }

        if (!entUser.UserName.IsNull)
        {
            Session["UserName"] = entUser.UserName.Value.ToString();
        }

        if (!entUser.UserID.IsNull)
        {
            #region Get AddressID
            AddressENT entAddress = new AddressENT();
            AddressBAL balAddress = new AddressBAL();

            entAddress = balAddress.GetAddressIDByUserID(entUser.UserID.Value);

            if (!entAddress.AddressID.IsNull)
            {
                Session["AddressID"] = entAddress.AddressID.Value;
            }

            #endregion Get AddressID
        }

        if (!entUser.UserID.IsNull)
        {
            if (entUser.UserType == "user")
            {
                Response.Redirect("~/User/Home.aspx");
            }

            else
            {
                Response.Redirect("~/AdminPanel/Product/ProductList.aspx");
            }
        }

        else
        {
            lblMessage.Text    = "Enter Valid Name or Password";
            divMessage.Visible = true;
        }

        #endregion Collect Data
    }
예제 #22
0
        public UserENT SelectByUserNamePassword(SqlString UserName, SqlString Password)
        {
            using (SqlConnection objConn = new SqlConnection(ConnectionString))
            {
                objConn.Open();
                using (SqlCommand objCmd = objConn.CreateCommand())
                {
                    try
                    {
                        #region Prepare Command
                        objCmd.CommandType = CommandType.StoredProcedure;
                        objCmd.CommandText = "PR_User_SelectByUserNamePassword";
                        objCmd.Parameters.Add("@UserName", SqlDbType.VarChar).Value = UserName;
                        objCmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = Password;
                        #endregion Prepare Command

                        #region Read Data and Set Controls
                        UserENT entUser = new UserENT();
                        using (SqlDataReader objSDR = objCmd.ExecuteReader())
                        {
                            if (objSDR.HasRows)
                            {
                                while (objSDR.Read())
                                {
                                    if (!objSDR["UserID"].Equals(DBNull.Value))
                                    {
                                        entUser.UserID = Convert.ToInt32(objSDR["UserID"]);
                                    }

                                    if (!objSDR["DesignationName"].Equals(DBNull.Value))
                                    {
                                        entUser.DesignationName = Convert.ToString(objSDR["DesignationName"]);
                                    }

                                    if (!objSDR["DesignationID"].Equals(DBNull.Value))
                                    {
                                        entUser.DesignationID = Convert.ToInt32(objSDR["DesignationID"]);
                                    }

                                    if (!objSDR["DisplayName"].Equals(DBNull.Value))
                                    {
                                        entUser.DisplayName = Convert.ToString(objSDR["DisplayName"]);
                                    }

                                    if (!objSDR["PhotoPath"].Equals(DBNull.Value))
                                    {
                                        entUser.PhotoPath = Convert.ToString(objSDR["PhotoPath"]);
                                    }
                                }
                                return(entUser);
                            }
                            else
                            {
                                return(null);
                            }
                        }

                        #endregion Read Data and Set Controls
                    }
                    catch (SqlException ex)
                    {
                        Message = ex.Message;
                        return(null);
                    }
                    catch (Exception ex)
                    {
                        Message = ex.Message;
                        return(null);
                    }
                    finally
                    {
                        if (objConn.State == ConnectionState.Open)
                        {
                            objConn.Close();
                        }
                    }
                }
            }
        }
예제 #23
0
    protected void btnUpdateProfile_Click(object sender, EventArgs e)
    {
        #region Server Side Validation
        string strErrorMessage = "";

        if (txtUserName.Text.Trim() == "")
        {
            strErrorMessage += "-Enter User Name <br />";
        }
        if (txtDisplayName.Text.Trim() == "")
        {
            strErrorMessage += "-Enter Display Name  <br />";
        }
        if (txtMobileNo.Text.Trim() == "")
        {
            strErrorMessage += "-enter mobile number  <br />";
        }
        if (strErrorMessage.Trim() != "")
        {
            lblMessageProfile.Text = strErrorMessage;
            return;
        }
        #endregion Server Side Validation

        UserENT entUser = new UserENT();
        #region Read Data
        if (txtUserName.Text.Trim() != "")
        {
            entUser.UserName = txtUserName.Text.ToString();
        }
        if (txtDisplayName.Text.Trim() != "")
        {
            entUser.DisplayName = txtDisplayName.Text.ToString();
        }
        if (txtMobileNo.Text.Trim() != "")
        {
            entUser.MobileNumber = txtMobileNo.Text.ToString();
        }
        entUser.Address = txtAddress.Text.ToString();
        entUser.UserID  = Convert.ToInt32(Session["UserID"].ToString());

        #endregion Read Data

        UserBAL balUser = new UserBAL();

        if (balUser.UpdateByPK(entUser))
        {
            lblMessageProfile.Text = "Updated Successfully";
            divMessage.Visible     = true;
            Session["UserName"]    = txtUserName.Text;
            Session["DisplayName"] = txtDisplayName.Text;
            Session["Address"]     = txtAddress.Text.ToString();
            Session["MobileNo"]    = txtMobileNo.Text.ToString();
            profile();
        }
        else
        {
            lblMessageProfile.Text = balUser.Message;
        }
        Response.Redirect("~/AdminPanel/Profile/Profile.aspx");
    }
예제 #24
0
    private void fillLabel(SqlInt32 UserID)
    {
        UserBAL balUser = new UserBAL();
        UserENT entUser = new UserENT();

        entUser = balUser.SelectByPK(Convert.ToInt32(Session["UserID"].ToString().Trim()));

        if (entUser != null)
        {
            if (!entUser.DepartmentName.IsNull)
            {
                lblDepartment.Text = entUser.DepartmentName.ToString().Trim();
            }

            if (!entUser.DesignationName.IsNull)
            {
                lblDesignation.Text = entUser.DesignationName.ToString().Trim();
            }

            if (!entUser.InstituteName.IsNull)
            {
                lblInstitute.Text = entUser.InstituteName.ToString().Trim();
            }

            if (!entUser.Gender.IsNull)
            {
                if (entUser.Gender.ToString().Trim() == "Male")
                {
                    lblGender.Text = "Male";
                }

                if (entUser.Gender.ToString().Trim() == "Female")
                {
                    lblGender.Text = "Female";
                }
            }

            if (!entUser.UserName.IsNull)
            {
                lblUsername.Text = entUser.UserName.ToString().Trim();
            }

            if (!entUser.DisplayName.IsNull)
            {
                lblDisplayname.Text = entUser.DisplayName.ToString().Trim();
            }

            if (!entUser.MobileNo.IsNull)
            {
                lblMobileno.Text = entUser.MobileNo.ToString().Trim();
            }

            if (!entUser.DOB.IsNull)
            {
                lblDOB.Text = entUser.DOB.ToString().Trim();
            }

            if (!entUser.Email.IsNull)
            {
                lblEmail.Text = entUser.Email.ToString().Trim();
            }

            if (!entUser.Experience.IsNull)
            {
                lblExperience.Text = entUser.Experience.ToString().Trim();
            }

            if (!entUser.Qualification.IsNull)
            {
                lblQualification.Text = entUser.Qualification.ToString().Trim();
            }

            if (!entUser.City.IsNull)
            {
                lblCity.Text = entUser.City.ToString().Trim();
            }

            if (!entUser.PhotoPath.IsNull)
            {
                img.ImageUrl = entUser.PhotoPath.ToString().Trim();
            }
        }
        else
        {
            PanelErrorMesseage.Visible = true;
            lblErrorMessage.Text       = "missing data";
        }
    }
    private void fillControls(SqlInt32 UserID)
    {
        UserBAL balUser = new UserBAL();
        UserENT entUser = new UserENT();

        entUser = balUser.SelectByPK(Convert.ToInt32(Session["UserID"].ToString().Trim()));

        if (entUser != null)
        {
            if (!entUser.DepartmentID.IsNull)
            {
                ddlDepartment.SelectedValue = entUser.DepartmentID.ToString().Trim();
            }

            if (Session["Select"].ToString() == "Employee")
            {
                if (!entUser.DesignationID.IsNull)
                {
                    ddlDesignation.SelectedValue = entUser.DesignationID.ToString().Trim();
                }
                PanelHOD.Visible = false;
            }
            else if (Session["Select"].ToString() == "HOD")
            {
                PanelEmployee.Visible = false;
                lblHOD.Text           = "HOD";

                ddlDesignation.SelectedValue = entUser.DesignationID.ToString().Trim();
            }

            if (!entUser.InstituteID.IsNull)
            {
                ddlInstitute.SelectedValue = entUser.InstituteID.ToString().Trim();
            }

            if (!entUser.Gender.IsNull)
            {
                if (entUser.Gender.ToString().Trim() == "Male")
                {
                    rbMale.Checked = true;
                }

                if (entUser.Gender.ToString().Trim() == "Female")
                {
                    rbFemale.Checked = true;
                }
            }

            if (!entUser.UserName.IsNull)
            {
                txtUsername.Text = entUser.UserName.ToString().Trim();
            }

            if (!entUser.Password.IsNull)
            {
                txtPassword.Text = entUser.Password.ToString().Trim();
            }

            if (!entUser.DisplayName.IsNull)
            {
                txtDisplayName.Text = entUser.DisplayName.ToString().Trim();
            }

            if (!entUser.MobileNo.IsNull)
            {
                txtMobileNo.Text = entUser.MobileNo.ToString().Trim();
            }

            if (!entUser.DOB.IsNull)
            {
                txtDOB.Text = entUser.DOB.ToString().Trim();
            }

            if (!entUser.Email.IsNull)
            {
                txtEmail.Text = entUser.Email.ToString().Trim();
            }

            if (!entUser.Experience.IsNull)
            {
                txtExperience.Text = entUser.Experience.ToString().Trim();
            }

            if (!entUser.Qualification.IsNull)
            {
                txtQualification.Text = entUser.Qualification.ToString().Trim();
            }

            if (!entUser.City.IsNull)
            {
                txtCity.Text = entUser.City.ToString().Trim();
            }
        }
        else
        {
            lblErrorMessage.Text = "missing data";
        }
    }
예제 #26
0
        public UserENT SelectByUserNameAndPassword(SqlString UserName, SqlString Password)
        {
            using (SqlConnection objConn = new SqlConnection(ConnectionString))
            {
                objConn.Open();
                using (SqlCommand objCmd = objConn.CreateCommand())
                {
                    try
                    {
                        objCmd.CommandType = CommandType.StoredProcedure;
                        objCmd.CommandText = "PR_User_SelectByUserNamePassword";

                        objCmd.Parameters.Add("@UserName", SqlDbType.VarChar).Value = UserName;
                        objCmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = Password;

                        UserENT entUser = new UserENT();
                        using (SqlDataReader objSDR = objCmd.ExecuteReader())
                        {
                            if (objSDR.HasRows)
                            {
                                while (objSDR.Read())
                                {
                                    if (!objSDR["UserID"].Equals(DBNull.Value))
                                    {
                                        entUser.UserID = Convert.ToInt32(objSDR["UserID"].ToString().Trim());
                                    }
                                    if (!objSDR["UserName"].Equals(DBNull.Value))
                                    {
                                        entUser.UserName = objSDR["UserName"].ToString().Trim();
                                    }
                                    if (!objSDR["DisplayName"].Equals(DBNull.Value))
                                    {
                                        entUser.DisplayName = objSDR["DisplayName"].ToString().Trim();
                                    }
                                    if (!objSDR["Address"].Equals(DBNull.Value))
                                    {
                                        entUser.Address = objSDR["Address"].ToString().Trim();
                                    }
                                    if (!objSDR["MobileNo"].Equals(DBNull.Value))
                                    {
                                        entUser.MobileNumber = objSDR["MobileNo"].ToString().Trim();
                                    }
                                    if (!objSDR["UserProfileImage"].Equals(DBNull.Value))
                                    {
                                        entUser.UserProfileImage = objSDR["UserProfileImage"].ToString().Trim();
                                    }
                                }
                            }
                        }
                        return(entUser);
                    }
                    catch (SqlException sqlex)
                    {
                        Message = sqlex.InnerException.ToString();
                        return(null);
                    }
                    catch (Exception ex)
                    {
                        Message = ex.InnerException.ToString();
                        return(null);
                    }
                    finally
                    {
                        if (objConn.State == ConnectionState.Open)
                        {
                            objConn.Close();
                        }
                    }
                }
            }
        }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        #region Collect Data
        UserENT        entUser        = new UserENT();
        LeaveTypeENT   entLeaveType   = new LeaveTypeENT();
        DesignationENT entDesignation = new DesignationENT();

        if (ddlDepartment.SelectedIndex > 0)
        {
            entUser.DepartmentID = Convert.ToInt32(ddlDepartment.SelectedValue);
        }

        if (ddlInstitute.SelectedIndex > 0)
        {
            entUser.InstituteID = Convert.ToInt32(ddlInstitute.SelectedValue);
        }

        if (ddlDesignation.SelectedIndex > 0)
        {
            entUser.DesignationID        = Convert.ToInt32(ddlDesignation.SelectedValue);
            entDesignation.DesignationID = Convert.ToInt32(ddlDesignation.SelectedValue);
        }

        if (rbFemale.Checked != false)
        {
            entUser.Gender = rbFemale.Text.Trim();
        }

        if (rbMale.Checked != false)
        {
            entUser.Gender = rbMale.Text.Trim();
        }

        if (txtUsername.Text.Trim() != "")
        {
            entUser.UserName = txtUsername.Text.Trim();
        }

        if (txtPassword.Text.Trim() != "")
        {
            entUser.Password = txtPassword.Text.Trim();
        }

        if (txtDisplayName.Text.Trim() != "")
        {
            entUser.DisplayName = txtDisplayName.Text.Trim();
        }

        if (txtMobileNo.Text.Trim() != "")
        {
            entUser.MobileNo = txtMobileNo.Text.Trim();
        }

        if (txtDOB.Text.Trim() != "")
        {
            entUser.DOB = txtDOB.Text.Trim();
        }

        if (txtEmail.Text.Trim() != "")
        {
            entUser.Email = txtEmail.Text.Trim();
        }

        if (txtExperience.Text.Trim() != "")
        {
            entUser.Experience = txtExperience.Text.Trim();
        }

        if (txtQualification.Text.Trim() != "")
        {
            entUser.Qualification = txtQualification.Text.Trim();
        }

        if (txtCity.Text.Trim() != "")
        {
            entUser.City = txtCity.Text.Trim();
        }

        if (fuStaffPhoto.HasFile)
        {
            string strFileLocationSave = "~/Content/assets/images/";
            string strPhysicalPath     = "";

            strPhysicalPath      = Server.MapPath(strFileLocationSave);
            strPhysicalPath     += fuStaffPhoto.FileName;
            strFileLocationSave += fuStaffPhoto.FileName;

            if (File.Exists(strPhysicalPath))
            {
                File.Delete(strPhysicalPath);
            }

            fuStaffPhoto.SaveAs(strPhysicalPath);
            entUser.PhotoPath = strFileLocationSave;
        }
        #endregion Collect Data

        UserBAL        balUser        = new UserBAL();
        LeaveTypeBAL   balLeaveType   = new LeaveTypeBAL();
        DesignationBAL balDesignation = new DesignationBAL();

        entDesignation = balDesignation.SelectByPK(entDesignation.DesignationID);

        if (Session["UserID"] == null)
        {
            if (entDesignation.DesignationName == "HOD")
            {
                balUser.Insert(entUser);
                entUser = balUser.SelectByPK(entUser.UserID);

                clearSelection();
                lblSuccess.Text = "Data Inserted Successfully";
            }
            else if (entDesignation.DesignationName != "HOD")
            {
                balUser.Insert(entUser);

                if (entUser.UserID > 0)
                {
                    entLeaveType.UserID = entUser.UserID;
                    entUser             = balUser.SelectByPK(entUser.UserID);
                }
                else
                {
                    lblErrorMessage.Text = "empty";
                    return;
                }

                entLeaveType.LeaveType = "Casual Leave";
                entLeaveType.TotalDays = 25;
                balLeaveType.Insert(entLeaveType);

                entLeaveType.LeaveType = "Medical Leave";
                entLeaveType.TotalDays = 15;
                balLeaveType.Insert(entLeaveType);

                entLeaveType.LeaveType = "LOP";
                entLeaveType.TotalDays = 10;
                balLeaveType.Insert(entLeaveType);

                entLeaveType.LeaveType = "Other Leave";
                entLeaveType.TotalDays = 5;
                balLeaveType.Insert(entLeaveType);

                clearSelection();
                lblSuccess.Text = "Data Inserted Successfully";
            }
            else
            {
                lblErrorMessage.Text = balUser.Message;
            }
            using (MailMessage mail = new MailMessage())
            {
                mail.From = new MailAddress("*****@*****.**");
                mail.To.Add(entUser.Email.ToString());
                mail.Subject = "User Created Successfully !!";
                mail.Body    = "<h3>You can now login into Leave management system</h3><br>" +
                               "Your Username Is :- " + Convert.ToString(entUser.UserName) +
                               "<br>Your Password Is :- " + Convert.ToString(entUser.Password) +
                               "<br><br><i>Please don't reply, this is auto generated email</i>";
                mail.IsBodyHtml = true;

                using (SmtpClient smtp = new SmtpClient("smtp.gmail.com", 587))
                {
                    smtp.Credentials = new NetworkCredential("*****@*****.**", "password");
                    smtp.EnableSsl   = true;
                    smtp.Send(mail);
                }
            }
        }
        else
        {
            entUser.UserID = Convert.ToInt32(Session["UserID"].ToString().Trim());

            if (balUser.Update(entUser))
            {
                if (Session["Select"].ToString() == "Employee")
                {
                    Response.Redirect("~/Content/Home/Employee_Home.aspx");
                }
                else if (Session["Select"].ToString() == "HOD")
                {
                    Response.Redirect("~/Content/Home/HOD_Home.aspx");
                }
            }
            else
            {
                lblErrorMessage.Text = balUser.Message;
            }
        }
    }
    private void fillSession()
    {
        UserBAL balUser = new UserBAL();
        UserENT entUser = new UserENT();

        #region Local Variables
        SqlString strUserName = SqlString.Null;
        SqlString strPassword = SqlString.Null;
        string    strError    = "";
        #endregion

        #region Server Side Validation
        if (txtUserName.Text.Trim() == "")
        {
            strError += "Enter UserName </br>";
        }

        if (txtPassword.Text.Trim() == "")
        {
            strError += "Enter Password </br>";
        }

        if (strError.Trim() != "")
        {
            lblErrorMesseage.Text = strError;
            return;
        }
        #endregion

        #region Read Form Value
        if (txtUserName.Text.Trim() != "")
        {
            strUserName = txtUserName.Text.Trim();
        }
        if (txtPassword.Text.Trim() != "")
        {
            strPassword = txtPassword.Text.Trim();
        }
        #endregion

        if (strUserName == "admin" && strPassword == "admin")
        {
            Session["Select"] = "Admin";
            Response.Redirect("~/Content/Institute/InstituteList.aspx");
            return;
        }

        entUser = balUser.SelectByUserNamePassword(strUserName, strPassword);

        if (entUser != null)
        {
            if (!entUser.UserID.IsNull)
            {
                Session["UserID"] = entUser.UserID;
            }
            if (!entUser.DisplayName.IsNull)
            {
                Session["DisplayName"] = entUser.DisplayName;
            }
            if (!entUser.PhotoPath.IsNull)
            {
                Session["PhotoPath"] = entUser.PhotoPath;
            }

            if (entUser.DesignationName == "HOD")
            {
                Session["Select"] = "HOD";
                Response.Redirect("~/Content/Home/HOD_Home.aspx");
            }
            else
            {
                Session["Select"] = "Employee";
                Response.Redirect("~/Content/Home/Employee_Home.aspx");
            }
        }
        else
        {
            lblErrorMesseage.Text = "Either Username Or PAssword Is Invalid";
        }
    }
예제 #29
0
        public UserENT SelectByUserPassword(String UserName, String password)
        {
            using (SqlConnection objConn = new SqlConnection(ConnectionString))
            {
                objConn.Open();

                using (SqlCommand objCmd = objConn.CreateCommand())
                {
                    try
                    {
                        #region Prepare command
                        objCmd.CommandType = CommandType.StoredProcedure;
                        objCmd.CommandText = "PR_User_SelectByUserPassword";
                        objCmd.Parameters.AddWithValue("@UserName", UserName);
                        objCmd.Parameters.AddWithValue("@Password", password);

                        #endregion Prepare command

                        #region Read Data and Set Controls
                        UserENT entUser = new UserENT();

                        using (SqlDataReader objSDR = objCmd.ExecuteReader())
                        {
                            while (objSDR.Read())
                            {
                                if (!objSDR["UserID"].Equals(DBNull.Value))
                                {
                                    entUser.UserID = Convert.ToInt32(objSDR["UserID"]);
                                }

                                if (!objSDR["UserName"].Equals(DBNull.Value))
                                {
                                    entUser.UserName = Convert.ToString(objSDR["UserName"]);
                                }

                                if (!objSDR["Email"].Equals(DBNull.Value))
                                {
                                    entUser.Email = Convert.ToString(objSDR["Email"]);
                                }

                                if (!objSDR["UserType"].Equals(DBNull.Value))
                                {
                                    entUser.UserType = Convert.ToString(objSDR["UserType"]);
                                }

                                if (!objSDR["Password"].Equals(DBNull.Value))
                                {
                                    entUser.Password = Convert.ToString(objSDR["Password"]);
                                }
                            }
                        }
                        return(entUser);

                        #endregion Read Data and Set Controls
                    }
                    catch (SqlException sqlex)
                    {
                        Message = sqlex.InnerException.Message.ToString();
                        return(null);
                    }
                    catch (Exception ex)
                    {
                        Message = ex.InnerException.Message.ToString();
                        return(null);
                    }
                    finally
                    {
                        if (objConn.State == ConnectionState.Open)
                        {
                            objConn.Close();
                        }
                    }
                }
            }
        }