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