public void GetAllUsers_Returns_Users()
{
dbContext.AddRange(UsersData.Entries);
dbContext.SaveChanges();
var users = usersService.GetAllUsers();
users.Should().HaveCount(3);
}
public void AddUserAccount(UserSignUpView user)
{
using (DemoDBContext db = new DemoDBContext()) {
Sysuser SU = new Sysuser();
SU.LoginName = user.LoginName;
SU.PasswordEncryptedText = user.Password;
SU.RowCreatedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1;
SU.RowModifiedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1;;
SU.RowCreatedDateTime = DateTime.Now;
SU.RowModifiedDateTime = DateTime.Now;
db.Sysuser.Add(SU);
db.SaveChanges();
SysuserProfile SUP = new SysuserProfile();
SUP.SysuserId = SU.SysuserId;
SUP.FirstName = user.FirstName;
SUP.LastName = user.LastName;
SUP.Gender = user.Gender;
SUP.RowCreatedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUP.RowModifiedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUP.RowCreatedDateTime = DateTime.Now;
SUP.RowModifiedDateTime = DateTime.Now;
db.SysuserProfile.Add(SUP);
db.SaveChanges();
if (user.LOOKUPRoleID > 0)
{
SysuserRole SUR = new SysuserRole();
SUR.LookuproleId = user.LOOKUPRoleID;
SUR.SysuserId = user.SYSUserID;
SUR.IsActive = true;
SUR.RowCreatedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUR.RowModifiedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUR.RowCreatedDateTime = DateTime.Now;
SUR.RowModifiedDateTime = DateTime.Now;
db.SysuserRole.Add(SUR);
db.SaveChanges();
}
}
}
public IActionResult PostCustomers([FromBody] Customers customers)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.Customers.Add(customers);
_context.SaveChanges();
return(CreatedAtAction("GetCustomers", new { id = customers.CustomerId }, customers));
}
static void Main(string[] args)
{
System.Console.WriteLine("Try and create some items");
using (DemoDBContext db = new DemoDBContext())
{
try
{
//Se crean un elemento cualquiera
Item item1 = new Item()
{
Name = "Item1" + DateTime.Now.ToShortDateString(),
Description = "Description:" + DateTime.Now.ToLongDateString()
};
//Se agregan a la coleccion en el db context
db.Items.Add(item1);
//Se guardan los cambios
db.SaveChanges();
System.Console.WriteLine("Item CREATED!!!");
System.Console.ReadKey();
}
catch (Exception ex)
{
System.Console.WriteLine("Something bad happened :(");
System.Console.Write(ex);
System.Console.ReadKey();
}
}
//Then we can do the same to list the items in the database
System.Console.WriteLine("/n Items in the database so far:");
using (DemoDBContext db = new DemoDBContext())
{
foreach (var item in db.Items)
{
System.Console.WriteLine("---Item---");
System.Console.WriteLine("Id: " + item.Id);
System.Console.WriteLine("Name: " + item.Name);
System.Console.WriteLine("Description: " + item.Description);
}
System.Console.ReadKey();
}
}
public void UpdateUserAccount(UserProfileView user)
{
using (DemoDBContext db = new DemoDBContext()) {
using (var dbContextTransaction = db.Database.BeginTransaction()) {
try {
Sysuser SU = db.Sysuser.Find(user.SYSUserID);
SU.LoginName = user.LoginName;
SU.PasswordEncryptedText = user.Password;
SU.RowCreatedSysuserId = user.SYSUserID;
SU.RowModifiedSysuserId = user.SYSUserID;
SU.RowCreatedDateTime = DateTime.Now;
SU.RowModifiedDateTime = DateTime.Now;
db.SaveChanges();
var userProfile = db.SysuserProfile.Where(o => o.SysuserId == user.SYSUserID);
if (userProfile.Any())
{
SysuserProfile SUP = userProfile.FirstOrDefault();
SUP.SysuserId = SU.SysuserId;
SUP.FirstName = user.FirstName;
SUP.LastName = user.LastName;
SUP.Gender = user.Gender;
SUP.RowCreatedSysuserId = user.SYSUserID;
SUP.RowModifiedSysuserId = user.SYSUserID;
SUP.RowCreatedDateTime = DateTime.Now;
SUP.RowModifiedDateTime = DateTime.Now;
db.SaveChanges();
}
if (user.LOOKUPRoleID > 0)
{
var userRole = db.SysuserRole.Where(o => o.SysuserId == user.SYSUserID);
SysuserRole SUR = null;
if (userRole.Any())
{
SUR = userRole.FirstOrDefault();
SUR.LookuproleId = user.LOOKUPRoleID;
SUR.SysuserId = user.SYSUserID;
SUR.IsActive = true;
SUR.RowCreatedSysuserId = user.SYSUserID;
SUR.RowModifiedSysuserId = user.SYSUserID;
SUR.RowCreatedDateTime = DateTime.Now;
SUR.RowModifiedDateTime = DateTime.Now;
}
else
{
SUR = new SysuserRole();
SUR.LookuproleId = user.LOOKUPRoleID;
SUR.SysuserId = user.SYSUserID;
SUR.IsActive = true;
SUR.RowCreatedSysuserId = user.SYSUserID;
SUR.RowModifiedSysuserId = user.SYSUserID;
SUR.RowCreatedDateTime = DateTime.Now;
SUR.RowModifiedDateTime = DateTime.Now;
db.SysuserRole.Add(SUR);
}
db.SaveChanges();
}
dbContextTransaction.Commit();
}
catch {
dbContextTransaction.Rollback();
}
}
}
}
public int Complete()
{
return(_context.SaveChanges());
}
