예제 #1
0
        /// <summary>
        /// 更新預約資訊
        /// </summary>
        /// <param name="clientData"></param>
        /// <returns></returns>
        public static bool Update(Interview.Models.Container.ClientData clientData)
        {
            try
            {
                using (var context = new HouseRulesEntities())
                {
                    //var item = context.ClientData.FirstOrDefault(x => x.ID == clientData.ID);
                    var item = context.ClientData.FirstOrDefault(x => x.ID == clientData.ID);

                    if (item == null)
                    {
                        return(false);
                    }

                    item.ClientName = clientData.ClientName;
                    item.Sex        = clientData.Sex;
                    item.City       = clientData.City;
                    item.Address    = clientData.Address;
                    item.Mobile     = clientData.Mobile;
                    item.Budget     = clientData.Budget;
                    item.UpdateDate = DateTime.Now;

                    context.SaveChanges();
                }
                return(true);
            }
            catch
            {
                return(false);
            }
        }
예제 #2
0
        /// <summary>
        /// 抓所有預約資訊的ViewModel
        /// </summary>
        /// <returns></returns>
        public static List <Interview.ViewModel.ClientDataViewModel> GetClientsViewModel()
        {
            try
            {
                var query = new List <Interview.Models.Container.ClientData>();
                using (var context = new HouseRulesEntities())
                {
                    query = context.ClientData.Where(x => x.Status == 1).ToList();
                }

                var clientList = new List <Interview.ViewModel.ClientDataViewModel>();
                foreach (var item in query)
                {
                    clientList.Add(
                        new Interview.ViewModel.ClientDataViewModel
                    {
                        Id         = item.ID,
                        ClientName = item.ClientName,
                        Sex        = item.Sex,
                        City       = item.City,
                        Address    = item.Address,
                        Mobile     = item.Mobile,
                        Budget     = item.Budget,
                    });
                }

                return(clientList);
            }
            catch
            {
                return(new List <Interview.ViewModel.ClientDataViewModel>());
            }
        }
예제 #3
0
        /// <summary>
        /// 檢查後台帳號登入
        /// </summary>
        /// <param name="account">帳號</param>
        /// <param name="password">密碼</param>
        /// <param name="isLoginAction">是否為登入動作</param>
        /// <returns></returns>
        public static Interview.Models.Container.AdminAccount GetAccount(string account, string password, bool isLoginAction)
        {
            try
            {
                using (var context = new HouseRulesEntities())
                {
                    var encryptPassword = Utility.SiteSecurity.Encrypt(password);
                    if (string.IsNullOrWhiteSpace(account) || string.IsNullOrWhiteSpace(encryptPassword))
                    {
                        return(null);
                    }

                    var query = context.AdminAccount.FirstOrDefault(x => x.Account == account && x.Password == encryptPassword);
                    if (query != null)
                    {
                        return(query);
                    }

                    return(null);
                }
            }
            catch
            {
                throw;
            }
        }
예제 #4
0
 /// <summary>
 /// 抓指定的keyvalue
 /// </summary>
 ///
 /// <returns></returns>
 public static KeyValue GetKeyValueById(int keyId)
 {
     try
     {
         using (var context = new HouseRulesEntities())
         {
             return(context.KeyValue.FirstOrDefault(x => x.Status == true && x.KeyID == keyId));
         }
     }
     catch
     {
         return(new KeyValue());
     }
 }
예제 #5
0
 /// <summary>
 /// 抓全部的keyvalue
 /// </summary>
 /// <returns></returns>
 public static List <KeyValue> GetKeyValues()
 {
     try
     {
         using (var context = new HouseRulesEntities())
         {
             return(context.KeyValue.Where(x => x.Status == true).ToList());
         }
     }
     catch
     {
         return(new List <KeyValue>());
     }
 }
예제 #6
0
 /// <summary>
 /// 抓指定預約資訊
 /// </summary>
 /// <param name="id"></param>
 /// <returns></returns>
 public static Interview.Models.Container.ClientData GetClientById(int id)
 {
     try
     {
         var item = new Interview.Models.Container.ClientData();
         using (var context = new HouseRulesEntities())
         {
             item = context.ClientData.FirstOrDefault(x => x.Status == 1 && x.ID == id);
         }
         return(item);
     }
     catch
     {
         return(new Interview.Models.Container.ClientData());
     }
 }
예제 #7
0
 /// <summary>
 /// 抓所有預約資訊
 /// </summary>
 /// <returns></returns>
 public static List <Interview.Models.Container.ClientData> GetClients()
 {
     try
     {
         var item = new List <Interview.Models.Container.ClientData>();
         using (var context = new HouseRulesEntities())
         {
             item = context.ClientData.Where(x => x.Status == 1).ToList();
         }
         return(item);
     }
     catch
     {
         return(new List <Interview.Models.Container.ClientData>());
     }
 }
예제 #8
0
 /// <summary>
 /// 新增後台帳號
 /// </summary>
 /// <param name="userAccount"></param>
 /// <returns></returns>
 public static bool Insert(Interview.Models.Container.AdminAccount userAccount)
 {
     try
     {
         using (var context = new HouseRulesEntities())
         {
             context.AdminAccount.Add(userAccount);
             context.SaveChanges();
             return(true);
         }
     }
     catch (Exception ex)
     {
         return(false);
     }
 }
예제 #9
0
 /// <summary>
 /// 新增預約資訊
 /// </summary>
 /// <param name="clientData"></param>
 /// <returns></returns>
 public static bool Insert(Interview.Models.Container.ClientData clientData)
 {
     try
     {
         using (var context = new HouseRulesEntities())
         {
             clientData.CreateDate = DateTime.Now;
             clientData.UpdateDate = DateTime.Now;
             clientData.Status     = 1;
             context.ClientData.Add(clientData);
             context.SaveChanges();
         }
         return(true);
     }
     catch (Exception ex)
     {
         return(false);
     }
 }
예제 #10
0
        /// <summary>
        /// 更新上下架狀態
        /// </summary>
        /// <param name="id"></param>
        /// <param name="status"></param>
        /// <returns></returns>
        public static bool EditStatus(int id, int status)
        {
            try
            {
                using (var context = new HouseRulesEntities())
                {
                    var clientData = context.ClientData.FirstOrDefault(x => x.ID == id);

                    if (clientData == null)
                    {
                        return(false);
                    }

                    clientData.UpdateDate = DateTime.Now;
                    clientData.Status     = status;
                    context.SaveChanges();
                }
                return(true);
            }
            catch (Exception ex)
            {
                return(false);
            }
        }