public DsMaster.USERINFODataTable CheckLoginDetails(string username, string password) { var ta = new DsMasterTableAdapters.USERINFOTableAdapter {Connection = {ConnectionString = _constr}}; var ds = new DsMaster().USERINFO; ta.FillByLogin(ds, username, password); return ds; }
public string GetUserNameByUserid(int userid){ var ta = new DsMasterTableAdapters.USERINFOTableAdapter {Connection = {ConnectionString = _constr}}; var ds = new DsMaster().USERINFO; return ta.GetNameByUserid(userid).ToString(); }
public DsMaster.USERINFODataTable GetUserinfoByUserName(string username) { var ta = new DsMasterTableAdapters.USERINFOTableAdapter {Connection = {ConnectionString = _constr}}; var ds = new DsMaster().USERINFO; ta.FillByUSERNAME(ds, username); return ds; }
public DsMaster.USERINFODataTable GetUserinfoByEmp(string empno) { var ta = new DsMasterTableAdapters.USERINFOTableAdapter {Connection = {ConnectionString = _constr}}; var ds = new DsMaster().USERINFO; ta.FillByEMPNO(ds, empno); return ds; }
public DsMaster.USERINFODataTable GetUserInfo(bool useconstr = false, string newconstr = "p") { var ta = new DsMasterTableAdapters.USERINFOTableAdapter { Connection = { ConnectionString = useconstr ? newconstr : _constr } }; var ds = new DsMaster().USERINFO; ta.Fill(ds); return ds; }
public string DoSave() { string retval; // SqlTransaction tran = null; try { var cn = new SqlConnection {ConnectionString = _constr}; cn.Open(); //tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted); var dt = new DsMaster().USERINFO; bool isnew = false; var ta = new DsMasterTableAdapters.USERINFOTableAdapter() {Connection = cn}; ta.Fill(dt); //ta.AssignConnection(cn, tran); var dr = dt.FindByUSERID(userinfoRow.USERID); if (dr != null) { dr.BeginEdit(); dr.EDATE = System.DateTime.Now.Date; dr.EDITEDBY = Utils.Userid; } else { dr = (DsMaster.USERINFORow) dt.NewRow(); isnew = true; dr.CREATEDBY = Utils.Userid; dr.CDATE = System.DateTime.Now.Date; } dr.USERNAME = userinfoRow.USERNAME; dr.FULLNAME = userinfoRow.FULLNAME; dr.EMPNO = userinfoRow.EMPNO; dr.PASSWORD = userinfoRow.PASSWORD; dr.ACTIVE = userinfoRow.ACTIVE; dr.PROFILEID = userinfoRow.PROFILEID; dr.USERTYPE = userinfoRow.USERTYPE; if (isnew) { dt.Rows.Add(dr); ta.Update(dt); } else { dr.EndEdit(); ta.Update(dt); } //Utils.NewUserid retval = "1"; } catch (Exception ex) { retval = ex.ToString(); // if (tran != null) tran.Rollback(); } return retval; }