public int Insert(frmU U) { return(base.ExecNonQuery("INSERT INTO " + "Users(UName, Password) " + "VALUES(@UName, @Password)", GetParameter(U))); }
public object InsertScalar(frmU U) { return(base.ExecScalar("INSERT INTO " + "Users(UName, Password ) " + "OUTPUT INSERTED.UID VALUES(@UName, @Password)", GetParameter(U))); }
public SqlParameter[] GetParameter(frmU U) { SqlParameter[] param = new SqlParameter[11]; param[0] = new SqlParameter("UID", U.UID); param[1] = new SqlParameter("UCode", U.UCode); param[2] = new SqlParameter("UName", U.UName); param[3] = new SqlParameter("Password", U.Password); return(param); }
private frmU GetUser() { frmU U = new frmU(); U.UID = Convert.ToInt32(txtUID.Text); U.UCode = txtUCode.Text; U.UName = txtUName.Text; U.Password = txtPass.Text; return(U); }
public int Update(frmU U) { return(base.ExecNonQuery("UPDATE Users " + "SET UName=@UName, Password=@Password WHERE UID=@UID", GetParameter(U))); }