/// <summary> /// Save /// </summary> /// <param name="companyId">companyId</param> public void Save(int companyId) { ToDoListInformationTDS toDoListInformationChanges = (ToDoListInformationTDS)Data.GetChanges(); if (toDoListInformationChanges != null) { if (toDoListInformationChanges.BasicInformation.Rows.Count > 0) { ToDoListInformationBasicInformationGateway toDoListInformationBasicInformationGateway = new ToDoListInformationBasicInformationGateway(toDoListInformationChanges); // Update to do foreach (ToDoListInformationTDS.BasicInformationRow row in (ToDoListInformationTDS.BasicInformationDataTable)toDoListInformationChanges.BasicInformation) { // Unchanged values int toDoId = row.ToDoID; string subject = toDoListInformationBasicInformationGateway.GetSubject(toDoId); DateTime creationDate = toDoListInformationBasicInformationGateway.GetCreationDate(toDoId); int createdById = toDoListInformationBasicInformationGateway.GetCreatedByID(toDoId); // Original values DateTime? originalDueDate = null; if (toDoListInformationBasicInformationGateway.GetDueDateOriginal(toDoId).HasValue) originalDueDate = (DateTime)toDoListInformationBasicInformationGateway.GetDueDateOriginal(toDoId); int? originalUnitId = null; if (toDoListInformationBasicInformationGateway.GetUnitIDOriginal(toDoId).HasValue) originalUnitId = (int)toDoListInformationBasicInformationGateway.GetUnitIDOriginal(toDoId); string originalState = toDoListInformationBasicInformationGateway.GetStateOriginal(toDoId); // New variables DateTime? newDueDate = null; if (toDoListInformationBasicInformationGateway.GetDueDate(toDoId).HasValue) newDueDate = (DateTime)toDoListInformationBasicInformationGateway.GetDueDate(toDoId); int? newUnitId = null; if (toDoListInformationBasicInformationGateway.GetUnitID(toDoId).HasValue) newUnitId = (int)toDoListInformationBasicInformationGateway.GetUnitID(toDoId); string newState = toDoListInformationBasicInformationGateway.GetState(toDoId); ToDoListToDoList toDoListToDoList = new ToDoListToDoList(null); toDoListToDoList.UpdateDirect(toDoId, subject, creationDate, createdById, originalState, originalDueDate, originalUnitId, row.Deleted, row.COMPANY_ID, toDoId, subject, creationDate, createdById, newState, newDueDate, newUnitId, row.Deleted, row.COMPANY_ID); } } } }
private void LoadData(int toDoId) { ToDoListInformationBasicInformationGateway toDoListInformationBasicInformationGateway = new ToDoListInformationBasicInformationGateway(toDoListInformationTDS); if (toDoListInformationBasicInformationGateway.Table.Rows.Count > 0) { // Load to do Details int companyId = Int32.Parse(hdfCompanyId.Value); int createdById = toDoListInformationBasicInformationGateway.GetCreatedByID(toDoId); hdfCreatedById.Value = createdById.ToString(); EmployeeGateway employeeGateway = new EmployeeGateway(); employeeGateway.LoadByEmployeeId(createdById); tbxCreatedBy.Text = employeeGateway.GetFullName(createdById); tbxCreationDate.Text = toDoListInformationBasicInformationGateway.GetCreationDate(toDoId).ToString(); tbxState.Text = toDoListInformationBasicInformationGateway.GetState(toDoId); if (toDoListInformationBasicInformationGateway.GetDueDate(toDoId).HasValue) { DateTime dueDateValue = (DateTime)toDoListInformationBasicInformationGateway.GetDueDate(toDoId); tbxDueDate.Text = dueDateValue.Month.ToString() + "/" + dueDateValue.Day.ToString() + "/" + dueDateValue.Year.ToString(); } int? unitId = toDoListInformationBasicInformationGateway.GetUnitID(toDoId); tbxUnit.Text = ""; if (unitId.HasValue) { UnitsGateway unitsGateway = new UnitsGateway(); unitsGateway.LoadByUnitId((int)unitId, companyId); tbxUnit.Text = unitsGateway.GetUnitCode((int)unitId) + " " + unitsGateway.GetDescription((int)unitId); } } }
private void LoadData(int toDoId) { ToDoListInformationBasicInformationGateway toDoListInformationBasicInformationGateway = new ToDoListInformationBasicInformationGateway(toDoListInformationTDS); if (toDoListInformationBasicInformationGateway.Table.Rows.Count > 0) { // Load to do Details int companyId = Int32.Parse(hdfCompanyId.Value); int createdById = toDoListInformationBasicInformationGateway.GetCreatedByID(toDoId); EmployeeGateway employeeGateway = new EmployeeGateway(); employeeGateway.LoadByEmployeeId(createdById); tbxCreatedBy.Text = employeeGateway.GetFullName(createdById); tbxCreationDate.Text = toDoListInformationBasicInformationGateway.GetCreationDate(toDoId).ToString(); tbxState.Text = toDoListInformationBasicInformationGateway.GetState(toDoId); if (toDoListInformationBasicInformationGateway.GetDueDate(toDoId).HasValue) { tkrdpDueDate.SelectedDate = (DateTime)toDoListInformationBasicInformationGateway.GetDueDate(toDoId); } int? unitId = toDoListInformationBasicInformationGateway.GetUnitID(toDoId); if (unitId.HasValue) { ddlUnit.SelectedValue = unitId.ToString(); } } }