public bool EtlToShapes()
{
var context = new RuleTestEntities();
try
{
var listForInsert = context.massinserts.Where(x => x.is_valid == 0).ToList();
foreach (var massinsert in listForInsert)
{
var result = ValidateAndInsert(massinsert.shape);
if (result)
{
massinsert.is_valid = 1;
context.SaveChanges();
}
}
}
catch (Exception exc)
{
log.Error(exc);
return false;
}
return true;
}
public ShapeResponse AddShape(ShapeRequest request)
{
var response = new ShapeResponse();
var context = new RuleTestEntities();
try
{
var newShape = new shape();
newShape.name = request.ShapeDto.name;
newShape.coordinates = request.ShapeDto.coordinates;
newShape.area = request.Area;
newShape.date_created = DateTime.Now;
newShape.is_valid = 1;
context.AddObject("shapes", newShape);
context.SaveChanges();
response.ShapeId = newShape.id_shape;
response.Acknowledge = AcknowledgeType.Success;
}
catch (InvalidOperationException exc)
{
log.Error(exc);
response.Message = exc.Message;
response.Acknowledge = AcknowledgeType.Failure;
}
catch (ArgumentNullException exc)
{
log.Error(exc);
response.Message = exc.Message;
response.Acknowledge = AcknowledgeType.Failure;
}
catch (NullReferenceException exc)
{
log.Error(exc);
response.Message = exc.Message;
response.Acknowledge = AcknowledgeType.Failure;
}
catch (OptimisticConcurrencyException exc)
{
log.Error(exc);
response.Message = exc.Message;
response.Acknowledge = AcknowledgeType.Failure;
}
catch (Exception exc)
{
log.Error(exc);
response.Message = exc.Message;
response.Acknowledge = AcknowledgeType.Failure;
}
finally
{
context.Dispose();
}
return(response);
}
public ShapeResponse AddShape(ShapeRequest request)
{
var response = new ShapeResponse();
var context = new RuleTestEntities();
try
{
var newShape = new shape();
newShape.name = request.ShapeDto.name;
newShape.coordinates = request.ShapeDto.coordinates;
newShape.area = request.Area;
newShape.date_created = DateTime.Now;
newShape.is_valid = 1;
context.AddObject("shapes",newShape);
context.SaveChanges();
response.ShapeId = newShape.id_shape;
response.Acknowledge = AcknowledgeType.Success;
}
catch (InvalidOperationException exc)
{
log.Error(exc);
response.Message = exc.Message;
response.Acknowledge = AcknowledgeType.Failure;
}
catch (ArgumentNullException exc)
{
log.Error(exc);
response.Message = exc.Message;
response.Acknowledge = AcknowledgeType.Failure;
}
catch (NullReferenceException exc)
{
log.Error(exc);
response.Message = exc.Message;
response.Acknowledge = AcknowledgeType.Failure;
}
catch (OptimisticConcurrencyException exc)
{
log.Error(exc);
response.Message = exc.Message;
response.Acknowledge = AcknowledgeType.Failure;
}
catch (Exception exc)
{
log.Error(exc);
response.Message = exc.Message;
response.Acknowledge = AcknowledgeType.Failure;
}
finally
{
context.Dispose();
}
return response;
}
/// <summary>
/// Runs the store proceadure to add all the information from the file the database
/// </summary>
/// <returns>result from the SPROC</returns>
public int PostFileInDb()
{
var context = new RuleTestEntities();
try
{
return context.MassUpdate();
}
catch (Exception exc)
{
log.Error(exc);
return 1;
}
}
/// <summary>
/// Runs the store proceadure to add all the information from the file the database
/// </summary>
/// <returns>result from the SPROC</returns>
public int PostFileInDb()
{
var context = new RuleTestEntities();
try
{
return(context.MassUpdate());
}
catch (Exception exc)
{
log.Error(exc);
return(1);
}
}
public bool EtlToShapes()
{
var context = new RuleTestEntities();
try
{
var listForInsert = context.massinserts.Where(x => x.is_valid == 0).ToList();
foreach (var massinsert in listForInsert)
{
var result = ValidateAndInsert(massinsert.shape);
if (result)
{
massinsert.is_valid = 1;
context.SaveChanges();
}
}
}
catch (Exception exc)
{
log.Error(exc);
return(false);
}
return(true);
}
