public static List <Postal> FindAllPostals() { var result = new List <Postal>(); var connection = new System.Data.SqlClient.SqlConnection(_connectionString); connection.Open(); var command = new System.Data.SqlClient.SqlCommand("", connection); command.CommandText = @" Select * from [PostalTable]"; var reader = command.ExecuteReader(); while (reader.Read()) { Postal item = new Postal(); //item.ID = reader["ID"].ToString(); item.PostalCode = Convert.ToInt32(reader["PostalCode"]); item.Section = reader["Section"].ToString(); item.English = reader["English"].ToString(); result.Add(item); } connection.Close(); return(result); }
/// <summary> /// Initializes a new instance of the <see cref="AbstractCityResponse" /> class. /// </summary> protected AbstractCityResponse() { City = new City(); Location = new Location(); Postal = new Postal(); Subdivisions = new List <Subdivision>(); }
protected virtual void CreateArtists(UnitOfWork session) { Artist artist = null; MovieArtistLine line = MovieArtistLine.GetDirector(session); artist = CreateArtist(session, "James", "Cameron"); Avatar.AddArtist(artist, line); artist = CreateArtist(session, "Uwe", "Boll"); Postal.AddArtist(artist, MovieArtistLine.GetDirector(session)); }
public SendEmailResponse SendEmail(Postal.Email email, ILogger log) { var output = new SendEmailResponse(); #if !DEBUG try { #endif // Process email with Postal var emailService = ServiceLocator.Current.GetInstance<Postal.IEmailService>(); using (var message = emailService.CreateMailMessage(email)) { var htmlView = message.AlternateViews.FirstOrDefault(x => x.ContentType.MediaType.ToLower() == "text/html"); if (htmlView != null) { string body = new StreamReader(htmlView.ContentStream).ReadToEnd(); // move ink styles inline with PreMailer.Net var result = PreMailer.Net.PreMailer.MoveCssInline(body, false, "#ignore"); htmlView.ContentStream.SetLength(0); var streamWriter = new StreamWriter(htmlView.ContentStream); streamWriter.Write(result.Html); streamWriter.Flush(); htmlView.ContentStream.Position = 0; } // send email with default smtp client. (the same way as Postal) using (var smtpClient = new SmtpClient()) { try { smtpClient.Send(message); output.Success = true; } catch (SmtpException exception) { _logger.Error("Exception: {0}, inner message {1}",exception.Message,(exception.InnerException!=null) ? exception.InnerException.Message : string.Empty); output.Success = false; output.Exception = exception; } } } #if !DEBUG } catch (Exception ex) { _logger.Error("Error sending email", ex); output.Exception = ex; } #endif return output; }
public IEnumerable <ValidationResult> Validate(ValidationContext validationContext) { var results = new List <ValidationResult>(); if ((new[] { "US", "CA" }.Contains(CountryCode)) && string.IsNullOrWhiteSpace(Postal)) { results.Add(new ValidationResult("Tape Address Postal Code is required.", new[] { "Postal" })); } if (CountryCode == "US" && Postal != null && !Regex.Match(Postal, @"^\d{1,5}(\-\d{4})?$").Success) { results.Add(new ValidationResult("Tape Address Postal Code is not valid.", new[] { "Postal" })); } if ((new[] { "US", "CA", "BR", "AU", "IT", "MX" }.Contains(CountryCode)) && string.IsNullOrWhiteSpace(StateProvince)) { results.Add(new ValidationResult("Tape Address State/Province is required.", new[] { "StateProvince" })); } if (CountryCode == "CA" && !string.IsNullOrWhiteSpace(Postal)) { if (!Regex.Match(Postal, @"(\D\d\D\s\d\D\d)").Success) { results.Add(new ValidationResult("Tape Address Postal Code is not valid.", new[] { "Postal" })); } var canadaPostalValidations = new[] { new Tuple <string, string> ("T", "AB"), new Tuple <string, string> ("V", "BC"), new Tuple <string, string> ("R", "MB"), new Tuple <string, string> ("E", "NB"), new Tuple <string, string> ("A", "NL"), new Tuple <string, string> ("B", "NS"), new Tuple <string, string> ("X", "NT"), new Tuple <string, string> ("K", "ON"), new Tuple <string, string> ("L", "ON"), new Tuple <string, string> ("M", "ON"), new Tuple <string, string> ("N", "ON"), new Tuple <string, string> ("P", "ON"), new Tuple <string, string> ("C", "PE"), new Tuple <string, string> ("G", "QC"), new Tuple <string, string> ("H", "QC"), new Tuple <string, string> ("J", "QC"), new Tuple <string, string> ("S", "SK"), new Tuple <string, string> ("Y", "YT") }; if (!canadaPostalValidations.Any(x => x.Item1 == Postal.Substring(0, 1).ToUpper() && StateProvince == x.Item2)) { results.Add(new ValidationResult("Tape Address State/Province and Postal Code is not a valid combination.", new[] { "Postal" })); } } return(results); }
/* * Function to change a customers information. * This function will recieve a customer (a mix model). First the function will check if the customer * exists in the database for security reasons. If it exists the user data will be overwritten. * This function will also check if the new zipcode entered by the user exists or not. If it does not * exists it will be added to the database. */ public bool editUser(Customer inCustomer) { try { using (var db = new ModelContext()) { // Find the user User selectUser = db.Users.FirstOrDefault (u => u.personalIdentification == inCustomer.personalIdentification); // User does not exists or something went wrong. if (selectUser == null) { return(false); } else { // Overwrite old data with new data. selectUser.firstname = inCustomer.firstname; selectUser.lastname = inCustomer.lastname; selectUser.address = inCustomer.address; selectUser.phoneNumber = inCustomer.phoneNumber; selectUser.email = inCustomer.email; // Find the postal. Postal verifyPostal = db.Postals.FirstOrDefault (p => p.postalCode == inCustomer.zipCode); // Postal does not exist. if (verifyPostal == null) { // Adding new posta to database and merge with customer. Postal newPostal = new Postal(); newPostal.postalCode = inCustomer.zipCode; newPostal.city = inCustomer.city; db.Postals.Add(newPostal); selectUser.postalCode = newPostal; } else { // Postal exists. Merge with customer. selectUser.postalCode = verifyPostal; } db.SaveChanges(); return(true); } } } catch (Exception error) { logErrorToFile(error); return(false); } }
// GET: api/Assets/5 public IHttpActionResult GetHotel(int id) { //Asset asset =(Asset) db.Asset.Find(id); Postal item = _RepositoryHandlerCollection.PostalHandler.GetById(id); if (item == null) { return(NotFound()); } return(Ok(item)); }
public void Test2() { var def = MessageParser.ParseText(Test); var postal = new Postal(); postal.OutputDir = AppDomain.CurrentDomain.BaseDirectory; var codeDOM = postal.GenerateCodeDOM("Test.postal", def); var code = postal.GenerateCSharpCode(codeDOM); var header = postal.GenerateHeaderFile(def); File.WriteAllText("Test.cs", code); var proto = postal.GenerateProtoFile("Test.cs", postal.GenerateCodeDOM("Test.postal", def), def); }
/// <summary> /// Constructor /// </summary> public CityIspOrgResponse( City city = null, Continent continent = null, Country country = null, Location location = null, Model.MaxMind maxMind = null, Postal postal = null, Country registeredCountry = null, RepresentedCountry representedCountry = null, List <Subdivision> subdivisions = null, Traits traits = null) : base( city, continent, country, location, maxMind, postal, registeredCountry, representedCountry, subdivisions, traits) { }
public CityResponse( City city = null, Continent continent = null, Country country = null, Location location = null, [Parameter("maxmind")] Model.MaxMind maxMind = null, Postal postal = null, [Parameter("registered_country")] Country registeredCountry = null, [Parameter("represented_country")] RepresentedCountry representedCountry = null, IEnumerable <Subdivision> subdivisions = null, [Parameter("traits", true)] Traits traits = null) : base( city, continent, country, location, maxMind, postal, registeredCountry, representedCountry, subdivisions, traits) { }
public List <Field> GetFields() { List <Field> fields = GetEmptyFields(); fields[0].SetValue(Name); fields[1].SetValue(Surname); fields[2].SetValue(Dni.ToString()); fields[3].SetValue(Mail); fields[4].SetValue(Tel.ToString()); fields[5].SetValue(Dir); fields[6].SetValue(City); fields[7].SetValue(Postal.ToString()); fields[8].SetValue(BirthDate.ToString("yyyy-MM-dd HH.mmm:ss:l")); fields[9].SetValue(Endabled.ToString()); fields[10].SetValue(User); return(fields); }
// GET: Postal public ActionResult Index(string search = "", int PostalCode = -1) { var postallocations = RV.Databases.PostalLocationDatabase.FindAllPostalLocation(); var postals = RV.Databases.PostalDatabase.FindAllPostals(); if (postallocations.Count == 0) { postallocations = PostalData.GetPostalLocation(); RV.Databases.PostalLocationDatabase.Create(postallocations); } if (postals.Count == 0) { postals = PostalData.GetPostal(); RV.Databases.PostalDatabase.Create(postals); } if (!string.IsNullOrEmpty(search)) { postals = postals .Where(x => x.PostalCode.ToString().Contains(search) || x.Section.Contains(search)) .ToList(); } ViewBag.Search = search; if (PostalCode != -1) { foreach (var postallocation in postallocations) { if (postallocation.PostalCode == PostalCode) { PostalController.postallocation = postallocation; } } foreach (var postal in postals) { if (postal.PostalCode == PostalCode) { PostalController.postal = postal; } } } //ViewBag.Stations = stations; return(View(postals)); }
public List <Field> GetFields() { List <Field> f = GetEmptyFields(); f[0].SetValue(Cuit); f[1].SetValue(Rsocial); f[2].SetValue(Mail); f[3].SetValue(Tel.ToString()); f[4].SetValue(Domicilio); f[5].SetValue(Localidad); f[6].SetValue(Ciudad); f[7].SetValue(Rubro); f[8].SetValue(Postal.ToString()); f[9].SetValue(ProvNombre); f[10].SetValue(Endabled.ToString()); f[11].SetValue(user); return(f); }
/// <summary> /// Initializes a new instance of the <see cref="AbstractCityResponse" /> class. /// </summary> protected AbstractCityResponse( City city = null, Continent continent = null, Country country = null, Location location = null, Model.MaxMind maxMind = null, Postal postal = null, Country registeredCountry = null, RepresentedCountry representedCountry = null, IEnumerable <Subdivision> subdivisions = null, Traits traits = null) : base(continent, country, maxMind, registeredCountry, representedCountry, traits) { City = city ?? new City(); Location = location ?? new Location(); Postal = postal ?? new Postal(); Subdivisions = subdivisions != null ? new List <Subdivision>(subdivisions) : new List <Subdivision>(); }
/// <summary> /// Method for populating the database with address data. /// </summary> /// <param name="staticMapData">The staticdata object.</param> private void UpdateDatabase(StaticMapData staticMapData) { using (var context = new InformationContext()) { Dispatcher.Invoke(() => { lblNumberOfRecords.Content = context.Persons.Count().ToString(); }); Postal postal = context.Postals.Where(x => x.PostalCode == staticMapData.PostalCode && x.City == staticMapData.City).FirstOrDefault(); if (postal == null) { context.Postals.Add(staticMapData.GetPostal()); context.SaveChanges(); return; } Address address = context.Addresses.Where(x => x.Street == staticMapData.Addr1 && x.PostalCode == staticMapData.PostalCode).FirstOrDefault(); if (address == null) { postal.Addresses.Add(staticMapData.GetAddress(postal)); context.SaveChanges(); return; } Person person = context.Persons.Where(x => x.DataId.ToString() == staticMapData.Id).FirstOrDefault(); if (person == null) { address.Persons.Add(staticMapData.GetPerson(address)); context.SaveChanges(); } } }
private bool Send(Postal.Email emailMessage) { var result = _emailDispatcher.SendEmail(emailMessage, Log); if (result.Success) return true; Log.Error(result.Exception.Message, result.Exception); return false; }
private bool AttemptSendOf(Postal.Email emailMessage) { try { return Send(emailMessage); } catch (Exception ex) { Log.Error("Error occured when sending ResetPassword emailMessage.", ex); return false; } }
public SendEmailResponse SendEmail(Postal.Email email) { var log = LogManager.GetLogger(); return SendEmail(email, log); }
public SendEmailResponse SendEmail(Postal.Email email) { return SendEmail(email, _logger); }
// // Oppsummering: // Representerer testdata til prosjektet. Brukere, kontoer og transaksjoner opprettes her. // public static void initialize_test_data() { DB daldb = new DB(); // Open connection to Database using (var db = new ModelContext()) { // Get user var exist = from a in db.Users where a.firstname == "Ola" select a; DateTime setDate = DateTime.Now; // Check if user exist if (!exist.Any()) { try { string[] salt = { daldb.Create_Salt(), daldb.Create_Salt(), daldb.Create_Salt() }; Postal newPostal = null; // Postalcode newPostal = new Postal { postalCode = "0707", city = "Oslo" }; // accountType AccountType newAccountType = new AccountType { card = true, interest = 3.00, limit = 10000, yearlyFee = 0 }; // User1 account Account account1 = new Account { accountNumber = "44444444444", name = "Savings account", balance = 10000, accountType = newAccountType, active = true }; // User2 account1 Account account2_1 = new Account { accountNumber = "11111111111", name = "Savings account", balance = 4100.50, accountType = newAccountType, active = true }; // User2 account2 Account account2_2 = new Account { accountNumber = "22222222222", name = "Checkings account", balance = 1533.40, accountType = newAccountType, active = true }; // User2 account3 Account account2_3 = new Account { accountNumber = "33333333333", name = "Loan account", balance = 0.00, accountType = newAccountType, active = false }; // User3 account Account account3 = new Account { accountNumber = "55555555555", name = "Savings account", balance = 2500, accountType = newAccountType, active = true }; // Transaction from user 1 account to user 2 account Transaction transaction1 = new Transaction { date = setDate.Date, fromAccount = account1, toAccount = account2_1, amount = 500, message = "Vi er skuls", isTransferred = true }; // Transaction from user 2 account too user 3 account Transaction transaction2 = new Transaction { date = setDate.Date, fromAccount = account2_1, toAccount = account3, amount = 250, message = "Mat greier", isTransferred = true }; // Transaction from user 3 account too user 1 account Transaction transaction3 = new Transaction { date = setDate.Date, fromAccount = account3, toAccount = account1, amount = 1500, message = "Nasty stuff", isTransferred = false }; // Add user 1 User user1 = new User { personalIdentification = "11111111111", firstname = "Ola", lastname = "Nordmann", address = "Nordmannveien 32", postalCode = newPostal, phoneNumber = "07070707", email = "*****@*****.**", salt = salt[0], password = daldb.Create_Hash("password" + salt[0]), active = true, accounts = new List <Account> { account1 } }; // Add user 2 User user2 = new User { personalIdentification = "22222222222", firstname = "Kari", lastname = "Nordmann", address = "Nordmannveien 32", postalCode = newPostal, phoneNumber = "06060606", email = "*****@*****.**", salt = salt[1], password = daldb.Create_Hash("password" + salt[1]), active = true, accounts = new List <Account> { account2_1, account2_2, account2_3 } }; // Add user 3 User user3 = new User { personalIdentification = "33333333333", firstname = "Nils", lastname = "Nordmann", address = "Nordmannveien 32", postalCode = newPostal, phoneNumber = "05050505", email = "*****@*****.**", salt = salt[2], password = daldb.Create_Hash("password3" + salt[2]), active = true, accounts = new List <Account> { account3 } }; Admin admin1 = new Admin { personalIdentification = "22222222222" }; db.Admins.Add(admin1); // Add Transanctions db.Transactions.Add(transaction1); db.Transactions.Add(transaction2); db.Transactions.Add(transaction3); // Add Accounts db.Accounts.Add(account1); db.Accounts.Add(account2_1); db.Accounts.Add(account2_2); db.Accounts.Add(account2_3); db.Accounts.Add(account3); // Add Users db.Users.Add(user1); db.Users.Add(user2); db.Users.Add(user3); // Save data to Database db.SaveChanges(); } catch (Exception error) { Console.Write(error); } } } }
/// <summary> /// Send a simple HTML based email /// </summary> private void Send(Postal.Email email) { ////create a new message object //var message = SendGrid.GenerateInstance(); //message.AddTo(to); ////set the sender //message.From = new MailAddress(from); ////set the message body //message.Html = CreateHtmlMailFromView(view); // "<html><p>Hello</p><p>World</p></html>"; //message.Text = "sdfsdfsdf"; ////set the message subject //message.Subject = "Hello World HTML Test"; ////enable Open Tracking //message.EnableOpenTracking(); ////enable clicktracking //message.EnableClickTracking(false); ////enable spamcheck //message.EnableSpamCheck(); ////create an instance of the SMTP transport mechanism //var transportInstance = SMTP.GenerateInstance(new NetworkCredential("username", "password")); ////send the mail //transportInstance.Deliver(message); }
private async void RecallLookup_Clicked(object sender, EventArgs e) { try { bool connection = CrossConnectivity.Current.IsConnected; if (connection) { Indicator.IsRunning = true; Indicator.IsVisible = true; if (userZip.Text != null && userZip.Text != "") { HttpClient client = new HttpClient(); /*added an exception for iOS in info.plist https://docs.microsoft.com/en-us/xamarin/ios/app-fundamentals/ats#optout */ string dictionaryEndpoint = "http://api.geonames.org/postalCodeSearchJSON?formatted=true&country=US&postalcode=" + userZip.Text + "&username=abezat"; Uri dictionaryUri = new Uri(dictionaryEndpoint); HttpResponseMessage response = await client.GetAsync(dictionaryEndpoint); if (response.IsSuccessStatusCode) { string jsonString = await response.Content.ReadAsStringAsync(); var myPostal = Postal.FromJson(jsonString); PostalCode result = myPostal.PostalCodes.First(); string ZipToCity = result.PlaceName; userEntry.Text = ZipToCity; Analytics.TrackEvent("Successfully Retrived zip code info"); } } if (userEntry.Text != null && userEntry.Text != "") { string d1 = D1.Date.ToString("yyyyMMdd"); string d2 = D2.Date.ToString("yyyyMMdd"); //string userString = userEntry.Text; //userString = userString.ToLower(); HttpClient client = new HttpClient(); string dictionaryEndpoint = "https://api.fda.gov/drug/enforcement.json?search=report_date:[" + d1 + "+TO+" + d2 + "]+AND+city:" + userEntry.Text + "+AND+status:ongoing&limit=100"; Uri dictionaryUri = new Uri(dictionaryEndpoint); HttpResponseMessage response = await client.GetAsync(dictionaryEndpoint); if (response.IsSuccessStatusCode) { Indicator.IsRunning = false; Indicator.IsVisible = false; string jsonString = await response.Content.ReadAsStringAsync(); var myRecalls = MyRecalls.FromJson(jsonString); //List<Define> myDefinitions = JsonConvert.DeserializeObject<List<Define>>(jsonContent); //if (myRecalls.Meta.Results.Total > 0) //{ myRecallsCollection.Clear(); myRecalls.Results.ForEach(myRecallsCollection.Add); RecallsListView.ItemsSource = myRecallsCollection; RecallsListView.IsVisible = true; userLabel.IsVisible = false; Analytics.TrackEvent("Successfully Retrived recall info"); //RecallsListView_Refreshing(RecallsListView, null); //} //else //{ // userLabel.Text = "NO RECALLS IN YOUR CITY WITHIN LAST YEAR"; //strings of letters that are not words, but still return success // userLabel.IsVisible = true; // RecallsListView.IsVisible = false; //} } else { Indicator.IsRunning = false; Indicator.IsVisible = false; userLabel.Text = "YOUR ENTRY RETURNED ZERO RESULTS"; //for empty strings userLabel.IsVisible = true; RecallsListView.IsVisible = false; } } else { Indicator.IsRunning = false; Indicator.IsVisible = false; userLabel.Text = "PLEASE ENTER A CITY NAME"; userLabel.IsVisible = true; } } else { Indicator.IsRunning = false; Indicator.IsVisible = false; await DisplayAlert("No Internet", "No Internet Connection Detected", "OK"); userLabel.IsVisible = true; RecallsListView.IsVisible = false; } var s = userZip.Text; var s2 = userEntry.Text; if ((userZip.Text == null || userZip.Text == "") && (userEntry.Text == null || userEntry.Text == "")) { userSearch.IsVisible = false; } else { userSearch.IsVisible = true; userSearch.Text = "You've searched: " + userEntry.Text; } if (userZip.Text != null && userZip.Text != "") { userSearch.Text += ", " + userZip.Text; } userEntry.Text = null; userZip.Text = null; } catch (Exception exception) { Crashes.TrackError(exception); } }
public async Task saveFile(List <IFormFile> files, string directory, string subDirectory, CancellationToken cancellationToken) { subDirectory = subDirectory ?? string.Empty; var target = Path.Combine(directory, subDirectory); Directory.CreateDirectory(target); foreach (IFormFile file in files) { if (file.Length <= 0) { return; } var filePath = Path.Combine(target, file.FileName); using (var stream = new FileStream(filePath, FileMode.Create)) { await file.CopyToAsync(stream, cancellationToken); try { // add to read encoded 1252 values using (var package = new ExcelPackage(stream)) { // Express worksheet ExcelWorksheet worksheet = package.Workbook.Worksheets["Express"]; int colCount = worksheet.Dimension.End.Column; //get Column Count int rowCount = worksheet.Dimension.End.Row; List <Express> lsShippingExpress = new List <Express>(); for (int row = 2; row < rowCount; row++) { Express shippingExpress = new Express(); shippingExpress.id = row - 1; for (int col = 1; col < colCount; col++) { string currValue = worksheet.Cells[row, col].Value == null ? string.Empty : worksheet.Cells[row, col].Value.ToString(); switch (col) { case 1: // break if there is no fake rows if (!currValue.Equals("Express", StringComparison.OrdinalIgnoreCase)) { goto ExpressEnd; } shippingExpress.type = currValue; break; case 2: shippingExpress.trackable = currValue; break; case 3: shippingExpress.service_level = currValue; break; case 4: shippingExpress.country = currValue; break; case 5: shippingExpress.country_code = currValue; break; case 6: shippingExpress.rate_flag = NumberUtil.convertStringToInt(currValue); break; case 7: shippingExpress.weight = NumberUtil.convertStringToDouble(currValue); break; case 8: shippingExpress.dhl_express = NumberUtil.convertStringToDouble(currValue); break; case 9: shippingExpress.sf_economy = NumberUtil.convertStringToDouble(currValue); break; case 10: shippingExpress.ninja_van = NumberUtil.convertStringToDouble(currValue); break; case 11: shippingExpress.zone = NumberUtil.convertStringToInt(currValue); break; } } lsShippingExpress.Add(shippingExpress); } ExpressEnd: { Console.WriteLine(lsShippingExpress.Count); // delete everything in the database await _shippingExpressRepository.deleteAllRecords(cancellationToken); var result = await _shippingExpressRepository.insertRecords(lsShippingExpress, cancellationToken); } // process bulk file worksheet = package.Workbook.Worksheets["Bulk Mail"]; colCount = worksheet.Dimension.End.Column; //get Column Count rowCount = worksheet.Dimension.End.Row; List <Bulk> lsShippingBulk = new List <Bulk>(); for (int row = 4; row < rowCount; row++) { Bulk shippingBulk = new Bulk(); shippingBulk.id = row - 3; for (int col = 1; col < colCount; col++) { string currValue = worksheet.Cells[row, col].Value == null ? string.Empty : worksheet.Cells[row, col].Value.ToString(); switch (col) { case 1: // break if there is no fake rows if (!currValue.Equals("Bulk", StringComparison.OrdinalIgnoreCase)) { goto BulkEnd; } shippingBulk.type = currValue; break; case 2: shippingBulk.trackable = currValue; break; case 3: shippingBulk.service_level = currValue; break; case 4: shippingBulk.country = currValue; break; case 5: shippingBulk.country_code = currValue; break; case 6: shippingBulk.item_weight_kg = NumberUtil.convertStringToDouble(currValue); break; case 7: shippingBulk.total_weight_kg = NumberUtil.convertStringToDouble(currValue); break; case 8: shippingBulk.ascendia_item_rate = NumberUtil.convertStringToDouble(currValue); break; case 9: shippingBulk.ascendia_rate_per_kg = NumberUtil.convertStringToDouble(currValue); break; case 10: shippingBulk.singpost_item_rate = NumberUtil.convertStringToDouble(currValue); break; case 11: shippingBulk.singpost_rate_per_kg = NumberUtil.convertStringToDouble(currValue); break; case 12: shippingBulk.dai_item_rate = NumberUtil.convertStringToDouble(currValue); break; case 13: shippingBulk.dai_rate_per_kg = NumberUtil.convertStringToDouble(currValue); break; } } lsShippingBulk.Add(shippingBulk); } BulkEnd: { Console.WriteLine(lsShippingBulk.Count); // delete everything in the database await _shippingBulkRepository.deleteAllRecords(cancellationToken); var result = await _shippingBulkRepository.insertRecords(lsShippingBulk, cancellationToken); } // process bulk file worksheet = package.Workbook.Worksheets["Postal"]; colCount = worksheet.Dimension.End.Column; //get Column Count rowCount = worksheet.Dimension.End.Row; List <Postal> lsShippingPostal = new List <Postal>(); for (int row = 4; row < rowCount; row++) { Postal shippingPostal = new Postal(); shippingPostal.id = row - 3; for (int col = 1; col < colCount; col++) { string currValue = worksheet.Cells[row, col].Value == null ? string.Empty : worksheet.Cells[row, col].Value.ToString(); switch (col) { case 1: // break if there is no fake rows if (!currValue.Equals("Postal", StringComparison.OrdinalIgnoreCase)) { goto PostalEnd; } shippingPostal.type = currValue; break; case 2: shippingPostal.trackable = currValue; break; case 3: shippingPostal.service_level_days = currValue; break; case 4: shippingPostal.country = currValue; break; case 5: shippingPostal.country_code = currValue; break; case 6: shippingPostal.item_weight_kg = NumberUtil.convertStringToDouble(currValue); break; case 7: shippingPostal.singpost_item_rate = NumberUtil.convertStringToDouble(currValue); break; case 8: shippingPostal.singpost_rate_per_kg = NumberUtil.convertStringToDouble(currValue); break; } } lsShippingPostal.Add(shippingPostal); } PostalEnd: { Console.WriteLine(lsShippingPostal.Count); // delete everything in the database await _shippingPostalRepository.deleteAllRecords(cancellationToken); var result = await _shippingPostalRepository.insertRecords(lsShippingPostal, cancellationToken); } } } catch (Exception ex) { Console.WriteLine(ex); } } } }