public AuxiliaryHelper(LedgerContext ledger, ICacheHelper cache, IAccountBookHelper acctBook, HttpContextBase context)
{
_ledger = ledger;
_cache = cache;
_acctBook = acctBook;
_context = context;
}
public CertificateWordHelper(HttpContextBase context, LedgerContext ledger, ICacheHelper cache)
{
_identity = context.User.Identity as ClaimsIdentity;
_ledger = ledger;
_context = context;
_cache = cache;
}
public List <Category> GetCategories(DbContextOptionsBuilder <LedgerContext> context)
{
using (var ctx = new LedgerContext(context.Options))
{
return(ctx.Categories.ToList());
}
}
public static void FinishRecord()
{
try
{
Guid personId = SetInformations.SetPersonId();
using (var context = new LedgerContext())
{
var leavingPerson = context.People.Find(personId);
var ledgers = context.Ledgers.ToList();
for (int i = 0; i < ledgers.Count; i++)
{
if (ledgers[i].PersonId == leavingPerson.Id)
{
context.Ledgers.Remove(ledgers[i]);
context.SaveChanges();
ledgers[i].ExitTime = DateTime.Now;
context.Ledgers.Add(ledgers[i]);
context.SaveChanges();
break;
}
}
}
}
catch (ArgumentNullException exception)
{
Console.WriteLine(exception.ParamName);
}
}
public Guid Create(Transaction transaction, DbContextOptionsBuilder <LedgerContext> context)
{
try
{
using (var ctx = new LedgerContext(context.Options))
{
transaction.DateCreated = DateTime.Now.ToUniversalTime();
ctx.Transactions.Add(transaction);
if (ctx.SaveChanges() != 1)
{
return(Guid.Empty);
}
return(transaction.Id);
}
}
catch (DbEntityValidationException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public List <Transaction> GetTransactions(Guid accountId, DbContextOptionsBuilder <LedgerContext> context)
{
using (var ctx = new LedgerContext(context.Options))
{
return(ctx.Transactions.OrderBy(t => t.TransactionDate).ToList());
}
}
public List <PaymentType> GetPaymentTypes(DbContextOptionsBuilder <LedgerContext> context)
{
using (var ctx = new LedgerContext(context.Options))
{
return(ctx.PaymentTypes.ToList());
}
}
public void Can_Get_Transaction()
{
using (var context = new LedgerContext(_optionBuilder.Options))
{
var trans = context.Transactions.FirstOrDefault(t => t.AccountId == _acctId);
Assert.IsNotNull(trans, "Transaction was not successfully created");
}
}
public AccountBookHelper(HttpContextBase context,
LedgerContext ledger,
ICacheHelper cache,
ICertificateWordHelper certWord)
{
_identity = context.User.Identity as ClaimsIdentity;
_ledger = ledger;
_cache = cache;
_certWord = certWord;
}
private void AutofacConfig()
{
var builder = new ContainerBuilder();
var assembly = Assembly.GetExecutingAssembly();
// MVC - Register your MVC controllers.
builder.RegisterControllers(assembly);
// MVC - OPTIONAL: Register web abstractions like HttpContextBase.
builder.RegisterModule <AutofacWebTypesModule>();
// MVC - OPTIONAL: Enable property injection in view pages.
builder.RegisterSource(new ViewRegistrationSource());
// MVC - OPTIONAL: Enable property injection into action filters.
builder.RegisterFilterProvider();
//注入实现Sintoacct.Ledger.IDependency接口的对象
builder.RegisterAssemblyTypes(assembly)
.Where(t => t.GetInterface("Sintoacct.Ledger.IDependency") != null)
.AsImplementedInterfaces();
//注入Ledger上下文
var ledger = new LedgerContext();
ledger.Database.Initialize(false);
//#warning 输出SQL
//ledger.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
//builder.RegisterInstance(ledger).As<LedgerContext>();
builder.RegisterType <LedgerContext>().InstancePerLifetimeScope();
//注入BizProgressContext
var prog = new BizProgressContext();
prog.Database.Initialize(false);
builder.RegisterType <BizProgressContext>().InstancePerLifetimeScope();
// WebAPI - Register your Web API controllers
builder.RegisterApiControllers(assembly);
// WebAPI - OPTIONAL: Register the Autofac filter provider.
builder.RegisterWebApiFilterProvider(GlobalConfiguration.Configuration);
//注入Log4net
builder.RegisterModule(new LogInjectionModule());
IContainer container = builder.Build();
//注入MVC
DependencyResolver.SetResolver(new AutofacDependencyResolver(container));
//注入Web API
GlobalConfiguration.Configuration.DependencyResolver = new AutofacWebApiDependencyResolver(container);
}
public VoucherHelper(LedgerContext ledger,
ICacheHelper cache,
IAccountBookHelper acctBook,
HttpContextBase context,
IAccountHelper account)
{
_ledger = ledger;
_cache = cache;
_acctBook = acctBook;
_context = context;
_account = account;
}
public Category GetCategory(int id, DbContextOptionsBuilder <LedgerContext> context)
{
using (var ctx = new LedgerContext(context.Options))
{
var cat = ctx.Categories.FirstOrDefault(c => c.Id == id);
if (cat == null)
{
throw new Exception("Cannot find a category with this parameter");
}
return(cat);
}
}
public ActionResult CryptoData()
{
ViewBag.Message = "Here are the top 100 coins !";
ViewBag.Time = DateTime.Now;
/*
* var hap = new HAPScraper();
* hap.Run();
*/
using (var db = new LedgerContext())
{
var url = "https://coinmarketcap.com/";
var htmlWeb = new HtmlWeb();
var htmlDocument = new HtmlDocument();
htmlDocument = htmlWeb.Load(url);
HtmlNodeCollection allRows = htmlDocument.DocumentNode.SelectNodes("//table[1]/tbody[1]/tr[*]");
List <Coin> currencyList = new List <Coin>();
foreach (var row in allRows)
{
var CoinPosition = row.ChildNodes[1].InnerText;
var CoinSymbol = row.ChildNodes[3].ChildNodes[3].InnerText;
var CoinName = row.ChildNodes[3].ChildNodes[7].InnerText;
var CoinChange = row.ChildNodes[13].InnerText;
var CoinPrice = row.ChildNodes[7].InnerText;
Coin coin = new Coin(CoinPosition, CoinSymbol, CoinName, CoinChange, CoinPrice);
currencyList.Add(coin);
}
//Creates a date.time snapshot-this will be my future snapshot button
var ledger = new Ledger
{
CryptoCoins = currencyList,
Time = DateTime.Now
};
db.Ledgers.Add(ledger);
db.SaveChanges();
Console.WriteLine();
return(View(currencyList));
}
}
public int RemoveTransaction(Guid transId, DbContextOptionsBuilder <LedgerContext> context)
{
using (var ctx = new LedgerContext(context.Options))
{
var entity = ctx.Transactions.FirstOrDefault(t => t.Id == transId);
if (entity != null)
{
ctx.Entry(entity).State = EntityState.Deleted;
}
return(ctx.SaveChanges());
}
}
public Transaction GetTransaction(Guid id, DbContextOptionsBuilder <LedgerContext> context)
{
using (var ctx = new LedgerContext(context.Options))
{
var trans = ctx.Transactions.FirstOrDefault(t => t.Id == id);
if (trans == null)
{
throw new Exception("Cannot locate transaction with this id");
}
return(trans);
}
}
public void Can_Get_Account()
{
var optionBuilder = new DbContextOptionsBuilder <LedgerContext>();
optionBuilder.UseInMemoryDatabase();
using (var context = new LedgerContext(optionBuilder.Options))
{
var account = context.Accounts.FirstOrDefault(a => a.UserName == "BVilla");
Assert.IsNotNull(account, "Can not locate account");
}
}
public void OnException(ExceptionContext filterContext)
{
LedgerContext context = new LedgerContext();
ExceptionLog exception = new ExceptionLog();
exception.RequestUrl = filterContext.HttpContext.Request.RawUrl;
exception.RequestDetail = JsonConvert.SerializeObject(filterContext.HttpContext.Request.Params);
exception.ExceptionMessage = filterContext.Exception.Message;
exception.ExceptionDetail = JsonConvert.SerializeObject(filterContext.Exception);
exception.LogTime = System.DateTime.Now;
context.Exceptions.Add(exception);
context.SaveChanges();
}
public AddLedgerInViewModel(IRegionManager rm, IEventAggregator ea, IOfficeContext context)
{
regionManager = rm;
eventAggregator = ea;
this.context = context;
LedgerDTO = new LedgerContext {
LedgerDate = DateTime.Now
};
AccountList = new ObservableCollection <AccountInfoContext>();
AccountInList = new ObservableCollection <AccountInfoContext>();
EmployeeList = new ObservableCollection <UserSimpleContext>();
}
public ActionResult Contact()
{
ViewBag.Message = "Your contact page.";
using (var db = new LedgerContext())
{
}
var url = "https://coinmarketcap.com/";
var htmlWeb = new HtmlWeb();
var htmlDocument = new HtmlDocument();
htmlDocument = htmlWeb.Load(url);
HtmlNodeCollection allRows = htmlDocument.DocumentNode.SelectNodes("//table[1]/tbody[1]/tr[*]");
//var rowNumber = 0;
List <Coin> currencyDataList = new List <Coin>();
foreach (var row in allRows)
{
// Console.WriteLine("Attempting to process row: " + rowNumber++);
try
{
var CoinSymbol = row.ChildNodes[3].ChildNodes[3].InnerText;
var CoinName = row.ChildNodes[3].ChildNodes[5].InnerText;
var CoinPrice = row.ChildNodes[7].InnerText;
Coin coin = new Coin(CoinSymbol, CoinName, CoinPrice);
currencyDataList.Add(coin);
}
catch (Exception e)
{
Console.WriteLine("Failed to Find Value at Specified Co-ordinates");
Console.WriteLine(e);
throw;
}
Console.WriteLine("Process done");
}
return(View(currencyDataList));
}
public PaymentType GetPaymentType(int id, DbContextOptionsBuilder <LedgerContext> context)
{
using (var ctx = new LedgerContext(context.Options))
{
var pt = ctx.PaymentTypes.FirstOrDefault(p => p.Id == id);
if (pt == null)
{
throw new Exception("Cannot find a payment type with this parameter");
}
return(pt);
;
}
}
public static Guid SetPersonId()
{
do
{
try
{
Console.WriteLine("Выберите номер человека который уходит:");
List <Person> persons;
using (var context = new LedgerContext())
{
persons = context.People.ToList();
if (persons.Count == Constants.NULL)
{
throw new ArgumentNullException("Нет людей");
}
for (int i = 0; i < persons.Count; i++)
{
Console.WriteLine($"{i + 1}) {persons[i].Name} : {persons[i].CertificateNumber}");
}
}
int personId;
if (int.TryParse(Console.ReadLine().Trim(), out personId))
{
if (personId > 0 && personId <= persons.Count)
{
return(persons[personId - 1].Id);
}
throw new ArgumentException("Нет такого номера, выберите существующи");
}
throw new ArgumentException("Номер был некоректно введен");
}
catch (ArgumentNullException)
{
throw;
}
catch (ArgumentException exception)
{
Console.WriteLine(exception.Message);
}
} while (true);
}
private static async Task GetHtmlAsync()
{
using (var db = new LedgerContext())
{
var url = "https://coinmarketcap.com/";
var htmlWeb = new HtmlWeb();
var htmlDocument = new HtmlDocument();
htmlDocument = htmlWeb.Load(url);
HtmlNodeCollection allRows = htmlDocument.DocumentNode.SelectNodes("//table[1]/tbody[1]/tr[*]");
var rowNumber = 0;
List <Coin> currencyDataList = new List <Coin>();
foreach (var row in allRows)
{
try
{
Console.WriteLine("Attempting to process row: " + rowNumber++);
var CoinPosition = row.ChildNodes[1].InnerText;
/*var CoinSymbol = row.ChildNodes[3].ChildNodes[3].InnerText;
* var CoinName = row.ChildNodes[3].ChildNodes[5].InnerText;
* var CoinPrice = row.ChildNodes[7].InnerText; */
Coin coin = new Coin(CoinPosition /*CoinSymbol, CoinName, CoinPrice*/);
currencyDataList.Add(coin);
}
catch (Exception e)
{
Console.WriteLine("Failed to find value at specified coordinates");
Console.WriteLine(e);
throw;
}
Console.WriteLine("Process Done !");
}
Console.WriteLine(currencyDataList);
//db.Ledgers.Add(Ledger);
//db.SaveChanges();
}
}
public int Create(Category category, DbContextOptionsBuilder <LedgerContext> context)
{
try
{
using (var ctx = new LedgerContext(context.Options))
{
ctx.Categories.Add(category);
return(ctx.SaveChanges());
}
}
catch (DbEntityValidationException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public Account GetAccount(string userName, DbContextOptionsBuilder <LedgerContext> context)
{
try
{
using (var ctx = new LedgerContext(context.Options))
{
var account = ctx.Accounts.FirstOrDefault(a => a.UserName == userName);
return(account);
}
}
catch (DbEntityValidationException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public int Create(PaymentType paymentType, DbContextOptionsBuilder <LedgerContext> context)
{
try
{
using (var ctx = new LedgerContext(context.Options))
{
ctx.PaymentTypes.Add(paymentType);
return(ctx.SaveChanges());
}
}
catch (DbEntityValidationException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public int Create(Account account, DbContextOptionsBuilder <LedgerContext> context)
{
try
{
using (var ctx = new LedgerContext(context.Options))
{
account.DateCreated = DateTime.Now;
ctx.Accounts.Add(account);
return(ctx.SaveChanges());
}
}
catch (DbEntityValidationException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public void Can_Create_Tranaction()
{
using (var context = new LedgerContext(_optionBuilder.Options))
{
context.Transactions.Add(new Transaction
{
AccountId = _acctId,
Amount = 100,
CategoryId = 1,
Description = "New shoes",
IsDeposit = false,
PaymentTypeId = 1,
TransactionDate = DateTime.Now,
CreatedBy = "BVilla",
DateCreated = DateTime.Now,
});
context.SaveChanges();
var trans = context.Transactions.FirstOrDefault(t => t.AccountId == _acctId);
Assert.IsNotNull(trans, "Transaction was not successfully created");
}
}
public void Can_Create_Account()
{
var optionBuilder = new DbContextOptionsBuilder <LedgerContext>();
optionBuilder.UseInMemoryDatabase();
using (var context = new LedgerContext(optionBuilder.Options))
{
context.Accounts.Add(new Account
{
FirstName = "Bob",
LastName = "Villa",
UserName = "******",
Password = "******",
CreatedBy = "Admin",
DateCreated = DateTime.Now
});
context.SaveChanges();
var account = context.Accounts.FirstOrDefault(a => a.UserName == "BVilla");
Assert.IsNotNull(account, "Account was not successfully created");
}
}
public static void CraeteReacord()
{
Person newPerson = new Person()
{
Name = SetInformations.SetName(),
CertificateNumber = SetInformations.SetCertificateNumber()
};
Ledger newRecord = new Ledger()
{
Person = newPerson,
EnterTime = DateTime.Now,
ExitTime = null,
PersonId = newPerson.Id,
VisitPurpose = SetInformations.SetVisitPurpose()
};
using (var context = new LedgerContext())
{
context.People.Add(newPerson);
context.Ledgers.Add(newRecord);
context.SaveChanges();
}
}
public CacheHelper(HttpContextBase context, LedgerContext ledger)
{
_context = context;
_ledger = ledger;
}
