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