public static RepoAukcijaEntity FetchRepoAukcija(DataAccessAdapterBase adapter, PrefetchPath2 prefetchPath, DateTime datumAukcije)
{
RelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.PredicateExpression.Add(RepoAukcijaFields.DatumAukcije == datumAukcije);
return FetchRepoAukcijaCollection(adapter, bucket, prefetchPath).SingleOrDefault();
}
public static EntityCollection <ArtiklEntity> FetchActiveArtiklCollection(DataAccessAdapterBase adapter, long firmaId)
{
RelationPredicateBucket bucket = new RelationPredicateBucket(ArtiklFields.IsActive == true);
bucket.PredicateExpression.Add(ArtiklFields.FirmaId == firmaId);
return(FetchArtiklCollection(adapter, bucket, null));
}
public static ErrorEntity FetchError(DataAccessAdapterBase adapter, PrefetchPath2 prefetchPath, long ErrorId)
{
ErrorEntity _ErrorEntity = new ErrorEntity(ErrorId);
adapter.FetchEntity(_ErrorEntity, prefetchPath);
return(_ErrorEntity);
}
public FileContentResult RacunReport(long racunGlavaId)
{
DataAccessAdapterBase adapter = Helpers.Helper.GetDataAccessAdapter();
long firmaId = UserEntity.GetFirmaId(adapter, User.Identity.Name);
string reportPath = Server.MapPath(string.Format("~/ReportTemplates/{0}/Racun.xls", firmaId));
FlexCel.XlsAdapter.XlsFile xls = new FlexCel.XlsAdapter.XlsFile();
xls.Open(reportPath);
List <RacunReport> racunGlavaList = new List <RacunReport>();
racunGlavaList.Add(new RacunReport(adapter, racunGlavaId));
FlexCel.Report.FlexCelReport report = new FlexCel.Report.FlexCelReport();
report.AddTable("Racun", racunGlavaList);
report.Run(xls);
using (System.IO.MemoryStream ms = new System.IO.MemoryStream())
{
FlexCel.Render.FlexCelPdfExport pdfExport = new FlexCel.Render.FlexCelPdfExport(xls);
pdfExport.BeginExport(ms);
pdfExport.ExportAllVisibleSheets(false, "");
pdfExport.EndExport();
//xls.Save(ms);
ms.Position = 0;
return(File(ms.ToArray(), "application/pdf"));
}
}
/// <summary>
/// Returns number of entities after filterBucket is applied.
/// If you need number of all entities send null as filterBucket.
/// </summary>
public static int GetNumberOfEntities(DataAccessAdapterBase adapter,
IRelationPredicateBucket filterBucket)
{
EntityCollection entityCollection = new EntityCollection(new PartnerEntityFactory());
return(adapter.GetDbCount(entityCollection, filterBucket));
}
public ActionResult GetPartnerCollectionForPaging(string sidx, string sord, string filters, int page = 1)
{
using (DataAccessAdapterBase adapter = Helper.GetDataAccessAdapter())
{
RelationPredicateBucket bucket = new RelationPredicateBucket();
long firmaId = UserEntity.GetFirmaId(adapter, User.Identity.Name);
bucket.PredicateExpression.Add(PartnerFields.FirmaId == firmaId);
if (filters != null)
{
bucket.PredicateExpression.Add(PredicateHelper.CreatePredicateFromJqGridFilterString(filters, typeof(PartnerFields), DbGenericHelper.GetDbGenericTypeByName));
}
if (!string.IsNullOrWhiteSpace(filters))
{
JqGridFilter jqGridFilter = JsonConvert.DeserializeObject <JqGridFilter>(filters);
bool foo;
JqGridFilterItem filterItem = jqGridFilter.rules.Where(r => r.field == PartnerFields.IsActive.Name && bool.TryParse(r.data, out foo)).SingleOrDefault();
if (filterItem != null)
{
bool isActive = bool.Parse(filterItem.data);
bucket.PredicateExpression.Add(PartnerFields.IsActive == isActive);
}
}
bool?isSortAscending = PagerBase.IsJqgridSortAscending(sord);
PartnerPager partnerPager = new PartnerPager();
partnerPager.LoadData(adapter, bucket, page, Common.Config.JqGridPageSize, sidx, isSortAscending);
return(CreateJsonResponse(partnerPager.CreateJqGridRespose()));
}
}
public ActionResult SavePdv(PdvEntity pdv)
{
bool isSaved = false;
DataAccessAdapterBase adapter = Helper.GetDataAccessAdapter(User.Identity.Name);
using (adapter)
{
adapter.StartTransaction(System.Data.IsolationLevel.Serializable, "SavePdv");
PdvEntity pdv4Save;
if (pdv.PdvId == 0)
{
pdv4Save = pdv;
pdv4Save.FirmaId = UserEntity.GetFirmaId(adapter, User.Identity.Name);
}
else
{
pdv4Save = PdvEntity.FetchPdv(adapter, null, pdv.PdvId);
pdv4Save.UpdateDataFromOtherObject(pdv, null, null);
}
isSaved = adapter.SaveEntity(pdv4Save);
adapter.Commit();
}
dynamic response = new { IsSaved = isSaved };
return(CreateJsonResponse(response));
}
public static FirmaEntity FetchFirma(DataAccessAdapterBase adapter, PrefetchPath2 prefetchPath, long FirmaId)
{
FirmaEntity _FirmaEntity = new FirmaEntity(FirmaId);
adapter.FetchEntity(_FirmaEntity, prefetchPath);
return(_FirmaEntity);
}
public static ArtiklEntity FetchArtikl(DataAccessAdapterBase adapter, PrefetchPath2 prefetchPath, long ArtiklId)
{
ArtiklEntity _ArtiklEntity = new ArtiklEntity(ArtiklId);
adapter.FetchEntity(_ArtiklEntity, prefetchPath);
return(_ArtiklEntity);
}
public static RoleRoEntity FetchRoleRo(DataAccessAdapterBase adapter, PrefetchPath2 prefetchPath, long RoleRoId)
{
RoleRoEntity _RoleRoEntity = new RoleRoEntity(RoleRoId);
adapter.FetchEntity(_RoleRoEntity, prefetchPath);
return(_RoleRoEntity);
}
public ActionResult GetArtiklCollectionForPaging(string sidx, string sord, string filters, int page = 1)
{
using (DataAccessAdapterBase adapter = Helper.GetDataAccessAdapter())
{
RelationPredicateBucket bucket = new RelationPredicateBucket();
long firmaId = UserEntity.GetFirmaId(adapter, User.Identity.Name);
bucket.PredicateExpression.Add(ArtiklFields.FirmaId == firmaId);
if (filters != null)
{
bucket.Relations.Add(ArtiklEntity.Relations.PdvEntityUsingPdvId);
bucket.PredicateExpression.Add(PredicateHelper.CreatePredicateFromJqGridFilterString(filters, typeof(ArtiklFields), DbGenericHelper.GetDbGenericTypeByName));
}
bool?isSortAscending = PagerBase.IsJqgridSortAscending(sord);
PrefetchPath2 prefetchPath = new PrefetchPath2(EntityType.ArtiklEntity);
prefetchPath.Add(ArtiklEntity.PrefetchPathPdv);
ArtiklPager artiklPager = new ArtiklPager();
artiklPager.LoadData(adapter, bucket, page, Common.Config.JqGridPageSize, sidx, isSortAscending);
return(CreateJsonResponse(artiklPager.CreateJqGridRespose()));
}
}
public static AuditInfoEntity FetchAuditInfo(DataAccessAdapterBase adapter, PrefetchPath2 prefetchPath, long AuditInfoId)
{
AuditInfoEntity _AuditInfoEntity = new AuditInfoEntity(AuditInfoId);
adapter.FetchEntity(_AuditInfoEntity, prefetchPath);
return(_AuditInfoEntity);
}
public override bool ChangePassword(string name, string oldPwd, string newPwd)
{
using (DataAccessAdapterBase adapter = Helper.GetDataAccessAdapter(name))
{
return(CoolJ.EntityClasses.UserEntity.ChangePassword(adapter, name, oldPwd, newPwd));
}
}
public static RacunStavkaEntity FetchRacunStavka(DataAccessAdapterBase adapter, PrefetchPath2 prefetchPath, long RacunStavkaId)
{
RacunStavkaEntity _RacunStavkaEntity = new RacunStavkaEntity(RacunStavkaId);
adapter.FetchEntity(_RacunStavkaEntity, prefetchPath);
return(_RacunStavkaEntity);
}
public AukcijaTrezorskihZapisaPager(DataAccessAdapterBase adapter, string baseDirectory)
{
this.AukcijaDateDictionary = new Dictionary<DateTime, string>();
DirectoryInfo directoryInfo = new DirectoryInfo(Path.Combine(baseDirectory, Config.AukcijaTrezorskihZapisaFolderPath()));
foreach (FileInfo fileInfo in directoryInfo.EnumerateFiles())
{
try
{
string[] fileParts = fileInfo.Name.Split('_');
int year = Convert.ToInt32(fileParts[3].Replace(".xls", ""));
int month = Convert.ToInt32(fileParts[2]);
int day = Convert.ToInt32(fileParts[1]);
DateTime date = new DateTime(year, month, day);
this.AukcijaDateDictionary.Add(date, fileInfo.Name);
}
catch (Exception ex)
{
ErrorEntity.LogException(adapter, ex);
}
}
this.AukcijaDateDictionary = this.AukcijaDateDictionary.
OrderByDescending(ad => ad.Key).
ToDictionary(ad => ad.Key, ad => ad.Value);
}
public static PdvEntity FetchPdv(DataAccessAdapterBase adapter, PrefetchPath2 prefetchPath, long PdvId)
{
PdvEntity _PdvEntity = new PdvEntity(PdvId);
adapter.FetchEntity(_PdvEntity, prefetchPath);
return(_PdvEntity);
}
/// <summary>
/// Efficient pageing for grid.
/// </summary>
/// <param name="pageNumber">Must be greater than zero.</param>
/// <param name="sortDirection">Validne vrijednosti su 'asc' i 'desc'.</param>
public static EntityCollection <ArtiklEntity> FetchArtiklCollectionForPaging(DataAccessAdapterBase adapter,
RelationPredicateBucket bucket,
PrefetchPath2 prefetchPath,
int pageNumber,
int pageSize,
string sortField,
bool isSortAscending)
{
string sortDirection = isSortAscending ? "asc" : "desc";
Type sortEntityFieldType = typeof(ArtiklFields);
string sortEntityFieldTypeName = SortHelper.GetEntityFieldTypeNameForSorting(sortField, sortEntityFieldType);
if (!string.IsNullOrWhiteSpace(sortEntityFieldTypeName))
{
sortEntityFieldType = Type.GetType(sortEntityFieldTypeName);
}
sortField = SortHelper.GetSortField(sortField);
SortExpression sort = SortHelper.GetSortExpression(sortField, sortDirection, sortEntityFieldType);
EntityCollection <ArtiklEntity> toReturn = new EntityCollection <ArtiklEntity>(new ArtiklEntityFactory());
adapter.FetchEntityCollection(toReturn, bucket, pageSize, sort, prefetchPath, pageNumber, pageSize);
return(toReturn);
}
public void UpdateModelFromJson(DataAccessAdapterBase adapter, string racunGlavaJson, string racunStavkaCollectionJson)
{
JsonSerializerSettings jsonSettings = new JsonSerializerSettings();
CultureInfo currentCulture = System.Threading.Thread.CurrentThread.CurrentCulture;
jsonSettings.Culture = currentCulture;
RacunGlavaEntity racunGlavaDeserialized = JsonConvert.DeserializeObject<RacunGlavaEntity>(racunGlavaJson, jsonSettings);
this.RacunGlava.UpdateDataFromOtherObject(racunGlavaDeserialized, null, null);
this.RacunStavkaCollectionToDelete = this.RacunGlava.RacunStavkaCollection.GetEntitiesNotIncludedInJson(racunStavkaCollectionJson);
foreach (RacunStavkaEntity racunStavka in this.RacunStavkaCollectionToDelete)
{
this.RacunGlava.RacunStavkaCollection.Remove(racunStavka);
}
this.RacunGlava.RacunStavkaCollection.UpdateEntityCollectionFromJson(racunStavkaCollectionJson, RacunStavkaFields.RacunStavkaId, null, null, jsonSettings);
TarifaEntity tarifa = TarifaEntity.FetchTarifa(adapter, null, this.RacunGlava.TarifaId);
short counter = 0;
foreach (RacunStavkaEntity racunStavka in this.RacunStavkaCollection)
{
racunStavka.Pozicija = counter++;
racunStavka.RefreshCalculatedData(tarifa.Stopa);
}
}
public static UserEntity FetchUser(DataAccessAdapterBase adapter, PrefetchPath2 prefetchPath, long UserId)
{
UserEntity _UserEntity = new UserEntity(UserId);
adapter.FetchEntity(_UserEntity, prefetchPath);
return(_UserEntity);
}
public static long GetFirmaId(DataAccessAdapterBase adapter, string username)
{
RelationPredicateBucket bucket = new RelationPredicateBucket(UserFields.Username == username);
IEnumerable <UserEntity> userCollection = UserEntity.FetchUserCollection(adapter, bucket, null);
return(userCollection.Single().FirmaId);
}
public static PartnerEntity FetchPartner(DataAccessAdapterBase adapter, PrefetchPath2 prefetchPath, long PartnerId)
{
PartnerEntity _PartnerEntity = new PartnerEntity(PartnerId);
adapter.FetchEntity(_PartnerEntity, prefetchPath);
return(_PartnerEntity);
}
public RepoAukcijaViewModel(DataAccessAdapterBase adapter, DateTime? datumAukcije)
{
IEnumerable<DateTime> repoAukcijaDatumList = RepoAukcijaEntity.FetchRepoAukcijaDateCollection(adapter);
if (datumAukcije.HasValue)
{
this.RepoAukcija = RepoAukcijaEntity.FetchRepoAukcija(adapter, null, datumAukcije.Value);
}
if (null == this.RepoAukcija)
{
this.RepoAukcija = RepoAukcijaEntity.FetchRepoAukcija(adapter, null, repoAukcijaDatumList.Max());
}
this.DatumAukcijeSelectList = new List<SelectListItem>();
foreach (DateTime date in repoAukcijaDatumList)
{
SelectListItem selectListItem = new SelectListItem()
{
Value = date.ToShortDateString(),
Text = date.ToShortDateString(),
Selected = date == this.RepoAukcija.DatumAukcije
};
this.DatumAukcijeSelectList.Add(selectListItem);
}
}
public ActionResult SaveArtikl(ArtiklEntity artikl)
{
bool isSaved = false;
DataAccessAdapterBase adapter = Helper.GetDataAccessAdapter(User.Identity.Name);
using (adapter)
{
adapter.StartTransaction(System.Data.IsolationLevel.Serializable, "SaveArtikl");
ArtiklEntity artikl4Save;
if (artikl.ArtiklId == 0)
{
artikl4Save = artikl;
artikl4Save.IsActive = true;
artikl4Save.FirmaId = UserEntity.GetFirmaId(adapter, User.Identity.Name);
}
else
{
artikl4Save = ArtiklEntity.FetchArtikl(adapter, null, artikl.ArtiklId);
artikl4Save.UpdateDataFromOtherObject(artikl, null, null);
}
isSaved = adapter.SaveEntity(artikl4Save);
adapter.Commit();
}
dynamic response = new { IsSaved = isSaved };
return(CreateJsonResponse(response));
}
public ActionResult SaveConfig(ConfigEntity config)
{
bool isSaved = false;
if (config.AktivnaGodina >= 2005 && config.AktivnaGodina <= 2025)
{
DataAccessAdapterBase adapter = Helper.GetDataAccessAdapter(User.Identity.Name);
using (adapter)
{
adapter.StartTransaction(System.Data.IsolationLevel.Serializable, "SaveConfig");
ConfigEntity config4Save;
if (config.ConfigId == 0)
{
config4Save = config;
config4Save.FirmaId = UserEntity.GetFirmaId(adapter, User.Identity.Name);
}
else
{
config4Save = ConfigEntity.FetchConfig(adapter, null, config.ConfigId);
config4Save.UpdateDataFromOtherObject(config, null, null);
}
isSaved = adapter.SaveEntity(config4Save);
adapter.Commit();
}
}
dynamic response = new { IsSaved = isSaved };
return(CreateJsonResponse(response));
}
public ActionResult SaveTarifa(TarifaEntity tarifa)
{
bool isSaved = false;
DataAccessAdapterBase adapter = Helper.GetDataAccessAdapter(User.Identity.Name);
using (adapter)
{
adapter.StartTransaction(System.Data.IsolationLevel.Serializable, "SaveTarifa");
TarifaEntity tarifa4Save;
if (tarifa.TarifaId == 0)
{
tarifa.IsActive = true;
tarifa4Save = tarifa;
tarifa4Save.FirmaId = UserEntity.GetFirmaId(adapter, User.Identity.Name);
}
else
{
tarifa4Save = TarifaEntity.FetchTarifa(adapter, null, tarifa.TarifaId);
tarifa4Save.UpdateDataFromOtherObject(tarifa, null, null);
}
isSaved = adapter.SaveEntity(tarifa4Save);
adapter.Commit();
}
dynamic response = new { IsSaved = isSaved };
return(CreateJsonResponse(response));
}
public static EntityRoEntity FetchEntityRo(DataAccessAdapterBase adapter, PrefetchPath2 prefetchPath, long EntityRoId)
{
EntityRoEntity _EntityRoEntity = new EntityRoEntity(EntityRoId);
adapter.FetchEntity(_EntityRoEntity, prefetchPath);
return(_EntityRoEntity);
}
public static EntityCollection<TrgovanjeGlavaEntity> FetchTrgovanjeGlavaCollection(DataAccessAdapterBase adapter, int godina, int mjesec, ValutaEnum valutaEnum)
{
DateTime startDate = new DateTime(godina, mjesec, 1);
DateTime endDate = startDate.AddMonths(1);
return FetchTrgovanjeGlavaCollection(adapter, startDate, endDate, valutaEnum);
}
public static StatusRoEntity FetchStatusRo(DataAccessAdapterBase adapter, PrefetchPath2 prefetchPath, long StatusRoId)
{
StatusRoEntity _StatusRoEntity = new StatusRoEntity(StatusRoId);
adapter.FetchEntity(_StatusRoEntity, prefetchPath);
return(_StatusRoEntity);
}
public FileContentResult RacunReportCollection(string jqGridFilters)
{
DataAccessAdapterBase adapter = Helpers.Helper.GetDataAccessAdapter();
long firmaId = UserEntity.GetFirmaId(adapter, User.Identity.Name);
string reportPath = Server.MapPath(string.Format("~/ReportTemplates/{0}/Racun.xls", firmaId));
FlexCel.XlsAdapter.XlsFile xls = new FlexCel.XlsAdapter.XlsFile();
xls.Open(reportPath);
short godina = ConfigEntity.GetInstance(adapter, firmaId).AktivnaGodina;
RelationPredicateBucket bucket = RacunGlavaPager.CreateBucket(godina, jqGridFilters);
bucket.PredicateExpression.Add(RacunGlavaFields.FirmaId == firmaId);
IEnumerable <RacunReport> racunReportCollection = CoolJ.DatabaseGeneric.BusinessLogic.RacunReport.GetRacunReportCollection(adapter, bucket, firmaId);
FlexCel.Report.FlexCelReport report = new FlexCel.Report.FlexCelReport();
report.AddTable("Racun", racunReportCollection);
report.Run(xls);
using (System.IO.MemoryStream ms = new System.IO.MemoryStream())
{
FlexCel.Render.FlexCelPdfExport pdfExport = new FlexCel.Render.FlexCelPdfExport(xls);
pdfExport.BeginExport(ms);
pdfExport.ExportAllVisibleSheets(false, "");
pdfExport.EndExport();
//xls.Save(ms);
ms.Position = 0;
return(File(ms.ToArray(), "application/pdf"));
}
}
/// <summary>
/// Efficient pageing for grid.
/// </summary>
/// <param name="pageNumber">Must be greater than zero.</param>
/// <param name="sortDirection">Validne vrijednosti su 'asc' i 'desc'.</param>
public static EntityCollection<ArtiklEntity> FetchArtiklCollectionForPaging(DataAccessAdapterBase adapter,
RelationPredicateBucket bucket,
PrefetchPath2 prefetchPath,
int pageNumber,
int pageSize,
string sortField,
bool isSortAscending)
{
string sortDirection = isSortAscending ? "asc" : "desc";
Type sortEntityFieldType = typeof(ArtiklFields);
string sortEntityFieldTypeName = SortHelper.GetEntityFieldTypeNameForSorting(sortField, sortEntityFieldType);
if (!string.IsNullOrWhiteSpace(sortEntityFieldTypeName))
{
sortEntityFieldType = Type.GetType(sortEntityFieldTypeName);
}
sortField = SortHelper.GetSortField(sortField);
SortExpression sort = SortHelper.GetSortExpression(sortField, sortDirection, sortEntityFieldType);
EntityCollection<ArtiklEntity> toReturn = new EntityCollection<ArtiklEntity>(new ArtiklEntityFactory());
adapter.FetchEntityCollection(toReturn, bucket, pageSize, sort, prefetchPath, pageNumber, pageSize);
return toReturn;
}
public static BrojacEntity FetchBrojac(DataAccessAdapterBase adapter, PrefetchPath2 prefetchPath, long BrojacId)
{
BrojacEntity _BrojacEntity = new BrojacEntity(BrojacId);
adapter.FetchEntity(_BrojacEntity, prefetchPath);
return(_BrojacEntity);
}
public static ConfigEntity FetchConfig(DataAccessAdapterBase adapter, PrefetchPath2 prefetchPath, long ConfigId)
{
ConfigEntity _ConfigEntity = new ConfigEntity(ConfigId);
adapter.FetchEntity(_ConfigEntity, prefetchPath);
return(_ConfigEntity);
}
public static TarifaEntity FetchTarifa(DataAccessAdapterBase adapter, PrefetchPath2 prefetchPath, long TarifaId)
{
TarifaEntity _TarifaEntity = new TarifaEntity(TarifaId);
adapter.FetchEntity(_TarifaEntity, prefetchPath);
return(_TarifaEntity);
}
public override string[] GetRolesForUser(string username)
{
using (DataAccessAdapterBase adapter = Helper.GetDataAccessAdapter())
{
var user = UserEntity.FetchUser(adapter, username);
return(new string[] { user.Role.Name });
}
}
public static UserEntity FetchUser(DataAccessAdapterBase adapter, string userName, string passwordHash)
{
RelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.PredicateExpression.Add(UserFields.Username == userName);
bucket.PredicateExpression.Add(UserFields.Password == passwordHash);
return FetchUserCollection(adapter, bucket, null).SingleOrDefault();
}
public TrgovanjeGodinaViewModel(DataAccessAdapterBase adapter, int godina)
{
this.TrgovanjeMjesecList = TrgovanjeMjesec.GetTrgovanjeMjesecCollection(adapter, godina);
this.Godina = godina;
LoadChartData(this.TrgovanjeMjesecList);
this.GodinaSelectList = Helper.CreateTrgovanjeGlavaGodinaSelectList(adapter, godina);
}
public ActionResult GetTarifa(long tarifaId)
{
using (DataAccessAdapterBase adapter = Helper.GetDataAccessAdapter())
{
TarifaEntity tarifa = TarifaEntity.FetchTarifa(adapter, null, tarifaId);
return(CreateJsonResponse(tarifa));
}
}
public ActionResult GetStatusCollection()
{
using (DataAccessAdapterBase adapter = Helper.GetDataAccessAdapter())
{
IEnumerable <StatusRoEntity> statusCollection = StatusRoEntity.FetchStatusRoCollection(adapter, null, null).OrderBy(s => s.Name);
return(CreateJsonResponse(statusCollection));
}
}
public static List<int> GodinaTrgovanjaCollection(DataAccessAdapterBase adapter)
{
if (null == _godinaTrgovanjaCollection)
{
LoadTrgovanjeGodinaList(adapter);
}
return _godinaTrgovanjaCollection;
}
public TrgovanjeMjesecRokHnbViewModel(DataAccessAdapterBase adapter, int godina, int mjesec)
: base(adapter, godina, mjesec)
{
this.TrgovanjeGlavaHnbCollection = TrgovanjeGlavaHnbEntity.FetchTrgovanjeGlavaHnbCollection(adapter, godina, mjesec).OrderBy(tg => tg.Datum);
//foreach (TrgovanjeGlavaEntity trgovanjeGlava in this.TrgovanjeGlavaCollection)
//{
// trgovanjeGlava.LoadTrgovanjeGlavaPrethodniDan(adapter);
//}
}
public void LoadViewSpecificData(DataAccessAdapterBase adapter)
{
PrefetchPath2 prefetchPathArtikl = new PrefetchPath2(EntityType.ArtiklEntity);
prefetchPathArtikl.Add(ArtiklEntity.PrefetchPathPdv);
this.ArtiklCollection = ArtiklEntity.FetchArtiklCollection(adapter, null, prefetchPathArtikl).OrderBy(a => a.Naziv);
this.PartnerCollection = PartnerEntity.FetchPartnerCollection(adapter, null, null).OrderBy(p => p.Naziv);
this.TarifaCollection = TarifaEntity.FetchTarifaCollection(adapter, null, null).OrderBy(t => t.Naziv);
this.StatusCollection = StatusRoEntity.FetchStatusRoCollection(adapter, null, null).OrderBy(s => s.Name);
}
protected override void SetDataSource(DataAccessAdapterBase adapter, int pageNumber, int pageSize, string sortField, bool isSortAscending)
{
PrefetchPath2 prefetchPath = new PrefetchPath2(EntityType.ArtiklEntity);
prefetchPath.Add(ArtiklEntity.PrefetchPathPdv);
IEnumerable<ArtiklEntity> artiklCollection =
ArtiklEntity.FetchArtiklCollectionForPaging(adapter, null, prefetchPath, pageNumber, pageSize, sortField, isSortAscending);
this.DataSource = artiklCollection;
this.NoOfRecords = ArtiklEntity.GetNumberOfEntities(adapter, null);
}
protected override void SetDataSource(DataAccessAdapterBase adapter, int pageNumber, int pageSize, string sortField, bool isSortAscending)
{
PrefetchPath2 prefetchPath = new PrefetchPath2(EntityType.RacunGlavaEntity);
prefetchPath.Add(RacunGlavaEntity.PrefetchPathPartner);
prefetchPath.Add(RacunGlavaEntity.PrefetchPathStatus);
prefetchPath.Add(RacunGlavaEntity.PrefetchPathRacunStavkaCollection);
this.DataSource = RacunGlavaEntity.FetchRacunGlavaCollectionForPaging(adapter, null, prefetchPath, pageNumber, pageSize, sortField, isSortAscending);
this.NoOfRecords = RacunGlavaEntity.GetNumberOfEntities(adapter, null);
}
public TrgovanjeGodinaRokViewModelBase(DataAccessAdapterBase adapter, int godina)
{
this.Godina = godina;
this.TrgovanjeVrstaList = new List<TrgovanjeVrstaRoEntity>();
foreach (TrgovanjeVrstaEnum trgovanjeVrstaEnum in Helper.TrgovanjeVrstaEnumArrayZaPrikaz)
{
TrgovanjeVrstaRoEntity trgovanjeVrsta = TrgovanjeVrstaRoEntity.FetchTrgovanjeVrstaRo(adapter, null, (long)trgovanjeVrstaEnum);
this.TrgovanjeVrstaList.Add(trgovanjeVrsta);
}
}
public UserViewModel(DataAccessAdapterBase adapter, long? userId)
{
if (userId.HasValue)
{
this.User = UserEntity.FetchUser(adapter, null, userId.Value);
}
else
{
this.User = new UserEntity();
}
}
public SudionikViewModel(DataAccessAdapterBase adapter, long? sudionikId)
{
if (sudionikId.HasValue)
{
this.Sudionik = SudionikEntity.FetchSudionik(adapter, null, sudionikId.Value);
}
else
{
this.Sudionik = new SudionikEntity();
}
}
private HtmlPageEntity GetHtmlPage(DataAccessAdapterBase adapter, long? htmlPageId)
{
if (htmlPageId.HasValue && htmlPageId.Value > 0)
{
return HtmlPageEntity.FetchHtmlPage(adapter, null, htmlPageId.Value);
}
else
{
return new HtmlPageEntity();
}
}
public static TrgovanjeGlavaEntity FetchTrgovanjeGlavaForGuiDisplay(DataAccessAdapterBase adapter, long trgovanjeGlavaId)
{
PrefetchPath2 prefetchPath = new PrefetchPath2(EntityType.TrgovanjeGlavaEntity);
IPrefetchPathElement2 trgovanjeStavkaPrefetchElement = prefetchPath.Add(TrgovanjeGlavaEntity.PrefetchPathTrgovanjeStavkaCollection);
trgovanjeStavkaPrefetchElement.SubPath.Add(TrgovanjeStavkaEntity.PrefetchPathValuta);
trgovanjeStavkaPrefetchElement.SubPath.Add(TrgovanjeStavkaEntity.PrefetchPathTrgovanjeVrsta);
TrgovanjeGlavaEntity trgovanjeGlava = TrgovanjeGlavaEntity.FetchTrgovanjeGlava(adapter, prefetchPath, trgovanjeGlavaId);
trgovanjeGlava.LoadTrgovanjeGlavaPrethodniDan(adapter);
return trgovanjeGlava;
}
public static EntityCollection<TrgovanjeGlavaHnbEntity> FetchTrgovanjeGlavaHnbCollection(DataAccessAdapterBase adapter,
DateTime startDate,
DateTime endDate)
{
RelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.PredicateExpression.Add(PredicateHelper.FilterValidEntities(startDate, endDate, TrgovanjeGlavaHnbFields.Datum));
PrefetchPath2 prefetchPath = new PrefetchPath2(EntityType.TrgovanjeGlavaHnbEntity);
prefetchPath.Add(TrgovanjeGlavaHnbEntity.PrefetchPathTrgovanjeStavkaHnbCollection);
return FetchTrgovanjeGlavaHnbCollection(adapter, bucket, prefetchPath);
}
public TrgovanjeMjesecViewModel(DataAccessAdapterBase adapter, int godina, int mjesec, ValutaEnum valutaEnum)
{
this.TrgovanjeGlavaCollection = TrgovanjeGlavaEntity.FetchTrgovanjeGlavaCollection(adapter, godina, mjesec, valutaEnum).OrderBy(tg => tg.Datum);
this.Godina = godina;
this.Mjesec = mjesec;
this.ValutaEnum = valutaEnum;
if (ValutaEnum.Kn == valutaEnum)
{
LoadChartData(this.TrgovanjeGlavaCollection);
}
}
public ArtiklViewModel(DataAccessAdapterBase adapter, long? artiklId)
{
if (artiklId.HasValue)
{
this.Artikl = ArtiklEntity.FetchArtikl(adapter, null, artiklId.Value);
}
else
{
this.Artikl = new ArtiklEntity();
this.Artikl.Jm = "kom";
this.Artikl.IsActive = true;
}
}
public static List<TrgovanjeMjesecRok> GetTrgovanjeMjesecRokCollection(DataAccessAdapterBase adapter, int godina, TrgovanjeVrstaEnum[] trgovanjeVrstaEnumArray)
{
List<TrgovanjeMjesecRok> trgovanjeMjesecListRok = new List<TrgovanjeMjesecRok>();
EntityCollection<TrgovanjeStavkaEntity> trgovanjeStavkaCollection =
TrgovanjeStavkaEntity.FetchTrgovanjeStavkaCollection(adapter, godina, ValutaEnum.Kn);
for (int mjesec = 1; mjesec < 13; mjesec++)
{
TrgovanjeMjesecRok trgovanjeMjesecRok = (from ts in trgovanjeStavkaCollection
where ts.ValutaId == (long)ValutaEnum.Kn && ts.TrgovanjeGlava.Datum.Month == mjesec
group ts by ts.ValutaId into g
select new TrgovanjeMjesecRok()
{
Valuta = (ValutaEnum)g.Key,
Godina = godina,
Mjesec = mjesec,
PrometUkupno = g.Sum(ts => ts.Promet),
KamatnaStopaUkupno = g.Sum(ts => ts.Promet * ts.PrometDodatak) / g.Sum(ts => ts.Promet)
}).SingleOrDefault();
if (null != trgovanjeMjesecRok)
{
trgovanjeMjesecRok.TrgovanjeRokList = new List<TrgovanjeRok>();
foreach (TrgovanjeVrstaEnum trgovanjeVrstaEnum in trgovanjeVrstaEnumArray)
{
TrgovanjeRok trgovanjeRok = (from ts in trgovanjeStavkaCollection
where ts.ValutaId == (long)ValutaEnum.Kn &&
ts.TrgovanjeGlava.Datum.Month == mjesec &&
ts.TrgovanjeVrstaId == (long)trgovanjeVrstaEnum &&
ts.Promet > 0
group ts by ts.ValutaId into g
select new TrgovanjeRok()
{
TrgovanjeVrstaEnum = trgovanjeVrstaEnum,
Promet = g.Sum(ts => ts.Promet),
KamatnaStopa = g.Sum(ts => ts.Promet * ts.PrometDodatak) / g.Sum(ts => ts.Promet)
}).SingleOrDefault();
if (null != trgovanjeRok)
{
trgovanjeMjesecRok.TrgovanjeRokList.Add(trgovanjeRok);
}
}
trgovanjeMjesecListRok.Add(trgovanjeMjesecRok);
}
}
return trgovanjeMjesecListRok;
}
public static List<DateTime> FetchRepoAukcijaDateCollection(DataAccessAdapterBase adapter)
{
if (null == _repoAukcijaDateCollection)
{
EntityCollection<RepoAukcijaEntity> repoAukcijaEntityCollection = new EntityCollection<RepoAukcijaEntity>(new RepoAukcijaEntityFactory());
ExcludeIncludeFieldsList includeFieldList = new ExcludeIncludeFieldsList(false);
includeFieldList.Add(RepoAukcijaFields.DatumAukcije);
adapter.FetchEntityCollection(repoAukcijaEntityCollection, includeFieldList, null);
_repoAukcijaDateCollection = repoAukcijaEntityCollection.OrderByDescending(ra => ra.DatumAukcije).Select(ra => ra.DatumAukcije).ToList();
}
return _repoAukcijaDateCollection;
}
public override void Save(DataAccessAdapterBase adapter, bool refetchAfterSave, bool recurse)
{
if (!this.IsNew &&
this.Fields[UserFields.Username.Name].IsChanged)
{
throw new Exception("Username change is not allowed.");
}
if (this.Fields[UserFields.Password.Name].IsChanged)
{
this.Password = NinjaSoftware.Api.Core.Security.GetPasswordHash(this.Password);
}
base.Save(adapter, refetchAfterSave, recurse);
}
public static EntityCollection<TrgovanjeStavkaHnbEntity> FetchTrgovanjeStavkaHnbCollection(DataAccessAdapterBase adapter, int godina)
{
DateTime startDate = new DateTime(godina, 1, 1);
DateTime endDate = startDate.AddYears(1);
RelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.Add(TrgovanjeStavkaHnbEntity.Relations.TrgovanjeGlavaHnbEntityUsingTrgovanjeGlavaHnbId);
bucket.PredicateExpression.Add(PredicateHelper.FilterValidEntities(startDate, endDate, TrgovanjeGlavaHnbFields.Datum));
PrefetchPath2 prefetchPath = new PrefetchPath2(EntityType.TrgovanjeStavkaHnbEntity);
prefetchPath.Add(TrgovanjeStavkaHnbEntity.PrefetchPathTrgovanjeGlavaHnb);
EntityCollection<TrgovanjeStavkaHnbEntity> trgovanjeStavkaHnbCollection = TrgovanjeStavkaHnbEntity.FetchTrgovanjeStavkaHnbCollection(adapter, bucket, prefetchPath);
return trgovanjeStavkaHnbCollection;
}
public static TrgovanjeGlavaEntity FetchTrgovanjeGlavaForGuiDisplay(DataAccessAdapterBase adapter, DateTime date)
{
RelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.PredicateExpression.Add(TrgovanjeGlavaFields.Datum <= date.Date);
SortExpression sort = new SortExpression(TrgovanjeGlavaFields.Datum | SortOperator.Descending);
EntityCollection<TrgovanjeGlavaEntity> trgovanjeGlavaCollection = new EntityCollection<TrgovanjeGlavaEntity>(new TrgovanjeGlavaEntityFactory());
adapter.FetchEntityCollection(trgovanjeGlavaCollection, bucket, 1, sort);
if (0 == trgovanjeGlavaCollection.Count)
{
sort = new SortExpression(TrgovanjeGlavaFields.Datum | SortOperator.Ascending);
adapter.FetchEntityCollection(trgovanjeGlavaCollection, null, 1, sort);
}
return FetchTrgovanjeGlavaForGuiDisplay(adapter, trgovanjeGlavaCollection.Single().TrgovanjeGlavaId);
}
public override void Delete(DataAccessAdapterBase adapter)
{
EntityCollection<TrgovanjeStavkaHnbEntity> trgovanjeStavkaHnbCollection = this.TrgovanjeStavkaHnbCollection;
if (null == trgovanjeStavkaHnbCollection ||
0 == trgovanjeStavkaHnbCollection.Count)
{
RelationPredicateBucket bucket = new RelationPredicateBucket(TrgovanjeStavkaHnbFields.TrgovanjeGlavaHnbId == this.TrgovanjeGlavaHnbId);
trgovanjeStavkaHnbCollection = TrgovanjeStavkaHnbEntity.FetchTrgovanjeStavkaHnbCollection(adapter, bucket, null);
}
foreach (TrgovanjeStavkaHnbEntity trgovanjeStavkaHnb in trgovanjeStavkaHnbCollection)
{
trgovanjeStavkaHnb.Delete(adapter);
}
base.Delete(adapter);
}
public TrgovanjeHnbViewModel(DataAccessAdapterBase adapter, long? trgovanjeGlavaHnbId)
{
if (trgovanjeGlavaHnbId.HasValue && trgovanjeGlavaHnbId.Value > 0)
{
PrefetchPath2 prefetchPath = new PrefetchPath2(EntityType.TrgovanjeGlavaHnbEntity);
IPrefetchPathElement2 trgovanjeStavkaHnbPrefetchElement = prefetchPath.Add(TrgovanjeGlavaHnbEntity.PrefetchPathTrgovanjeStavkaHnbCollection);
trgovanjeStavkaHnbPrefetchElement.SubPath.Add(TrgovanjeStavkaHnbEntity.PrefetchPathTrgovanjeVrsta);
this.TrgovanjeGlavaHnb = TrgovanjeGlavaHnbEntity.FetchTrgovanjeGlavaHnb(adapter, prefetchPath, trgovanjeGlavaHnbId.Value);
this.TrgovanjeStavkaHnbCollection = this.TrgovanjeGlavaHnb.TrgovanjeStavkaHnbCollection;
}
else
{
this.TrgovanjeGlavaHnb = new TrgovanjeGlavaHnbEntity();
this.TrgovanjeGlavaHnb.Datum = DateTime.Now;
this.TrgovanjeStavkaHnbCollection = new List<TrgovanjeStavkaHnbEntity>();
}
}
public static bool ChangePassword(DataAccessAdapterBase adapter,
string userName,
string oldPasswordHash,
string newPasswordHash)
{
UserEntity user = UserEntity.FetchUser(adapter, userName, oldPasswordHash);
if (null == user)
{
return false;
}
else
{
user.Password = newPasswordHash;
user.Save(adapter, false, false);
return true;
}
}
public void Save(DataAccessAdapterBase adapter)
{
foreach (RacunStavkaEntity racunStavka in this.RacunStavkaCollectionToDelete)
{
racunStavka.Delete(adapter);
}
foreach (RacunStavkaEntity racunStavka in this.RacunGlava.RacunStavkaCollection)
{
if (racunStavka.IsDirty)
{
this.RacunGlava.IsDirty = true;
}
racunStavka.Save(adapter, false, false);
}
this.RacunGlava.Save(adapter, false, false);
}
