Untitled

 avatar
unknown
plain_text
2 years ago
1.3 kB
2
Indexable
public async Task<bool> AddSystemUser(string fullname, string address, string mobile, string position,
            string userName, string pass)
        {
            try
            {
                Sqlcmd.Parameters.Clear();
                await Conopen();
                Strsql =
                    "Insert into tbl_SystemUsers(Fullname, Address, mobile_num, Position, username, password) " +
                    "Values(@Fullname, @Address, @mobile_num, @Position, @username, @password)";
                Sqlcmd.Parameters.AddWithValue("@Fullname", fullname);
                Sqlcmd.Parameters.AddWithValue("@Address", address);
                Sqlcmd.Parameters.AddWithValue("@mobile_num", mobile);
                Sqlcmd.Parameters.AddWithValue("@Position", position);
                Sqlcmd.Parameters.AddWithValue("@username", userName);
                Sqlcmd.Parameters.AddWithValue("@password", pass);
                Sqlcmd.Connection = Cnn;
                Sqlcmd.CommandText = Strsql;
                await Sqlcmd.ExecuteNonQueryAsync();
                Sqlcmd.Dispose();
                Strsql = "";
                Cnn.Close();
                return true;
            }
            catch
            {
                return false;
            }

        }
Editor is loading...