private bool getKDInformation(DBSqlServer sql) { bool res = false; try { sql.SQLScript = "select id from packages where PackageType = 1 and DATEADD(day, 0, DATEDIFF(day, 0, CreateDate)) = @date"; sql.AddParameter("@date", EnumDBDataTypes.EDT_DateTime, DateTime.Now.ToShortDateString()); if (sql.ExecuteScalar() != null) { return(true); } sql.SQLScript = "insert into packages(PackageType, CreateDate) values(1, getdate())"; sql.ExecuteNonQuery(); res = true; } catch (Exception ee) { res = false; Log.Write("getKDInformation " + ee.Message); } return(res); }
public Task Execute(IJobExecutionContext context) { return(Task.Run(() => { try { string apServer, apDatabase; apServer = System.Configuration.ConfigurationManager.AppSettings["ServerName"]; apDatabase = System.Configuration.ConfigurationManager.AppSettings["BaseName"]; DBSqlServer _sql = new DBSqlServer(apServer, apDatabase, null, ""); _sql.Connect("sa", "sasa", false); getKDInformation(_sql); getPlanHospitalization(_sql); } catch (Exception ee) { Log.Write(ee.Message); } })); }