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; }