protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
ToDoStatus toDoStatus = new ToDoStatus
{
Id = 1,
Title = "Not Complete",
};
modelBuilder.Entity <ToDoStatus>().HasData(toDoStatus);
modelBuilder.Entity <ToDoStatus>().HasData(
new ToDoStatus()
{
Id = 2,
Title = "In Progress"
},
new ToDoStatus()
{
Id = 3,
Title = "Complete"
}
);
}
public ToDoQuery WithStatus(ToDoStatus value = null,
ArgumentEvaluationMode mode = ArgumentEvaluationMode.IgnoreNeutral,
EntityOperator @operator = EntityOperator.Equal)
{
switch (mode)
{
case ArgumentEvaluationMode.IgnoreNeutral:
if (Neutrals.Is(value))
{
return(this);
}
break;
case ArgumentEvaluationMode.Explicit:
break;
default:
throw new NotSupportedEnumException(mode);
}
switch (@operator)
{
case EntityOperator.Equal:
Entities = Entities.Where(td => td.Status == value);
return(this);
case EntityOperator.NotEqual:
Entities = Entities.Where(td => td.Status != value);
return(this);
default:
throw new NotSupportedEnumException(@operator);
}
}
public ToDoStatus GetToDoStatus(int toDoStatusId)
{
ToDoStatus toDoStatus = null;
string queryString =
SelectString +
"WHERE ToDoStatusId = @ToDoStatusId;";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = connection.CreateCommand();
command.CommandText = queryString;
command.Parameters.Add(new SqlParameter("@ToDoStatusId", toDoStatusId));
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
toDoStatus = Read(reader);
}
}
}
return(toDoStatus);
}
public ToDo(Guid id)
{
ID = id;
DataRow row = getRow(ID).Rows[0];
Timestamp = DBUtil.parseData <DateTime>(row, COL_DB_TIMESTAMP);
Description = DBUtil.parseData <string>(row, COL_DB_DESCRIPTION);
Status = Tools.parseEnum <ToDoStatus>(DBUtil.parseData <Int16>(row, COL_DB_STATUSENUMID));
CustomerID = DBUtil.parseData <Guid?>(row, COL_DB_CUSTOMERID);
VendorID = DBUtil.parseData <Guid?>(row, COL_DB_VENDORID);
CustomerName = DBUtil.parseData <string>(row, COL_CUSTOMERNAME);
VendorName = DBUtil.parseData <string>(row, COL_VENDORNAME);
}
public IEnumerable <ToDoItem> GetByStatus_Original(ToDoStatus status)
{
try
{
// return new List<string>(new string[] { status.ToString() });
ToDoRepository tdr = new ToDoRepository();
var lst = tdr.GetByStatus(status);
return(lst);
}
catch (Exception ex)
{
_logger.LogError("GetByStatus: " + ex.Message);
return(new List <ToDoItem>());
}
}
public ToDoStatus Delete(Guid identifier)
{
// Load item that will be deleted
ToDoStatus dbEntry = context.ToDoStatuses
.FirstOrDefault(x => x.Identifier == identifier);
if (dbEntry != null)
{
// Set activity
dbEntry.Active = false;
// Set timestamp
dbEntry.UpdatedAt = DateTime.Now;
}
return(dbEntry);
}
public static void updateStatus(Guid id, ToDoStatus statusEnumID)
{
SqlQueryResult result = DBConnection.query(
false,
DBConnection.ActiveSqlConnection,
QueryTypes.ExecuteNonQuery,
"todo_update_status",
new SqlQueryParameter(COL_DB_ID, SqlDbType.UniqueIdentifier, id),
new SqlQueryParameter(COL_DB_STATUSENUMID, SqlDbType.TinyInt, statusEnumID)
);
if (result.IsSuccessful)
{
ActivityLog.submit(id, "Update Status to " + statusEnumID.ToString());
}
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
// Create a Default, new user for Identity Framework
ApplicationUser user = new ApplicationUser
{
FirstName = "Rose",
LastName = "Wiz",
UserName = "******",
NormalizedUserName = "******",
Email = "*****@*****.**",
NormalizedEmail = "*****@*****.**",
EmailConfirmed = true,
LockoutEnabled = false,
SecurityStamp = "7f434309-a4d9-48e9-9ebb-8803db794577",
Id = "00000000-ffff-ffff-ffff-ffffffffffff"
};
var passwordHash = new PasswordHasher <ApplicationUser>();
user.PasswordHash = passwordHash.HashPassword(user, "Admin8*");
modelBuilder.Entity <ApplicationUser>().HasData(user);
//Create shopping items
ToDoStatus status = new ToDoStatus
{
Id = 1,
Title = "To Do"
};
modelBuilder.Entity <ToDoStatus>().HasData(status);
modelBuilder.Entity <ToDoStatus>().HasData(
new ToDoStatus()
{
Id = 2,
Title = "In Progress"
},
new ToDoStatus()
{
Id = 3,
Title = "Done"
}
);
}
public static ToDoStatus ConvertToToDoStatus(this ToDoStatusViewModel toDoStatusViewModel)
{
ToDoStatus toDoStatus = new ToDoStatus()
{
Id = toDoStatusViewModel.Id,
Identifier = toDoStatusViewModel.Identifier,
Code = toDoStatusViewModel.Code,
Name = toDoStatusViewModel.Name,
CreatedById = toDoStatusViewModel.CreatedBy?.Id ?? null,
CompanyId = toDoStatusViewModel.Company?.Id ?? null,
CreatedAt = toDoStatusViewModel.CreatedAt,
UpdatedAt = toDoStatusViewModel.UpdatedAt
};
return(toDoStatus);
}
public static ToDoStatusViewModel ConvertToToDoStatusViewModelLite(this ToDoStatus toDoStatus)
{
ToDoStatusViewModel toDoStatusViewModel = new ToDoStatusViewModel()
{
Id = toDoStatus.Id,
Identifier = toDoStatus.Identifier,
Code = toDoStatus.Code,
Name = toDoStatus.Name,
IsActive = toDoStatus.Active,
UpdatedAt = toDoStatus.UpdatedAt,
CreatedAt = toDoStatus.CreatedAt
};
return(toDoStatusViewModel);
}
public ToDoStatusResponse Delete(Guid identifier)
{
ToDoStatusResponse response = new ToDoStatusResponse();
try
{
ToDoStatus deletedToDoStatus = unitOfWork.GetToDoStatusRepository().Delete(identifier);
unitOfWork.Save();
response.ToDoStatus = deletedToDoStatus.ConvertToToDoStatusViewModel();
response.Success = true;
}
catch (Exception ex)
{
response.ToDoStatus = new ToDoStatusViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public ToDoStatusResponse Create(ToDoStatusViewModel re)
{
ToDoStatusResponse response = new ToDoStatusResponse();
try
{
ToDoStatus addedToDoStatus = unitOfWork.GetToDoStatusRepository().Create(re.ConvertToToDoStatus());
unitOfWork.Save();
response.ToDoStatus = addedToDoStatus.ConvertToToDoStatusViewModel();
response.Success = true;
}
catch (Exception ex)
{
response.ToDoStatus = new ToDoStatusViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
private ToDoStatus Read(SqlDataReader reader)
{
ToDoStatus toDoStatus = new ToDoStatus();
toDoStatus.Id = Int32.Parse(reader["ToDoStatusId"].ToString());
toDoStatus.Identifier = Guid.Parse(reader["ToDoStatusIdentifier"].ToString());
if (reader["ToDoStatusCode"] != DBNull.Value)
{
toDoStatus.Code = reader["ToDoStatusCode"].ToString();
}
if (reader["ToDoStatusName"] != DBNull.Value)
{
toDoStatus.Name = reader["ToDoStatusName"].ToString();
}
toDoStatus.Active = bool.Parse(reader["Active"].ToString());
toDoStatus.UpdatedAt = DateTime.Parse(reader["UpdatedAt"].ToString());
if (reader["CreatedById"] != DBNull.Value)
{
toDoStatus.CreatedBy = new User();
toDoStatus.CreatedById = Int32.Parse(reader["CreatedById"].ToString());
toDoStatus.CreatedBy.Id = Int32.Parse(reader["CreatedById"].ToString());
toDoStatus.CreatedBy.FirstName = reader["CreatedByFirstName"]?.ToString();
toDoStatus.CreatedBy.LastName = reader["CreatedByLastName"]?.ToString();
}
if (reader["CompanyId"] != DBNull.Value)
{
toDoStatus.Company = new Company();
toDoStatus.CompanyId = Int32.Parse(reader["CompanyId"].ToString());
toDoStatus.Company.Id = Int32.Parse(reader["CompanyId"].ToString());
toDoStatus.Company.Name = reader["CompanyName"].ToString();
}
return(toDoStatus);
}
public ToDoStatus Create(ToDoStatus toDoStatus)
{
if (context.ToDoStatuses.Where(x => x.Identifier != null && x.Identifier == toDoStatus.Identifier).Count() == 0)
{
toDoStatus.Id = 0;
toDoStatus.Code = GetNewCodeValue(toDoStatus.CompanyId ?? 0);
toDoStatus.Active = true;
toDoStatus.UpdatedAt = DateTime.Now;
toDoStatus.CreatedAt = DateTime.Now;
context.ToDoStatuses.Add(toDoStatus);
return(toDoStatus);
}
else
{
// Load ToDoStatus that will be updated
ToDoStatus dbEntry = context.ToDoStatuses
.FirstOrDefault(x => x.Identifier == toDoStatus.Identifier && x.Active == true);
if (dbEntry != null)
{
dbEntry.CompanyId = toDoStatus.CompanyId ?? null;
dbEntry.CreatedById = toDoStatus.CreatedById ?? null;
// Set properties
dbEntry.Code = toDoStatus.Code;
dbEntry.Name = toDoStatus.Name;
// Set timestamp
dbEntry.UpdatedAt = DateTime.Now;
}
return(dbEntry);
}
}
public IEnumerable <ToDoItem> GetByStatus(int status)
{
try
{
_logger.LogInformation("Hello");
if (Enum.IsDefined(typeof(ToDoStatus), status))
{
ToDoStatus s = (ToDoStatus)status;
// return new List<string>(new string[] { status.ToString() });
ToDoRepository tdr = new ToDoRepository();
var lst = tdr.GetByStatus(s);
return(lst);
}
else
{
return(new List <ToDoItem>());
}
}
catch (Exception ex)
{
_logger.LogError("GetByStatus: " + ex.Message);
return(new List <ToDoItem>());
}
}
public async Task <int> SaveAsync(ToDoStatus entity)
{
return(entity.Id != 0 ? await _database.UpdateAsync(entity) : await _database.InsertAsync(entity));
}
public ToDoArchiveEvent()
{
Status = new ToDoStatus {
Status = TODO.Status.Archive
};
}
public async Task <int> DeleteAsync(ToDoStatus entity)
{
return(await _database.DeleteAsync(entity));
}
public ToDoDoneEvent()
{
Status = new ToDoStatus {
Status = TODO.Status.Done
};
}
public void SetStatus(ToDoStatus status)
{
Status = status;
}
