public bool SendMail(string TemplateCode, List <string> MailTo = null, List <string> MailCC = null, List <string> MailBCC = null, Dictionary <string, string> SubjectVariables = null, Dictionary <string, string> BodyVariables = null, bool defaultSignature = true) { try { if (this.SetSmtpSettings()) { MasterDataAccess objMasterDataAccess = new MasterDataAccess(); MasterTemplate objMailTemplate = objMasterDataAccess.GetTemplate(TemplateCode); if (objMailTemplate != null) { Constants.MailSend(MailTo, objMailTemplate.MailFrom, objMailTemplate.TemplateSubject, objMailTemplate.TemplateDtls, MailCC, MailBCC, SubjectVariables, BodyVariables, true, defaultSignature); return(true); } else { return(false); } } else { return(false); } } catch (Exception ex) { CLogger.WriteLog(ProjectSource.BusinessLayer, ELogLevel.ERROR, "ERROR ocurred in EmailService while calling SendMail Action, Ex.: " + ex.Message); } return(false); }
private void btnExport_Click(object sender, EventArgs e) { //Get Folder Path FolderBrowserDialog fbDialog = new FolderBrowserDialog(); fbDialog.ShowDialog(); string folderPath = fbDialog.SelectedPath; List <string> existingfiles = Directory.GetFiles(folderPath, "trainingdetails.xlsx", SearchOption.AllDirectories).ToList <string>(); foreach (string fileDet in existingfiles) { System.IO.FileInfo fInfo = new FileInfo(fileDet); fInfo.Delete(); } //getdata string errorMsg = string.Empty; List <TrainingDataModelForExcel> tModels = MasterDataAccess.GetTrainingData(conn, ref errorMsg); //Create Excel Microsoft.Office.Interop.Excel.Application excelApp = null; Workbook excelWorkBook = null; try { PropertyDescriptorCollection properties = TypeDescriptor.GetProperties(typeof(TrainingDataModel)); excelApp = new Microsoft.Office.Interop.Excel.Application(); excelWorkBook = excelApp.Workbooks.Add(); _Worksheet xlWorksheet = excelWorkBook.Sheets[1]; Range xlRange = xlWorksheet.UsedRange; //Add a new worksheet to workbook with the Datatable name Worksheet sheet = excelWorkBook.Sheets.Add(); sheet.Name = "Paper Citation Details"; List <string> captions = tModels[0].ToString().Split('^').ToList <string>(); for (int i = 1; i <= properties.Count; i++) { sheet.Cells[1, i] = captions[i - 1]; } int counter = 0; for (int i = 1; i < tModels.Count; i++) { List <string> values = tModels[i].ToString().Split('^').ToList <string>(); for (int j = 1; j <= properties.Count; j++) { sheet.Cells[i + 1, j].Value = values[counter]; counter++; } counter = 0; } sheet.SaveAs(folderPath + "\\trainingdetails.xlsx"); excelWorkBook.Close(); excelApp.Quit(); } catch (Exception ex) { MessageBox.Show(string.Format("There is a problem while creating Excel sheet. The reason is {0}", ex.Message)); Console.WriteLine("There is a problem in creating and saving Excel sheet. the Reason is {0}", ex.Message); excelWorkBook.Close(); excelApp.Quit(); } MessageBox.Show("Training details are exported"); }
public IEnumerable <MasterImageType> GetImageType() { MasterDataAccess objDataAccess = new MasterDataAccess(); return(objDataAccess.GetImageType()); }
public MasterController() { da = new MasterDataAccess(); }
public TrainingData(MySqlConnection conn) : this() { this.conn = conn; //application area foreach (string s in MasterDataAccess.GetValueSetForATable("applicationarea", "aaName", conn)) { cmbAArea.Items.Add(s); } //blockchain network foreach (string s in MasterDataAccess.GetValueSetForATable("BCNetworks", "bcnName", conn)) { cmbBcType.Items.Add(s); } //Network participation foreach (string s in MasterDataAccess.GetValueSetForATable("BCNWParticipation", "bcnpName", conn)) { cmbNwPart.Items.Add(s); } //Consensus foreach (string s in MasterDataAccess.GetValueSetForATable("BCConsensus", "bccName", conn)) { cmbConsensus.Items.Add(s); } //Scalability foreach (string s in MasterDataAccess.GetValueSetForATable("BCScalability", "bcsName", conn)) { cmbScalability.Items.Add(s); } //Latency foreach (string s in MasterDataAccess.GetValueSetForATable("BCLatency", "bclName", conn)) { cmbLatency.Items.Add(s); } //Performance foreach (string s in MasterDataAccess.GetValueSetForATable("BCPerformance", "bcprName", conn)) { cmbPerf.Items.Add(s); } // Data Access foreach (string s in MasterDataAccess.GetValueSetForATable("BCDataAccess", "bcdaName", conn)) { cmbDataAccess.Items.Add(s); } //Data Access Policy foreach (string s in MasterDataAccess.GetValueSetForATable("BCDataAccessPolicy", "bcdapName", conn)) { cmbDap.Items.Add(s); } //Data format foreach (string s in MasterDataAccess.GetValueSetForATable("BCDataFormat", "bcdfName", conn)) { cmbDataFormat.Items.Add(s); } //Arch Style foreach (string s in MasterDataAccess.GetValueSetForATable("ArchitectureStyle", "asName", conn)) { cmbAs.Items.Add(s); } //NFR in ARchitecture foreach (string s in MasterDataAccess.GetValueSetForATable("NFRsInArchitecture", "nfrasName", conn)) { cmbAsNFR.Items.Add(s); } //Data Storage Platform foreach (string s in MasterDataAccess.GetValueSetForATable("DataStorageSystems", "dsName", conn)) { cmbDS.Items.Add(s); } //Blockchain platform foreach (string s in MasterDataAccess.GetValueSetForATable("BlockchainPlatforms", "bpName", conn)) { cmbBcPlat.Items.Add(s); } //Results Obtained foreach (string s in MasterDataAccess.GetValueSetForATable("resultsobtained", "rsName", conn)) { cmbarFeatures.Items.Add(s); } }
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(); } }