/// <summary>
/// Kiểm tra tồn tại
/// </summary>
public static bool IsExist(int amountBuy)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
bool result = mpdb.Categories.Any(c => c.Value == amountBuy && c.Active == true);
mpdb.Connection.Close();
return result;
}
//
public static bool IsExist(string phoneNumber)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
bool result = mpdb.Customers.Any(c => c.PhoneNumber.Trim() == phoneNumber.Trim());
mpdb.Connection.Close();
return result;
}
public static bool AddNew(Collection entity)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
mpdb.Collections.InsertOnSubmit(entity);
mpdb.SubmitChanges();
return true;
}
public static bool AddNew(StoreUser entity)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
DataAccessLayer.GetConnection.StoreUsers.InsertOnSubmit(entity);
DataAccessLayer.GetConnection.SubmitChanges();
return true;
}
public static void AddObject(TimeTable entity)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
mpdb.TimeTables.InsertOnSubmit(entity);
mpdb.SubmitChanges();
mpdb.Connection.Close();
}
public static List<PartPacificCode> GetList()
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
List<PartPacificCode> lstResult = mpdb.PartPacificCodes.ToList<PartPacificCode>();
mpdb.Connection.Close();
return lstResult;
}
public static List<StoreManager> GetList()
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
List<StoreManager> result = mpdb.StoreManagers.ToList<StoreManager>();
mpdb.Connection.Close();
return result;
}
public static StoreUser GetObject(string phoneNumber)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
return DataAccessLayer.GetConnection.StoreUsers
.Where(s => s.Phone.Trim().Equals(phoneNumber.Trim()))
.Single<StoreUser>();
}
public static bool Update(Agent entity)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
Agent existAgent = DataAccessLayer.GetConnection.Agents
.Where(p => p.UserId.Equals(entity.UserId))
.SingleOrDefault();
existAgent.Address = entity.Address;
//existAgent.Block = entity.Block;
//existAgent.CreateDate = entity.CreateDate;
//existAgent.Email = entity.Email;
//existAgent.FirstName = entity.FirstName;
//existAgent.LastName = entity.LastName;
//existAgent.LastVisitDate = entity.LastVisitDate;
//existAgent.Password = entity.Password;
existAgent.Phone = entity.Phone;
existAgent.StatusId = entity.StatusId;
//existAgent.Username = entity.Username;
DataAccessLayer.GetConnection.SubmitChanges();
mpdb.Connection.Close();
return true;
}
public static StoreUser[] GetArray(Guid managerUserId)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
StoreUser[] result = mpdb.StoreUsers
.Where(s => s.ManagerId.Equals(managerUserId)).ToArray<StoreUser>();
mpdb.Connection.Close();
return result;
}
public static bool IsExist(string collectNumber)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
bool result = mpdb.Collections
.Where(p => p.CollectNumber.Trim() == collectNumber.Trim())
.Any();
return result;
}
public static CollectionState GetObject(int id)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
CollectionState existState = mpdb.CollectionStates
.Where(c => c.Id == id)
.SingleOrDefault();
return existState;
}
public static bool AddNew(PartPacificCode entity)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
mpdb.PartPacificCodes.InsertOnSubmit(entity);
mpdb.SubmitChanges();
mpdb.Connection.Close();
return true;
}
public static StoreManager GetObject(string phoneNumber)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
StoreManager obj = mpdb.StoreManagers
.Where(s => s.ManagerPhone.Trim().Equals(phoneNumber.Trim()))
.Single<StoreManager>();
mpdb.Connection.Close();
return obj;
}
public static TimeItem GetObject(string day, int hour)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
TimeItem result = mpdb.TimeItems
.Where(t => (t.Day == day && t.Hour == hour))
.SingleOrDefault();
mpdb.Connection.Close();
return result;
}
public static PartPacificCode GetObject(Guid id)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
PartPacificCode result = mpdb.PartPacificCodes
.Where(p => p.Id.Equals(id))
.Single<PartPacificCode>();
mpdb.Connection.Close();
return result;
}
public static List<StoreUser> GetList(Guid managerId)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
List<StoreUser> lstResult = mpdb.StoreUsers
.Where(s => s.ManagerId == managerId)
.ToList<StoreUser>();
mpdb.Connection.Close();
return lstResult;
}
public static StoreUserState GetObject(int id)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
StoreUserState result = mpdb.StoreUserStates
.Where(s => s.Id.Equals(id))
.Single<StoreUserState>();
mpdb.Connection.Close();
return result;
}
public static List<Collection> GetList(int statusId)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
List<Collection> lstResult = mpdb.Collections
.Where(p => (p.StatusId == statusId))
.ToList<Collection>();
mpdb.Connection.Close();
return lstResult;
}
public static Collection GetObject(string collectNumber)
{
MoneyPacificDataContext mpdp = new MoneyPacificDataContext();
Collection existCollection = mpdp.Collections
.Where(c => c.CollectNumber.Trim() == collectNumber.Trim())
.SingleOrDefault<Collection>();
mpdp.Connection.Close();
return existCollection;
}
public static StoreUser GetObject(Guid userId)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
StoreUser existStore = mpdb.StoreUsers
.Where(s => s.UserId.Equals(userId))
.Single<StoreUser>();
mpdb.Connection.Close();
return existStore;
}
public static User GetObject(Guid userId)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
User existUser = mpdb.Users
.Where(c => c.Id.Equals(userId))
.Single<User>();
mpdb.Connection.Close();
return existUser;
}
public static CustomerState GetObject(int id)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
CustomerState obj = mpdb.CustomerStates
.Where(c => c.Id == id)
.Single<CustomerState>();
mpdb.Connection.Close();
return obj;
}
public static Customer GetObject(string phoneNumber)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
Customer existCustomer = mpdb.Customers
.Where(c => c.PhoneNumber.Trim().Equals(phoneNumber.Trim()))
.Single<Customer>();
mpdb.Connection.Close();
return existCustomer;
}
public static TimeTable GetObject(int timeItemId, Guid managerId)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
TimeTable result = mpdb.TimeTables
.Where(t => (t.TimeItemId == timeItemId && t.ManagerId == managerId))
.SingleOrDefault();
mpdb.Connection.Close();
return result;
}
public static Area GetObject(int id)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
Area result = mpdb.Areas
.Where(a => a.Id.Equals(id))
.Single<Area>();
mpdb.Connection.Close();
return result;
}
public static StoreManager GetObject(Guid userId)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
StoreManager obj= mpdb.StoreManagers
.Where(s => s.UserId == userId)
.Single<StoreManager>();
mpdb.Connection.Close();
return obj;
}
public static CustomerState GetObject(string code)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
CustomerState obj = mpdb.CustomerStates
.Where(c => c.Code.Trim().Equals(code.Trim()))
.Single<CustomerState>();
mpdb.Connection.Close();
return obj;
}
public static AgentState GetObject(int id)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
AgentState existAgentState = mpdb.AgentStates
.Where(a => a.Id == id)
.Single<AgentState>();
mpdb.Connection.Close();
return existAgentState;
}
public static Customer GetObject(Guid customerUserId)
{
MoneyPacificDataContext mpdb = new MoneyPacificDataContext();
Customer existCustomer = mpdb.Customers
.Where(c => c.UserId.Equals(customerUserId))
.Single<Customer>();
mpdb.Connection.Close();
return existCustomer;
}
