public int InsertUserHeartBeat(UserHeartBeat heartbeat)
{
//context.UserHeartBeats.Add(heartbeat);
SqlParameter[] Param = new SqlParameter[7];
Param[0] = new SqlParameter("@pHeartBeatGUID", SqlDbType.UniqueIdentifier);
Param[0].Value = heartbeat.HeartBeatGUID;
Param[1] = new SqlParameter("@pUserGUID", SqlDbType.UniqueIdentifier);
Param[1].Value = heartbeat.UserGUID;
Param[2] = new SqlParameter("@pLatitude", SqlDbType.Float);
Param[2].Value = (object)heartbeat.Latitude ?? DBNull.Value;
Param[3] = new SqlParameter("@pLongitude", SqlDbType.Float);
Param[3].Value = (object)heartbeat.Longitude ?? DBNull.Value;
Param[4] = new SqlParameter("@pHeartBeatTime", SqlDbType.DateTime);
Param[4].Value = (object)heartbeat.HeartBeatTime ?? DBNull.Value;
Param[5] = new SqlParameter("@pCreateDate", SqlDbType.DateTime);
Param[5].Value = (object)heartbeat.CreateDate ?? DBNull.Value;
Param[6] = new SqlParameter("@pCreateBy", SqlDbType.UniqueIdentifier);
Param[6].Value = (object)heartbeat.CreateBy ?? DBNull.Value;
return context.Database.ExecuteSqlCommand("insert into UserHeartBeats(HeartBeatGUID,UserGUID,Latitude,Longitude,HeartBeatTime,CreateDate,CreateBy)"
+ "values(@pHeartBeatGUID,@pUserGUID,@pLatitude,@pLongitude,@pHeartBeatTime,@pCreateDate,@pCreateBy)", Param);
}
public int PostHeartBeat(HeartBeatRequest HeartBeatRequest, Guid UserGUID)
{
try
{
int result = 0;
IUserRepository _IUserRepository;
_IUserRepository = new UserRepository(new WorkersInMotionDB());
UserHeartBeat _userHeartBeat = new UserHeartBeat();
_userHeartBeat.HeartBeatGUID = Guid.NewGuid();
_userHeartBeat.UserGUID = UserGUID;
_userHeartBeat.Latitude = HeartBeatRequest.latitude;
_userHeartBeat.Longitude = HeartBeatRequest.longitude;
_userHeartBeat.HeartBeatTime = HeartBeatRequest.time;
_userHeartBeat.CreateDate = DateTime.UtcNow;
_userHeartBeat.CreateBy = UserGUID;
result = _IUserRepository.InsertUserHeartBeat(_userHeartBeat);
//result = _IUserRepository.Save();
return result;
}
catch (Exception ex)
{
return 0;
}
}