private Dictionary <string, string> getMandateDataItem(modelProjectVariation projvar, modelOrganization applicant, modelOrganization partner, modelNationalAgency agency) { Dictionary <string, string> data = new Dictionary <string, string>(); data.Add("[@PROJECTVARIATION-ProjectTitle]", projvar.getProjectTitle()); data.Add("[@PROJECTVARIATION-Acronym]", projvar.Acronym); data.Add("[@PROJECTVARIATION-VariationTitle]", projvar.Title); data.Add("[@PARTNER-acronym]", partner.Acronym); data.Add("[@PARTNER-legal-name]", partner.LegalName); data.Add("[@PARTNER-legal-representative]", partner.Representative()); data.Add("[@PARTNER-legal-status]", partner.LegalStatus); data.Add("[@PARTNER-registration-no]", partner.RegistrationNumber); data.Add("[@PARTNER-full-address]", partner.Address); data.Add("[@PARTNER-city]", partner.City); data.Add("[@PARTNER-country]", partner.getCountry()); data.Add("[@PARTNER-country-code]", partner.getCountryCode()); data.Add("[@APPLICANT-legal-name]", applicant.LegalName); data.Add("[@APPLICANT-acronym]", applicant.Acronym); data.Add("[@APPLICANT-legal-status]", applicant.LegalStatus); data.Add("[@APPLICANT-registration-no]", applicant.RegistrationNumber); data.Add("[@APPLICANT-full-address]", applicant.Address); data.Add("[@APPLICANT-country]", applicant.getCountry()); data.Add("[@APPLICANT-country-code]", applicant.getCountryCode()); data.Add("[@APPLICANT-legal-representative]", applicant.Representative()); data.Add("[@APPLICANT-city]", applicant.City); data.Add("[@NATIONALAGENCY-AgencyName]", agency.AgencyName); data.Add("[@NATIONALAGENCY-Country]", agency.getCountry()); return(data); }
public formMandate(modelProjectVariation projVar) { InitializeComponent(); SetStatus(""); projectVariation = projVar; prepareMandateData(); }
public void Delete(modelProjectVariation projectVariation, bool reload = true) { db.Delete("tblProjectVariation", "ID", projectVariation); if (reload) { LoadProjectVariations(); } }
public void Update(modelProjectVariation projectVariation, bool reload = true) { if (projectVariation.CreatedDate.Year < 2000) { projectVariation.CreatedDate = new DateTime(2000, 1, 1); } projectVariation.UpdatedDate = DateTime.Now; db.Update("tblProjectVariation", "ID", projectVariation); if (reload) { LoadProjectVariations(); } }
public void Insert(modelProjectVariation projectVariation, bool reload = true) { if (projectVariation.ID == 0) { projectVariation.ID = Program.GData.LongID(); projectVariation.CreatedDate = DateTime.Now; projectVariation.UpdatedDate = DateTime.Now; } db.Insert("tblProjectVariation", "ID", false, projectVariation); if (reload) { LoadProjectVariations(); } }
private void AddProjectVariationVariables(ref Dictionary <string, string> mailMergeVars, modelProjectVariation projvar, modelProjectVariationOrganization[] partners, string countryList) { string na = ""; var natagency = Program.GData.dataLOV.getNationalAgency(projvar.NationalAgency); if (natagency != null) { na = natagency.AgencyName; } AddToVariablesDictionary(ref mailMergeVars, "round", projvar.Call); AddToVariablesDictionary(ref mailMergeVars, "project_name", projvar.Title); AddToVariablesDictionary(ref mailMergeVars, "project_name_acronym", projvar.Acronym); AddToVariablesDictionary(ref mailMergeVars, "partner_count", partners.Count().ToString()); AddToVariablesDictionary(ref mailMergeVars, "partners_countries_list", countryList); AddToVariablesDictionary(ref mailMergeVars, "national_agency", na); AddToVariablesDictionary(ref mailMergeVars, "custom_variable1", projvar.CustomVariable1); AddToVariablesDictionary(ref mailMergeVars, "custom_variable2", projvar.CustomVariable2); }
public void prepareMailMergeDataVariation(modelProjectVariation prjVariation, ref Dictionary <string, string> mailMergeVars) { modelOrganization emptyOrg = new modelOrganization(); //modelProjectVariation projvar1 = null; modelProjectActivityVariation projactvar1 = null; //modelProjectVariation projvar2 = null; modelProjectActivityVariation projactvar2 = null; modelOrganization applicant = emptyOrg; modelOrganization partner01 = emptyOrg; modelOrganization partner02 = emptyOrg; modelOrganization partner03 = emptyOrg; modelOrganization partner04 = emptyOrg; modelOrganization partner05 = emptyOrg; modelOrganization partner06 = emptyOrg; modelOrganization partner07 = emptyOrg; modelMobility emptyMobility = new modelMobility(); var actvars = Program.GData.dataProject.getProjectActivityVariations.Where(c => c.ProjectVariation == prjVariation.ID).ToArray(); if (actvars.Count() == 0) { return; } if (actvars.Count() == 1) { projactvar1 = actvars[0]; projactvar2 = new modelProjectActivityVariation(); projactvar2.Duration = 1; } if (actvars.Count() == 2) { projactvar1 = actvars[0]; projactvar2 = actvars[1]; } applicant = Program.GData.dataOrganization.getOrganization(prjVariation.ApplicantOrganization); var partners = Program.GData.dataProject.getProjectVariationOrganizations.Where(c => c.ProjectVariation == prjVariation.ID).OrderBy(d => d.OrganizationOrder).ToArray(); if (partners.Count() > 0) { partner01 = Program.GData.dataOrganization.getOrganization(partners[0].Organization); } if (partners.Count() > 1) { partner02 = Program.GData.dataOrganization.getOrganization(partners[1].Organization); } if (partners.Count() > 2) { partner03 = Program.GData.dataOrganization.getOrganization(partners[2].Organization); } if (partners.Count() > 3) { partner04 = Program.GData.dataOrganization.getOrganization(partners[3].Organization); } if (partners.Count() > 4) { partner05 = Program.GData.dataOrganization.getOrganization(partners[4].Organization); } if (partners.Count() > 5) { partner06 = Program.GData.dataOrganization.getOrganization(partners[5].Organization); } if (partners.Count() > 6) { partner07 = Program.GData.dataOrganization.getOrganization(partners[6].Organization); } string countryList = applicant.getCountryCode() + "," + partner01.getCountryCode() + "," + partner02.getCountryCode() + "," + partner03.getCountryCode() + "," + partner04.getCountryCode() + "," + partner05.getCountryCode() + "," + partner06.getCountryCode() + "," + partner07.getCountryCode(); while (countryList.Contains(",,")) { countryList = countryList.Replace(",,", ","); } if (countryList.Substring(countryList.Length - 1) == ",") { countryList = countryList.Substring(0, countryList.Length - 1); } var mobilities1 = Program.GData.dataActivity.getMobilities.Where(c => c.ActivityVariation == projactvar1.ID).OrderBy(c => c.MobilityOrder).ToArray(); var mobilities2 = Program.GData.dataActivity.getMobilities.Where(c => c.ActivityVariation == projactvar2.ID).OrderBy(c => c.MobilityOrder).ToArray(); AddProjectVariationVariables(ref mailMergeVars, prjVariation, partners, countryList); AddProjectActivityVariationVariables(ref mailMergeVars, projactvar1, partners, "a1_"); AddProjectActivityVariationVariables(ref mailMergeVars, projactvar2, partners, "a2_"); int sum1_facilitators = 0; int sum1_stuff = 0; int sum1_gtl = 0; int sum1_participants = 0; for (int idx = 0; idx < 8; idx++) { if (mobilities1.Count() > idx) { AddMobilityVariables(ref mailMergeVars, mobilities1[idx], "a1_mob" + (idx + 1).ToString() + "_"); sum1_facilitators += mobilities1[idx].Facilitators; sum1_stuff += mobilities1[idx].Others; sum1_gtl += mobilities1[idx].GroupLeaders + mobilities1[idx].Trainers + mobilities1[idx].Facilitators; sum1_participants += mobilities1[idx].Participants; } else { AddMobilityVariables(ref mailMergeVars, emptyMobility, "a1_mob" + (idx + 1).ToString() + "_"); } } AddMobilitySumsVariables(ref mailMergeVars, sum1_facilitators, sum1_stuff, sum1_gtl, sum1_participants, "a1_"); int sum2_facilitators = 0; int sum2_stuff = 0; int sum2_gtl = 0; int sum2_participants = 0; for (int idx = 0; idx < 8; idx++) { if (mobilities2.Count() > idx) { AddMobilityVariables(ref mailMergeVars, mobilities2[idx], "a2_mob" + (idx + 1).ToString() + "_"); sum2_facilitators += mobilities2[idx].Facilitators; sum2_stuff += mobilities2[idx].Others; sum2_gtl += mobilities2[idx].GroupLeaders + mobilities2[idx].Trainers + mobilities2[idx].Facilitators; sum2_participants += mobilities2[idx].Participants; } else { AddMobilityVariables(ref mailMergeVars, emptyMobility, "a2_mob" + (idx + 1).ToString() + "_"); } } AddMobilitySumsVariables(ref mailMergeVars, sum2_facilitators, sum2_stuff, sum2_gtl, sum2_participants, "a2_"); AddApplicantVariables(ref mailMergeVars, applicant, "applicant_"); AddPartnerVariables(ref mailMergeVars, partner01, "partner01_"); AddPartnerVariables(ref mailMergeVars, partner02, "partner02_"); AddPartnerVariables(ref mailMergeVars, partner03, "partner03_"); AddPartnerVariables(ref mailMergeVars, partner04, "partner04_"); AddPartnerVariables(ref mailMergeVars, partner05, "partner05_"); AddPartnerVariables(ref mailMergeVars, partner06, "partner06_"); AddPartnerVariables(ref mailMergeVars, partner07, "partner07_"); }