private static void BuildBillPurpParameter(BillPurpose billpurp, string statement)
{
if (statement == "update")
{
cmd.Parameters.Add(new SqlParameter("@id", billpurp.Id));
}
cmd.Parameters.Add(new SqlParameter("@name", billpurp.Name));
cmd.Parameters.Add(new SqlParameter("@description", billpurp.Description));
cmd.Parameters.Add(new SqlParameter("@statusid", billpurp.StatusID));
}
private static BillPurpose BindPurposeProperties(BillPurpose obj, ref SqlDataReader reader)
{
while (reader.Read())
{
obj.Name = reader.GetString(0);
if (!reader.GetSqlString(1).IsNull)
{
obj.Description = reader.GetString(1);
}
obj.Id = (int)reader.GetSqlInt32(3);
if (!reader.GetSqlInt32(4).IsNull)
{
obj.StatusID = (int)reader.GetInt32(4);
}
}
return(obj);
}
