public void SetUnitValues()
{
if (SelectedUnitName != "" && SelectedUnitName != null)
{
UnitProgressModel unit = new UnitProgressModel();
unit = Read.UnitProgress().Where(x => x.UnitName == SelectedUnitName).FirstOrDefault();
CurrentUnitType = unit.UnitTypeName;
CurrentAddress = unit.UnitAddress;
}
}
public void SaveItem(UnitProgressModel updatedModel)
{
MainWindowView main = (MainWindowView)Application.Current.MainWindow;
this.newModel = updatedModel;
updatedModel.Employee_ID = (int)main.lblEmployeeID.Content;
updatedModel.UploadDate = DateTime.Now.ToString("M-d-yyyy hh:mm:ss");
Create.UnitProgress(updatedModel);
helper.MessageDialog("Unit Progress data has been added successfully!",
updatedModel.UnitName);
}
private void ClearProgressFields()
{
int selectedTab = SelectedTabIndex;
UnitName = "";
SelectedUnitType = null;
SelectedUnitStatuse = null;
UnitAddress = "";
UnitStartDate = null;
UnitCompletionDate = null;
ProgressOfUnits = new BindableCollection <UnitProgressModel>(Read.UnitProgress());
SelectedProgressOfUnit = new UnitProgressModel();
//LoadUnit();
SelectedTabIndex = selectedTab;
}
private void CollectProgressDetails(UnitProgressModel currentProgress)
{
int statusID = Read.DropdownID("UnitStatus", SelectedUnitStatuse).FirstOrDefault();
int typeID = Read.DropdownID("UnitType", CurrentUnitType).FirstOrDefault();
UnitProgressModel unit = new UnitProgressModel();
unit = Read.UnitProgress().Where(x => x.UnitName == SelectedUnitName).FirstOrDefault();
currentProgress.Unit_ID = unit.ID;
currentProgress.UnitName = SelectedUnitName;
currentProgress.UnitTypeName = CurrentUnitType;
currentProgress.UnitType_ID = typeID;
currentProgress.UnitStatusName = SelectedUnitStatuse;
currentProgress.Status_ID = statusID;
currentProgress.Notes = Notes;
currentProgress.UnitAddress = CurrentAddress;
currentProgress.Image = upHelper.ReadImageFile(FileLocation);
currentProgress.Employee_ID = (int)main.lblEmployeeID.Content;
}
public void SaveProgress()
{
UnitProgressModel currentProgress = new UnitProgressModel();
CollectProgressDetails(currentProgress);
UnitProgressValidator validator = new UnitProgressValidator();
ValidationResult result = validator.Validate(currentProgress);
if (result.IsValid == false)
{
string errorMessage = (String.Join(Environment.NewLine + " • ",
result.Errors.Select(error => error.ErrorMessage)));
universalHelper.MessageDialog("Saving of data failed!", " • " + errorMessage);
return;
}
else
{
upHelper.SaveItem(currentProgress);
RefreshProgressTable();
RightSideUP = false;
}
}
public static void UnitProgress(UnitProgressModel table)
{
string Delete = SqliteQuery.Delete("UnitProgress", table.ID);
SqliteDataAccess.ExecuteQuery(Delete, table);
}
public UnitProgressHelperClass(UnitProgressModel thisModel, UnitViewModel thisVM)
{
this.thisModel = thisModel;
this.thisVM = thisVM;
PassValuesToControls();
}
public static void UnitProgress(UnitProgressModel table)
{
string update = SqliteQuery.Update("UnitProgress", table.Headers, table.ID);
SqliteDataAccess.ExecuteQuery(update, table);
}
public static void UnitProgress(UnitProgressModel table)
{
string insert = SqliteQuery.Create("UnitProgress", table.Headers);
SqliteDataAccess.ExecuteQuery(insert, table);
}
