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