public string admin_login(string userid, string pwd)
{
string host = libhp.ini_opacurl();
string st = string.Format("server={0};database=database;User ID=user;Password=pwd;Trusted_Connection=false;", host);
using (SqlConnection con = new SqlConnection(st))
{
con.Open();
string sql = string.Format("exec dbo.wsrv_checkadmi @id='{0}', @pwd='{1}';", userid, pwd);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(sql, con);
da.Fill(dt);
Checkadmi checkadmi = new Checkadmi();
checkadmi.result = dt.Rows[0][0].ToString();
checkadmi.msg = dt.Rows[0][1].ToString();
checkadmi.userid = dt.Rows[0][2].ToString();
checkadmi.location = dt.Rows[0][3].ToString();
string result = JsonConvert.SerializeObject(checkadmi);
return(result);
}
}
private void pictureBox2_Click(object sender, EventArgs e)
{
if (checkBox1.Checked)
{
string id = txt_userid.Text.Trim();
if (id == string.Empty || id == null)
{
MessageBox.Show("ERROR", "Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txt_userid.Focus();
return;
}
else
{
OfflineForm frm1 = new OfflineForm();
this.Hide();
frm1.String1 = id;
frm1.SetValue();
frm1.Show();
}
}
else
{
if (txt_userid.Text.Trim() == string.Empty || txt_userid.Text.Trim() == null)
{
MessageBox.Show("ERROR", "Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txt_userid.Focus();
return;
}
workingForm1 frm = new workingForm1();
frm.StartPosition = FormStartPosition.CenterScreen;
frm.Show();
frm.BringToFront();
string opacurl = libhp.ini_opacurl();
string id = txt_userid.Text.Trim();
string pwd = txt_pwd.Text.Trim();
string url = string.Format("http://{0}/getservice.ashx?mode=1&userid={1}&pwd={2}", opacurl, id, pwd);
try
{
string get = string.Empty;
if (libhp.ini_mode() == "0")
{
get = libhp.getservice(url);
}
else
{
get = sqlhp.admin_login(id, pwd);
}
Checkadmi m = JsonConvert.DeserializeObject <Checkadmi>(get);
switch (m.result.ToString())
{
case "0":
{
frm.Close();
Form1 frm1 = new Form1();
this.Hide();
frm1.String1 = m.userid;
frm1.String2 = m.location;
frm1.String3 = id;
frm1.SetValue();
frm1.Show();
break;
}
default:
{
Thread.Sleep(1000);
frm.Close();
MessageBox.Show(m.msg.ToString(), "Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
libhp.clean_control(txt_userid, txt_pwd);
txt_userid.Focus();
break;
}
}
}
catch
{
Thread.Sleep(10000);
MessageBox.Show("ERROR", "Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
Application.Exit();
}
}
}
