private void LoadFormToObject(RunnerCrawler runnerCrawler)
{
runnerCrawler.description = txtDescription.Text;
runnerCrawler.number_thread = Convert.ToInt32(spinNumberThread.Value);
runnerCrawler.is_find_new = ckFindNewItem.Checked;
runnerCrawler.is_reload_item = ckReloadData.Checked;
runnerCrawler.max_deep = Convert.ToInt32(spinMaxDeep.Value);
runnerCrawler.max_item = Convert.ToInt32(spinMaxItem.Value);
runnerCrawler.max_time_run_crawler = Convert.ToInt32(spimMaxTime.Value);
runnerCrawler.name = txtName.Text;
runnerCrawler.root_link = QT.Entities.Common.GetListXPathFromString(txtRootLink.Text);
runnerCrawler.website_id = Convert.ToInt32(cboWebSite.SelectedValue);
}
private void ParseRunnerCrawler(DataRow dataRow, RunnerCrawler runnerCrawler)
{
runnerCrawler.id = Common.Obj2Int(dataRow["id"]);
runnerCrawler.name = Common.Obj2String(dataRow["name"]);
runnerCrawler.website_id = Common.Obj2Int(dataRow["website_id"]);
runnerCrawler.is_find_new = Common.Obj2Bool(dataRow["is_find_new"]);
runnerCrawler.is_reload_item = Common.Obj2Bool(dataRow["is_reload_item"]);
runnerCrawler.last_end = Common.ObjectToDataTime(dataRow["last_end"]);
runnerCrawler.last_push = Common.ObjectToDataTime(dataRow["last_push"]);
runnerCrawler.max_deep = Common.Obj2Int(dataRow["max_deep"]);
runnerCrawler.max_item = Common.Obj2Int(dataRow["max_item"]);
runnerCrawler.max_time_run_crawler = Common.Obj2Int(dataRow["max_time_run_crawler"]);
runnerCrawler.number_thread = Common.Obj2Int(dataRow["number_thread"]);
runnerCrawler.root_link = QT.Entities.Common.GetListXPathFromString(Common.Obj2String(dataRow["root_link"]));
runnerCrawler.second_sleep_recrawler = Common.Obj2Int(dataRow["second_sleep_recrawler"]);
}
public Entities.RaoVat.RunnerCrawler GetRunnerCrawler(int idSelected)
{
DataTable tbl = this.sqlDb.GetTblData("select * from runner_crawler where id = @id", CommandType.Text, new System.Data.SqlClient.SqlParameter[]
{
SqlDb.CreateParamteterSQL("id", idSelected, SqlDbType.Int)
});
if (tbl != null && tbl.Rows.Count > 0)
{
RunnerCrawler runnerCrawler = new RunnerCrawler();
ParseRunnerCrawler(tbl.Rows[0], runnerCrawler);
return(runnerCrawler);
}
else
{
return(null);
}
}
private void SaveData()
{
try
{
RunnerCrawler runnerCrawler = new RunnerCrawler();
if (Convert.ToInt32(spinId.Value) != 0)
{
runnerCrawler = this.adapterProduct.GetRunnerCrawler(Convert.ToInt32(spinId.Value));
}
LoadFormToObject(runnerCrawler);
if (this.adapterProduct.SaveRunner(runnerCrawler))
{
MessageBox.Show("Saved!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public bool SaveRunner(RunnerCrawler runnerCrawler)
{
SqlParameter[] parameter = new SqlParameter[] {
SqlDb.CreateParamteterSQL("id", runnerCrawler.id, SqlDbType.Int),
SqlDb.CreateParamteterSQL("name", runnerCrawler.name, SqlDbType.NVarChar),
SqlDb.CreateParamteterSQL("description", runnerCrawler.description, SqlDbType.NVarChar),
SqlDb.CreateParamteterSQL("is_find_new", runnerCrawler.is_find_new, SqlDbType.Bit),
SqlDb.CreateParamteterSQL("is_reload_item", runnerCrawler.is_reload_item, SqlDbType.Bit),
SqlDb.CreateParamteterSQL("max_deep", runnerCrawler.max_deep, SqlDbType.Int),
SqlDb.CreateParamteterSQL("max_item", runnerCrawler.max_item, SqlDbType.Int),
SqlDb.CreateParamteterSQL("max_time_run_crawler", runnerCrawler.max_time_run_crawler, SqlDbType.Int),
SqlDb.CreateParamteterSQL("number_thread", runnerCrawler.number_thread, SqlDbType.Int),
SqlDb.CreateParamteterSQL("root_link", Common.ConvertToString(runnerCrawler.root_link), SqlDbType.NVarChar),
SqlDb.CreateParamteterSQL("second_sleep_recrawler", runnerCrawler.second_sleep_recrawler, SqlDbType.Int),
SqlDb.CreateParamteterSQL("website_id", runnerCrawler.website_id, SqlDbType.Int),
SqlDb.CreateParamteterSQL("state", runnerCrawler.state, SqlDbType.Int)
};
if (runnerCrawler.id == 0)
{
this.sqlDb.RunQuery(@"INSERT INTO [dbo].[runner_crawler]
([website_id]
,[root_link]
,[number_thread]
,[second_sleep_recrawler]
,[is_find_new]
,[is_reload_item]
,[max_deep]
,[max_item]
,[description]
,[name]
,[max_time_run_crawler]
,[state]) values
(@website_id
,@root_link
,@number_thread
,@second_sleep_recrawler
,@is_find_new
,@is_reload_item
,@max_deep
,@max_item
,@description
,@name
,@max_time_run_crawler
,@state)", CommandType.Text, parameter);
}
else
{
this.sqlDb.RunQuery(@"
UPDATE [dbo].[runner_crawler]
SET [website_id] = @website_id
,[root_link] = @root_link
,[number_thread] = @number_thread
,[second_sleep_recrawler] = @second_sleep_recrawler
,[is_find_new] = @is_find_new
,[is_reload_item] = @is_reload_item
,[max_deep] = @max_deep
,[max_item] = @max_item
,[description] = @description
,[name] = @name
,[max_time_run_crawler] = @max_time_run_crawler
,[state] = @state
WHERE id = @id", CommandType.Text, parameter);
}
return(true);
}
