/// <summary>
/// Deletes selected memory.
/// </summary>
/// <param name="obj"></param>
private async void ExecDeleteMemoryAsync(object obj)
{
Memory memory = (Memory)ProductListView.ProductListUserControl.MemoryList.SelectedItem;
Rams.Remove(memory);
switch (App.DataSource)
{
case ConnectionResource.LOCALAPI:
await new WebServiceManager <Memory>().DeleteAsync(memory);
break;
case ConnectionResource.LOCALMYSQL:
using (var ctx = new MysqlDbContext(ConnectionResource.LOCALMYSQL))
{
ctx.DbSetMemories.Attach(memory);
ctx.DbSetMemories.Remove(memory);
await ctx.SaveChangesAsync();
}
break;
default:
break;
}
}
/// <summary>
/// Deletes selected case.
/// </summary>
/// <param name="obj"></param>
private async void ExecDeleteCaseAsync(object obj)
{
Case pcCase = (Case)ProductListView.ProductListUserControl.CaseList.SelectedItem;
Cases.Remove(pcCase);
switch (App.DataSource)
{
case ConnectionResource.LOCALAPI:
await new WebServiceManager <Case>().DeleteAsync(pcCase);
break;
case ConnectionResource.LOCALMYSQL:
using (var ctx = new MysqlDbContext(ConnectionResource.LOCALMYSQL))
{
ctx.DbSetCases.Attach(pcCase);
ctx.DbSetCases.Remove(pcCase);
await ctx.SaveChangesAsync();
}
break;
default:
break;
}
}
/// <summary>
/// Deletes selected storage component.
/// </summary>
/// <param name="obj"></param>
private async void ExecDeleteStorageAsync(object obj)
{
Storage storageComponent = (Storage)ProductListView.ProductListUserControl.StorageList.SelectedItem;
StorageComponents.Remove(storageComponent);
switch (App.DataSource)
{
case ConnectionResource.LOCALAPI:
await new WebServiceManager <Storage>().DeleteAsync(storageComponent);
break;
case ConnectionResource.LOCALMYSQL:
using (var ctx = new MysqlDbContext(ConnectionResource.LOCALMYSQL))
{
ctx.DbSetStorages.Attach(storageComponent);
ctx.DbSetStorages.Remove(storageComponent);
await ctx.SaveChangesAsync();
}
break;
default:
break;
}
}
public async Task <IActionResult> Post(int id, string lang)
{
var model = new BlogPostViewModel();
Utils.CheckOrRefreshUiStrings(lang);
ViewBag.Title = Utils.GetUiString("title.blog");
ViewBag.ActiveLink = 1;
var postItem = new BlogItem();
using (var db = new MysqlDbContext(this.ConnectionString))
{
var post = await db.Posts.SingleOrDefaultAsync(b => b.Id == id);
var titleImage = await db.Media.SingleOrDefaultAsync(i => i.Id == post.TitleImage);
// TODO: add gallery
postItem.Post = post;
postItem.TitleImage = titleImage;
ViewBag.Title = $"{post.Title} | {Utils.GetUiString("title.blog")} ";
}
model.Post = postItem;
return(this.View(model));
}
public async Task <IActionResult> Index(string lang)
{
var model = new HomeViewModel();
Utils.CheckOrRefreshUiStrings(lang);
ViewBag.Title = Utils.GetUiString("title.home");
using (var db = new MysqlDbContext(this.ConnectionString))
{
model.CoreData = await db.CoreData.FirstOrDefaultAsync();
var latestPosts = db.Posts.Where(p => p.IsPublished).Take(3);
var blogItems = new List <BlogItem>();
// Get related mediafiles
foreach (var b in latestPosts)
{
var blogItem = new BlogItem();
blogItem.Post = b;
blogItem.TitleImage = await db.Media.FirstOrDefaultAsync(m => m.Id == b.TitleImage);
// TODO: add galleries below!
blogItems.Add(blogItem);
}
model.LatestPosts = blogItems;
}
return(this.View(model));
}
private int setTaskMin()
{
using (MysqlDbContext dbcontext = new MysqlDbContext())
{
int ttaskMin = 5;
try
{
logger.DebugFormat("test!");
var tmptaskMin = dbcontext.m_Parameter.Where(m => m.paramkey.Equals("autoGetXMLMin")).Select(m => m.paramvalue).SingleOrDefault();
logger.DebugFormat("**获取远行job分钟：{0}", tmptaskMin);
if (!string.IsNullOrEmpty(tmptaskMin))
{
if (int.TryParse(tmptaskMin, out ttaskMin))
{
logger.DebugFormat("**获取job分钟成功：{0}，currMin:{1}", tmptaskMin, ttaskMin);
if (ttaskMin < 5)
{
ttaskMin = 5;
}
}
}
else
{
logger.DebugFormat("**job运行失败，获取分钟：{0}，默认值：{1}", tmptaskMin, ttaskMin);
}
}
catch (Exception ex)
{
logger.Error("**##Mysql Error:", ex);
}
return(ttaskMin);
}
}
/// <summary>
/// Deletes selected worker.
/// </summary>
/// <param name="obj"></param>
private async void ExecDeleteWorkerAsync(object obj)
{
Worker worker = (Worker)WorkerListView.WorkerListUserControl.WorkerList.SelectedItem;
Workers.Remove(worker);
switch (App.DataSource)
{
case ConnectionResource.LOCALAPI:
await new WebServiceManager <Worker>().DeleteAsync(worker);
break;
case ConnectionResource.LOCALMYSQL:
using (var ctx = new MysqlDbContext(ConnectionResource.LOCALMYSQL))
{
ctx.DbSetWorkers.Attach(worker);
ctx.DbSetWorkers.Remove(worker);
await ctx.SaveChangesAsync();
}
break;
default:
break;
}
}
/// <summary>
/// 根据db类型和db名称获取执行content
/// </summary>
public static DbContext <EmptyEntity> EmptyDb(string _dbMappingName)
{
var dbProvider = AntData.ORM.Common.Configuration.DBSettings.DatabaseSettings.FirstOrDefault(r => r.Name.Equals(_dbMappingName));
var _dbType = dbProvider?.Provider;
if (string.IsNullOrEmpty(_dbType))
{
return(null);
}
DbContext <EmptyEntity> db;
if (_dbType.ToLower().Contains("mysql"))
{
db = new MysqlDbContext <EmptyEntity>(_dbMappingName);
}
else
{
db = new SqlServerlDbContext <EmptyEntity>(_dbMappingName);
}
#if DEBUG
db.IsEnableLogTrace = true;
db.OnLogTrace = OnCustomerTraceConnection;
#endif
return(db);
}
/// <summary>
/// Deletes selected GPU.
/// </summary>
/// <param name="obj"></param>
private async void ExecDeleteGPUAsync(object obj)
{
GPU gpu = (GPU)ProductListView.ProductListUserControl.GPUList.SelectedItem;
GPUs.Remove(gpu);
switch (App.DataSource)
{
case ConnectionResource.LOCALAPI:
await new WebServiceManager <GPU>().DeleteAsync(gpu);
break;
case ConnectionResource.LOCALMYSQL:
using (var ctx = new MysqlDbContext(ConnectionResource.LOCALMYSQL))
{
ctx.DbSetGPUs.Attach(gpu);
ctx.DbSetGPUs.Remove(gpu);
await ctx.SaveChangesAsync();
}
break;
default:
break;
}
}
public async Task <IActionResult> Index(int?id, string lang)
{
var model = new BlogAllViewModel();
Utils.CheckOrRefreshUiStrings(lang);
ViewBag.Title = Utils.GetUiString("title.blog");
ViewBag.ActiveLink = 1;
using (var db = new MysqlDbContext(this.ConnectionString))
{
// Get Posts from DB
var posts = await db.Posts.ToListAsync();
var blogItems = new List <BlogItem>();
// Get related mediafiles
foreach (var b in posts)
{
var blogItem = new BlogItem();
blogItem.Post = b;
blogItem.TitleImage = await db.Media.FirstOrDefaultAsync(m => m.Id == b.TitleImage);
// TODO: add galleries below!
blogItems.Add(blogItem);
}
blogItems.OrderBy(d => d.Post.Date).ToList();
model.FeaturedPost = blogItems.FirstOrDefault();
model.BlogItems = blogItems;
}
return(this.View(model));
}
/// <summary>
/// 初始化 <see cref="DefaultDataFacade"/> 类的新实例。
/// <see cref="DefaultDataFacade"/> 类的初始化将会创建 MySQL 数据库结构。
/// </summary>
/// <param name="mysqlDbContext">MySQL数据上下文。</param>
/// <param name="mongoDbContext">MongoDB数据上下文。</param>
/// <exception cref="ArgumentNullException">
/// <paramref name="mysqlDbContext"/>为null
/// 或
/// <paramref name="mongoDbContext"/>为null
/// </exception>
public DefaultDataFacade(MysqlDbContext mysqlDbContext, MongoDbContext mongoDbContext)
{
_mysqlDbContext = mysqlDbContext ?? throw new ArgumentNullException(nameof(mysqlDbContext));
_mongoDbContext = mongoDbContext ?? throw new ArgumentNullException(nameof(mongoDbContext));
// TODO: 尝试重构下面的代码以分离数据库创建检查逻辑
_mysqlDbContext.Database.EnsureCreated();
}
static void Main(string[] args)
{
Console.WriteLine("Probando el contexto de base de datos con MySQL");
using (var db = new MysqlDbContext())
{
db.Database.EnsureCreated();
}
}
public ActionResult Get()
{
using (var db = new MysqlDbContext())
{
var usuarios = db.Usuarios.ToList();
return(Ok(usuarios));
}
}
public GroceryListController(MysqlDbContext context)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
_context = context;
}
public int Exist(string openid)
{
using (MysqlDbContext mdb = new MysqlDbContext())
{
var user = mdb.Users.Where(t => t.Openid == openid).FirstOrDefault();
if (user == null)
{
return(0);
}
return(1);
}
}
public IHttpActionResult GoInRoom([FromBody] GoInRoom_Ac_Request RequestMod)
{
try
{
if (RequestMod.RoomId < 1 || RequestMod.LocationId < 1)
{
throw new ArgumentException("非法访问");
}
using (MysqlDbContext db = new MysqlDbContext())
{
var room = db.Rooms.Where(t => t.RoomId == RequestMod.RoomId & t.IsQuit == false).FirstOrDefault();
var roomroles = db.RoomRoles.Where(t => t.Rid == RequestMod.RoomId && t.LocationId == RequestMod.LocationId).FirstOrDefault();
if (room == null || roomroles == null)
{
throw new ArgumentException("房间不存在");
}
GoInRoom_Ac_Response ResponseMod = new GoInRoom_Ac_Response()
{
RoomID = room.RoomId,
Pnum = room.PersonsNum,
Victory = room.VictoryCondition,
Role = roomroles.RoleEnum.ToString(),
Location = roomroles.LocationId
};
return(Ok(new AjaxResult()
{
state = ResultType.success.ToString(), data = ResponseMod
}));
}
}
catch (MySqlException e)
{
LogFactory.GetLogger("").Error(Environment.NewLine + DateTime.Now + ":房间进入失败(数据库问题):" + e.Message);
return(Ok(new AjaxResult()
{
state = ResultType.error.ToString(), message = "房间进入失败,请联系管理员"
}));
}
catch (ArgumentException e)
{
return(Ok(new AjaxResult()
{
state = ResultType.error.ToString(), message = e.Message
}));
}
catch (Exception e)
{
return(Ok(new AjaxResult()
{
state = ResultType.error.ToString(), message = "非法操作:" + e.Message
}));
}
}
public IHttpActionResult GameOver([FromBody] EndAction_Ac_Request RequestMod)
{
try
{
if (RequestMod.Roomid < 1)
{
throw new ArgumentException("非法访问");
}
using (MysqlDbContext db = new MysqlDbContext())
{
var room = db.Rooms.Where(t => t.RoomId == RequestMod.Roomid & t.IsQuit == false).FirstOrDefault();
var roomroles = db.RoomRoles.Where(t => t.Rid == RequestMod.Roomid);
if (room == null || roomroles == null)
{
throw new ArgumentException("房间不存在");
}
db.RoomRoles.RemoveRange(roomroles);
int i = db.SaveChanges();
GoInRoom_Ac_Response ResponseMod = new GoInRoom_Ac_Response()
{
RoomID = room.RoomId,
Pnum = room.PersonsNum
};
return(Ok(new AjaxResult()
{
state = ResultType.success.ToString(), data = ResponseMod
}));
}
}
catch (MySqlException e)
{
LogFactory.GetLogger("").Error(Environment.NewLine + DateTime.Now + ":记录删除失败:" + e.Message);
return(Ok(new AjaxResult()
{
state = ResultType.error.ToString(), message = "记录删除失败,请重试"
}));
}
catch (ArgumentException e)
{
return(Ok(new AjaxResult()
{
state = ResultType.error.ToString(), message = e.Message
}));
}
catch (Exception e)
{
return(Ok(new AjaxResult()
{
state = ResultType.error.ToString(), message = "非法操作:" + e.Message
}));
}
}
public void Post([FromBody] lgview v)
{
MysqlDbContext db = new MysqlDbContext();
lg g = new lg
{
ip = v.ii,
gz = v.gg,
bs = v.bb
};
db.LG.Add(g);
db.SaveChanges();
}
public IHttpActionResult GameLogs([FromBody] GameLogs_Ac_Request RequestMod)
{
try
{
if (RequestMod.RoomId < 1)
{
throw new ArgumentException("非法访问");
}
using (MysqlDbContext db = new MysqlDbContext())
{
GameLogs_Ac_Response res = new GameLogs_Ac_Response();
res.logs = db.WerewlovesLogs.Where(t => t.RoomId == RequestMod.RoomId).OrderBy(t => t.CreateTime).ToList();
if (res.logs != null)
{
return(Ok(new AjaxResult()
{
state = ResultType.success.ToString(), data = res
}));
}
else
{
return(Ok(new AjaxResult()
{
state = ResultType.error.ToString(), message = "无日志记录"
}));
}
}
}
catch (MySqlException e)
{
LogFactory.GetLogger("").Error(Environment.NewLine + DateTime.Now + "GameLogs记录失败(sql):" + e.Message);
return(Ok(new AjaxResult()
{
state = ResultType.error.ToString(), message = "无日志记录"
}));
}
catch (ArgumentException e)
{
return(Ok(new AjaxResult()
{
state = ResultType.error.ToString(), message = e.Message
}));
}
catch (Exception e)
{
return(Ok(new AjaxResult()
{
state = ResultType.error.ToString(), message = "非法操作:" + e.Message
}));
}
}
public async Task <IActionResult> Index(string lang)
{
var model = new PortfolioViewModel();
Utils.CheckOrRefreshUiStrings(lang);
ViewBag.Title = Utils.GetUiString("title.portfolio");
ViewBag.ActiveLink = 2;
using (var db = new MysqlDbContext(this.ConnectionString))
{
var featuredItem = await db.Portfolio.FirstOrDefaultAsync(p => p.IsFeatured);
}
return(this.View(model));
}
public IHttpActionResult RemoveLogs([FromBody] GameLogs_Ac_Request RequestMod)
{
try
{
if (RequestMod.RoomId < 1)
{
throw new ArgumentException("非法访问");
}
using (MysqlDbContext db = new MysqlDbContext())
{
var ReturnData = db.WerewlovesLogs.Where(t => t.RoomId == RequestMod.RoomId).ToList();
db.WerewlovesLogs.RemoveRange(ReturnData);
db.SaveChanges();
return(Ok(new AjaxResult()
{
state = ResultType.success.ToString()
}));
}
}
catch (MySqlException e)
{
LogFactory.GetLogger("").Error(Environment.NewLine + DateTime.Now + "RemoveLogs删除失败(sql):" + e.Message);
return(Ok(new AjaxResult()
{
state = ResultType.error.ToString(), message = e.Message
}));
}
catch (ArgumentException e)
{
return(Ok(new AjaxResult()
{
state = ResultType.error.ToString(), message = e.Message
}));
}
catch (Exception e)
{
return(Ok(new AjaxResult()
{
state = ResultType.error.ToString(), message = "非法操作:" + e.Message
}));
}
}
/// <summary>
/// 返回随机数(强制转换)
/// </summary>
/// <param name="many">几位随机数,最高不超过6</param>
/// <returns></returns>
public static int GetByPower()
{
//if (many < 0 || many > 6) many = 6;
Random r = new Random();
int num = r.Next((int)Math.Pow(10, many), (int)(Math.Pow(10, many + 1) - 1));
//double min=Math.Pow(10, many) ,max=Math.Pow(10, many + 1) - 1;
using (MysqlDbContext db = new MysqlDbContext())
{
var res = db.Rooms.Where(t => t.RoomId == num && t.IsQuit == false).FirstOrDefault();
if (res == null)
{
return(num);
}
else
{
return(GetByPower());
}
}
}
/// <summary>
/// Loads all customers.
/// </summary>
public async void LoadCustomersAsync()
{
App.SetConnectionResource();
switch (App.DataSource)
{
case ConnectionResource.LOCALAPI:
Customers = new ObservableCollection <Customer>(await new WebServiceManager <Customer>().GetAllAsync());
break;
case ConnectionResource.LOCALMYSQL:
using (var ctx = new MysqlDbContext(ConnectionResource.LOCALMYSQL))
{
Customers = new ObservableCollection <Customer>(await ctx.DbSetCustomers.Include(c => c.Address).ToListAsync());
}
break;
default:
break;
}
}
/// <summary>
/// Loads all workers.
/// </summary>
public async void LoadWorkersAsync()
{
#pragma warning disable CS4014
Application.Current.Dispatcher.BeginInvoke(new ThreadStart(() =>
{
try
{
WaitWindow.ShowDialog();
}
catch (InvalidOperationException e)
{
}
}));
#pragma warning restore CS4014
App.SetConnectionResource();
switch (App.DataSource)
{
case ConnectionResource.LOCALAPI:
Workers = new ObservableCollection <Worker>(await new WebServiceManager <Worker>().GetAllAsync());
break;
case ConnectionResource.LOCALMYSQL:
using (var ctx = new MysqlDbContext(ConnectionResource.LOCALMYSQL))
{
Workers = new ObservableCollection <Worker>(await ctx.DbSetWorkers.Include(w => w.Address).ToListAsync());
}
break;
default:
break;
}
await Application.Current.Dispatcher.BeginInvoke(new ThreadStart(() =>
{
WaitWindow.Close();
}));
}
/// <summary>
/// Adds or updates a customer.
/// </summary>
/// <param name="obj"></param>
private async void ExecSaveCustomerAsync(object obj)
{
switch (App.DataSource)
{
case ConnectionResource.LOCALAPI:
WebServiceManager <Customer> webServiceManager = new WebServiceManager <Customer>();
if (Customer.Id == 0) // Saving new customer
{
await webServiceManager.PostAsync(Customer);
}
else // Saving updated customer
{
await webServiceManager.PutAsync(Customer);
}
break;
case ConnectionResource.LOCALMYSQL:
using (var ctx = new MysqlDbContext(ConnectionResource.LOCALMYSQL))
{
if (Customer.Id == 0) // Saving new customer
{
ctx.DbSetCustomers.Add(Customer);
await ctx.SaveChangesAsync();
}
else // Saving updated customer
{
ctx.Entry(Customer).State = EntityState.Modified;
ctx.Entry(Customer.Address).State = EntityState.Modified;
await ctx.SaveChangesAsync();
}
}
break;
default:
break;
}
CustomerView.NavigationService.Navigate(new CustomerListView());
}
public async Task <IActionResult> CreatePost(BlogItem blogItem)
{
if (!ModelState.IsValid)
{
// Fehlerbehandlung
}
using (var db = new MysqlDbContext(this.ConnectionString))
{
var addedBlogPost = await db.Posts.AddAsync(blogItem.Post);
var addedTitleImage = await db.Media.AddAsync(blogItem.TitleImage);
// redirectto home if no entities were saved (because whatever)
// TODO: return to specific error page
if (await db.SaveChangesAsync() == 0)
{
return(this.RedirectToAction("index", "home"));
}
// redirect directly to new blogpost
return(this.RedirectToAction("index", "blog", new { id = addedBlogPost.Entity.Id }));
}
}
public UsersController(MysqlDbContext context)
{
_context = context;
}
/// <summary>
/// Processes the payment.
/// Stock of products decreased, customer gets charged.
/// </summary>
/// <param name="obj"></param>
private async void ExecProceedToPaymentAsync(object obj)
{
Cart.Customer.Money -= Cart.Total;
switch (App.DataSource)
{
case ConnectionResource.LOCALAPI:
await new WebServiceManager <Cart>().PostAsync(Cart);
break;
case ConnectionResource.LOCALMYSQL:
using (var ctx = new MysqlDbContext(ConnectionResource.LOCALMYSQL))
{
ctx.Entry(Cart.Customer).State = EntityState.Modified;
foreach (var item in Cart.Items)
{
ctx.Entry(item.Product).State = EntityState.Modified;
}
ctx.DbSetCarts.Add(Cart);
await ctx.SaveChangesAsync();
}
break;
default:
break;
}
foreach (var item in Cart.Items)
{
if (item.Product.Stock > 0)
{
if (item.Product is CPU)
{
CPUs.Add((CPU)item.Product);
}
else if (item.Product is GPU)
{
GPUs.Add((GPU)item.Product);
}
else if (item.Product is Motherboard)
{
Motherboards.Add((Motherboard)item.Product);
}
else if (item.Product is Memory)
{
Rams.Add((Memory)item.Product);
}
else if (item.Product is Storage)
{
StorageComponents.Add((Storage)item.Product);
}
else if (item.Product is PSU)
{
PSUs.Add((PSU)item.Product);
}
else // Case
{
Cases.Add((Case)item.Product);
}
}
}
Cart.Items.Clear();
Cart.Total = 0;
}
public ArticleService(MysqlDbContext dbContext)
{
this.dbContext = dbContext;
}
public UserController(MysqlDbContext ctx, UserService userService)
{
_ctx = ctx;
_userService = userService;
}
