public override void UpdateContentFields(object jobID, object estRevID, DataRow rowNew)
{
//New Version
var pcv = new ProjectChildrenVersion(Convert.ToInt32(jobID));
rowNew["quoteRev"] = pcv.NewestQuoteRev;
rowNew["isssueDate"] = DateTime.Today;
if (Convert.ToInt32(rowNew["quoteStatus"]) == (int)NJobStatus.win)
{
rowNew["quoteStatus"] = (int)NJobStatus.qProcessing;
rowNew["contractNumber"] = DBNull.Value;
rowNew["contractAmount"] = DBNull.Value;
rowNew["contractDate"] = DBNull.Value;
}
}
public void GenerateTitle()
{
//generate Quote Title
var connectionSQL = new SqlConnection(SalesCenterConfiguration.ConnectionString);
//Get Row Schema
const string sqlSelectString = "SELECT * FROM Sales_JobMasterList_quoteRev WHERE (quoteRevID =0)";
var selectCommand = new SqlCommand(sqlSelectString, connectionSQL);
var adapter1 = new SqlDataAdapter(selectCommand);
var ds1 = new DataSet();
ds1.Tables.Clear();
try
{
connectionSQL.Open();
adapter1.Fill(ds1, "t1");
DataRow row = ds1.Tables["t1"].NewRow();
var pcv = new ProjectChildrenVersion(_jobID);
row["quoteRev"] = pcv.NewestQuoteRev;
row["quoteOption"] = 0;
row["quoteAmount"] = 0;
row["quoteStatus"] = NJobStatus.qProcessing;
row["estRevID"] = _estRevID;
row["isssueDate"] = DateTime.Today;
var cst = new CustomerDetails(_cID);
row["termBalance"] = cst.TermID;
row["Currency"] = cst.Currency;
row["termDeposit"] = cst.TermDeposit;
row["jobID"] = _jobID;
row["quoteGST"] = true;
row["quotePST"] = false;
row["quoteLocked"] = false;
row["isItemCopied"] = false;
row["PrintOption"] = 1;
row["DiscountText"] = "Discount";
row["DiscountAmount"] = 0;
var est = new MyEstRev(_estRevID);
row["sa1ID"] = est.Value.sa1ID;
//Add this into dataset
ds1.Tables["t1"].Rows.Add(row);
var cb = new SqlCommandBuilder(adapter1);
adapter1 = cb.DataAdapter;
adapter1.Update(ds1, "t1");
}
catch (SqlException ex)
{
string result = ex.Message;
}
finally
{
connectionSQL.Close();
}
}
