public Int32 AddProfile(LocationData request)
{
Int32 response = -1;
using (var context = new TICPuppyLoveDbContext())
{
using (var dbTran = context.Database.BeginTransaction())
{
try
{
var oParm = new SqlParameter
{
ParameterName = "@TotalCount",
DbType = DbType.Int32,
Direction = ParameterDirection.Output
};
context.Database.ExecuteSqlCommand(
"EXEC SP_AddUpdateLocation @UserID, @Latitude, @Longitude, @Accuracy, @TimeStamp, @TotalCount OUTPUT",
new SqlParameter("@UserID", request.UserID),
new SqlParameter("@Latitude", request.Latitude),
new SqlParameter("@Longitude", request.Longitude),
new SqlParameter("@Accuracy", request.Accuracy),
new SqlParameter("@TimeStamp", request.Timestamp),
oParm
);
context.SaveChanges();
response = Convert.ToInt32(oParm.Value);
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
throw;
}
}
}
return response;
}
public Int32 DeleteConfigurations(ConfigMultiEntries request)
{
Int32 response = -1;
using (var context = new TICPuppyLoveDbContext())
{
using (var dbContextTransaction = context.Database.BeginTransaction())
{
context.dbTransaction = dbContextTransaction;
ConfigDTO cdto = new ConfigDTO { configs = request.ConfigEntries };
cdto.refConfigEntries = context.GetRefConfigData();
cdto.refConfigEntries = cdto.GetSpecificRefConfigs();
context.Ref_Config.RemoveRange(cdto.refConfigEntries);
response = context.SaveChanges();
// everything good, commit transaction
dbContextTransaction.Commit();
}
}
return response;
}
public Int32 RemoveLocation(LocationData request)
{
Int32 response = -1;
using (var dbEntities = new TICPuppyLoveDbContext())
{
dbEntities.Locations.RemoveRange(
dbEntities.Locations.Where(x => x.UserID == request.UserID));
response = dbEntities.SaveChanges();
}
return response;
}