// internal static DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
        internal static void AddNew(DTO.PacificCode newSuccessPacificCode)
        {
            DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();

            Transaction newTransaction = new Transaction();

            newTransaction.CreateDate = newSuccessPacificCode.Date;
            newTransaction.CustomerId = newSuccessPacificCode.CustomerId;
            newTransaction.StoreId = newSuccessPacificCode.StoreId;
            newTransaction.Amount = newSuccessPacificCode.InitialAmount;
            newTransaction.Origine = "Buy MP";
            //newTranSaction.StatusID = 1; // StatusID = 1 : Status = '11'

            mpdb.Transactions.InsertOnSubmit(newTransaction);
            mpdb.SubmitChanges();

            mpdb.Connection.Close();
        }
 partial void DeleteTransaction(Transaction instance);
 partial void UpdateTransaction(Transaction instance);
 partial void InsertTransaction(Transaction instance);
		private void detach_Transactions(Transaction entity)
		{
			this.SendPropertyChanging();
			entity.TransactionCate = null;
		}
		private void attach_Transactions(Transaction entity)
		{
			this.SendPropertyChanging();
			entity.TransactionState = this;
		}
		private void attach_Transactions(Transaction entity)
		{
			this.SendPropertyChanging();
			entity.PacificCode = this;
		}