public static bool Update(Timelapse timelapse)
{
string query = @"UPDATE [dbo].[Timelapses] " +
"SET [OauthToken]=@OauthToken,[Title]=@Title, [Privacy]=@Privacy, [SnapsInterval]=@SnapsInterval, [FromDT]=@FromDT, [ToDT]=@ToDT,[DateAlways]=@DateAlways,[TimeAlways]=@TimeAlways,[TzId]=@TzId,[Timezone]=@Timezone, [EnableMD]=@EnableMD, [MDThreshold]=@MDThreshold, [ExcludeDark]=@ExcludeDark, [DarkThreshold]=@DarkThreshold, [IsRecording]=@IsRecording, [FPS]=@FPS, [WatermarkImage]=@WatermarkImage, [WatermarkPosition]=@WatermarkPosition " +
"WHERE (Code = '" + timelapse.Code + "')";
try
{
var p3 = new SqlParameter("@OauthToken", timelapse.OauthToken);
var p4 = new SqlParameter("@Title", timelapse.Title);
var p6 = new SqlParameter("@Privacy", timelapse.Privacy);
var p7 = new SqlParameter("@FromDT", (timelapse.FromDT == null) ? Utils.SQLMinDate : timelapse.FromDT);
var p8 = new SqlParameter("@ToDT", (timelapse.ToDT == null) ? Utils.SQLMinDate : timelapse.ToDT);
var p9 = new SqlParameter("@SnapsInterval", timelapse.SnapsInterval);
var p10 = new SqlParameter("@EnableMD", timelapse.EnableMD);
var p11 = new SqlParameter("@MDThreshold", timelapse.MDThreshold);
var p12 = new SqlParameter("@ExcludeDark", timelapse.ExcludeDark);
var p13 = new SqlParameter("@DarkThreshold", timelapse.DarkThreshold);
var p14 = new SqlParameter("@IsRecording", timelapse.IsRecording);
var p15 = new SqlParameter("@DateAlways", timelapse.DateAlways);
var p16 = new SqlParameter("@TimeAlways", timelapse.TimeAlways);
var p17 = new SqlParameter("@Timezone", timelapse.TimeZone);
var p18 = new SqlParameter("@TzId", timelapse.TzId);
var p19 = new SqlParameter("@FPS", timelapse.FPS);
var p20 = new SqlParameter("@WatermarkImage", (timelapse.WatermarkImage.Equals("-") ? "" : timelapse.WatermarkImage));
var p21 = new SqlParameter("@WatermarkPosition", timelapse.WatermarkPosition);
var list = new[] { p3, p4, p6, p7, p8, p9, p10, p11, p12, p13, p14, p15, p16, p17, p18, p19, p20, p21 };
var cmd = new SqlCommand { CommandText = query, CommandType = CommandType.Text };
cmd.Parameters.AddRange(list);
Connection.OpenConnection();
cmd.Connection = Connection.DbConnection;
bool result = (cmd.ExecuteNonQuery() > 0);
Connection.CloseConnection();
cmd.Dispose();
return result;
}
catch (Exception ex)
{
Utils.FileLog("TimelapseDao Update(Timelapse timelapse) " + ex.Message);
return false;
}
finally
{ Connection.CloseConnection(); }
}