protected void btnSendEnquiry_Click(object sender, EventArgs e)
{
WorkFlow objWorkFlow = new WorkFlow();
objWorkFlow.WFID = Convert.ToInt32(Request.QueryString["WFID"]);
DataTable dt1 = objWorkFlow.GetWFById();
objWorkFlow.Parent_WFID = Convert.ToInt32(dt1.Rows[0]["Parent_WFID"]);
objWorkFlow.WF_Status = "Enquiry For Techno Commercial Negotiation Completed";
objWorkFlow.Project = dt1.Rows[0]["Project"].ToString().Substring(0, 6);
//int res = objWorkFlow.UpdateEnquiryRaised();
int res = objWorkFlow.UpdateTechnoCommercialNegotiationCompleted();
objWorkFlow.UpdateWF_StatusInBAANTable();// Dump Preorder Data TO BAAN table change 25/08/2018 sagar
if (res > 0)
{
InsertPreHistory(Convert.ToInt32(Request.QueryString["WFID"]), "Enquiry For Techno Commercial Negotiation Completed");
}
#region ERP Transaction Update for Control Tower
//if (Request.QueryString["Status"] == "Enquiry Raised" || Request.QueryString["Status"] == "Technical offer Received")
// {
objWorkFlow.TransactionDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
objWorkFlow.BusinessObjectHandle = "CT_RFQCOMMERCIALFINALISED";
objWorkFlow.IndexValue = (Request.QueryString["WFID"]).ToString();
int SerialNoCount = objWorkFlow.GetSerialNumber();
SerialNoCount++;
objWorkFlow.SLNO_WFID = SerialNoCount;
string[] Project = txtProject.Text.Split('-');
objWorkFlow.Project = Project[0];
string[] Element = txtElement.Text.Split('-');
objWorkFlow.Element = Element[0];
objWorkFlow.UserId = Request.QueryString["u"];
int nRecordInserted = objWorkFlow.InsertPreOrderDatatoControlTower();
if (nRecordInserted > 0)
{
// for each PMDL doc insert a new record ( Sagar new change 11-July-2018)
// 2 ways- comma seperated substring or select PMDLDoc for given WFID from WF1_PreOrderPMDL table
//and loop through each PMDL doc.
int DetailSerialNoCount = 0;
DataTable dtPMDL = objWorkFlow.GetMultiPMDL(hdfParentWFID.Value);
if (dtPMDL.Rows.Count > 0)
{
foreach (DataRow dr in dtPMDL.Rows)
{
DetailSerialNoCount = objWorkFlow.GetDetailSerialNumber();
DetailSerialNoCount++;
objWorkFlow.DetailSerialCount = DetailSerialNoCount;
objWorkFlow.PMDLdocDesc = dr["PMDLDocNo"].ToString();
DataTable dt = objWorkFlow.GetPartItemCount_Weight();
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["PartItemCount"].ToString() != "")
{
objWorkFlow.PartItemCount = (int)dt.Rows[0]["PartItemCount"];
}
else
{
objWorkFlow.PartItemCount = 0;
}
if (dt.Rows[0]["PartItenWeight"].ToString() != "")
{
objWorkFlow.PartItemWeight = (double)dt.Rows[0]["PartItenWeight"];
}
else
{
objWorkFlow.PartItemWeight = 0;
}
}
else
{
objWorkFlow.PartItemCount = 0;
objWorkFlow.PartItemWeight = 0;
}
objWorkFlow.InsertPreOrderDatatoControlTowerChildTable();
//if (Request.QueryString["Status"] == "Technical offer Received")
//{
double nTechnoComNegotiationrawingCount = 0;
double nTotalDrawingCount = 0;
double nTotalChildRecordCount = 0;
double nTechnoCommNegotiationWeight = 0;
double nTotalWeight = 0;
double nQualifiedforTechnoCommercial = 0;
double nTechnoCommercialChildRecordCount = 0;
string PMDLDocs = "";
string PMDLDocuments = "";
string PMDLDocNo = "";
double percentageTechnoCommercial_byCount;
double percentageTechnoCommercial_byWeight;
DataTable dataTable1 = objWorkFlow.GetTechnoCommercialItemReference();
objWorkFlow.ItemReference = (string)dataTable1.Rows[0]["t_iref"];
string Itemref_Typ = objWorkFlow.GetItemRefType();
if (dataTable1.Rows[0]["TechnoCommercialDate"].ToString() == "01-01-1970" || dataTable1.Rows[0]["TechnoCommercialDate"].ToString() == "01-01-1900")
{
string CurrentDate = DateTime.Now.ToString("yyyy-MM-dd");
// objWorkFlow.UpdateTechnoCommercialDate(CurrentDate);
objWorkFlow.UpdateTechnoCommercialNegotiationDate(CurrentDate);
}
DataTable dtPMDLDoc = objWorkFlow.GetPMDLFromItemRef();
if (dtPMDLDoc.Rows.Count > 0)
{
for (int i = 0; i < dtPMDLDoc.Rows.Count; i++)
{
if (i == 0)
{
PMDLDocs = "'" + dtPMDLDoc.Rows[0]["t_docn"].ToString() + "'";
}
else
{
PMDLDocs += ",'" + dtPMDLDoc.Rows[i]["t_docn"].ToString() + "'";
}
}
}
DataTable dtPMDLDocForTechnoCommNegotiation = objWorkFlow.GetPMDLDocForTechnoCommNegotiation();
if (dtPMDLDocForTechnoCommNegotiation.Rows.Count > 0)
{
for (int i = 0; i < dtPMDLDocForTechnoCommNegotiation.Rows.Count; i++)
{
if (i == 0)
{
PMDLDocuments = "'" + dtPMDLDocForTechnoCommNegotiation.Rows[0]["t_docn"].ToString() + "'";
}
else
{
PMDLDocuments += ",'" + dtPMDLDocForTechnoCommNegotiation.Rows[i]["t_docn"].ToString() + "'";
}
}
}
int nWFID = objWorkFlow.WFID;
objWorkFlow.WFID = objWorkFlow.Parent_WFID;
DataTable dtStatus = objWorkFlow.GetWFById();
string sCurrentWFID_Status = dtStatus.Rows[0]["WF_Status"].ToString();
DataTable dtPMDLbyWFID = objWorkFlow.GetPMDLbyWFID();
objWorkFlow.WFID = nWFID;
if (dtPMDLbyWFID.Rows.Count > 0)
{
for (int i = 0; i < dtPMDLbyWFID.Rows.Count; i++)
{
if (i == 0)
{
PMDLDocNo = "'" + dtPMDLbyWFID.Rows[0]["PMDLDocNo"].ToString() + "'";
}
else
{
PMDLDocNo += ",'" + dtPMDLbyWFID.Rows[i]["PMDLDocNo"].ToString() + "'";
}
}
}
nTechnoCommNegotiationWeight = objWorkFlow.GetTotalWeight(PMDLDocNo);
nTotalWeight = objWorkFlow.GetTotalWeight();
nTechnoComNegotiationrawingCount += objWorkFlow.GetTechnoComNegotiationrawingCount(PMDLDocNo);
nTotalDrawingCount = objWorkFlow.GeTotalDrawingCount();
// nQualifiedforTechnoCommercial += objWorkFlow.GetQualifiedforTechnoCommercialCount();
if (sCurrentWFID_Status == "All Offer Received")
{
nTotalChildRecordCount = objWorkFlow.GetTotalChildRecordCount_AllOfferReceived(PMDLDocNo);
}
else
{
nTotalChildRecordCount = objWorkFlow.GetTotalChildRecordCount(PMDLDocNo);
}
//3
nTechnoCommercialChildRecordCount += objWorkFlow.GetTechnoCommercialChildRecordCount(PMDLDocs);
//4
//objWorkFlow.UpdateTechnoCommercialCount(nTechnoCommercialChildRecordCount);
double Technicalvettingpercentage = objWorkFlow.GetTechnicalvettingpercentage();
if (nTotalChildRecordCount != 0 && nTotalDrawingCount != 0)
{
percentageTechnoCommercial_byCount = Math.Round((nTechnoCommercialChildRecordCount / nTotalChildRecordCount) * (nTechnoComNegotiationrawingCount / nTotalDrawingCount) * 100, 2);
}
else
{
percentageTechnoCommercial_byCount = 0;
}
//percentageTechnoCommercial_byWeight
if (nTotalWeight != 0 && nTotalDrawingCount != 0)
{
// percentageTechnoCommercial_byWeight = Math.Round((nTechnoCommNegotiationWeight / nTotalWeight) * (nTechnoComNegotiationrawingCount / nTotalDrawingCount)*100, 2);
percentageTechnoCommercial_byWeight = Math.Round((nTechnoCommNegotiationWeight / nTotalWeight) * (nTechnoCommercialChildRecordCount / nTotalChildRecordCount) * 100, 2);
}
else
{
percentageTechnoCommercial_byWeight = 0;
}
objWorkFlow.InsertIntoItemReferencewiseProgressTable(percentageTechnoCommercial_byWeight, percentageTechnoCommercial_byCount);
//DataTable dtPercentage = objWorkFlow.GetTechnoComNegotiationPercentagebyCount_Weight();
DataTable dtPercentage = new DataTable();
if (sCurrentWFID_Status == "All Offer Received")
{
dtPercentage = objWorkFlow.GetPercentagebyCount_Weight_AllOfferReceievd();
}
else
{
dtPercentage = objWorkFlow.GetPercentagebyCount_Weight();
}
double percentage_byCount = 0;
double percentage_byWeight = 0;
if (dtPercentage.Rows.Count > 0)
{
foreach (DataRow dr2 in dtPercentage.Rows)
{
objWorkFlow.Project = dr2["Project"].ToString();
objWorkFlow.ItemReference = dr2["ItemReference"].ToString();
//double percentage_byCount = Convert.ToDouble(dr2["CountPercentage"]);
//double percentage_byWeight = Convert.ToDouble(dr2["WeightPercentage"]);
percentage_byCount += Convert.ToDouble(dr2["CountPercentage"]);
percentage_byWeight += Convert.ToDouble(dr2["WeightPercentage"]);
}
}
if (percentage_byCount < 100.00 && percentage_byWeight < 100.00)
{
if ((percentage_byCount >= percentage_byWeight))
{
//objWorkFlow.UpdateTechOfferReceivedDrawingpercentage(percentage_byCount);
}
else
{
if (Itemref_Typ == "4") // when item reference typ=="Self Engineered"
{
// objWorkFlow.UpdateTechOfferReceivedDrawingpercentage(percentage_byWeight);
}
else
{
// objWorkFlow.UpdateTechOfferReceivedDrawingpercentage(percentage_byCount);
}
}
}
else
{
if (percentage_byCount >= 100)
{
// objWorkFlow.UpdateTechOfferReceivedDrawingpercentage(100);
}
else
{
// objWorkFlow.UpdateTechOfferReceivedDrawingpercentage(percentage_byCount);
}
}
// }
//}
//if (percentageTechnoCommercial_byCount>= 100.00 || percentageTechnoCommercial_byWeight>=100.00)
//{
// objWorkFlow.UpdateTechOfferReceivedDrawingpercentage(100);
//}
//else if ((percentageTechnoCommercial_byCount >= percentageTechnoCommercial_byWeight))
//{
// objWorkFlow.UpdateTechOfferReceivedDrawingpercentage(percentageTechnoCommercial_byCount);
//}
//else
//{
// objWorkFlow.UpdateTechOfferReceivedDrawingpercentage(percentageTechnoCommercial_byWeight);
//}
// objWorkFlow.UpdateTechnoCommercialpercentage(percentageTechnoCommercial_byCount);
DateTime MinTechnoCommecrialDate = objWorkFlow.GetMinTechnoCommecrialDate();
if (MinTechnoCommecrialDate != default(DateTime))
{
string OfferReceieveDate = MinTechnoCommecrialDate.ToString("yyyy-MM-dd hh:mm:ss");
// objWorkFlow.UpdateTechnoCommercialDate(OfferReceieveDate);
}
}
}
else
{
Response.Redirect("RaisedEnquiry.aspx?u=" + Request.QueryString["u"] + "&WFPID=" + hdfParentWFID.Value);
}
#endregion
//if (Request.QueryString["Status"] == "Enquiry Raised")
//{
// Response.Redirect("EnquiryInProcess.aspx?u=" + Request.QueryString["u"]);
//}
//if (Request.QueryString["Status"] == "Technical offer Received" || Request.QueryString["Status"] == "Commercial offer Received")
//{
// Response.Redirect("RaisedEnquiry.aspx?u=" + Request.QueryString["u"] + "&WFPID=" + Request.QueryString["WFPID"]);
//}
//if (Request.QueryString["Status"] == "Isgec Comment Submitted")
//{
// Response.Redirect("ReleaseComments.aspx?u=" + Request.QueryString["u"]);
//}
// ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('" + Request.QueryString["Status"] + "');", true);
}
Response.Redirect("RaisedEnquiry.aspx?u=" + Request.QueryString["u"] + "&WFPID=" + hdfParentWFID.Value);
}
