Untitled
unknown
plain_text
3 years ago
1.3 kB
6
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...