public Portfolio AddPortfolio(Portfolio portfolio) { try { using (ApplicationUnit unit = new ApplicationUnit()) { Client client = unit.Clients.GetAll() .FirstOrDefault(u => u.Id == portfolio.Client.Id); Portfolio hasPortfolio = unit.Portfolios.GetAll() .FirstOrDefault(u => u.Name.ToLower() == portfolio.Name.ToLower()); if (hasPortfolio == null) { portfolio.Client = client; unit.Portfolios.Add(portfolio); unit.SaveChanges(); return(portfolio); } return(null); } } catch (Exception ex) { throw ex; } }
public Facility AddFacility(Facility facility) { try { using (ApplicationUnit unit = new ApplicationUnit()) { Portfolio portfolio = unit.Portfolios.GetAll() .FirstOrDefault(p => p.Id == facility.Portfolio.Id); Facility hasFacility = unit.Facilities.GetAll() .FirstOrDefault(u => u.Name.ToLower() == facility.Name.ToLower()); if (hasFacility == null) { facility.CreatedDate = DateTime.Now; facility.ModifiedDate = DateTime.Now; facility.Portfolio = portfolio; facility.Status = "New"; unit.Facilities.Add(facility); unit.SaveChanges(); return(facility); } return(null); } } catch (Exception ex) { ErrorHandling.LogError(ex.StackTrace, "AddFacility"); throw ex; } }
public HttpResponseMessage Put(int id, Home home) { if (!ModelState.IsValid) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState)); } if (id != home.Id) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } Home existingHome = _unit.Homes.GetById(id); _unit.Homes.Detach(existingHome); // Keep original CreatedOn home.CreatedOn = existingHome.CreatedOn; _unit.Homes.Update(home); try { _unit.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "{success:'true', verb:'PUT'}")); } catch (DbUpdateConcurrencyException ex) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public ActionResult UploadImage(HttpPostedFileBase image, int id) { JsonResult result; Home home; Random rand = new Random(); string unique; string ext; string fileName; string path; unique = rand.Next(1000000).ToString(); ext = Path.GetExtension(image.FileName).ToLower(); fileName = string.Format("{0}-{1}{2}", id, unique, ext); path = Path.Combine( HttpContext.Server.MapPath(Config.ImagesFolderPath), fileName); if (ext == ".png" || ext == ".jpg") { home = _unit.Homes.GetById(id); if (home != null) { home.ImageName = fileName; _unit.Homes.Update(home); _unit.SaveChanges(); image.SaveAs(path); result = this.Json(new { imageUrl = string.Format("{0}{1}", Config.ImagesUrlPrefix, fileName) }); } else { result = this.Json(new { status = "error", statusText = string.Format("There is no home with the Id of " + "'{0}' in the system.", id) }); } } else { result = this.Json(new { status = "error", statusText = "Unsupported image type. Only .png or " + ".jpg files are acceptable." }); } return(result); }
private void CreateEditBoundryPolygon(List <BoundryPolygon> boundryPolygons, ref ApplicationUnit unit, Location location) { foreach (var boundryPolygon in boundryPolygons) { boundryPolygon.Location = location; location.BoundryPolygon.Add(boundryPolygon); } unit.SaveChanges(); }
/// <summary> /// Log error /// </summary> /// <param name="errorLog"></param> /// <returns></returns> public async Task Log(ErrorLog errorLog) { ApplicationUnit unit = new ApplicationUnit(); Model.ErrorLog errorLogd = new Model.ErrorLog(); errorLogd.ErrorMessage = errorLog.ErrorMessage; errorLogd.Source = errorLog.Source; errorLogd.Date = errorLog.Date; unit.ErrorLogs.Add(errorLogd); unit.SaveChanges(); }
private void CreateEditGPSCoordinates(GPSCoordinate GPSCoordinates, ref ApplicationUnit unit) { if (GPSCoordinates.Id != 0) { unit.GPSCoordinates.Update(GPSCoordinates); } else { unit.GPSCoordinates.Add(GPSCoordinates); } unit.SaveChanges(); }
public static void LogError(string errorMessase, string source) { using (ApplicationUnit unit = new ApplicationUnit()) { ErrorLog errorLog = new ErrorLog { Date = DateTime.Now, ErrorMessage = errorMessase, Source = source }; unit.ErrorLogs.Add(errorLog); unit.SaveChanges(); } }
public HttpResponseMessage UpdateBuilding(Building building) { ApplicationUnit unit = new ApplicationUnit(); try { Building updateBudilng = unit.Buildings.GetAll().FirstOrDefault(fc => fc.Id == building.Id); if (updateBudilng != null) { updateBudilng.BuildingName = building.BuildingName.Trim(); updateBudilng.BuildingNumber = building.BuildingNumber.Trim(); updateBudilng.BuildingType = building.BuildingType.Trim(); updateBudilng.BuildingStandard = building.BuildingStandard.Trim(); updateBudilng.Status = building.Status.Trim(); updateBudilng.GPSCoordinates = GPSCoordinates(building.GPSCoordinates, ref unit); updateBudilng.NumberOfFloors = building.NumberOfFloors; updateBudilng.FootPrintArea = building.FootPrintArea; updateBudilng.ImprovedArea = building.ImprovedArea; updateBudilng.Heritage = building.Heritage; updateBudilng.OccupationYear = building.OccupationYear; updateBudilng.DisabledAccess = building.DisabledAccess.Trim(); updateBudilng.DisabledComment = building.DisabledComment.Trim(); updateBudilng.ConstructionDescription = building.ConstructionDescription; updateBudilng.Photo = building.Photo; updateBudilng.ModifiedDate = DateTime.Now; unit.Buildings.Update(updateBudilng); unit.SaveChanges(); int userId = updateBudilng.ModifiedUserId != null ? updateBudilng.ModifiedUserId.Value : 0; Task updateTask = new Task(() => LogAuditTrail("Building", "Update", userId, updateBudilng.Id)); updateTask.Start(); building.Facility = null; return(Request.CreateResponse(HttpStatusCode.OK, new { content = building })); } return(Request.CreateResponse(HttpStatusCode.OK)); } catch (Exception ex) { unit.Dispose(); ErrorHandling.LogError(ex.StackTrace, "UpdateBuilding"); return(Request.CreateResponse(ex)); } }
public HttpResponseMessage AddBuilding(Building building) { try { using (ApplicationUnit unit = new ApplicationUnit()) { Facility facility = unit.Facilities.GetAll().Include(b => b.Buildings) .FirstOrDefault(fc => fc.Id == building.Facility.Id); if (facility != null) { bool hasBuilding = facility.Buildings.Exists(b => b.BuildingName == building.BuildingName); if (!hasBuilding) { building.BuildingName = building.BuildingName.Trim(); building.BuildingNumber = building.BuildingNumber.Trim(); building.BuildingType = building.BuildingType.Trim(); building.DisabledAccess = building.DisabledAccess.Trim(); building.DisabledComment = building.DisabledComment.Trim(); building.BuildingStandard = building.BuildingStandard.Trim(); building.Status = building.Status.Trim(); building.Facility = facility; building.CreatedDate = DateTime.Now; building.ModifiedDate = DateTime.Now; unit.Buildings.Add(building); unit.SaveChanges(); building.Facility = null; Task addTask = new Task(() => LogAuditTrail("Building", "Add", building.CreatedUserId, building.Id)); addTask.Start(); return(Request.CreateResponse(HttpStatusCode.OK, new { content = building })); } } return(Request.CreateResponse(HttpStatusCode.OK)); } } catch (Exception ex) { ErrorHandling.LogError(ex.StackTrace, "AddBuilding"); return(Request.CreateResponse(ex)); } }
public HttpResponseMessage UpdateFacility(Facility facility) { ApplicationUnit unit = new ApplicationUnit(); Facility updateFacility = unit.Facilities.GetAll().FirstOrDefault(fc => fc.Id == facility.Id); try { if (updateFacility != null) { updateFacility.SettlementType = facility.SettlementType; updateFacility.Zoning = facility.Zoning; updateFacility.Name = facility.Name; updateFacility.IDPicture = facility.IDPicture; updateFacility.Status = facility.Status; updateFacility.ModifiedUserId = facility.ModifiedUserId; updateFacility.ModifiedDate = DateTime.Now; unit.Facilities.Update(updateFacility); unit.SaveChanges(); unit.Dispose(); int userId = updateFacility.ModifiedUserId != null ? facility.ModifiedUserId.Value : 0; Task updateTask = new Task(() => LogAuditTrail("Facility", "Update", userId, updateFacility.Id)); updateTask.Start(); return(Request.CreateResponse(HttpStatusCode.OK, new { content = true })); } return(Request.CreateResponse(HttpStatusCode.OK, new { content = true })); } catch (Exception ex) { unit.Dispose(); ErrorHandling.LogError(ex.StackTrace, "UpdateFacility"); return(Request.CreateResponse(ex)); } }
public Client AddClient(Client client) { using (ApplicationUnit unit = new ApplicationUnit()) { Client hasClient = unit.Clients.GetAll() .FirstOrDefault(cl => cl.ClientId.ToLower() == client.ClientId.ToLower()); if (hasClient == null) { client.CreatedDate = DateTime.Now; client.ModifiedDate = DateTime.Now; unit.Clients.Add(client); unit.SaveChanges(); return(client); } return(null); } }
public User AddUser(User user) { using (ApplicationUnit unit = new ApplicationUnit()) { User loginUser = unit.Users.GetAll() .FirstOrDefault(usr => usr.Username.ToLower() == user.Username.ToLower()); if (loginUser == null) { string password = EncryptString.Encrypt(user.Password, "THEPROJECT"); user.Password = password; user.CreatedDate = DateTime.Now; user.ModifiedDate = DateTime.Now; unit.Users.Add(user); unit.SaveChanges(); return(user); } return(null); } }
private void LogAuditTrail(string section, string type, int userId, int itemId) { try { using (ApplicationUnit unit = new ApplicationUnit()) { Audit audit = new Audit { ChangeDate = DateTime.Now, ItemId = itemId, Section = section, UserId = userId, Type = type }; unit.Audits.Add(audit); unit.SaveChanges(); } } catch (Exception) { throw; } }
public Technician CreateTechnicianAccount(Technician technician) { using (ApplicationUnit unit = new ApplicationUnit()) { Technician hasUser = unit.Technicians.GetAll().FirstOrDefault(u => u.CellNo.ToLower() == technician.CellNo.ToLower()); if (hasUser == null) { string password = Encryption.Encrypt(technician.Password, "BusinessPortal"); technician.Password = password; technician.Role = "Technician"; unit.Technicians.Add(technician); unit.SaveChanges(); //Send Message to user //EmailService emailService = new EmailService(); //Task sendEmailTask = new Task(() => emailService.SendWelcomeEmail(user.Email)); //sendEmailTask.Start(); return(technician); } return(null); } }
private void CreateK2UKApp() { //Database.SetInitializer(new DropCreateDatabaseAlways<K2Field.SmartForms.Workspace.Model.WorkspaceContext>()); using (var unit = new ApplicationUnit()) { Data.WorkspaceUser u = new Data.WorkspaceUser() { Username = @"denallix\administrator", FQN = @"denallix\administrator", DisplayName = "Administrator", Email = "*****@*****.**", IsActive = true }; ObservableCollection <Data.WorkspaceUser> r = new ObservableCollection <Data.WorkspaceUser>(); r.Add(u); Data.WorkspaceTeam scna = new Data.WorkspaceTeam() { Name = "scna", DisplayName = "K2 SCNA", Description = "K2 North American Team", IsActive = true, WorkspaceUsers = r, }; Data.WorkspaceTeam scuk = new Data.WorkspaceTeam() { Name = "scuk", DisplayName = "K2 SCUK", Description = "K2 UK Europe Team", IsActive = true, WorkspaceUsers = r, }; Data.WorkspaceLink link1a = new Data.WorkspaceLink() { Name = "mytasks", DisplayName = "My Tasks", IsEnabled = true, IsSmartForm = true, Level = 1, Url = "https://k2.denallix.com/Runtime/Runtime/Form/Worklist/", Type = "Link", Icon = "fa fa-male fa-fw", MinHeight = 400 }; Data.WorkspaceLink link1b = new Data.WorkspaceLink() { Name = "teamtasks", DisplayName = "Team Tasks", IsEnabled = true, IsSmartForm = true, Level = 1, Url = "https://k2.denallix.com/Runtime/Runtime/Form/Worklist/", Type = "Link", Icon = "fa fa-group fa-fw", MinHeight = 400 }; Data.WorkspaceLink link1c = new Data.WorkspaceLink() { Name = "servicetasks", DisplayName = "Service Tasks", IsEnabled = true, IsSmartForm = true, Level = 1, Url = "https://k2.denallix.com/Runtime/Runtime/Form/Worklist/", Type = "Link", Icon = "fa fa-sort-amount-asc fa-fw", MinHeight = 400 }; ObservableCollection <Data.WorkspaceLink> tasks = new ObservableCollection <Data.WorkspaceLink>(); tasks.Add(link1a); tasks.Add(link1b); tasks.Add(link1c); Data.WorkspaceLink link1 = new Data.WorkspaceLink() { Name = "tasks", DisplayName = "Tasks", IsEnabled = true, IsSmartForm = false, Level = 0, Type = "Heading", ChildLinks = tasks, Icon = "fa fa-tasks fa-fw", }; Data.WorkspaceLink link2 = new Data.WorkspaceLink() { Name = "apps", DisplayName = "Apps", IsEnabled = true, IsSmartForm = false, Level = 0, //Url = "https://k2.denallix.com/Runtime/Runtime/View/Demo+CRM+Account+List/", Type = "Heading", Icon = "fa fa-cogs fa-fw", MinHeight = 500 }; Data.WorkspaceLink taskalloc = new Data.WorkspaceLink() { Name = "taskallocation", DisplayName = "Task Allocation", Description = "Allocate a managed tasks to users", IsEnabled = true, IsSmartForm = true, Level = 1, Url = "https://k2.denallix.com/runtime/runtime/form/cm.task__create.form/?_theme=jove1", Type = "Link", Icon = "fa fa-sitemap fa-fw", MinHeight = 500, Sequence = 0, }; Data.WorkspaceLink sendmessage = new Data.WorkspaceLink() { Name = "sendmessage", DisplayName = "Send Message", Description = "Send a tracked email or SMS message", IsEnabled = true, IsSmartForm = true, Level = 1, Url = "https://k2.denallix.com/runtime/runtime/form/cm.sendmessage.form/?_theme=jove1", Type = "Link", Icon = "fa fa-paper-plane fa-fw", MinHeight = 500, Sequence = 0, }; Data.WorkspaceLink customerfeedback = new Data.WorkspaceLink() { Name = "customerfeedback", DisplayName = "Customer Feedback", Description = "Record and manage customer feedback", IsEnabled = true, IsSmartForm = true, Level = 1, Url = "https://k2.denallix.com/runtime/runtime/form/newportal__denallix__com__sales__lists__customer__feedbacktaskform/?_theme=jove1", Type = "Link", Icon = "fa fa-rocket fa-fw", MinHeight = 500, Sequence = 0, }; Data.WorkspaceLink logaconversation = new Data.WorkspaceLink() { Name = "logaconversation", DisplayName = "Log a Conversation", Description = "Log a conversation with an employee or customer", IsEnabled = true, IsSmartForm = true, Level = 1, Url = "https://k2.denallix.com/runtime/runtime/form/cm.logconversation.form/", Type = "Link", Icon = "fa fa-wechat fa-fw", MinHeight = 500, Sequence = 0, }; Data.WorkspaceLink employeeonboarding = new Data.WorkspaceLink() { Name = "employeeonboarding", DisplayName = "Employee Onboarding", Description = "Onboard a new employee", IsEnabled = true, IsSmartForm = true, Level = 1, Url = "https://k2.denallix.com/runtime/runtime/form/eo.submitnewemployee.form/", Type = "Link", Icon = "fa fa-desktop fa-fw", MinHeight = 500, Sequence = 0, }; Data.WorkspaceLink raiseapurchaseorder = new Data.WorkspaceLink() { Name = "raiseapurchaseorder", DisplayName = "Raise Purchase Order", Description = "Raise new purchase order", IsEnabled = true, IsSmartForm = true, Level = 1, Url = "https://k2.denallix.com/runtime/runtime/form/po.raisenewpo.form/?_theme=jove1", Type = "Link", Icon = "fa fa-usd fa-fw", MinHeight = 500, Sequence = 0, }; ObservableCollection <Data.WorkspaceLink> apps = new ObservableCollection <Data.WorkspaceLink>(); apps.Add(taskalloc); apps.Add(sendmessage); apps.Add(customerfeedback); apps.Add(logaconversation); apps.Add(employeeonboarding); apps.Add(raiseapurchaseorder); link2.ChildLinks = apps; Data.WorkspaceLink link3 = new Data.WorkspaceLink() { Name = "dashboards", DisplayName = "Dashboards", IsEnabled = true, IsSmartForm = false, Level = 0, Type = "Heading", Icon = "fa fa-dashboard fa-fw", MinHeight = 500, Sequence = 2, }; Data.WorkspaceLink chart1 = new Data.WorkspaceLink() { Name = "chart1", DisplayName = "Org KPI ", Description = "Organization wide KPIs", IsEnabled = true, IsSmartForm = true, Level = 1, Url = "https://k2.denallix.com/runtime/runtime/form/po.raisenewpo.form/?_theme=jove1", Type = "Link", Icon = "fa fa-area-chart fa-fw", MinHeight = 500, Sequence = 0, }; Data.WorkspaceLink chart2 = new Data.WorkspaceLink() { Name = "chart2", DisplayName = "Task Dashboard ", Description = "Task Dashboard", IsEnabled = true, IsSmartForm = true, Level = 1, Url = "https://k2.denallix.com/runtime/runtime/form/po.raisenewpo.form/?_theme=jove1", Type = "Link", Icon = "fa fa-line-chart fa-fw", MinHeight = 500, Sequence = 0, }; Data.WorkspaceLink chart3 = new Data.WorkspaceLink() { Name = "chart3", DisplayName = "Customer Service Dashboard ", Description = "Customer Service Dashboard", IsEnabled = true, IsSmartForm = true, Level = 1, Url = "https://k2.denallix.com/runtime/runtime/form/po.raisenewpo.form/?_theme=jove1", Type = "Link", Icon = "fa fa-pie-chart fa-fw", MinHeight = 500, Sequence = 0, }; ObservableCollection <Data.WorkspaceLink> dash = new ObservableCollection <Data.WorkspaceLink>(); dash.Add(chart1); dash.Add(chart2); dash.Add(chart3); link3.ChildLinks = dash; ObservableCollection <Data.WorkspaceLink> headings = new ObservableCollection <Data.WorkspaceLink>(); headings.Add(link1); headings.Add(link2); headings.Add(link3); //Url = "https://k2.denallix.com/Runtime/Runtime/View/Demo+CRM+Account+List/", //unit.WorklistUsers.Add(u); Data.Workspace w = new Data.Workspace() { DisplayName = "K2 Workdesk", Name = "K2workdesk", Description = "K2 Workdesk description....", SmartFormsRuntimeUrl = "https://k2.denallix.com/runtime/", Links = headings, Icon = "fa fa-suitcase fa-2x", }; ObservableCollection <Data.WorkspaceLink> headings1 = new ObservableCollection <Data.WorkspaceLink>(); headings1.Add(link1a); headings1.Add(link1b); headings1.Add(link1c); headings1.Add(chart1); headings1.Add(chart2); Data.Workspace w1 = new Data.Workspace() { DisplayName = "Task Management", Name = "taskmanagement", Description = "Task Management workdesk description...", SmartFormsRuntimeUrl = "https://k2.denallix.com/runtime/", Links = headings1, Icon = "fa fa-share-alt fa-2x", }; Data.WorkspaceLink linkservice = new Data.WorkspaceLink() { Name = "serviceapps", DisplayName = "Service Apps", IsEnabled = true, IsSmartForm = false, Level = 0, //Url = "https://k2.denallix.com/Runtime/Runtime/View/Demo+CRM+Account+List/", Type = "Heading", Icon = "fa fa-cogs fa-fw", MinHeight = 500 }; ObservableCollection <Data.WorkspaceLink> serviceapps = new ObservableCollection <Data.WorkspaceLink>(); serviceapps.Add(customerfeedback); serviceapps.Add(sendmessage); serviceapps.Add(logaconversation); serviceapps.Add(taskalloc); linkservice.ChildLinks = serviceapps; ObservableCollection <Data.WorkspaceLink> headings2 = new ObservableCollection <Data.WorkspaceLink>(); headings2.Add(link1a); headings2.Add(link1b); headings2.Add(linkservice); headings2.Add(chart1); headings2.Add(chart3); Data.Workspace w2 = new Data.Workspace() { DisplayName = "Service Desks", Name = "servicedesk", Description = "Customer Service Desk description...", SmartFormsRuntimeUrl = "https://k2.denallix.com/runtime/", Links = headings2, Icon = "fa fa-trophy fa-2x", }; w.WorkspaceTeams = new ObservableCollection <Data.WorkspaceTeam>(); w.WorkspaceTeams.Add(scna); w.WorkspaceTeams.Add(scuk); w1.WorkspaceTeams = new ObservableCollection <Data.WorkspaceTeam>(); w1.WorkspaceTeams.Add(scna); w1.WorkspaceTeams.Add(scuk); w2.WorkspaceTeams = new ObservableCollection <Data.WorkspaceTeam>(); w2.WorkspaceTeams.Add(scna); w2.WorkspaceTeams.Add(scuk); //unit.WorkspaceTeams.Add(t); unit.Workspaces.Add(w); unit.Workspaces.Add(w1); unit.Workspaces.Add(w2); int rows = unit.SaveChanges(); MessageBox.Show("Rows: " + rows); } }