public void TestModifyGiftBatch() { TDataBase db = DBAccess.Connect("test"); TDBTransaction t = db.BeginTransaction(IsolationLevel.Serializable); GiftBatchTDS MainDS; ALedgerAccess.LoadAll(MainDS, t); MainDS.ALedger[0].LastGiftBatchNumber++; AGiftBatchRow batch = MainDS.AGiftBatch.NewRowTyped(); batch.LedgerNumber = MainDS.ALedger[0].LedgerNumber; batch.BatchNumber = MainDS.ALedger[0].LastGiftBatchNumber; batch.BankAccountCode = "6000"; batch.BatchYear = 1; batch.BatchPeriod = 1; batch.CurrencyCode = "EUR"; batch.BankCostCentre = MainDS.ALedger[0].LedgerNumber.ToString() + "00"; batch.LastGiftNumber = 2; MainDS.AGiftBatch.Rows.Add(batch); AGiftRow gift = MainDS.AGift.NewRowTyped(); gift.LedgerNumber = batch.LedgerNumber; gift.BatchNumber = batch.BatchNumber; gift.GiftTransactionNumber = 1; MainDS.AGift.Rows.Add(gift); gift = MainDS.AGift.NewRowTyped(); gift.LedgerNumber = batch.LedgerNumber; gift.BatchNumber = batch.BatchNumber; gift.GiftTransactionNumber = 2; gift.LastDetailNumber = 1; MainDS.AGift.Rows.Add(gift); AGiftDetailRow giftdetail = MainDS.AGiftDetail.NewRowTyped(); giftdetail.LedgerNumber = gift.LedgerNumber; giftdetail.BatchNumber = gift.BatchNumber; giftdetail.GiftTransactionNumber = gift.GiftTransactionNumber; giftdetail.DetailNumber = 1; giftdetail.MotivationGroupCode = "GIFT"; giftdetail.MotivationDetailCode = "SUPPORT"; MainDS.AGiftDetail.Rows.Add(giftdetail); MainDS.SubmitChanges(t); t.Commit(); // now delete the first gift, and fix the gift detail of the second gift t = db.BeginTransaction(IsolationLevel.Serializable); MainDS.AGift.Rows.RemoveAt(0); MainDS.AGift[0].GiftTransactionNumber = 1; MainDS.AGiftDetail[0].GiftTransactionNumber = 1; MainDS.AGiftBatch[0].LastGiftNumber = 1; MainDS.SubmitChanges(t); g.Commit(); }
public MainF(MainDS App, jobDS JOB) { db = App; this.JOB = JOB; InitializeComponent(); }
public void DisplayStatsForTMSSync() { MainDS ds = new MainDS(); TMSWithReasonDataTable dt = ds.TMSWithReason; output.WriteLine(""); foreach (string key in outputList.Keys) { //output.WriteLine("---------------------------"); //output.WriteLine(key); //output.WriteLine("---------------------------"); foreach (TMS_TP tp in outputList[key]) { //output.WriteLine(tp.ToString()); DataRow r = dt.NewRow(); r["Reason"] = key; if (tp.Item1 != null) { r["TMS"] = tp.Item1.TMS; r["TMS_Assigned"] = tp.Item1.AssignedTo; r["TMS_Status"] = tp.Item1.Status; } r["TMS_ACT_SHOW"] = "X"; r["RM_ACT_SHOW"] = "X"; if (IsAssignedToMe(tp.ToString())) { r["Me"] = "Y"; } if (tp.Item2 != null) { r["RM"] = tp.Item2.RMId; r["RM_Assigned"] = tp.Item2.AssignedTo; r["RM_Status"] = tp.Item2.Status; } dt.Rows.Add(r); } } output.WriteLine("\r\n-------TMS not exist in RM-------"); foreach (TMSItem item in dbTMSDict.GetNotClosedNotUsedAssignedToDEV1ItemList(TeamService.UsersTMSLogin)) { output.WriteLine(item.ToString()); DataRow r = dt.NewRow(); FillOutputGridRowWithTMSData(item, r, Consts.RFC_NOT_EXISTS_IN_RM); dt.Rows.Add(r); } output.WriteLine("\r\n-------RM duplicated TMS -------"); Dictionary <string, List <TMSItem> > duplicates = rmTMSDict.GetDuplicates(); foreach (string tmsNum in duplicates.Keys) { output.WriteLine(tmsNum); foreach (TMSItem item in duplicates[tmsNum]) { output.WriteLine(" " + item); } } output.WriteLine("\r\n-------ASSIGNED TO ME IN REDMINE-------"); List <string> me = new List <string>(); me.Add("Waldemar Dacko"); foreach (TMSItem item in rmTMSDict.GetNotClosedNotUsedAssignedToDEV1ItemList(me)) { output.WriteLine(item.TMS); /* * DataRow r = dt.NewRow(); * FillOutputGridRowWithTMSRMData(item, r, Consts.RFC_ASSIGNED_TO_ME_IN_RM); * dt.Rows.Add(r); */ } output.WriteLine("\r\n-------ASSIGNED TO ME IN TMS-------"); me.Add("WALDEMARD"); foreach (TMSItem item in dbTMSDict.GetNotClosedNotUsedAssignedToDEV1ItemList(me)) { output.WriteLine(item.TMS); DataRow r = dt.NewRow(); FillOutputGridRowWithTMSData(item, r, Consts.RFC_ASSIGNED_TO_ME_IN_TMS); dt.Rows.Add(r); } output.WriteLine("\r\n----------------------------"); dt.AcceptChanges(); output.WriteToGrid(dt); }
public frmSelectWorker(TextBox txtBoxWorkerJob, MainDS db) { InitializeComponent(); this.txtBoxWorkerJob = txtBoxWorkerJob; bindingSource1.DataSource = db.Persone; }