public static Int32 Delete(IInvoiceSchedule invoice)
{
SqlParameter[] _parameters =
{
new SqlParameter("@InvoiceNo", invoice.InvoiceNo)
, new SqlParameter("@SysModifier", invoice.SysModifier)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, "sp_Invoices_ScheduleDelete", _parameters)));
}
public static Int32 Insert(IInvoiceSchedule invoice)
{
SqlParameter[] _parameters =
{
new SqlParameter("@InvoiceNo", invoice.InvoiceNo)
, new SqlParameter("@DateSent", invoice.DateSent)
, new SqlParameter("@SysCreator", invoice.SysCreator)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, "sp_Invoices_ScheduleInsert", _parameters)));
}