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 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 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 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(); }
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 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(); }