// private static async Task<CommonClass.MapEditor.Position>
internal async Task GetCatege(Random rm)
{
var index = rm.Next(0, roomUrls.Count);
var roomUrl = roomUrls[index];
var sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(
new
{
c = "GetCatege",
});
var json = await Startup.sendInmationToUrlAndGetRes(roomUrl, sendMsg);
Console.WriteLine(json);
var obj = Newtonsoft.Json.JsonConvert.DeserializeObject <List <string> >(json);
// return obj;
// throw new NotImplementedException();
for (var i = 0; i < obj.Count; i += 2)
{
aModel am = new aModel(obj[i], obj[i + 1]);
material.Add(am);
}
var x = (from item in material
orderby item.modelType, item.modelName ascending
select item).ToList();
material = x.ToList();
}
public static void InitDatabase()
{
aModel db = new aModel();
Database.SetInitializer(new MigrateDatabaseToLatestVersion <aModel, MyConfiguration>());
db.Database.Initialize(false);
}
public async override Task <ActionResult> GetAll()
{
aModel db = new aModel();
try
{
List <eNhapHangNhaCungCapChiTiet> lstDetail = await db.eNhapHangNhaCungCapChiTiet.ToListAsync();
var qDT =
from a in lstDetail
group a by a.IDNhapHangNhaCungCap into b
select new { IDNhapHangNhaCungCap = b.Key, NhapHangNhaCungCapChiTiets = b.ToList() };
List <eNhapHangNhaCungCap> lstMaster = await db.eNhapHangNhaCungCap.ToListAsync();
lstMaster.ForEach(a =>
{
var b = qDT.FirstOrDefault(c => c.IDNhapHangNhaCungCap == a.KeyID);
if (b != null)
{
b.NhapHangNhaCungCapChiTiets.ForEach(c =>
{
a.eNhapHangNhaCungCapChiTiet.Add(c);
});
}
});
List <eNhapHangNhaCungCap> lstResult = new List <eNhapHangNhaCungCap>(lstMaster);
return(Ok(lstResult));
}
catch { return(BadRequest(new List <eNhapHangNhaCungCap>())); }
}
async Task <IActionResult> SaveData(xFeature[] features)
{
aModel db = new aModel();
try
{
await db.Database.BeginTransactionAsync();
IEnumerable <xFeature> lstRemoves = await db.xFeature.ToListAsync();
db.xFeature.RemoveRange(lstRemoves.ToArray());
await db.AddRangeAsync(features.ToArray());
await db.SaveChangesAsync();
db.Database.CommitTransaction();
return(Ok(features));
}
catch (Exception ex)
{
db.Database.RollbackTransaction();
ModelState.AddModelError("Exception_Message", ex.Message);
return(BadRequest(ModelState));
}
}
public virtual async Task <ActionResult> DeleteEntries(Object[] ids)
{
aModel db = new aModel();
try
{
ids = ids ?? new object[] { };
db.BeginTransaction();
foreach (object id in ids)
{
T Item = await db.Set <T>().FindAsync(id);
db.Set <T>().Remove(Item);
}
await db.SaveChangesAsync();
db.CommitTransaction();
return(NoContent(ids));
}
catch (Exception ex)
{
db.RollbackTransaction();
return(BadRequest(ex));
}
}
public async Task <Boolean> DeleteEntries(Object[] ids)
{
try
{
Context = new aModel();
ids = ids ?? new object[] { };
await Context.Database.BeginTransactionAsync();
foreach (object id in ids)
{
T Item = await Context.Set <T>().FindAsync(id);
Context.Set <T>().Remove(Item);
}
await Context.SaveChangesAsync();
Context.Database.CommitTransaction();
return(true);
}
catch
{
Context.Database.RollbackTransaction();
return(false);
}
}
public IList <eTinhThanh> DanhSachTinhThanh()
{
aModel db = new aModel();
try
{
IList <eTinhThanh> lstResult = db.eTinhThanh.ToList();
return(lstResult);
}
catch { return(new List <eTinhThanh>()); }
}
public async Task <T> GetByID(Object id)
{
try
{
Context = new aModel();
T item = await Context.Set <T>().FindAsync(id.ConvertType <T>());
return(item ?? new T());
}
catch { return(new T()); }
}
public async Task <IList <eTinhThanh> > DanhSach63TinhThanh()
{
aModel db = new aModel();
try
{
IList <eTinhThanh> lstResult = await db.eTinhThanh.Where(x => x.IDLoai >= 1 && x.IDLoai <= 2).ToListAsync();
return(lstResult);
}
catch { return(new List <eTinhThanh>()); }
}
public async Task <IEnumerable <T> > GetAll()
{
try
{
Context = new aModel();
IEnumerable <T> lstTemp = await Context.Set <T>().ToListAsync();
IList <T> lstResult = lstTemp.OrderBy <T, String>("Ten").ToList();
return(lstResult);
}
catch { return(new List <T>()); }
}
HttpStatusCode CheckRole(ActionExecutingContext context)
{
try
{
Controller controller = (Controller)context.Controller;
//IPAddress address = context.HttpContext.Connection.RemoteIpAddress;
//ControllerActionDescriptor descriptor = (ControllerActionDescriptor)context.ActionDescriptor;
//string MethodName = context.HttpContext.Request.Method.ToLower();
//string ControllerName = descriptor.ControllerName.ToLower();
//string ActionName = descriptor.ActionName.ToLower();
//string TemplateName = descriptor.AttributeRouteInfo.Template.ToLower();
ControllerActionDescriptor descriptor = (ControllerActionDescriptor)context.ActionDescriptor;
string MethodName = context.HttpContext.Request.Method.ToLower();
string ControllerName = descriptor.ControllerName.ToLower();
string ActionName = descriptor.ActionName.ToLower();
string TemplateName = descriptor.AttributeRouteInfo.Template.ToLower();
aModel db = new aModel();
xAccount account = db.xAccount.Find(Convert.ToInt32(controller.Request.Headers["IDAccount"].ToList()[0]));
if (account == null)
{
return(HttpStatusCode.BadRequest);
}
xUserFeature userFeature = db.xUserFeature
.FirstOrDefault(x =>
x.IDPermission == account.IDPermission &&
x.Controller.Equals(ControllerName) &&
x.Action.Equals(ActionName) &&
x.Method.Equals(MethodName) &&
x.Path.Equals(TemplateName));
if (userFeature == null)
{
return(HttpStatusCode.BadRequest);
}
if (userFeature.TrangThai == 3)
{
return(HttpStatusCode.BadRequest);
}
return(HttpStatusCode.OK);
}
catch
{
return(HttpStatusCode.BadRequest);
}
}
public async Task AddModel(aModel m, WebSocket webSocket)
{
this.ID = "n" + Guid.NewGuid().ToString("N");
var sn = new
{
c = "AddModel",
WebSocketID = 0,
aModel = m,
id = this.ID
};
var sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(sn);
var sendData = Encoding.ASCII.GetBytes(sendMsg);
await webSocket.SendAsync(new ArraySegment <byte>(sendData, 0, sendData.Length), WebSocketMessageType.Text, true, CancellationToken.None);
}
public async override Task <ActionResult> UpdateEntries(eNhapHangNhaCungCap[] Items)
{
aModel db = new aModel();
try
{
db.BeginTransaction();
db.eNhapHangNhaCungCap.AddOrUpdate(Items);
Items.ToList().ForEach(async x =>
{
IEnumerable <eNhapHangNhaCungCapChiTiet> lstDetail = await db.eNhapHangNhaCungCapChiTiet.Where(y => y.IDNhapHangNhaCungCap == x.KeyID).ToListAsync();
lstDetail.ToList().ForEach(y =>
{
eNhapHangNhaCungCapChiTiet obj = x.eNhapHangNhaCungCapChiTiet.FirstOrDefault(z => z.KeyID == y.KeyID);
if (obj == null)
{
db.eNhapHangNhaCungCapChiTiet.Remove(y);
}
else
{
db.Entry(y).CurrentValues.SetValues(obj);
}
});
x.eNhapHangNhaCungCapChiTiet.ToList().ForEach(y =>
{
if (y.KeyID <= 0)
{
y.IDNhapHangNhaCungCap = x.KeyID;
db.eNhapHangNhaCungCapChiTiet.Add(y);
}
});
});
await CapNhatCongNo(db, Items);
await CapNhatTonKho(db, Items);
await db.SaveChangesAsync();
db.CommitTransaction();
return(Ok(Items));
}
catch (Exception ex)
{
db.RollbackTransaction();
return(BadRequest(ex));
}
}
public async override Task <ActionResult> GetByID(Object id)
{
aModel db = new aModel();
try
{
eNhapHangNhaCungCap Item = await db.eNhapHangNhaCungCap.FindAsync(id);
IEnumerable <eNhapHangNhaCungCapChiTiet> lstItemDetail = await db.eNhapHangNhaCungCapChiTiet.Where(x => x.IDNhapHangNhaCungCap == Item.KeyID).ToListAsync();
lstItemDetail.ToList().ForEach(x => Item.eNhapHangNhaCungCapChiTiet.Add(x));
return(Ok(Item));
}
catch { return(BadRequest(new eNhapHangNhaCungCap())); }
}
async static void InitDonViTinh()
{
aModel db = new aModel();
await Task.Factory.StartNew(() =>
{
if (db.eDonViTinh.Count() == 0)
{
try
{
string Query = File.ReadAllText($@"{Directory.GetCurrentDirectory()}\wwwroot\InitData\DATA_eDonViTinh.sql");
db.Database.ExecuteSqlCommandAsync(Query, new SqlParameter[] { }).Wait();
}
catch { }
}
});
}
public async Task <ActionResult> CongNoHienTai(int IDMaster, int IDNhaCungCap, DateTime NgayHienTai)
{
aModel db = new aModel();
try
{
IEnumerable <eCongNoNhaCungCap> lstCongNo = await db.eCongNoNhaCungCap.Where(x => x.IDNhaCungCap == IDNhaCungCap).ToListAsync();
lstCongNo = lstCongNo.Where(x => x.Ngay.Date <= NgayHienTai.Date);
eCongNoNhaCungCap congNo = lstCongNo.FirstOrDefault(x => x.IDMaster == IDMaster) ?? new eCongNoNhaCungCap();
congNo.ConLai = lstCongNo.Where(x => x.IDMaster != IDMaster).ToList().Sum(x => x.ConLai);
return(Ok(congNo));
}
catch { return(BadRequest(new eCongNoNhaCungCap())); }
}
void GetPrimaryKey()
{
aModel db = new aModel();
ModuleHelper.ListKeys = new List <IKey>();
var eTypes = db.Model.GetEntityTypes();
foreach (var eType in eTypes)
{
var keys = eType.GetKeys();
foreach (var key in keys)
{
ModuleHelper.ListKeys.Add(key);
}
}
}
public virtual async Task <ActionResult> GetByID(Object id)
{
aModel db = new aModel();
try
{
//T item = await db.Set<T>().FindAsync(id.ConvertType<T>());
T Item = await db.Set <T>().FindAsync(id);
return(Ok(Item ?? new T()));
}
catch
{
return(BadRequest(new T()));
}
}
async Task <IActionResult> InitTinhThanh()
{
aModel db = new aModel();
if (db.eTinhThanh.Count() == 0)
{
try
{
string Query = System.IO.File.ReadAllText($@"{Directory.GetCurrentDirectory()}\wwwroot\InitData\DATA_eTinhThanh.sql");
await db.Database.ExecuteSqlCommandAsync(Query, new SqlParameter[] { });
return(Ok($"Init data {(typeof(eTinhThanh).Name)} success."));
}
catch (Exception ex) { return(BadRequest($"Init data {(typeof(eTinhThanh).Name)} fail: {ex}")); }
}
return(Ok($"No init {(typeof(eTinhThanh).Name)} data"));
}
async Task <ActionResult> InitDonViTinh()
{
aModel db = new aModel();
if (db.eDonViTinh.Count() == 0)
{
try
{
string Query = System.IO.File.ReadAllText($@"{HttpRuntime.AppDomainAppPath}\wwwroot\InitData\DATA_eDonViTinh.sql");
await db.Database.ExecuteSqlCommandAsync(Query, new SqlParameter[] { });
return(Ok($"Init data {(typeof(eDonViTinh).Name)} success."));
}
catch (Exception ex) { return(BadRequest($"Init data {(typeof(eDonViTinh).Name)} fail: {ex}")); }
}
return(Ok($"No init {(typeof(eDonViTinh).Name)} data"));
}
public virtual async Task <ActionResult> GetAll()
{
aModel db = new aModel();
try
{
IEnumerable <T> lstTemp = await db.Set <T>().ToListAsync();
//IList<T> lstResult = lstTemp.OrderBy<T, String>("Ten").ToList();
List <T> lstResult = lstTemp.ToList();
return(Ok(lstResult));
}
catch
{
return(BadRequest(new List <T>()));
}
}
private static void GetPrimaryKeys(aModel db)
{
string qSelectKey =
"SELECT DISTINCT " +
" PK_TableName = PK.TABLE_NAME, " +
" PK_ColumnName = CU.COLUMN_NAME, " +
" PK_Indentity = CAST(p.IS_IDENTITY as bit), " +
" FK_TableName = '', " +
" FK_ColumnName = '', " +
" FK_Indentity = CAST(0 as bit) " +
"FROM " +
" INFORMATION_SCHEMA.TABLE_CONSTRAINTS PK " +
" LEFT JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CU ON CU.Table_Name = PK.Table_Name " +
" LEFT JOIN( " +
" SELECT c.name COLUMN_NAME, t.name TABLE_NAME, c.is_identity IS_IDENTITY " +
" FROM " +
" sys.tables t " +
" left join sys.columns c on c.object_id= t.object_id) p ON p.COLUMN_NAME = CU.COLUMN_NAME and p.TABLE_NAME = PK.TABLE_NAME " +
"WHERE " +
" CU.Constraint_Name = PK.Constraint_Name AND Constraint_Type = 'PRIMARY KEY' " +
"UNION " +
"SELECT DISTINCT " +
" PK_TableName = PK.TABLE_NAME, " +
" PK_ColumnName = PT.COLUMN_NAME, " +
" PK_Indentity = CAST(0 as bit), " +
" FK_TableName = FK.TABLE_NAME, " +
" FK_ColumnName = CU.COLUMN_NAME, " +
" FK_Indentity = CAST(0 as bit) " +
"FROM " +
" INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS C " +
" LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS FK ON C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME " +
" LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS PK ON C.UNIQUE_CONSTRAINT_NAME = PK.CONSTRAINT_NAME " +
" LEFT JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE CU ON C.CONSTRAINT_NAME = CU.CONSTRAINT_NAME " +
" LEFT JOIN( " +
" SELECT DISTINCT " +
" i1.TABLE_NAME, " +
" i2.COLUMN_NAME " +
" FROM " +
" INFORMATION_SCHEMA.TABLE_CONSTRAINTS i1 " +
" LEFT JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE i2 ON i1.CONSTRAINT_NAME = i2.CONSTRAINT_NAME " +
" WHERE " +
" i1.CONSTRAINT_TYPE = 'PRIMARY KEY') PT ON PT.TABLE_NAME = PK.TABLE_NAME";
lstSchemaKeys = new List <ColumnKey>(db.Database.SqlQuery <ColumnKey>(qSelectKey).ToList());
}
public async Task DrawModel(aModel m, CommonClass.databaseModel.detailmodel dm, WebSocket webSocket)
{
//this.ID = "n" + Guid.NewGuid().ToString("N");
var sn = new
{
c = "DrawModel",
WebSocketID = 0,
aModel = m,
id = dm.modelID,
x = dm.x,
y = dm.y,
z = dm.z,
r = dm.rotatey
};
var sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(sn);
var sendData = Encoding.ASCII.GetBytes(sendMsg);
await webSocket.SendAsync(new ArraySegment <byte>(sendData, 0, sendData.Length), WebSocketMessageType.Text, true, CancellationToken.None);
}
async Task CapNhatTonKho(aModel db, eNhapHangNhaCungCap[] Items)
{
foreach (eNhapHangNhaCungCap item in Items)
{
foreach (eNhapHangNhaCungCapChiTiet itemDT in item.eNhapHangNhaCungCapChiTiet)
{
eTonKho tonKho = await db.eTonKho.FirstOrDefaultAsync(x => x.IsNhapHang && x.IDMaster == item.KeyID && x.IDDetail == itemDT.KeyID);
if (tonKho == null)
{
tonKho = new eTonKho();
tonKho.IDSanPham = itemDT.IDSanPham;
tonKho.IDNhomSanPham = itemDT.IDNhomSanPham;
tonKho.IDDonViTinh = itemDT.IDDonViTinh;
tonKho.IDMaster = item.KeyID;
tonKho.IDDetail = itemDT.KeyID;
tonKho.NguoiTao = item.NguoiTao;
tonKho.MaNguoiTao = item.MaNguoiTao;
tonKho.TenNguoiTao = item.TenNguoiTao;
tonKho.NgayTao = item.NgayTao;
tonKho.IsNhapHang = true;
db.eTonKho.AddOrUpdate(tonKho);
}
else
{
tonKho.NguoiCapNhat = item.NguoiCapNhat;
tonKho.MaNguoiCapNhat = item.MaNguoiCapNhat;
tonKho.TenNguoiCapNhat = item.TenNguoiCapNhat;
tonKho.NgayCapNhat = item.NgayCapNhat;
}
tonKho.Ngay = item.NgayNhap;
tonKho.MaSanPham = itemDT.MaSanPham;
tonKho.TenSanPham = itemDT.TenSanPham;
tonKho.MaNhomSanPham = itemDT.MaNhomSanPham;
tonKho.TenNhomSanPham = itemDT.TenNhomSanPham;
tonKho.MaDonViTinh = itemDT.MaDonViTinh;
tonKho.TenDonViTinh = itemDT.TenDonViTinh;
tonKho.HanSuDung = itemDT.HanSuDung;
tonKho.SoLuongSi = itemDT.SoLuongSi;
tonKho.SoLuongLe = itemDT.SoLuongLe;
tonKho.SoLuong = itemDT.SoLuong;
}
}
}
public async Task <Boolean> UpdateEntry(T Item)
{
try
{
Context = new aModel();
await Context.Database.BeginTransactionAsync();
Context.Set <T>().Update(Item);
await Context.SaveChangesAsync();
Context.Database.CommitTransaction();
return(true);
}
catch
{
Context.Database.RollbackTransaction();
return(false);
}
}
public virtual async Task <ActionResult> UpdateEntry(T Item)
{
aModel db = new aModel();
try
{
db.BeginTransaction();
db.Set <T>().AddOrUpdate(Item);
await db.SaveChangesAsync();
db.CommitTransaction();
return(Ok(Item));
}
catch (Exception ex)
{
db.RollbackTransaction();
return(BadRequest(ex));
}
}
public async Task <ActionResult> Login()
{
aModel db = new aModel();
try
{
string Username = Request.Headers["Username"];
string Password = Request.Headers["Password"];
if (string.IsNullOrWhiteSpace(Username) || string.IsNullOrWhiteSpace(Password))
{
throw new Exception("Username hoặc Password không hợp lệ");
}
xTaiKhoan account = await db.xTaiKhoan.FirstOrDefaultAsync(x => x.Username.ToLower().Equals(Username.ToLower()) && x.Password.ToLower().Equals(Password.ToLower()));
if (account == null)
{
throw new Exception("Tài khoản không tồn tại");
}
xNhanVien personnel = await db.xNhanVien.FindAsync(account.KeyID);
if (personnel == null)
{
throw new Exception("Nhân viên không tồn tại");
}
ThongTinNguoiDung user = new ThongTinNguoiDung()
{
xPersonnel = personnel,
xAccount = account
};
return(Ok(user));
}
catch (Exception ex)
{
ModelState.AddModelError("Exception_Message", ex.Message);
return(BadRequest(ModelState));
}
}
public virtual async Task <ActionResult> DeleteEntry(T Item)
{
aModel db = new aModel();
try
{
db.BeginTransaction();
db.Set <T>().Attach(Item);
db.Set <T>().Remove(Item);
await db.SaveChangesAsync();
db.CommitTransaction();
return(NoContent(Item));
}
catch (Exception ex)
{
db.RollbackTransaction();
return(BadRequest(ex));
}
}
async Task CapNhatCongNo(aModel db, eNhapHangNhaCungCap[] Items)
{
foreach (eNhapHangNhaCungCap item in Items)
{
eCongNoNhaCungCap congNo = await db.eCongNoNhaCungCap.FirstOrDefaultAsync(x => x.IsNhapHang && x.IDMaster == item.KeyID);
if (congNo == null)
{
congNo = new eCongNoNhaCungCap();
congNo.IDNhaCungCap = item.IDNhaCungCap;
congNo.IDMaster = item.KeyID;
congNo.NguoiTao = item.NguoiTao;
congNo.MaNguoiTao = item.MaNguoiTao;
congNo.TenNguoiTao = item.TenNguoiTao;
congNo.NgayTao = item.NgayTao;
congNo.IsNhapHang = true;
db.eCongNoNhaCungCap.AddOrUpdate(congNo);
}
else
{
congNo.NguoiCapNhat = item.NguoiCapNhat;
congNo.MaNguoiCapNhat = item.MaNguoiCapNhat;
congNo.TenNguoiCapNhat = item.TenNguoiCapNhat;
congNo.NgayCapNhat = item.NgayCapNhat;
}
congNo.MaNhaCungCap = item.MaNhaCungCap;
congNo.TenNhaCungCap = item.TenNhaCungCap;
congNo.TrangThai = item.TrangThai;
congNo.Ngay = item.NgayNhap;
congNo.ThanhTien = item.ThanhTien;
congNo.VAT = item.VAT;
congNo.TienVAT = item.TienVAT;
congNo.CK = item.ChietKhau;
congNo.TienCK = item.TienChietKhau;
congNo.TongTien = item.TongTien;
congNo.NoCu = item.NoCu;
congNo.ThanhToan = item.ThanhToan;
congNo.ConLai = item.ConLai;
congNo.GhiChu = item.GhiChu;
}
}
public async Task <Boolean> DeleteEntry(Object id)
{
try
{
Context = new aModel();
await Context.Database.BeginTransactionAsync();
T Item = await Context.Set <T>().FindAsync(id);
Context.Set <T>().Remove(Item);
await Context.SaveChangesAsync();
Context.Database.CommitTransaction();
return(true);
}
catch
{
Context.Database.RollbackTransaction();
return(false);
}
}
