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();
}
}
