public int AddOfflineUser(OfflineValidate offlinevalidate)
{
SqlParameter[] parms =
{
data.MakeInParam("@UserName", SqlDbType.VarChar, 50, offlinevalidate.UserName),
data.MakeInParam("@Name", SqlDbType.VarChar, 50, offlinevalidate.Name),
data.MakeInParam("@Email", SqlDbType.VarChar, 50, offlinevalidate.Email),
data.MakeInParam("@Telephone", SqlDbType.VarChar, 50, offlinevalidate.Telephone),
data.MakeInParam("@ValidateAddress", SqlDbType.VarChar, 100, offlinevalidate.ValidateAddress),
};
return
(data.RunProc(
"insert into offlinevalidate (username,name,email,telephone,validateaddress) values (@UserName,@Name,@Email,@Telephone,@ValidateAddress)", parms));
}
public DataSet SearchUser(OfflineValidate offlinevalidate)
{
SqlParameter[] parms =
{
data.MakeInParam("@UserName", SqlDbType.VarChar, 50, offlinevalidate.UserName),
data.MakeInParam("@Name", SqlDbType.VarChar, 50, offlinevalidate.Name),
data.MakeInParam("@Email", SqlDbType.VarChar, 50, offlinevalidate.Email),
data.MakeInParam("@Telephone", SqlDbType.VarChar, 50, offlinevalidate.Telephone),
data.MakeInParam("@ValidateAddress", SqlDbType.VarChar, 100, offlinevalidate.ValidateAddress),
};
return
(data.RunProcReturn(
"SELECT * FROM offlinevalidate WHERE username = @UserName", parms,
"offlinevalidate"));
}
