public override String GetQuery(SECUserCompany 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";
}
if (data.User != null && data.User.Id != 0)
{
dml += " AND a.User.Id = :User \n";
}
dml += " order by a.Id asc ";
}
return(dml);
}
public override SECUserCompany Execute(SECUserCompany 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, SECUserCompany 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);
}
if (data.User != null && data.User.Id != 0)
{
query.SetInt32("User", data.User.Id);
}
}
}
public override void RemoveRules(SECUserCompany data)
{
base.RemoveRules(data);
}
public override void ModifyRules(SECUserCompany data)
{
base.ModifyRules(data);
data.LastUpdate = DateTime.Now;
}
public override void CommonRules(SECUserCompany data)
{
base.CommonRules(data);
}
public void AddDetails(SECUserCompany data)
{
}
public override void FindByIdRules(SECUserCompany data)
{
base.FindByIdRules(data);
}
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 <SECUserCompany> FindAll(SECUserCompany data, Options option)
{
return(base.FindAll(data, option));
}
public override SECUserCompany FindById(SECUserCompany data)
{
return(base.FindById(data));
}
public override void AddMoreDetailFindById(SECUserCompany data)
{
}
public override void SaveOrUpdateDetails(SECUserCompany data)
{
base.SaveOrUpdateDetails(data);
}
