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