public override String GetQuery(CONRecordDetail data, Boolean byId)
{
String dml = base.GetQuery(data, byId);
if (byId)
{
//add more parameters to method for query by id
}
else
{
//add more parameters to method for query by any field
if (data.SQL != null && data.SQL.Id != 0)
{
dml += " AND a.SQL.Id = :SQL \n";
}
if (data.Record != null && data.Record.Id != 0)
{
dml += " AND a.Record.Id = :Record \n";
}
dml += " order by a.Id asc ";
}
return(dml);
}
public override CONRecordDetail Execute(CONRecordDetail 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();
}
data = base.Execute(data, action, option, token);
if (action == Actions.Find && option == Options.Me)
{
}
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 SetQueryParameters(IQuery query, CONRecordDetail data, Boolean byId)
{
base.SetQueryParameters(query, data, byId);
if (byId)
{
//add more parameters to method for query by id
}
else
{
//add more parameters to method for query by any field
if (data.SQL != null && data.SQL.Id != 0)
{
query.SetInt32("SQL", data.SQL.Id);
}
if (data.Record != null && data.Record.Id != 0)
{
query.SetInt32("Record", data.Record.Id);
}
}
}
public override List <CONRecordDetail> FindAll(CONRecordDetail data, Options option)
{
return(base.FindAll(data, option));
}
public override CONRecordDetail FindById(CONRecordDetail data)
{
return(base.FindById(data));
}
public override void AddMoreDetailFindById(CONRecordDetail data)
{
}
public override void SaveOrUpdateDetails(CONRecordDetail data)
{
base.SaveOrUpdateDetails(data);
}
public override void ModifyRules(CONRecordDetail data)
{
base.ModifyRules(data);
data.LastUpdate = DateTime.Now;
}
public override void CommonRules(CONRecordDetail data)
{
base.CommonRules(data);
}
public void AddDetails(CONRecordDetail data)
{
}
public override void FindByIdRules(CONRecordDetail data)
{
base.FindByIdRules(data);
}
public override void RemoveRules(CONRecordDetail data)
{
base.RemoveRules(data);
}
