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