public int addNewUser(string name, string emailid, int isactive) { DAL.pyatLevelDSTableAdapters.tbluserTableAdapter adapter = new tbluserTableAdapter(); int success = Convert.ToInt32(adapter.addNewUser(name, emailid, isactive)); if (success > 1) { return success; } else { return -1; } }
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 addNewUser(string userName, string password, string Email, string address, String phoneNo) { /*if * getUserwithSameName() returns null then go ahead and * AddNewUser(); * then AddUserInfo() * then setPassword() * * */ int insertionsuccess = -1; DAL.pyatLevelDSTableAdapters.tbluserTableAdapter useradapter = new tbluserTableAdapter(); DAL.pyatLevelDSTableAdapters.tbluserinfoTableAdapter infoAdapter = new tbluserinfoTableAdapter(); DAL.pyatLevelDSTableAdapters.tblpasswordTableAdapter passwordAdapter = new tblpasswordTableAdapter(); if (useradapter.GetUserIDByName(userName) != null) { //we got result back. Which means there is a user with the same name. return -1; } else { try { int userid = addNewUser(userName, address, 0); int success = infoAdapter.AddUserInfo(userid, userName, address, phoneNo, Email); insertionsuccess = passwordAdapter.SetPasswordInfo(password, password, 0, userid); } catch { } } return insertionsuccess; }
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; } }