public ActionResult Create(WorkItemsVm model)
{
if (model is null)
{
return(RedirectToAction("Create"));
}
if (String.IsNullOrWhiteSpace(model.Name) ||
model.Project_Id == null || model.Project_Id == 0 ||
model.Employee_Id == null || model.Employee_Id == 0 ||
model.DateCreated == DateTime.MinValue ||
(model.DateCreated == DateTime.MinValue && model.DateDue == DateTime.MinValue) ||
model.DateCreated == DateTime.MinValue || model.DateDue == DateTime.MinValue ||
DateTime.Compare(model.DateCreated, model.DateDue) > 0)
{
TempData["error"] = "You did not enter information correctly. Check the information and try again.";
return(RedirectToAction("Create"));
}
if (model.DateStarted != null && model.DateFinished != null)
{
if (model.DateStarted.Value != DateTime.MinValue && model.DateFinished.Value != DateTime.MinValue)
{
if (DateTime.Compare(model.DateStarted.Value, model.DateFinished.Value) > 0)
{
TempData["error"] = "You did not enter dates correctly. Check the dates and try again.";
return(RedirectToAction("Create"));
}
}
}
WorkItemsModel workItem = new WorkItemsModel()
{
Name = model.Name,
Description = model.Description,
Project_Id = model.Project_Id,
Employee_Id = model.Employee_Id,
DateCreated = model.DateCreated,
DateStarted = model.DateStarted,
DateFinished = model.DateFinished,
DateDue = model.DateDue
};
try
{
if (!_workItemService.Create(workItem))
{
TempData["error"] = $"Problems with create work item (Service error \"Create\").";
return(RedirectToAction("Create"));
}
}
catch (Exception e)
{
TempData["error"] = $"Problems with saving information to database (services). {e.Message}";
return(RedirectToAction("Create"));
}
return(RedirectToAction("Index"));
}
public bool Create(WorkItemsModel workItem)
{
if (workItem == null)
{
return(false);
}
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
string dataStart = workItem.DateStarted == null ? null : String.Format("{0}/{1}/{2}", workItem.DateStarted.Value.Year, workItem.DateStarted.Value.Month, workItem.DateStarted.Value.Day);
string dataFinished = workItem.DateFinished == null ? null : String.Format("{0}/{1}/{2}", workItem.DateFinished.Value.Year, workItem.DateFinished.Value.Month, workItem.DateFinished.Value.Day);
string dataCreated = String.Format("{0}/{1}/{2}", workItem.DateCreated.Year, workItem.DateCreated.Month, workItem.DateCreated.Day);
string dataDue = String.Format("{0}/{1}/{2}", workItem.DateDue.Year, workItem.DateDue.Month, workItem.DateDue.Day);
string queryString = $"INSERT INTO {WorkItemsTable} (Name, Description, Project_Id, Employee_Id, DateCreated, DateDue, DateStarted, DateFinished) " +
$"VALUES (" +
$"'{workItem.Name}'," +
$"'{workItem.Description}', " +
$"{workItem.Project_Id}, " +
$"{workItem.Employee_Id}, " +
$"'{workItem.DateCreated}', " +
$"'{workItem.DateDue}', ";
if (string.IsNullOrEmpty(dataStart))
{
queryString += "NULL, ";
}
else
{
queryString += $"{dataStart}, ";
}
if (string.IsNullOrEmpty(dataFinished))
{
queryString += "NULL) ";
}
else
{
queryString += $"{dataFinished}) ";
}
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
command.Prepare();
int number = command.ExecuteNonQuery();
return(number > 0 ? true : false);
}
}
catch (Exception)
{
return(false);
}
}
public bool Update(WorkItemsModel workItem)
{
if (workItem is null)
{
return(false);
}
try
{
string dataStart = workItem.DateStarted == null ? null : String.Format("{0}/{1}/{2}", workItem.DateStarted.Value.Year, workItem.DateStarted.Value.Month, workItem.DateStarted.Value.Day);
string dataFinished = workItem.DateFinished == null ? null : String.Format("{0}/{1}/{2}", workItem.DateFinished.Value.Year, workItem.DateFinished.Value.Month, workItem.DateFinished.Value.Day);
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
string queryString = $"UPDATE {WorkItemsTable} " +
$"SET " +
$"Name = '{workItem.Name}', " +
$"Description = '{workItem.Description}', " +
$"Project_Id = {workItem.Project_Id}, " +
$"Employee_Id = {workItem.Employee_Id}, " +
$"DateCreated = CAST('{workItem.DateCreated}' as DATETIME), " +
$"DateDue = CAST('{workItem.DateDue}' as DATETIME), ";
if (string.IsNullOrEmpty(dataStart))
{
queryString += "DateStarted = NULL ,";
}
else
{
queryString += $"DateStarted = CAST('{dataStart}' as DATETIME), ";
}
if (string.IsNullOrEmpty(dataFinished))
{
queryString += $"DateFinished = NULL ";
}
else
{
queryString += $"DateFinished = CAST('{dataFinished}' as DATETIME) ";
}
queryString += $"WHERE {WorkItemsTable}.Id = {workItem.Id}";
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
command.Prepare();
int number = command.ExecuteNonQuery();
return(number > 0 ? true : false);
}
}
catch (Exception)
{
return(false);
}
}
public List <WorkItemsModel> GetAllWorkItems()
{
List <WorkItemsModel> workItems = new List <WorkItemsModel>();
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
string queryString = $"SELECT * FROM {WorkItemsTable};";
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
command.Prepare();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
try
{
WorkItemsModel workItem = new WorkItemsModel();
workItem.Id = int.Parse(reader["Id"].ToString());
workItem.Name = reader["Name"].ToString();
workItem.Description = reader["Description"].ToString();
workItem.Project_Id = int.Parse(reader["Project_Id"].ToString());
workItem.Employee_Id = int.Parse(reader["Employee_Id"].ToString());
workItem.DateCreated = DateTime.Parse(reader["DateCreated"].ToString());
workItem.DateDue = DateTime.Parse(reader["DateDue"].ToString());
workItem.DateStarted = String.IsNullOrEmpty(reader["DateStarted"].ToString()) ? (DateTime?)null : DateTime.Parse(reader["DateStarted"].ToString());
workItem.DateFinished = String.IsNullOrEmpty(reader["DateFinished"].ToString()) ? (DateTime?)null : DateTime.Parse(reader["DateFinished"].ToString());
workItems.Add(workItem);
}
catch (Exception)
{
return(new List <WorkItemsModel>());
}
}
}
}
catch (Exception)
{
return(new List <WorkItemsModel>());
}
return(workItems);
}
private void OnWorkItemsButtonCommand(object param)
{
//IUnityContainer container = new UnityContainer();
//container.RegisterType<IWorkItemsModel, WorkItemsModel>();
//container.RegisterType<IWorkItemsViewModel, WorkItemsViewModel>();
//var workItemsView = container.Resolve<WorkItemsView>();
//workItemsView.Show();
var workItemsModel = new WorkItemsModel();
var workItemsViewModel = new WorkItemsViewModel(workItemsModel);
var workItemsView = new WorkItemsView
{
DataContext = workItemsViewModel
};
workItemsView.Show();
}
private void mapDataToWorkItem(List <WorkItemsModel> listWorkItemsState, int id, JObject workItems, List <WorkItemsModel> workItemStateList)
{
List <WorkItemsModel> newWorkItemModel = new List <WorkItemsModel>();
foreach (var item in workItems["value"])
{
var projectModel = new WorkItemsModel()
{
Id = id,
Name = item["name"].ToString()
};
if (listWorkItemsState.Where(x => x.Id == id && x.Name == projectModel.Name).Count() == 0 && workItemStateList.Where(x => x.Name == projectModel.Name && x.Id == id).Count() == 0)
{
listWorkItemsState.Add(projectModel);
}
}
}
public ActionResult Edit(int workItem_id)
{
string errorMsg = String.Empty;
if (TempData.ContainsKey("error"))
{
errorMsg = TempData["error"].ToString();
}
WorkItemsModel workItem = new WorkItemsModel();
List <SelectListItem> projectsList = new List <SelectListItem>();
List <SelectListItem> employeeList = new List <SelectListItem>();
try
{
projectsList = Utils.Helper.GetProjectsList();
employeeList = Utils.Helper.GetEmployeeList();
workItem = _workItemService.GetWorkItem(workItem_id);
}
catch (Exception e)
{
TempData["error"] = $"Problems with getting information from database (services). {e.Message}";
return(RedirectToAction("Index", "Home"));
}
WorkItemsVm model = new WorkItemsVm()
{
Id = workItem.Id,
Name = workItem.Name,
Description = workItem.Description,
Project_Id = workItem.Project_Id,
Employee_Id = workItem.Employee_Id,
DateCreated = workItem.DateCreated,
DateStarted = workItem.DateStarted,
DateFinished = workItem.DateFinished,
DateDue = workItem.DateDue,
ProjectsList = projectsList,
EmployeeList = employeeList,
ErrorMsg = errorMsg
};
return(View("Edit", model));
}
