private int GetChildrenCount()
{
int cc = 0;
DataTable tbl = EstItemCommon.GetEstimationItems(_estRevID);
if (tbl != null)
{
cc = tbl.Rows.Count;
}
return(cc);
}
public void Generate()
{
DataTable tbl = EstItemCommon.GetEstimationItems(_estRevID);
if (tbl == null)
{
return;
}
foreach (DataRow row in tbl.Rows)
{
var qi = new QuoteItemGenerateFromEstimationSingleItem(_quoteRevID, row);
qi.Generate();
}
}
public int Generate(int estItemID)
{
int id = 0;
DataTable tbl = EstItemCommon.GetEstimationItems(_estRevID, estItemID);
if (tbl == null)
{
return(id);
}
foreach (DataRow row in tbl.Rows)
{
var qi = new QuoteItemGenerateFromEstimationSingleItem(_quoteRevID, row);
qi.Generate();
id = qi.NewlyInsertedQuoteItemID;
}
return(id);
}
public void Refresh(int estRevID)
{
//Drawing Items
DrawingRequisitionItems = _db.Sales_Dispatching_DrawingRequisition_EstimationItem.Where(x => x.RequisitionID == RequisitionID).ToList();
if (DrawingRequisitionItems.Any())
{
foreach (var drwItem in DrawingRequisitionItems)
{
drwItem.ItemName = EstItemCommon.GetFullItemName(drwItem.EST_Item);
}
}
IsThereActiveItems = DrawingRequisitionItems.Where(x => x.IsIncludedWhenPrint).ToList().Any();
var estItems = _db.EST_Item.Where(x => x.EstRevID == estRevID &&
x.ItemPurposeID == (short)NEstItemPurpose.ForEstimation &&
!x.Sales_Dispatching_DrawingRequisition_EstimationItem.Any()
).ToList();
AvailableEstItems = new List <MyLongKeyValueBool>();
if (!estItems.Any( ))
{
return;
}
foreach (var estItem in estItems)
{
var sli = new MyLongKeyValueBool
{
Key = estItem.EstItemID,
Value1 = EstItemCommon.GetFullItemName(estItem),
Value2 = estItem.Description,
IsChecked = true,
};
AvailableEstItems.Add(sli);
}
}
public void Generate()
{
DataTable tbl = EstItemCommon.GetEstimationItems(_estRevID);
if (tbl != null)
{
//
//2. Define the destination: InvoiceItem
var connectionSQL = new SqlConnection(SalesCenterConfiguration.ConnectionString);
const string sqlSelectString2 = "SELECT * FROM [Invoice_Item] WHERE ([quoteItemID] = 0) ";
var selectCommand2 = new SqlCommand(sqlSelectString2, connectionSQL);
var adapter2 = new SqlDataAdapter(selectCommand2);
var ds2 = new DataSet();
ds2.Tables.Clear();
try
{
connectionSQL.Open();
//define row
adapter2.Fill(ds2, "t2");
foreach (DataRow row in tbl.Rows)
{
DataRow rowNew = ds2.Tables["t2"].NewRow();
rowNew["quoteRevID"] = _invoiceID;
int fwJobTypeRequriedmentID = Convert.ToInt32(row["RequirementID"]);
var sp = new SupplyType(fwJobTypeRequriedmentID);
rowNew["supplyType"] = sp.QuoteSupplyTypeID;
rowNew["qiPrintOrder"] = row["estItemNo"];
rowNew["quoteOption"] = row["ItemOption"];
rowNew["isFinal"] = row["isFinalOption"];
rowNew["estItemID"] = row["estItemID"];
rowNew["qiItemTitle"] = row["ProductName"];
string copyDetails = SalesCenterConfiguration.CopyDetailsToInvoice;
if (copyDetails.Trim().ToLower() == "yes")
{
rowNew["qiDescription"] = row["Description"];
}
else
{
rowNew["qiDescription"] = DBNull.Value;
}
rowNew["recordType"] = "I";
rowNew["qiQty"] = row["Qty"];
rowNew["qiQtyPC"] = row["QtyPc"];
double qiAmount = MyConvert.ConvertToDouble(row["estimatorPrice"]);
rowNew["qiAmount"] = qiAmount;
rowNew["qiUnitPrice"] = 0;
//to be defined in estimation
rowNew["estItemID"] = row["estItemID"];
rowNew["Requirement"] = row["RequirementID"];
//rowNew["Position"] = row["Position"];
rowNew["Position"] = "Indoor";
int s = MyConvert.ConvertToInteger(row["SerialID"]);
rowNew["SerialID"] = "E" + string.Format("{0:D2}", s);
rowNew["nameDetailsID"] = row["ProductID"];
ds2.Tables["t2"].Rows.Add(rowNew);
}
//4. Write ds2, back to DB
var cb = new SqlCommandBuilder(adapter2);
adapter2 = cb.DataAdapter;
adapter2.Update(ds2, "t2");
}
catch (SqlException ex)
{
string errorLog = ex.Message;
}
finally
{
connectionSQL.Close();
}
}
}
