public static int PersonUpdate(this TestDataDB dataConnection, int?id, int?personId, string?firstName, string?middleName, string?lastName, string?gender)
{
var parameters = new []
{
new DataParameter("@id", id, DataType.Int32),
new DataParameter("@PersonID", personId, DataType.Int32),
new DataParameter("@FirstName", firstName, DataType.VarChar)
{
Size = 255
},
new DataParameter("@MiddleName", middleName, DataType.VarChar)
{
Size = 255
},
new DataParameter("@LastName", lastName, DataType.VarChar)
{
Size = 255
},
new DataParameter("@Gender", gender, DataType.VarChar)
{
Size = 255
}
};
return(dataConnection.ExecuteProc("[Person_Update]", parameters));
}
public static IEnumerable <PersonSelectByKeyResult> PersonSelectByKey(this TestDataDB dataConnection, int?id)
{
var parameters = new []
{
new DataParameter("@id", id, DataType.Int32)
};
return(dataConnection.QueryProc <PersonSelectByKeyResult>("[Person_SelectByKey]", parameters));
}
public static int PersonDelete(this TestDataDB dataConnection, int?personId)
{
var parameters = new []
{
new DataParameter("@PersonID", personId, DataType.Int32)
};
return(dataConnection.ExecuteProc("[Person_Delete]", parameters));
}
public static IEnumerable <PersonSelectByNameResult> PersonSelectByName(this TestDataDB dataConnection, string?firstName, string?lastName)
{
var parameters = new []
{
new DataParameter("@firstName", firstName, DataType.VarChar)
{
Size = 255
},
new DataParameter("@lastName", lastName, DataType.VarChar)
{
Size = 255
}
};
return(dataConnection.QueryProc <PersonSelectByNameResult>("[Person_SelectByName]", parameters));
}
public static int PersonInsert(this TestDataDB dataConnection, string?firstName, string?middleName, string?lastName, string?gender)
{
var parameters = new []
{
new DataParameter("@FirstName", firstName, DataType.VarChar)
{
Size = 255
},
new DataParameter("@MiddleName", middleName, DataType.VarChar)
{
Size = 255
},
new DataParameter("@LastName", lastName, DataType.VarChar)
{
Size = 255
},
new DataParameter("@Gender", gender, DataType.VarChar)
{
Size = 255
}
};
return(dataConnection.ExecuteProc("[Person_Insert]", parameters));
}
