public int AddNewInvoice(List <OrderInvoiceEntity> entity)
{
ConvertEntitiesDL obj = new ConvertEntitiesDL();
DataTable table = obj.ConvertInvoiceOrderListToDataTable(entity);
using (SqlConnection myConnection = new SqlConnection(cs))
{
using (SqlCommand cmd = new SqlCommand("spInsertInvoiceDetails", myConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
myConnection.Open();
SqlParameter customrId = cmd.Parameters.AddWithValue("@tblInvoice", table);
return((int)cmd.ExecuteScalar());
}
}
}
