public void UpdateProjectInfoTreeLocation(ProjectInfoTreeLocation updatedProjectInfoTreeLocation) { // Validate Parameters if (updatedProjectInfoTreeLocation == null) { throw (new ArgumentNullException("updatedProjectInfoTreeLocation")); } // Validate Primary key value if (updatedProjectInfoTreeLocation.ProjectInfoTreeLocationID.IsInvalidKey()) { BusinessLayerHelper.ThrowErrorForInvalidDataKey("ProjectInfoTreeLocationID"); } // Apply business rules OnProjectInfoTreeLocationSaving(updatedProjectInfoTreeLocation); OnProjectInfoTreeLocationUpdating(updatedProjectInfoTreeLocation); //attaching and making ready for parsistance if (updatedProjectInfoTreeLocation.EntityState == EntityState.Detached) { _DatabaseContext.ProjectInfoTreeLocations.Attach(updatedProjectInfoTreeLocation); } _DatabaseContext.ObjectStateManager.ChangeObjectState(updatedProjectInfoTreeLocation, System.Data.EntityState.Modified); //this line makes the code un-testable! int numberOfAffectedRows = _DatabaseContext.SaveChanges(); if (numberOfAffectedRows == 0) { throw new DataNotUpdatedException("No projectInfoTreeLocation updated!"); } //Apply business workflow OnProjectInfoTreeLocationUpdated(updatedProjectInfoTreeLocation); OnProjectInfoTreeLocationSaved(updatedProjectInfoTreeLocation); }
public void DeleteProjectInfoTreeLocation(ProjectInfoTreeLocation projectInfoTreeLocationToBeDeleted) { //Validate Input if (projectInfoTreeLocationToBeDeleted == null) { throw (new ArgumentNullException("projectInfoTreeLocationToBeDeleted")); } // Validate Primary key value if (projectInfoTreeLocationToBeDeleted.ProjectInfoTreeLocationID.IsInvalidKey()) { BusinessLayerHelper.ThrowErrorForInvalidDataKey("ProjectInfoTreeLocationID"); } OnProjectInfoTreeLocationSaving(projectInfoTreeLocationToBeDeleted); OnProjectInfoTreeLocationDeleting(projectInfoTreeLocationToBeDeleted); if (projectInfoTreeLocationToBeDeleted.EntityState == EntityState.Detached) { _DatabaseContext.ProjectInfoTreeLocations.Attach(projectInfoTreeLocationToBeDeleted); } _DatabaseContext.ProjectInfoTreeLocations.DeleteObject(projectInfoTreeLocationToBeDeleted); int numberOfAffectedRows = _DatabaseContext.SaveChanges(); if (numberOfAffectedRows == 0) { throw new DataNotUpdatedException("No ProjectInfoTreeLocation deleted!"); } OnProjectInfoTreeLocationDeleted(projectInfoTreeLocationToBeDeleted); OnProjectInfoTreeLocationSaved(projectInfoTreeLocationToBeDeleted); }
public virtual int CreateNewProjectInfoTreeLocation(ProjectInfoTreeLocation newProjectInfoTreeLocation) { // Validate Parameters if (newProjectInfoTreeLocation == null) { throw (new ArgumentNullException("newProjectInfoTreeLocation")); } // Apply business rules OnProjectInfoTreeLocationSaving(newProjectInfoTreeLocation); OnProjectInfoTreeLocationCreating(newProjectInfoTreeLocation); _DatabaseContext.ProjectInfoTreeLocations.AddObject(newProjectInfoTreeLocation); int numberOfAffectedRows = _DatabaseContext.SaveChanges(); if (numberOfAffectedRows == 0) { throw new DataNotUpdatedException("No projectInfoTreeLocation created!"); } // Apply business workflow OnProjectInfoTreeLocationCreated(newProjectInfoTreeLocation); OnProjectInfoTreeLocationSaved(newProjectInfoTreeLocation); return(newProjectInfoTreeLocation.ProjectInfoTreeLocationID); }
public void DeleteProjectInfoTreeLocations(List <int> projectInfoTreeLocationIDsToDelete) { //Validate Input foreach (int projectInfoTreeLocationID in projectInfoTreeLocationIDsToDelete) { if (projectInfoTreeLocationID.IsInvalidKey()) { BusinessLayerHelper.ThrowErrorForInvalidDataKey("ProjectInfoTreeLocationID"); } } List <ProjectInfoTreeLocation> projectInfoTreeLocationsToBeDeleted = new List <ProjectInfoTreeLocation>(); foreach (int projectInfoTreeLocationID in projectInfoTreeLocationIDsToDelete) { ProjectInfoTreeLocation projectInfoTreeLocation = new ProjectInfoTreeLocation { ProjectInfoTreeLocationID = projectInfoTreeLocationID }; _DatabaseContext.ProjectInfoTreeLocations.Attach(projectInfoTreeLocation); _DatabaseContext.ProjectInfoTreeLocations.DeleteObject(projectInfoTreeLocation); projectInfoTreeLocationsToBeDeleted.Add(projectInfoTreeLocation); OnProjectInfoTreeLocationDeleting(projectInfoTreeLocation); } int numberOfAffectedRows = _DatabaseContext.SaveChanges(); if (numberOfAffectedRows != projectInfoTreeLocationIDsToDelete.Count) { throw new DataNotUpdatedException("One or more projectInfoTreeLocation records have not been deleted."); } foreach (ProjectInfoTreeLocation projectInfoTreeLocationToBeDeleted in projectInfoTreeLocationsToBeDeleted) { OnProjectInfoTreeLocationDeleted(projectInfoTreeLocationToBeDeleted); } }
public static string GetMitigacion(ProjectInfoTreeLocation _projectInfoTreeLocation) { if (_projectInfoTreeLocation == null) { return(""); } switch (_projectInfoTreeLocation.Mitigation) { case 0: case 1: return("Mitigación por solares"); case 2: case 3: if (_projectInfoTreeLocation.PreviouslyImpacted.HasValue) { if ((bool)_projectInfoTreeLocation.PreviouslyImpacted) { return("No requerirá mitigación (Previamente Impactado)"); } } if (_projectInfoTreeLocation.Acres.HasValue) { if ((decimal)_projectInfoTreeLocation.Acres < 1) { return("No requerirá mitigación (Total de Cuerdas en el Proyecto menor de uno)"); } } return("Mitigación por perímetro"); default: return(""); } }
protected string getProjectDetails() { Project project = new ProjectBLL().GetProjectByProjectID(Convert.ToInt32(RouteData.Values["project_id"])); ProjectInfoTreeLocation projectInfoTreeLocation = project.ProjectInfoTreeLocations.FirstOrDefault(); ProjectInfo projectInfo = project.ProjectInfoes.FirstOrDefault(); if (projectInfoTreeLocation == null) { projectInfoTreeLocation = new ProjectInfoTreeLocation(); projectInfoTreeLocation.X = 0; projectInfoTreeLocation.Y = 0; projectInfoTreeLocation.Lat = 0; projectInfoTreeLocation.Lon = 0; projectInfoTreeLocation.Acres = 0; projectInfoTreeLocation.Lots1 = 0; projectInfoTreeLocation.Parkings = 0; projectInfoTreeLocation.DistanceBetweenTrees = 10; projectInfoTreeLocation.ProjectID = project.ProjectID; projectInfoTreeLocation.ProjectReference.EntityKey = project.EntityKey; new ProjectInfoTreeLocationBLL().CreateNewProjectInfoTreeLocation(projectInfoTreeLocation); } var proj = new { projectInfo.ProjectName, projectInfoTreeLocation.ProjectID, projectInfoTreeLocation.Acres, projectInfoTreeLocation.DistanceBetweenTrees, projectInfoTreeLocation.Lat, projectInfoTreeLocation.Lon, projectInfoTreeLocation.Parkings, projectInfoTreeLocation.X, projectInfoTreeLocation.Y, projectInfo.City.CityName, projectInfo.City.CityID, CityX = projectInfo.City.X, CityY = projectInfo.City.Y, CityLat = projectInfo.City.Lat, CityLon = projectInfo.City.Lon, projectInfo.ZipCode }; return(new JavaScriptSerializer().Serialize(proj)); }
public static void EditProjectCenter(string projectID, string JStr) { Project project = new ProjectBLL().GetProjectByProjectId2(Convert.ToInt32(projectID)); using (DatabaseContext _DatabaseContext = new DatabaseContext()) { var nList = new JavaScriptSerializer().Deserialize <Object>(JStr); ProjectInfoTreeLocation projectInfoTreeLocation = project.ProjectInfoTreeLocations.Count == 0 ? new ProjectInfoTreeLocation() : _DatabaseContext.ProjectInfoTreeLocations.First(instance => instance.ProjectID == project.ProjectID); ProjectInfo projectInfo = project.ProjectInfoes.Count == 0 ? new ProjectInfo() : _DatabaseContext.ProjectInfoes.First(instance => instance.ProjectID == project.ProjectID); projectInfo.ProjectName = ((Dictionary <string, object>)nList).ContainsKey("ProjectName") ? Convert.ToInt32(((Dictionary <string, object>)nList)["ProjectName"]).ToString() : projectInfo.ProjectName; projectInfoTreeLocation.ProjectID = ((Dictionary <string, object>)nList).ContainsKey("ProjectID") ? Convert.ToInt32(((Dictionary <string, object>)nList)["ProjectID"]) : projectInfoTreeLocation.ProjectID; projectInfoTreeLocation.X = ((Dictionary <string, object>)nList).ContainsKey("X") ? Convert.ToDecimal(((Dictionary <string, object>)nList)["X"]) : projectInfoTreeLocation.X; projectInfoTreeLocation.Y = ((Dictionary <string, object>)nList).ContainsKey("Y") ? Convert.ToDecimal(((Dictionary <string, object>)nList)["Y"]) : projectInfoTreeLocation.Y; projectInfoTreeLocation.Lat = ((Dictionary <string, object>)nList).ContainsKey("Lat") ? Convert.ToDecimal(((Dictionary <string, object>)nList)["Lat"]) : projectInfoTreeLocation.Lat; projectInfoTreeLocation.Lon = ((Dictionary <string, object>)nList).ContainsKey("Lon") ? Convert.ToDecimal(((Dictionary <string, object>)nList)["Lon"]) : projectInfoTreeLocation.Lon; projectInfoTreeLocation.Acres = ((Dictionary <string, object>)nList).ContainsKey("Acres") ? Convert.ToDecimal(((Dictionary <string, object>)nList)["Acres"]) : projectInfoTreeLocation.Acres; projectInfoTreeLocation.Lots0 = ((Dictionary <string, object>)nList).ContainsKey("Lots0") ? Convert.ToInt32(((Dictionary <string, object>)nList)["Lots0"]) : projectInfoTreeLocation.Lots0; projectInfoTreeLocation.Lots1 = ((Dictionary <string, object>)nList).ContainsKey("Lots1") ? Convert.ToInt32(((Dictionary <string, object>)nList)["Lots1"]) : projectInfoTreeLocation.Lots1; projectInfoTreeLocation.Lots2 = ((Dictionary <string, object>)nList).ContainsKey("Lots2") ? Convert.ToInt32(((Dictionary <string, object>)nList)["Lots2"]) : projectInfoTreeLocation.Lots2; projectInfoTreeLocation.Lots3 = ((Dictionary <string, object>)nList).ContainsKey("Lots3") ? Convert.ToInt32(((Dictionary <string, object>)nList)["Lots3"]) : projectInfoTreeLocation.Lots3; projectInfoTreeLocation.Mitigation = ((Dictionary <string, object>)nList).ContainsKey("Mitigation") ? Convert.ToInt32(((Dictionary <string, object>)nList)["Mitigation"]) : projectInfoTreeLocation.Mitigation; projectInfoTreeLocation.SocialInterest = ((Dictionary <string, object>)nList).ContainsKey("SocialInterest") ? Convert.ToBoolean(((Dictionary <string, object>)nList)["SocialInterest"]) : projectInfoTreeLocation.SocialInterest; projectInfoTreeLocation.PreviouslyImpacted = ((Dictionary <string, object>)nList).ContainsKey("PreviouslyImpacted") ? Convert.ToBoolean(((Dictionary <string, object>)nList)["PreviouslyImpacted"]) : projectInfoTreeLocation.PreviouslyImpacted; projectInfoTreeLocation.Parkings = ((Dictionary <string, object>)nList).ContainsKey("Parkings") ? Convert.ToInt32(((Dictionary <string, object>)nList)["Parkings"]) : projectInfoTreeLocation.Parkings; projectInfoTreeLocation.DistanceBetweenTrees = ((Dictionary <string, object>)nList).ContainsKey("DistanceBetweenTrees") ? Convert.ToInt32(((Dictionary <string, object>)nList)["DistanceBetweenTrees"]) : projectInfoTreeLocation.DistanceBetweenTrees; projectInfo.ZipCode = ((Dictionary <string, object>)nList).ContainsKey("ZipCode") ? (((Dictionary <string, object>)nList)["ZipCode"]).ToString() : projectInfo.ZipCode; projectInfo.CityID = ((Dictionary <string, object>)nList).ContainsKey("City") ? Convert.ToInt32(((Dictionary <string, object>)nList)["City"]) : projectInfo.City.CityID; projectInfoTreeLocation.ProjectID = project.ProjectID; projectInfoTreeLocation.ProjectReference.EntityKey = project.EntityKey; projectInfo.ProjectID = project.ProjectID; projectInfo.ProjectReference.EntityKey = project.EntityKey; if (project.ProjectInfoTreeLocations.Count == 0) { new ProjectInfoTreeLocationBLL().CreateNewProjectInfoTreeLocation(projectInfoTreeLocation); } _DatabaseContext.SaveChanges(); } }
protected void FormViewTlProject_DataBinding(object sender, EventArgs e) { string projectID = Page.RouteData.Values["project_id"] as string; if (projectID != null && projectID != "0") { Project project = new ProjectBLL().GetProjectByProjectID(Convert.ToInt32(projectID)); this.editor = new Eisk.BusinessLogicLayer.UserBLL().GetUserByUserID(project.EditorUserID); this.creator = new Eisk.BusinessLogicLayer.UserBLL().GetUserByUserID(project.CreatorUserID); if (project.ProjectInfoTreeLocations.Count > 0) { this.projectInfoTreeLocation = project.ProjectInfoTreeLocations.First(); } if (project.ProjectInfoes.Count > 0) { this.projectInfo = project.ProjectInfoes.First(); } } }
protected void FormViewTlProject_ItemUpdating(object sender, FormViewUpdateEventArgs e) { Project project = new ProjectBLL().GetProjectByProjectId2((int)e.Keys["ProjectId"]); using (DatabaseContext _DatabaseContext = new DatabaseContext()) { // ProjectInfoTreeLocation TextBox txtX = (TextBox)formViewTlProject.FindControl("txtX"); TextBox txtY = (TextBox)formViewTlProject.FindControl("txtY"); TextBox txtLat = (TextBox)formViewTlProject.FindControl("txtLat"); TextBox txtLon = (TextBox)formViewTlProject.FindControl("txtLon"); TextBox txtParkings = (TextBox)formViewTlProject.FindControl("txtParkings"); RadioButtonList rblCalc = (RadioButtonList)formViewTlProject.FindControl("rblCalc"); TextBox txtAcres = (TextBox)formViewTlProject.FindControl("txtAcres"); DropDownList ddlDistanceBetweenTrees = (DropDownList)formViewTlProject.FindControl("ddlDistanceBetweenTrees"); TextBox txtLots0 = (TextBox)formViewTlProject.FindControl("txtLots0"); TextBox txtLots1 = (TextBox)formViewTlProject.FindControl("txtLots1"); TextBox txtLots2 = (TextBox)formViewTlProject.FindControl("txtLots2"); TextBox txtLots3 = (TextBox)formViewTlProject.FindControl("txtLots3"); RadioButtonList rblSocialInterest = (RadioButtonList)formViewTlProject.FindControl("rblSocialInterest"); RadioButtonList rblPreviouslyImpacted = (RadioButtonList)formViewTlProject.FindControl("rblPreviouslyImpacted"); ProjectInfoTreeLocation projectInfoTreeLocation = project.ProjectInfoTreeLocations.Count == 0 ? new ProjectInfoTreeLocation() : _DatabaseContext.ProjectInfoTreeLocations.First(instance => instance.ProjectID == project.ProjectID); decimal dec; int integer; RadioButtonList rblPosition = (RadioButtonList)formViewTlProject.FindControl("rblPosition"); if (rblPosition.SelectedValue == "0") // Nad83 { projectInfoTreeLocation.X = decimal.TryParse(txtX.Text, out dec) ? Convert.ToDecimal(txtX.Text) : 0; projectInfoTreeLocation.Y = decimal.TryParse(txtY.Text, out dec) ? Convert.ToDecimal(txtY.Text) : 0; if (projectInfoTreeLocation.X != 0 && projectInfoTreeLocation.Y != 0) { Dictionary <string, object> anewpointObj = Utility.ConvertToLatLng(projectInfoTreeLocation.X.ToString(), projectInfoTreeLocation.Y.ToString(), @"~/App_Resources/client-scripts/tl/"); projectInfoTreeLocation.Lat = Convert.ToDecimal(anewpointObj["y"]); txtLat.Text = projectInfoTreeLocation.Lat.ToString(); projectInfoTreeLocation.Lon = Convert.ToDecimal(anewpointObj["x"]); txtLon.Text = projectInfoTreeLocation.Lon.ToString(); } else { projectInfoTreeLocation.Lat = 0; projectInfoTreeLocation.Lon = 0; } } else // StatePlanes { projectInfoTreeLocation.Lat = decimal.TryParse(txtLat.Text, out dec) ? Convert.ToDecimal(txtLat.Text) : 0; projectInfoTreeLocation.Lon = decimal.TryParse(txtLon.Text, out dec) ? Convert.ToDecimal(txtLon.Text) : 0; if (projectInfoTreeLocation.Lat != 0 && projectInfoTreeLocation.Lon != 0) { Dictionary <string, object> anewpointObj = Utility.ConvertToStatePlane(projectInfoTreeLocation.Lon.ToString(), projectInfoTreeLocation.Lat.ToString(), @"~/App_Resources/client-scripts/tl/"); projectInfoTreeLocation.X = Convert.ToDecimal(anewpointObj["x"]); txtX.Text = projectInfoTreeLocation.X.ToString(); projectInfoTreeLocation.Y = Convert.ToDecimal(anewpointObj["y"]); txtY.Text = projectInfoTreeLocation.Y.ToString(); } else { projectInfoTreeLocation.X = 0; projectInfoTreeLocation.Y = 0; } } projectInfoTreeLocation.Parkings = Int32.TryParse(txtParkings.Text, out integer) ? Convert.ToInt32(txtParkings.Text) : 0; projectInfoTreeLocation.Acres = decimal.TryParse(txtAcres.Text, out dec) ? Convert.ToDecimal(txtAcres.Text) : 0; projectInfoTreeLocation.DistanceBetweenTrees = null; projectInfoTreeLocation.PreviouslyImpacted = null; projectInfoTreeLocation.Mitigation = Convert.ToInt32(rblCalc.SelectedValue); if (Convert.ToInt32(rblCalc.SelectedValue) > 1) { // Cálculo por perímetro projectInfoTreeLocation.Lots0 = projectInfoTreeLocation.Lots1 = projectInfoTreeLocation.Lots2 = projectInfoTreeLocation.Lots3 = 0; if (rblPreviouslyImpacted.SelectedValue == "0") // Previamente impactado = No { projectInfoTreeLocation.DistanceBetweenTrees = Int32.TryParse(ddlDistanceBetweenTrees.SelectedValue, out integer) ? Convert.ToInt32(ddlDistanceBetweenTrees.SelectedValue) : 0; } projectInfoTreeLocation.PreviouslyImpacted = rblPreviouslyImpacted.SelectedValue == "1"; } else {// Cálculo por solares projectInfoTreeLocation.Lots0 = Int32.TryParse(txtLots0.Text, out integer) ? integer : 0; projectInfoTreeLocation.Lots1 = Int32.TryParse(txtLots1.Text, out integer) ? integer : 0; projectInfoTreeLocation.Lots2 = Int32.TryParse(txtLots2.Text, out integer) ? integer : 0; projectInfoTreeLocation.Lots3 = Int32.TryParse(txtLots3.Text, out integer) ? integer : 0; projectInfoTreeLocation.DistanceBetweenTrees = null; } projectInfoTreeLocation.SocialInterest = rblSocialInterest.SelectedValue == "1"; projectInfoTreeLocation.ProjectID = project.ProjectID; projectInfoTreeLocation.ProjectReference.EntityKey = project.EntityKey; if (project.ProjectInfoTreeLocations.Count == 0) { new ProjectInfoTreeLocationBLL().CreateNewProjectInfoTreeLocation(projectInfoTreeLocation); } else { _DatabaseContext.SaveChanges(); } // } Type myType = (typeof(Project)); PropertyInfo[] props = myType.GetProperties(); string[] arrNewValues = new string[e.NewValues.Keys.Count]; e.NewValues.Keys.CopyTo(arrNewValues, 0); foreach (var prop in props) { if (("System.String,System.Int,System.DateTime,System.Guid").IndexOf((prop.PropertyType).FullName) >= 0) // Si la propiedad es de tipo Guid, String, Int o DateTime { if (!arrNewValues.Contains(prop.Name)) { e.NewValues[prop.Name] = prop.GetValue(project, null); } } } User editor = new UserBLL().GetUserByUserName((HttpContext.Current.User.Identity).Name); e.NewValues["EditorUserId"] = editor.UserID.ToString(); e.NewValues["EditedDate"] = DateTime.Now; //} //else //{ // ltlMessage.Text = MessageFormatter.GetFormattedErrorMessage(GetErrorMessage(status)); // e.Cancel = true; //} }
protected void OdsProject_Details_Inserted(object sender, System.Web.UI.WebControls.ObjectDataSourceStatusEventArgs e) { int integer; int result = Convert.ToInt32(e.ReturnValue, System.Globalization.CultureInfo.CurrentCulture.NumberFormat); if (result != 0) { Project project = new ProjectBLL().GetProjectByProjectID(result); UserBLL userBLL = new UserBLL(); Eisk.BusinessEntities.User user = userBLL.GetUserByUserName((HttpContext.Current.User.Identity).Name); if (user != null) { // ProjectInfoTreeLocation TextBox txtX = (TextBox)formViewTlProject.FindControl("txtX"); TextBox txtY = (TextBox)formViewTlProject.FindControl("txtY"); TextBox txtLat = (TextBox)formViewTlProject.FindControl("txtLat"); TextBox txtLon = (TextBox)formViewTlProject.FindControl("txtLon"); TextBox txtParking = (TextBox)formViewTlProject.FindControl("txtParking"); RadioButtonList rblCalc = (RadioButtonList)formViewTlProject.FindControl("rblCalc"); TextBox txtAcres = (TextBox)formViewTlProject.FindControl("txtAcres"); DropDownList ddlDistanceBetweenTrees = (DropDownList)formViewTlProject.FindControl("ddlDistanceBetweenTrees"); TextBox txtLots0 = (TextBox)formViewTlProject.FindControl("txtLots0"); TextBox txtLots1 = (TextBox)formViewTlProject.FindControl("txtLots1"); TextBox txtLots2 = (TextBox)formViewTlProject.FindControl("txtLots2"); TextBox txtLots3 = (TextBox)formViewTlProject.FindControl("txtLots3"); RadioButtonList rblSocialInterest = (RadioButtonList)formViewTlProject.FindControl("rblSocialInterest"); RadioButtonList rblPreviouslyImpacted = (RadioButtonList)formViewTlProject.FindControl("rblPreviouslyImpacted"); ProjectInfoTreeLocation projectInfoTreeLocation = new ProjectInfoTreeLocation(); projectInfoTreeLocation.X = Convert.ToDecimal(txtX.Text); projectInfoTreeLocation.Y = Convert.ToDecimal(txtY.Text); projectInfoTreeLocation.Lat = Convert.ToDecimal(txtLat.Text); projectInfoTreeLocation.Lon = Convert.ToDecimal(txtLon.Text); projectInfoTreeLocation.Parkings = Convert.ToInt32(txtParking.Text); projectInfoTreeLocation.Acres = Convert.ToDecimal(txtAcres.Text); projectInfoTreeLocation.SocialInterest = rblSocialInterest.SelectedValue == "1"; projectInfoTreeLocation.PreviouslyImpacted = rblPreviouslyImpacted.SelectedValue == "1"; projectInfoTreeLocation.Mitigation = Convert.ToInt32(rblCalc.SelectedValue); if (rblCalc.SelectedValue == "0") { projectInfoTreeLocation.Lots0 = projectInfoTreeLocation.Lots1 = projectInfoTreeLocation.Lots2 = projectInfoTreeLocation.Lots3 = 0; } else { projectInfoTreeLocation.Lots0 = Int32.TryParse(txtLots0.Text, out integer) ? integer : 0; projectInfoTreeLocation.Lots1 = Int32.TryParse(txtLots1.Text, out integer) ? integer : 0; projectInfoTreeLocation.Lots2 = Int32.TryParse(txtLots2.Text, out integer) ? integer : 0; projectInfoTreeLocation.Lots3 = Int32.TryParse(txtLots3.Text, out integer) ? integer : 0; projectInfoTreeLocation.DistanceBetweenTrees = null; } projectInfoTreeLocation.ProjectID = project.ProjectID; projectInfoTreeLocation.ProjectReference.EntityKey = project.EntityKey; new ProjectInfoTreeLocationBLL().CreateNewProjectInfoTreeLocation(projectInfoTreeLocation); // } Response.RedirectToRoute(new { edit_mode = "edit", Project_id = result.ToString() }); } }
partial void OnProjectInfoTreeLocationDeleted(ProjectInfoTreeLocation projectInfoTreeLocation);
partial void OnProjectInfoTreeLocationSaved(ProjectInfoTreeLocation projectInfoTreeLocation);
partial void OnProjectInfoTreeLocationUpdated(ProjectInfoTreeLocation projectInfoTreeLocation);
partial void OnProjectInfoTreeLocationCreating(ProjectInfoTreeLocation projectInfoTreeLocation);
public object Post([FromBody] ProjectModel newProject) { User user = (User)HttpContext.Current.Items["user"]; City city = (City)HttpContext.Current.Items["city"]; List <Group> groups = (List <Group>)HttpContext.Current.Items["groups"]; Project project = new Project(); project.CreatedDate = DateTime.Now; project.CreatorUserID = user.UserID; project.EditedDate = DateTime.Now; project.EditorUserID = user.UserID; new ProjectBLL().CreateNewProject(project); ProjectInfo projectInfo = new ProjectInfo(); projectInfo.ProjectName = newProject.ProjectName; projectInfo.Client = newProject.Client; projectInfo.Address1 = newProject.Address1; projectInfo.Address2 = newProject.Address2; projectInfo.CityID = newProject.CityID; projectInfo.CityReference.EntityKey = city.EntityKey; projectInfo.State = newProject.State; projectInfo.ZipCode = newProject.ZipCode != null?newProject.ZipCode.Replace("-", "") : ""; projectInfo.Description = newProject.Description != null?newProject.Description.Substring(0, Math.Min(newProject.Description.Length, 5000)) : ""; projectInfo.Comments = newProject.Comments != null?newProject.Comments.Substring(0, Math.Min(newProject.Comments.Length, 5000)) : ""; projectInfo.ProjectID = project.ProjectID; projectInfo.ProjectReference.EntityKey = project.EntityKey; new ProjectInfoBLL().CreateNewProjectInfo(projectInfo); ProjectInfoTreeLocation projectInfoTreeLocation = new ProjectInfoTreeLocation(); projectInfoTreeLocation.Acres = newProject.Acres; projectInfoTreeLocation.DistanceBetweenTrees = newProject.DistanceBetweenTrees; projectInfoTreeLocation.Lots1 = newProject.Lots; projectInfoTreeLocation.Parkings = newProject.Parkings; if ((newProject.Lat == null || newProject.Lat == 0) || (newProject.Lon == null || newProject.Lon == 0)) { newProject.Lat = city.Lat; newProject.Lon = city.Lon; } projectInfoTreeLocation.Lat = newProject.Lat; projectInfoTreeLocation.Lon = newProject.Lon; Dictionary <string, object> anewpointObj = Utility.ConvertToStatePlane(projectInfoTreeLocation.Lon.ToString(), projectInfoTreeLocation.Lat.ToString(), @"~/Javascript/"); projectInfoTreeLocation.X = Convert.ToDecimal(anewpointObj["x"]); projectInfoTreeLocation.Y = Convert.ToDecimal(anewpointObj["y"]); projectInfoTreeLocation.ProjectID = project.ProjectID; projectInfoTreeLocation.ProjectReference.EntityKey = project.EntityKey; new ProjectInfoTreeLocationBLL().CreateNewProjectInfoTreeLocation(projectInfoTreeLocation); // Group_Projects Group group = groups[0]; Group_Projects group_Projects = new Eisk.BusinessEntities.Group_Projects(); group_Projects.GroupID = group.GroupID; group_Projects.GroupReference.EntityKey = group.EntityKey; group_Projects.ProjectID = project.ProjectID; group_Projects.ProjectReference.EntityKey = project.EntityKey; new Group_ProjectsBLL().CreateNewGroup_Projects(group_Projects); // // Project project = new ProjectBLL().CreateNewProject(newProject.ProjectName, user, city, groups); return(ProjectModel.GetProjectObject(project)); }
public static object SetPerimeterFromSIP(string projectID, string JStr, string userID) { Project project = new ProjectBLL().GetProjectByProjectId2(Convert.ToInt32(projectID)); using (DatabaseContext _DatabaseContext = new DatabaseContext()) { var nList = new JavaScriptSerializer().Deserialize <Object>(JStr); ProjectInfoTreeLocation projectInfoTreeLocation = project.ProjectInfoTreeLocations.Count == 0 ? new ProjectInfoTreeLocation() : _DatabaseContext.ProjectInfoTreeLocations.First(instance => instance.ProjectID == project.ProjectID); projectInfoTreeLocation.X = ((Dictionary <string, object>)nList).ContainsKey("X") ? Convert.ToDecimal(((Dictionary <string, object>)nList)["X"]) : projectInfoTreeLocation.X; projectInfoTreeLocation.Y = ((Dictionary <string, object>)nList).ContainsKey("Y") ? Convert.ToDecimal(((Dictionary <string, object>)nList)["Y"]) : projectInfoTreeLocation.Y; string url = "http://www.gis.sip.pr.gov/ArcGIS/rest/services/Tools/Localizdor_JS8/MapServer/identify?f=json&geometry=%7B%22" + "x%22%3A" + miX + "%2C%22" + "y%22%3A" + miY + "%2C%22" + "spatialReference%22%3A%7B%22wkid%22%3A32161%7D%7D&tolerance=1&returnGeometry=true&mapExtent=%7B%22" + "xmin%22%3A" + miX + "%2C%22" + "ymin%22%3A" + miY + "%2C%22" + "xmax%22%3A" + miX + "%2C%22" + "ymax%22%3A" + miY + "%2C%22" + "spatialReference%22%3A%7B%22wkid%22%3A32161%7D%7D&imageDisplay=1920%2C304%2C96&geometryType=esriGeometryPoint&sr=32161&layers=all%3A0&callback=dojo.io.script.jsonp_dojoIoScript6._jsonpCallback"; var json = new WebClient().DownloadString(url); var points = new JavaScriptSerializer().Deserialize <Object>(json.Replace("dojo.io.script.jsonp_dojoIoScript6._jsonpCallback(", "").Replace(");", "")); JObject j = JObject.FromObject(points); JArray jArray = GetRings(j); Perimeter mainPerimeter = _DatabaseContext.Perimeters.FirstOrDefault(instance => instance.IsMainPerimeter); if (mainPerimeter != null) { mainPerimeter.IsMainPerimeter = false; mainPerimeter.PerimeterName = "Perímetro"; // Foreign Key Color Color blue = _DatabaseContext.Colors.First(instance => instance.ColorID == 1); mainPerimeter.ColorID = blue.ColorID; mainPerimeter.ColorReference.EntityKey = blue.EntityKey; // } Perimeter newPerimeter = new Perimeter(); List <PerimeterPoint> perimeterPoints = new List <PerimeterPoint>(); List <object> perimeterPointsObjects = new List <object>(); // Initialize a context using (JavascriptContext context = new JavascriptContext()) { System.Collections.Generic.Dictionary <string, object> anewpointObj = new Dictionary <string, object>(); using (var streamReader = new StreamReader(new Page().Server.MapPath(@"~/App_Resources\client-scripts\tl\proj4js-compressed.js"))) { context.Run(streamReader.ReadToEnd() + ScriptFileSeparator); } foreach (JToken JToken1 in jArray) { foreach (JToken JToken2 in JToken1) { // Script string script = @" function ConvertToLatLng(x, y) { Proj4js.defs[""EPSG:32161""] = ""+proj=lcc +lat_1=18.43333333333333 +lat_2=18.03333333333333 +lat_0=17.83333333333333 +lon_0=-66.43333333333334 +x_0=200000 +y_0=200000 +ellps=GRS80 +datum=NAD83 +units=m +no_defs""; Proj4js.defs[""EPSG:4326""] = ""+proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs""; var source = new Proj4js.Proj('EPSG:32161'); var dest = new Proj4js.Proj('EPSG:4326'); var anewpoint = new Proj4js.Point(x, y); Proj4js.transform(source, dest, anewpoint); return anewpoint; } var anewpoint = ConvertToLatLng(parseFloat('" + ((JValue)(JToken2[0])).Value.ToString() + "'),parseFloat('" + ((JValue)(JToken2[1])).Value.ToString() + "')); "; // Running the script context.Run(script); // Getting a parameter anewpointObj = (System.Collections.Generic.Dictionary <string, object>)context.GetParameter("anewpoint"); PerimeterPoint perimeterPoint = new PerimeterPoint(); perimeterPoint.Y = Convert.ToDecimal(anewpointObj["y"]); perimeterPoint.X = Convert.ToDecimal(anewpointObj["x"]); perimeterPoint.PerimeterID = newPerimeter.PerimeterID; perimeterPoint.PerimeterReference.EntityKey = newPerimeter.EntityKey; newPerimeter.PerimeterPoints.Add(perimeterPoint); var perimeterPointObject = new { perimeterPoint.PerimeterID, perimeterPoint.PerimeterPointID, perimeterPoint.X, perimeterPoint.Y }; perimeterPointsObjects.Add(perimeterPointObject); } } } newPerimeter.IsMainPerimeter = true; newPerimeter.PerimeterName = "Perímetro Principal"; newPerimeter.CreatedDate = DateTime.Now; newPerimeter.CreatorUserID = new Guid(userID); newPerimeter.EditedDate = DateTime.Now; newPerimeter.EditorUserID = new Guid(userID); // Foreign Key Project newPerimeter.ProjectID = project.ProjectID; newPerimeter.ProjectReference.EntityKey = project.EntityKey; // // Foreign Key Color Color red = _DatabaseContext.Colors.First(instance => instance.ColorID == 2); newPerimeter.ColorID = red.ColorID; newPerimeter.ColorReference.EntityKey = red.EntityKey; // _DatabaseContext.Perimeters.AddObject(newPerimeter); _DatabaseContext.SaveChanges(); var perimeterObject = new { newPerimeter.ColorID, newPerimeter.Color.Code, newPerimeter.Color.ColorDesc, newPerimeter.IsMainPerimeter, newPerimeter.PerimeterID, newPerimeter.PerimeterName, PerimeterPoints = perimeterPointsObjects, newPerimeter.ProjectID }; return(perimeterObject); } }
public static object GetProjectObject(Project project) { ProjectInfoTreeLocation projectInfoTreeLocation = project.ProjectInfoTreeLocations.FirstOrDefault(); ProjectInfo projectInfo = project.ProjectInfoes.FirstOrDefault(); if (projectInfoTreeLocation == null) { projectInfoTreeLocation = new ProjectInfoTreeLocation(); projectInfoTreeLocation.X = 0; projectInfoTreeLocation.Y = 0; projectInfoTreeLocation.Lat = 0; projectInfoTreeLocation.Lon = 0; projectInfoTreeLocation.Acres = 0; projectInfoTreeLocation.Lots1 = 0; projectInfoTreeLocation.Parkings = 0; projectInfoTreeLocation.DistanceBetweenTrees = 10; projectInfoTreeLocation.ProjectID = project.ProjectID; projectInfoTreeLocation.ProjectReference.EntityKey = project.EntityKey; new ProjectInfoTreeLocationBLL().CreateNewProjectInfoTreeLocation(projectInfoTreeLocation); } string zipCode = null; if (string.IsNullOrWhiteSpace(projectInfo.ZipCode)) { } else if (projectInfo.ZipCode.Length == 5) { zipCode = projectInfo.ZipCode; } else if (projectInfo.ZipCode.Length == 9) { zipCode = projectInfo.ZipCode.Substring(0, 5) + "-" + projectInfo.ZipCode.Substring(5, 4); } return(new { projectInfo.ProjectName, projectInfoTreeLocation.ProjectID, Acres = projectInfoTreeLocation.Acres.ToString(), DistanceBetweenTrees = projectInfoTreeLocation.DistanceBetweenTrees.ToString(), projectInfoTreeLocation.Lat, projectInfoTreeLocation.Lon, Lots = projectInfoTreeLocation.Lots1.ToString(), Parkings = projectInfoTreeLocation.Parkings.ToString(), projectInfoTreeLocation.X, projectInfoTreeLocation.Y, projectInfo.City.CityName, projectInfo.City.CityID, projectInfo.Client, CityX = projectInfo.City.X, CityY = projectInfo.City.Y, CityLat = projectInfo.City.Lat, CityLon = projectInfo.City.Lon, ZipCode = zipCode, projectInfo.Comments, projectInfo.Description, projectInfo.Address1, projectInfo.Address2, projectInfo.State, Perimeters = project.Perimeters.Select(i => new { PerimeterID = i.PerimeterID, ColorID = i.ColorID, Code = i.Color.Code, ColorDesc = i.Color.ColorDesc, PerimeterName = i.PerimeterName, PerimeterPoints = i.PerimeterPoints.Select(e => new { PerimeterPointID = e.PerimeterPointID, X = e.X, Y = e.Y }) }), Trees = project.Project_Organisms.Select(i => ProjectOrganismModel.GetProjectOrganismObject(i.TreeDetails.First()) // i.TreeDetails.First().ActionProposed.ActionProposedDesc, // i.TreeDetails.First().ActionProposed.ActionProposedID, // i.TreeDetails.First().ActionProposed.Color.ColorDesc, // i.TreeDetails.First().ActionProposed.Color.ColorID, // i.TreeDetails.First().ActionProposed.Color.Code, // i.TreeDetails.First().Commentary, // i.TreeDetails.First().Condition.ConditionDesc, // i.TreeDetails.First().Condition.ConditionID, // i.TreeDetails.First().CreatedDate, // i.TreeDetails.First().CreatorUserID, // i.TreeDetails.First().Dap, // i.TreeDetails.First().Dap_Counter, //// Daps,//jsonSerialiser.Serialize(treeDetail.Daps.ToList()), // i.TreeDetails.First().EditedDate, // i.TreeDetails.First().EditorUserID, // i.TreeDetails.First().Height, // i.TreeDetails.First().Lat, // i.TreeDetails.First().Lon, // i.TreeDetails.First().X, // i.TreeDetails.First().Y, // i.TreeDetails.First().Number, // i.TreeDetails.First().ProjectOrganismID, // i.TreeDetails.First().Project_Organisms.ProjectID, // i.TreeDetails.First().Project_Organisms.OrganismID, // i.TreeDetails.First().Project_Organisms.Organism.CommonName.CommonNameDesc, // i.TreeDetails.First().Project_Organisms.Organism.CommonName.CommonNameID, // i.TreeDetails.First().Project_Organisms.Organism.ScientificName.ScientificNameDesc, // i.TreeDetails.First().Project_Organisms.Organism.ScientificName.ScientificNameID, // i.TreeDetails.First().TreeDetailsID, // i.TreeDetails.First().Varas // } ) }); }
/// <summary> /// Deprecated Method for adding a new object to the ProjectInfoTreeLocations EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToProjectInfoTreeLocations(ProjectInfoTreeLocation projectInfoTreeLocation) { base.AddObject("ProjectInfoTreeLocations", projectInfoTreeLocation); }
public object Update([FromBody] ProjectModel_Update projectUpdate) { User user = (User)HttpContext.Current.Items["user"]; City city = (City)HttpContext.Current.Items["city"]; List <Group> groups = (List <Group>)HttpContext.Current.Items["groups"]; var project = (Project)HttpContext.Current.Items["project"]; using (DatabaseContext _DatabaseContext = new DatabaseContext()) { // ProjectInfo ProjectInfo projectInfo = _DatabaseContext.ProjectInfoes.First(instance => instance.ProjectID == projectUpdate.ProjectID); projectInfo.ProjectName = projectUpdate.ProjectName; projectInfo.Client = projectUpdate.Client; projectInfo.Address1 = projectUpdate.Address1; projectInfo.Address2 = projectUpdate.Address2; projectInfo.CityID = projectUpdate.CityID; projectInfo.State = projectUpdate.State; projectInfo.ZipCode = !string.IsNullOrWhiteSpace(projectUpdate.ZipCode) ? projectUpdate.ZipCode.Replace("-", "") : null; projectInfo.Description = projectUpdate.Description; projectInfo.Comments = projectUpdate.Comments; projectInfo.EditedDate = DateTime.Now; // // ProjectInfoTreeLocation ProjectInfoTreeLocation projectInfoTreeLocation = _DatabaseContext.ProjectInfoTreeLocations.First(instance => instance.ProjectID == projectUpdate.ProjectID); projectInfoTreeLocation.Acres = projectUpdate.Acres; projectInfoTreeLocation.DistanceBetweenTrees = projectUpdate.DistanceBetweenTrees; projectInfoTreeLocation.Lots1 = projectUpdate.Lots; projectInfoTreeLocation.Parkings = projectUpdate.Parkings; if ((projectUpdate.Lat == null || projectUpdate.Lat == 0) || (projectUpdate.Lon == null || projectUpdate.Lon == 0)) { projectUpdate.Lat = city.Lat; projectUpdate.Lon = city.Lon; } projectInfoTreeLocation.Lat = projectUpdate.Lat; projectInfoTreeLocation.Lon = projectUpdate.Lon; Dictionary <string, object> anewpointObj = Utility.ConvertToStatePlane(projectInfoTreeLocation.Lon.ToString(), projectInfoTreeLocation.Lat.ToString(), @"~/Javascript/"); projectInfoTreeLocation.X = Convert.ToDecimal(anewpointObj["x"]); projectInfoTreeLocation.Y = Convert.ToDecimal(anewpointObj["y"]); // // Project project = _DatabaseContext.Projects.First(instance => instance.ProjectID == project.ProjectID); project.EditedDate = DateTime.Now; project.EditorUserID = user.UserID; // _DatabaseContext.SaveChanges(); } project = new ProjectBLL().GetProjectByProjectID(project.ProjectID); return(ProjectModel.GetProjectObject(project)); }