public void SaveMPAItem(Guid txID, long documentID) { MPADocumentDataSet mpaItemDS = (MPADocumentDataSet)TransactionService.GetDS(txID); // Insert, Delete TADocumentTraveller. ScgeAccountingDaoProvider.MPAItemDao.Persist(mpaItemDS.MPAItem); }
public System.Data.DataSet PrepareDS(long documentID) { MPADocumentDataSet documentDS = (MPADocumentDataSet)this.PrepareDataToDataset(documentID, false); documentDS.AcceptChanges(); return(documentDS); }
public DataTable DeleteMPAItemTransaction(Guid txID, long MPAItemID) { MPADocumentDataSet MPAItemDS = (MPADocumentDataSet)TransactionService.GetDS(txID); MPADocumentDataSet.MPAItemRow mpaItemRow = MPAItemDS.MPAItem.FindByMPAItemID(MPAItemID); mpaItemRow.Delete(); return(MPAItemDS.MPAItem); }
public void UpdateMPADocumentTransaction(Guid txID, MPADocument mpaDocument) { Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); MPADocumentDataSet mpaDocumentDS = (MPADocumentDataSet)TransactionService.GetDS(txID); MPADocumentDataSet.MPADocumentRow mpaDocumentRow = mpaDocumentDS.MPADocument.FindByMPADocumentID(mpaDocument.MPADocumentID); mpaDocumentRow.BeginEdit(); mpaDocumentRow.DocumentID = mpaDocument.DocumentID.DocumentID; //if (mpaDocument.StartDate < DateTime.Today) //{ // errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("StartDateMoreOrEqualToDay")); //} if (mpaDocument.StartDate > mpaDocument.EndDate) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("StartDateLessOrEqualEndDate")); } if (mpaDocument.StartDate.Equals(DateTime.MinValue)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("StartDateIsRequired")); } else { mpaDocumentRow.StartDate = mpaDocument.StartDate; } if (mpaDocument.EndDate.Equals(DateTime.MinValue)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("EndDateIsRequired")); } else { mpaDocumentRow.EndDate = mpaDocument.EndDate; } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } mpaDocumentRow.Active = mpaDocument.Active; mpaDocumentRow.CreBy = UserAccount.UserID; mpaDocumentRow.CreDate = DateTime.Now; mpaDocumentRow.UpdBy = UserAccount.UserID; mpaDocumentRow.UpdDate = DateTime.Now; mpaDocumentRow.UpdPgm = UserAccount.CurrentProgramCode; mpaDocumentRow.EndEdit(); }
public long AddMPADocumentTransaction(Guid txID) { //Initial Data for another table. MPADocumentDataSet mpaDocumentDS = (MPADocumentDataSet)TransactionService.GetDS(txID); MPADocumentDataSet.DocumentRow documentRow = mpaDocumentDS.Document.NewDocumentRow(); //create new row to dataset. mpaDocumentDS.Document.AddDocumentRow(documentRow); //add new row to dataset. MPADocumentDataSet.MPADocumentRow mpaDocumentRow = mpaDocumentDS.MPADocument.NewMPADocumentRow(); mpaDocumentRow.DocumentID = documentRow.DocumentID; mpaDocumentDS.MPADocument.AddMPADocumentRow(mpaDocumentRow); return(mpaDocumentRow.MPADocumentID); }
public long AddMPAItemTransaction(Guid txID, MPAItem mpaItem) { MPADocumentDataSet mpaItemDS = (MPADocumentDataSet)TransactionService.GetDS(txID); MPADocumentDataSet.MPAItemRow mpaItemRow = mpaItemDS.MPAItem.NewMPAItemRow(); //mpaItemRow.MPAItemID = mpaItem.MPAItemID; mpaItemRow.MPADocumentID = mpaItem.MPADocumentID.MPADocumentID; mpaItemRow.UserID = mpaItem.UserID.Userid; mpaItemRow.UpdBy = UserAccount.UserID; mpaItemRow.UpdDate = DateTime.Now; mpaItemRow.UpdPgm = UserAccount.CurrentProgramCode; mpaItemDS.MPAItem.AddMPAItemRow(mpaItemRow); return(mpaItemRow.MPAItemID); }
public void PrepareDataToDataset(MPADocumentDataSet MPAItemDS, long mpaDocumentID) { IList <MPAItem> mpaItemList = ScgeAccountingQueryProvider.MPAItemQuery.FindMPAItemByMPADocumentID(mpaDocumentID); //MPADocumentDataSet.MPAItemRow mpaItemRow = MPAItemDS.MPAItem.NewMPAItemRow(); ; foreach (MPAItem mpaItem in mpaItemList) { MPADocumentDataSet.MPAItemRow mpaItemDataRow = MPAItemDS.MPAItem.NewMPAItemRow(); mpaItemDataRow.MPAItemID = mpaItem.MPAItemID; mpaItemDataRow.MPADocumentID = mpaItem.MPADocumentID.MPADocumentID; mpaItemDataRow.UserID = mpaItem.UserID.Userid; if (mpaItem.ActualAmount != null) { mpaItemDataRow.ActualAmount = mpaItem.ActualAmount; } if (mpaItem.ActualAmountNotExceed != null) { mpaItemDataRow.ActualAmountNotExceed = mpaItem.ActualAmountNotExceed; } if (mpaItem.AmountCompanyPackage != null) { mpaItemDataRow.AmountCompanyPackage = mpaItem.AmountCompanyPackage; } if (mpaItem.TotalAmount != null) { mpaItemDataRow.TotalAmount = mpaItem.TotalAmount; } mpaItemDataRow.MobilePhoneNo = mpaItem.MobilePhoneNo; mpaItemDataRow.MobileBrand = mpaItem.MobileBrand; mpaItemDataRow.MobileModel = mpaItem.MobileModel; mpaItemDataRow.CreBy = UserAccount.UserID; mpaItemDataRow.CreDate = DateTime.Now; mpaItemDataRow.UpdBy = UserAccount.UserID; mpaItemDataRow.UpdDate = DateTime.Now; mpaItemDataRow.UpdPgm = UserAccount.CurrentProgramCode; // Add document initiator to datatable taDocumentDS. MPAItemDS.MPAItem.AddMPAItemRow(mpaItemDataRow); } }
public long SaveMPADocument(Guid txID, long mpaDocumentID) { MPADocumentDataSet mpaDocumentDS = (MPADocumentDataSet)TransactionService.GetDS(txID); MPADocumentDataSet.MPADocumentRow mpaDocumentRow = mpaDocumentDS.MPADocument.FindByMPADocumentID(mpaDocumentID); long documentID = mpaDocumentRow.DocumentID; // Insert, Update SCGDocument. // Insert, Update, Delete DocumentInitiator. // Insert, Delete DocumentAttachment. documentID = SCGDocumentService.SaveSCGDocument(txID, documentID); // Insert, Update, Delete MPADocument. mpaDocumentID = ScgeAccountingDaoProvider.MPADocumentDao.Persist(mpaDocumentDS.MPADocument); // Insert, Update, Delete MPAItem. MPAItemService.SaveMPAItem(txID, documentID); return(mpaDocumentID); }
public void UpdateMPAItemTransaction(Guid txID, MPAItem mpaItem) { Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); MPADocumentDataSet MPAItemDS = (MPADocumentDataSet)TransactionService.GetDS(txID); MPADocumentDataSet.MPAItemRow mpaItemRow = MPAItemDS.MPAItem.FindByMPAItemID(mpaItem.MPAItemID); mpaItemRow.BeginEdit(); mpaItemRow.UserID = mpaItem.UserID.Userid; if (mpaItem.ActualAmount != null) { mpaItemRow.ActualAmount = mpaItem.ActualAmount; } if (mpaItem.ActualAmountNotExceed != null) { mpaItemRow.ActualAmountNotExceed = mpaItem.ActualAmountNotExceed; } if (mpaItem.AmountCompanyPackage != null) { mpaItemRow.AmountCompanyPackage = mpaItem.AmountCompanyPackage; } if (mpaItem.TotalAmount != null) { mpaItemRow.TotalAmount = mpaItem.TotalAmount; } mpaItemRow.MobilePhoneNo = mpaItem.MobilePhoneNo; mpaItemRow.MobileBrand = mpaItem.MobileBrand; mpaItemRow.MobileModel = mpaItem.MobileModel; mpaItemRow.CreBy = UserAccount.UserID; mpaItemRow.CreDate = DateTime.Now; mpaItemRow.UpdBy = UserAccount.UserID; mpaItemRow.UpdDate = DateTime.Now; mpaItemRow.UpdPgm = UserAccount.CurrentProgramCode; mpaItemRow.EndEdit(); }
public void ChangeRequesterMAPItem(Guid txID, MPAItem mpaItem) { MPADocumentDataSet mpaItemDS = (MPADocumentDataSet)TransactionService.GetDS(txID); MPADocumentDataSet.MPAItemRow mpaItemRow = mpaItemDS.MPAItem.FindByMPAItemID(mpaItem.MPAItemID); mpaItemRow.BeginEdit(); //mpaItemRow.MPAItemID = mpaItem.MPAItemID; mpaItemRow.UserID = mpaItem.UserID.Userid; mpaItemRow.ActualAmount = mpaItem.ActualAmount; mpaItemRow.ActualAmountNotExceed = mpaItem.ActualAmountNotExceed; mpaItemRow.AmountCompanyPackage = mpaItem.AmountCompanyPackage; mpaItemRow.TotalAmount = mpaItem.TotalAmount; mpaItemRow.MobilePhoneNo = mpaItem.MobilePhoneNo; mpaItemRow.MobileBrand = mpaItem.MobileBrand; mpaItemRow.MobileModel = mpaItem.MobileModel; mpaItemRow.UpdBy = UserAccount.UserID; mpaItemRow.UpdDate = DateTime.Now; mpaItemRow.UpdPgm = UserAccount.CurrentProgramCode; mpaItemRow.EndEdit(); }
public System.Data.DataSet PrepareDS() { MPADocumentDataSet documentDS = new MPADocumentDataSet(); return(documentDS); }
public System.Data.DataSet PrepareDataToDataset(long documentID, bool isCopy) { MPADocumentDataSet mpaDocumentDS = new MPADocumentDataSet(); MPADocument mpaDocument = ScgeAccountingQueryProvider.MPADocumentQuery.GetMPADocumentByDocumentID(documentID); Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); if (mpaDocument == null) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("MPADocumentNotFound")); } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } // Prepare Data to Document datatable. if (!isCopy) { SCGDocumentService.PrepareDataToDataset(mpaDocumentDS, documentID); } else { SCGDocumentService.PrepareDataInternalToDataset(mpaDocumentDS, documentID, isCopy); } // Set data to Document row MPADocumentDataSet.MPADocumentRow mpaDocumentRow = mpaDocumentDS.MPADocument.NewMPADocumentRow(); mpaDocumentRow.MPADocumentID = mpaDocument.MPADocumentID; if (!isCopy) { if (mpaDocument.DocumentID != null) { mpaDocumentRow.DocumentID = mpaDocument.DocumentID.DocumentID; } } else { if (mpaDocumentDS.Document.Rows.Count > 0) { MPADocumentDataSet.DocumentRow docRow = (MPADocumentDataSet.DocumentRow)mpaDocumentDS.Document.Rows[0]; mpaDocumentRow.DocumentID = docRow.DocumentID; } } mpaDocumentRow.StartDate = mpaDocument.StartDate; mpaDocumentRow.EndDate = mpaDocument.EndDate; mpaDocumentRow.Active = mpaDocument.Active; mpaDocumentRow.CreBy = mpaDocument.CreBy; mpaDocumentRow.CreDate = mpaDocument.CreDate; mpaDocumentRow.UpdBy = mpaDocument.UpdBy; mpaDocumentRow.UpdDate = mpaDocument.UpdDate; mpaDocumentRow.UpdPgm = mpaDocument.UpdPgm; // Add ta document row to MPADocument. mpaDocumentDS.MPADocument.AddMPADocumentRow(mpaDocumentRow); // Prepare Data to MPAItemService Datatable. MPAItemService.PrepareDataToDataset(mpaDocumentDS, mpaDocument.MPADocumentID); return(mpaDocumentDS); }