public int GetDataByUserNamenPassword(string username, string password)
{
tbluserTableAdapter adapter = new tbluserTableAdapter();
pyatLevelDS.tbluserDataTable tbl = new pyatLevelDS.tbluserDataTable();
tbl = adapter.GetDataByUserNamenPassword(username, password);
if (tbl == null || tbl.Rows.Count == 0)
return 0;
if (tbl.Rows.Count > 1)
return -1;
else
{
System.Data.DataColumn column = tbl.Columns[0];
int value = Convert.ToInt32(tbl.Rows[0][0]);
return value;
}
}
public int LogIn(string username, string Password, string Emailid)
{
tbluserTableAdapter adapter = new tbluserTableAdapter();
pyatLevelDS.tbluserDataTable tbl = new pyatLevelDS.tbluserDataTable();
tbl = adapter.GetDataByCredentials(username,Password , Emailid);
if (tbl == null || tbl.Rows.Count == 0)
return 0;
if (tbl.Rows.Count > 1)
return -1;
else
{
System.Data.DataColumn column = tbl.Columns[0];
int value = Convert.ToInt32(tbl.Rows[0][0]);
return value;
}
}
