public int InsertMayavi_Users(string USER_NAME, string EMAIL, string PWD)
{
int AffectedRow = 0;
try
{
string MOBILENO = "";
string ORGANIZATION = "";
string PRIVILEGE = "F";
MD5Encryption md5 = new MD5Encryption();
PWD = md5.Encryption(PWD);
Query = @"INSERT INTO MAYAVI_USERS(USER_NAME,EMAIL,MOBILENO,ORGANIZATION,PWD,PRIVILEGE) VALUES(@USER_NAME,@EMAIL,@MOBILENO,@ORGANIZATION,@PWD,@PRIVILEGE)";
AffectedRow = db.ExecuteInsert(Query,
new MySqlParameter("@USER_NAME", USER_NAME),
new MySqlParameter("@EMAIL", EMAIL),
new MySqlParameter("@MOBILENO", MOBILENO),
new MySqlParameter("@ORGANIZATION", ORGANIZATION),
new MySqlParameter("@PWD", PWD),
new MySqlParameter("@PRIVILEGE", PRIVILEGE));
}
catch
{
AffectedRow = 0;
}
return(AffectedRow);
}