public static Timelapse UpdateStatus(string code, int userId, TimelapseStatus status)
{
var client = new RestClient(Settings.TimelapseAPIUrl);
var request = new RestRequest("v1/timelapses/" + code + "/status/" + (int)status + "/users/" + userId, Method.POST);
var timelapsedata = client.Execute <Timelapse>(request);
Timelapse timelapse = timelapsedata.Data;
if (timelapsedata == null || timelapsedata.Data == null)
{
return(new Timelapse());
}
return(timelapse);
}
public static bool UpdateStatus(string code, TimelapseStatus status, string tag, string timezone)
{
string query = @"UPDATE [dbo].[Timelapses] " +
"SET [Status]=@Status, [StatusTag]=@StatusTag, [ModifiedDT]=@ModifiedDT " +
"WHERE (Code = '" + code + "')";
try
{
var p1 = new SqlParameter("@Status", (int)status);
var p2 = new SqlParameter("@StatusTag", tag);
var p3 = new SqlParameter("@ModifiedDT", Utils.ConvertFromUtc(DateTime.UtcNow, timezone));
var cmd = new SqlCommand { CommandText = query, CommandType = CommandType.Text };
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
Connection.OpenConnection();
cmd.Connection = Connection.DbConnection;
bool result = (cmd.ExecuteNonQuery() > 0);
Connection.CloseConnection();
cmd.Dispose();
return result;
}
catch (Exception ex)
{
Utils.FileLog("TimelapseDao UpdateStatus(string code, TimelapseStatus status, string tag) " + ex.Message);
return false;
}
finally
{ Connection.CloseConnection(); }
}
public static List<Timelapse> GetListByUserId(int id, TimelapsePrivacy? privacy, TimelapseStatus? status)
{
try
{
string s = (status.HasValue ? " AND Status = " + ((int)status.Value) : "");
string p = (privacy.HasValue ? " AND Privacy = " + ((int)privacy.Value) : "");
string sql = "Select * FROM Timelapses WHERE UserId=@UserId AND IsDeleted=0 " + s + p + " ORDER BY CreatedDT DESC";
var p1 = new SqlParameter("@UserId", id);
var cmd = new SqlCommand { CommandText = sql, CommandType = CommandType.Text };
cmd.Parameters.Add(p1);
cmd.Connection = Connection.DbConnection;
Connection.OpenConnection();
var dr = GetListFromDataReader(cmd.ExecuteReader());
Connection.CloseConnection();
return dr;
}
catch (Exception ex)
{
if (Connection.DbConnection.State == ConnectionState.Closed)
Utils.FileLog("TimelapseDao GetListByUserId(int id) " + ex.Message);
else
Utils.FileLog(string.Format("TimelapseDao GetListByUserId(int id) Id={0}<br />{1}", id, ex.Message));
return new List<Timelapse>();
}
finally
{
Connection.CloseConnection();
}
}
public static Timelapse UpdateStatus(string code, int userId, TimelapseStatus status)
{
var client = new RestClient(Settings.TimelapseAPIUrl);
var request = new RestRequest("v1/timelapses/" + code + "/status/" + (int)status + "/users/" + userId, Method.POST);
var timelapsedata = client.Execute<Timelapse>(request);
Timelapse timelapse = timelapsedata.Data;
if (timelapsedata == null || timelapsedata.Data == null)
return new Timelapse();
return timelapse;
}
