public EvaluationCardPrint (DbEntities.dbserver3.wordup.rows.Projekt projektDaten) : base(projektDaten) { LoadIdeePrint(); LoadAktivitaeten(); }
public AktivitaetenPrint(DbEntities.dbserver3.wordup.rows.Aktivitaet AktivitaetenEntry) { ID = AktivitaetenEntry.Id.ToString(); Type = AktivitaetenEntry.AktivitaetsTyp.AktivitaetsType; Wer = AktivitaetenEntry.Akteur.NameId; Details = AktivitaetenEntry.Details; PrintOutType = AktivitaetenEntry.AktivitaetsTyp.PrintOutType; SymbolFarbe = AktivitaetenEntry.AktivitaetsTyp.SymbolFarbe; }
public IdeePrint(DbEntities.dbserver3.wordup.rows.WSPlakat WSPlakateEntry) { ShowWMUDetail = false; ID = WSPlakateEntry.Id.ToString(); Idee = WSPlakateEntry.LangBeschreibung; OrtsHinweis = WSPlakateEntry.OrtsHinweis; Klasse = WSPlakateEntry.Organisation.CodeName; WMU = "W/M/U = " + WSPlakateEntry.WertW + "/" + WSPlakateEntry.WertM + "/" + WSPlakateEntry.WertU; WMUSumme = "IdeenPunkte = " + Convert.ToString(((WSPlakateEntry.WertW != null) ? WSPlakateEntry.WertW : 0) + ((WSPlakateEntry.WertM != null) ? WSPlakateEntry.WertM : 0) + ((WSPlakateEntry.WertU != null) ? WSPlakateEntry.WertU : 0)); }
public OrderToStoreLog SaveLogOrderToStore(OrderToStore orderToStore, string comments, string status, DateTime timestamp, bool bHasToSave = false) { var orderToStoreLog = new OrderToStoreLog { Comments = comments, OrderToStore = orderToStore, Status = status, Timestamp = timestamp }; DbEntities.OrderToStoreLog.Add(orderToStoreLog); if (bHasToSave) { DbEntities.SaveChanges(); } return(orderToStoreLog); }
private void CreatePlayerRootPage(DbEntities.dbserver3.multimedia.rows.Page sourceRootPage) { HsCentralServiceWebInterfacesServer._dbs.hsserver.ringplayerdb.rows.Page convertedSourceRootPage = TargetPlayerDb.Pages.NewRow(); convertedSourceRootPage.Id = sourceRootPage.Id; convertedSourceRootPage.DiagnosticText = sourceRootPage.DiagnosticText; convertedSourceRootPage.ExpectedDuration = (double) sourceRootPage.ExpectedDuration; convertedSourceRootPage.PageGroup = TargetPageGroup; convertedSourceRootPage.SortOrder = (int) sourceRootPage.SortOrder; convertedSourceRootPage.BorderColor = sourceRootPage.BorderColor; convertedSourceRootPage.Background = sourceRootPage.Background; convertedSourceRootPage.BorderThickness = sourceRootPage.BorderThickness; convertedSourceRootPage.HasFixedRatio = sourceRootPage.HasFixedRatio; convertedSourceRootPage.RatioX = sourceRootPage.RatioX; convertedSourceRootPage.RatioY = sourceRootPage.RatioY; convertedSourceRootPage.Table.Rows.Add(convertedSourceRootPage); CreateAllChildElements(sourceRootPage, convertedSourceRootPage); }
public IEnumerable <ProductStoreModel> GetAllProductStoreByStoreID(int storeID) { dbcontext = new DbEntities(); var query = from c in dbcontext.StoreDetails where c.Store.StoreID == storeID select c; return(query.ToList().Select( c => new ProductStoreModel() { Name = c.Product.Name, ProductID = c.Product.ProductID, Picture = c.Product.Picture.LoadImage(), Quantity = c.Quantity } )); }
private void addToGroup(int id, int GroupId, int uid) { using (DbEntities _db = new DbEntities()) { DateTime _now = DateTime.Now; GroupMember _new = new GroupMember() { UserId = id, GroupId = GroupId, CreatedDate = _now, CreatedBy = uid, UpdatedBy = uid, }; _db.GroupMembers.Add(_new); _db.SaveChanges(); } }
public HttpResponseMessage CreateNewJob(JobDTO jobDTO) { using (DbEntities entities = new DbEntities()) { Client_User _User = new Client_User { cu_name = jobDTO.Name, cu_surname = jobDTO.Surname, cu_email = jobDTO.Email, cu_contact = jobDTO.Contact, client_no = jobDTO.CompanyID }; Job job = new Job { job_title = jobDTO.Title, job_description = jobDTO.Description, job_attachement = jobDTO.Attachment, client_user_no = jobDTO.ClientID, job_date = jobDTO.Date, job_status = "Registered", Client_User = _User }; entities.Jobs.Add(job); entities.SaveChanges(); JobModel jobModel = new JobModel { ID = job.job_No, Title = job.job_title, Description = job.job_description, Attachment = job.job_attachement, ClientID = job.client_user_no, Date = job.job_date, Status = job.job_status }; var message = Request.CreateResponse(HttpStatusCode.Created, jobModel); message.Headers.Location = new Uri(Request.RequestUri + "/" + jobModel.ID); return(message); } }
private void InitializeOrganTree() { this.treeOrgan.Nodes.Clear(); using (DbEntities db = new DbEntities()) { var vList = db.Organizations.ToList(); this.ResolveOrganTree(vList, Guid.Empty.ToString(), this.treeOrgan.Nodes); // 生成树 if (treeOrgan.Nodes.Count == 0) { Response.Write("组织机构信息尚未初始化!"); Response.End(); return; } // 展开第一个树节点 this.treeOrgan.Nodes[0].Expanded = true; } }
/// <summary> /// 查询信息(根据SubTitle模糊查询) /// </summary> /// <param name="input">输入信息</param> /// <returns></returns> public static Dictionary <int, string> Search(string input) { var dic = new Dictionary <int, string>(); try { var db = new DbEntities(); dic = (from d in db.DreamTitle where d.SubTitle.Contains(input) select d).ToDictionary(key => key.DreamId, value => value.SubTitle); } catch (Exception ex) { LogService.InsertLog(ex); } return(dic); }
public DataPoolVO(DataPool datapool) { DbEntities db = new DbEntities(); this.Id = datapool.Id; this.DescricaoDataPool = datapool.Descricao; this.DescricaoDemanda = datapool.Demanda != null ? datapool.Demanda.Descricao : ""; this.DescricaoSistema = datapool.AUT.Descricao != null ? datapool.AUT.Descricao : ""; this.DataSolicitacao = datapool.DataSolicitacao; this.DataTermino = datapool.DataTermino; this.DescricaoTDM = datapool.TDM.Descricao; this.IdScriptCondicaoScript = datapool.IdScript_CondicaoScript; List <TestData> listaMassasTestes = new List <TestData>(); listaMassasTestes.AddRange(db.TestData.Where(x => x.IdDataPool == datapool.Id).ToList()); this.ListaMassa = listaMassasTestes; //DataPoolVOs.ListaMassa.ad }
/// <summary> /// 取当前页的数据。 /// </summary> /// <returns></returns> private List <Module> GetPagedData() { int pageIndex = this.Grid2.PageIndex; int pageSize = this.Grid2.PageSize; string sortField = this.Grid2.SortField; string sortDirection = this.Grid2.SortDirection; string key = this.tbKey.Text.Trim(); int type = (int)GoComType.Business; using (var db = new DbEntities()) { var vList = db.Modules .Where(p => p.Name.StartsWith(key) || p.Type.StartsWith(key) || p.Assembly.StartsWith(key)) .Select(p => new Module { Guid = p.Guid, Name = p.Name, Assembly = p.Assembly, Type = p.Type, Method = p.Method, Description = p.Description, Attributes = p.Attributes, Version = p.Version, Developer = p.Developer, SortCode = p.SortCode, Url = p.Url, Package = p.Package, LMTime = p.LMTime }) .ToList(); var v = vList.AsQueryable().Where(p => (p.Attributes & type) == type); if (!string.IsNullOrEmpty(sortField)) { v = v.DynamicSorting(sortField, sortDirection); } var vList2 = v.Skip(pageIndex * pageSize).Take(pageSize).ToList(); return(vList2); } }
public void SetCancelOrderToStore(long orderToStoreId) { var now = DateTime.Now; var orderToStore = new OrderToStore { OrderToStoreId = orderToStoreId, IsCanceled = true, DateTimeCanceled = now, LastStatus = string.Empty }; DbEntities.OrderToStore.Attach(orderToStore); DbEntities.Entry(orderToStore).Property(e => e.IsCanceled).IsModified = true; DbEntities.Entry(orderToStore).Property(e => e.DateTimeCanceled).IsModified = true; DbEntities.SaveChanges(); ((IObjectContextAdapter)DbEntities).ObjectContext.Detach(orderToStore); SaveLogOrderToStore(orderToStoreId, "Cancelado por el cliente", SettingsData.Constants.TrackConst.CANCELED, now, true); }
public IHttpActionResult GetParentPost(int id) { using (DbEntities _db = new DbEntities()) { var s = _db.DiscussionPosts.Find(id); if (s != null) { var result = new DiscussionPost(); result.Id = s.Id; result.DiscussionId = s.DiscussionId; result.Topic = s.Topic; return(Ok(result)); } } return(NotFound()); }
/// <summary> /// 审核用户 /// </summary> /// <param name="UserID"></param> /// <returns></returns> public string CheckUser(string UserID = "") { string res = "Error"; //查找该用户 var userdb = new DbEntities <User>().SimpleClient; var curuser = userdb.GetById(UserID); if (curuser != null) { //更新 curuser.IsChecked = true; if (userdb.Update(curuser)) { res = "OK"; } } return(res); }
public void Add(StoreUpModel model) { var franchiseStore = new FranchiseStore { AddressId = model.AddressId, FranchiseId = model.FranchiseId, Name = model.Name, UserIdIns = model.UserInsUpId, DatetimeIns = DateTime.Today, IsObsolete = false, WsAddress = model.WsAddress, ManageUserId = model.ManUserId, StoreEmail = model.StoreEmail, HasSendEmailWhenNewOrder = model.HasSendEmailWhenNewOrder }; DbEntities.FranchiseStore.Add(franchiseStore); DbEntities.SaveChanges(); }
/// <summary> /// This method will insert every missing column for each table into the database. Will only be called if HasallColumns() returns false. This means the user has an outdated .db file /// </summary> private static void InsertNewColumns() { using (DbEntities db = new DbEntities()) { //every column that SHOULD exist var settingNames = typeof(Settings).GetProperties().Select(property => property.Name).ToArray(); foreach (string column in settingNames) { if (!HasColumn(column, "settings")) { db.Database.ExecuteSqlCommand("ALTER TABLE SETTINGS ADD COLUMN " + column + " " + GetSettingColumnSqlType(column)); } } db.SaveChanges(); db.Dispose(); } }
public static DTO.ImageDTO GetImage(int id) { using (var ctx = new DbEntities()) { var image = ctx.Images.Find(id); if (image == null) { return(null); } var ImageDTO = new ImageDTO { Id = image.Id, MymeType = image.MymeType, UserId = image.UserId, BlobId = image.BlobId }; return(ImageDTO); } }
public static List <UserDTO> GetUsers(int?lastId = null) { using (var ctx = new DbEntities()) { var users = ctx.Users.AsNoTracking().AsQueryable(); if (lastId.HasValue) { users = users.Where(x => x.Id < lastId); } var usersDTO = new List <UserDTO>(); var dbusers = users.OrderByDescending(x => x.Id).Take(3).ToList(); foreach (User dbUser in dbusers) { var user = new UserDTO { BirthDate = dbUser.BirthDate, Id = dbUser.Id, PostsId = new List <int>(), LoginName = dbUser.LoginName, Nickname = dbUser.Nickname, PasswordHash = dbUser.PasswordHash, CreateTime = dbUser.CreateTime, Salt = dbUser.Salt, IsProfileShared = dbUser.IsProfileShared }; dbUser.Posts.Select(x => x.Id).ToList().ForEach(user.PostsId.Add); var Avatar = dbUser.Avatars.FirstOrDefault(x => x.UserId == user.Id); if (Avatar is Avatar) { user.ImageAvatarId = Avatar.ImageId; } else { user.ImageAvatarId = null; } usersDTO.Add(user); } return(usersDTO); } }
public ActionResult Index(ActionViewModel model) { try { var db = new DbEntities(); db.Actions.Add(new Models.Action() { Data = model.data, Software = model.software, ActionDate = DateTime.Now }); db.SaveChanges(); return(Json(new { status = "OK" })); } catch (Exception) { return(Json(new { status = "ERROR" })); } }
public long SaveAddressMap(AddressInfoModel model, bool bIsNew) { var address = bIsNew ? new Entities.Address() : DbEntities.Address.Single(e => e.AddressId == model.AddressId); var phoneToAdd = new ClientPhone { ClientPhoneId = model.PrimaryPhone.PhoneId }; DbEntities.ClientPhone.Attach(phoneToAdd); for (var i = address.ClientPhone.Count - 1; i >= 0; i--) { var phone = address.ClientPhone.ElementAt(i); address.ClientPhone.Remove(phone); } address.ClientPhone.Add(phoneToAdd); address.CountryName = model.Country.Value; address.RegionNameA = model.RegionA.Value; address.RegionNameB = model.RegionB.Value; address.RegionNameC = model.RegionC.Value; address.RegionNameD = model.RegionD.Value; address.ZipCodeValue = model.ZipCode.Value; address.PlaceId = model.PlaceId; address.Lat = model.Lat; address.Lng = model.Lng; address.ExtIntNumber = model.ExtIntNumber; address.MainAddress = model.MainAddress; address.Reference = model.Reference; address.IsMap = true; if (bIsNew) { DbEntities.Address.Add(address); } DbEntities.SaveChanges(); return(address.AddressId); }
public ActionResult Reviews(string id, string a, string reason) { var model = new List <Review>(); //show list using (HlidacStatu.Lib.Data.DbEntities db = new DbEntities()) { if (!string.IsNullOrEmpty(id) && !string.IsNullOrEmpty(a) && Devmasters.TextUtil.IsNumeric(id) ) { var iId = Convert.ToInt32(id); var item = db.Review.FirstOrDefault(m => m.Id == iId); if (item != null) { switch (a.ToLower()) { case "accepted": item.Accepted(this.User.Identity.Name); break; case "denied": item.Denied(this.User.Identity.Name, reason); break; default: break; } } return(RedirectToAction("Reviews", "Manage")); } else { model = db.Review.AsNoTracking() .Where(m => m.reviewed == null) .ToList(); } } return(View(model)); }
public ActionResult OutboundTaskDetail(string obtid = "-1") { if (int.TryParse(obtid, out int id)) { //视图模型 List<OutboundTaskDetailViewModel> model = new List<OutboundTaskDetailViewModel>(); //出库任务细节列表 var lists = new DbEntities<OutboundTaskDetail>().SimpleClient.GetList(); //遍历所有 foreach (OutboundTaskDetail item in lists) { //首先添加不是当前的对象 if (item.OutboundTaskDetailID != id) { model.Add(Formatterr.GetOutboundTaskDetailViewModel(item)); } } //获取当前查看的出库任务细节对象 OutboundTaskDetail cur = lists.Where(it => it.OutboundTaskDetailID == id).FirstOrDefault(); if (cur != null) { //不为空,存在该对象 //按时间排序 var temp = model.OrderBy(it => it.ChangeTime).ToList(); temp.Add(Formatterr.GetOutboundTaskDetailViewModel(cur)); //反转 temp.Reverse(); return View(temp); } model.Reverse(); return View(model); } TempData["Msg"] = "没有找到对象"; return RedirectToAction("OutboundTask", "Warehouse"); }
public ActionResult EditCar(int id) { TempData.Keep(); using (DbEntities entity = new DbEntities()) { var Result = (from c in entity.Cars where c.Car_Id == id select c).SingleOrDefault <Car>(); CarDto cmodel = new CarDto { ID = Result.Car_Id, Registration = Result.Registration, Model = Result.Model, Brand = Result.brand, Description = Result.Description, SeatsNumber = Result.SeatNumber, Image = Result.Image, CarCategory_Id = Result.Category_Id, CarStatus_Id = Result.CarStatus_Id, }; List <Car_Category> catList = new List <Car_Category>(); List <Car_Status> statusList = new List <Car_Status>(); using (DbEntities entities = new DbEntities()) { catList = (from l in entities.Car_Category select l).ToList <Car_Category>(); } using (DbEntities entities = new DbEntities()) { statusList = (from s in entities.Car_Status select s).ToList <Car_Status>(); } TempData.Clear(); ViewData["Department"] = new SelectList(catList, "CarCategory_Id", "CarCategory_Name", $"{cmodel.CarCategory_Id}"); ViewData["Status"] = new SelectList(statusList, "CarStatus_Id", "CarStatus_Name", $"{ cmodel.CarStatus_Id }"); return(View(cmodel)); } }
public static void DefaultTemplate(DbEntities db) { var user = db.User.Local.Where(r => r.Name.Contains("System Admin")).FirstOrDefault() ?? db.User.Where(r => r.Name.Contains("System Admin")).FirstOrDefault(); foreach (NotificationType notifyType in Enum.GetValues(typeof(NotificationType))) { var tempSLA = db.SLAReminder.Where(s => s.NotificationType == notifyType).FirstOrDefault(); NotificationCategory tempCategory = (int)0; if (tempSLA != null) { tempCategory = tempSLA.NotificationCategory; } var template = db.NotificationTemplates.Local.Where(r => r.NotificationType == notifyType).FirstOrDefault() ?? db.NotificationTemplates.Where(r => r.NotificationType == notifyType).FirstOrDefault(); if (template == null) { db.NotificationTemplates.Add( new NotificationTemplate { NotificationType = notifyType, NotificationCategory = tempCategory, TemplateName = notifyType.DisplayName(), TemplateRefNo = "T" + ((int)notifyType).ToString(), enableEmail = true, TemplateSubject = "Subject: " + notifyType.DisplayName(), TemplateMessage = "Email Body Template", enableSMSMessage = true, SMSMessage = "SMS Message Template", enableWebMessage = true, WebMessage = "Web Message Template", WebNotifyLink = "", CreatedDate = DateTime.Now, CreatedBy = user.Id, User = user, Display = true }); } } }
public static void VerificarSequencial(System.Data.Entity.Infrastructure.DbEntityEntry entityEntry) { DbEntities contextoSequencial = new DbEntities(); string nomeTipo = entityEntry.Entity.GetType().Name; Sequencial ultimo = contextoSequencial.Sequenciais.Where(s => s.Entidade == nomeTipo).SingleOrDefault(); if (ultimo == null) { ultimo = new Sequencial() { Entidade = entityEntry.Entity.GetType().Name, ProximoSequencial = 0 }; contextoSequencial.Sequenciais.Add(ultimo); } ultimo.ProximoSequencial += 1; entityEntry.CurrentValues["Id"] = ultimo.ProximoSequencial; //entityEntry.Entity.GetType().GetProperty("Id").SetValue(entityEntry.Entity, ultimo.ProximoSequencial, null); contextoSequencial.SaveChanges(); }
/// <summary> /// Checks wether the table x has column x /// </summary> /// <param name="columnName">The column you want to check on</param> /// <param name="table">The table you want to check on</param> /// <returns></returns> private static bool HasColumn(string columnName, string table) { using (DbEntities db = new DbEntities()) { try { var t = db.Database.SqlQuery <object>("SELECT " + columnName + " FROM " + table).ToList(); db.Dispose(); return(true); } catch (SQLiteException) { db.Dispose(); //if (ex.Message.ToLower().Contains("no such column")) //{ return(false); //} } } }
public PersonPrint(DbEntities.dbserver3.wordup.rows.PersonZuTermin ConnectorDaten) { ID = ConnectorDaten.Person.Id.ToString(); Sex = ConnectorDaten.Person.Sex; NameID = ConnectorDaten.Person.NameId; VorName = ConnectorDaten.Person.VorName; FamilienName = ConnectorDaten.Person.FamilienName; Telefon = ConnectorDaten.Person.Telefon; eMail = ConnectorDaten.Person.EMail; if (ConnectorDaten.PersonenTypId != null) TypNameID = ConnectorDaten.Typ.TypNameId; else TypNameID = ConnectorDaten.Typ.TypNameId; Gruppe = ConnectorDaten.Typ.Gruppe; ZusatzInformation = ConnectorDaten.Person.ZusatzInformation; Interessen = ConnectorDaten.Person.Interessen; // ArbeitsGruppenName = ConnectorDaten.ArbeitsGruppe.LangName; //if (ConnectorDaten.Table.Columns["PersonenInDerAGTyp"] != null) // PersonenInDerAGTyp = ConnectorDaten["PersonenInDerAGTyp"].ToString(); }
public ActionResult Login(User user) { if (!ModelState.IsValid) { return(View("Index", user)); } DbEntities db = new DbEntities(); var userInfo = db.User.FirstOrDefault(s => s.Name == user.Name); if (userInfo != null && userInfo.Pwd == user.Pwd) { FormsAuthentication.SetAuthCookie(userInfo.Name, false); return(RedirectToAction("Index", "Order")); } else { ModelState.AddModelError("", "无效的登录尝试。检查用户名和密码"); } return(View("Index", user)); }
public void UpdateSyncOkFile(SyncFileModel syncFile) { DbEntities.Configuration.ValidateOnSaveEnabled = false; var model = new FranchiseDataFile { FranchiseDataFileId = syncFile.FranchiseDataFileId, IsSync = true }; DbEntities.FranchiseDataFile.Attach(model); DbEntities.Entry(model).Property(e => e.IsSync).IsModified = true; DbEntities.SaveChanges(); var countSyncFiles = DbEntities.FranchiseDataFile.Count(e => e.FranchiseDataVersionId == syncFile.FranchiseDataVersionId && e.IsSync); var countModel = new FranchiseDataVersion { FranchiseDataVersionId = syncFile.FranchiseDataVersionId, NumberOfFilesDownloaded = countSyncFiles }; DbEntities.FranchiseDataVersion.Attach(countModel); DbEntities.Entry(countModel).Property(e => e.NumberOfFilesDownloaded).IsModified = true; DbEntities.SaveChanges(); }
private static List <int> ObtemIdTestData(int id_datapool) { #region Debug // Instancia a Entity #endregion DbEntities db = new DbEntities(); #region Debug // Query para buscar o id do TestData,passando o id do Datapool que será executado. #endregion var tdQuery = (from td1 in db.TestData join dtp in db.DataPool on td1.IdDataPool equals dtp.Id where dtp.Id == id_datapool && td1.IdStatus == 1 select td1.Id).ToList(); return(tdQuery); }
public List <Modelos.PersonaDgv> MostrarTodos() { DbEntities db = new DbEntities(); //var lista = (from p in db.Personas.Include("Pais") // select p).ToList(); List <Modelos.PersonaDgv> lista = (from p in db.Personas join pa in db.Paises on p.Id_Pais equals pa.Id select new PersonaDgv { Id = p.Id, Nombre = p.Nombre, Fecha_Nacimiento = p.Fecha_Nacimiento, Id_Pais = p.Id_Pais, Credito_Maximo = p.Credito_Maximo, Descripcion = pa.Descripcion }).ToList(); return(lista); }
/// <summary> /// 创建一对多关联 /// </summary> /// <typeparam name="T"></typeparam> /// <typeparam name="TJoin"></typeparam> /// <param name="expression"></param> /// <returns></returns> protected DbEntities<TJoin> IncludeMany<T, TJoin>(Expression<Func<T, TJoin,bool>> expression) where T : IModel, new() where TJoin : IModel, new() { var type = typeof(TJoin); var name = $"ents_{type}_{TypeCache.GetpPrimaryKeyValue(this)}"; var a = DbContext._DbSets.TryGetValue(name, out IDbSet set2); if (a) { return set2 as DbEntities<TJoin>; } if (FromCache)//当是缓存时 { throw new Exception("缓存对象不能调用"); } var _relationExp = CreaterelationExp(expression); var set = new DbEntities<TJoin>(name, DbContext, _relationExp); //DbContext._DbSets.Add(name, set); return set; }
public HttpResponseMessage UpdateEmployeeLoginDetails(UserModel user) { using (DbEntities entities = new DbEntities()) { var userResult = (from u in entities.Users where u.users_no == user.ID select u).FirstOrDefault(); if (userResult != null) { userResult.users_password = user.Password; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, user)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotModified, "Could Not Update Password. Please Contact Administrator")); } } }
public IHttpActionResult AddAttachmentToDisccusion(int pid, int aid) { if (aid > 0) { using (DbEntities _db = new DbEntities()) { DiscussionAttachment _attachment = new DiscussionAttachment() { AttachmentId = aid, PostId = pid, }; _db.DiscussionAttachment.Add(_attachment); _db.SaveChanges(); return(Ok(true)); } } return(NotFound()); }
public PersonPrint (DbEntities.dbserver3.wordup.rows.PersonZuWordUpID ConnectorDaten ) { this.ConnectorDaten = ConnectorDaten; ID = ConnectorDaten.Person.Id.ToString(); Sex = ConnectorDaten.Person.Sex; NameID = ConnectorDaten.Person.NameId; VorName = ConnectorDaten.Person.VorName; FamilienName = ConnectorDaten.Person.FamilienName; Telefon = ConnectorDaten.Person.Telefon; eMail = ConnectorDaten.Person.EMail; if (ConnectorDaten.PersonenTypId != null) TypNameID = ConnectorDaten.Typ.TypNameId; else TypNameID = ConnectorDaten.Typ.TypNameId; Gruppe = ConnectorDaten.Typ.Gruppe; ZusatzInformation = ConnectorDaten.Person.ZusatzInformation; Interessen = ConnectorDaten.Person.Interessen; CodeName = ConnectorDaten.Organisation.CodeName; PLZ = ConnectorDaten.Person.PLZ; Ort = ConnectorDaten.Person.Ort; Adresse = ConnectorDaten.Person.Adresse; //if (ConnectorDaten.Table.Columns["PersonenInDerAGTyp"] != null) // PersonenInDerAGTyp = ConnectorDaten["PersonenInDerAGTyp"].ToString(); }
public List<Object> CreateTreeForOrtePictures(DbEntities.dbserver3.wordup.rows.Projekt ProjectEntry) { List<Object> PicturesToPrint = new List<Object>(); PicturesToPrint.Add(new HeadLinePrint(ProjectEntry.Ort.Bezeichnung, "Main") { PageBreakBeforeRequested = false, AdditionalTopDistance = 8, AdditionalBottomDistance = 5 }); List<PictureContainerList> PictureContainerLists = PictureContainerList.PrepareData (Data.DbServer3, ProjectEntry, ProjectEntry.Ort, true, true); foreach (PictureContainerList pictureContainerList in PictureContainerLists) { if (pictureContainerList.ForeignKeyConnectoren.Count == 0) continue; if ((pictureContainerList.MaterialienTyp == MaterialienTypen.Ort) || (pictureContainerList.MaterialienTyp == MaterialienTypen.OrtsBild)) continue; foreach (MaterialJPGForeignKeyConnector materialJPGForeignKeyConnector in pictureContainerList.ForeignKeyConnectoren) { PicturesToPrint.Add(new VerticalStackedPicturePrint(materialJPGForeignKeyConnector) { PageBreakAllowedBefore = true }); } } foreach (PictureContainerList pictureContainerList in PictureContainerLists) { if (pictureContainerList.ForeignKeyConnectoren.Count == 0) continue; if ((pictureContainerList.MaterialienTyp != MaterialienTypen.Ort) && (pictureContainerList.MaterialienTyp != MaterialienTypen.OrtsBild)) continue; int Index = 0; int Columns = 5; while (Index < pictureContainerList.ForeignKeyConnectoren.Count) { foreach (MaterialJPGForeignKeyConnector materialJPGForeignKeyConnector in pictureContainerList.ForeignKeyConnectoren) { PicturesToPrint.Add(new HorizontalStackedPicturePrint (pictureContainerList, Index, Columns) { PageBreakAllowedBefore = true, Height = 100}); Index += Columns; } } } /* if ((MainPictureFiles.Count > 0) || (CommonPictureFiles.Count > 0)) { List<String> EntriesToDelete = new List<String>(); foreach (String PictureName in MainPictureFiles) { if (PictureName.IndexOf(WMB.Basics.THUMB_NAIL_PREFIX) != -1) EntriesToDelete.Add(PictureName); } foreach (String PictureNameToDelete in EntriesToDelete) MainPictureFiles.Remove(PictureNameToDelete); EntriesToDelete.Clear(); MainPictureFiles.Sort(); foreach (String PictureName in CommonPictureFiles) { if ((PictureName.IndexOf("LuftBild.jpg") != -1) || (PictureName.IndexOf("LagePlan.jpg") != -1) || (PictureName.IndexOf("UeberBlick.jpg") != -1)) EntriesToDelete.Add(PictureName); } foreach (String PictureNameToDelete in EntriesToDelete) CommonPictureFiles.Remove(PictureNameToDelete); CommonPictureFiles.Sort(); foreach (String MainPictureName in MainPictureFiles) { PicturesToPrint.Add(new VerticalStackedPicturePrint(MainPictureName) {PageBreakAllowedBefore = true}); } int Index = 0; int Columns = 5; while (Index < CommonPictureFiles.Count) { PicturesToPrint.Add(new HorizontalStackedPicturePrint(CommonPictureFiles, Index, Columns) {PageBreakAllowedBefore = true, Height = 100}); Index += Columns; } } */ return PicturesToPrint; }
private String GruenGelbRotVerteilung(DbEntities.dbserver3.wordup.rows.Projekt[] projekteToProcess) { List<String> result = new List<string>(); Dictionary<AktivitaetsTyp.AmpelTyp,int> AmpelDistribution = new Dictionary<AktivitaetsTyp.AmpelTyp, int>(); AmpelDistribution[AktivitaetsTyp.AmpelTyp.Green] = 0; AmpelDistribution[AktivitaetsTyp.AmpelTyp.Yellow] = 0; AmpelDistribution[AktivitaetsTyp.AmpelTyp.Red] = 0; AmpelDistribution[AktivitaetsTyp.AmpelTyp.NoAction] = 0; int unTyped = 0; foreach (DbEntities.dbserver3.wordup.rows.Projekt projekt in projekteToProcess) { AktivitaetsTyp.AmpelTyp? typOfProjekt = projekt.AmpelTypForThisProjekt; if (typOfProjekt == null) { unTyped++; continue; } AmpelDistribution[(AktivitaetsTyp.AmpelTyp) typOfProjekt]++; } result.Add($"Grün {AmpelDistribution[AktivitaetsTyp.AmpelTyp.Green]}"); result.Add($"Gelb {AmpelDistribution[AktivitaetsTyp.AmpelTyp.Yellow]}"); result.Add($"Rot {AmpelDistribution[AktivitaetsTyp.AmpelTyp.Red]}"); result.Add($"Fremd {AmpelDistribution[AktivitaetsTyp.AmpelTyp.NoAction]}"); result.Add($"-- {unTyped}"); return String.Join(", ", result); }
private List<Object> CreateZustaendigForProjekte(DbEntities.dbserver3.wordup.rows.Projekt[] projekteToCount) { List<Object> CollectionOfClassesToPrint = new List<object>(); Dictionary<Zustaendigkeit, int> ZuständigkeitenVerteilung = new Dictionary<Zustaendigkeit, int>(); foreach (DbEntities.dbserver3.wordup.rows.Projekt projekt in projekteToCount) { if (!ZuständigkeitenVerteilung.Keys.Contains(projekt.Zustaendigkeit)) ZuständigkeitenVerteilung[projekt.Zustaendigkeit] = 0; ZuständigkeitenVerteilung[projekt.Zustaendigkeit]++; } List<String> numbers = new List<string>(); bool first = true; foreach (Zustaendigkeit zust in ZuständigkeitenVerteilung.Keys.OrderBy(ord => ord.NameId)) { if (first) { decimal Prozente = Math.Round((decimal)((ZuständigkeitenVerteilung[zust]*100)/projekteToCount.Length), 2); numbers.Add($"{zust.NameId} = {ZuständigkeitenVerteilung[zust]} ({Prozente}%)"); } else numbers.Add($"{zust.NameId} = {ZuständigkeitenVerteilung[zust]}"); first = false; } String printLine = String.Join("; ", numbers); CollectionOfClassesToPrint.Add(new HeadLinePrint($"{printLine}", "SubSubSub")); return CollectionOfClassesToPrint; }
private static void DebugLoop(DbEntities.dbserver3.multimedia.rows.Page page, int level) { String indentation = "\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t"; Debug.WriteLine($"{indentation.Substring(0, level + 2)} P {level}: {page.SortOrder} {page.DiagnosticText}"); foreach (IBaseVisual baseVisual in page.IChildren.Where(whe => whe.GetType() != typeof(Page))) { if (baseVisual.GetType() == typeof(Text)) { Debug.WriteLine($"{indentation.Substring(0, level + 3)} T {(baseVisual as Text).DiagnosticText}: {(baseVisual as Text).TextColumn}"); continue; } if (baseVisual.GetType() == typeof(Link)) { Debug.WriteLine($"{indentation.Substring(0, level + 3)} L {(baseVisual as Link).DiagnosticText}: {(baseVisual as Link).LinkColumn}"); continue; } if (baseVisual.GetType() == typeof(Image)) { Debug.WriteLine($"{indentation.Substring(0, level + 3)} I {(baseVisual as Image).DiagnosticText}: {(baseVisual as Image).Extension}"); continue; } if (baseVisual.GetType() == typeof(Video)) { continue; } } foreach (Page childPage in page.ChildPages.OrderBy(ord => ord.SortOrder)) { DebugLoop(childPage, level + 1); } }
private void CreateImageElement(DbEntities.dbserver3.multimedia.rows.Image imageBase, HsCentralServiceWebInterfacesServer._dbs.hsserver.ringplayerdb.rows.Page convertedParentPage) { Image newImage = TargetPlayerDb.Images.NewRow(); newImage.Id = imageBase.Id; newImage.Page = convertedParentPage; newImage.ImageId = imageBase.ImageId; newImage.FileIdentifier = imageBase.ImageId; newImage.Background = imageBase.Background; newImage.BorderColor = imageBase.BorderColor; newImage.SortOrder = imageBase.SortOrder; newImage.Extension = imageBase.Extension; newImage.Rotation = imageBase.Rotation; newImage.Background = imageBase.Background; newImage.BorderColor = imageBase.BorderColor; newImage.BorderThickness = imageBase.BorderThickness; newImage.MarginThickness = imageBase.MarginThickness; newImage.Rotation = imageBase.Rotation; newImage.Table.Rows.Add(newImage); }
public ProjektPrint(DbEntities.dbserver3.wordup.rows.Projekt projektDaten) : base(projektDaten) { }
public RealisierungPrint(DbEntities.dbserver3.wordup.rows.Projekt projektDaten) : base(projektDaten) { }
public void AddUsedEntry(DbEntities.dbserver3.wordup.rows.Projekt ProjektUsed) { UsedEntries.Add(new AccessedInThisRun() { LastAccessTime = DateTime.Now, AccessedProjekt = ProjektUsed }); SendPropertyChanged("UsedEntries"); }
string GetModuleName(object addIn) { string guid = string.Empty; if (addIn is IAddIn) { guid = ((IAddIn)addIn).Guid.ToString(); } else { guid = MetaHelper.GetModuleGuid(addIn.GetType()); } Module module = XContext.ModuleList.Where(p => p.Guid == guid).FirstOrDefault(); if (module == null) { using (DbEntities db = new DbEntities()) { module = db.Modules.Where(p => p.Guid == guid.ToUpper()).FirstOrDefault(); } } if (module != null) { return module.Name; } else { return ModuleManager.GetModuleName(addIn); } }
public IdeePrintTight(DbEntities.dbserver3.wordup.rows.WSPlakat WSPlakateEntry) { ShowWMUDetail = false; WsPlakat = WSPlakateEntry; }
private void CreatePlayerSubPage(DbEntities.dbserver3.multimedia.rows.Page sourcePage, HsCentralServiceWebInterfacesServer._dbs.hsserver.ringplayerdb.rows.Page convertedSourceParent) { HsCentralServiceWebInterfacesServer._dbs.hsserver.ringplayerdb.rows.Page convertedSourcePage = TargetPlayerDb.Pages.NewRow(); convertedSourcePage.Id = Guid.NewGuid(); convertedSourcePage.DiagnosticText = $"child von {sourcePage.DiagnosticText}"; convertedSourcePage.ExpectedDuration = 0; convertedSourcePage.PageGroup = TargetPageGroup; convertedSourcePage.ParentPage = convertedSourceParent; convertedSourcePage.SortOrder = (int)sourcePage.SortOrder; convertedSourcePage.BorderColor = sourcePage.BorderColor; convertedSourcePage.Background = sourcePage.Background; convertedSourcePage.BorderThickness = sourcePage.BorderThickness; convertedSourcePage.MarginThickness = sourcePage.MarginThickness; convertedSourcePage.HasFixedRatio = false; convertedSourcePage.RatioX = sourcePage.RatioX; convertedSourcePage.RatioY = sourcePage.RatioY; convertedSourcePage.Table.Rows.Add(convertedSourcePage); CreateAllChildElements(sourcePage, convertedSourcePage); }
public ProjektPrintRoot(DbEntities.dbserver3.wordup.rows.Projekt projektDaten) { ProjektDaten = projektDaten; PageBreakAllowedBefore = true; ID = projektDaten.Id.ToString(); ProjektBeschreibung = projektDaten.Beschreibung; NumericProjektID = projektDaten.NumericProjektId; OrtsNameID = projektDaten.Ort?.NameId; Zustaendig = projektDaten.Zustaendigkeit?.NameId; ProjektTyp = projektDaten.Typ?.TypNameId; Wertigkeit = Convert.ToString(projektDaten.Wertigkeit); ArbeitsGruppenNameID = projektDaten.Ort?.OrtsTeil?.AktuallArbeitsGruppe?.NameId; OrtsTeil = projektDaten.Ort?.OrtsTeil?.NameId; ImPlenumsFilm = projektDaten.ImPlenumsFilm; ImFilm = projektDaten.ImFilm; if (projektDaten.SummeW != null) SummeW = projektDaten.SummeW.Value; else SummeW = 0; if (projektDaten.SummeM != null) SummeM = projektDaten.SummeM.Value; else SummeM = 0; if (projektDaten.SummeU != null) SummeU = projektDaten.SummeU.Value; else SummeU = 0; }
private void CreateTextElement(DbEntities.dbserver3.multimedia.rows.Text textBase, HsCentralServiceWebInterfacesServer._dbs.hsserver.ringplayerdb.rows.Page convertedParentPage) { Text newText = TargetPlayerDb.Texts.NewRow(); newText.Id = textBase.Id; newText.Page = convertedParentPage; newText.TextColumn = textBase.TextColumn; newText.Background = textBase.Background; newText.BorderColor = textBase.BorderColor; newText.SortOrder = textBase.SortOrder; newText.TextColumn = textBase.TextColumn; newText.FontFamily = textBase.FontFamily; newText.FontWeight = textBase.FontWeight; newText.FontStyle = textBase.FontStyle; newText.Foreground = textBase.Foreground; newText.Background = textBase.Background; newText.BorderColor = textBase.BorderColor; newText.BorderThickness = textBase.BorderThickness; newText.MarginThickness = textBase.MarginThickness; newText.Rotation = textBase.Rotation; newText.Table.Rows.Add(newText); }
public String CreateMultiProjectProjectFolder(DbEntities.dbserver3.wordup.rows.Projekt[] ProjectsToCreate, String TargetDirectory, String Description, String FileNameElement = "") { //String ProjectFolderBaseDirectory = Basics.Instance.ProjektMaterialDirectory; //String OrteFolderBaseDirectory = Basics.Instance.OrtsMaterialDirectory; String FileName = String.Empty; if (String.IsNullOrEmpty(FileNameElement)) FileName = Path.Combine(TargetDirectory, "ProjektMappe_" + DateTime.Now.ToString("yyyy-MMM-dd_HH_mm") + ".pdf"); else FileName = Path.Combine(TargetDirectory, WMB.Basics.ConvertToCorrectFileNameElement(FileNameElement) + ".pdf"); Guid OldOrteID = Guid.Empty; List<Object> ResultetObjectsToPrint = new List<Object>(); foreach (DbEntities.dbserver3.wordup.rows.Projekt projectEntry in ProjectsToCreate) { PlanungPrint planungPrint = new PlanungPrint(projectEntry) { PageBreakAllowedBefore = true }; ResultetObjectsToPrint.Add(planungPrint); planungPrint.MaximalWMUValue = Data.DbServer3.WordUp.Projekte.WMUDistribution.Keys.Max(); planungPrint.MaximalWSPLakateValue = Data.DbServer3.WordUp.Projekte.WSPlakateDistribution.Keys.Max(); planungPrint.MaximalWertigkeitValue = Data.DbServer3.WordUp.Projekte.WertigkeitValueDistribution.Keys.Max(); ResultetObjectsToPrint.Add(new HeadLinePrint("Bemerkungen:", "SubSubSub")); foreach (Aktivitaet aktivitaet in projectEntry.Aktivitaeten) { ResultetObjectsToPrint.Add(new AktivitaetenPrint(aktivitaet) { }); } ResultetObjectsToPrint.Add(new HeadLinePrint("Ideen", "SubSubSub")); foreach (WSPlakat wsPlakat in projectEntry.WSPlakate) { ResultetObjectsToPrint.Add(new IdeePrint(wsPlakat) {} ); } foreach (ProjektZuTermin projektZuTermin in Data.DbServer3.WordUp.ProjekteZuTerminen.Find_By_ProjekteId(projectEntry.Id) ) { TerminPrint TerminRoot = new TerminPrint(projektZuTermin.Termin); ResultetObjectsToPrint.Add(TerminRoot); bool firstTeam = true; bool firstVertreter = true; foreach (PersonZuTermin PersonZuTerminEntry in Data.DbServer3.WordUp.PersonenZuTerminen .FindOrLoad_ActivePersonenZuTerminen(projektZuTermin.Termin.Id) .Where(sel => Data.DbServer3.WordUp.Typen.AllTypIDsForBetreuer.Contains((Guid)sel.PersonenTypId))) { if (firstTeam) { ResultetObjectsToPrint.Add(new HeadLinePrint("Betreuer", "Sub") { PageBreakAllowedBefore = true, BorderPadding = new Thickness(40, 10, 0, 0) }); firstTeam = false; } TeamPersonPrint TeamPerson = new TeamPersonPrint(PersonZuTerminEntry); TeamPerson.BorderPadding = new Thickness(40, 0, 0, 0); ResultetObjectsToPrint.Add(TeamPerson); } foreach (PersonZuTermin PersonZuTerminEntry in Data.DbServer3.WordUp.PersonenZuTerminen .FindOrLoad_ActivePersonenZuTerminen(projektZuTermin.Termin.Id) .Where(sel => Data.DbServer3.WordUp.Typen.AllTypIDsForVertreter.Contains((Guid)sel.PersonenTypId))) { if (firstVertreter) { ResultetObjectsToPrint.Add(new HeadLinePrint("VertreterInnen", "Sub") { PageBreakAllowedBefore = true, BorderPadding = new Thickness(40, 10, 0, 0) }); firstVertreter = false; } VertreterPersonPrint VertreterPerson = new VertreterPersonPrint(PersonZuTerminEntry); VertreterPerson.BorderPadding = new Thickness(40, 0, 0, 0); ResultetObjectsToPrint.Add(VertreterPerson); } } if (projectEntry.Ort.Id != OldOrteID) { OldOrteID = projectEntry.Ort.Id; ResultetObjectsToPrint.AddRange(DataWrapper.Instance.CreateTreeForOrtePictures (projectEntry)); } } XAMLPrintoutDefinitions.PrintFileCards PicturePrintHandler = new XAMLPrintoutDefinitions.PrintFileCards(); return PicturePrintHandler.PrintProjektMapData(ResultetObjectsToPrint, FileName, Description); }
private void CreateVideoElement(DbEntities.dbserver3.multimedia.rows.Video videoBase, HsCentralServiceWebInterfacesServer._dbs.hsserver.ringplayerdb.rows.Page convertedParentPage) { Video newVideo = TargetPlayerDb.Videos.NewRow(); newVideo.Id = videoBase.Id; newVideo.Page = convertedParentPage; newVideo.VideoId = videoBase.VideoId; newVideo.FileIdentifier = videoBase.VideoId; newVideo.Background = videoBase.Background; newVideo.BorderColor = videoBase.BorderColor; newVideo.SortOrder = videoBase.SortOrder; newVideo.Extension = videoBase.Extension; newVideo.Rotation = videoBase.Rotation; newVideo.Background = videoBase.Background; newVideo.BorderColor = videoBase.BorderColor; newVideo.BorderThickness = videoBase.BorderThickness; newVideo.MarginThickness = videoBase.MarginThickness; newVideo.Rotation = videoBase.Rotation; newVideo.Table.Add(newVideo); }
public void CreateAllForOneProjectToPrint(Basics.DataSelection Phase, List<Object> CollectionOfClassesToPrint, DbEntities.dbserver3.wordup.rows.Projekt ProjektToUse, ref bool FirstProjekt, bool WithOrWithoutPlakate = false, bool WithOrWithoutActivities = false, bool WithOrWithoutTermine = false, bool WithOrWithoutProjektUebersicht = false, String SecurityGroup = "ProfisFull") { ProjektPrintRoot RootProjektObject = null; switch (Phase) { case Basics.DataSelection.Wuensche: RootProjektObject = new WunschPrint(ProjektToUse); break; case Basics.DataSelection.Planungen: RootProjektObject = new PlanungPrint(ProjektToUse); break; case Basics.DataSelection.Projekte: RootProjektObject = new ProjektPrint(ProjektToUse); break; case Basics.DataSelection.Realisierungen: RootProjektObject = new RealisierungPrint(ProjektToUse); break; case Basics.DataSelection.Fertig: RootProjektObject = new FertigPrint(ProjektToUse); break; } RootProjektObject.MaximalWMUValue = Data.DbServer3.WordUp.Projekte.WMUDistribution.Keys.Max(); RootProjektObject.MaximalWSPLakateValue = Data.DbServer3.WordUp.Projekte.WSPlakateDistribution.Keys.Max(); RootProjektObject.MaximalWertigkeitValue = Data.DbServer3.WordUp.Projekte.WertigkeitValueDistribution.Keys.Max(); if (FirstProjekt) { FirstProjekt = false; } else { RootProjektObject.PageBreakAllowedBefore = true; } RootProjektObject.BorderPadding = new Thickness(40, 10, 0, 0); CollectionOfClassesToPrint.Add(RootProjektObject); if (WithOrWithoutActivities) { bool FirstAktivitaet = true; foreach (Aktivitaet AktivitaetenEntry in Data.DbServer3.WordUp.Aktivitaeten.Collection .Where(Entry => Entry.ProjektId == ProjektToUse.Id).OrderByDescending(ord => ord.CreationDateTime)) { if (FirstAktivitaet) { CollectionOfClassesToPrint.Add(new HeadLinePrint("Bemerkungen:", "SubSubSub")); FirstAktivitaet = false; } AktivitaetenPrint RootAktivitaetenPrint = new AktivitaetenPrint(AktivitaetenEntry); RootProjektObject.Aktivitaeten.Add(RootAktivitaetenPrint); RootAktivitaetenPrint.BorderPadding = new Thickness(80, 0, 0, 0); CollectionOfClassesToPrint.Add(RootAktivitaetenPrint); } } if (WithOrWithoutPlakate) { bool FirstIdee = true; foreach (WSPlakat PlakatEntry in Data.DbServer3.WordUp.WSPlakate.Collection .Where(Entry => Entry.ProjektId == ProjektToUse.Id)) { if (FirstIdee) { CollectionOfClassesToPrint.Add(new HeadLinePrint("Ideen", "SubSubSub")); FirstIdee = false; } IdeePrint RootIdeePrint = new IdeePrint(PlakatEntry) { ShowWMUDetail = true }; RootProjektObject.Ideen.Add(RootIdeePrint); RootIdeePrint.BorderPadding = new Thickness(80, 0, 0, 0); CollectionOfClassesToPrint.Add(RootIdeePrint); } } if (WithOrWithoutTermine) { bool FirstTermin = true; foreach ( Termin TerminEntry in Data.DbServer3.WordUp.Termine.Find_ForSpecificProjektID(ProjektToUse.Id)) { if (FirstTermin) { CollectionOfClassesToPrint.Add(new HeadLinePrint("Termine, die eine Verbindung mit dem Projekt " + RootProjektObject.NumericProjektID.Substring(3) + " haben", "SubSubSub")); FirstTermin = false; } AddOnTerminPrint RootTerminPrint = new AddOnTerminPrint(TerminEntry); RootProjektObject.Termine.Add(RootTerminPrint); RootTerminPrint.BorderPadding = new Thickness(80, 0, 0, 0); CollectionOfClassesToPrint.Add(RootTerminPrint); } } }
private void CreateAllChildElements(DbEntities.dbserver3.multimedia.rows.Page sourcePage, HsCentralServiceWebInterfacesServer._dbs.hsserver.ringplayerdb.rows.Page convertedSourcePage) { foreach (DbEntities.CustomClasses.PlayerInterfaces.IBaseVisual baseVisual in sourcePage.IChildren.OrderBy(ord => ord.ISortOrder)) { if (baseVisual.GetType() == typeof(DbEntities.dbserver3.multimedia.rows.Page)) { CreatePlayerSubPage(baseVisual as DbEntities.dbserver3.multimedia.rows.Page, convertedSourcePage); } else if (baseVisual.GetType() == typeof(DbEntities.dbserver3.multimedia.rows.Text)) { CreateTextElement(baseVisual as DbEntities.dbserver3.multimedia.rows.Text, convertedSourcePage); } else if (baseVisual.GetType() == typeof(DbEntities.dbserver3.multimedia.rows.Image)) { CreateImageElement(baseVisual as DbEntities.dbserver3.multimedia.rows.Image, convertedSourcePage); } else if (baseVisual.GetType() == typeof(DbEntities.dbserver3.multimedia.rows.Video)) { CreateVideoElement(baseVisual as DbEntities.dbserver3.multimedia.rows.Video, convertedSourcePage); } else { throw new Exception($"Illegal Typ ({baseVisual.GetType()}) as pageChildren "); } } }
public VertreterPersonPrint (DbEntities.dbserver3.wordup.rows.PersonZuWordUpID connectorDaten) : base(connectorDaten) { }
void SetModule(object addIn) { string guid = string.Empty; if (addIn is IAddIn) { guid = ((IAddIn)addIn).Guid.ToString(); } else { guid = MetaHelper.GetModuleGuid(addIn.GetType()); } if (addIn is AboutForm) { this.Icon = (addIn as AboutForm).Icon; } else if (addIn is LoginForm) { this.Icon = (addIn as LoginForm).Icon; } else if (guid.Length > 0) { Module module = XContext.ModuleList.Where(p => p.Guid == guid).FirstOrDefault(); if (module == null) { using (DbEntities db = new DbEntities()) { module = db.Modules.Where(p => p.Guid == guid.ToUpper()).FirstOrDefault(); } } if (module != null) { this.Text = module.Name; try { using (System.IO.MemoryStream ms = new System.IO.MemoryStream(module.Icon)) { this.Icon = System.Drawing.Image.FromStream(ms).ToIcon(); } } catch { } } else { this.Text = ModuleManager.GetModuleName(addIn); } } }
public VertreterPersonPrint(DbEntities.dbserver3.wordup.rows.PersonZuArbeitsGruppe connectorDaten) : base(connectorDaten) { }
private DbEntities.dbserver3.wordup.rows.Ort[] GetOrteToDraw(out DbEntities.dbserver3.wordup.rows.Projekt[] Projekte, TypeOfPictureToDraw PictureToDraw) { DbEntities.dbserver3.wordup.rows.Ort[] Result = new Ort[0]; Projekte = new Projekt[0]; switch (PictureToDraw) { case TypeOfPictureToDraw.AllActuallExistingOrte: case TypeOfPictureToDraw.AllActuallWuensche: Projekte = Data.DbServer3.WordUp.Projekte.Find_PhasenCorrectProjekte("Wuensche"); Result = Projekte.Select(sel => sel.Ort).Distinct().OrderBy(ord => ord.Bezeichnung).ToArray(); break; case TypeOfPictureToDraw.AllActuallWuenscheNotFinish: Projekte = Data.DbServer3.WordUp.Projekte.Find_PhasenCorrectProjekte("Wuensche") .Where(sel => sel.Ort.WLaenge == null).ToArray(); Result = Projekte.Select(sel => sel.Ort).Distinct().OrderBy(ord => ord.Bezeichnung).ToArray(); break; case TypeOfPictureToDraw.AllActualPlanungen: Projekte = Data.DbServer3.WordUp.Projekte.Find_PhasenCorrectProjekte("Planungen"); Result = Projekte.Select(sel => sel.Ort).Distinct().OrderBy(ord => ord.Bezeichnung).ToArray(); break; case TypeOfPictureToDraw.AllActuallPlanungenNotFinish: Projekte = Data.DbServer3.WordUp.Projekte.Find_PhasenCorrectProjekte("Planungen") .Where(sel => sel.Ort.WLaenge == null || sel.PPTBilder.Count == 0).ToArray(); Result = Projekte.Select(sel => sel.Ort).Distinct().OrderBy(ord => ord.Bezeichnung).ToArray(); break; } return Result; }
public StadtWienEttikettenPersonPrint(DbEntities.dbserver3.wordup.rows.PersonZuWordUpID connectorDaten) : base(connectorDaten) { }
/* private void ConvertToMMUnitsLoop(ButtonData parentButton, Object ParentObject, int level) { if (!EntriesPerLevel.ContainsKey(level)) EntriesPerLevel[level] = 0; int sortOrder = 0; foreach (ButtonData buttonData in allOldButton .Where(whe => whe.ParentButton != null && whe.ParentButton == parentButton).OrderBy(ord => ord.Row).ToArray()) { MMUnit RootMMUnit = null; DbEntities.dbserver3.multimedia.rows.Page contentPage = null; if (level == 0) { RootMMUnit = Data.DbServer3.MultiMedia.MMUnits.FindOrLoad(buttonData.Id); if (RootMMUnit != null) { RootMMUnit.Delete(); Data.DbServer3.MultiMedia.SaveKatabolic(new Object()); Data.DbServer3.MultiMedia.AcceptChanges(); } RootMMUnit = Data.DbServer3.MultiMedia.MMUnits.NewRow(); RootMMUnit.Id = buttonData.Id; if (String.IsNullOrWhiteSpace(buttonData.NameId)) buttonData.NameId = "Fahrplan"; RootMMUnit.NameId = buttonData.NameId; RootMMUnit.Title = buttonData.Text; if (buttonData.EntryType == "Entry") RootMMUnit.MMUnitTyp = mmUnitTypForButtonData; if (buttonData.EntryType == "StaticEntry") RootMMUnit.MMUnitTyp = mmUnitTypForButtonDataStatic; RootMMUnit.Table.Rows.Add(RootMMUnit); RootMMUnit.PagingType = DirectPlayerPage; Data.DbServer3.MultiMedia.MMUnits.SaveChanges(new Object()); Data.DbServer3.MultiMedia.MMUnits.AcceptChanges(); } contentPage = Data.DbServer3.MultiMedia.Pages.NewRow(); contentPage.Id = buttonData.Id; contentPage.SortOrder = ++sortOrder; contentPage.DiagnosticText = buttonData.NameId; if (level == 0) { contentPage.MMUnit = RootMMUnit; } else { contentPage.ParentPage = ParentObject as DbEntities.dbserver3.multimedia.rows.Page; } contentPage.Table.Rows.Add(contentPage); AddDrawingElements(buttonData, contentPage); Data.DbServer3.MultiMedia.SaveAnabolic(new Object()); Data.DbServer3.MultiMedia.AcceptChanges(); ConvertToMMUnitsLoop(buttonData, contentPage, level + 1); EntriesPerLevel[level]++; LoopCounter++; } } */ private void AddDrawingElements(ButtonData buttonData, DbEntities.dbserver3.multimedia.rows.Page page) { XmlDocument FileContent = null; if (!String.IsNullOrWhiteSpace(buttonData.FileName)) { FileInfo fileInfo = new FileInfo(Path.Combine(@"\\webserver2\WPMediaSender\Haus\ButtonData", buttonData.FileName)); if (fileInfo.Exists) { FileContent = new XmlDocument(); FileContent.Load(fileInfo.FullName); } } if (!String.IsNullOrWhiteSpace(buttonData.ImageAfter)) { String OldButtonRootDirectory = @"D:\WPMediaSender\AutoContent\ButtonData"; FileInfo imageFileInfo = new FileInfo(Path.Combine(OldButtonRootDirectory, buttonData.ImageAfter)); if (imageFileInfo.Exists) { Byte[] pictureBytes = imageFileInfo.LoadAs_ByteArray(); String extension = Path.GetExtension(imageFileInfo.Name).Replace(".", "").ToLower(); MMPicture picture = Data.DbServer3.MultiMedia.MMPictures.LoadOrCreate(pictureBytes, Path.GetFileNameWithoutExtension(imageFileInfo.Name), extension); Image newImage = Data.DbServer3.MultiMedia.Images.NewRow(); newImage.Id = Guid.NewGuid(); newImage.Page = page; newImage.DiagnosticText = $"Image zu {buttonData.NameId}"; newImage.Extension = extension; newImage.SortOrder = 1; newImage.MMPicture = picture; newImage.Background = Colors.Transparent.ToString(); newImage.BorderThickness = new Thickness(0).ToString(); newImage.MarginThickness = new Thickness(0).ToString(); newImage.Rotation = 0D; newImage.Table.Rows.Add(newImage); } } if (buttonData.LinkType == "ButtonPage") return; if ((buttonData.LinkType == "Internet") && (!String.IsNullOrWhiteSpace(buttonData.LinkData))) { Link newLink = Data.DbServer3.MultiMedia.Links.NewRow(); newLink.Id = Guid.NewGuid(); newLink.Page = page; newLink.DiagnosticText = $"Link zu {buttonData.NameId}"; newLink.SortOrder = 1; newLink.LinkColumn = buttonData.LinkData; newLink.FontWeight = FontWeights.ExtraLight.ToString(); newLink.Foreground = Colors.Black.ToString(); newLink.MarginThickness = new Thickness(0).ToString(); newLink.Table.Rows.Add(newLink); } if ((buttonData.LinkType == "Content") && (!String.IsNullOrWhiteSpace(buttonData.LinkData))) { Text newText = Data.DbServer3.MultiMedia.Texts.NewRow(); newText.Id = Guid.NewGuid(); newText.Page = page; newText.DiagnosticText = $"Text zu {buttonData.NameId}"; newText.SortOrder = 1; newText.TextColumn = buttonData.LinkData; newText.FontWeight = FontWeights.ExtraLight.ToString(); newText.Foreground = Colors.Black.ToString(); newText.MarginThickness = new Thickness(0).ToString(); newText.Table.Rows.Add(newText); } }
public List<Object> CreateTreeForProjekteFolder(DbEntities.dbserver3.wordup.rows.Projekt ProjektEntry, String SecurityGroup) { List<Object> CollectionOfClassesToPrint = new List<object>(); bool FirstProjektInProjektOrt = false; CreateAllForOneProjectToPrint(Basics.DataSelection.Planungen, CollectionOfClassesToPrint, ProjektEntry, ref FirstProjektInProjektOrt, true, true, true, true, SecurityGroup); return CollectionOfClassesToPrint; }