private string GetInvoiceNumber() { string invNumber = ""; DataRow row = _iField.GetInvoiceTitleDataRow(); if (row != null) { invNumber = Convert.ToString(row["invoiceNo"]); } return(invNumber); }
public override void CopyNotes(int myParentID, int newParentID, int myID, int newID) { //Build Note to customer var iField = new InvoiceField(myID); DataRow row = iField.GetInvoiceTitleDataRow(); string note = "This Invoice supercedes invoice No. "; string invNo = Convert.ToString(row["invoiceNo"]); note += invNo; int rev = Convert.ToInt32(row["Revision"]) - 1; if (rev > 0) { string revStr = " Rev " + rev.ToString(); note += revStr; } //Write the note to db using (var Connection = new SqlConnection(SalesCenterConfiguration.ConnectionString)) { string UpdateString = "UPDATE [Sales_JobMasterList_Invoice] SET [Note] = @Note WHERE [invoiceID] = @InvoiceID"; var UPdateCommand = new SqlCommand(UpdateString, Connection); UPdateCommand.Parameters.Add("@InvoiceID", SqlDbType.Int).Value = newID; UPdateCommand.Parameters.Add("@Note", SqlDbType.NVarChar, 500).Value = note; try { Connection.Open(); UPdateCommand.ExecuteNonQuery(); } catch (SqlException ex) { string errorlog = ex.Message; } finally { Connection.Close(); } } }