static void CurrentDomain_UnhandledException(object sender, UnhandledExceptionEventArgs e) { try { GF.closeLoading(); Exception ex = (Exception)e.ExceptionObject; GF.doDebug("********** FATAL UNHANDLED EXCEPTION ERROR : " + Environment.MachineName + " **********"); GF.doDebug(" [" + ex.TargetSite.ToString() + "]"); GF.doDebug(ex.Message); GF.doDebug("\r\n\r\n" + ex.StackTrace); GF.doDebug("\r\n\r\nFile : " + new StackTrace(ex, true).GetFrame(0).GetFileName()); GF.doDebug("\r\n\r\nLine : " + new StackTrace(ex, true).GetFrame(0).GetFileLineNumber()); GF.submitErrorLog(); waitHandle.WaitOne(); /*MessageBox.Show("Whoops! Please contact the developers with the following" + " information:\n\n" + ex.Message + ex.StackTrace, + "Fatal Error", MessageBoxButtons.OK, MessageBoxIcon.Stop);*/ } finally { if (currentProcess != null) { currentProcess.Kill(); } System.Environment.Exit(0); } }
static void Application_ThreadException(object sender, System.Threading.ThreadExceptionEventArgs e) { try { GF.closeLoading(); Exception ex = (Exception)e.Exception; GF.doDebug("********** THREAD FATAL ERROR : " + Environment.MachineName + " **********"); GF.doDebug(" [" + ex.TargetSite.ToString() + "]"); GF.doDebug(ex.Message); GF.doDebug("\r\n\r\n" + ex.StackTrace); GF.doDebug("\r\n\r\nFile : " + new StackTrace(ex, true).GetFrame(0).GetFileName()); GF.doDebug("\r\n\r\nLine : " + new StackTrace(ex, true).GetFrame(0).GetFileLineNumber()); GF.submitErrorLog(); waitHandle.WaitOne(); } finally { if (currentProcess != null) { currentProcess.Kill(); } System.Environment.Exit(0); } }
public static Image download(string fileName, string folderName) { GF.doDebug("DOWNLOADING " + fileName + " FROM " + folderName); Image returnImage = null; FtpWebRequest request = open(WebRequestMethods.Ftp.DownloadFile, fileName, folderName); if (request != null) { FtpWebResponse response = (FtpWebResponse)request.GetResponse(); Stream responseStream = response.GetResponseStream(); if (response.StatusCode == FtpStatusCode.OpeningData) { returnImage = Bitmap.FromStream(responseStream); } else { MessageBox.Show("(" + response.StatusCode.ToString() + ") " + response.StatusDescription); returnImage = null; } response.Close(); } return(returnImage); }
public static Boolean executeSP(string queryString, String stringParams, String stringValues) { // BEGIN SET if (conn.State != ConnectionState.Open) { //RAISE ERROR /*errorMsg = "Connection is not opened !!"; * MessageBox.Show(errorMsg);*/ if (!open()) { return(false); } } if (trans == null) { //RAISE ERROR /*errorMsg = "Transaction is not established !!"; * MessageBox.Show(errorMsg);*/ beginTrans(); } // EXECUTE QUERY GF.doDebug("SETTING DATA ..."); GF.doDebug("[EXECUTE SP] >>> " + queryString); try { using (command = new SqlCommand(queryString, conn, trans)) { command.CommandType = CommandType.StoredProcedure; String[] Values = stringValues.Split(','); int index = -1; foreach (String param in stringParams.Split(',')) { //"@FirstName", SqlDbType.VarChar index++; command.Parameters.Add(param, SqlDbType.Int).Value = Values[index]; } command.ExecuteNonQuery(); } } catch (Exception e) { errorMsg = e.ToString(); GF.doDebug("[SET] could not set data ... " + errorMsg); GF.doDebug(queryString); trans.Rollback(); trans.Dispose(); trans = null; GF.doDebug("[SET] TRANSACTION IS ROLLBACKED !!"); return(false); } GF.doDebug("[SET] data is set ..."); lastQuery = queryString; saveLog(queryString, "EXECUTE SP " + queryString); return(true); }
public static String[] GetDetailForAllFiles() { try { FtpWebRequest ftpclientRequest = open(WebRequestMethods.Ftp.ListDirectoryDetails, "", "SMS_CARDS"); ftpclientRequest.Proxy = null; using (FtpWebResponse response = ftpclientRequest.GetResponse() as FtpWebResponse) { StreamReader sr = new StreamReader(response.GetResponseStream(), System.Text.Encoding.UTF8); string Datastring = sr.ReadToEnd(); GF.doDebug("\r\n" + Datastring + "\r\n"); FileStruct[] list = GetList(Datastring); //Console.WriteLine("------------After Parsing-----------"); List <String> outputStr = new List <String>(); foreach (FileStruct thisstruct in list) { if (!thisstruct.IsDirectory) { outputStr.Add(thisstruct.Name + "!!!" + thisstruct.Size.ToString() + "!!!" + thisstruct.CreateTime); } } return(outputStr.ToArray()); } } catch (Exception e) { GF.doDebug(e.Message + "\r\n" + e.Data); return(null); } }
private void main_page_FormClosing(object sender, FormClosingEventArgs e) { GF.doDebug(" ========== MAIN FORM IS NOW CLOSED !! ==========="); //clock.Dispose(); GF.closeChildren(this); GF.showLoading(this); //DB.logout(); GF.closeLoading(); }
public re_issue_card_approve() { InitializeComponent(); GF.doDebug("===== CHILD FORM :: " + this.Name + " IS OPENED ====="); this.FormClosing += (s, e) => { GF.doDebug("===== CHILD FORM :: " + this.Name + " IS CLOSED ====="); }; }
public static bool close() { try { GF.doDebug("closing connection ..."); String[] tmpStr = command.CommandText.Split(' '); GF.doDebug("trans == null[" + (trans == null).ToString() + "]"); //GF.doDebug(">>>>> " + command.CommandText); if (tmpStr[0] == "SELECT") { if (trans == null) { if (conn != null) { conn.Close(); conn.Dispose(); conn = null; GF.doDebug("connection closed ..."); } } } else { GF.doDebug("[TRANSACTION] COMMITTING TRANSACTION ..."); GF.doDebug("[TRANSACTION] NULL TRANSACTION ? " + (trans == null).ToString()); if (trans != null) { trans.Commit(); trans.Dispose(); trans = null; GF.doDebug("[TRANSACTION] TRANSACTION IS COMMITTED ..."); } if (conn != null) { conn.Close(); conn.Dispose(); conn = null; GF.doDebug("connection closed ..."); } if (command != null) { command.Dispose(); } } } catch (Exception e) { errorMsg = e.ToString(); GF.doDebug("could not close connection ... " + errorMsg); if (trans != null) { trans.Rollback(); } return(false); } return(true); }
public viewer() { InitializeComponent(); GF.doDebug("===== CHILD FORM :: " + this.Name + " IS OPENED ====="); this.FormClosing += (s, e) => { GF.doDebug("===== CHILD FORM :: " + this.Name + " IS CLOSED ====="); }; }
public static Boolean set(string queryString, string logMsg, bool fromLog = false) { // BEGIN SET if (conn == null) { if (!open()) { return(false); } } if (conn.State != ConnectionState.Open) { //RAISE ERROR /*errorMsg = "Connection is not opened !!"; * MessageBox.Show(errorMsg); * return false;*/ GF.doDebug("*** CONNECTION IS NOT OPENED !! ***"); if (!open()) { return(false); } } if (trans == null) { beginTrans(); } // EXECUTE QUERY GF.doDebug("SETTING DATA ..."); GF.doDebug("[SET] >>> " + queryString); try { using (command = new SqlCommand(queryString, conn, trans)) { command.ExecuteNonQuery(); } } catch (Exception e) { errorMsg = e.ToString(); GF.doDebug("could not set data ... " + errorMsg); GF.doDebug(queryString); trans.Rollback(); trans.Dispose(); trans = null; GF.doDebug("TRANSACTION IS ROLLBACKED !!"); return(false); } GF.doDebug("data is set ..."); lastQuery = queryString; //saveLog(queryString, logMsg); return(true); }
public static bool isValidDate(string date) { if (date.Trim().Length != 10) { return(false); } if (date.Trim().Replace(" ", "") == "//" || date.Trim().Replace(" ", "") == "--" || date.Trim().Replace(" ", "") == "..") { return(false); } /*int day = Convert.ToInt32(date.Trim().Split(GF.dateSep[0])[0]); * int month = Convert.ToInt32(date.Trim().Split(GF.dateSep[0])[1]); * int year = Convert.ToInt32(date.Trim().Split(GF.dateSep[0])[2]);*/ int day = 0; int month = 0; int year = 0; if (!Int32.TryParse(date.Trim().Substring(0, 2), out day)) { return(false); } if (!Int32.TryParse(date.Trim().Substring(3, 2), out month)) { return(false); } if (!Int32.TryParse(date.Trim().Substring(6, 4), out year)) { return(false); } GF.doDebug("CHECK DaysInMonth(" + year.ToString("0000") + ", " + month.ToString("00") + ")"); if (month <= 0 || month > 12) { MessageBox.Show("MONTH MUST BE 1 - 12 !! (" + month.ToString("00") + ")", "ERROR"); return(false); } if (year <= 0) { MessageBox.Show("YEAR MUST BE GREATER THAN 0 !! (" + year.ToString("0000") + ")", "ERROR"); return(false); } if (day <= 0 || day > DateTime.DaysInMonth(year, month)) { return(false); } else { return(true); } }
public static int insertReturnID(string Query, string logMsg) { int returnValue = -1; // BEGIN SET if (conn == null) { if (!open()) { return(-1); } } if (conn.State != ConnectionState.Open) { //RAISE ERROR errorMsg = "[insertReturnID] SET Connection is not opened !!"; MessageBox.Show(errorMsg); return(-1); } else if (trans == null) { //RAISE ERROR errorMsg = "[insertReturnID] SET Transaction is not established !!"; MessageBox.Show(errorMsg); return(-1); } else { // EXECUTE QUERY GF.doDebug("[insertReturnID] SETTING DATA ..."); GF.doDebug("[INSERT RETURN ID] >>> " + Query); try { using (command = new SqlCommand(Query + ";SELECT CAST(scope_identity() AS int)", conn, trans)) { returnValue = (int)command.ExecuteScalar(); } } catch (Exception e) { errorMsg = e.ToString(); GF.doDebug("[insertReturnID] could not set data ... " + errorMsg); GF.doDebug(Query); trans.Rollback(); trans.Dispose(); trans = null; return(returnValue); } GF.doDebug("[insertReturnID] data is set ..."); lastQuery = Query; saveLog(Query, logMsg); return(returnValue); } }
public progress() { InitializeComponent(); GF.doDebug("===== MAIN FORM :: " + this.Name + " IS OPENED ====="); this.FormClosing += (s, e) => { GF.doDebug("===== MAIN FORM :: " + this.Name + " IS CLOSED ====="); }; //remoteAddr = "localhost"; //credential = new NetworkCredential("anonymous", "*****@*****.**"); }
static FtpWebRequest open(string Method, string fileName, string folderName) { GF.doDebug("OPENING CONNECTION TO ftp://" + Properties.Settings.Default.ftp_ip + "/" + folderName + "/" + fileName); // Get the object used to communicate with the server. FtpWebRequest request = (FtpWebRequest)WebRequest.Create("ftp://" + Properties.Settings.Default.ftp_ip + "/" + folderName + "/" + fileName); request.Method = Method; // This example assumes the FTP site uses anonymous logon. request.Credentials = new NetworkCredential("SMS_FTP", "SMS_FTP"); return(request); }
public static void rollbackTrans() { GF.doDebug("[TRANSACTION] Rollbacking ..."); if (trans != null) { trans.Rollback(); trans.Dispose(); trans = null; } close(); GF.doDebug("[TRANSACTION] Rollback complete ..."); }
public static bool upload(string file_path, string new_fileName, string folderName) { GF.doDebug("UPLOADING " + new_fileName + " TO " + folderName); String card_front_ext = new_fileName.Substring(new_fileName.LastIndexOf(".")); if (card_front_ext.Trim().ToLower().IndexOf("jpg") == -1 && card_front_ext.Trim().ToLower().IndexOf("png") == -1) { MessageBox.Show("FILE UPLOADING ACCEPTS ONLY .JPG OR .PNG !!", "ERROR"); return(false); } bool boolReturn = false; FtpWebRequest request = open(WebRequestMethods.Ftp.UploadFile, new_fileName, folderName); if (request != null) { // Copy the contents of the file to the request stream. byte[] fileContents = File.ReadAllBytes(file_path); request.RenameTo = new_fileName; request.ContentLength = fileContents.Length; try { Stream requestStream; using (requestStream = request.GetRequestStream()) { requestStream.Write(fileContents, 0, fileContents.Length); requestStream.Close(); FtpWebResponse response = (FtpWebResponse)request.GetResponse(); if (response.StatusCode == FtpStatusCode.ClosingData) { boolReturn = true; } else { MessageBox.Show("(" + response.StatusCode.ToString() + ") " + response.StatusDescription); boolReturn = false; } response.Close(); } } catch (Exception EX) { MessageBox.Show(EX.Message); } } return(boolReturn); }
public attachments() { InitializeComponent(); GF.doDebug("===== CHILD FORM :: " + this.Name + " IS OPENED ====="); this.FormClosing += (s, e) => { GF.doDebug("===== CHILD FORM :: " + this.Name + " IS CLOSED ====="); }; DGV.Width = line_sep1.Width; DGV.Height = this.Height - DGV.Top - 40; GF.disableButton(add_btn); GF.disableButton(delete_btn); }
public login() { InitializeComponent(); GF.doDebug("===== MAIN FORM :: " + this.Name + " IS OPENED ====="); this.FormClosing += (s, e) => { GF.doDebug("===== MAIN FORM :: " + this.Name + " IS CLOSED ====="); }; foreach (InputLanguage IL in InputLanguage.InstalledInputLanguages) { if (IL.LayoutName.ToString() == "US") { InputLanguage.CurrentInputLanguage = IL; break; } } }
public static void initPage(Form childPage, main_page mainPage) { GF.closeChildren(mainPage); GF.showLoading(mainPage); GF.doDebug("========== MAIN FORM :: " + childPage.Name + " =========="); GF.selected_id = 0; childPage.MdiParent = mainPage; if (childPage.Name.IndexOf("report_") != -1) { childPage.Dock = DockStyle.Fill; } else { childPage.Size = childPage.MdiParent.ClientSize; childPage.StartPosition = FormStartPosition.Manual; } childPage.WindowState = FormWindowState.Maximized; GF.addKeyUp(childPage); childPage.Load += (s, e) => { //((Form)s).Visible = true; }; childPage.LocationChanged += (s, e) => { if (childPage.Left != 0) { childPage.Left = -5; } if (childPage.Top != 0) { childPage.Top = 0; } }; if (!childPage.IsDisposed) { childPage.Show(); } GF.closeLoading(); }
public static bool beginTrans() { GF.doDebug("[TRANSACTION] ESTABLISHING TRANSACTION ..."); try { if (conn == null) { if (!open()) { return(false); } } else if (conn.State == ConnectionState.Closed) { if (!open()) { return(false); } } GF.doDebug("[TRANSACTION] NULL CONNECTION IS NULL ? : " + (conn == null).ToString()); GF.doDebug("[TRANSACTION] CONNECTION IS CLOSED ? : " + (conn.State == ConnectionState.Closed).ToString()); if (conn.State == ConnectionState.Closed) { conn.Close(); } if (trans != null) { trans.Dispose(); } trans = conn.BeginTransaction(IsolationLevel.ReadUncommitted); GF.doDebug("[TRANSACTION] TRANSACTION IS ESTABLISHED"); return(true); } catch (Exception e) { if (conn != null) { conn.Dispose(); } GF.doDebug("COULD NOT ESTABLISH TRANSACTION ... " + e.Message); return(false); } }
private static FileStruct ParseFileStructFromUnixStyleRecord(string Record) { GF.doDebug(Record); ///Assuming record style as /// dr-xr-xr-x 1 owner group 0 Nov 25 2002 bussys FileStruct f = new FileStruct(); string processstr = Record.Trim(); f.Flags = processstr.Substring(0, 9); f.IsDirectory = (f.Flags[0] == 'd'); processstr = (processstr.Substring(11)).Trim(); _cutSubstringFromStringWithTrim(ref processstr, ' ', 0); //skip one part f.Owner = _cutSubstringFromStringWithTrim(ref processstr, ' ', 0); f.Group = _cutSubstringFromStringWithTrim(ref processstr, ' ', 0); f.Size = Convert.ToInt64(_cutSubstringFromStringWithTrim(ref processstr, ' ', 0)); //_cutSubstringFromStringWithTrim(ref processstr,' ',0); //skip one part f.CreateTime = DateTime.Parse(_cutSubstringFromStringWithTrim(ref processstr, ' ', 8)); f.Name = processstr; //Rest of the part is name return(f); }
public static bool delete(string fileName, string folderName) { GF.doDebug("DELETING " + fileName + " FROM " + folderName); bool boolReturn = false; FtpWebRequest request = open(WebRequestMethods.Ftp.DeleteFile, fileName, folderName); if (request != null) { FtpWebResponse response = (FtpWebResponse)request.GetResponse(); if (response.StatusCode == FtpStatusCode.FileActionOK) { boolReturn = true; } else { MessageBox.Show("(" + response.StatusCode.ToString() + ") " + response.StatusDescription); boolReturn = false; } } return(boolReturn); }
public static void logout() { GF.doDebug("LOGGING OUT ..."); if (!beginTrans()) { MessageBox.Show("COULD NOT BEGIN DATABASE TRANSACTION !!"); return; } else { if (!set("UPDATE USERS SET last_login = CURRENT_TIMESTAMP WHERE user_id = " + GF.user_id.ToString(), "LOGOUT SUCCESS, UPDATE LAST LOGIN")) { GF.doDebug("[ERROR] " + errorMsg); MessageBox.Show("ERROR : " + errorMsg); } else { GF.is_logged_in = false; close(); GF.doDebug("LOG OUT COMPLETED."); } } }
private static void saveLog(String Query, String logMsg) { GF.doDebug("saving log ..."); try { String logQueryString = @"INSERT INTO LOG ( subject, query, log_datetime, user_id, emp_id, old_value ) VALUES ( '" + logMsg + @"', '" + Query.Replace("'", "''") + @"', CURRENT_TIMESTAMP, " + GF.user_id + @", "; if (GF.emp_id == 0) { logQueryString += "NULL"; } else { logQueryString += GF.emp_id; } logQueryString += @", '" + GF.old_value + @"' ) "; GF.doDebug("[LOG] >>> " + logQueryString); //command = new SqlCommand(logQueryString, conn, trans); //command.ExecuteNonQuery(); } catch (Exception e) { errorMsg = e.ToString(); trans.Rollback(); GF.doDebug("could not save log ... " + errorMsg); return; } GF.doDebug("log saved ..."); }
private void card_print_Load(object sender, EventArgs e) { String queryString = ""; DataTable DT = null; switch (card_type) { case 0: case 1: // MEMBERCARD & MEMBERCARD_LIMITED_EDITION print_card1_btn.Text = "FRONT"; print_card2_btn.Text = "BACK"; attach_paper_btn.Text = "ATTACH PAPER"; break; case 2: // GIFT CERTIFICATE print_card1_btn.Text = "CARD"; print_card1_btn.Width = attach_paper_btn.Width; print_card2_btn.Visible = false; break; case 3: // GIFT VOUCHER GF.enableButton(print_card1_btn); print_card1_btn.Text = "CARD"; print_card1_btn.Width = attach_paper_btn.Width; print_card2_btn.Visible = false; attach_paper_btn.Visible = false; groupBox1.Height = attach_paper_btn.Top; instruction_lbl.Top = groupBox1.Height + 15; this.Height = instruction_lbl.Top + instruction_lbl.Height + 40; break; } switch (card_type) { case 0: case 1: // MEMBERCARD queryString = @" SELECT A.CARD_NO, B.*, C.CODE FROM MEMBERCARD A INNER JOIN MEMBERCARD_TYPE B ON A.MEMBERCARD_TYPE_ID = B.MEMBERCARD_TYPE_ID INNER JOIN CUSTOMER C ON A.CUSTOMER_ID = C.CUSTOMER_ID WHERE A.MEMBERCARD_ID = " + GF.selected_id.ToString(); using (DT = DB.getS(queryString, null, "GET DATA FROM MEMBERCARD_TYPE", false)) { file1 = DT.Rows[0]["FRONT_CARD"].ToString(); file2 = DT.Rows[0]["BACK_CARD"].ToString(); file3 = DT.Rows[0]["ATTACH_PAPER"].ToString(); customer_code = DT.Rows[0]["CODE"].ToString(); if (card_no == "") { card_no = DT.Rows[0]["CARD_NO"].ToString(); } } break; case 2: // GIFT CERTIFICATE queryString = "SELECT A.*, B.RUS_NAME FROM GIFT_CERTIFICATE A LEFT OUTER JOIN SPA_PROGRAM B ON A.SPA_PROGRAM_ID = B.SPA_PROGRAM_ID WHERE A.GIFT_CERTIFICATE_ID = " + GF.selected_id.ToString(); using (DT = DB.getS(queryString, null, "GET SPA_PROGRAM_NAME FROM GIFT_CERTIFICATE[" + GF.selected_id.ToString() + "]", false)) { if (DT.Rows.Count == 1) { spaProgramName = DT.Rows[0]["RUS_NAME"].ToString(); if (DT.Rows[0]["BALANCE_MAX"].ToString() != "") { price = DT.Rows[0]["BALANCE_MAX"].ToString(); } else { price = DT.Rows[0]["PRICE"].ToString(); } from_txt = DT.Rows[0]["FROM_TXT"].ToString(); for_txt = DT.Rows[0]["FOR_TXT"].ToString(); if (card_no == "") { card_no = DT.Rows[0]["CARD_NO"].ToString(); } } } queryString = "SELECT * FROM GIFT_CERTIFICATE_CONFIG"; DT = DB.getS(queryString, null, "GET GIFT_CERTIFICATE_CONFIG", false); file1 = DT.Rows[0]["CARD1"].ToString(); file3 = DT.Rows[0]["CARD2"].ToString(); break; case 3: // GIFT VOUCHER String[] tmp = GF.tmpText.Split(); if (!isReIssue) { if (GF.selected_id.ToString() != "-1") { queryString = "SELECT RUS_NAME FROM SPA_PROGRAM WHERE SPA_PROGRAM_ID = " + GF.selected_id.ToString(); using (DT = DB.getS(queryString, null, "GET RUS_NAME OF SPA_PROGRAM_NAME FROM GIFT_VOUCHER", false)) { spaProgramName = DT.Rows[0]["RUS_NAME"].ToString(); } } else { spaProgramName = "ALL SPA PROGRAM " + tmp[0] + " " + tmp[1]; } } else { if (GF.selected_id.ToString() != "-1") { queryString = "SELECT B.RUS_NAME FROM GIFT_VOUCHER A INNER JOIN SPA_PROGRAM B ON A.SPA_PROGRAM_ID = B.SPA_PROGRAM_ID WHERE A.GIFT_VOUCHER_ID = " + GF.selected_id.ToString(); using (DT = DB.getS(queryString, null, "GET RUS_NAME OF SPA_PROGRAM_NAME FROM GIFT_VOUCHER", false)) { spaProgramName = DT.Rows[0]["RUS_NAME"].ToString(); } } else { spaProgramName = "ALL SPA PROGRAM " + tmp[0] + " " + tmp[1]; } } queryString = "SELECT * FROM GIFT_VOUCHER_CONFIG"; using (DT = DB.getS(queryString, null, "GET GIFT_VOUCHER_CONFIG", false)) { file1 = DT.Rows[0]["CARD"].ToString(); } break; } if (!isReIssue) { expire_amount = Convert.ToInt32(DT.Rows[0]["EXPIRE_AMOUNT"].ToString()); expire_unit = Convert.ToInt32(DT.Rows[0]["EXPIRE_UNIT"].ToString()); if (expire_amount.ToString() != "0") { DateTime expiryDate = new DateTime(); if (expire_unit == 0) { expiryDate = DateTime.Now.AddMonths(expire_amount); } if (expire_unit == 1) { expiryDate = DateTime.Now.AddYears(expire_amount); } expire_date = expiryDate.Day.ToString("00") + "/" + expiryDate.Month.ToString("00") + "/" + expiryDate.Year.ToString(); } if (card_type == 3) { card_no = (DateTime.Now.Year + 543).ToString() + DateTime.Now.Month.ToString("00") + DateTime.Now.Day.ToString("00") + DateTime.Now.Hour.ToString("00") + DateTime.Now.Minute.ToString("00") + DateTime.Now.Second.ToString("00") + new Random().Next(1, 100).ToString("00"); } switch (card_type) { case 0: case 1: // MEMBERCARD break; case 2: insertString = "UPDATE GIFT_CERTIFICATE SET IS_PAID = 1, IS_USE = 1 WHERE GIFT_CERTIFICATE_ID = " + GF.selected_id.ToString(); break; case 3: // GIFT_VOUCHER String[] tmp = GF.tmpText.Split(' '); insertString = "INSERT INTO GIFT_VOUCHER (" + (billID != -1 ? "BILL_ID, " : "") + "CARD_NO, SPA_PROGRAM_ID, EXPIRY_DATE, DISCOUNT_AMOUNT, DISCOUNT_UNIT, ISSUE_BY, APPROVED_BY, ISSUE_FOR"; if (member_card_id != -1) { insertString += ", MEMBERCARD_ID"; } insertString += ") SELECT " + (billID != -1 ? billID.ToString() + ", " : "") + "'" + card_no + "', " + GF.selected_id.ToString() + ", "; if (GF.selected_id.ToString() != "-1") { insertString += "DATEADD("; if (expire_unit == 0) { insertString += "MONTH"; } if (expire_unit == 1) { insertString += "YEAR"; } insertString += ", " + expire_amount.ToString() + ", GETDATE()), "; } else { insertString += GF.modDate(tmp[2]) + ", "; } insertString += tmp[0] + ", "; insertString += (tmp[1].Trim() == "%" ? "0, " : "1, "); insertString += GF.emp_id.ToString() + ", " + approved_id.ToString() + ", '" + gv_issue_for + "'"; if (member_card_id != -1) { insertString += ", " + member_card_id.ToString(); } insertString += " FROM GIFT_VOUCHER_CONFIG WHERE GIFT_VOUCHER_CONFIG_ID = 1"; break; } if (insertString.Trim() != "") { DB.beginTrans(); GF.doDebug(">>>>>>>>>> " + insertString); if (!DB.set(insertString, "INSERT INTO " + type_name[card_type] + " TABLE")) { GF.closeLoading(); MessageBox.Show("ERROR INSERT INTO " + type_name[card_type] + " TABLE !!", "ERROR"); return; } else { DB.close(); } } } else { switch (card_type) { case 0: case 1: // MEMBERCARD queryString = "SELECT CARD_NO, CONVERT(NVARCHAR(MAX), EXPIRE_DATE, 103) EXPIRY_DATE FROM MEMBERCARD WHERE MEMBERCARD_ID = " + GF.selected_id.ToString(); DT = DB.getS(queryString, null, "GET CARD_NO, EXPIRY_DATE FROM MEMBERCARD[" + GF.selected_id.ToString() + "]", false); break; case 2: queryString = "SELECT CARD_NO, CONVERT(NVARCHAR(MAX), EXPIRY_DATE, 103) EXPIRY_DATE FROM GIFT_CERTIFICATE WHERE GIFT_CERTIFICATE_ID = " + GF.selected_id.ToString(); DT = DB.getS(queryString, null, "GET CARD_NO, EXPIRY_DATE FROM GIFT_CERTIFICATE[" + GF.selected_id.ToString() + "]", false); break; case 3: queryString = "SELECT CARD_NO, CONVERT(NVARCHAR(MAX), EXPIRY_DATE, 103) EXPIRY_DATE FROM GIFT_VOUCHER WHERE GIFT_VOUCHER_ID = " + GF.selected_id.ToString(); DT = DB.getS(queryString, null, "GET CARD_NO, EXPIRY_DATE FROM GIFT_VOUCHER[" + GF.selected_id.ToString() + "]", false); break; } card_no = DT.Rows[0]["CARD_NO"].ToString(); expire_date = DT.Rows[0]["EXPIRY_DATE"].ToString(); DT.Dispose(); } }
static void Main() { try { if (Process.GetProcessesByName("SPA MANAGEMENT SYSTEM").Length <= 1) { AppDomain.CurrentDomain.UnhandledException += new UnhandledExceptionEventHandler(CurrentDomain_UnhandledException); Application.ThreadException += new System.Threading.ThreadExceptionEventHandler(Application_ThreadException); Application.ApplicationExit += (ss, ee) => { if (GF.is_logged_in) { DB.logout(); } }; Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); if (!File.Exists(GF.path)) { File.Create(GF.path); } else { File.WriteAllText(GF.path, String.Empty); } //Application.Run(new login()); Application.Run(new main_page()); // Check if user is NOT admin if (!IsRunningAsAdministrator()) { // Setting up start info of the new process of the same application ProcessStartInfo processStartInfo = new ProcessStartInfo(Assembly.GetEntryAssembly().CodeBase); // Using operating shell and setting the ProcessStartInfo.Verb to “runas” will let it run as admin processStartInfo.UseShellExecute = true; processStartInfo.Verb = "runas"; // Start the application as new process currentProcess = Process.Start(processStartInfo); // Shut down the current (old) process System.Windows.Forms.Application.Exit(); } } } catch (Win32Exception e) { GF.doDebug("\r\n\r\n APPLICATION EXIT WITH CODE : " + e.ErrorCode); GF.doDebug("\r\n\r\n" + e.Message); GF.doDebug("\r\n\r\n" + e.StackTrace); GF.doDebug("\r\n\r\nFile : " + new StackTrace(e, true).GetFrame(0).GetFileName()); GF.doDebug("\r\n\r\nLine : " + new StackTrace(e, true).GetFrame(0).GetFileLineNumber()); if (currentProcess != null) { currentProcess.Kill(); } System.Environment.Exit(0); } }
void syncFile() { if (FilesToDownload.Count > 0) { GF.doDebug("[ FILE LIST :: BEGIN ] TOTAL : " + FilesToDownload.Count.ToString() + " FILE" + (FilesToDownload.Count > 1 ? "S" : "")); int count = 1; foreach (String file in FilesToDownload) { GF.doDebug(count.ToString() + ". " + file); count++; } GF.doDebug("[ FILE LIST :: END ]"); backgroundTask.ReportProgress(0); bytesTotal = new long[FilesToDownload.Count]; foreach (String file in FilesToDownload) { FtpWebRequest fileSizeFTP; fileSizeFTP = (FtpWebRequest)FtpWebRequest.Create(new Uri("ftp://" + remoteAddr + "/" + folderName + "/" + file)); fileSizeFTP.Credentials = credential; fileSizeFTP.KeepAlive = false; fileSizeFTP.Method = WebRequestMethods.Ftp.GetFileSize; fileSizeFTP.UseBinary = true; fileSizeFTP.Proxy = null; fileSizeFTP.UsePassive = true; using (FtpWebResponse fileSizeResponse = (FtpWebResponse)fileSizeFTP.GetResponse()) { bytesTotal[index] = fileSizeResponse.ContentLength; fileSizeResponse.Close(); } index++; } // START DOWNLOAD FILE Mode = 1; index = 0; foreach (String file in FilesToDownload) { backgroundTask.ReportProgress(0); //GF.doDebug("FILE " + (index + 1).ToString() + " : " + file); string uri = "ftp://" + remoteAddr + "/" + folderName + "/" + file; Uri serverUri = new Uri(uri); if (serverUri.Scheme != Uri.UriSchemeFtp) { return; } FtpWebRequest reqFTP = (FtpWebRequest)FtpWebRequest.Create(new Uri("ftp://" + remoteAddr + "/" + folderName + "/" + file)); reqFTP.Credentials = credential; reqFTP.KeepAlive = true; reqFTP.Method = WebRequestMethods.Ftp.DownloadFile; reqFTP.UseBinary = true; reqFTP.Proxy = null; reqFTP.UsePassive = true; using (FtpWebResponse response = (FtpWebResponse)reqFTP.GetResponse()) { using (Stream responseStream = response.GetResponseStream()) { int Length = 2048; Byte[] buffer = new Byte[Length]; int bytesRead = 0; long allRead = 0; using (FileStream writeStream = new FileStream(@"C:\" + folderName + @"\" + file, FileMode.Create)) { GF.doDebug("[ DOWNLOAD FILE ] " + "ftp://" + remoteAddr + "/" + folderName + "/" + file); allRead += bytesRead = responseStream.Read(buffer, 0, buffer.Length); //GF.doDebug("[" + file + "] " + ((int)(((float)allRead / (float)bytesTotal[index]) * 100.0)).ToString() + "% " + allRead.ToString() + "/" + bytesTotal[index].ToString()); backgroundTask.ReportProgress((int)(((float)allRead / (float)bytesTotal[index]) * 100.0)); while (bytesRead > 0) { writeStream.Write(buffer, 0, bytesRead); allRead += bytesRead = responseStream.Read(buffer, 0, Length); backgroundTask.ReportProgress((int)(((float)allRead / (float)bytesTotal[index]) * 100.0)); //GF.doDebug("[" + file + "] " + ((int)(((float)allRead / (float)bytesTotal[index]) * 100.0)).ToString() + "% " + allRead.ToString() + "/" + bytesTotal[index].ToString()); } GF.doDebug("[ DOWNLOAD COMPLETED ] " + file); writeStream.Close(); } response.Close(); } } while (true) { if (progressBar.Value == progressBar.Maximum) { Thread.Sleep(1000); break; } } index++; //if (index == 2) return; currentFile++; } //GF.doDebug("PROGRESS CLOSE !!"); } }
void getFTPFileList() { FTPFiles = new List <string>(); using (DataTable myDT = DB.getS("SELECT FRONT_CARD, BACK_CARD, ATTACH_PAPER FROM MEMBERCARD_TYPE WHERE IS_USE = 1", null, "GET MEMBERCARD FILES", false)) { foreach (DataRow myDR in myDT.Rows) { FTPFiles.Add(myDR["FRONT_CARD"].ToString()); FTPFiles.Add(myDR["BACK_CARD"].ToString()); FTPFiles.Add(myDR["ATTACH_PAPER"].ToString()); } } using (DataTable myDT = DB.getS("SELECT CARD1, CARD2 FROM GIFT_CERTIFICATE_CONFIG", null, "GET GIFT_CERTIFICATE FILES", false)) { foreach (DataRow myDR in myDT.Rows) { FTPFiles.Add(myDR["CARD1"].ToString()); FTPFiles.Add(myDR["CARD2"].ToString()); } } foreach (String tmpStr in FTPFiles) { GF.doDebug("- " + tmpStr); } /*StringBuilder result = new StringBuilder(); * WebResponse response = null; * StreamReader reader = null; * try * { * FtpWebRequest reqFTP; * reqFTP = (FtpWebRequest)FtpWebRequest.Create(new Uri("ftp://" + remoteAddr + "/SMS_CARDS/")); * reqFTP.UseBinary = true; * reqFTP.Credentials = credential; * reqFTP.Method = WebRequestMethods.Ftp.ListDirectory; * reqFTP.Proxy = null; * reqFTP.KeepAlive = true; * reqFTP.UsePassive = true; * using (response = reqFTP.GetResponse()) * { * using (reader = new StreamReader(response.GetResponseStream())) * { * string line = reader.ReadLine(); * while (line != null) * { * result.Append(line); * result.Append("\n"); * line = reader.ReadLine(); * } * // to remove the trailing '\n' * result.Remove(result.ToString().LastIndexOf('\n'), 1); * result.Replace("version.txt\n", ""); * String[] tmp = result.ToString().Split('\n'); * GF.doDebug("\r\n========== FTP FILE =========="); * FTPFiles = new List<string>(); * foreach (String tmpStr in tmp) { * FTPFiles.Add(tmpStr); * GF.doDebug("- " + tmpStr); * } * GF.doDebug("\r\n"); * return true; * } * } * } * catch (Exception ex) * { * if (reader != null) * { * reader.Close(); * } * if (response != null) * { * response.Close(); * } * FTPFiles = null; * GF.doDebug("[ GET FILE LIST :: ERROR ] >>> " + ex.Message); * return false; * }*/ }
/*public static DataTable get(string Query, string logMsg, bool paging = true) * { * //if (!open("GET")) * if (!open()) * { * //RAISE ERROR * return null; * } * else * { * GF.doDebug("[GET] getting data ... [ " + logMsg + " ]"); * GF.doDebug("[GET] >>> " + modifySelect(Query, paging)); * * try * { * using (command = new SqlCommand(modifySelect(Query, paging), conn, trans)) * { * using (SqlDataAdapter dataAdapter = new SqlDataAdapter(command)) * { * using (DataSet myDS = new DataSet()) * { * //GF.closeLoading(); * dataAdapter.Fill(myDS); * GF.doDebug("got data ..."); * lastQuery = modifySelect(Query, paging); * GF.doDebug("HAS " + myDS.Tables[0].Rows.Count.ToString() + " DATA"); * return myDS.Tables[0]; * } * } * } * } * catch (Exception e) * { * errorMsg = e.ToString(); * GF.doDebug("could not get data ... \r\n\r\n" + errorMsg + "\r\n\r\n"); * GF.doDebug(modifySelect(Query, paging)); * * MessageBox.Show("COULD NOT GET DATA ...\r\nPLEASE TRY AGAIN LATER :)", "ERROR"); * * return null; * } * finally * { * close(); * } * } * }*/ public static DataTable getS(string Query, Dictionary <string, string> Params, string logMsg, bool paging = true) { //if (!open("GET")) if (!open()) { //RAISE ERROR return(null); } else { GF.doDebug("[GET] getting data ... [ " + logMsg + " ]"); GF.doDebug("[GET] >>> " + modifySelect(Query, paging)); try { using (command = new SqlCommand(modifySelect(Query, paging), conn, trans)) { if (Params != null) { if (Params.Count > 0) { SqlParameter param; foreach (KeyValuePair <string, string> entry in Params) { param = new SqlParameter(); Console.WriteLine(entry.Key + " : " + entry.Value); param.ParameterName = entry.Key; param.Value = entry.Value.Trim(); command.Parameters.Add(param); } } } using (SqlDataAdapter dataAdapter = new SqlDataAdapter(command)) { using (DataSet myDS = new DataSet()) { //GF.closeLoading(); dataAdapter.Fill(myDS); GF.doDebug("got data ..."); lastQuery = modifySelect(Query, paging); GF.doDebug("HAS " + myDS.Tables[0].Rows.Count.ToString() + " DATA"); return(myDS.Tables[0]); } } } } catch (Exception e) { errorMsg = e.ToString(); Console.WriteLine(Query); GF.doDebug("could not get data ... \r\n\r\n" + errorMsg + "\r\n\r\n"); GF.doDebug(modifySelect(Query, paging)); MessageBox.Show("COULD NOT GET DATA ...\r\nPLEASE TRY AGAIN LATER :)", "ERROR"); return(null); } finally { close(); } } }
public static bool open() { if (localIP == "") { System.Net.IPHostEntry host; host = System.Net.Dns.GetHostEntry(System.Net.Dns.GetHostName()); foreach (System.Net.IPAddress ip in host.AddressList) { if (ip.AddressFamily == System.Net.Sockets.AddressFamily.InterNetwork) { localIP = ip.ToString(); break; } } } GF.doDebug("opening connection ..."); errorMsg = ""; if (localIP == "192.168.1.251" || Environment.MachineName == "SPA01-PC") { DataSource = "localhost"; } else if (Properties.Settings.Default.db_ip == "") { DataSource = DataSource = "85.30.232.165"; //"192.168.1.251"; } else { DataSource = Properties.Settings.Default.db_ip; } if (useLocalHost) { DataSource = "localhost"; } DataSource += "\\SQLEXPRESS,25529"; SqlConnectionStringBuilder connectionString = new SqlConnectionStringBuilder(); connectionString.UserID = UserID; connectionString.Password = Password; connectionString.DataSource = DataSource; connectionString.InitialCatalog = DBName; connectionString.ConnectTimeout = 15; GF.doDebug("\r\n" + connectionString.ConnectionString + "\r\n"); if (conn == null || conn.State == ConnectionState.Closed) { conn = new SqlConnection(connectionString.ConnectionString); try { GF.doDebug("CREATING NEW SQL CONNECTION ..."); conn.Open(); GF.doDebug("SQL CONNECTION IS CREATED !!"); } catch (Exception e) { if (conn != null) { conn.Dispose(); } errorMsg = e.ToString(); MessageBox.Show("CANNOT CONNECT TO DATABASE.\r\n\r\nPLEASE TRY AGAIN A FEW MINUTES LATER ...", "ERROR"); GF.doDebug("could not open connection ... \r\n\r\n" + errorMsg); System.Environment.Exit(0); return(false); } GF.doDebug("connection opened ..."); return(true); } GF.doDebug("CONNECTION STATE :: " + conn.State.ToString()); return(true); }