public static bool CheckUser_Login(string _UserName, string _Password, xPersonnel personnel, xAccount account)
{
//try
//{
// db = new aModel();
// account = db.xAccount.FirstOrDefault(n => n.UserName.Equals(_UserName) && n.Password.Equals(_Password));
// if (account != null)
// {
// personnel = db.xPersonnel.FirstOrDefault(x => x.KeyID == account.KeyID && x.IsEnable && x.IsAccount);
// if (personnel != null)
// {
// clsGeneral.curAccount = account;
// clsGeneral.curPersonnel = personnel;
// clsGeneral.curUserFeature = new xUserFeature() { IsEnable = true };
// return true;
// }
// else
// return false;
// }
// else
// return false;
//}
return(true);
//catch { return false; }
}
public override async void LoadDataForm()
{
_iEntry = _iEntry ?? new xPersonnel()
{
IsEnable = true
};
_aEntry = await clsPersonnel.Instance.GetByID(_iEntry.KeyID);
SetControlValue();
}
protected override void grv_TopRowChanged <T>(object sender, EventArgs e, IList <T> ListData, string query, SqlParameter[] parameters)
{
GridView view = (GridView)sender;
xPersonnel personnel = view.GetRow(GetGridViewLastRow(view)) as xPersonnel;
if (personnel == null)
{
return;
}
query = $"select top 10 * from xPersonnel where KeyID>@KeyID";
parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@KeyID", personnel.KeyID);
base.grv_TopRowChanged(sender, e, ListData, query, parameters);
}
public async Task <IActionResult> Login([FromHeader] string Username, [FromHeader] string Password)
{
aModel db = new aModel();
try
{
if (string.IsNullOrWhiteSpace(Username) || string.IsNullOrWhiteSpace(Password))
{
throw new Exception("Username hoặc Password không hợp lệ");
}
xAccount account = await db.xAccount.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");
}
xPersonnel personnel = await db.xPersonnel.FindAsync(account.KeyID);
if (personnel == null)
{
throw new Exception("Nhân viên không tồn tại");
}
UserInfo user = new UserInfo()
{
xPersonnel = personnel,
xAccount = account
};
return(Ok(user));
}
catch (Exception ex)
{
ModelState.AddModelError("Exception_Message", ex.Message);
return(BadRequest(ModelState));
}
}
public async override void DeleteEntry()
{
//int[] Indexes = grvPersonnelList.GetSelectedRows();
//List<int> lstIDNhanVien = new List<int>();
//List<int> lstIDTaiKhoan = new List<int>();
//bool IsWarming = false;
//for (int i = 0; i < Indexes.Length; i++)
//{
// xPersonnel personnel = (xPersonnel)grvPersonnelList.GetRow(Indexes[i]);
// if (!IsWarming)
// {
// //Thông báo nếu chưa được cảnh báo nhân viên đã có tài khoản
// if (personnel.IsAccount)
// {
// bool IsXoa = clsGeneral.showConfirmMessage("Nhân viên đã có tài khoản! Xác nhận xóa tài khoản của nhân viên này?");
// if (IsXoa)
// {
// lstIDNhanVien.Add(personnel.KeyID);
// lstIDTaiKhoan.Add(personnel.KeyID);
// }
// }
// else
// {
// lstIDNhanVien.Add(personnel.KeyID);
// }
// }
// else
// {
// lstIDNhanVien.Add(personnel.KeyID);
// if (personnel.IsAccount)
// lstIDTaiKhoan.Add(personnel.KeyID);
// }
// //Thông báo có áp dụng cho các trường hợp nhân viên đã có tài khoản
// if (!IsWarming && personnel.IsAccount) IsWarming = clsGeneral.showConfirmMessage("Áp dụng cho tất cả nhân viên được xóa?");
//}
//clsPersonnel.Instance.Init();
//clsPersonnel.Instance.SetEntity(typeof(xPersonnel).Name, lstIDNhanVien);
//clsPersonnel.Instance.SetEntity(typeof(xAccount).Name, lstIDTaiKhoan);
//clsPersonnel.Instance.ReloadProgress = LoadProgress;
//clsPersonnel.Instance.ReloadPercent = LoadPercent;
//clsPersonnel.Instance.ReloadMessage = LoadMessage;
//clsPersonnel.Instance.ReloadError = LoadError;
//clsPersonnel.Instance.ReloadData = loadData;
//clsPersonnel.Instance.StartRun();
int[] Indexes = grvPersonnelList.GetSelectedRows();
List <xPersonnel> lstNhanVien = new List <xPersonnel>();
for (int i = 0; i < Indexes.Length; i++)
{
xPersonnel personnel = (xPersonnel)grvPersonnelList.GetRow(Indexes[i]);
personnel.Address = "ABCDEF";
lstNhanVien.Add(personnel);
}
//clsPersonnel.Instance.Init();
//clsPersonnel.Instance.SetEntity(typeof(xPersonnel).Name, lstNhanVien.ToList<object>());
//clsPersonnel.Instance.ReloadProgress = OpenProgress;
//clsPersonnel.Instance.ReloadPercent = LoadPercent;
//clsPersonnel.Instance.ReloadMessage = LoadMessage;
//clsPersonnel.Instance.ReloadError = LoadError;
//clsPersonnel.Instance.StartRun();
// lstPersonnel = new List<xPersonnel>();
await clsPersonnel.Instance.AddOrUpdate(lstNhanVien);
}
public async Task <IActionResult> InitUser()
{
aModel db = new aModel();
DateTime time = DateTime.Now;
try
{
await db.Database.BeginTransactionAsync();
xPermission permission = new xPermission()
{
KeyID = 0,
Ma = "ADMIN",
Ten = "ADMIN",
NgayTao = time
};
await db.xPermission.AddAsync(permission);
await db.SaveChangesAsync();
xPersonnel personnel = new xPersonnel()
{
KeyID = 0,
Ma = "NV0001",
Ten = "Nhân viên 0001",
NgayTao = time
};
await db.xPersonnel.AddAsync(personnel);
await db.SaveChangesAsync();
xAccount account = new xAccount()
{
KeyID = personnel.KeyID,
NgayTao = time,
PersonelName = personnel.Ten,
UserName = "******",
Password = "******",
IDPermission = permission.KeyID,
PermissionName = permission.Ten
};
await db.xAccount.AddAsync(account);
await db.SaveChangesAsync();
List <xFeature> features = await db.xFeature.ToListAsync();
List <xUserFeature> userFeatures = new List <xUserFeature>();
foreach (xFeature f in features)
{
userFeatures.Add(new xUserFeature()
{
KeyID = 0,
IDPermission = permission.KeyID,
PermissionName = permission.Ten,
IDFeature = f.KeyID,
Controller = f.Controller,
Action = f.Action,
Method = f.Method,
Template = f.Template,
Path = f.Path,
NgayTao = time
});
}
await db.xUserFeature.AddRangeAsync(userFeatures.ToArray());
await db.SaveChangesAsync();
db.Database.CommitTransaction();
return(Ok(userFeatures));
}
catch (Exception ex)
{
db.Database.RollbackTransaction();
ModelState.AddModelError("Exception_Message", ex.Message);
return(BadRequest(ModelState));
}
}
public override void RenewData()
{
_iEntry = _aEntry = null;
}
