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