protected void Button_Submit_Click(object sender, EventArgs e)
{
if (FileUpload1 != null && FileUpload1.HasFile)
{
BackEndObjects.DefectDetails defObj = BackEndObjects.DefectDetails.getDefectDetailsbyidDB(Request.QueryString.GetValues("contextId1")[0]);
defObj.setFileStream(FileUpload1);
try
{
BackEndObjects.DefectDetails.updateorInsertDefectDocDB(defObj);
Label_Upload_Stat.Visible = true;
Label_Upload_Stat.Text = "Document Uploaded Successfully";
Label_Upload_Stat.ForeColor = System.Drawing.Color.Green;
String docName = "";
if (defObj.getDocPath() != null)
{
String[] docPathList = defObj.getDocPath().
Split(new String[] { "\\" }, StringSplitOptions.RemoveEmptyEntries);
if (docPathList.Length > 0)
{
docName = docPathList[docPathList.Length - 1];
}
}
LinkButton_Existing_Doc.Text = docName;
String context = Request.QueryString.GetValues("contextId")[0];
String dataItemIndex = Request.QueryString.GetValues("dataItemIndex")[0];
if (context.Equals("incoming"))
{
DataTable dt = (DataTable)Session[SessionFactory.ALL_DEFECT_ALL_INCOMING_DEFECT_GRID];
dt.Rows[Int32.Parse(dataItemIndex)]["docNameHidden"] = docName;
dt.DefaultView.Sort = "Submit Date Ticks" + " " + "DESC";
Session[SessionFactory.ALL_DEFECT_ALL_INCOMING_DEFECT_GRID] = dt.DefaultView.ToTable();
ScriptManager.RegisterStartupScript(this, typeof(string), "RefreshDefectGridIncm", "RefreshParentIncm();", true);
}
else
{
DataTable dt = (DataTable)Session[SessionFactory.ALL_DEFECT_ALL_OUTGOING_DEFECT_GRID];
dt.Rows[Int32.Parse(dataItemIndex)]["docNameHidden"] = docName;
dt.DefaultView.Sort = "Submit Date Ticks" + " " + "DESC";
Session[SessionFactory.ALL_DEFECT_ALL_OUTGOING_DEFECT_GRID] = dt.DefaultView.ToTable();
ScriptManager.RegisterStartupScript(this, typeof(string), "RefreshDefectGridIncm", "RefreshParentIncm();", true);
}
}
catch (Exception ex)
{
Label_Upload_Stat.Visible = true;
Label_Upload_Stat.Text = "Document Upload Failed";
Label_Upload_Stat.ForeColor = System.Drawing.Color.Red;
}
}
}
protected void fillDefectGrid(Dictionary <String, DefectDetails> defectDictPassed)
{
DataTable dt = new DataTable();
dt.Columns.Add("DefectId");
dt.Columns.Add("RFQId");
dt.Columns.Add("InvNo");
dt.Columns.Add("descr");
dt.Columns.Add("Submit Date");
dt.Columns.Add("Close Date");
dt.Columns.Add("Amount");
dt.Columns.Add("Defect_Stat");
dt.Columns.Add("Defect_Stat_Reason");
dt.Columns.Add("Assigned_To");
dt.Columns.Add("Severity");
dt.Columns.Add("Defect_Resol_Stat");
Dictionary <String, DefectDetails> defectDict = new Dictionary <string, DefectDetails>();
if (defectDictPassed == null)
{
defectDict = BackEndObjects.DefectDetails.getAllDefectDetailsforInvoiceIdDB(Request.QueryString.GetValues("contextId1")[0]);
}
else
{
defectDict = defectDictPassed;
}
int counter = 0;
DateUtility dU = new DateUtility();
foreach (KeyValuePair <String, DefectDetails> kvp in defectDict)
{
BackEndObjects.DefectDetails defObj = kvp.Value;
dt.Rows.Add();
dt.Rows[counter]["DefectId"] = defObj.getDefectId();
dt.Rows[counter]["RFQId"] = defObj.getRFQId();
dt.Rows[counter]["InvNo"] = defObj.getInvoiceId();
dt.Rows[counter]["descr"] = defObj.getDescription();
dt.Rows[counter]["Submit Date"] = dU.getConvertedDate(defObj.getDateCreated());
dt.Rows[counter]["Close Date"] = dU.getConvertedDate(defObj.getCloseDate() != null && !defObj.getCloseDate().Equals("") ? defObj.getCloseDate() : "");
dt.Rows[counter]["Amount"] = defObj.getTotalAmount();
dt.Rows[counter]["Defect_Stat"] = defObj.getDefectStat();
dt.Rows[counter]["Defect_Stat_Reason"] = defObj.getStatReason();
dt.Rows[counter]["Assigned_To"] = defObj.getAssignedToUser();
dt.Rows[counter]["Severity"] = defObj.getSeverity();
dt.Rows[counter]["Defect_Resol_Stat"] = defObj.getResolStat();
counter++;
}
if (defectDict.Count > 0)
{
GridView_Defects.Visible = true;
GridView_Defects.DataSource = dt;
GridView_Defects.DataBind();
}
else
{
Label_Empty_Grid.Visible = true;
}
//Dont show assigned to for outgoing defects
String context = Request.QueryString.GetValues("contextId2")[0];
if (context != null && !context.Equals("vendor"))
{
GridView_Defects.Columns[9].Visible = false;
}
}
protected void fillOutgoingDefectGrid(Dictionary <String, DefectDetails> defectDictPassed)
{
String[] contactEntId = Request.QueryString.GetValues("contactId");
DataTable dt = new DataTable();
dt.Columns.Add("DefectId");
dt.Columns.Add("RFQId");
dt.Columns.Add("InvNo");
dt.Columns.Add("descr");
dt.Columns.Add("Submit Date");
dt.Columns.Add("Amount");
dt.Columns.Add("Defect_Stat");
dt.Columns.Add("Defect_Stat_Reason");
//dt.Columns.Add("Assigned_To");
dt.Columns.Add("Severity");
dt.Columns.Add("Defect_Resol_Stat");
Dictionary <String, DefectDetails> defectDict = new Dictionary <string, DefectDetails>();
if (defectDictPassed == null)
{
defectDict = BackEndObjects.DefectDetails.getAllDefectDetailsforCustomerIdDB(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
}
else
{
defectDict = defectDictPassed;
}
int counter = 0;
DateUtility dU = new DateUtility();
foreach (KeyValuePair <String, DefectDetails> kvp in defectDict)
{
BackEndObjects.DefectDetails defObj = kvp.Value;
String suplId = defObj.getSupplierId();
if (suplId != null && suplId.Equals(contactEntId[0]))
{
dt.Rows.Add();
dt.Rows[counter]["DefectId"] = defObj.getDefectId();
dt.Rows[counter]["RFQId"] = defObj.getRFQId();
dt.Rows[counter]["InvNo"] = defObj.getInvoiceId();
dt.Rows[counter]["descr"] = defObj.getDescription();
dt.Rows[counter]["Submit Date"] = dU.getConvertedDate(defObj.getDateCreated());
dt.Rows[counter]["Amount"] = defObj.getTotalAmount();
dt.Rows[counter]["Defect_Stat"] = defObj.getDefectStat();
dt.Rows[counter]["Defect_Stat_Reason"] = defObj.getStatReason();
//dt.Rows[counter]["Assigned_To"] = defObj.getAssignedToUser();
dt.Rows[counter]["Severity"] = defObj.getSeverity();
dt.Rows[counter]["Defect_Resol_Stat"] = defObj.getResolStat();
counter++;
}
}
GridView_Outgoing_Defects.Visible = true;
GridView_Outgoing_Defects.DataSource = dt;
GridView_Outgoing_Defects.DataBind();
Session[SessionFactory.ALL_CONTACT_ALL_DEFECT_OUTGOING_DEF_GRID] = dt;
Session[SessionFactory.ALL_CONTACT_ALL_DEFECT_OUTGOING_DEF_DICTIONARY] = defectDictPassed;
}
protected Dictionary <String, String> getContentTypeandPath()
{
ActionLibrary.ImageContextFactory icObj = (ActionLibrary.ImageContextFactory)Session[SessionFactory.DISP_IMAGE_CONTEXT_FACTORY_OBJ];
DataTable dt = new DataTable();
dt.Columns.Add("img");
String serverPath = "";
String contentType = "";
Dictionary <String, String> pathAndContent = new Dictionary <string, string>();
switch (icObj.getParentContextName())
{
case ActionLibrary.ImageContextFactory.PARENT_CONTEXT_NOTES:
if (icObj.getDestinationContextName().Equals
(ActionLibrary.ImageContextFactory.DESTINATION_CONTEXT_DOC_FOR_PARENT_NOTE))
{
serverPath = BackEndObjects.Communications.getCommunicationbyIdDB(icObj.getParentContextValue()).getDocPath();
contentType = getMimeType(serverPath);
}
break;
case ActionLibrary.ImageContextFactory.PARENT_CONTEXT_REQUIREMENT:
int counter = 0;
if (icObj.getDestinationContextName().Equals
(ActionLibrary.ImageContextFactory.DESTINATION_CONTEXT_FEAT_FOR_PARENT_REQUIREMENT))
{
String prodCatId = icObj.getChildContextObjects()[ActionLibrary.ImageContextFactory.CHILD_CONTEXT_PRODCAT_ID],
featId = icObj.getChildContextObjects()[ActionLibrary.ImageContextFactory.CHILD_CONTEXT_FEAT_ID];
ArrayList reqSpecList = BackEndObjects.Requirement_Spec.getRequirementSpecsforReqbyIdDB(icObj.getParentContextValue());
for (int i = 0; i < reqSpecList.Count; i++)
{
BackEndObjects.Requirement_Spec reqrObj = (Requirement_Spec)reqSpecList[i];
if (reqrObj.getProdCatId().Equals(prodCatId) && reqrObj.getFeatId().Equals(featId))
{
serverPath = reqrObj.getImgPath();
//dt.Rows.Add();
//dt.Rows[counter]["img"] = serverPath;
contentType = getMimeType(serverPath);
counter++;
}
}
}
break;
case ActionLibrary.ImageContextFactory.PARENT_CONTEXT_RFQ:
if (icObj.getDestinationContextName().Equals(ActionLibrary.ImageContextFactory.DESTINATION_CONTEXT_FEAT_FOR_PARENT_RFQ))
{
String prodCatId = icObj.getChildContextObjects()[ActionLibrary.ImageContextFactory.CHILD_CONTEXT_PRODCAT_ID],
featId = icObj.getChildContextObjects()[ActionLibrary.ImageContextFactory.CHILD_CONTEXT_FEAT_ID];
ArrayList rfqSpecList = BackEndObjects.RFQProductServiceDetails.getAllProductServiceDetailsbyRFQIdDB(icObj.getParentContextValue());
counter = 0;
for (int i = 0; i < rfqSpecList.Count; i++)
{
BackEndObjects.RFQProductServiceDetails rfqObj = (RFQProductServiceDetails)rfqSpecList[i];
if (rfqObj.getPrdCatId().Equals(prodCatId) && rfqObj.getFeatId().Equals(featId))
{
serverPath = rfqObj.getImgPath();
//dt.Rows.Add();
//dt.Rows[counter]["img"] = serverPath;
contentType = getMimeType(serverPath);
counter++;
}
}
}
if (icObj.getDestinationContextName().Equals(ActionLibrary.ImageContextFactory.DESTINATION_CONTEXT_NDA_FOR_PARENT_RFQ))
{
serverPath = BackEndObjects.RFQDetails.getRFQDetailsbyIdDB(icObj.getParentContextValue()).getNDADocPath();
//dt.Rows.Add();
//dt.Rows[0]["img"] = serverPath;
contentType = getMimeType(serverPath);
}
break;
case ActionLibrary.ImageContextFactory.PARENT_CONTEXT_RFQ_RESPONSE:
if (icObj.getDestinationContextName().Equals(ActionLibrary.ImageContextFactory.DESTINATION_CONTEXT_NDA_FOR_PARENT_RFQ_RESPONSE))
{
serverPath = BackEndObjects.RFQResponse.
getRFQResponseforRFQIdandResponseEntityIdDB
(icObj.getParentContextValue(),
(icObj.getChildContextObjects()[ActionLibrary.ImageContextFactory.CHILD_CONTEXT_RFQ_RESPONSE_RESPONSE_ENTITY_ID]).ToString()).getNdaPath();
contentType = getMimeType(serverPath);
//dt.Rows.Add();
//dt.Rows[0]["img"] = serverPath;
}
break;
case ActionLibrary.ImageContextFactory.PARENT_CONTEXT_PRODUCT:
if (icObj.getDestinationContextName().Equals(ActionLibrary.ImageContextFactory.DESTINATION_CONTEXT_FEAT_FOR_PARENT_PRODUCT))
{
String prodName = icObj.getParentContextValue();
String entId = icObj.getChildContextObjects()[ActionLibrary.ImageContextFactory.CHILD_CONTEXT_PROD_ENT_ID];
String featId = icObj.getChildContextObjects()[ActionLibrary.ImageContextFactory.CHILD_CONTEXT_PROD_FEAT_ID];
ShopChildProdsSpecs specObj = (ShopChildProdsSpecs)ShopChildProdsSpecs.
getShopChildProdsSpecObjbyEntIdandProdNameDB(entId, prodName)[featId];
serverPath = specObj.getImgPath();
contentType = getMimeType(serverPath);
}
break;
case ActionLibrary.ImageContextFactory.PARENET_CONTEXT_DEFECT:
if (icObj.getDestinationContextName().Equals(ActionLibrary.ImageContextFactory.DESTINATION_CONTEXT_DOC_FOR_PARENT_DEFECT))
{
String defectId = icObj.getParentContextValue();
BackEndObjects.DefectDetails defObj = BackEndObjects.DefectDetails.getDefectDetailsbyidDB(defectId);
serverPath = defObj.getDocPath();
contentType = getMimeType(serverPath);
}
break;
}
pathAndContent.Add(SERVER_PATH, serverPath);
pathAndContent.Add(CONTENT_TYPE, contentType);
return(pathAndContent);
}