public void GetTaskSettingAndGo(int idtask)
{
t = new DataTable();
FTask = new FullTask();
BDAL.OpenConnection();
t = BDAL.SelCurrentTask(idtask);
BDAL.CloseConnection();
FTask.Source = (string)t.Rows[0]["source"];
FTask.Dest = (string)t.Rows[0]["dest"];
FTask.Taskname = (string)t.Rows[0]["task_name"];
FTask.Selday = (string)t.Rows[0]["sel_day"];
FTask.Time = (DateTime)t.Rows[0]["task_time"];
FTask.Nextstart = (DateTime)t.Rows[0]["Next_Start"];
FTask.Timelive = (int)t.Rows[0]["time_live"];
////add 05.04.2017
FTask.Extension = (string)t.Rows[0]["extension"];
FTask.Password = (string)t.Rows[0]["password"];
FTask.Exeption = (string)t.Rows[0]["exeption"];
FTask.Ftp = (int)t.Rows[0]["ftp"];
FBC = new FullBackupClass(FTask);
TimeSpan rangenexttask = FTask.Nextstart - CurrentDateTime;
TMFULL = new System.Timers.Timer();
TMFULL.Interval = Convert.ToInt32(rangenexttask.TotalMilliseconds - 10000);
TMFULL.Elapsed += delegate(object sender2, System.Timers.ElapsedEventArgs e2)
{
TMFULL_Elapsed(sender2, e2, FTask.Nextstart);
};
TMFULL.Enabled = true;
}
public void EditFullTask(FullTask fulltask)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = this.sqlCn;
cmd.CommandText = "edit_full_copy_next";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id_task", SqlDbType.Int).Value = fulltask.Idtask;
cmd.Parameters.Add("@task_name", SqlDbType.NVarChar, 50).Value = fulltask.Taskname;
cmd.Parameters.Add("@source", SqlDbType.NVarChar, 250).Value = fulltask.Source;
cmd.Parameters.Add("@Dest", SqlDbType.NVarChar, 250).Value = fulltask.Dest;
cmd.Parameters.Add("@Sel_day", SqlDbType.NVarChar, 50).Value = fulltask.Selday;
cmd.Parameters.Add("@task_time", SqlDbType.Time).Value = fulltask.Time.ToShortTimeString();
cmd.Parameters.Add("@next_start", SqlDbType.DateTime).Value = fulltask.Nextstart;
cmd.Parameters.Add("@time_live", SqlDbType.Int).Value = fulltask.Timelive;
cmd.Parameters.Add("@extension", SqlDbType.NVarChar, 50).Value = fulltask.Extension;
cmd.Parameters.Add("@password", SqlDbType.NVarChar, 50).Value = fulltask.Password;
cmd.Parameters.Add("@exeption", SqlDbType.NVarChar, 1000).Value = fulltask.Exeption;
cmd.Parameters.Add("@ftp", SqlDbType.Int).Value = fulltask.Ftp;
cmd.Parameters.Add("@shadow", SqlDbType.Int).Value = fulltask.Shadow;
cmd.ExecuteNonQuery();
}
}
public FullBackupClass(FullTask ftask)
{
BDAL = new BackuperDAL();
FTask = new FullTask();
FTask = ftask;
}
