private static void CreateFakeData(AlbumManager albumManager) { if (albumManager.Query().Any() == false) { for (int i = 0; i < 5; i++) { albumManager.Create(new Album { Name = NameData.GetCompanyName(), Price = (decimal)NumberData.GetDouble() * NumberData.GetNumber(100, 4000), IsSales = BooleanData.GetBoolean(), Year = NumberData.GetNumber(1980, DateTime.Now.Year) }); } Console.WriteLine("Sample data created. Please enter for continue.."); Console.WriteLine(); Console.ReadKey(); } }
protected override void Seed(ZeroDbContext context) { var admin = new ApplicationUser() { Id = 1, FirstName = "Ekin", LastName = "Memiş", Email = "*****@*****.**", Password = "******", Active = true, Deleted = false, }; context.ApplicationUser.AddOrUpdate(admin); Random rnd = new Random(); for (int i = 0; i < 100; i++) { Customer customer = new Customer { Id = i, Active = true, DateOfBirth = DateTimeData.GetDatetime(), Deleted = false, Email = NetworkData.GetEmail(), FirstName = NameData.GetFirstName(), LastName = NameData.GetSurname(), PalceOfBirth = FakeData.PlaceData.GetAddress(), PhoneNumber = PhoneNumberData.GetPhoneNumber(), TurkishIdentityNumber = NumberData.GetDouble().ToString(), }; context.Customer.AddOrUpdate(customer); Employee employee = new Employee { Id = i, Active = true, DateOfBirth = DateTimeData.GetDatetime(), Deleted = false, Email = NetworkData.GetEmail(), FirstName = NameData.GetFirstName(), LastName = NameData.GetSurname(), PalceOfBirth = FakeData.PlaceData.GetAddress(), PhoneNumber = PhoneNumberData.GetPhoneNumber(), TurkishIdentityNumber = NumberData.GetDouble().ToString(), Sallary = NumberData.GetNumber(), Title = NameData.GetCompanyName() }; context.Employee.AddOrUpdate(employee); AppointmentType appointmentType = new AppointmentType { Id = i, DefaultSeanceQuantity = NumberData.GetNumber(1, 10), Name = TextData.GetAlphabetical(5), Deleted = false, }; context.AppointmentType.AddOrUpdate(appointmentType); Appointment appointment = new Appointment { Id = i, Deleted = false, StartDate = DateTimeData.GetDatetime(), EndDate = DateTimeData.GetDatetime(), Price = NumberData.GetNumber(), PriceIncludedTax = NumberData.GetNumber(), Name = TextData.GetAlphabetical(5), AppointmentStatusId = 0, AppointmentTypeId = rnd.Next(100), }; context.Appointment.AddOrUpdate(appointment); } }
private static AllTypesModel GenerateSimpleModel(Random random, int min, int max) { var itemToAdd = new AllTypesModel { Long = NumberData.GetNumber(min, max), LongNullable = RandomiseNullable(NumberData.GetNumber(min, max)), #if USE_UTYPES ULong = (ulong)NumberData.GetNumber(0, max), ULongNullable = RandomiseNullable((ulong)NumberData.GetNumber(0, max)), #else ULong = (long)NumberData.GetNumber(0, max), ULongNullable = (long?)RandomiseNullable(NumberData.GetNumber(0, max)), #endif Integer = random.Next(min, max), IntegerNullable = RandomiseNullable(FakeData.NumberData.GetNumber(min, max)), #if USE_UTYPES UInt = (uint)NumberData.GetNumber(0, max), UIntNullable = (uint?)RandomiseNullable(NumberData.GetNumber(0, max)), #else UInt = (int)NumberData.GetNumber(0, max), UIntNullable = (int?)RandomiseNullable(NumberData.GetNumber(0, max)), #endif DoubleProperty = NumberData.GetDouble(), DoubleNullable = RandomiseNullable(NumberData.GetDouble()), Float = (float)NumberData.GetDouble(), FloatNullable = RandomiseNullable((float)NumberData.GetDouble()), DecimalProperty = (decimal)NumberData.GetDouble(), DecimalNullable = (decimal?)RandomiseNullable(NumberData.GetDouble()), Short = (short)NumberData.GetNumber(min, max), ShortNullable = (short?)(NumberData.GetNumber(min, max)), #if USE_UTYPES UShort = (ushort)NumberData.GetNumber(0, max), UShortNullable = (ushort?)RandomiseNullable(NumberData.GetNumber(0, max)), #else UShort = (short)NumberData.GetNumber(0, max), UShortNullable = (short?)RandomiseNullable(NumberData.GetNumber(0, max)), #endif ByteProperty = RandomByte(), ByteNullable = RandomiseNullable(RandomByte()), #if USE_STYPES SByteProperty = RandomSByte(), SByteNullable = RandomiseNullable(RandomSByte()), #else SByteProperty = RandomByte(), SByteNullable = RandomiseNullable(RandomByte()), #endif #if USE_CHARTYPE CharProperty = FakeData.TextData.GetAlphabetical(1)[0], CharNullable = RandomiseNullable(FakeData.TextData.GetAlphabetical(1)[0]), #else CharProperty = FakeData.TextData.GetAlphabetical(1)[0].ToString(), CharNullable = RandomiseNullable(TextData.GetAlphaNumeric(1), 0.3), #endif BooleanProperty = BooleanData.GetBoolean(), BooleanNullable = RandomiseNullable(BooleanData.GetBoolean()), StringProperty = RandomiseNullable(TextData.GetAlphaNumeric(NumberData.GetNumber(0, 20)), 0.3), DateTimeProperty = RandomDate(max), DateTimeNullable = RandomiseNullable(RandomDate(max)), #if USE_DTOFFSET DateTimeOffsetProperty = RandomDateTimeOffset(max), DateTimeOffsetNullable = RandomiseNullable(RandomDateTimeOffset(max)) #else DateTimeOffsetProperty = RandomDate(max), DateTimeOffsetNullable = RandomiseNullable(RandomDate(max)), #endif }; return(itemToAdd); }
public IActionResult ExcelExport() { // https://steemit.com/utopian-io/@haig/how-to-create-excel-spreadsheets-using-npoi var workbook = new HSSFWorkbook(); var sheet = workbook.CreateSheet("Sheet 1"); IFont fontBold = workbook.CreateFont(); fontBold.Boldweight = (short)FontBoldWeight.Bold; var headerCellStyle = workbook.CreateCellStyle(); headerCellStyle.SetFont(fontBold); var header = sheet.CreateRow(0); ICell col1 = header.CreateCell(0); col1.CellStyle = headerCellStyle; col1.SetCellValue("Fullname"); ICell col2 = header.CreateCell(1); col2.CellStyle = headerCellStyle; col2.SetCellValue("Country"); ICell col3 = header.CreateCell(2); col3.CellStyle = headerCellStyle; col3.SetCellValue("Email"); ICell col4 = header.CreateCell(3); col4.CellStyle = headerCellStyle; col4.SetCellValue("Numbers"); ICell col5 = header.CreateCell(4); col5.CellStyle = headerCellStyle; col5.SetCellValue("Datetime"); ICell col6 = header.CreateCell(5); col6.CellStyle = headerCellStyle; col6.SetCellValue("Sentence"); var currencyCellStyle = workbook.CreateCellStyle(); currencyCellStyle.Alignment = HorizontalAlignment.Right; currencyCellStyle.DataFormat = workbook.CreateDataFormat().GetFormat("₺#.##0,00");; int length = 50; for (int i = 0; i < length; i++) { var row = sheet.CreateRow(i + 1); row.CreateCell(0).SetCellValue(NameData.GetFullName()); row.CreateCell(1).SetCellValue(PlaceData.GetCountry()); row.CreateCell(2).SetCellValue(NetworkData.GetEmail()); ICell numberCell = row.CreateCell(3); numberCell.CellStyle = currencyCellStyle; numberCell.SetCellValue(NumberData.GetDouble() * 1000); row.CreateCell(4).SetCellValue(DateTimeData.GetDatetime().ToShortDateString()); row.CreateCell(5).SetCellValue(TextData.GetSentence()); } var totalRow = sheet.CreateRow(length + 1); ICell totalCell = totalRow.CreateCell(3); ICellStyle totalCellStyle = workbook.CreateCellStyle(); totalCellStyle.CloneStyleFrom(sheet.GetRow(length).GetCell(3).CellStyle); totalCell.CellStyle = totalCellStyle; totalCell.CellStyle.SetFont(fontBold); totalCell.SetCellType(CellType.Formula); totalCell.CellFormula = $"SUM(D2:D{length + 1})"; // Headercell den sonrası. string root = _environment.WebRootPath; string folder = Path.Combine(root, "Excels"); string filename = "f_" + Guid.NewGuid().ToString() + ".xls"; string file = Path.Combine(folder, filename); if (Directory.Exists(folder) == false) { Directory.CreateDirectory(folder); } using (var fileStream = new FileStream(file, FileMode.Create)) { workbook.Write(fileStream); } return(File("~/Excels/" + filename, "application/vnd.ms-excel")); }