public static bool IsValidNorthAmericanNumber(string number) { bool isValid = false; try { string numbersOnly = StripNonNumericCharacters(number); //dnw: 2402164320 //Regex regexObj = new Regex(@"(?:(?:\+?1\s*(?:[.-]\s*)?)?(?:(\s*([2-9]1[02-9]|[2-9][02-8]1|[2-9][02-8][02-9])\s*)|([2-9]1[02-9]|[2-9][02-8]1|[2-9][02-8][02-9]))\s*(?:[.-]\s*)?)([2-9]1[02-9]|[2-9][02-9]1|[2-9][02-9]{2})\s*(?:[.-]\s*)?([0-9]{4})"); //http://www.asiteaboutnothing.net/regex/regex-quickstart.html Regex regexObj = new Regex(@"^1?([0-9]{3})([0-9]{3})([0-9]{4})$"); if (regexObj.IsMatch(numbersOnly)) { string formattedPhoneNumber = regexObj.Replace(numbersOnly, "($1) $2-$3"); isValid = true; } else { // Invalid phone number } } catch (Exception ex) { LogIt.E(ex); } return(isValid); }
public static bool Execute( string AWSAccessKey, string AWSSecretKey, string bucketName, byte[] ba, string toPath, out string url, RegionEndpoint re, S3CannedACL s3ca ) { url = ""; try { using (var ms = new MemoryStream(ba)) { var uploadMultipartRequest = new TransferUtilityUploadRequest { BucketName = bucketName, Key = toPath, CannedACL = s3ca, InputStream = ms, //PartSize = 123? }; using (var tu = new TransferUtility(AWSAccessKey, AWSSecretKey, re)) { tu.Upload(uploadMultipartRequest); } url = S3_BASE + bucketName + "/" + toPath; return(true); } } catch (Exception ex) { LogIt.E(ex); return(false); } }
/// <summary> /// account for possbility of ELB sheilding the public ip /// </summary> /// <returns></returns> public static string Execute(bool elbIsInUse = true) { try { #if DEBUG #else #endif //LogIt.D(string.Join("|", new List<object> { HttpContext.Current.Request.UserHostAddress, HttpContext.Current.Request.Headers["X-Forwarded-For"], HttpContext.Current.Request.Headers["REMOTE_ADDR"] })); if ((HttpContext.Current == null) || (HttpContext.Current.Request == null)) { return(null); } var ip = HttpContext.Current.Request.UserHostAddress; if (HttpContext.Current.Request.Headers["X-Forwarded-For"] != null) { ip = HttpContext.Current.Request.Headers["X-Forwarded-For"]; //LogIt.D(ip + "|X-Forwarded-For"); } else if (HttpContext.Current.Request.Headers["REMOTE_ADDR"] != null) { ip = HttpContext.Current.Request.Headers["REMOTE_ADDR"]; //LogIt.D(ip + "|REMOTE_ADDR"); } //ip = string.IsNullOrEmpty(ip) ? ip : ip.Split() return(ip); } catch (Exception ex) { LogIt.E(ex); } return(null); }
public static bool Execute( string AWSAccessKey, string AWSSecretKey, string bucketName, string filePath, string toPath, RegionEndpoint re, out string url, S3CannedACL s3ca ) { url = ""; try { using (var tu = new TransferUtility(AWSAccessKey, AWSSecretKey, re)) { var tuur = new TransferUtilityUploadRequest { FilePath = filePath, BucketName = bucketName, Key = toPath, CannedACL = s3ca }; tu.Upload(tuur); url = S3_BASE + bucketName + "/" + toPath; } return(true); } catch (Exception ex) { LogIt.E(ex); return(false); } }
//TODO: do i really want all these to be public read?! are we locking down elsewhre w/ cors or bucket policy? public static bool Execute( string AWSAccessKey, string AWSSecretKey, string bucketName, MemoryStream ms, string key, RegionEndpoint re, out string url ) { url = ""; try { var uploadMultipartRequest = new TransferUtilityUploadRequest { BucketName = bucketName, Key = key, CannedACL = S3CannedACL.PublicRead, InputStream = ms, }; using (var tu = new TransferUtility(AWSAccessKey, AWSSecretKey, re)) { tu.Upload(uploadMultipartRequest); } url = S3_BASE + bucketName + "/" + key; return(true); } catch (Exception ex) { LogIt.E(ex); return(false); } }
public static bool IsDisposable(string email, string apiKey) { try { var response = new RestClient { BaseUrl = new Uri("http://check.block-disposable-email.com/"), Timeout = 5000 }.Execute(new RestRequest { Resource = "easyapi/json/" + apiKey + "/" + email, Method = Method.GET, //RequestFormat = RestSharp.DataFormat.Json }); var content = response.Content; dynamic json = Newtonsoft.Json.Linq.JObject.Parse(content); //{"request_status":"success","domain_status":"block","version":"0.1","servertime":"2013-01-14 22:37:39","server_id":"mirror2_chicago"} var request_status = json.request_status.Value; var domain_status = json.domain_status.Value; var disposable = (request_status == "success") && (domain_status == "block"); //consider fallback plan if/when we run out of queries... ie use the static list. return(disposable); } catch (Exception ex) { LogIt.E(ex); return(false); } }
static void Main(string[] args) { LogIt.LogInfo("Program starting"); Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new Form1()); }
/// <summary> /// verify valid job /// </summary> /// <param name="jobID"></param> /// <param name="connectionString"></param> /// <returns>boolean indicating job exists in database</returns> private static bool valid_job(int jobID, string connectionString) { bool isValid = false; try { using (SqlConnection conn = new SqlConnection(connectionString)) { LogIt.LogInfo($"Validating job ID {jobID}"); string cmdText = "SELECT COUNT(JobID) FROM MLG.POL.tblJobs WHERE JobID = @jobID"; using (SqlCommand cmd = new SqlCommand(cmdText, conn)) { cmd.Parameters.AddWithValue("@jobID", jobID); conn.Open(); int rows = (int)cmd.ExecuteScalar(); isValid = (rows > 0); } } } catch (Exception ex) { LogIt.LogError($"Error validating job ID {jobID}: {ex.Message}"); } return(isValid); }
public static string GetCountryCode(string ip, MaxmindSource mms = MaxmindSource.LocalDb, bool throwOnError = false, bool doNotWarnOnNotInDb = false) { try { using (WebServiceClient wsc = new MaxMind.GeoIP2.WebServiceClient(MAXMIND_WS_USER_ID, MAXMIND_WS_KEY)) { var ir = wsc.Insights(ip); LogIt.D(ir.Country.IsoCode + "|" + ir.City.Name); return(ir.Country.IsoCode); } } catch (Exception ex) { if (doNotWarnOnNotInDb && ex.Message.Contains("is not in the database")) { //LogIt.W(ip + "|" + ex.Message); } else { LogIt.W(ip + "|" + ex.Message); } if (throwOnError) { throw ex; } else { return(null); } } }
private static string StringToCSVCell(string str) { try { bool mustQuote = (str.Contains(",") || str.Contains("\"") || str.Contains("\r") || str.Contains("\n")); if (mustQuote) { var sb = new StringBuilder(); sb.Append("\""); foreach (char nextChar in str) { sb.Append(nextChar); if (nextChar == '"') { sb.Append("\""); } } sb.Append("\""); return(sb.ToString()); } return(str); } catch (Exception ex) { LogIt.E(ex); throw ex; } }
public static string Execute <T>(List <T> data, bool addHeaderRow = false) { try { var properties = typeof(T).GetProperties(); var result = new StringBuilder(); if (addHeaderRow) { var methods = properties .Select(p => p.GetMethod) .Select(v => StringToCSVCell( ((v == null) ? "" : v.ToString()) )) .Select(m => m.Substring(m.IndexOf("get_") + 4).Replace("()", "")); result.AppendLine(string.Join(",", methods)); } foreach (var row in data) { var values = properties.Select(p => p.GetValue(row, null)) .Select(v => StringToCSVCell( ((v == null) ? "" : v.ToString()) )); var line = string.Join(",", values); result.AppendLine(line); } return(result.ToString()); } catch (Exception ex) { LogIt.E(ex); throw ex; } }
public static bool Execute( string AWSAccessKey, string AWSSecretKey, string bucketName, string fileKey, RegionEndpoint re, out MemoryStream ms ) { ms = null; try { using (var s3c = new AmazonS3Client(AWSAccessKey, AWSSecretKey, re)) { var response = s3c.GetObject( new GetObjectRequest { BucketName = bucketName, Key = fileKey }); using (var rs = response.ResponseStream) { ms = new MemoryStream(); rs.CopyTo(ms); return(true); } } } catch (Exception ex) { LogIt.E(ex); return(false); } }
public static bool Execute( string AWSAccessKey, string AWSSecretKey, string bucketName, string objectKey, out string url, int numberOfMinutes = 30 ) { url = ""; try { using (var s3Client = new AmazonS3Client(Amazon.RegionEndpoint.USEast1)) { var gpsur = new GetPreSignedUrlRequest { BucketName = bucketName, Key = objectKey, Expires = DateTime.UtcNow.AddMinutes(numberOfMinutes) }; url = s3Client.GetPreSignedURL(gpsur); } return(true); } catch (Exception ex) { LogIt.E(ex); return(false); } }
private DataSet GetAllSchools() { DataSet ds = new DataSet(); try { LogIt.LogInfo("Getting schools."); using (ODBCClass o = new ODBCClass("MySql")) { var procName = "select SchoolID from SchoolInfo"; using (OdbcCommand oCommand = o.GetCommand(procName)) { using (OdbcDataAdapter oAdapter = new OdbcDataAdapter(oCommand)) { oAdapter.Fill(ds); } } } } catch (Exception ex) { var msg = $"Error getting schools: {ex.Message}"; LogIt.LogError(msg); } return(ds); }
public static List <AreaCode> AcquireFromResources() { try { var content = Properties.Resources.area_codes; var lol = content.Split(new string[] { "\r\n", "\n" }, StringSplitOptions.RemoveEmptyEntries).ToList(); //skip header: Area Code,Region lol.RemoveAt(0); _loac = new List <AreaCode> { }; foreach (var l in lol) { var los = l.Split(new char[] { ',' }); //var location = los[1]; //if (location.Length == 2) { // if (States.GetStateName(location) != null) { // location = States.GetStateName(location); // } //} //do I include non us/ca states? _loac.Add(new AreaCode { numberCode = los[0], stateCode = los[1] }); } return(_loac); } catch (Exception ex) { LogIt.E(ex); return(null); } }
/// <summary> /// verify work order belongs to job /// </summary> /// <param name="jobID"></param> /// <param name="woNo"></param> /// <returns>boolean indicating work order belongs to job</returns> private static bool valid_work_order(int jobID, string woNo, string connectionString) { bool isValid = false; string projFinalID = $"{jobID}-{woNo}"; try { using (SqlConnection conn = new SqlConnection(connectionString)) { LogIt.LogInfo($"Validating work order \"{woNo}\" for job {jobID}"); string cmdText = "SELECT COUNT(ProjectFinalID) FROM MLG.POL.tblProjectFinal where ProjectFinalID = @projFinalID"; using (SqlCommand cmd = new SqlCommand(cmdText, conn)) { cmd.Parameters.AddWithValue("@projFinalID", projFinalID); conn.Open(); int rows = (int)cmd.ExecuteScalar(); isValid = (rows > 0); } } } catch (Exception ex) { LogIt.LogError($"Error validating work order \"{woNo}\" for job {jobID}: {ex.Message}"); } return(isValid); }
private void lblSettings_Click(object sender, EventArgs e) { SettingsForm sf = new SettingsForm(); sf.StartPosition = FormStartPosition.CenterParent; sf.ShowDialog(); doc.Load(settingsFile); if (GetSettings()) { fromDate = DateTime.Today.AddDays(-fromDaysAgo); dtpFromDate.Value = fromDate; toDate = DateTime.Today.AddDays(-toDaysAgo); dtpToDate.Value = toDate; LogIt.LogInfo($"Got beginning and ending dates from settings file: FromDate={fromDate.ToShortDateString()}, ToDate={toDate.ToShortDateString()}"); CheckSelectedSchools(); this.btnPreview.Enabled = true; this.btnProcess.Enabled = true; } else { this.btnPreview.Enabled = false; this.btnProcess.Enabled = false; } }
/// <summary> /// updates timesheet totals for supplied timesheet IDs /// </summary> /// <param name="timesheetsUpdated">List of timesheet IDs to be updated</param> /// <param name="connectionString"></param> /// <returns></returns> private bool update_timesheet_totals(List <string> timesheetsUpdated, string connectionString) { bool result = false; string where = string.Join("','", timesheetsUpdated); string sql = "UPDATE ts SET ts.TotalHours = tse.HoursWorked, ts.RegHours = case when tse.HoursWorked <= 40 then tse.HoursWorked else 40 end, " + "ts.OTHours = case when tse.HoursWorked <= 40 then 0 else tse.HoursWorked - 40 end " + "FROM MLG.POL.tblWeeklyTimeSheets ts INNER JOIN " + "(SELECT WeeklyTimeSheetID, sum(HoursWorked) as HoursWorked FROM MLG.POL.tblWeeklyTimeSheetEntries GROUP BY WeeklyTimeSheetID) as tse " + $"ON tse.WeeklyTimeSheetID = ts.WeeklyTimeSheetID WHERE ts.WeeklyTimeSheetID in('{where}')"; try { using (SqlConnection conn = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand(sql, conn)) { conn.Open(); var recs = cmd.ExecuteNonQuery(); result = (recs >= 1); } } } catch (Exception ex) { string msg = $"Error updating timesheet totals: {ex.Message}"; Status = msg; LogIt.LogError(msg); } return(result); }
/// <summary> /// adds a timesheet entry for supplied timesheet ID /// </summary> /// <param name="timesheetId">8-digit hashed ID of timesheet to add hours to</param> /// <param name="jobId">AIMM job number</param> /// <param name="workOrder">AIMM work order number</param> /// <param name="startTime">Date-time work reported for</param> /// <param name="regularHours">Number of regular hours reported</param> /// <param name="overtimeHours">Number of overtime hours reported</param> /// <param name="doubleOvertimeHours">Number of double overtime hours reported</param> /// <param name="connectionString"></param> /// <returns></returns> private bool add_timesheet_detail(string timesheetId, int jobId, string workOrder, DateTime startTime, float regularHours, float overtimeHours, float doubleOvertimeHours, string connectionString) { bool result = false; string estID = $"{jobId}-{workOrder}"; float hours = regularHours + overtimeHours + doubleOvertimeHours; KeyValuePair <DateTime, DateTime> wkStartAndEnd = get_week_start_and_end(startTime, DayOfWeek.Wednesday); string workDate = startTime.Date.ToString("yyyy-MM-dd 00:00:00.000"); string weDate = wkStartAndEnd.Value.ToString("yyyy-MM-dd 00:00:00.000"); ; string sql = "INSERT INTO MLG.POL.tblWeeklyTimeSheetEntries (WeeklyTimeSheetID, JobID, HoursWorked, EstimateID, EstimateTypeID, TheDate, " + "Notes, PerformanceLevel, AttendCode, NPReasonCode, Correction, JobErrorID, WeekEndingDate) VALUES " + $"( '{timesheetId}', {jobId}, {hours}, '{estID}', null, '{workDate}', null, null, null, null, 0, null, '{weDate}')"; try { using (SqlConnection conn = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand(sql, conn)) { conn.Open(); var recs = cmd.ExecuteNonQuery(); result = (recs == 1); } } } catch (Exception ex) { string msg = $"Error adding timesheet detail for timesheet \"{timesheetId}\" for {startTime.ToShortDateString()}: {ex.Message}"; Status = msg; LogIt.LogError(msg); } return(result); }
public static string GetCountryCode(string ip, bool throwOnError = false, bool doNotWarnOnNotInDb = true) { try { var cr = maxmindDr.City(ip); //LogIt.D(or.Country.IsoCode + "|" + or.City.Name); return(cr.Country.IsoCode); } catch (Exception ex) { if (doNotWarnOnNotInDb && ex.Message.Contains("is not in the database")) { //LogIt.W(ip + "|" + ex.Message); } else { LogIt.W(ip + "|" + ex.Message); } if (throwOnError) { throw ex; } else { return(null); } } }
static void Main(string[] args) { LogIt log = null; if (log != null) { log("initial"); } // INVALID: log = LogDouble; // log = new LogIt(LogFancy); log = LogFancy; log += LogNormal; if (log != null) { log("blablabla"); } log -= LogFancy; if (log != null) { log("another"); } Console.ReadKey(); }
public static bool Execute( string AWSAccessKey, string AWSSecretKey, string fileKey, string bucketName, RegionEndpoint re, out string url ) { url = ""; try { using (var s3c = new AmazonS3Client( awsAccessKeyId: AWSAccessKey, awsSecretAccessKey: AWSSecretKey, region: re )) { var s3FileInfo = new Amazon.S3.IO.S3FileInfo(s3c, bucketName, fileKey); url = "https://s3.amazonaws.com/" + bucketName + "/" + fileKey; return(s3FileInfo.Exists); } } catch (Exception ex) { LogIt.E(ex); return(false); } }
private DataSet GetPaymentsForSchool(string school) { DataSet ds = new DataSet(); try { //if(Status != null) // Status += Environment.NewLine; status = $"Getting payments made"; LogIt.LogInfo(status); Status += Environment.NewLine + " " + status; using (ODBCClass o = new ODBCClass("MySql")) { var procName = "payments_made(?,?,?)"; var parms = new KeyValuePair <string, string>[] { new KeyValuePair <string, string>("_school", school), new KeyValuePair <string, string>("_fromDate", fromDate.ToString("yyyy-MM-dd")), new KeyValuePair <string, string>("_toDate", toDate.ToString("yyyy-MM-dd")) }; using (OdbcCommand oCommand = o.GetCommand(procName, parms)) { using (OdbcDataAdapter oAdapter = new OdbcDataAdapter(oCommand)) { oAdapter.Fill(ds); } } } } catch (Exception) { } return(ds); }
private void DebugLog(string message) { if (this.debug) { var now = Convert.ToString(CurrentTime()); //Console.WriteLine("[{0}] {1}", now, message); LogIt.D(message); } }
//this does not return state name... wonder why ic ommited public static string GetStateName(string areaCode) { try { return(loacUsCa.Where(ac => ac.numberCode == areaCode).Select(ac => ac.stateCode).FirstOrDefault()); } catch (Exception ex) { LogIt.E(ex); return(null); } }
public static string Execute(object o) { try { return(JsonConvert.SerializeObject(o)); } catch (Exception ex) { LogIt.E(ex); } return(""); }
public static void RemoveFromPool(WebProxy wp) { lock (mLouwp) { if (_louwp.Contains(wp)) { _louwp.Remove(wp); LogIt.D(wp.Address); } } }
public static bool IsDisposable(string email) { try { var disposableDomain = loDomains.Where(d => email.EndsWith(d, StringComparison.CurrentCultureIgnoreCase)).FirstOrDefault(); return(disposableDomain != null); } catch (Exception ex) { LogIt.E(ex); return(false); } }
public static void Execute() { try { foreach (var ci in CultureInfo.GetCultures(System.Globalization.CultureTypes.AllCultures).OrderBy(ci => ci.Name)) { LogIt.D(ci.Name + "|" + ci.EnglishName); } } catch (Exception ex) { LogIt.E(ex); } }
public static Coordinate Execute(string address) { var c = new Coordinate { g = Geocoder.Esri }; try { if (!string.IsNullOrEmpty(address) && !address.Equals("0")) { var uea = HttpUtility.UrlEncode(address.Trim()); //http://geocode.arcgis.com/arcgis/rest/services/World/GeocodeServer/find?text=1700 Penny ave washingtn dc&f=pjson&forStorage=false&maxLocations=1 var client = new RestClient("http://geocode.arcgis.com/"); var request = new RestRequest("/arcgis/rest/services/World/GeocodeServer/find?text=" + uea + "&f=pjson&forStorage=false&maxLocations=1", Method.GET); var response = client.Execute(request); if (response.StatusCode != System.Net.HttpStatusCode.OK) { LogIt.D(response.StatusCode + "|" + address); } else { var content = response.Content; dynamic json = Newtonsoft.Json.Linq.JObject.Parse(content); if (json.locations.Count > 0) { var geometry = json.locations[0].feature.geometry; if (geometry != null) { var lng = Convert.ToDecimal(geometry.x.Value); var lat = Convert.ToDecimal(geometry.y.Value); if ((lat != 0) && (lng != 0)) { c.lng = lng; c.lat = lat; } } var precision = json.locations[0].feature.attributes; if (precision != null) { var pc = precision.Score.Value; c.precision = Convert.ToString(pc); } } } } } catch (Exception ex) { LogIt.W(address); LogIt.E(ex); } return(c); }