public MemberService(
ApplicationUserManager userManager,
DanceClassDbContext dbContext,
IMapper mapper,
IConfigurationProvider mappingConfig) : base(userManager, dbContext, mapper, mappingConfig)
{
}
public ClassService(
DanceClassDbContext dbContext,
IMapper mapper,
IConfigurationProvider mappingConfig
) : base(dbContext, mapper)
{
_mappingConfig = mappingConfig;
}
public UserService(
ApplicationUserManager userManager,
DanceClassDbContext dbContext,
IMapper mapper,
IConfigurationProvider mappingConfig) : base(dbContext, mapper)
{
_userManager = userManager;
_mappingConfig = mappingConfig;
}
public BaseService(DanceClassDbContext dbContext, IMapper mapper)
{
_dbContext = dbContext;
_mapper = mapper;
}
public WeeklyScheduleReportService(DanceClassDbContext dbContext, IMapper mapper, IConfigurationProvider mappingConfig) : base(dbContext, mapper)
{
_mappingConfig = mappingConfig;
}
public ApplicationUserStore(DanceClassDbContext context) : base(context)
{
}
static void Main(string[] args)
{
_Application app = new Application();
Workbook book = null;
Worksheet sheet = null;
Range range = null;
try
{
app.Visible = false;
app.ScreenUpdating = false;
app.DisplayAlerts = false;
string filePath = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), @"MasterSheet.xlsx");
book = app.Workbooks.Open(filePath, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
sheet = (Worksheet)book.Worksheets[1];
// get a range to work with
range = sheet.get_Range("A2", Missing.Value);
// get the end of values to the right (will stop at the first empty cell)
range = range.get_End(XlDirection.xlToRight);
// get the end of values toward the bottom, looking in the last column (will stop at first empty cell)
range = range.get_End(XlDirection.xlDown);
// get the address of the bottom, right cell
string downAddress = range.get_Address(
false, false, XlReferenceStyle.xlA1,
Type.Missing, Type.Missing);
// Get the range, then values from a1
range = sheet.get_Range("A2", downAddress);
object[,] values = (object[, ])range.Value2;
// Value2 is a two dimenial array dime one = row, dime two = column.
Console.WriteLine("Col Count: " + values.GetLength(1).ToString());
Console.WriteLine("Row Count: " + values.GetLength(0).ToString());
using (DanceClassDbContext db = new DanceClassDbContext())
{
var users = new List <ApplicationUser>();
var memberships = new List <Membership>();
var packages = new List <Package>();
var defaultPackages = db.DefaultPackages.ToList();
for (int i = 1; i <= values.GetLength(0); i++)
{
string fullName = values[i, 1].ToString().Trim();
if (!values[i, 2].ToString().Equals("0"))
{
fullName = values[i, 2].ToString().Trim() + " " + fullName;
}
DateTime?dob = !values[i, 3].Equals("undefined") ? (DateTime?)DateTime.FromOADate((double)values[i, 3]) : null;
string phoneNumber = "0" + values[i, 4].ToString().Trim();
int numberOfSessions = int.Parse(values[i, 5].ToString());
int months = int.Parse(values[i, 6].ToString());
DateTime createdDate = DateTime.FromOADate((double)values[i, 7]);
Console.WriteLine(createdDate);
DateTime expiryDate = DateTime.FromOADate((double)values[i, 8]);
int remainingSessions = int.Parse(values[i, 10].ToString());
double price = (double)values[i, 11];
ApplicationUser user = new ApplicationUser
{
FullName = fullName,
UserName = GenerateUserName(users, fullName),
PhoneNumber = phoneNumber,
Birthdate = dob,
CreatedBy = "Imported",
UpdatedBy = "Imported",
CreatedDate = createdDate,
UpdatedDate = createdDate
};
Membership membership = new Membership
{
User = user,
RemainingSessions = remainingSessions,
ExpiryDate = expiryDate,
CreatedBy = "Imported",
UpdatedBy = "Imported",
CreatedDate = createdDate,
UpdatedDate = createdDate
};
DefaultPackage defaultPackage = defaultPackages.FirstOrDefault(p => p.NumberOfSessions == numberOfSessions);
Package package = new Package
{
NumberOfSessions = numberOfSessions,
RemainingSessions = remainingSessions,
Months = months,
Price = price,
DefaultPackageId = defaultPackage != null ? (int?)defaultPackage.Id : null,
User = user,
CreatedBy = "Imported",
UpdatedBy = "Imported",
CreatedDate = createdDate,
UpdatedDate = createdDate,
ExpiryDate = expiryDate
};
users.Add(user);
memberships.Add(membership);
packages.Add(package);
}
ApplicationUserManager userManager = new ApplicationUserManager(new ApplicationUserStore(db));
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
Console.WriteLine("--------------------------------------");
Console.WriteLine("- ADDING USERS -------------------------");
Console.WriteLine("--------------------------------------");
foreach (var u in users)
{
Console.WriteLine("Adding user: "******"Mistake1234").GetAwaiter().GetResult();
if (result.Succeeded)
{
result = userManager.AddToRoleAsync(u.Id, "Member").GetAwaiter().GetResult();
}
if (!result.Succeeded)
{
throw new Exception(string.Join(". ", result.Errors));
}
}
Console.WriteLine("--------------------------------------");
Console.WriteLine("- ADDING MEMBERSHIPS -------------------------");
Console.WriteLine("--------------------------------------");
db.Memberships.AddRange(memberships);
Console.WriteLine("--------------------------------------");
Console.WriteLine("- ADDING PACKAGES -------------------------");
Console.WriteLine("--------------------------------------");
db.Packages.AddRange(packages);
Console.WriteLine("--------------------------------------");
Console.WriteLine("- SAVING CHANGES -------------------------");
Console.WriteLine("--------------------------------------");
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
Console.WriteLine(ex);
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
finally
{
range = null;
sheet = null;
if (book != null)
{
try
{
book.Close(false, Missing.Value, Missing.Value);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
book = null;
if (app != null)
{
try
{
app.Quit();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
app = null;
Console.ReadKey();
}
}
public RevenueReportService(DanceClassDbContext dbContext, IMapper mapper) : base(dbContext, mapper)
{
}
public MembershipService(DanceClassDbContext dbContext, IMapper mapper) : base(dbContext, mapper)
{
}