public override String GetQuery(CONStructure 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.Main = :Main \n"; dml += " AND a.Active = :Active \n"; //add more parameters to method for query by any field if (data.Integrator != null && data.Integrator.Id != 0) { dml += " AND a.Integrator.Id = :Integrator \n"; } dml += " order by a.Id asc "; } return(dml); }
public override void SetQueryParameters(IQuery query, CONStructure 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("Main", data.Main); query.SetBoolean("Active", data.Active); //add more parameters to method for query by any field if (data.Integrator != null && data.Integrator.Id != 0) { query.SetInt32("Integrator", data.Integrator.Id); } } }
public override List <CONStructure> FindAll(CONStructure data, Options option) { return(base.FindAll(data, option)); }
public override CONStructure FindById(CONStructure data) { return(base.FindById(data)); }
public override void AddMoreDetailFindById(CONStructure data) { }
public override void SaveOrUpdateDetails(CONStructure data) { base.SaveOrUpdateDetails(data); }
public override CONStructure Execute(CONStructure 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(); cONSQLDl = new CONSQLBLL(Work); cONStructureAssociationDl = new CONStructureAssociationBLL(Work); cONStructureDetailDl = new CONStructureDetailBLL(Work); } data = base.Execute(data, action, option, token); if (action == Actions.Find && option == Options.Me) { cONSQLDl = new CONSQLBLL(this.Work.Settings); cONStructureAssociationDl = new CONStructureAssociationBLL(this.Work.Settings); cONStructureDetailDl = new CONStructureDetailBLL(this.Work.Settings); data.SQLs = cONSQLDl.FindAll(new CONSQL { StructureId = data.Id }, Options.All); data.MainStructures = cONStructureAssociationDl.FindAll(new CONStructureAssociation { MainStructureId = data.Id }, Options.All); data.ChildStructures = cONStructureAssociationDl.FindAll(new CONStructureAssociation { ChildStructureId = data.Id }, Options.All); data.StructureDetails = cONStructureDetailDl.FindAll(new CONStructureDetail { StructureId = 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 RemoveRules(CONStructure data) { base.RemoveRules(data); }
public override void FindByIdRules(CONStructure data) { base.FindByIdRules(data); }
public override void ModifyRules(CONStructure data) { base.ModifyRules(data); data.LastUpdate = DateTime.Now; }
public override void CommonRules(CONStructure data) { base.CommonRules(data); }
public void AddDetails(CONStructure data) { if (data.SQLs != null && data.SQLs.Count > 0) { for (int i = 0; i < data.SQLs.Count; i++) { data.SQLs[i].StructureId = data.Id; data.SQLs[i].LastUpdate = DateTime.Now; data.SQLs[i].UpdatedBy = data.UpdatedBy; if (data.SQLs[i].Company != null) { data.SQLs[i].CompanyId = data.SQLs[i].Company.Id; } if (data.SQLs[i].MainSQL != null) { data.SQLs[i].MainSQLId = data.SQLs[i].MainSQL.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.MainStructures != null && data.MainStructures.Count > 0) { for (int i = 0; i < data.MainStructures.Count; i++) { data.MainStructures[i].MainStructureId = data.Id; data.MainStructures[i].LastUpdate = DateTime.Now; data.MainStructures[i].UpdatedBy = data.UpdatedBy; if (data.MainStructures[i].Id == 0) { data.MainStructures[i] = cONStructureAssociationDl.Add(data.MainStructures[i]); } else { data.MainStructures[i] = cONStructureAssociationDl.Modify(data.MainStructures[i]); } } } if (data.ChildStructures != null && data.ChildStructures.Count > 0) { for (int i = 0; i < data.ChildStructures.Count; i++) { data.ChildStructures[i].ChildStructureId = data.Id; data.ChildStructures[i].LastUpdate = DateTime.Now; data.ChildStructures[i].UpdatedBy = data.UpdatedBy; if (data.ChildStructures[i].Id == 0) { data.ChildStructures[i] = cONStructureAssociationDl.Add(data.ChildStructures[i]); } else { data.ChildStructures[i] = cONStructureAssociationDl.Modify(data.ChildStructures[i]); } } } if (data.StructureDetails != null && data.StructureDetails.Count > 0) { for (int i = 0; i < data.StructureDetails.Count; i++) { data.StructureDetails[i].StructureId = data.Id; data.StructureDetails[i].LastUpdate = DateTime.Now; data.StructureDetails[i].UpdatedBy = data.UpdatedBy; if (data.StructureDetails[i].Id == 0) { data.StructureDetails[i] = cONStructureDetailDl.Add(data.StructureDetails[i]); } else { data.StructureDetails[i] = cONStructureDetailDl.Modify(data.StructureDetails[i]); } } } }
public BindingList <CONStructureDetail> GetStructureDetails(CONStructure structure) { return(new BindingList <CONStructureDetail>(((CONStructureDetail)eToolsServer().Execute(new CONStructureDetail { Structure = structure }, Actions.Find, Options.Light, DefaultDatabaseSettingName, "")).Entities)); }
public BindingList <CONStructure> GetChildStructures(CONStructure structure) { return(new BindingList <CONStructure>(((CONStructureAssociation)eToolsServer().Execute(new CONStructureAssociation { MainStructure = structure }, Actions.Find, Options.All, DefaultDatabaseSettingName, "")).Entities.Select(x => x.ChildStructure).ToList <CONStructure>())); }