Пример #1
0
        /// <summary>
        /// ADD USERS
        /// </summary>
        /// <param name="data"></param>
        /// <returns></returns>
        public bool AddUser(SystemUserModel data)//(string fname,string lname,string contact)
        {
            cmd = new SqlCommand("usp_UserRegistration");
            cmd.Parameters.AddWithValue("@useraccess", data.Useraccess);
            cmd.Parameters.AddWithValue("@userpassword", data.Userpassword);
            cmd.Parameters.AddWithValue("@empNumber", data.EmployeeNumber);
            cmd.Parameters.AddWithValue("@empType", data.EmployeeType);


            return(ExecNonQuery(cmd));
        }
Пример #2
0
        /// <summary>
        /// SAVE THE UPDATED USER DETAILS
        /// </summary>
        /// <param name="data"></param>
        /// <returns></returns>
        public bool UserDetailsUpdate(SystemUserModel data)//(string fname,string lname,string contact)
        {
            cmd = new SqlCommand("usp_UserDetailsUpdate");
            cmd.Parameters.AddWithValue("@UserID", data.UserID);
            cmd.Parameters.AddWithValue("@useraccess", data.Useraccess);
            cmd.Parameters.AddWithValue("@userpassword", data.Userpassword);
            cmd.Parameters.AddWithValue("@EmployeeNumber", data.EmployeeNumber);
            cmd.Parameters.AddWithValue("@UserType", data.EmployeeType);


            return(ExecNonQuery(cmd));
        }