public static bool SaveCommonDetails(CommonDataSaveModel cModel, TrainingDataModel tModel, MySqlConnection conn, ref string errorMsg) { MySqlTransaction myTrans; // Start a local transaction myTrans = conn.BeginTransaction(); try { string savingSql = string.Format("INSERT INTO commonparameters(pID,pName,pCitation,pRef) VALUES ({0},'{1}','{2}','{3}')", cModel.PId, cModel.PName, cModel.PCitation, cModel.PRef); MySqlCommand cmd = new MySqlCommand(savingSql.ToString(), conn); cmd.Transaction = myTrans; cmd.ExecuteNonQuery(); System.Threading.Thread.Sleep(100 * 1);//sleep for 2 ms just to ensure everything is OK.. string savingSql1 = string.Format("INSERT INTO trainingdata(pID, AaID, BcnID, BcnpID, BccID, BcsID, BclID, BcprID, BcdaID, BcdapID, bcdfID, AsID, NfrasID, DsID, BpID, rsID) VALUES " + "({0},'{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}')", tModel.PId, tModel.AaID, tModel.BcnID, tModel.BcnpID, tModel.BccID, tModel.BcsID, tModel.BclID, tModel.BcprID, tModel.BcdaID, tModel.BcdapID, tModel.bcdfID, tModel.AsID, tModel.NfrasID, tModel.DsID, tModel.BpID, tModel.RsID); MySqlCommand cmd2 = new MySqlCommand(savingSql1.ToString(), conn); cmd2.Transaction = myTrans; cmd2.ExecuteNonQuery(); System.Threading.Thread.Sleep(100 * 1);//sleep for 2 ms just to ensure everything is OK.. myTrans.Commit(); return(true); } catch (Exception ex) { myTrans.Rollback(); errorMsg = string.Format("Exception happened when saving common models. Reason is {0}", ex.Message); } return(false); }
private void NextItem(object sender, EventArgs e) { if (newTraingingData.Count <= 0 || string.IsNullOrEmpty(questionStatementTypeEntry.Text) || string.IsNullOrEmpty(SentimentTypeEntry.Text)) { MessageDialog md = new MessageDialog(this, DialogFlags.DestroyWithParent, MessageType.Info, ButtonsType.Close, "Missing data. Please ensure all fields are filled in."); md.Run(); md.Destroy(); return; } TrainingDataModel tdm = new TrainingDataModel(); tdm.MessageContent = DataViewEntry.Text; tdm.questionOrStatement = new StatementTypeModel { ID = new Random().Next(), Statement = DataViewEntry.Text, StatementType = QuestionOrStatmentCheckbox.Active }; if (tdm.questionOrStatement.StatementType) { tdm.questionType = new QuestionTypeModel { ID = new Random().Next(), Statement = DataViewEntry.Text, QuestionType = questionStatementTypeEntry.Text }; } else { tdm.StatementType = new SentenceTypeModel { ID = new Random().Next(), Statement = DataViewEntry.Text, sentenceType = questionStatementTypeEntry.Text }; } tdm.SentimentType = new SentimentModel { ID = new Random().Next(), Statement = DataViewEntry.Text, SentimentType = SentimentTypeEntry.Text }; newTraingingData.Add(tdm); msgs.RemoveAt(0); DataViewEntry.Text = msgs[0]; }
public static TrainingDataModel Parse(string[] data) { var model = new TrainingDataModel { Id = int.Parse(data[0]), Title = data[1].Replace("\"", "").Replace("!", ""), UserActivityData = JsonConvert.DeserializeObject <Dictionary <int, int> >(data[2]), Photos = data[3].Replace("[", "").Replace("]", "").Replace("\"", "").Split(',').ToList(), L1Category = int.Parse(data[4]) }; if (data.Length > 5) { model.L2Category = int.Parse(data[5]); } if (data.Length > 6) { model.L3Category = int.Parse(data[6]); } return(model); }
public void Populate(TrainingDataModel trainingDataDto) { _trainingDataModel = trainingDataDto; }
private void btnSave_Click(object sender, EventArgs e) { string errorMsg = string.Empty; if (string.IsNullOrEmpty(tbPaperName.Text) || string.IsNullOrEmpty(tbCitaton.Text) || string.IsNullOrEmpty(tbRef.Text)) { MessageBox.Show("Please enter Common details for Paper"); } else { int nextPid = MasterDataAccess.GetNextPID(conn) + 1; CommonDataSaveModel cmdModel = new CommonDataSaveModel(); cmdModel.PId = nextPid; if (!string.IsNullOrEmpty(tbPaperName.Text)) { cmdModel.PName = tbPaperName.Text; } if (!string.IsNullOrEmpty(tbCitaton.Text)) { cmdModel.PCitation = tbCitaton.Text; } if (!string.IsNullOrEmpty(tbRef.Text)) { cmdModel.PRef = tbRef.Text; } TrainingDataModel tdModel = new TrainingDataModel(); tdModel.PId = nextPid; if (!string.IsNullOrEmpty(cmbAArea.SelectedItem.ToString())) { tdModel.AaID = MasterDataAccess.GetIDForAValue("applicationarea", "aaName", "aaID", cmbAArea.SelectedItem.ToString(), conn); } if (!string.IsNullOrEmpty(cmbBcType.SelectedItem.ToString())) { tdModel.BcnID = MasterDataAccess.GetIDForAValue("BCNetworks", "bcnName", "bcnID", cmbBcType.SelectedItem.ToString(), conn); } if (!string.IsNullOrEmpty(cmbNwPart.SelectedItem.ToString())) { tdModel.BcnpID = MasterDataAccess.GetIDForAValue("BCNWParticipation", "bcnpName", "bcnpID", cmbNwPart.SelectedItem.ToString(), conn); } if (!string.IsNullOrEmpty(cmbConsensus.SelectedItem.ToString())) { tdModel.BccID = MasterDataAccess.GetIDForAValue("BCConsensus", "bccName", "BccID", cmbConsensus.SelectedItem.ToString(), conn); } if (!string.IsNullOrEmpty(cmbScalability.SelectedItem.ToString())) { tdModel.BcsID = MasterDataAccess.GetIDForAValue("BCScalability", "bcsName", "BcsID", cmbScalability.SelectedItem.ToString(), conn); } if (!string.IsNullOrEmpty(cmbLatency.SelectedItem.ToString())) { tdModel.BclID = MasterDataAccess.GetIDForAValue("BCLatency", "bclName", "BclID", cmbLatency.SelectedItem.ToString(), conn); } if (!string.IsNullOrEmpty(cmbPerf.SelectedItem.ToString())) { tdModel.BcprID = MasterDataAccess.GetIDForAValue("BCPerformance", "bcprName", "BcprID", cmbPerf.SelectedItem.ToString(), conn); } if (!string.IsNullOrEmpty(cmbDataAccess.SelectedItem.ToString())) { tdModel.BcdaID = MasterDataAccess.GetIDForAValue("BCDataAccess", "bcdaName", "BcdaID", cmbDataAccess.SelectedItem.ToString(), conn); } if (!string.IsNullOrEmpty(cmbDap.SelectedItem.ToString())) { tdModel.BcdapID = MasterDataAccess.GetIDForAValue("BCDataAccessPolicy", "bcdapName", "BcdapID", cmbDap.SelectedItem.ToString(), conn); } if (!string.IsNullOrEmpty(cmbDataFormat.SelectedItem.ToString())) { tdModel.bcdfID = MasterDataAccess.GetIDForAValue("BCDataFormat", "bcdfName", "bcdfID", cmbDataFormat.SelectedItem.ToString(), conn); } if (!string.IsNullOrEmpty(cmbAs.SelectedItem.ToString())) { tdModel.AsID = MasterDataAccess.GetIDForAValue("ArchitectureStyle", "asName", "AsID", cmbAs.SelectedItem.ToString(), conn); } if (!string.IsNullOrEmpty(cmbAsNFR.SelectedItem.ToString())) { tdModel.NfrasID = MasterDataAccess.GetIDForAValue("NFRsInArchitecture", "nfrasName", "NfrasID", cmbAsNFR.SelectedItem.ToString(), conn); } if (!string.IsNullOrEmpty(cmbDS.SelectedItem.ToString())) { tdModel.DsID = MasterDataAccess.GetIDForAValue("DataStorageSystems", "dsName", "DsID", cmbDS.SelectedItem.ToString(), conn); } if (!string.IsNullOrEmpty(cmbBcPlat.SelectedItem.ToString())) { tdModel.BpID = MasterDataAccess.GetIDForAValue("BlockchainPlatforms", "bpName", "BpID", cmbBcPlat.SelectedItem.ToString(), conn); } if (!string.IsNullOrEmpty(cmbarFeatures.SelectedItem.ToString())) { tdModel.RsID = MasterDataAccess.GetIDForAValue("resultsobtained", "rsName", "rsID", cmbarFeatures.SelectedItem.ToString(), conn); } if (!MasterDataAccess.SaveCommonDetails(cmdModel, tdModel, conn, ref errorMsg)) { MessageBox.Show(string.Format("PRoblem in saving taraining data. The Reason is {0}", errorMsg)); } else { MessageBox.Show("Data Inserted sucessfully"); } this.Close(); } }
public TrainingParametersPage(TrainingDataModel trainingDataModel) { InitializeComponent(); var viewModel = (TrainingParametersViewModel) DataContext; viewModel.Populate(trainingDataModel); }