public int AddUploadInvoiceFile(List <OrderInvoiceEntity> entity)
{
ConvertEntitiesDL obj = new ConvertEntitiesDL();
DataTable table = obj.ConvertInvoiceUploadListToDataTable(entity);
using (SqlConnection myConnection = new SqlConnection(cs))
{
using (SqlCommand cmd = new SqlCommand("spUpdateInvoiceOrderUpload", myConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
myConnection.Open();
SqlParameter customrId = cmd.Parameters.AddWithValue("@INVOICEORDERNO", table.Rows[0][0].ToString());
SqlParameter Comment = cmd.Parameters.AddWithValue("@UPLOADFILENAME", table.Rows[0][1].ToString());
return((int)cmd.ExecuteScalar());
}
}
}
