public string Create(string UserName, string FullName, string DOB, string Email, string PhoneNumber, string Active, List <String> RoleName)
{
var accTest = _context.Accounts.Where(m => m.UserName == UserName).SingleOrDefault();
if (accTest == null)
{
if (ModelState.IsValid)
{
try
{
Account account = new Account()
{
UserName = UserName,
Password = "******",
FullName = FullName,
DOB = DateTime.ParseExact(DOB, "dd/MM/yyyy", null),
Email = Email,
PhoneNumber = PhoneNumber,
Active = Convert.ToBoolean(Active),
};
_context.Accounts.Add(account);
foreach (var i in RoleName)
{
Account_Role ar = new Account_Role()
{
RoleName = i,
UserName = UserName
};
_context.Account_Roles.Add(ar);
}
_context.SaveChanges();
return("success");
}catch (DbUpdateConcurrencyException)
{
return("");
}
}
}
else if (accTest != null)
{
ModelState.AddModelError("UserNameExist", "User Name này đã tồn tại");
}
return("fail");
}
public bool CreateCatalog(string TagName, string deviceName, string Address, string Unit, string WarningMin, string WarningMax)
{
try
{
Catalog_Data cld = new Catalog_Data()
{
TagName = TagName,
DeviceName = deviceName,
Address = Address,
Unit = Unit,
WarnningMin = double.Parse(WarningMin),
WarnningMax = double.Parse(WarningMax)
};
_context.Add(cld);
_context.SaveChanges();
}
catch
{
return(false);
}
return(true);
}
public string UpdateDeivces(string name, string nameShow, string branchOrProtocol)
{
try
{
var d = _context.Devices.Find(name);
if (d == null)
{
return("device không tồn tại");
}
d.NameShow = nameShow;
d.Name = name;
d.BranchOrProtocol = branchOrProtocol;
//remove
_context.SaveChanges();
}
catch (Exception ex)
{
return("Update device không thành công !!!");
}
return("success");
}
public string UpdateRole(string RoleName, string Description, List <String> PermissionRole)
{
try
{
if (PermissionRole == null)
{
PermissionRole = new List <string>();
}
var r = _context.Roles.Find(RoleName);
if (r == null)
{
return("Role không tồn tại");
}
r.Description = Description;
//remove
var getPer = _context.AccoPermission_Roles.Where(x => x.RoleName == RoleName);
foreach (var i in getPer)
{
_context.AccoPermission_Roles.Remove(i);
}
//add new
foreach (var i in PermissionRole)
{
var pe_ro = new Permission_Role()
{
RoleName = RoleName,
PermissionID = int.Parse(i)
};
_context.AccoPermission_Roles.Add(pe_ro);
}
_context.SaveChanges();
}
catch (Exception ex)
{
}
return("success");
}
public string Edit(string FullName, string Email, string Dob, string phoneNumber, string Password)
{
if (ModelState.IsValid)
{
var account = _db.Accounts.FirstOrDefault(x => x.UserName == HttpContext.Session.GetString("UserName").ToString());
if (account != null)
{
account.FullName = FullName;
account.Password = Password;
account.Email = Email;
account.DOB = DateTime.ParseExact(Dob, "dd/MM/yyyy", null);;
account.PhoneNumber = phoneNumber;
}
_db.SaveChanges();
HttpContext.Session.SetObjectAsJson("Account", account);
return("success");
}
return("fali");
}