public override void SetQueryParameters(IQuery query, SECCompany data, Boolean byId) { base.SetQueryParameters(query, data, byId); if (byId) { //add more parameters to method for query by id } else { //Determine if the boolean values are taken included as part of the consultation //query.SetBoolean("Active", data.Active); //add more parameters to method for query by any field } }
public override String GetQuery(SECCompany data, Boolean byId) { String dml = base.GetQuery(data, byId); if (byId) { //add more parameters to method for query by id } else { //Determine if the boolean values are taken included as part of the consultation //dml += " AND a.Active = :Active \n" ; //add more parameters to method for query by any field dml += " order by a.Id asc "; } return(dml); }
void ReadSEC() { string secCompanies = Resources.SECCompanyList; XmlDocument doc = new XmlDocument(); doc.LoadXml(secCompanies); var companiesTags = doc.SelectNodes("/companies/company"); if (companiesTags != null) { for (int i = 0; i < companiesTags.Count; ++i) { SECCompany comp = new SECCompany(); comp.CIK = companiesTags[i].Attributes["cik"].Value; comp.Ticker = companiesTags[i].Attributes["ticker"].Value; comp.Name = companiesTags[i].Attributes["name"].Value; _lookupSECCompanies.Add(comp.CIK, comp); _lookupSECCompaniesByTicker.Add(comp.Ticker, comp); } } }
public override SECCompany Execute(SECCompany data, Actions action, Options option, string token) { try { if (action == Actions.Add || action == Actions.Modify || action == Actions.Remove || (action == Actions.Find && (option == Options.Me || option == Options.Exist))) { if ((action == Actions.Add || action == Actions.Modify) && option == Options.All) { BenginTransaction(); cONEquivalenceDl = new CONEquivalenceBLL(Work); cONIntegratorConfigurationDl = new CONIntegratorConfigurationBLL(Work); cONSQLDl = new CONSQLBLL(Work); sECConnectionDl = new SECConnectionBLL(Work); sECUserCompanyDl = new SECUserCompanyBLL(Work); } data = base.Execute(data, action, option, token); if (action == Actions.Find && option == Options.Me) { cONEquivalenceDl = new CONEquivalenceBLL(this.Work.Settings); cONIntegratorConfigurationDl = new CONIntegratorConfigurationBLL(this.Work.Settings); cONSQLDl = new CONSQLBLL(this.Work.Settings); sECConnectionDl = new SECConnectionBLL(this.Work.Settings); sECUserCompanyDl = new SECUserCompanyBLL(this.Work.Settings); data.Equivalences = cONEquivalenceDl.FindAll(new CONEquivalence { CompanyId = data.Id }, Options.All); data.IntegratorConfigurations = cONIntegratorConfigurationDl.FindAll(new CONIntegratorConfiguration { CompanyId = data.Id }, Options.All); data.SQLs = cONSQLDl.FindAll(new CONSQL { CompanyId = data.Id }, Options.All); data.Connections = sECConnectionDl.FindAll(new SECConnection { CompanyId = data.Id }, Options.All); data.UserCompanies = sECUserCompanyDl.FindAll(new SECUserCompany { CompanyId = data.Id }, Options.All); } if ((action == Actions.Add || action == Actions.Modify) && option == Options.All) { AddDetails(data); } //if (option == Options.All) // Work.Commit(); return(data); } else if (action == Actions.Find && (option == Options.All || option == Options.Light)) { if (option == Options.All) { data.Entities = FindAll(data, Options.All); } else if (option == Options.Light) { data.Entities = FindAll(data, Options.Light); } return(data); } else { throw new NotImplementedException(GetLocalizedMessage(Language.DLACTIONNOTIMPLEMENT, action.ToString(), option.ToString())); } } catch (FaultException <BusinessException> f) { Rollback(); throw f; } catch (Exception e) { Rollback(); throw new BusinessException(e).GetFaultException(); } finally { Commit(); } }
public override void FindByIdRules(SECCompany data) { base.FindByIdRules(data); }
public override void RemoveRules(SECCompany data) { base.RemoveRules(data); }
public override void ModifyRules(SECCompany data) { base.ModifyRules(data); data.LastUpdate = DateTime.Now; }
public override void CommonRules(SECCompany data) { base.CommonRules(data); }
public void AddDetails(SECCompany data) { if (data.Equivalences != null && data.Equivalences.Count > 0) { for (int i = 0; i < data.Equivalences.Count; i++) { data.Equivalences[i].CompanyId = data.Id; data.Equivalences[i].LastUpdate = DateTime.Now; data.Equivalences[i].UpdatedBy = data.UpdatedBy; if (data.Equivalences[i].Id == 0) { data.Equivalences[i] = cONEquivalenceDl.Add(data.Equivalences[i]); } else { data.Equivalences[i] = cONEquivalenceDl.Modify(data.Equivalences[i]); } } } if (data.IntegratorConfigurations != null && data.IntegratorConfigurations.Count > 0) { for (int i = 0; i < data.IntegratorConfigurations.Count; i++) { data.IntegratorConfigurations[i].CompanyId = data.Id; data.IntegratorConfigurations[i].LastUpdate = DateTime.Now; data.IntegratorConfigurations[i].UpdatedBy = data.UpdatedBy; if (data.IntegratorConfigurations[i].Integrator != null) { data.IntegratorConfigurations[i].IntegratorId = data.IntegratorConfigurations[i].Integrator.Id; } if (data.IntegratorConfigurations[i].Id == 0) { data.IntegratorConfigurations[i] = cONIntegratorConfigurationDl.Add(data.IntegratorConfigurations[i]); } else { data.IntegratorConfigurations[i] = cONIntegratorConfigurationDl.Modify(data.IntegratorConfigurations[i]); } } } if (data.SQLs != null && data.SQLs.Count > 0) { for (int i = 0; i < data.SQLs.Count; i++) { data.SQLs[i].CompanyId = data.Id; data.SQLs[i].LastUpdate = DateTime.Now; data.SQLs[i].UpdatedBy = data.UpdatedBy; if (data.SQLs[i].MainSQL != null) { data.SQLs[i].MainSQLId = data.SQLs[i].MainSQL.Id; } if (data.SQLs[i].Structure != null) { data.SQLs[i].StructureId = data.SQLs[i].Structure.Id; } if (data.SQLs[i].Id == 0) { data.SQLs[i] = cONSQLDl.Add(data.SQLs[i]); } else { data.SQLs[i] = cONSQLDl.Modify(data.SQLs[i]); } } } //if (data.Configurations != null && data.Configurations.Count > 0) //{ // for (int i = 0; i < data.Configurations.Count; i++) // { // data.Configurations[i].CompanyId = data.Id; // data.Configurations[i].LastUpdate = DateTime.Now; // data.Configurations[i].UpdatedBy = data.UpdatedBy; // if (data.Configurations[i].Id == 0) // data.Configurations[i] = sECConfigurationDl.Add(data.Configurations[i]); // else // data.Configurations[i] = sECConfigurationDl.Modify(data.Configurations[i]); // } //} if (data.Connections != null && data.Connections.Count > 0) { for (int i = 0; i < data.Connections.Count; i++) { data.Connections[i].CompanyId = data.Id; data.Connections[i].LastUpdate = DateTime.Now; data.Connections[i].UpdatedBy = data.UpdatedBy; if (data.Connections[i].DbType != null) { data.Connections[i].DbType = data.Connections[i].DbType; } if (data.Connections[i].Id == 0) { data.Connections[i] = sECConnectionDl.Add(data.Connections[i]); } else { data.Connections[i] = sECConnectionDl.Modify(data.Connections[i]); } } } if (data.UserCompanies != null && data.UserCompanies.Count > 0) { for (int i = 0; i < data.UserCompanies.Count; i++) { data.UserCompanies[i].CompanyId = data.Id; data.UserCompanies[i].LastUpdate = DateTime.Now; data.UserCompanies[i].UpdatedBy = data.UpdatedBy; if (data.UserCompanies[i].User != null) { data.UserCompanies[i].UserId = data.UserCompanies[i].User.Id; } if (data.UserCompanies[i].Id == 0) { data.UserCompanies[i] = sECUserCompanyDl.Add(data.UserCompanies[i]); } else { data.UserCompanies[i] = sECUserCompanyDl.Modify(data.UserCompanies[i]); } } } }
public void InstallLocalData() { Configuration conf = GetConfiguration(); ENDefaultData defaultData = new ENDefaultData(); try { DomainLogic dl = new DomainLogic(conf.DataBaseSettings[0]); if (defaultData.Roles() != null && defaultData.Roles().Count > 0) { foreach (SECRole rol in defaultData.Roles()) { SECRole data = dl.GetSECRoleBLL().Add(rol); if (rol.Users != null && rol.Users.Count > 0) { foreach (SECUser user in rol.Users) { user.Role = data; user.RoleId = data.Id; dl.GetSECUserBLL().Add(user); } } } } //if (defaultData.Languages() != null && defaultData.Languages().Count > 0) //{ // foreach (SECLanguage language in defaultData.Languages()) // { // SECLanguage data = dl.GetSECLanguageDL().Add(language); // } //} //if (defaultData.Types() != null && defaultData.Types().Count > 0) //{ // foreach (SECType type in defaultData.Types()) // { // SECType data = dl.GetSECTypeDL().Add(type); // if (type.TypeValues != null && type.TypeValues.Count > 0) // foreach (SECTypeValue typeValue in type.TypeValues) // { // typeValue.TypeId = type.Id; // SECTypeValue data1 = dl.GetSECTypeValueDL().Add(typeValue); // if (typeValue.TypeValueDetails != null && typeValue.TypeValueDetails.Count > 0) // foreach (SECTypeValueDetail typeValueDetail in typeValue.TypeValueDetails) // { // typeValueDetail.TypeValueId = typeValue.Id; // SECTypeValueDetail data2 = dl.GetSECTypeValueDetailDL().Add(typeValueDetail); // } // } // } //} if (defaultData.Companies() != null && defaultData.Companies().Count > 0) { foreach (SECCompany company in defaultData.Companies()) { SECCompany data = dl.GetSECCompanyBLL().Add(company); } } List <SECCompany> companies = dl.GetSECCompanyBLL().FindAll(new SECCompany { Active = true }, Options.All); List <SECUser> users = dl.GetSECUserBLL().FindAll(new SECUser { Active = true }, Options.All); SECUserCompany useCompany = new SECUserCompany { Active = true, CompanyId = companies[0].Id, UserId = users[0].Id, LastUpdate = DateTime.Now, UpdatedBy = "admin" }; dl.GetSECUserCompanyBLL().Add(useCompany); } catch (Exception e) { throw new BusinessException(e).GetFaultException(); } }
public override List <SECCompany> FindAll(SECCompany data, Options option) { return(base.FindAll(data, option)); }
public override SECCompany FindById(SECCompany data) { return(base.FindById(data)); }
public override void AddMoreDetailFindById(SECCompany data) { }
public override void SaveOrUpdateDetails(SECCompany data) { base.SaveOrUpdateDetails(data); }