public bool Modify(usersData datusers) { int iRel = -1; bool bRel = false; DataAccess.CommonDB objDB = new DataAccess.CommonDB(); try { objDB.OpenConnection(); string strSql = "update users set userid=@userid,userpwrd=@userpwrd,username=@username,usertype=@usertype,userclass=@userclass where Id = @Id"; objDB.Command.CommandType = System.Data.CommandType.Text; objDB.Command.CommandText = strSql; objDB.Command.Parameters.AddWithValue("@userid", datusers.userid); objDB.Command.Parameters.AddWithValue("@userpwrd", datusers.userpwrd); objDB.Command.Parameters.AddWithValue("@username", datusers.username); objDB.Command.Parameters.AddWithValue("@usertype", datusers.usertype); objDB.Command.Parameters.AddWithValue("@userclass", datusers.userclass); objDB.Command.Parameters.AddWithValue("@Id", datusers.Id); iRel = objDB.Command.ExecuteNonQuery(); } catch (Exception ex) { iRel = -1; } objDB.CloseConnection(); objDB.Dispose(); objDB = null; bRel = (iRel.Equals(1) ? true : false); return(bRel); }
public usersData[] Put(string Id) { int iRel = -1; DataAccess.CommonDB objDB = new DataAccess.CommonDB(); usersData[] datusers = new usersData[1]; string sql = "select * from users where 1 = 1 "; sql += Id; try { objDB.OpenConnection(); DataSet ds = objDB.QueryData(sql, "departmentinfo"); if (ds.Tables.Count > 0) { long nRow = ds.Tables[0].Rows.Count; if (nRow > 0) { datusers = new usersData[nRow]; for (int i = 0; i < nRow; i++) { datusers[i] = new usersData(); datusers[i].userid = ds.Tables[0].Rows[i]["userid"].ToString(); datusers[i].userpwrd = ds.Tables[0].Rows[i]["userpwrd"].ToString(); datusers[i].username = ds.Tables[0].Rows[i]["username"].ToString(); datusers[i].usertype = ds.Tables[0].Rows[i]["usertype"].ToString(); datusers[i].userclass = ds.Tables[0].Rows[i]["userclass"].ToString(); } } } } catch (Exception ex) { iRel = -1; } objDB.CloseConnection(); objDB.Dispose(); objDB = null; return(datusers); }