public void UpdateLocation(MarkMyLocation item)
{
_db.Execute("update MarkMyLocation set UserId=" + item.UserId + ", Latitude=" + item.Latitude
+ ", Longitude=" + item.Longitude + ", PinId=" + item.PinId + ", PinActivatedTime='" + item.PinActivatedTime
+ "', PinningAttempts='" + item.PinningAttempts + "', IsPinActive=" + item.IsPinActive + ", IsValidUser="******", Weather='" + item.Weather + "',PinExpiredTime='" + item.PinExpiredTime + "' where Id=" + item.Id);
}
/*----- Location Manage -----*/
public void AddLocation(MarkMyLocation item)
{
_db.Execute("insert into MarkMyLocation values(null," + item.UserId + "," + item.Latitude + "," + item.Longitude + "," + item.PinId
+ "','" + item.PinActivatedTime + "', '" + item.PinningAttempts + "'," + item.IsPinActive
+ "," + item.IsValidUser + ",'" + item.Weather + "','" + item.PinExpiredTime + "');");
}
