public static bool GetCheckUser(string UserCode, string UserPass) { string sSql = @""; sSql += " SELECT COUNT(*) "; sSql += " FROM USER_MST"; sSql += " WHERE USER_CODE = '" + UserCode + "'"; sSql += " AND PASSWORD = '******'"; DataSet ds; using (var db = new MSSQLDB()) { ds = db.Query(sSql); if (ds.Tables[0].Rows[0][0].ToString() == "0") { return(false); } else { return(true); } } return(false); }
public static DataSet GetSearchReg(string Search_name, string Search_class) { string sSql = @""; sSql += " SELECT STOCK_CODE, STOCK_NAME, STOCK_CLASS1, STOCK_CLASS2, STOCK_REMARK "; sSql += " FROM STOCK_CLASS"; sSql += " WHERE 1 = 1 "; if (string.IsNullOrEmpty(Search_name) && string.IsNullOrEmpty(Search_class)) { sSql += " AND 1 = 2 "; } else { sSql += " AND ( STOCK_CODE LIKE '%" + Search_name + "%'" + " OR STOCK_NAME LIKE '%" + Search_name + "%')"; sSql += " AND ( STOCK_CLASS1 LIKE '%" + Search_class + "%'" + " OR STOCK_CLASS2 LIKE '%" + Search_class + "%')"; } sSql += " ORDER BY STOCK_NAME"; DataSet user; using (var db = new MSSQLDB()) { user = db.Query(sSql); } return(user); }
public void Init() { conection = new MSSQLDB(new DBConfiguration()); _SREP = new StudentRepository(conection); _encryptor = new Encryptor(); handler = new StudentQueryHandler(_SREP); var db = conection.GetCon(); // Create Course course = new Course(Guid.NewGuid(), "LTP5"); var sql = "INSERT INTO [Course] ([Id], [Name]) VALUES (@Id, @Name)"; db.Execute(sql, param: new { Id = course.CourseId, Name = course.Name }); var cpf = "964.377.278-02"; string password = cpf.Replace("-", "").Replace(".", ""); password = _encryptor.Encrypt(password, out string salt); student = new Student(course, DateTime.Now, "Abmael", "Araujo", cpf, "*****@*****.**", "(86) 2802-4826", "M", "Brasil", "Araguaina", "Centro", password, salt); _SREP.Create(student); commandGetById = new StudentInputGetById() { StudentId = student.Id }; commandList = new StudentInputList(); commandGetByCPF = new StudentInputGetByCPF() { StudentCPF = student.CPF.Number }; }
public JournalController(MSSQLDB db, IConfiguration configuration, IMemoryCache memoryCache, MinioClient minioClient) { _db = db; _configuration = configuration; _memoryCache = memoryCache; _minioClient = minioClient; }
public static async Task InitializeJournalDownloadersAsync(PerformContext context) { context.WriteLine("Looking for journals do download!"); using (var scope = Startup.ServiceProvider.CreateScope()) { MSSQLDB db = scope.ServiceProvider.GetRequiredService<MSSQLDB>(); IConfiguration configuration = scope.ServiceProvider.GetRequiredService<IConfiguration>(); var usersToDownloadJournalsFor = await db.ExecuteListAsync<Shared.Models.User.Profile>( @"SELECT * FROM user_profile WHERE DATEDIFF(MINUTE, GETUTCDATE(), CAST(JSON_VALUE(user_settings, '$.TokenExpiration') as DATETIMEOFFSET)) > 10 AND last_notification_mail IS NULL AND skip_download = 0 AND deleted = 0" ); if (usersToDownloadJournalsFor.Count > 0) { await SSEActivitySender.SendGlobalActivityAsync("Fetching journals from Elite", $"Downloading journals for {usersToDownloadJournalsFor.Count} users"); } foreach (var user in usersToDownloadJournalsFor) { if (RedisJobLock.IsLocked($"JournalDownloader.DownloadJournal.{user.UserIdentifier}")) continue; BackgroundJob.Schedule(() => JournalDownloader.DownloadJournalAsync(user.UserIdentifier, null), TimeSpan.Zero); } } context.WriteLine("All done!"); }
public static bool SetRegDelete(string Stock_Code, string User_ID) { string sSql = @""; sSql += " DELETE FROM USER_STOCK "; sSql += " WHERE STOCK_CODE = '" + Stock_Code + "'"; sSql += " AND USER_ID = " + User_ID; int Result; using (var db = new MSSQLDB()) { Result = db.Execute(sSql); } if (Result > 0) { return(true); } else { return(false); } }
public static DataSet GetSearchData2( string Search_name, string Search_class, string Search_per, string Search_gap , string Search_sa_rate, string Search_bp_rate, string Search_np_rate , string List_Type, string User_ID ) { string sSql = @""; sSql += " SELECT A.STOCK_CODE, A.STOCK_NAME, STOCK_URL, TOTAL_AMT, SALES_AMT, BIZ_PROFIT, NET_PROFIT, PER, EST_PER, BIZ_PER, STOCK_PRICE, NAVER_PRICE, "; sSql += " CAL_PSR, CAL_POR, CAL_PER, BIZ_RATE, NET_RATE, "; sSql += " SA_Y3, SA_Y2, SA_Y1, SA_Y0, BP_Y3, BP_Y2, BP_Y1, BP_Y0, NP_Y3, NP_Y2, NP_Y1, NP_Y0, "; sSql += " SA_RATE, BP_RATE, NP_RATE, "; sSql += " B.STOCK_REMARK, ISNULL(LEN(B.STOCK_REMARK),0) as REMARK_LEN "; sSql += " FROM STOCK_INFO A"; sSql += " , STOCK_CLASS B"; sSql += " WHERE A.STOCK_CODE = B.STOCK_CODE "; sSql += " AND ( A.STOCK_CODE LIKE '%" + Search_name + "%'" + " OR A.STOCK_NAME LIKE '%" + Search_name + "%')"; sSql += " AND ( A.STOCK_CLASS1 LIKE '%" + Search_class + "%'" + " OR A.STOCK_CLASS2 LIKE '%" + Search_class + "%')"; //User별 if (List_Type == "User") { sSql += " AND A.STOCK_CODE IN ( SELECT C.STOCK_CODE FROM USER_STOCK C WHERE C.USER_ID = " + User_ID + " )"; } if (!string.IsNullOrEmpty(Search_per) && Search_per != "") { sSql += " AND CAL_PER <= " + Search_per; } if (!string.IsNullOrEmpty(Search_gap) && Search_gap != "") { sSql += " AND ( (NAVER_PRICE - STOCK_PRICE) / NAVER_PRICE * 100 >= " + Search_gap + " OR (NAVER_PRICE - STOCK_PRICE) / NAVER_PRICE * 100 <= (" + Search_gap + "*-1) )"; sSql += " AND NAVER_PRICE <> 0 "; } if (!string.IsNullOrEmpty(Search_sa_rate) && Search_sa_rate != "") { sSql += " AND SA_RATE >= " + Search_sa_rate; } if (!string.IsNullOrEmpty(Search_bp_rate) && Search_bp_rate != "") { sSql += " AND BP_RATE >= " + Search_bp_rate; } if (!string.IsNullOrEmpty(Search_np_rate) && Search_np_rate != "") { sSql += " AND NP_RATE >= " + Search_np_rate; } sSql += " ORDER BY TOTAL_AMT DESC"; DataSet user; using (var db = new MSSQLDB()) { user = db.Query(sSql); } return(user); }
public async static Task <bool> UpdateJournalIntegrationDataAsync(MSSQLDB db, long journalId, string integrationKey, IntegrationJournalData integrationJournalData) { return((await db.ExecuteNonQueryAsync( "UPDATE user_journal SET integration_data = JSON_MODIFY(ISNULL(integration_data, JSON_QUERY('{}')), '$.\"" + integrationKey + "\"', JSON_QUERY(@integration_data)) WHERE journal_id = @journal_id", new SqlParameter("journal_id", journalId), new SqlParameter("integration_data", JsonSerializer.Serialize(integrationJournalData)) )) > 0); }
public static DataSet GetSearchData3( string Search_name, string Search_class, string Search_buy_gap, string Search_sell_gap , string List_Type, string User_ID ) { string sSql = @""; sSql += " SELECT A.STOCK_CODE, B.STOCK_NAME, B.STOCK_URL, B.STOCK_CLASS1, B.STOCK_PRICE, B.NAVER_PRICE, "; sSql += " A.BUY_PRICE, A.SELL_PRICE, A.AVG_PRICE, "; sSql += " A.STOCK_REMARK, ISNULL(LEN(A.STOCK_REMARK),0) as REMARK_LEN, "; sSql += " A.BUY_PRICE - B.STOCK_PRICE as BUY_GAP, "; sSql += " ROUND(CASE A.BUY_PRICE WHEN 0 THEN 0 ELSE (A.BUY_PRICE - B.STOCK_PRICE) / A.BUY_PRICE * 100 END, 2) as BUY_GAP_RATE, "; sSql += " A.SELL_PRICE - B.STOCK_PRICE as SELL_GAP, "; sSql += " ROUND(CASE A.SELL_PRICE WHEN 0 THEN 0 ELSE (A.SELL_PRICE - B.STOCK_PRICE) / A.SELL_PRICE * 100 END, 2) as SELL_GAP_RATE, "; sSql += " ROUND(CASE A.AVG_PRICE WHEN 0 THEN 0 ELSE (B.STOCK_PRICE - A.AVG_PRICE) / A.AVG_PRICE * 100 END,2) as AVG_GAP, "; sSql += " ( SELECT COUNT(*) REG_CNT "; sSql += " FROM USER_STOCK C "; sSql += " WHERE C.STOCK_CODE = A.STOCK_CODE ) REG_CNT, "; sSql += " ( SELECT ISNULL(AVG(C.BUY_PRICE),0) BUY_AVG "; sSql += " FROM USER_STOCK C "; sSql += " WHERE C.STOCK_CODE = A.STOCK_CODE AND C.BUY_PRICE > 0 ) BUY_AVG, "; sSql += " ( SELECT ISNULL(AVG(C.SELL_PRICE),0) SELL_PRICE "; sSql += " FROM USER_STOCK C "; sSql += " WHERE C.STOCK_CODE = A.STOCK_CODE AND C.SELL_PRICE > 0 ) SELL_AVG, "; sSql += " ( SELECT ISNULL(AVG(C.AVG_PRICE),0) AVG_AVG "; sSql += " FROM USER_STOCK C "; sSql += " WHERE C.STOCK_CODE = A.STOCK_CODE AND C.AVG_PRICE > 0) AVG_AVG "; sSql += " FROM USER_STOCK A"; sSql += " , STOCK_INFO B"; sSql += " WHERE A.USER_ID = " + User_ID; sSql += " AND B.STOCK_CODE = A.STOCK_CODE "; sSql += " AND ( B.STOCK_CODE LIKE '%" + Search_name + "%'" + " OR B.STOCK_NAME LIKE '%" + Search_name + "%')"; sSql += " AND ( B.STOCK_CLASS1 LIKE '%" + Search_class + "%'" + " OR B.STOCK_CLASS2 LIKE '%" + Search_class + "%')"; if (!string.IsNullOrEmpty(Search_buy_gap) && Search_buy_gap != "") { sSql += " AND (A.BUY_PRICE - B.STOCK_PRICE) / A.BUY_PRICE * 100 <= " + Search_buy_gap; sSql += " AND A.BUY_PRICE <> 0 "; } if (!string.IsNullOrEmpty(Search_sell_gap) && Search_sell_gap != "") { sSql += " AND (A.SELL_PRICE - B.STOCK_PRICE) / A.SELL_PRICE * 100 >= " + Search_sell_gap; sSql += " AND A.SELL_PRICE <> 0 "; } sSql += " ORDER BY B.TOTAL_AMT DESC"; DataSet user; using (var db = new MSSQLDB()) { user = db.Query(sSql); } return(user); }
public static async Task SendLoginNotification(MSSQLDB db, IConfiguration configuration, Profile user) { var email = @"Hi there! This is an automated email, since you have logged in to Journal Limpet at least once. I'm sorry that I have to send you this email, but we need you to log in to Journal Limpet <https://journal-limpet.com> again. .. at least if you want us to be able to continue: - Storing your Elite: Dangerous journals - Sync progress with other applications And if you don't want us to sync your account any longer, we'll delete your account after 6 months from your last fetched journal. This is the only email we will ever send you (every time that you need to login) Regards, NoLifeKing85 Journal Limpet"; var htmlEmail = @"<html> <head></head> <body> Hi there!<br /> <br /> This is an automated email, since you have logged in to <b>Journal Limpet</b> at least once.<br /> <br /> I'm sorry that I have to send you this email, but we need you to log in to <a href=""https://journal-limpet.com/Login"" target=""_blank"">Journal Limpet</a> again.<br /> <br /> .. at least if you want us to be able to continue:<br /> - Storing your Elite: Dangerous journals<br /> - Sync progress with other applications<br /> <br /> And if you don't want us to sync your account any longer, we'll delete your account after 6 months from your last fetched journal.<br /> <br /> This is the only email we will ever send you (every time that you need to login)<br /> <br /> Regards,<br /> NoLifeKing85<br /> <a href=""https://journal-limpet.com/"" target=""_blank"">Journal Limpet</a> </body></html>"; var sendgridClient = new SendGridClient(configuration["SendGrid:ApiKey"]); var mail = MailHelper.CreateSingleEmail( new EmailAddress("*****@*****.**", "Journal Limpet"), new EmailAddress(user.NotificationEmail), "Login needed for further journal storage", email, htmlEmail ); await sendgridClient.SendEmailAsync(mail); await db.ExecuteNonQueryAsync("UPDATE user_profile SET last_notification_mail = GETUTCDATE() WHERE user_identifier = @userIdentifier", new SqlParameter("@userIdentifier", user.UserIdentifier) ); }
public static async Task <IndexStatsModel> GetIndexStatsAsync(MSSQLDB _db) { return(await _db.ExecuteSingleRowAsync <IndexStatsModel>(@"SELECT COUNT_BIG(DISTINCT up.user_identifier) user_count, COUNT_BIG(journal_id) journal_count, SUM(last_processed_line_number) total_number_of_lines FROM user_profile up LEFT JOIN user_journal uj ON up.user_identifier = uj.user_identifier AND uj.last_processed_line_number > 0 WHERE up.deleted = 0")); }
protected void Page_Load(object sender, EventArgs e) { MSSQLDB mydb = new MSSQLDB(@"DESKTOP-UQ6D8UK\SQLEXPRESS", "PW", "admintest", "adminTest"); if (mydb.Status) { mydb.ReadData("SELECT TOP 2 A_ID, A_DATE, A_NAME, A_DESCRIPTION, A_ANCHORLINK FROM PW_ARTICLE_TBL ORDER BY A_ID DESC"); switch (mydb.DTTable.Rows.Count) { case 2: des1.InnerHtml = mydb.DTTable.Rows[0]["A_DESCRIPTION"].ToString() + "<span class =\"desID\">文章ID: " + mydb.DTTable.Rows[0]["A_ID"].ToString() + "</span>"; des2.InnerHtml = mydb.DTTable.Rows[1]["A_DESCRIPTION"].ToString() + "<span class =\"desID\">文章ID: " + mydb.DTTable.Rows[1]["A_ID"].ToString() + "</span>"; des1AnchorLink.HRef = mydb.DTTable.Rows[0]["A_ANCHORLINK"].ToString(); des2AnchorLink.HRef = mydb.DTTable.Rows[1]["A_ANCHORLINK"].ToString(); break; case 1: des1.InnerHtml = mydb.DTTable.Rows[0]["A_DESCRIPTION"].ToString() + "<span class =\"desID\">文章ID: " + mydb.DTTable.Rows[0]["A_ID"].ToString() + "</span>"; des1AnchorLink.HRef = mydb.DTTable.Rows[0]["A_ANCHORLINK"].ToString(); des2.InnerHtml = "暂时只有一篇文章"; break; default: des1.InnerHtml = "暂时没有文章"; des2.InnerHtml = "暂时没有文章"; break; } mydb.ReadData("SELECT A_ABOUT FROM PW_ABOUT_TBL ORDER BY Count DESC"); if (mydb.DTTable.Rows.Count > 0) { for (int i = 0; i < mydb.DTTable.Rows.Count; i++) { if (i == 0) { about.InnerHtml += "<span class=\"badge\">" + mydb.DTTable.Rows[i]["A_ABOUT"].ToString() + "</span>\r\n"; } else { about.InnerHtml += " " + "<span class=\"badge\">" + mydb.DTTable.Rows[i]["A_ABOUT"].ToString() + "</span>\r\n"; } } } else { about.InnerText = "暂时没有相关标签"; } } else { des1.InnerHtml = "数据库连接失败,无法读取"; des2.InnerHtml = "数据库连接失败,无法读取"; } }
public void Init() { conection = new MSSQLDB(new DBConfiguration()); _DREP = new DisciplineRepository(conection); _PREPProfessorContext = new Infra.ProfessorContext.ProfessorRepository(conection); _PREPCourseContext = new Infra.CourseContext.ProfessorRepository(conection); _encryptor = new Encryptor(); handler = new DisciplineCommandHandler(_DREP, _PREPCourseContext); var db = conection.GetCon(); var cpf = "357.034.413-40"; string password = cpf.Replace("-", "").Replace(".", ""); password = _encryptor.Encrypt(password, out string salt); professor = new Entities.ProfessorContext.Entities.Professor("Lívia", "Emanuelly Elisa", cpf, "*****@*****.**", "(21) 2682-8370", EDegree.Master, password, salt); _PREPProfessorContext.Create(professor); // Create Course course = new Course(Guid.NewGuid()); var sql = "INSERT INTO [Course] ([Id], [Name]) VALUES (@Id, 'LTP6')"; db.Execute(sql, param: new { Id = course.Id }); commandRegister = new DisciplineInputRegister() { Name = "Filosofia", CourseId = course.Id, ProfessorId = professor.Id, WeeklyWorkload = 1, Period = 1 }; discipline = new Discipline("Filosofia", course, new Professor(professor.Id), 1, 1, 0); _DREP.Create(discipline); commandUpdate = new DisciplineInputUpdate() { DisciplineId = discipline.Id, Name = "Matematica", CourseId = course.Id, ProfessorId = professor.Id, WeeklyWorkload = 2, Period = 2 }; commandDelete = new DisciplineInputDelete() { DisciplineId = discipline.Id }; }
public void Init() { conection = new MSSQLDB(new DBConfiguration()); _SREP = new StudentRepository(conection); _encryptor = new Encryptor(); handler = new StudentCommandHandler(_SREP, _encryptor); var db = conection.GetCon(); // Create Course course = new Course(Guid.NewGuid(), "LTP5"); var sql = "INSERT INTO [Course] ([Id], [Name]) VALUES (@Id, @Name)"; db.Execute(sql, param: new { Id = course.CourseId, Name = course.Name }); var cpf = "964.377.278-02"; string password = cpf.Replace("-", "").Replace(".", ""); password = _encryptor.Encrypt(password, out string salt); student = new Student(course, DateTime.Now, "Abmael", "Araujo", cpf, "*****@*****.**", "(86) 2802-4826", "M", "Brasil", "Araguaina", "Centro", password, salt); _SREP.Create(student); commandRegister = new StudentInputRegister() { CourseId = course.CourseId, Birthdate = DateTime.Now, FirstName = "Ester", LastName = "Emily Oliveira", CPF = "494.035.320-68", Email = "*****@*****.**", Phone = "(45) 2509-8770", Gender = "M", Country = "Brasil", City = "Araguaina", Address = "Centro" }; commandUpdate = new StudentInputUpdate() { CourseId = course.CourseId, Birthdate = DateTime.Now, FirstName = "Iago", LastName = "Bernardo Nunes", Email = "*****@*****.**", Phone = "(65) 3544-9294", Gender = "M", Country = "França", City = "Budapeste", Address = "Norte", StudentId = student.Id }; }
private static async Task ExecuteBatchInsert(List <string> batchInserts, MSSQLDB db) { var batch = $@"BEGIN TRANSACTION; INSERT INTO EliteSystem (SystemAddress, StarSystem, StarPos) VALUES {string.Join(",\n", batchInserts)} COMMIT TRANSACTION"; await db.ExecuteNonQueryAsync(batch); batchInserts.Clear(); }
public static DataSet AvgKospi() { string YD_POINT; // 어제 날짜 지수 가져오기 string sSql = @""; sSql += " SELECT MAX(INDEX_POINT) INDEX_POINT "; sSql += " FROM INDEX_POINT A "; sSql += " WHERE STOCK_MARKET = 'KOSPI'"; sSql += " AND INDEX_DATE = ( "; sSql += " SELECT MAX(INDEX_DATE) INDEX_DATE "; sSql += " FROM INDEX_POINT A "; sSql += " WHERE STOCK_MARKET = 'KOSPI'"; sSql += " AND INDEX_DATE < "; sSql += " ( SELECT TOP 1 INDEX_DATE"; sSql += " FROM INDEX_POINT"; sSql += " WHERE STOCK_MARKET = 'KOSPI'"; sSql += " AND INDEX_DATE > GETDATE() - 10 "; sSql += " ORDER BY INDEX_DATE DESC "; sSql += " ) "; sSql += " ) "; DataSet user; using (var db = new MSSQLDB()) { user = db.Query(sSql); } YD_POINT = user.Tables[0].Rows[0][0].ToString(); //평균 지수 가져오기 sSql = @""; sSql += " SELECT ROUND(AVG(INDEX_POINT),2) AVG_POINT, MIN(CONVERT(CHAR(10), INDEX_DATE, 111)) INDEX_DATE "; sSql += " FROM ( "; sSql += " SELECT TOP 60 ISNULL(INDEX_POINT,0) INDEX_POINT, INDEX_DATE"; sSql += " FROM INDEX_POINT"; sSql += " WHERE STOCK_MARKET = 'KOSPI'"; sSql += " AND INDEX_DATE > GETDATE() - 120 "; sSql += " ORDER BY INDEX_DATE DESC "; sSql += " ) A"; sSql += " UNION ALL"; sSql += " SELECT " + YD_POINT + " AVG_POINT, CONVERT(CHAR(10),GETDATE(),111) INDEX_DATE "; using (var db = new MSSQLDB()) { user = db.Query(sSql); } return(user); }
protected override void OnStart(string[] args) { /************* * Carrega configurações */ System.Reflection.Assembly asm = System.Reflection.Assembly.GetAssembly(this.GetType()); basePath = Path.GetDirectoryName(asm.Location); localConfig = new LocalConfig(); localConfig.LoadConfig(); if ((localConfig.SqlServer == null) || (localConfig.SqlServer.Trim() == "")) { StopOnError("Parâmetro 'sqlserver' não localizado no arquivo de configuração 'server.conf'", null); } if ((localConfig.SqlDb == null) || (localConfig.SqlDb.Trim() == "")) { StopOnError("Parâmetro 'sqldb' não localizado no arquivo de configuração 'server.conf'", null); } if ((localConfig.SqlUsername == null) || (localConfig.SqlUsername.Trim() == "")) { StopOnError("Parâmetro 'sqlusername' não localizado no arquivo de configuração 'server.conf'", null); } if ((localConfig.SqlPassword == null) || (localConfig.SqlPassword.Trim() == "")) { StopOnError("Parâmetro 'sqlpassword' não localizado no arquivo de configuração 'server.conf'", null); } try { MSSQLDB db = new MSSQLDB(localConfig.SqlServer, localConfig.SqlDb, localConfig.SqlUsername, localConfig.SqlPassword); db.openDB(); db.closeDB(); } catch (Exception ex) { StopOnError("Falha ao acessar o banco de dados", ex); } /************* * Inicia timer que processa os arquivos */ inboundTimer = new Timer(new TimerCallback(InboundTimer), null, 1000, 900000); outboundTimer = new Timer(new TimerCallback(OutboundTimer), null, 1000, 900000); }
public static async Task SendStatsActivityAsync(MSSQLDB _db) { try { var stats = await SharedSettings.GetIndexStatsAsync(_db); await SharedSettings.RedisPubsubSubscriber.PublishAsync($"stats-activity", JsonSerializer.Serialize(stats), CommandFlags.FireAndForget); } catch { // It is better is we don't send stats, instead of possibly sending the wrong one } }
protected void Page_Load(object sender, EventArgs e) { A_DATE.Value = DateTime.Now.ToString(); MSSQLDB mydb = new MSSQLDB(@"DESKTOP-UQ6D8UK\SQLEXPRESS", "PW", "admintest", "adminTest"); if (mydb.Status) { mydb.ReadData("SELECT TOP 1 A_ID FROM PW_ARTICLE_TBL ORDER BY A_ID DESC;"); string tempStr = GetRepeatNumberStr((Convert.ToInt32(mydb.DTTable.Rows[0]["A_ID"]) + 1), 0, 8); A_ID.Value = tempStr; } else { } }
static public void sendEmail(MSSQLDB db, String Subject, List <String> to, String replyTo, String body, Boolean isHTML, List <Attachment> atts) { using (ServerDBConfig conf = new ServerDBConfig(db.conn)) { MailMessage mail = new MailMessage(); mail.From = new MailAddress(conf.GetItem("mailFrom")); foreach (String t in to) { mail.To.Add(new MailAddress(t)); } mail.Subject = Subject; mail.IsBodyHtml = isHTML; mail.Body = body; if (replyTo != null) { try { mail.ReplyTo = new MailAddress(replyTo); } catch { } } if ((atts != null) && (atts.Count > 0)) { foreach (Attachment a in atts) { mail.Attachments.Add(a); } } SmtpClient client = new SmtpClient(); client.Host = conf.GetItem("smtpServer"); client.Port = 587; client.EnableSsl = true; client.Credentials = new System.Net.NetworkCredential(conf.GetItem("username"), conf.GetItem("password")); System.Net.ServicePointManager.ServerCertificateValidationCallback = new System.Net.Security.RemoteCertificateValidationCallback(RemoteCertificateValidationCallback); client.Send(mail); client = null; mail = null; } }
public static int SetUser(string UserCode, string PassWord, string UserAlias, string UserPhone, string UserEmail) { string sSql = @""; sSql += " INSERT INTO USER_MST ( USER_CODE, PASSWORD, USER_ALIAS, USER_PHONE, USER_EMAIL, USER_STATUS )"; sSql += " VALUES ( '" + UserCode + "', '" + PassWord + "', '" + UserAlias + "', '" + UserPhone + "', '" + UserEmail + "', 'Y')"; int result; using (var db = new MSSQLDB()) { result = db.Execute(sSql); } return(result); }
public static int SetStockDelete(string Stock_Code) { string sSql = @""; sSql += " DELETE FROM STOCK_INFO "; sSql += " WHERE STOCK_CODE = '" + Stock_Code + "'"; int Result; using (var db = new MSSQLDB()) { Result = db.Execute(sSql); } return(Result); }
public static DataSet GetUser(string UserCode) { string sSql = @""; sSql += " SELECT USER_ID, USER_ALIAS, USER_STATUS "; sSql += " FROM USER_MST"; sSql += " WHERE USER_CODE = '" + UserCode + "'"; DataSet ds; using (var db = new MSSQLDB()) { ds = db.Query(sSql); } return(ds); }
public static int SetRemarkSave(string Stock_Code, string Stock_Remark) { string sSql = @""; sSql += " UPDATE STOCK_CLASS "; sSql += " SET STOCK_REMARK = '" + Stock_Remark + "'"; sSql += " WHERE STOCK_CODE = '" + Stock_Code + "'"; int Result; using (var db = new MSSQLDB()) { Result = db.Execute(sSql); } return(Result); }
public static DataSet GetKospi() { string sSql = @""; sSql += " SELECT TOP 300 INDEX_DATE, ISNULL(INDEX_POINT,0) INDEX_POINT, ISNULL(INDEX_START,0) INDEX_START, ISNULL(INDEX_HIGH,0) INDEX_HIGH, ISNULL(INDEX_LOW,0) INDEX_LOW"; sSql += " FROM INDEX_POINT"; sSql += " WHERE STOCK_MARKET = 'KOSPI'"; sSql += " AND INDEX_DATE > GETDATE() - 600 "; sSql += " ORDER BY INDEX_DATE "; DataSet user; using (var db = new MSSQLDB()) { user = db.Query(sSql); } return(user); }
public static bool SetSavePrice(string Stock_Code, string User_ID, string Buy_Price, string Sell_Price, string Avg_Price) { string sSql = @""; sSql += " UPDATE USER_STOCK "; sSql += " SET BUY_PRICE = " + Buy_Price; sSql += " , SELL_PRICE = " + Sell_Price; sSql += " , AVG_PRICE = " + Avg_Price; sSql += " WHERE STOCK_CODE = '" + Stock_Code + "'"; sSql += " AND USER_ID = " + User_ID; int Result; using (var db = new MSSQLDB()) { Result = db.Execute(sSql); } return(true); }
public static DataSet GetAllData() { string sSql = @""; sSql += " SELECT STOCK_CODE, STOCK_NAME, STOCK_URL, TOTAL_AMT, SALES_AMT, BIZ_PROFIT, NET_PROFIT, PER, EST_PER, BIZ_PER, STOCK_PRICE, NAVER_PRICE, "; sSql += " CAL_PSR, CAL_POR, CAL_PER, BIZ_RATE, NET_RATE, "; sSql += " SA_Y3, SA_Y2, SA_Y1, SA_Y0, BP_Y3, BP_Y2, BP_Y1, BP_Y0, NP_Y3, NP_Y2, NP_Y1, NP_Y0, "; sSql += " SA_RATE, BP_RATE, NP_RATE "; sSql += " FROM STOCK_INFO"; sSql += " ORDER BY TOTAL_AMT DESC"; DataSet user; using (var db = new MSSQLDB()) { user = db.Query(sSql); } return(user); }
public void Init() { conection = new MSSQLDB(new DBConfiguration()); _PREP = new ProfessorRepository(conection); _encryptor = new Encryptor(); handler = new ProfessorQueryHandler(_PREP); var db = conection.GetCon(); var cpf = "357.034.413-40"; string password = cpf.Replace("-", "").Replace(".", ""); password = _encryptor.Encrypt(password, out string salt); professor = new Professor("Lívia", "Emanuelly Elisa", cpf, "*****@*****.**", "(21) 2682-8370", EDegree.Master, password, salt); _PREP.Create(professor); commandGet = new ProfessorInputGet() { ProfessorId = professor.Id }; }
public void Init() { conection = new MSSQLDB(new DBConfiguration()); _PREP = new ProfessorRepository(conection); _encryptor = new Encryptor(); handler = new ProfessorCommandHandler(_PREP, _encryptor); var db = conection.GetCon(); var cpf = "357.034.413-40"; string password = cpf.Replace("-", "").Replace(".", ""); password = _encryptor.Encrypt(password, out string salt); professor = new Professor("Lívia", "Emanuelly Elisa", cpf, "*****@*****.**", "(21) 2682-8370", EDegree.Master, password, salt); _PREP.Create(professor); commandRegister = new ProfessorInputRegister() { FirstName = "Lívia", LastName = "Emanuelly Elisa", CPF = cpf, Email = "*****@*****.**", Phone = "(21) 2682-8370", Degree = EDegree.Master }; commandUpdate = new ProfessorInputUpdate() { ProfessorId = professor.Id, FirstName = "Lívia", LastName = "Emanuelly Elisa", Email = "*****@*****.**", Phone = "(21) 2682-8370", Degree = EDegree.Master }; }
public static bool GetAliasCheck(string UserAlias) { string sSql = @""; sSql += " SELECT COUNT(*) "; sSql += " FROM USER_MST"; sSql += " WHERE USER_ALIAS = '" + UserAlias + "'"; DataSet ds; using (var db = new MSSQLDB()) { ds = db.Query(sSql); } if (ds.Tables[0].Rows[0][0].ToString() == "1") { return(false); } else { return(true); } }