protected string getColor(ActionProposed ap) { using (DatabaseContext _DatabaseContext = new DatabaseContext()) { return(_DatabaseContext.Colors.Where(i => i.ColorID == ap.ColorID).First().Code); } }
public void DeleteActionProposeds(List <int> actionProposedIDsToDelete) { //Validate Input foreach (int actionProposedID in actionProposedIDsToDelete) { if (actionProposedID.IsInvalidKey()) { BusinessLayerHelper.ThrowErrorForInvalidDataKey("ActionProposedID"); } } List <ActionProposed> actionProposedsToBeDeleted = new List <ActionProposed>(); foreach (int actionProposedID in actionProposedIDsToDelete) { ActionProposed actionProposed = new ActionProposed { ActionProposedID = actionProposedID }; _DatabaseContext.ActionProposeds.Attach(actionProposed); _DatabaseContext.ActionProposeds.DeleteObject(actionProposed); actionProposedsToBeDeleted.Add(actionProposed); OnActionProposedDeleting(actionProposed); } int numberOfAffectedRows = _DatabaseContext.SaveChanges(); if (numberOfAffectedRows != actionProposedIDsToDelete.Count) { throw new DataNotUpdatedException("One or more actionProposed records have not been deleted."); } foreach (ActionProposed actionProposedToBeDeleted in actionProposedsToBeDeleted) { OnActionProposedDeleted(actionProposedToBeDeleted); } }
public void DeleteActionProposed(ActionProposed actionProposedToBeDeleted) { //Validate Input if (actionProposedToBeDeleted == null) { throw (new ArgumentNullException("actionProposedToBeDeleted")); } // Validate Primary key value if (actionProposedToBeDeleted.ActionProposedID.IsInvalidKey()) { BusinessLayerHelper.ThrowErrorForInvalidDataKey("ActionProposedID"); } OnActionProposedSaving(actionProposedToBeDeleted); OnActionProposedDeleting(actionProposedToBeDeleted); if (actionProposedToBeDeleted.EntityState == EntityState.Detached) { _DatabaseContext.ActionProposeds.Attach(actionProposedToBeDeleted); } _DatabaseContext.ActionProposeds.DeleteObject(actionProposedToBeDeleted); int numberOfAffectedRows = _DatabaseContext.SaveChanges(); if (numberOfAffectedRows == 0) { throw new DataNotUpdatedException("No ActionProposed deleted!"); } OnActionProposedDeleted(actionProposedToBeDeleted); OnActionProposedSaved(actionProposedToBeDeleted); }
public void UpdateActionProposed(ActionProposed updatedActionProposed) { // Validate Parameters if (updatedActionProposed == null) { throw (new ArgumentNullException("updatedActionProposed")); } // Validate Primary key value if (updatedActionProposed.ActionProposedID.IsInvalidKey()) { BusinessLayerHelper.ThrowErrorForInvalidDataKey("ActionProposedID"); } // Apply business rules OnActionProposedSaving(updatedActionProposed); OnActionProposedUpdating(updatedActionProposed); //attaching and making ready for parsistance if (updatedActionProposed.EntityState == EntityState.Detached) { _DatabaseContext.ActionProposeds.Attach(updatedActionProposed); } _DatabaseContext.ObjectStateManager.ChangeObjectState(updatedActionProposed, System.Data.EntityState.Modified); //this line makes the code un-testable! int numberOfAffectedRows = _DatabaseContext.SaveChanges(); if (numberOfAffectedRows == 0) { throw new DataNotUpdatedException("No actionProposed updated!"); } //Apply business workflow OnActionProposedUpdated(updatedActionProposed); OnActionProposedSaved(updatedActionProposed); }
public virtual int CreateNewActionProposed(ActionProposed newActionProposed) { // Validate Parameters if (newActionProposed == null) { throw (new ArgumentNullException("newActionProposed")); } // Apply business rules OnActionProposedSaving(newActionProposed); OnActionProposedCreating(newActionProposed); _DatabaseContext.ActionProposeds.AddObject(newActionProposed); int numberOfAffectedRows = _DatabaseContext.SaveChanges(); if (numberOfAffectedRows == 0) { throw new DataNotUpdatedException("No actionProposed created!"); } // Apply business workflow OnActionProposedCreated(newActionProposed); OnActionProposedSaved(newActionProposed); return(newActionProposed.ActionProposedID); }
public static bool IsNull(ActionProposed requestedActionProposed, out ActionProposed actionProposed) { bool isNull = (requestedActionProposed == null || requestedActionProposed == new ActionProposed()); actionProposed = isNull ? null : requestedActionProposed; return(isNull); }
public static object GetActionProposedObject(ActionProposed actionProposed) { return((object)new { actionProposed.ActionProposedID, actionProposed.ActionProposedDesc, actionProposed.ColorID, actionProposed.Color.ColorDesc, actionProposed.Color.Code }); }
protected void rblActionProposed_CheckedChanged(object sender, EventArgs e) { RadioButton rb = (RadioButton)sender; int actionProposedID = Convert.ToInt32(rb.ID.Substring(rb.ID.LastIndexOf("_") + 1, rb.ID.Length - rb.ID.LastIndexOf("_") - 1)) + 1; int projectOrganismID = Convert.ToInt32(rb.GroupName.Substring(rb.GroupName.LastIndexOf("_") + 1, rb.GroupName.Length - rb.GroupName.LastIndexOf("_") - 1)); using (DatabaseContext _DatabaseContext = new DatabaseContext()) { TreeDetail treeDetail = _DatabaseContext.TreeDetails.First(instance => instance.ProjectOrganismID == projectOrganismID); ActionProposed actionProposed = _DatabaseContext.ActionProposeds.First(instance => instance.ActionProposedID == actionProposedID); treeDetail.ActionProposedID = actionProposed.ActionProposedID; treeDetail.ActionProposedReference.EntityKey = actionProposed.EntityKey; _DatabaseContext.SaveChanges(); } }
public static void EditTreeActionProposedID(string actionProposedID, string projectOrganismID, string userID) { int actionProposedIDINT = Convert.ToInt32(actionProposedID); int projectOrganismIDINT = Convert.ToInt32(projectOrganismID); using (DatabaseContext _DatabaseContext = new DatabaseContext()) { TreeDetail treeDetail = _DatabaseContext.TreeDetails.First(instance => instance.ProjectOrganismID == projectOrganismIDINT); ActionProposed actionProposed = _DatabaseContext.ActionProposeds.First(instance => instance.ActionProposedID == actionProposedIDINT); treeDetail.ActionProposedID = actionProposed.ActionProposedID; treeDetail.ActionProposedReference.EntityKey = actionProposed.EntityKey; treeDetail.EditedDate = DateTime.Now; treeDetail.EditorUserID = new Guid(userID); _DatabaseContext.SaveChanges(); } }
protected void ddlActionProposedChange_SelectedIndexChanged(object sender, EventArgs e) { int actionProposedChangeID = Convert.ToInt32(ddlActionProposedChange.SelectedValue); using (DatabaseContext _DatabaseContext = new DatabaseContext()) { foreach (GridViewRow row in gridViewTreeDetails.Rows) { // Save the ProjectID value for deletion // First, get the ProjectID for the selected row Int32 treeDetailsID = (Int32)gridViewTreeDetails.DataKeys[row.RowIndex].Value; TreeDetail treeDetail = _DatabaseContext.TreeDetails.First(instance => instance.TreeDetailsID == treeDetailsID); ActionProposed actionProposed = _DatabaseContext.ActionProposeds.First(instance => instance.ActionProposedID == actionProposedChangeID); treeDetail.ActionProposedID = actionProposed.ActionProposedID; treeDetail.ActionProposedReference.EntityKey = actionProposed.EntityKey; _DatabaseContext.SaveChanges(); } } ddlActionProposedChange.SelectedIndex = 0; }
partial void OnActionProposedDeleted(ActionProposed actionProposed);
partial void OnActionProposedSaved(ActionProposed actionProposed);
partial void OnActionProposedCreated(ActionProposed actionProposed);
partial void OnActionProposedSaving(ActionProposed actionProposed);
//------------------------------------------------------------------------------------------------------------------------------------------------------------- public TreeDetail CreateProject_Organism(int varas, decimal height, decimal lat, decimal lon, int[] daps, ActionProposed actionProposed, Condition condition, string commentary, Organism organism, Project project, Eisk.BusinessEntities.User user) { Project_Organisms project_Organism = new Project_Organisms(); project_Organism.CreatorUserID = user.UserID; project_Organism.CreatedDate = DateTime.Now; project_Organism.EditorUserID = user.UserID; project_Organism.EditedDate = DateTime.Now; project_Organism.OrganismID = organism.OrganismID; project_Organism.OrganismReference.EntityKey = organism.EntityKey; project_Organism.ProjectID = project.ProjectID; project_Organism.ProjectReference.EntityKey = project.EntityKey; int project_OrganismID = new Project_OrganismsBLL().CreateNewProject_Organisms(project_Organism); TreeDetail treeDetail = new TreeDetail(); if (varas != 0) // Is Cepa { treeDetail.Dap = 0; treeDetail.Dap_Counter = 0; } else if (daps.Length == 1) // Solo un Dap { treeDetail.Dap = daps[0]; treeDetail.Dap_Counter = 1; } else // Mas de un Dap { double dapTotal = 0; foreach (int dap in daps) { dapTotal += dap; } treeDetail.Dap = Convert.ToDecimal(Math.Round(Math.Sqrt(Math.Pow(dapTotal, 2D) / Convert.ToDouble(daps.Length)) * 100) / 100); treeDetail.Dap_Counter = daps.Length; } treeDetail.Varas = varas; treeDetail.Height = height; treeDetail.Commentary = commentary; List <Project_Organisms> project_Organisms = new Project_OrganismsBLL().GetProject_OrganismsByProjectID(project.ProjectID); Dictionary <string, object> anewpointObj = JavaScriptHelper.ConvertToStatePlane(lon.ToString(), lat.ToString()); treeDetail.Number = project_Organisms.Count; treeDetail.Y = Convert.ToDecimal(anewpointObj["y"]); treeDetail.X = Convert.ToDecimal(anewpointObj["x"]); treeDetail.Lat = Convert.ToDecimal(lat); treeDetail.Lon = Convert.ToDecimal(lon); treeDetail.CreatedDate = DateTime.Now; treeDetail.CreatorUserID = user.UserID; treeDetail.EditedDate = DateTime.Now; treeDetail.EditorUserID = user.UserID; treeDetail.ActionProposedID = actionProposed.ActionProposedID; treeDetail.ActionProposedReference.EntityKey = actionProposed.EntityKey; treeDetail.ConditionID = condition.ConditionID; treeDetail.ConditionReference.EntityKey = condition.EntityKey; treeDetail.ProjectOrganismID = project_Organism.ProjectOrganismID; treeDetail.Project_OrganismsReference.EntityKey = project_Organism.EntityKey; int treeDetailID = new TreeDetailBLL().CreateNewTreeDetail(treeDetail); foreach (decimal dapDecimal in daps) { Dap dap = new Dap(); dap.DapValue = dapDecimal; dap.TreeDetailsID = treeDetailID; dap.TreeDetailReference.EntityKey = treeDetail.EntityKey; new DapBLL().CreateNewDap(dap); } return(treeDetail); }
/// <summary> /// Deprecated Method for adding a new object to the ActionProposeds EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToActionProposeds(ActionProposed actionProposed) { base.AddObject("ActionProposeds", actionProposed); }
partial void OnActionProposedUpdated(ActionProposed actionProposed);