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