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; } }