public static ResponseResult Create(List_User model)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new RentalContext())
{
data_user User = new data_user();
User.Id = Guid.NewGuid().ToString();
//User.Id = "123abv";
User.Email = model.Email;
User.Nama = model.Nama;
User.Alamat = model.Alamat;
User.nomor_id = model.nomor_id;
db.data_users.Add(User);
db.SaveChanges();
result.list = model;
result.success = true;
}
}
catch (Exception ex)
{
result.success = false;
result.message = ex.Message;
throw;
}
return(result);
}
static void Main(string[] args)
{
RentalContext ctx = new RentalContext();
RentRepository rentRepo = new RentRepository(ctx);
VideoGameRepository gameRepo = new VideoGameRepository(ctx);
PersonRepository personRepo = new PersonRepository(ctx);
RentLogic rentLogic = new RentLogic(rentRepo);
VideoGameLogic gameLogic = new VideoGameLogic(gameRepo);
PersonLogic personLogic = new PersonLogic(personRepo);
Console.WriteLine(">List all rents");
rentLogic.GetAllRentals().ToList().ForEach(x => Console.WriteLine(x.AllData));
Console.WriteLine("\n\n##################################################\n");
Console.WriteLine("\n\n>List all games");
gameLogic.GetAllGames().ToList().ForEach(x => Console.WriteLine(x.AllData));
Console.WriteLine("\n\n##################################################\n");
Console.WriteLine("\n\n>List all people");
personLogic.GetAllPeople().ToList().ForEach(x => Console.WriteLine(x.AllData));
//##################################################
Console.WriteLine(rentLogic.MostFine());
Console.WriteLine(rentLogic.MostRentedGame());
Console.WriteLine(rentLogic.MostRentsByPerson());
}
public static List <Rent_lists> Search(string search)
{
ResponseResult final = new ResponseResult();
List <Rent_lists> result = new List <Rent_lists>();
List <TP_List> transport = new List <TP_List>();
final.success = true;
using (var db = new RentalContext())
{
result = (from r in db.DataRents
join t in db.Transport_Lists on r.id_Kendaraan equals t.Id
where (r.id_User == search)
select new Rent_lists
{
Id = r.Id,
id_Kendaraan = t.nama,
id_User = r.id_User,
Nomor_Pesanan = r.Nomor_Pesanan,
Start_Date = r.Start_Date,
End_Date = r.End_Date,
Status = r.Status
}).ToList();
}
if (result.Count < 1)
{
final.success = false;
final.message = "User ID not Found";
}
final.list = result;
return(result);
}
public static ResponseResult Create(Rent_lists model)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new RentalContext())
{
DataRent User = new DataRent();
User.Id = Guid.NewGuid().ToString();
//User.Id = "123abv";
User.id_Kendaraan = model.id_Kendaraan;
User.Start_Date = model.Start_Date;
User.End_Date = model.End_Date;
User.Nomor_Pesanan = DateTime.Now.ToString("ddmmyyyy") + "001";
db.DataRents.Add(User);
db.SaveChanges();
result.list = model;
result.success = true;
}
}
catch (Exception ex)
{
result.success = false;
result.message = ex.Message;
throw;
}
return(result);
}
private void SaveTransactionItems(IList <TransactionItem> newItems)
{
using (var context = new RentalContext())
{
var repo = new TransactionRepository(context);
repo.SaveTransactionItems(newItems);
}
}
public ActionResult Edit(int Id)
{
using (var db = new RentalContext())
{
var rental = db.Rentals.Find(Id);
return(View(rental));
}
}
public ActionResult Index()
{
using (var db = new RentalContext())
{
var rentalList = db.Rentals.ToList();
return(View(rentalList));
}
}
public void TestMethod1()
{
Trace.WriteLine("Start Read DataUser");
using (var db = new RentalContext())
{
var ListDataUser = db.data_users.ToList();
}
Trace.WriteLine("End Read DataUser");
}
public ActionResult Delete(int Id)
{
using (var db = new RentalContext())
{
var rental = db.Rentals.Find(Id);
db.Rentals.Remove(rental);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public void Setup()
{
RentalContext ctx = new RentalContext();
RentRepository rentRepo = new RentRepository(ctx);
VideoGameRepository gameRepo = new VideoGameRepository(ctx);
PersonRepository personRepo = new PersonRepository(ctx);
rentLogic = new RentLogic(rentRepo);
gameLogic = new VideoGameLogic(gameRepo);
personLogic = new PersonLogic(personRepo);
}
public static async Task DispatchDomainEventsAsync(this IMediator mediator, RentalContext ctx)
{
var domainEntities = ctx.ChangeTracker.Entries<Entity>().Where(x => x.Entity.DomainEvents != null && x.Entity.DomainEvents.Any());
var domainEvents = domainEntities.SelectMany(x => x.Entity.DomainEvents).ToList();
domainEntities.ToList().ForEach(entity => entity.Entity.DomainEvents.Clear());
var tasks = domainEvents
.Select(async (domainEvent) => {
await mediator.Publish(domainEvent);
});
await Task.WhenAll(tasks);
}
public ActionResult Edit(int Id, string firstName, string lastName, string movieTitle,
string emailAddress, DateTime checkOutDate)
{
using (var db = new RentalContext())
{
var rental = db.Rentals.Find(Id);
rental.FirstName = firstName;
rental.LastName = lastName;
rental.MovieTitle = movieTitle;
rental.Email = emailAddress;
rental.CheckOutDate = checkOutDate;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public void ProcessTransactions(string fullPathFileName)
{
var criteriaList = new List <TransactionCriteria>();
using (var context = new RentalContext())
{
var repo = new TransactionRepository(context);
criteriaList = repo.GetTransactionCriterias(true).ToList();
context.Dispose();
}
var extracts = ExtractTransactions(fullPathFileName, criteriaList);
var filteredExtracts = FilterTransactionItemsToPersist(extracts);
SaveTransactionItems(filteredExtracts);
var x = 1;
}
public static void RegisterTypes(IUnityContainer container)
{
var context = new RentalContext();
container.RegisterType <ICompanyRepository, CompanyRepository>();
container.RegisterType <IToolRepository, ToolRepository>();
container.RegisterType <ITransactionRepository, TransactionRepository>();
container.RegisterType <IUserRepository, UserRepository>();
container.RegisterType <IRentalContext, RentalContext>();
container.RegisterType <MainWindow>(new InjectionConstructor(container, new TransactionRepository(context)));
container.RegisterType <CompanyWindow>(new InjectionConstructor(container, new CompanyRepository(context)));
container.RegisterType <CompaniesWindow>(new InjectionConstructor(container, new CompanyRepository(context)));
container.RegisterType <UserWindow>(new InjectionConstructor(container, new UserRepository(context)));
container.RegisterType <UsersWindow>(new InjectionConstructor(container, new UserRepository(context)));
container.RegisterType <ToolWindow>(new InjectionConstructor(container, new ToolRepository(context)));
container.RegisterType <ToolsWindow>(new InjectionConstructor(container, new ToolRepository(context)));
container.RegisterType <ToolsForTransactionWindow>(new InjectionConstructor(container, new ToolRepository(context)));
container.RegisterType <TransactionWindow>(new InjectionConstructor(container, new TransactionRepository(context)));
container.RegisterType <StatisticWindow>(new InjectionConstructor(container, new TransactionRepository(context)));
}
public static List <Rent_lists> All()
{
List <Rent_lists> result = new List <Rent_lists>();
List <TP_List> transport = new List <TP_List>();
using (var db = new RentalContext())
{
result = (from r in db.DataRents
join t in db.Transport_Lists on r.id_Kendaraan equals t.Id
select new Rent_lists
{
Id = r.Id,
id_Kendaraan = t.nama,
id_User = r.id_User,
Nomor_Pesanan = r.Nomor_Pesanan,
Start_Date = r.Start_Date,
End_Date = r.End_Date,
Status = r.Status
}).ToList();
}
return(result);
}
private IList <TransactionItem> FilterTransactionItemsToPersist(IList <TransactionItem> extractItems)
{
var newTransactionItems = new List <TransactionItem>();
var searchDate = extractItems.OrderBy(x => x.TransactionDate).First().TransactionDate;
var existingTransactions = new List <TransactionItem>();
using (var context = new RentalContext())
{
var repo = new TransactionRepository(context);
existingTransactions = repo.GetTransactionItems(searchDate).ToList();
}
foreach (var item in extractItems)
{
if (!existingTransactions.Any(x => x.TransactionDate.Equals(item.TransactionDate) &&
x.Amount.Equals(item.Amount) &&
x.Description.Equals(item.Description)))
{
newTransactionItems.Add(item);
}
}
return(newTransactionItems);
}
public InvoiceRepository(RentalContext context)
{
this.context = context;
}
public BikesController(RentalContext context)
{
_context = context;
}
public MüsterilerController(RentalContext context)
{
_context = context;
}
public RentalAssetService(RentalContext context)
{
_context = context;
}
public DistributionService(RentalContext context)
{
_context = context;
}
public CustomersController(RentalContext context)
{
_context = context;
}
public KiralamalarController(RentalContext context)
{
_context = context;
}
public AraclarController(RentalContext context)
{
_context = context;
}
public SubscriberService(RentalContext context)
{
_context = context;
}
public RentalRepository(RentalContext dbContext) => _dbContext = dbContext;
public CustomerRepository(RentalContext context) : base(context)
{
}
public CarRepository(RentalContext context)
{
this.context = context;
}
public RentalRepository(RentalContext context) : base(context)
{
}
public MovieRepository(RentalContext rentalContext, IMapper mapper)
{
this.rentalContext = rentalContext;
this.mapper = mapper;
}
