public ActionResult UpdatePoint(PointTO point)
{
//Get Cube
IGCube cube = GeometryFactory.GetCube();
return(Json(new { success = cube.Update(point) }, JsonRequestBehavior.AllowGet));
}
public static void Update(PointTO item)
{
MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[DB_AppSetting]);
MySqlDataAdapter adapter = new MySqlDataAdapter("Core_UpdateCube", connection);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
MySqlParameter paramX = new MySqlParameter("pX", item.X);
paramX.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramX);
MySqlParameter paramY = new MySqlParameter("pY", item.Y);
paramY.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramY);
MySqlParameter paramZ = new MySqlParameter("pZ", item.Z);
paramZ.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramZ);
MySqlParameter paramNodeValue = new MySqlParameter("pNodeValue", item.Value);
paramNodeValue.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramNodeValue);
MySqlParameter paramID = new MySqlParameter("pID", item.ID);
paramID.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramID);
DataTable results = new DataTable();
adapter.Fill(results);
}
public static PointTO MapItem(DataRow row)
{
PointTO item = null;
item = new PointTO();
if (row["X"].GetType() != typeof(DBNull))
{
item.X = Convert.ToInt32(row["X"]);
}
if (row["Y"].GetType() != typeof(DBNull))
{
item.Y = Convert.ToInt32(row["Y"]);
}
if (row["Z"].GetType() != typeof(DBNull))
{
item.Z = Convert.ToInt32(row["Z"]);
}
if (row["NodeValue"].GetType() != typeof(DBNull))
{
item.Value = Convert.ToInt32(row["NodeValue"]);
}
if (row["ID"].GetType() != typeof(DBNull))
{
item.ID = Convert.ToInt32(row["ID"]);
}
return(item);
}
public double SumRegion(PointTO point1, PointTO point2)
{
ICubePersistence persistence = PersistenceFactory.GetCubePersistence();
//Point Validations
ValidatePoint(point1);
//Point Validations
ValidatePoint(point2);
return(persistence.SumRegion(point1, point2));
}
public bool Update(PointTO point)
{
try
{
MySqlDAL.Update(point);
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool Update(PointTO point)
{
ICubePersistence persistence = PersistenceFactory.GetCubePersistence();
//Point Validations
ValidatePoint(point);
//Check Value
if (point.Value < Math.Pow(10, 9) * -1 || point.Value > Math.Pow(10, 9))
{
throw new Exception("Value is not allowed. -10^9 <= W <= 10^9");
}
return(persistence.Update(point));
}
private void ValidatePoint(PointTO point)
{
ICubePersistence persistence = PersistenceFactory.GetCubePersistence();
int dimensions = persistence.GetDimensions();
//Check Boundaries
if (point.X <= 0 || point.Y <= 0 || point.Z <= 0)
{
throw new Exception("Cube is index 1, lower numbers are not allowed for x, y or z");
}
if (point.X > dimensions || point.Y > dimensions || point.Z > dimensions)
{
throw new Exception("Cube limits exceeded");
}
}
public ActionResult SumRegion(int x1, int y1, int z1, int x2, int y2, int z2)
{
//Get Cube
IGCube cube = GeometryFactory.GetCube();
PointTO point1 = new PointTO()
{
X = x1, Y = y1, Z = z1
};
PointTO point2 = new PointTO()
{
X = x2, Y = y2, Z = z2
};
return(Json(new { sum = cube.SumRegion(point1, point2) }, JsonRequestBehavior.AllowGet));
}
public static double SumRegion(PointTO point1, PointTO point2)
{
MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[DB_AppSetting]);
MySqlDataAdapter adapter = new MySqlDataAdapter("Core_SumCubeRegion", connection);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
MySqlParameter paramX = new MySqlParameter("pX1", point1.X);
paramX.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramX);
MySqlParameter paramY = new MySqlParameter("pY1", point1.Y);
paramY.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramY);
MySqlParameter paramZ = new MySqlParameter("pZ1", point1.Z);
paramZ.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramZ);
MySqlParameter paramX1 = new MySqlParameter("pX2", point2.X);
paramX.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramX1);
MySqlParameter paramY1 = new MySqlParameter("pY2", point2.Y);
paramY.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramY1);
MySqlParameter paramZ1 = new MySqlParameter("pZ2", point2.Z);
paramZ.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramZ1);
DataTable results = new DataTable();
adapter.Fill(results);
if (results.Rows.Count > 0)
{
return(Convert.ToDouble(results.Rows[0]["Sum"]));
}
else
{
return(0);
}
}
public static int Create(PointTO item)
{
MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[DB_AppSetting]);
MySqlDataAdapter adapter = new MySqlDataAdapter("Core_CreateCube", connection);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
MySqlParameter paramX = new MySqlParameter("pX", item.X);
paramX.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramX);
MySqlParameter paramY = new MySqlParameter("pY", item.Y);
paramY.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramY);
MySqlParameter paramZ = new MySqlParameter("pZ", item.Z);
paramZ.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramZ);
MySqlParameter paramNodeValue = new MySqlParameter("pNodeValue", item.Value);
paramNodeValue.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramNodeValue);
MySqlParameter paramID = new MySqlParameter("pID", item.ID);
paramID.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramID);
DataTable results = new DataTable();
adapter.Fill(results);
if (results.Rows.Count > 0)
{
return(Convert.ToInt32(results.Rows[0]["ID"]));
}
else
{
throw new Exception("Error creating Cube");
}
}
public static List <PointTO> GetAll()
{
List <PointTO> items = new List <PointTO>();
MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[DB_AppSetting]);
MySqlDataAdapter adapter = new MySqlDataAdapter("Core_GetAllCube", connection);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
DataTable results = new DataTable();
adapter.Fill(results);
foreach (DataRow row in results.Rows)
{
PointTO item = MapItem(row);
items.Add(item);
}
return(items);
}
public double SumRegion(PointTO point1, PointTO point2)
{
return(MySqlDAL.SumRegion(point1, point2));
}
