public override async void DeleteAction() { try { if (Model.IsValid) { Model.UpdatedBy = EasyApp.Current.User.Login; CONEquivalence data = ((CONEquivalence)await EasyApp.Current.eToolsServer().ExecuteAsync(Model.Entity, Actions.Remove, Options.Me, EasyApp.Current.DefaultDatabaseSettingName, "")); if (data != null) { Model.Details.Remove(data); } PostDeleteAction(""); MessageBoxResult result = MessageBox.Show("Registro eliminado correctamente", "Eliminando", MessageBoxButton.OK, MessageBoxImage.Question); OnNewCommand(new object()); } else { MessageBox.Show("Hay validaciones pendientes por favor verifique.", "Información", MessageBoxButton.OK, MessageBoxImage.Information); PostDeleteAction("Hay validaciones pendientes por favor verifique."); } } catch (FaultException ex) { MessageBox.Show(new BusinessException(ex).GetExceptionMessage(), "Error", MessageBoxButton.OK); PostDeleteAction(new BusinessException(ex).GetExceptionMessage()); } catch (Exception ex) { MessageBox.Show(new BusinessException(ex).GetExceptionMessage(), "Error", MessageBoxButton.OK); PostDeleteAction(new BusinessException(ex).GetExceptionMessage()); } }
public void AddDetails(CONEquivalence data) { if (data.EquivalenceDetails != null && data.EquivalenceDetails.Count > 0) { for (int i = 0; i < data.EquivalenceDetails.Count; i++) { data.EquivalenceDetails[i].EquivalenceId = data.Id; data.EquivalenceDetails[i].LastUpdate = DateTime.Now; data.EquivalenceDetails[i].UpdatedBy = data.UpdatedBy; if (data.EquivalenceDetails[i].Id == 0) { data.EquivalenceDetails[i] = cONEquivalenceDetailDl.Add(data.EquivalenceDetails[i]); } else { data.EquivalenceDetails[i] = cONEquivalenceDetailDl.Modify(data.EquivalenceDetails[i]); } } } if (data.SQLDetails != null && data.SQLDetails.Count > 0) { for (int i = 0; i < data.SQLDetails.Count; i++) { data.SQLDetails[i].EquivalenceId = data.Id; data.SQLDetails[i].LastUpdate = DateTime.Now; data.SQLDetails[i].UpdatedBy = data.UpdatedBy; //if (data.SQLDetails[i].MainSQLDetail != null) // data.SQLDetails[i].MainSQLDetailId = data.SQLDetails[i].MainSQLDetail.Id; if (data.SQLDetails[i].SQL != null) { data.SQLDetails[i].SQLId = data.SQLDetails[i].SQL.Id; } if (data.SQLDetails[i].StructureDetail != null) { data.SQLDetails[i].StructureDetailId = data.SQLDetails[i].StructureDetail.Id; } if (data.SQLDetails[i].Id == 0) { data.SQLDetails[i] = cONSQLDetailDl.Add(data.SQLDetails[i]); } else { data.SQLDetails[i] = cONSQLDetailDl.Modify(data.SQLDetails[i]); } } } }
public override async void SaveAction(bool createNew) { try { if (Model.IsValid) { Model.UpdatedBy = EasyApp.Current.User.Login; CONEquivalence data = ((CONEquivalence)await EasyApp.Current.eToolsServer().ExecuteAsync(Model.Entity, (Model.Id == 0 ? Actions.Add : Actions.Modify), Options.All, EasyApp.Current.DefaultDatabaseSettingName, "")); if (data != null) { if (Model.Details.IndexOf(data) != -1) { Model.Details[Model.Details.IndexOf(data)] = data; } else { Model.Details.Add(data); } Model.Entity = data; } PostSaveAction(""); MessageBox.Show("Archivos guardados correctamente ", "Proceso Terminado", MessageBoxButton.OK, MessageBoxImage.Information); //if (createNew) //{ // MessageBoxResult result = MessageBox.Show("Registro guardado correctamente, desea crear un nuevo registro", "Nuevo Registro", MessageBoxButton.YesNo, MessageBoxImage.Question); // if (result == MessageBoxResult.Yes) // OnNewCommand(new object()); //} } else { MessageBox.Show("Hay validaciones pendientes por favor verifique.", "Información", MessageBoxButton.OK, MessageBoxImage.Information); PostSaveAction("Hay validaciones pendientes por favor verifique."); } } catch (FaultException ex) { MessageBox.Show(new BusinessException(ex).GetExceptionMessage(), "Error", MessageBoxButton.OK); PostSaveAction(new BusinessException(ex).GetExceptionMessage()); } catch (Exception ex) { MessageBox.Show(new BusinessException(ex).GetExceptionMessage(), "Error", MessageBoxButton.OK); PostSaveAction(new BusinessException(ex).GetExceptionMessage()); } }
public override void SetQueryParameters(IQuery query, CONEquivalence 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 if (data.Company != null && data.Company.Id != 0) { query.SetInt32("Company", data.Company.Id); } } }
public override String GetQuery(CONEquivalence 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 if (data.Company != null && data.Company.Id != 0) { dml += " AND a.Company.Id = :Company \n"; } dml += " order by a.Id asc "; } return(dml); }
public override CONEquivalence Execute(CONEquivalence 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(); cONEquivalenceDetailDl = new CONEquivalenceDetailBLL(Work); cONSQLDetailDl = new CONSQLDetailBLL(Work); } data = base.Execute(data, action, option, token); if (action == Actions.Find && option == Options.Me) { cONEquivalenceDetailDl = new CONEquivalenceDetailBLL(this.Work.Settings); cONSQLDetailDl = new CONSQLDetailBLL(this.Work.Settings); data.EquivalenceDetails = cONEquivalenceDetailDl.FindAll(new CONEquivalenceDetail { EquivalenceId = data.Id }, Options.All); data.SQLDetails = cONSQLDetailDl.FindAll(new CONSQLDetail { EquivalenceId = data.Id }, Options.All); } if ((action == Actions.Add || action == Actions.Modify) && option == Options.All) { AddDetails(data); } return(data); } else if (action == Actions.Find && (option == Options.All || option == Options.Light)) { if (option == Options.All) { data.Entities = FindAll(data, Options.All); if (data.Entities != null && data.Entities.Count > 0) { cONEquivalenceDetailDl = new CONEquivalenceDetailBLL(Work); foreach (var item in data.Entities) { item.EquivalenceDetails = cONEquivalenceDetailDl.FindAll(new CONEquivalenceDetail { Equivalence = 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(CONEquivalence data) { base.FindByIdRules(data); }
public override void RemoveRules(CONEquivalence data) { base.RemoveRules(data); }
public override void ModifyRules(CONEquivalence data) { base.ModifyRules(data); data.LastUpdate = DateTime.Now; }
public override void CommonRules(CONEquivalence data) { base.CommonRules(data); }
public override async void FindAction() { try { CONEquivalence data = ((CONEquivalence)await EasyApp.Current.eToolsServer().ExecuteAsync(Model.Entity, Actions.Find, Options.Light, EasyApp.Current.DefaultDatabaseSettingName, "")); if (data.Entities != null && data.Entities.Count > 0) { Model.Details = new BindingList <CONEquivalence>(data.Entities); } if (!String.IsNullOrWhiteSpace(Model.LabelValue1)) { view.DataGridEquivalenceDetail.Columns["Value1"].IsVisible = true; view.DataGridEquivalenceDetail.Columns["Value1"].Header = model.LabelValue1; } if (!String.IsNullOrWhiteSpace(Model.LabelValue2)) { view.DataGridEquivalenceDetail.Columns["Value2"].IsVisible = true; view.DataGridEquivalenceDetail.Columns["Value2"].Header = model.LabelValue2; } if (!String.IsNullOrWhiteSpace(Model.LabelValue3)) { view.DataGridEquivalenceDetail.Columns["Value3"].IsVisible = true; view.DataGridEquivalenceDetail.Columns["Value3"].Header = model.LabelValue3; } if (!String.IsNullOrWhiteSpace(Model.LabelValue4)) { view.DataGridEquivalenceDetail.Columns["Value4"].IsVisible = true; view.DataGridEquivalenceDetail.Columns["Value4"].Header = model.LabelValue4; } if (!String.IsNullOrWhiteSpace(Model.LabelValue5)) { view.DataGridEquivalenceDetail.Columns["Value5"].IsVisible = true; view.DataGridEquivalenceDetail.Columns["Value5"].Header = model.LabelValue5; } if (!String.IsNullOrWhiteSpace(Model.LabelValue6)) { view.DataGridEquivalenceDetail.Columns["Value6"].IsVisible = true; view.DataGridEquivalenceDetail.Columns["Value6"].Header = model.LabelValue6; } if (!String.IsNullOrWhiteSpace(Model.LabelValue7)) { view.DataGridEquivalenceDetail.Columns["Value7"].IsVisible = true; view.DataGridEquivalenceDetail.Columns["Value7"].Header = model.LabelValue7; } if (!String.IsNullOrWhiteSpace(Model.LabelValue8)) { view.DataGridEquivalenceDetail.Columns["Value8"].IsVisible = true; view.DataGridEquivalenceDetail.Columns["Value8"].Header = model.LabelValue8; } if (!String.IsNullOrWhiteSpace(Model.LabelValue9)) { view.DataGridEquivalenceDetail.Columns["Value9"].IsVisible = true; view.DataGridEquivalenceDetail.Columns["Value9"].Header = model.LabelValue9; } if (!String.IsNullOrWhiteSpace(Model.LabelValue10)) { view.DataGridEquivalenceDetail.Columns["Value10"].IsVisible = true; view.DataGridEquivalenceDetail.Columns["Value10"].Header = model.LabelValue10; } PostFindAction("CONEquivalences", Model.Details.Count, ""); } catch (FaultException ex) { MessageBox.Show(new BusinessException(ex).GetExceptionMessage(), "Error", MessageBoxButton.OK); FormIsBusy = false; PostFindAction("", 0, new BusinessException(ex).GetExceptionMessage()); } catch (Exception ex) { MessageBox.Show(new BusinessException(ex).GetExceptionMessage(), "Error", MessageBoxButton.OK); FormIsBusy = false; PostFindAction("", 0, new BusinessException(ex).GetExceptionMessage()); } }
public override List <CONEquivalence> FindAll(CONEquivalence data, Options option) { return(base.FindAll(data, option)); }
public override CONEquivalence FindById(CONEquivalence data) { return(base.FindById(data)); }
public override void AddMoreDetailFindById(CONEquivalence data) { }
public override void SaveOrUpdateDetails(CONEquivalence data) { base.SaveOrUpdateDetails(data); }