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