protected void fillFirstGrid()
{
String entId = Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString();
String prodName = Session[SessionFactory.ALL_PRODUCT_SELECTED_PRODUCT_NAME].ToString();
Dictionary <String, ShopChildProdsSpecs> prodSpecDict = BackEndObjects.ShopChildProdsSpecs.
getShopChildProdsSpecObjbyEntIdandProdNameDB(entId, prodName);
Dictionary <String, String> existingFeatList = new Dictionary <string, string>();
DataTable dt = new DataTable();
dt.Columns.Add("FeatId");
dt.Columns.Add("FeatName");
dt.Columns.Add("SpecText");
dt.Columns.Add("FromSpec");
dt.Columns.Add("ToSpec");
dt.Columns.Add("imgName");
int counter = 0;
foreach (KeyValuePair <String, ShopChildProdsSpecs> kvp in prodSpecDict)
{
ShopChildProdsSpecs specObj = (ShopChildProdsSpecs)kvp.Value;
dt.Rows.Add();
existingFeatList.Add(specObj.getFeatId(), specObj.getFeatId());
dt.Rows[counter]["FeatId"] = specObj.getFeatId();
dt.Rows[counter]["FeatName"] = Features.getFeaturebyIdwoSpecDB(specObj.getFeatId()).getFeatureName();
dt.Rows[counter]["SpecText"] = specObj.getSpecText();
if (!specObj.getFromSpecId().Equals(""))
{
dt.Rows[counter]["FromSpec"] = Specifications.getSpecificationDetailbyIdDB(specObj.getFromSpecId()).getSpecName();
}
if (!specObj.getToSpecId().Equals(""))
{
dt.Rows[counter]["ToSpec"] = Specifications.getSpecificationDetailbyIdDB(specObj.getToSpecId()).getSpecName();
}
String[] imgPath = specObj.getImgPath().Split(new String[] { "\\" }, StringSplitOptions.RemoveEmptyEntries);
dt.Rows[counter]["imgName"] = (imgPath != null && imgPath.Length > 0 ? imgPath[imgPath.Length - 1] : "N\\A");
counter++;
}
GridView1.DataSource = dt;
GridView1.DataBind();
GridView1.Visible = true;
GridView1.Columns[2].Visible = false;
Session[SessionFactory.PRODUCT_SPECIFICATION_EXISTING_FEAT_LIST] = existingFeatList;
Session[SessionFactory.ALL_PROD_SPECIFICATION_DATAGRID] = dt;
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
DataTable dt = (DataTable)Session[SessionFactory.ALL_PROD_SPECIFICATION_DATAGRID];
String prodName = Session[SessionFactory.ALL_PRODUCT_SELECTED_PRODUCT_NAME].ToString();
String fromSpecText = ((DropDownList)GridView1.Rows[e.RowIndex].Cells[0].FindControl("DropDownList_From_Spec_Edit")).SelectedItem != null ?
((DropDownList)GridView1.Rows[e.RowIndex].Cells[0].FindControl("DropDownList_From_Spec_Edit")).SelectedItem.Text : "";
String fromSpecId = ((DropDownList)GridView1.Rows[e.RowIndex].Cells[0].FindControl("DropDownList_From_Spec_Edit")).SelectedValue != null ?
((DropDownList)GridView1.Rows[e.RowIndex].Cells[0].FindControl("DropDownList_From_Spec_Edit")).SelectedValue:"";
String ToSpecText = ((DropDownList)GridView1.Rows[e.RowIndex].Cells[0].FindControl("DropDownList_To_Spec_Edit")).SelectedItem != null ?
((DropDownList)GridView1.Rows[e.RowIndex].Cells[0].FindControl("DropDownList_To_Spec_Edit")).SelectedItem.Text:"";
String ToSpecId = ((DropDownList)GridView1.Rows[e.RowIndex].Cells[0].FindControl("DropDownList_To_Spec_Edit")).SelectedValue != null ?
((DropDownList)GridView1.Rows[e.RowIndex].Cells[0].FindControl("DropDownList_To_Spec_Edit")).SelectedValue:"";
String specText = ((TextBox)GridView1.Rows[e.RowIndex].Cells[0].FindControl("TextBox_SpecText_Edit")).Text;
int index = GridView1.Rows[e.RowIndex].DataItemIndex;
dt.Rows[index]["SpecText"] = specText;
dt.Rows[index]["FromSpec"] = fromSpecText;
dt.Rows[index]["ToSpec"] = ToSpecText;
String updatedImgPath = "";
Dictionary <String, String> whereCls = new Dictionary <string, string>();
Dictionary <String, String> targetVals = new Dictionary <string, string>();
whereCls.Add(BackEndObjects.ShopChildProdsSpecs.SHOP_CHILD_PROD_SPEC_COL_PROD_NAME, prodName);
whereCls.Add(BackEndObjects.ShopChildProdsSpecs.SHOP_CHILD_PROD_SPEC_COL_ENTITY_ID, Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
whereCls.Add(BackEndObjects.ShopChildProdsSpecs.SHOP_CHILD_PROD_SPEC_COL_FEAT_ID, ((Label)GridView1.Rows[e.RowIndex].Cells[0].FindControl("Label_Hidden_Feat")).Text);
if (!((FileUpload)GridView1.Rows[e.RowIndex].Cells[0].FindControl("FileUpload_Image")).HasFile)
{
targetVals.Add(BackEndObjects.ShopChildProdsSpecs.SHOP_CHILD_PROD_SPEC_COL_FROM_SPEC_ID, fromSpecId);
targetVals.Add(BackEndObjects.ShopChildProdsSpecs.SHOP_CHILD_PROD_SPEC_COL_TO_SPEC_ID, ToSpecId);
targetVals.Add(BackEndObjects.ShopChildProdsSpecs.SHOP_CHILD_PROD_SPEC_COL_SPEC_TEXT, specText);
BackEndObjects.ShopChildProdsSpecs.updateShopChildProdsSpecsDB(targetVals, whereCls, DBConn.Connections.OPERATION_UPDATE);
}
else
{
//Remove the entry and re-create
BackEndObjects.ShopChildProdsSpecs.updateShopChildProdsSpecsDB(targetVals, whereCls, DBConn.Connections.OPERATION_DELETE);
BackEndObjects.ShopChildProdsSpecs specObj = new ShopChildProdsSpecs();
specObj.setEntityId(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
specObj.setFeatId(((Label)GridView1.Rows[e.RowIndex].Cells[0].FindControl("Label_Hidden_Feat")).Text);
specObj.setFileStream(((FileUpload)GridView1.Rows[e.RowIndex].Cells[0].FindControl("FileUpload_Image")));
specObj.setFromSpecId(fromSpecId);
specObj.setSpecText(specText);
specObj.setToSpecId(ToSpecId);
specObj.setProdName(prodName);
specObj.setImgPathInFileStore(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
BackEndObjects.ShopChildProdsSpecs.insertShopChildProdsSpecsDB(specObj);
String[] imgPath = specObj.getImgPath().Split(new String[] { "\\" }, StringSplitOptions.RemoveEmptyEntries);
dt.Rows[index]["imgName"] = (imgPath != null && imgPath.Length > 0 ? imgPath[imgPath.Length - 1] : "N\\A");
updatedImgPath = specObj.getImgPath();
}
Session[SessionFactory.ALL_PROD_SPECIFICATION_DATAGRID] = dt;
GridView1.EditIndex = -1;
GridView1.DataSource = dt;
GridView1.DataBind();
}
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);
}