public int AddInvoiceDetails(List <OrderInvoiceEntity> entity)
{
int value = 0;
try
{
// int i = 0;
ConvertEntitiesDL obj = new ConvertEntitiesDL();
DataTable table = obj.ConvertInvoiceOrderUpdateListToDataTable(entity);
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
SqlCommand cmd = new SqlCommand("[spUpdateInvoiceDetails]", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter customrId = cmd.Parameters.AddWithValue("@tblInvoiceUpdate", table);
value = Convert.ToInt32(cmd.ExecuteScalar());
}
}
catch (Exception ex)
{
}
return(value);
}
