internal static PacificCode getPacificCode(string sCodeNumber)
 {
     DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
     PacificCode oPacificCode = mpdb.PacificCodes.Where(p => p.CodeNumber == sCodeNumber).Single<PacificCode>();
     mpdb.Connection.Close();
     return oPacificCode;
 }
 internal static Customer getCustomer(string sPhone)
 {
     DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
     Customer oCustomer = mpdb.Customers.Where(c => c.Phone == sPhone).Single<Customer>();
     mpdb.Connection.Close();
     return oCustomer;
 }
 internal static bool IsExist(string sPhone)
 {
     DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
     bool bResult = mpdb.StoreUsers.Any(l => l.Phone.Trim() == sPhone.Trim());
     mpdb.Connection.Close();
     return bResult;
 }
        internal static void updateAfterInsertNewCode(PacificCode newPacificCode)
        {
            DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
            // GET
            StoreUser existStore = mpdb.StoreUsers.Where(s => s.Id == newPacificCode.StoreId).Single<StoreUser>();

            // EXEC
            if (existStore != null)
            {
                if (existStore.NumberSales == null)
                {
                    existStore.NumberSales = 1;
                }
                else
                {
                    existStore.NumberSales++;
                }

                if (existStore.TotalSales == null)
                {
                    existStore.TotalSales = newPacificCode.ActualAmount;
                }
                else
                {
                    existStore.TotalSales += newPacificCode.ActualAmount;
                }
                // SAVE
                mpdb.SubmitChanges();
            }

            mpdb.Connection.Close();
        }
 internal static bool isExist(string sPhone)
 {
     DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
     bool bResult = mpdb.Customers.Where(c=>c.Phone == sPhone).Any();
     mpdb.Connection.Close();
     return bResult;
 }
 internal static bool IsExist(string sPhone)
 {
     DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
     bool bResult = mpdb.StoreManagers.Where(s => s.ManagerPhone.Trim() == sPhone.Trim()).Any();
     mpdb.Connection.Close();
     return bResult;            
 }
 public static List<PacificCode> GetList(int storeId)
 {
     DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
     List<PacificCode> lstPacificCode = mpdb.PacificCodes.Where(p => p.StoreId == storeId).ToList<PacificCode>();
     mpdb.Connection.Close();
     return lstPacificCode;
 }
示例#8
0
 internal static Agent GetItem(int id)
 {
     DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
     Agent existAgent = mpdb.Agents.Where(a => a.Id == id).SingleOrDefault<Agent>();
     mpdb.Connection.Close();
     return existAgent;
 }
 internal static bool isValidAmount(int amountBuy)
 {
     DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
     bool bResult =  (mpdb.Categories.Where(c => c.Value == amountBuy && c.Active == true).Any());
     mpdb.Connection.Close();
     return bResult;
 }
 internal static void addNew(PacificCode newPacificCode)
 {
     DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
     mpdb.PacificCodes.InsertOnSubmit(newPacificCode);
     mpdb.SubmitChanges();
     mpdb.Connection.Close();
 }
 internal static StoreUser[] GetArray(int managerId)
 {
     DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
     StoreUser[] lstUser = mpdb.StoreUsers.Where(s => s.ManagerId == managerId).ToArray();
     mpdb.Connection.Close();
     return lstUser;
 }
示例#12
0
        //private static DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();

        internal static void updateAfterInsertNewCode(PacificCode newPacificCode)
        {
            DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
            // GET
            Customer existCustomer = mpdb.Customers.Where(c => c.Id == newPacificCode.CustomerId).Single<Customer>();
            
            // EXEC
            if (existCustomer != null)
            {
                // . NumberTransaction
                if (existCustomer.NumberTransaction == null)
                {
                    existCustomer.NumberTransaction = 1;
                }
                else
                {
                    existCustomer.NumberTransaction++;
                }

                // . Total Amount
                if (existCustomer.TotalAmount == null)
                {
                    existCustomer.TotalAmount = newPacificCode.ActualAmount;
                }
                else
                {
                    existCustomer.TotalAmount += newPacificCode.ActualAmount;
                }

            }

            // SAVE
            mpdb.SubmitChanges();
            mpdb.Connection.Close();
        }
 internal static CollectMoney[] GetListStatusId(int statusId)
 {
     DBMoneyPacificDataContext db = new DBMoneyPacificDataContext();
     CollectMoney[] arrResult = db.CollectMoneys                
         .Where(c => c.StatusId == statusId).ToArray();
     db.Connection.Close();
     return arrResult;
 }
        //internal static bool Update(string sCollectCode)
        //{
        //    DBMoneyPacificDataContext db = new DBMoneyPacificDataContext();
        //    bool iResult = false;
        //    if (IsExist(sCollectCode))
        //    {
        //    }
        //    else
        //    {
        //        iResult = false;
        //    }
        //    db.Connection.Close();
        //    return iResult;
        //}

        internal static bool IsExist(string sCollectCode)
        {
            DBMoneyPacificDataContext db = new DBMoneyPacificDataContext();
            bool bResult = db.CollectMoneys
                .Where(c => c.CollectNumber.Trim() == sCollectCode.Trim()).Any();
            db.Connection.Close();
            return bResult;
        }
 internal static StoreManager GetItem(int managerId)
 {
     DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
     StoreManager existStore = mpdb.StoreManagers.
         Where(s => s.Id == managerId).Single<StoreManager>();
     mpdb.Connection.Close();
     return existStore;            
 }
 internal static StoreManager GetItem(string sPhone)
 {
     DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
     StoreManager existStore = mpdb.StoreManagers.
         Where(s => s.ManagerPhone.Trim() == sPhone.Trim()).Single<StoreManager>();
     mpdb.Connection.Close();
     return existStore;
 }
        // private static DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();

        internal static bool isExist(string sCodeNumber)
        {
            DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
            bool bResult = mpdb.PacificCodes.Where(p => p.CodeNumber.Trim() == sCodeNumber.Trim()).Any();
            mpdb.Connection.Close();
            return bResult;

        }
 internal static StoreUser GetStoreUser(string storePhone, string PINStore)
 {
     DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
     StoreUser existStore = mpdb.StoreUsers
         .Where(s => s.Phone.Trim() == storePhone.Trim() && s.PINStore == PINStore)
         .FirstOrDefault();
     mpdb.Connection.Close();
     return existStore;
 }
 public static int GetId(string nameState)
 {
     DBMoneyPacificDataContext db = new DBMoneyPacificDataContext();
     int id = (int)db.CollectStates
         .Where(c => c.Name.Trim() == nameState.Trim())
         .Single<CollectState>().Id;
     db.Connection.Close();
     return id;
 }
 internal static CollectMoney GetItem(string sCollectCode)
 {
     DBMoneyPacificDataContext db = new DBMoneyPacificDataContext();
     CollectMoney existCollectMoney = db.CollectMoneys                
         .Where(c => c.CollectNumber.Trim() == sCollectCode.Trim())
         .SingleOrDefault<CollectMoney>();
     db.Connection.Close();
     return existCollectMoney;
 }
        // private static DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();

        internal static bool CheckPassword(StoreUser senderStore)
        {
            DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
            bool bResult = mpdb.StoreUsers.Where(l => (l.Phone == senderStore.Phone
                 && l.PINStore == senderStore.PINStore)).Any();
            mpdb.Connection.Close();
            return bResult;

        }
 internal static int getActualAmount(string sCodeNumber)
 {
     DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
     
     PacificCode pCode = mpdb.PacificCodes.Where
         (p => p.CodeNumber.Trim() == sCodeNumber.Trim()).Single<PacificCode>();
     
     int iResult = (int)pCode.ActualAmount;
     mpdb.Connection.Close();
     
     return iResult;
 }
示例#23
0
        internal static Customer addNew(string sPhone)
        {
            DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();

            Customer newCustomer = new Customer();
            
            newCustomer.Phone = sPhone;
            // Default: Customer.status = "001" (normal customer & not yet buy)
            
            newCustomer.StatusID = CustomerStateBUS.getId("001");

            mpdb.Customers.InsertOnSubmit(newCustomer);
            mpdb.SubmitChanges();

            mpdb.Connection.Close();
            return newCustomer;
        }
        // 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();
        }
        internal static bool Update(CollectMoney updateCollectMoney)
        {
            DBMoneyPacificDataContext db = new DBMoneyPacificDataContext();
            bool iResult = false;
            CollectMoney exitCollectMoney = db.CollectMoneys
                .Where(c => c.CollectNumber.Trim() == updateCollectMoney.CollectNumber.Trim())
                .Single<CollectMoney>();

            exitCollectMoney.Amount = updateCollectMoney.Amount;
            exitCollectMoney.CollecteDate = updateCollectMoney.CollecteDate;
            exitCollectMoney.StatusId = updateCollectMoney.StatusId;
            
            db.SubmitChanges();
            db.Connection.Close();

            iResult = true;
            return iResult;
        }
        internal static int getMoneyForPayMent(string sCodeNumber, int Amount)
        {
            try
            {
                DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
                
                PacificCode pCode = mpdb.PacificCodes.Where
                    (p => p.CodeNumber.Trim() == sCodeNumber.Trim()).Single<PacificCode>();
                
                int iMin = Utility.Min((int)pCode.ActualAmount, Amount);

                pCode.ActualAmount = pCode.ActualAmount - iMin;
                Amount = Amount - iMin;

                mpdb.SubmitChanges();
                mpdb.Connection.Close();
                return iMin;
            }
            catch
            {
                return 0;
            }
        }
 internal static StoreUser GetItem(int storeId)
 {
     DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
     StoreUser exitStore = mpdb.StoreUsers
         .Where(l => l.Id == storeId)
         .Single<StoreUser>();
     mpdb.Connection.Close();
     return exitStore;            
 }
        internal static StoreUser GetItem(string sPhone)
        {
            DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
            StoreUser result = mpdb.StoreUsers
                .Where(l => l.Phone.Trim() == sPhone.Trim())
                .Single<StoreUser>();

            mpdb.Connection.Close();
            return result;
        }
        internal static bool UnLock(int storeId)
        {
            DBMoneyPacificDataContext mpdb = new DBMoneyPacificDataContext();
            StoreUser exitStore = mpdb.StoreUsers
                .Where(l => l.Id == storeId)
                .Single<StoreUser>();

            /// UNLOCK
            exitStore.Enable = true;
            ///

            mpdb.SubmitChanges();
            mpdb.Connection.Close();
            return true;
        }
        /// <summary>
        /// Lấy tất cả các PacificCode được mua bởi StoreUser này, 
        /// ở trong tháng. Tính tổng tất cả InitialAmount 
        /// </summary>        
        internal static int GetTotalAmount(int storeId)
        {
            DBMoneyPacificDataContext db = new DBMoneyPacificDataContext();
            int iTotalAmount = 0;

            //iTotalAmount = (from p in db.PacificCodes
            //                where p.StoreId == storeId
            //                select (int)p.InitialAmount).DefaultIfEmpty().Sum();

            List<PacificCode> lstPacificCode = PacificCodeDAO.GetList(storeId);
            foreach (PacificCode p in lstPacificCode)
            {
                if (p.InitialAmount == null) p.InitialAmount = 0;
                iTotalAmount += (int)p.InitialAmount;
            }

            db.Connection.Close();
            return iTotalAmount;
        }