public static StoreUser _GetTestStoreUser()
{
MoneyPacificEntities mpdb = new MoneyPacificEntities();
StoreUser store = mpdb.StoreUsers.First<StoreUser>();
mpdb.Connection.Close();
return store;
}
internal static StoreUser[] GetList(int ManagerId)
{
MoneyPacificEntities mpdb = new MoneyPacificEntities();
StoreUser[] lstUser = mpdb.StoreUsers.Where(s => s.ManagerId == ManagerId).ToArray();
mpdb.Connection.Close();
return lstUser;
}
public ActionResult ChangeCode(PacificCodeChangeCodeViewModel obj )
{
MoneyPacificEntities db = new MoneyPacificEntities();
if (obj.CodeNumber == null) return View();
obj.CodeNumber = obj.CodeNumber.Trim(' ');
bool bExist = db.PacificCodes.Where(p => p.CodeNumber == obj.CodeNumber).Any();
if (bExist)
{
PacificCode pCode = db.PacificCodes.Where
(p => p.CodeNumber.Trim() == obj.CodeNumber.Trim()).SingleOrDefault<PacificCode>();
do
{
pCode.CodeNumber = Generator.getNewCode();
bExist = (db.PacificCodes.Where
(p => p.CodeNumber.Trim() == pCode.CodeNumber.Trim()).Any());
} while (bExist);
db.SaveChanges();
obj.CodeNumber = pCode.CodeNumber;
ViewData["Message"] = obj.CodeNumber;
}
else
{
ViewData["Message"] = "Pacifice Code này ko tồn tại!.";
}
// Luu vao Transaction
// ..
db.Connection.Close();
return View();
}
internal static PacificCode[] GetList(int storeUserId)
{
MoneyPacificEntities db = new MoneyPacificEntities();
PacificCode[] arrResult = db.PacificCodes.Where(p => p.StoreId == storeUserId).ToArray();
db.Connection.Close();
return arrResult;
}
internal static StoreUser GetItem(int Id)
{
MoneyPacificEntities db = new MoneyPacificEntities();
StoreUser storeUser = db.StoreUsers.Where(s => s.Id == Id).Single<StoreUser>();
db.Connection.Close();
return storeUser;
}
internal static void AddObject(TimeTable timeTable)
{
MoneyPacificEntities db = new MoneyPacificEntities();
db.TimeTables.AddObject(timeTable);
db.SaveChanges();
db.Connection.Close();
}
internal static Customer getCustomer(string sPhone)
{
MoneyPacificEntities mpdb = new MoneyPacificEntities();
Customer oCustomer = mpdb.Customers.Where(c => c.Phone == sPhone).Single<Customer>();
mpdb.Connection.Close();
return oCustomer;
}
internal static StoreManagerState[] GetArray()
{
MoneyPacificEntities db = new MoneyPacificEntities();
StoreManagerState[] result = db.StoreManagerStates.ToArray();
db.Connection.Close();
return result;
}
public static int GetId(string codeState)
{
MoneyPacificEntities db = new MoneyPacificEntities();
StoreManagerState state = db.StoreManagerStates.Where
(s => s.Code.Trim() == codeState.Trim()).Single<StoreManagerState>();
return state.Id;
}
internal static List<Agent> GetList()
{
MoneyPacificEntities db = new MoneyPacificEntities();
List<Agent> lstAgent = db.Agents.ToList();
db.Connection.Close();
return lstAgent;
}
internal static void AddItem(PacificCode newPacificCode)
{
MoneyPacificEntities db = new MoneyPacificEntities();
db.PacificCodes.AddObject(newPacificCode);
db.SaveChanges();
db.Connection.Close();
}
internal static AgentState[] GetArray()
{
MoneyPacificEntities db = new MoneyPacificEntities();
AgentState[] result = db.AgentStates.ToArray();
db.Connection.Close();
return result;
}
internal static CollectMoney GetItem(int storeManagerId, int iStatusId, DateTime expireDate)
{
MoneyPacificEntities db = new MoneyPacificEntities();
CollectMoney result = null;
CollectMoney[] arrCM = db.CollectMoneys
.Include("StoreManager")
.Include("Agent")
.Include("CollectState")
.Where(c => c.StoreManagerId == storeManagerId
&& c.StatusId == iStatusId)
.DefaultIfEmpty<CollectMoney>().ToArray();
db.Connection.Close();
//if (arrCM == null) arrCM = new CollectMoney[0];
foreach (CollectMoney cm in arrCM)
{
if (cm != null)
{
if (cm.ExpireDate == null)
{
cm.ExpireDate = DateTime.MinValue;
}
if (cm.ExpireDate.Value > expireDate)
{
result = cm;
break;
}
}
}
return result;
}
internal static string getCode(int? iId)
{
MoneyPacificEntities mpdb = new MoneyPacificEntities();
if (iId == null) iId = 1; // Default
string sResult = mpdb.CustomerStates.Where(c => c.Id == iId).Single<CustomerState>().Code;
mpdb.Connection.Close();
return sResult;
}
internal static CollectMoney[] GetList(int storeManagerId)
{
MoneyPacificEntities db = new MoneyPacificEntities();
CollectMoney[] arrResult = db.CollectMoneys
.Where(c => c.StoreManagerId == storeManagerId).ToArray();
db.Connection.Close();
return arrResult;
}
internal static string GetCode(int Id)
{
MoneyPacificEntities db = new MoneyPacificEntities();
string result = db.StoreManagerStates.Where(s => s.Id == Id)
.Single<StoreManagerState>().Code;
db.Connection.Close();
return result;
}
internal static bool AddItem(Agent newAgent)
{
MoneyPacificEntities db = new MoneyPacificEntities();
db.Agents.AddObject(newAgent) ;
db.SaveChanges();
db.Connection.Close();
return true;
}
internal static InternetAccessRole[] GetArray()
{
MoneyPacificEntities db = new MoneyPacificEntities();
InternetAccessRole[] result = db.InternetAccessRoles.ToArray();
db.Connection.Close();
return result;
}
internal static string GetPhone(int? customerId)
{
MoneyPacificEntities mpdb = new MoneyPacificEntities();
string result = mpdb.Customers.Where
(c => c.Id == customerId).Single<Customer>().Phone;
mpdb.Connection.Close();
return result;
}
internal static int getId(string customerStatus)
{
MoneyPacificEntities mpdb = new MoneyPacificEntities();
int iResult = (mpdb.CustomerStates.Where(c =>
c.Code == customerStatus).Single<CustomerState>()).Id;
mpdb.Connection.Close();
return iResult;
}
internal static bool isExist(string sPhone)
{
MoneyPacificEntities mpdb = new MoneyPacificEntities();
bool bResult = mpdb.Customers.Where(c => c.Phone == sPhone).Any();
mpdb.Connection.Close();
return bResult;
}
internal static void AddItem(CollectMoney newCollectMoney)
{
MoneyPacificEntities db = new MoneyPacificEntities();
db.CollectMoneys.AddObject(newCollectMoney);
db.SaveChanges();
db.Connection.Close();
}
public static bool AddNew(StoreManager newStoreManager)
{
MoneyPacificEntities db = new MoneyPacificEntities();
db.StoreManagers.AddObject(newStoreManager);
db.SaveChanges();
db.Connection.Close();
return true;
}
internal static void UpdateAmount(PacificCode pacificCode, int actualAmount)
{
MoneyPacificEntities db = new MoneyPacificEntities();
PacificCode existPacificCode = PacificCodeDAO.GetItem(pacificCode.CodeNumber);
existPacificCode.ActualAmount = actualAmount;
db.SaveChanges();
db.Connection.Close();
}
internal static PacificCode GetItem(string codeNumber)
{
MoneyPacificEntities db = new MoneyPacificEntities();
PacificCode result = db.PacificCodes.
Where(p => p.CodeNumber.Trim() == codeNumber).Single<PacificCode>();
db.Connection.Close();
return result;
}
internal static bool IsExist(string codeNumber)
{
MoneyPacificEntities db = new MoneyPacificEntities();
bool result = db.PacificCodes.
Where(p => p.CodeNumber.Trim() == codeNumber).Any();
db.Connection.Close();
return result;
}
internal static TimeTable GetItem(int timeItemId, int managerId)
{
MoneyPacificEntities db = new MoneyPacificEntities();
TimeTable result = db.TimeTables
.Where(t => (t.TimeItemId == timeItemId && t.ManagerId == managerId))
.SingleOrDefault();
db.Connection.Close();
return result;
}
internal static Agent GetItem(int id)
{
MoneyPacificEntities db = new MoneyPacificEntities();
Agent existAgent = db.Agents
.Where(a => a.Id == id)
.SingleOrDefault();
db.Connection.Close();
return existAgent;
}
internal static bool Remove(int id)
{
MoneyPacificEntities db = new MoneyPacificEntities();
Agent existAgent = db.Agents.Where(a => a.Id == id).SingleOrDefault();
db.Agents.DeleteObject(existAgent);
db.SaveChanges();
db.Connection.Close();
return true;
}
internal static bool IsExist(string collectNumber)
{
MoneyPacificEntities db = new MoneyPacificEntities();
bool bResult = db.CollectMoneys
.Where(c => c.CollectNumber.Trim() == collectNumber.Trim())
.Any();
db.Connection.Close();
return bResult;
}
