public static string sql_insertuser(userinfo userdetail)
{
string status;
try
{
status = sp_sqlconnection.dml_sp_id("userdetail", "qtype=insert|user_name=" + userdetail.user_name + "|user_password="******"|user_type=" + userdetail.user_type + "|user_sec_question=" + userdetail.user_sec_question + "|user_sec_answer=" + userdetail.user_sec_answer + "|user_status=" + userdetail.user_status + "|country_id=" + userdetail.company_id + "");//insert user detail
}
catch (Exception)
{
status = "";
}
return(status);
}
public static int sql_deleteuser(userinfo userdetail)
{
int status;
try
{
sp_sqlconnection.dml_sp("userdetail", "qtype=delete|user_id=" + userdetail.user_id + "");//Delete user detail
status = 1;
}
catch (Exception)
{
status = 0;
}
return(status);
}
public static int sql_updateuserwithpermission(userinfo userdetail)
{
int status;
try
{
sp_sqlconnection.dml_sp("userdetail", "qtype=update|user_name=" + userdetail.user_name + "|user_password="******"|user_type=" + userdetail.user_type + "|user_sec_question=" + userdetail.user_sec_question + "|user_sec_answer=" + userdetail.user_sec_answer + "|user_status=" + userdetail.user_status + "|ins=" + userdetail.ins + "|del=" + userdetail.del + "|edt==" + userdetail.edt + "|company_id=" + userdetail.company_id + "|user_id=" + userdetail.user_id + "");//Update user detail
status = 1;
}
catch (Exception)
{
status = 0;
}
return(status);
}