public void UpdateTADocumentAdvanceTransaction(Guid txID, TADocumentAdvance taDocumentAdvance) { TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); TADocumentDataSet.TADocumentAdvanceRow taDocumentAdvanceRow = taDocumentDS.TADocumentAdvance.FindByTADocumentAdvanceID(taDocumentAdvance.TADocumentAdvanceID); taDocumentAdvanceRow.BeginEdit(); if (taDocumentAdvance.TADocument != null) { taDocumentAdvanceRow.TADocumentID = taDocumentAdvance.TADocument.TADocumentID; } if (taDocumentAdvance.Advance != null) { taDocumentAdvanceRow.AdvanceID = taDocumentAdvance.Advance.AdvanceID; } taDocumentAdvanceRow.Active = taDocumentAdvance.Active; taDocumentAdvanceRow.CreBy = UserAccount.UserID; taDocumentAdvanceRow.CreDate = DateTime.Now; taDocumentAdvanceRow.UpdBy = UserAccount.UserID; taDocumentAdvanceRow.UpdDate = DateTime.Now; taDocumentAdvanceRow.UpdPgm = UserAccount.CurrentProgramCode; taDocumentAdvanceRow.EndEdit(); }
public void SaveTADocumentTraveller(Guid txID, long taDocumentID) { TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); // Insert, Delete TADocumentTraveller. ScgeAccountingDaoProvider.TADocumentTravellerDao.Persist(taDocumentDS.TADocumentTraveller); }
public void PrepareDataToDataset(TADocumentDataSet taDocumentDS, long taDocumentID) { IList<TADocumentAdvance> taDocumentAdvanceList = ScgeAccountingQueryProvider.TADocumentAdvanceQuery.FindTADocumentAdvanceByTADocumentID(taDocumentID); foreach (TADocumentAdvance taDocumentAdvance in taDocumentAdvanceList) { TADocumentDataSet.TADocumentAdvanceRow taDocumentAdvanceRow = taDocumentDS.TADocumentAdvance.NewTADocumentAdvanceRow(); taDocumentAdvanceRow.TADocumentAdvanceID = taDocumentAdvance.TADocumentAdvanceID; if (taDocumentAdvance.TADocument != null) { taDocumentAdvanceRow.TADocumentID = taDocumentAdvance.TADocument.TADocumentID; } if (taDocumentAdvance.Advance != null) { taDocumentAdvanceRow.AdvanceID = taDocumentAdvance.Advance.AdvanceID; } taDocumentAdvanceRow.Active = taDocumentAdvance.Active; taDocumentAdvanceRow.CreBy = taDocumentAdvance.CreBy; taDocumentAdvanceRow.CreDate = taDocumentAdvance.CreDate; taDocumentAdvanceRow.UpdBy = taDocumentAdvance.UpdBy; taDocumentAdvanceRow.UpdDate = taDocumentAdvance.UpdDate; taDocumentAdvanceRow.UpdPgm = taDocumentAdvance.UpdPgm; // Add document initiator to datatable taDocumentDS. taDocumentDS.TADocumentAdvance.AddTADocumentAdvanceRow(taDocumentAdvanceRow); } }
public void ChangeRequesterTraveller(Guid txID, TADocumentTraveller taDocumentTraveller) { TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); TADocumentDataSet.TADocumentTravellerRow taDocumentTravellerRow = taDocumentDS.TADocumentTraveller.FindByTravellerID(taDocumentTraveller.TravellerID); taDocumentTravellerRow.BeginEdit(); taDocumentTravellerRow.TADocumentID = taDocumentTraveller.TADocumentID.TADocumentID; taDocumentTravellerRow.UserID = taDocumentTraveller.UserID.Userid; taDocumentTravellerRow.EmployeeNameEng = taDocumentTraveller.EmployeeNameEng; taDocumentTravellerRow.AirLineMember = taDocumentTraveller.AirLineMember; if (taDocumentTraveller.CostCenterID != null) { taDocumentTravellerRow.CostCenterID = taDocumentTraveller.CostCenterID.CostCenterID; } if (taDocumentTraveller.Account != null) { taDocumentTravellerRow.AccountID = taDocumentTraveller.Account.AccountID; } if (taDocumentTraveller.IOID != null) { taDocumentTravellerRow.IOID = taDocumentTraveller.IOID.IOID; } taDocumentTravellerRow.UpdBy = UserAccount.UserID; taDocumentTravellerRow.UpdDate = DateTime.Now; taDocumentTravellerRow.UpdPgm = UserAccount.CurrentProgramCode; taDocumentTravellerRow.EndEdit(); }
public DataSet PrepareDS(long documentID) { TADocumentDataSet taDocumentDS = (TADocumentDataSet)this.PrepareDataToDataset(documentID, false); taDocumentDS.AcceptChanges(); return(taDocumentDS); }
public DataTable DeleteTADocumentScheduleTransaction(Guid txID, int scheduleID) { TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); TADocumentDataSet.TADocumentScheduleRow taDocumentScheduleRow = taDocumentDS.TADocumentSchedule.FindByScheduleID(scheduleID); taDocumentScheduleRow.Delete(); return(taDocumentDS.TADocumentSchedule); }
public DataTable DeleteTADocumentTravellerTransaction(Guid txID, int travellerID) { TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); TADocumentDataSet.TADocumentTravellerRow taDocumentTravellerRow = taDocumentDS.TADocumentTraveller.FindByTravellerID(travellerID); taDocumentTravellerRow.Delete(); return(taDocumentDS.TADocumentTraveller); }
public int AddTADocumentScheduleTransaction(Guid txID, TADocumentSchedule taDocumentSchedule) { Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); TADocumentDataSet.TADocumentScheduleRow taDocumentScheduleRow = taDocumentDS.TADocumentSchedule.NewTADocumentScheduleRow(); taDocumentScheduleRow.TADocumentID = taDocumentSchedule.TADocumentID.TADocumentID; if (taDocumentSchedule.Date == null) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("Travelling date is required.")); } else { taDocumentScheduleRow.Date = taDocumentSchedule.Date.Value; } if (string.IsNullOrEmpty(taDocumentSchedule.DepartureFrom)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("Departure From is required.")); } else { taDocumentScheduleRow.DepartureFrom = taDocumentSchedule.DepartureFrom; } if (string.IsNullOrEmpty(taDocumentSchedule.ArrivalAt)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("Arrival At is required.")); } else { taDocumentScheduleRow.ArrivalAt = taDocumentSchedule.ArrivalAt; } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } taDocumentScheduleRow.DepartureFrom = taDocumentSchedule.DepartureFrom; taDocumentScheduleRow.ArrivalAt = taDocumentSchedule.ArrivalAt; taDocumentScheduleRow.TravelBy = taDocumentSchedule.TravelBy; taDocumentScheduleRow.Time = taDocumentSchedule.Time; taDocumentScheduleRow.FlightNo = taDocumentSchedule.FlightNo; taDocumentScheduleRow.TravellingDetail = taDocumentSchedule.TravellingDetail; taDocumentScheduleRow.Active = taDocumentSchedule.Active; taDocumentScheduleRow.CreBy = UserAccount.UserID; taDocumentScheduleRow.CreDate = DateTime.Now; taDocumentScheduleRow.UpdBy = UserAccount.UserID; taDocumentScheduleRow.UpdDate = DateTime.Now; taDocumentScheduleRow.UpdPgm = UserAccount.CurrentProgramCode; taDocumentDS.TADocumentSchedule.AddTADocumentScheduleRow(taDocumentScheduleRow); return(taDocumentScheduleRow.ScheduleID); }
public void PrepareDataToDataset(TADocumentDataSet taDocumentDS, long taDocumentID) { IList <TADocumentSchedule> taDocumentScheduleList = ScgeAccountingQueryProvider.TADocumentScheduleQuery.FindTADocumentScheduleByTADocumentID(taDocumentID); foreach (TADocumentSchedule taDocumentSchedule in taDocumentScheduleList) { TADocumentDataSet.TADocumentScheduleRow taDocumentScheduleRow = taDocumentDS.TADocumentSchedule.NewTADocumentScheduleRow(); taDocumentScheduleRow.ScheduleID = taDocumentSchedule.ScheduleID; if (taDocumentSchedule.TADocumentID != null) { taDocumentScheduleRow.TADocumentID = taDocumentSchedule.TADocumentID.TADocumentID; } if (taDocumentSchedule.Date != null) { taDocumentScheduleRow.Date = taDocumentSchedule.Date.Value; } if (taDocumentSchedule.DepartureFrom != null) { taDocumentScheduleRow.DepartureFrom = taDocumentSchedule.DepartureFrom; } if (taDocumentSchedule.ArrivalAt != null) { taDocumentScheduleRow.ArrivalAt = taDocumentSchedule.ArrivalAt; } if (taDocumentSchedule.TravelBy != null) { taDocumentScheduleRow.TravelBy = taDocumentSchedule.TravelBy; } if (taDocumentSchedule.Time != null) { taDocumentScheduleRow.Time = taDocumentSchedule.Time; } if (taDocumentSchedule.FlightNo != null) { taDocumentScheduleRow.FlightNo = taDocumentSchedule.FlightNo; } if (taDocumentSchedule.TravellingDetail != null) { taDocumentScheduleRow.TravellingDetail = taDocumentSchedule.TravellingDetail; } taDocumentScheduleRow.Active = taDocumentSchedule.Active; taDocumentScheduleRow.CreBy = taDocumentSchedule.CreBy; taDocumentScheduleRow.CreDate = taDocumentSchedule.CreDate; taDocumentScheduleRow.UpdBy = taDocumentSchedule.UpdBy; taDocumentScheduleRow.UpdDate = taDocumentSchedule.UpdDate; taDocumentScheduleRow.UpdPgm = taDocumentSchedule.UpdPgm; // Add document initiator to datatable taDocumentDS. taDocumentDS.TADocumentSchedule.AddTADocumentScheduleRow(taDocumentScheduleRow); } }
public void PrepareDataToDataset(TADocumentDataSet taDocumentDS, long taDocumentID) { IList <TADocumentTraveller> taDocumentTravellerList = ScgeAccountingQueryProvider.TADocumentTravellerQuery.FindTADocumentTravellerByTADocumentID(taDocumentID); TADocumentDataSet.TADocumentRow taDocumentRow = taDocumentDS.TADocument.FindByTADocumentID(taDocumentID); foreach (TADocumentTraveller taDocumentTraveller in taDocumentTravellerList.OrderBy(t => t.TravellerID)) { TADocumentDataSet.TADocumentTravellerRow taDocumentTravellerRow = taDocumentDS.TADocumentTraveller.NewTADocumentTravellerRow(); taDocumentTravellerRow.TravellerID = taDocumentTraveller.TravellerID; if (taDocumentTraveller.TADocumentID != null) { taDocumentTravellerRow.TADocumentID = taDocumentTraveller.TADocumentID.TADocumentID; } if (taDocumentTraveller.UserID != null) { taDocumentTravellerRow.UserID = taDocumentTraveller.UserID.Userid; } if (taDocumentTraveller.EmployeeNameEng != null) { taDocumentTravellerRow.EmployeeNameEng = taDocumentTraveller.EmployeeNameEng; } if (taDocumentTraveller.AirLineMember != null) { taDocumentTravellerRow.AirLineMember = taDocumentTraveller.AirLineMember; } if (taDocumentTraveller.CostCenterID != null) { taDocumentTravellerRow.CostCenterID = taDocumentTraveller.CostCenterID.CostCenterID; } if (taDocumentTraveller.Account != null) { taDocumentTravellerRow.AccountID = taDocumentTraveller.Account.AccountID; } if (taDocumentTraveller.IOID != null) { taDocumentTravellerRow.IOID = taDocumentTraveller.IOID.IOID; } taDocumentTravellerRow.Active = taDocumentTraveller.Active; taDocumentTravellerRow.CreBy = taDocumentTraveller.CreBy; taDocumentTravellerRow.CreDate = taDocumentTraveller.CreDate; taDocumentTravellerRow.UpdBy = taDocumentTraveller.UpdBy; taDocumentTravellerRow.UpdDate = taDocumentTraveller.UpdDate; taDocumentTravellerRow.UpdPgm = taDocumentTraveller.UpdPgm; // Add document initiator to datatable taDocumentDS. taDocumentDS.TADocumentTraveller.AddTADocumentTravellerRow(taDocumentTravellerRow); } }
public void DeleteTADocumentAdvanceTransaction(Guid txID, long taDocumentID , long advanceID) { TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); TADocumentDataSet.TADocumentAdvanceDataTable taDocumentAdvanceDT = taDocumentDS.TADocumentAdvance; foreach (TADocumentDataSet.TADocumentAdvanceRow row in taDocumentAdvanceDT) { if (row.TADocumentID.Equals(taDocumentID) && row.AdvanceID.Equals(advanceID)) { row.Delete(); break; } } }
public long AddTADocumentTransaction(Guid txID) { //Initial Data for another table. TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); TADocumentDataSet.DocumentRow documentRow = taDocumentDS.Document.NewDocumentRow(); //create new row to dataset. taDocumentDS.Document.AddDocumentRow(documentRow); //add new row to dataset. TADocumentDataSet.TADocumentRow taDocumentRow = taDocumentDS.TADocument.NewTADocumentRow(); taDocumentRow.DocumentID = documentRow.DocumentID; taDocumentDS.TADocument.AddTADocumentRow(taDocumentRow); return(taDocumentRow.TADocumentID); }
public int AddTADocumentAdvanceTransaction(Guid txID, TADocumentAdvance taDocumentAdvance) { TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); TADocumentDataSet.TADocumentAdvanceRow taDocumentAdvanceRow = taDocumentDS.TADocumentAdvance.NewTADocumentAdvanceRow(); taDocumentAdvanceRow.TADocumentID = taDocumentAdvance.TADocument.TADocumentID; if (taDocumentAdvance.Advance != null) { taDocumentAdvanceRow.AdvanceID = taDocumentAdvance.Advance.AdvanceID; } taDocumentAdvanceRow.Active = taDocumentAdvance.Active; taDocumentAdvanceRow.CreBy = UserAccount.UserID; taDocumentAdvanceRow.CreDate = DateTime.Now; taDocumentAdvanceRow.UpdBy = UserAccount.UserID; taDocumentAdvanceRow.UpdDate = DateTime.Now; taDocumentAdvanceRow.UpdPgm = UserAccount.CurrentProgramCode; taDocumentDS.TADocumentAdvance.AddTADocumentAdvanceRow(taDocumentAdvanceRow); return taDocumentAdvanceRow.TADocumentAdvanceID; }
public int AddTADocumentTravellerTransaction(Guid txID, TADocumentTraveller taDocumentTraveller) { TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); TADocumentDataSet.TADocumentTravellerRow taDocumentTravellerRow = taDocumentDS.TADocumentTraveller.NewTADocumentTravellerRow(); taDocumentTravellerRow.TADocumentID = taDocumentTraveller.TADocumentID.TADocumentID; taDocumentTravellerRow.UserID = taDocumentTraveller.UserID.Userid; taDocumentTravellerRow.EmployeeNameEng = taDocumentTraveller.EmployeeNameEng; taDocumentTravellerRow.AirLineMember = taDocumentTraveller.AirLineMember; taDocumentTravellerRow.Active = taDocumentTraveller.Active; taDocumentTravellerRow.CreBy = UserAccount.UserID; taDocumentTravellerRow.CreDate = DateTime.Now; taDocumentTravellerRow.UpdBy = UserAccount.UserID; taDocumentTravellerRow.UpdDate = DateTime.Now; taDocumentTravellerRow.UpdPgm = UserAccount.CurrentProgramCode; taDocumentDS.TADocumentTraveller.AddTADocumentTravellerRow(taDocumentTravellerRow); return(taDocumentTravellerRow.TravellerID); }
public long SaveTADocument(Guid txID, long taDocumentID) { TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); TADocumentDataSet.TADocumentRow taDocumentRow = taDocumentDS.TADocument.FindByTADocumentID(taDocumentID); long documentID = taDocumentRow.DocumentID; // Insert, Update SCGDocument. // Insert, Update, Delete DocumentInitiator. // Insert, Delete DocumentAttachment. documentID = SCGDocumentService.SaveSCGDocument(txID, documentID); // Insert, Update, Delete TADocument. taDocumentID = ScgeAccountingDaoProvider.TADocumentDao.Persist(taDocumentDS.TADocument); // Insert, Update, Delete TADocumentTraveller. TADocumentTravellerService.SaveTADocumentTraveller(txID, taDocumentID); // Insert, Update, Delete TADocumentSchedule. TADocumentScheduleService.SaveTADocumentSchedule(txID, taDocumentID); return(taDocumentID); }
public void UpdateTADocumentScheduleTransaction(Guid txID, TADocumentSchedule taDocumentSchedule) { Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); TADocumentDataSet.TADocumentScheduleRow taDocumentScheduleRow = taDocumentDS.TADocumentSchedule.FindByScheduleID(taDocumentSchedule.ScheduleID); TADocumentDataSet.TADocumentRow taDocumentRow = taDocumentDS.TADocument.FindByTADocumentID(taDocumentSchedule.TADocumentID.TADocumentID); taDocumentScheduleRow.BeginEdit(); if (taDocumentSchedule.TADocumentID != null) { taDocumentScheduleRow.TADocumentID = taDocumentSchedule.TADocumentID.TADocumentID; } if (taDocumentSchedule.Date == null) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("TravellingDateIsRequired")); } else { if (!taDocumentRow.IsNull("FromDate") && !taDocumentRow.IsNull("ToDate")) { if (taDocumentSchedule.Date >= taDocumentRow.FromDate && taDocumentSchedule.Date <= taDocumentRow.ToDate) { taDocumentScheduleRow.Date = taDocumentSchedule.Date.Value; } else { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("TravellingDateIsNotBetweenTravellingFromToDate")); } } } if (string.IsNullOrEmpty(taDocumentSchedule.DepartureFrom)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("DepartureFromIsRequired")); } else { taDocumentScheduleRow.DepartureFrom = taDocumentSchedule.DepartureFrom; } if (string.IsNullOrEmpty(taDocumentSchedule.ArrivalAt)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("ArrivalAtIsRequired")); } else { taDocumentScheduleRow.ArrivalAt = taDocumentSchedule.ArrivalAt; } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } taDocumentScheduleRow.TravelBy = taDocumentSchedule.TravelBy; taDocumentScheduleRow.Time = taDocumentSchedule.Time; taDocumentScheduleRow.FlightNo = taDocumentSchedule.FlightNo; taDocumentScheduleRow.TravellingDetail = taDocumentSchedule.TravellingDetail; taDocumentScheduleRow.Active = taDocumentSchedule.Active; taDocumentScheduleRow.CreBy = UserAccount.UserID; taDocumentScheduleRow.CreDate = DateTime.Now; taDocumentScheduleRow.UpdBy = UserAccount.UserID; taDocumentScheduleRow.UpdDate = DateTime.Now; taDocumentScheduleRow.UpdPgm = UserAccount.CurrentProgramCode; taDocumentScheduleRow.EndEdit(); }
public DataSet PrepareDS() { TADocumentDataSet taDocumentDS = new TADocumentDataSet(); return(taDocumentDS); }
public DataSet PrepareDataToDataset(long documentID, bool isCopy) { TADocumentDataSet taDocumentDS = new TADocumentDataSet(); TADocument taDocument = ScgeAccountingQueryProvider.TADocumentQuery.GetTADocumentByDocumentID(documentID); Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); if (taDocument == null) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("NoTADocumentFound")); } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } // Prepare Data to Document datatable. if (!isCopy) { SCGDocumentService.PrepareDataToDataset(taDocumentDS, documentID); } else { SCGDocumentService.PrepareDataInternalToDataset(taDocumentDS, documentID, isCopy); } // Set data to Budget Document row in budgetDocumentDS. TADocumentDataSet.TADocumentRow taDocumentRow = taDocumentDS.TADocument.NewTADocumentRow(); taDocumentRow.TADocumentID = taDocument.TADocumentID; if (!isCopy) { if (taDocument.DocumentID != null) { taDocumentRow.DocumentID = taDocument.DocumentID.DocumentID; } } else { if (taDocumentDS.Document.Rows.Count > 0) { TADocumentDataSet.DocumentRow docRow = (TADocumentDataSet.DocumentRow)taDocumentDS.Document.Rows[0]; taDocumentRow.DocumentID = docRow.DocumentID; } } taDocumentRow.FromDate = taDocument.FromDate; taDocumentRow.ToDate = taDocument.ToDate; taDocumentRow.IsBusinessPurpose = taDocument.IsBusinessPurpose; taDocumentRow.IsTrainningPurpose = taDocument.IsTrainningPurpose; taDocumentRow.IsOtherPurpose = taDocument.IsOtherPurpose; if (taDocument.OtherPurposeDescription != null) { taDocumentRow.OtherPurposeDescription = taDocument.OtherPurposeDescription; } taDocumentRow.TravelBy = taDocument.TravelBy; if (taDocument.Province != null) { taDocumentRow.Province = taDocument.Province; } if (taDocument.Country != null) { taDocumentRow.Country = taDocument.Country; } taDocumentRow.Ticketing = taDocument.Ticketing; //if (taDocument.CostCenterID != null) //{ // taDocumentRow.CostCenterID = taDocument.CostCenterID.CostCenterID; //} //if (taDocument.Account != null) //{ // taDocumentRow.AccountID = taDocument.Account.AccountID; //} //if (taDocument.IOID != null) //{ // taDocumentRow.IOID = taDocument.IOID.IOID; //} taDocumentRow.Active = taDocument.Active; taDocumentRow.CreBy = taDocument.CreBy; taDocumentRow.CreDate = taDocument.CreDate; taDocumentRow.UpdBy = taDocument.UpdBy; taDocumentRow.UpdDate = taDocument.UpdDate; taDocumentRow.UpdPgm = taDocument.UpdPgm; // Add ta document row to taDocument. taDocumentDS.TADocument.AddTADocumentRow(taDocumentRow); // Prepare Data to TADocumentTravellerService Datatable. TADocumentTravellerService.PrepareDataToDataset(taDocumentDS, taDocument.TADocumentID); // Prepare Data to TADocumentScheduleService Datatable. TADocumentScheduleService.PrepareDataToDataset(taDocumentDS, taDocument.TADocumentID); //Not Save to TADocumemtAdvance Table. // Prepare Data to TADocumentAdvanceService Datatable. ////TADocumentAdvanceService.PrepareDataToDataset(taDocumentDS, taDocument.TADocumentID); return(taDocumentDS); }
public void UpdateTADocumentTransaction(Guid txID, TADocument taDocument) { Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); TADocumentDataSet.TADocumentRow taDocumentRow = taDocumentDS.TADocument.FindByTADocumentID(taDocument.TADocumentID); taDocumentRow.BeginEdit(); taDocumentRow.DocumentID = taDocument.DocumentID.DocumentID; if (taDocument.FromDate < DateTime.Today) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("FromDateMoreOrEqualToDay")); } if (taDocument.FromDate > taDocument.ToDate) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("FromDateLessOrEqualToDate")); } if (taDocument.FromDate.Equals(DateTime.MinValue)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("FromDateIsRequired")); } else { taDocumentRow.FromDate = taDocument.FromDate; } if (taDocument.ToDate.Equals(DateTime.MinValue)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("ToDateIsRequired")); } else { taDocumentRow.ToDate = taDocument.ToDate; } if (((!taDocument.IsBusinessPurpose) && (!taDocument.IsTrainningPurpose) && (!taDocument.IsOtherPurpose))) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("PurposeIsRequired")); } else { taDocumentRow.IsBusinessPurpose = taDocument.IsBusinessPurpose; taDocumentRow.IsTrainningPurpose = taDocument.IsTrainningPurpose; taDocumentRow.IsOtherPurpose = taDocument.IsOtherPurpose; } if (taDocument.IsOtherPurpose && string.IsNullOrEmpty(taDocument.OtherPurposeDescription)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("OtherIsRequired")); } else { taDocumentRow.OtherPurposeDescription = taDocument.OtherPurposeDescription; } if ((!string.IsNullOrEmpty(taDocument.TravelBy)) && taDocument.TravelBy.Trim().ToUpper().Equals("D") && string.IsNullOrEmpty(taDocument.Province)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("TravelByProvinceIsRequired")); } else { taDocumentRow.Province = taDocument.Province; } if ((!string.IsNullOrEmpty(taDocument.TravelBy)) && taDocument.TravelBy.Trim().ToUpper().Equals("F") && string.IsNullOrEmpty(taDocument.Country)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("TravelByCountryIsRequired")); } else { taDocumentRow.Country = taDocument.Country; } if (string.IsNullOrEmpty(taDocument.TravelBy)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("TravelByIsRequired")); } else { taDocumentRow.TravelBy = taDocument.TravelBy; } if (string.IsNullOrEmpty(taDocument.Ticketing)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("TicketingIsRequired")); } else { taDocumentRow.Ticketing = taDocument.Ticketing; } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } taDocumentRow.Active = taDocument.Active; taDocumentRow.CreBy = UserAccount.UserID; taDocumentRow.CreDate = DateTime.Now; taDocumentRow.UpdBy = UserAccount.UserID; taDocumentRow.UpdDate = DateTime.Now; taDocumentRow.UpdPgm = UserAccount.CurrentProgramCode; taDocumentRow.EndEdit(); }
public void UpdateTADocumentTravellerTransaction(Guid txID, TADocumentTraveller taDocumentTraveller) { Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); TADocumentDataSet.TADocumentTravellerRow taDocumentTravellerRow = taDocumentDS.TADocumentTraveller.FindByTravellerID(taDocumentTraveller.TravellerID); TADocumentDataSet.TADocumentRow taDocumentRow = taDocumentDS.TADocument.FindByTADocumentID(taDocumentTraveller.TADocumentID.TADocumentID); taDocumentTravellerRow.BeginEdit(); if (taDocumentTraveller.TADocumentID != null) { taDocumentTravellerRow.TADocumentID = taDocumentTraveller.TADocumentID.TADocumentID; } if (taDocumentTraveller.UserID == null) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("UserIDIsRequired")); } else { taDocumentTravellerRow.UserID = taDocumentTraveller.UserID.Userid; } if (string.IsNullOrEmpty(taDocumentTraveller.EmployeeNameEng)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("FullNameEngIsRequired")); } else { taDocumentTravellerRow.EmployeeNameEng = taDocumentTraveller.EmployeeNameEng; } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } taDocumentTravellerRow.AirLineMember = taDocumentTraveller.AirLineMember; taDocumentTravellerRow.Active = taDocumentTraveller.Active; if (taDocumentRow.Ticketing.Trim().ToUpper().Equals("T") && (!string.IsNullOrEmpty(taDocumentRow.Ticketing))) { if (taDocumentTraveller.CostCenterID == null || taDocumentTraveller.CostCenterID.CostCenterID <= 0) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("CostCenterIsRequired", new object[] { taDocumentTraveller.UserName, " " })); } else { taDocumentTravellerRow.CostCenterID = taDocumentTraveller.CostCenterID.CostCenterID; } if (taDocumentTraveller.IOID == null || taDocumentTraveller.IOID.IOID <= 0) { taDocumentTravellerRow.IOID = 0; } else { taDocumentTravellerRow.IOID = taDocumentTraveller.IOID.IOID; } if (taDocumentTraveller.Account == null || taDocumentTraveller.Account.AccountID <= 0) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("ExpenseGroupIsRequired", new object[] { taDocumentTraveller.UserName, " " })); } else { taDocumentTravellerRow.AccountID = taDocumentTraveller.Account.AccountID; } } else { taDocumentTravellerRow.CostCenterID = 0; taDocumentTravellerRow.AccountID = 0; taDocumentTravellerRow.IOID = 0; } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } taDocumentTravellerRow.CreBy = UserAccount.UserID; taDocumentTravellerRow.CreDate = DateTime.Now; taDocumentTravellerRow.UpdBy = UserAccount.UserID; taDocumentTravellerRow.UpdDate = DateTime.Now; taDocumentTravellerRow.UpdPgm = UserAccount.CurrentProgramCode; taDocumentTravellerRow.EndEdit(); }