protected void btnChangeSave_Click(object sender, EventArgs e) { try { if (Session["SignatureExistingData"] != null) { List <SignatureComparisionData> list = null; for (int i = 0; i < lvExistingSignature.Items.Count; i++) { if ((lvExistingSignature.Items[i].FindControl("chkSelect") as CheckBox).Checked) { list = Session["SignatureExistingData"] as List <SignatureComparisionData>; string company = (lvExistingSignature.Items[i].FindControl("hdnComany") as HiddenField).Value; string plant = (lvExistingSignature.Items[i].FindControl("hdnPlant") as HiddenField).Value; string machine = (lvExistingSignature.Items[i].FindControl("hdnMachine") as HiddenField).Value; string paremeter = (lvExistingSignature.Items[i].FindControl("lblParameter") as Label).Text; string signatureidOld = (lvExistingSignature.Items[i].FindControl("hdnSignatureID") as HiddenField).Value; string signatureid = (lvExistingSignature.Items[i].FindControl("txtSignature") as TextBox).Text.Trim(); var destiList = list.Where(k => k.Company == company && k.Plant == plant && k.MachineID == machine && k.SignatureID == signatureidOld && k.ParameterID == paremeter).Select(k => k.SignatureData).ToList(); List <SignatureComparisionDetails> finalList = new List <SignatureComparisionDetails>(); foreach (var data in destiList) { for (int j = 0; j < data.Count; j++) { SignatureComparisionDetails seqData = new SignatureComparisionDetails(); seqData.CompanyID = company; seqData.PlantID = plant; seqData.MachineID = machine; seqData.ParameterID = paremeter; seqData.SignatureID = signatureid; seqData.Frequency = data[j].Frequency; seqData.ParameterValue = data[j].ParameterValue; finalList.Add(seqData); } } list.RemoveAll(k => k.Company == company && k.Plant == plant && k.MachineID == machine && k.SignatureID == signatureidOld && k.ParameterID == paremeter); Session["SignatureExistingData"] = list;; MongoDBAccess.insertSignatureComparisonMasterData(finalList); } } if (list.Count > 0) { ScriptManager.RegisterStartupScript(this, GetType(), "openModal", "openExistingSignatureDataModal();", true); btnOverwrite.Enabled = false; btnChangeSave.Visible = false; btnChange.Visible = true; btnChangeCancel.Visible = false; lvExistingSignature.DataSource = list; lvExistingSignature.DataBind(); } } BindSignatureDetails(); } catch (Exception ex) { } }
protected void btnInsert_Click(object sender, EventArgs e) { try { List <SignatureComparisionDetails> list = new List <SignatureComparisionDetails>(); SignatureComparisionDetails master = new SignatureComparisionDetails(); master.CompanyID = ddlCompany.SelectedValue; master.PlantID = ddlPlant.SelectedValue; master.MachineID = ddlMachine.SelectedValue; master.ParameterID = (gvSignatureComparisionDetails.FooterRow.FindControl("lblParemeterIDNew") as Label).Text; master.SignatureID = (gvSignatureComparisionDetails.FooterRow.FindControl("lblSignatureIDNew") as Label).Text; master.Frequency = (gvSignatureComparisionDetails.FooterRow.FindControl("txtSecondsNew") as TextBox).Text.Trim(); master.ParameterValue = (gvSignatureComparisionDetails.FooterRow.FindControl("txtSignatureValueNew") as TextBox).Text.Trim(); list.Add(master); if (master.CompanyID == "") { ScriptManager.RegisterStartupScript(this, GetType(), "warning", "openWarningModal('Please select Company.');", true); return; } if (master.PlantID == "") { ScriptManager.RegisterStartupScript(this, GetType(), "warning", "openWarningModal('Please select Plant.');", true); return; } if (master.MachineID == "") { ScriptManager.RegisterStartupScript(this, GetType(), "warning", "openWarningModal('Please select Machine.');", true); return; } if (master.ParameterID == "") { ScriptManager.RegisterStartupScript(this, GetType(), "warning", "openWarningModal('Please select Process Parameter.');", true); return; } if (master.SignatureID == "") { ScriptManager.RegisterStartupScript(this, GetType(), "warning", "openWarningModal('Please select Signature ID.');", true); return; } if (master.Frequency == "") { ScriptManager.RegisterStartupScript(this, GetType(), "warning", "openWarningModal('Please enter Seconds.');", true); return; } if (master.ParameterValue == "") { ScriptManager.RegisterStartupScript(this, GetType(), "warning", "openWarningModal('Please enter Signature Value.');", true); return; } MongoDBAccess.insertSignatureComparisonMasterData(list); BindSignatureDetails(); } catch (Exception ex) { } }
protected void btnSave_Click(object sender, EventArgs e) { try { for (int i = 0; i < gvSignatureComparisionDetails.Rows.Count; i++) { string hdnValue = (gvSignatureComparisionDetails.Rows[i].FindControl("hdnUpdate") as HiddenField).Value; if (hdnValue.Equals("update", StringComparison.OrdinalIgnoreCase)) { string id = (gvSignatureComparisionDetails.Rows[i].FindControl("hdnID") as HiddenField).Value; SignatureComparisionDetails master = new SignatureComparisionDetails(); master.CompanyID = ddlCompany.SelectedValue; master.PlantID = ddlPlant.SelectedValue; master.MachineID = ddlMachine.SelectedValue; master.ParameterID = (gvSignatureComparisionDetails.Rows[i].FindControl("lblParemeterID") as Label).Text; master.SignatureID = (gvSignatureComparisionDetails.Rows[i].FindControl("lblSignatureID") as Label).Text; master.Frequency = (gvSignatureComparisionDetails.Rows[i].FindControl("txtSeconds") as TextBox).Text; master.ParameterValue = (gvSignatureComparisionDetails.Rows[i].FindControl("txtSignatureValue") as TextBox).Text; if (master.Frequency == "") { ScriptManager.RegisterStartupScript(this, GetType(), "warning", "openWarningModal('Please enter Seconds.');", true); return; } if (master.ParameterValue == "") { ScriptManager.RegisterStartupScript(this, GetType(), "warning", "openWarningModal('Please enter Signature Value.');", true); return; } MongoDBAccess.updateSignatureFreqAndParameterMasterDataByID(id, master); } } BindSignatureDetails(); } catch (Exception ex) { } }
protected void btnCopy_Click(object sender, EventArgs e) { try { string srcCompany = lblSrcCopyCompany.Text; string srcPlant = lblSrcCopyPlant.Text; string srcMachine = lblSrcCopyMachine.Text; string srcSignature = lblSrcCopySignature.Text; string srcParameter = lblSrcCopyParameter.Text; srcParameter = "'" + srcParameter + "'"; string destiMachine = ddlDestiCopyMachine.SelectedValue; string destiSignature = txtDestiCopySignature.Text; string destiParameter = ddlDestiCopyParameter.SelectedValue; //get source data details //BsonArray parameters = new BsonArray(); //parameters.Add(srcParameter); //var filter = "{'CompanyID':'" + srcCompany + "','PlantID':'" + srcPlant + "',MachineID: '" + srcMachine + "',SignatureID: '" + srcSignature + "',ParameterID: '" + srcParameter + "'}"; List <SignatureComparisionDetails> sourceDetails = new List <SignatureComparisionDetails>(); // sourceDetails = _MongoDatabase.GetCollection<SignatureComparisionDetails>("PP_AMGIOT_SignatureMaster").Find(filter).ToList(); sourceDetails = MongoDBAccess.getSignatureComparisonMasterData(srcCompany, srcPlant, srcMachine, srcParameter, srcSignature); List <SignatureComparisionDetails> masterList = new List <SignatureComparisionDetails>(); for (int i = 0; i < sourceDetails.Count; i++) { SignatureComparisionDetails master = new SignatureComparisionDetails(); master.CompanyID = srcCompany; master.PlantID = srcPlant; master.MachineID = destiMachine; master.ParameterID = destiParameter; master.SignatureID = destiSignature; master.Frequency = sourceDetails[i].Frequency; master.ParameterValue = sourceDetails[i].ParameterValue; masterList.Add(master); } MongoDBAccess.insertSignatureComparisonMasterData(masterList); BindSignatureDetails(); //get dsetination detail from db for validation. //BsonArray destiparameters = new BsonArray(); //destiparameters.Add(destiParameter); //var destifilter = "{MachineID: '" + destiMachine + "',SignatureID: '" + destiSignature + "',Parameter: '" + destiParameter + "'}"; //List<SignatureComparisionDetails> destiDetails = new List<SignatureComparisionDetails>(); //destiDetails = _MongoDatabase.GetCollection<SignatureComparisionDetails>("SignatureComparisionMaster").Find(destifilter).ToList(); //List<SignatureComparisionDetails> existingDataList = new List<SignatureComparisionDetails>(); //var collection = _MongoDatabase.GetCollection<SignatureComparisionDetails>("SignatureComparisionMaster"); //if (destiDetails.Count > 0) //{ // foreach (SignatureComparisionDetails item in sourceDetails) // { // //check new machine and parameter contain entered signature id // } //} //else //{ //} } catch (Exception ex) { } }
protected void btnImport_Click(object sender, EventArgs e) { try { int success = 0; string APP_PATH = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location); DataTable dtMaster = new DataTable(); if (fpFile.HasFile) { string fileName = fpFile.FileName; if (Path.GetExtension(fileName) != ".xlsx" && Path.GetExtension(fileName) != ".xls") { ScriptManager.RegisterStartupScript(this, GetType(), "RecordsTextopenModaladded", "openWarningModal('Please choose the valid .xlsx or .xls file');", true); return; } else { if (!Directory.Exists(Server.MapPath("ImportedFiles"))) { Directory.CreateDirectory(Server.MapPath("ImportedFiles")); } string savedFileName = Server.MapPath("ImportedFiles//" + fileName); fpFile.SaveAs(savedFileName); string Errormsg = ""; dtMaster = GetDataTableFromFile(savedFileName); var distinctValues = dtMaster.AsEnumerable() .Select(row => new { CompanyID = row.Field <string>("CompanyID"), PlantID = row.Field <string>("PlantID"), MachineID = row.Field <string>("MachineID"), ParameterID = row.Field <string>("ParameterID"), SignatureID = row.Field <string>("SignatureID") }).Distinct(); List <SignatureComparisionData> existingSeqList = new List <SignatureComparisionData>(); foreach (var item in distinctValues) { //if data exist store it in another list if (isSignatureDetailsExist(item.CompanyID, item.PlantID, item.MachineID, item.ParameterID, item.SignatureID)) { SignatureComparisionData existingSeqdata = new SignatureComparisionData(); existingSeqdata.Company = item.CompanyID; existingSeqdata.Plant = item.PlantID; existingSeqdata.MachineID = item.MachineID; existingSeqdata.ParameterID = item.ParameterID; existingSeqdata.SignatureID = item.SignatureID; List <SignatureComparisionDetails> seqList = new List <SignatureComparisionDetails>(); var paramSignatureList = dtMaster.AsEnumerable().Where(myRow => myRow.Field <string>("ParameterID") == item.ParameterID && myRow.Field <string>("SignatureID") == item.SignatureID); foreach (var data in paramSignatureList) { SignatureComparisionDetails seqData = new SignatureComparisionDetails(); seqData.SignatureID = data.ItemArray[4].ToString(); seqData.Frequency = data.ItemArray[5].ToString(); seqData.ParameterValue = data.ItemArray[6].ToString(); seqList.Add(seqData); } existingSeqdata.SignatureData = seqList; existingSeqList.Add(existingSeqdata); } else { List <SignatureComparisionDetails> masterList = new List <SignatureComparisionDetails>(); var paramSignatureList = dtMaster.AsEnumerable().Where(myRow => myRow.Field <string>("ParameterID") == item.ParameterID && myRow.Field <string>("SignatureID") == item.SignatureID); foreach (var data in paramSignatureList) { SignatureComparisionDetails seqData = new SignatureComparisionDetails(); seqData.CompanyID = data.ItemArray[0].ToString(); seqData.PlantID = data.ItemArray[1].ToString(); seqData.MachineID = data.ItemArray[2].ToString(); seqData.ParameterID = data.ItemArray[3].ToString(); seqData.SignatureID = data.ItemArray[4].ToString(); seqData.Frequency = data.ItemArray[5].ToString(); seqData.ParameterValue = data.ItemArray[6].ToString(); masterList.Add(seqData); } MongoDBAccess.insertSignatureComparisonMasterData(masterList); } } if (existingSeqList.Count > 0) { Session["SignatureExistingData"] = existingSeqList; ScriptManager.RegisterStartupScript(this, GetType(), "openModal", "openExistingSignatureDataModal();", true); btnOverwrite.Enabled = true; btnChangeSave.Visible = false; btnChange.Visible = true; btnChangeCancel.Visible = false; lvExistingSignature.DataSource = existingSeqList; lvExistingSignature.DataBind(); } else { Session["SignatureExistingData"] = null; } } BindSignatureDetails(); //if (success <= 0) //{ // ScriptManager.RegisterStartupScript(this, GetType(), "RecordsTextopenModaladded", "openErrorModal('Excel file import failed.');", true); // return; //} //if (success > 0) //{ // gvPMMaster.EditIndex = -1; // bindPMMasterDetails(); //} } else { ScriptManager.RegisterStartupScript(this, GetType(), "RecordsTextopenModaladded", "openErrorModal('Please choose a file to import.');", true); } } catch (Exception ex) { } }