/// <summary>
/// 修改折扣
/// </summary>
/// <param name="Id">房间编号</param>
/// <param name="DiscountNum">折扣数</param>
/// <returns></returns>
public bool EditDiscount(int Id, int DiscountNum)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
Room_Discount room_Discount = new Room_Discount();
room_Discount.EstablishDate = DateTime.Now;
room_Discount.IsDelete = false;
room_Discount.DiscountNum = DiscountNum;
db.Room_Discount.Add(room_Discount);
db.SaveChanges();
Room room = db.Room.Where(s => s.Id == Id).FirstOrDefault();
Room_Discount rd = db.Room_Discount.Where(s => s.Id == room.Room_DiscountId).FirstOrDefault();
rd.IsDelete = true;
rd.DeleteDate = DateTime.Now;
rd.RoomId = Id;
db.Entry(rd).State = EntityState.Modified;
room.Room_DiscountId = room_Discount.Id;
db.Entry(room).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
//throw;
}
return(false);
}
/// <summary>
/// 修改房间金额
/// </summary>
/// <param name="Id">房间编号</param>
/// <param name="UnitPrice">金额</param>
/// <returns></returns>
public bool EditAmount(int Id, decimal UnitPrice)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
Room_Amount room_Amount = new Room_Amount();
room_Amount.EstablishDate = DateTime.Now;
room_Amount.IsDelete = false;
room_Amount.UnitPrice = UnitPrice;
db.Room_Amount.Add(room_Amount);
db.SaveChanges();
Room room = db.Room.Where(s => s.Id == Id).FirstOrDefault();
Room_Amount ra = db.Room_Amount.Where(s => s.Id == room.Room_AmountId).FirstOrDefault();
ra.IsDelete = true;
ra.DeleteDate = DateTime.Now;
ra.RoomId = room.Id;
db.Entry(ra).State = EntityState.Modified;
room.Room_AmountId = room_Amount.Id;
db.Entry(room).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
//throw;
}
return(false);
}
/// <summary>
/// 修改员工信息
/// </summary>
/// <param name="id">员工编号</param>
/// <param name="staff">修改后的员工信息</param>
/// <returns></returns>
public bool EditStaff(int id, Staff staff)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
Staff st = db.Staff.Where(s => s.Id == id).FirstOrDefault();
st.Name = staff.Name;
st.Sex = staff.Sex;
st.Age = staff.Age;
st.Nation = staff.Nation;
st.Phone = staff.Phone;
st.Email = staff.Email;
st.DeptId = staff.DeptId;
st.Staff_StateId = staff.Staff_StateId;
db.Entry(st).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
// throw;
}
return(false);
}
/// <summary>
/// 增加订单
/// </summary>
/// <param name="order">所有订单信息</param>
/// <returns></returns>
public bool AddOrder(Order order)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
db.Order.Add(order);
Room data = db.Room.Where(s => s.Id == order.RoomId).FirstOrDefault();
data.Room_StateId = 3;
db.Entry(data).State = EntityState.Modified;
Room_State room_State = new Room_State();
room_State.EstablishDate = DateTime.Now;
room_State.IsDelete = false;
room_State.RoomId = order.RoomId;
room_State.StateTxt = "使用中";
db.Room_State.Add(room_State);
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
//throw;
}
return(false);
}
/// <summary>
/// 修改状态
/// </summary>
/// <param name="id">房间编号</param>
/// <param name="dentityId">身份编号</param>
/// <returns></returns>
public bool ModifyState(int id, int dentityId)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
Room room = db.Room.Where(s => s.Id == id).FirstOrDefault();
Room_State room_State = new Room_State();
room_State.EstablishDate = DateTime.Now;
room_State.IsDelete = false;
room_State.RoomId = id;
bool flag = true;
if (dentityId == 5) //清洁部门 状态 待清洁
{
if (room.Room_StateId == 7)
{
room.Room_StateId = 4;
room_State.StateTxt = "在清洁";
flag = false;
}
else if (room.Room_StateId == 4)
{
room.Room_StateId = 1;
room_State.StateTxt = "可使用";
flag = false;
}
}
if (dentityId == 6) //维修部门 状态 待清洁
{
if (room.Room_StateId == 7 || room.Room_StateId == 1)
{
room.Room_StateId = 5;
room_State.StateTxt = "维修中";
flag = false;
}
else if (room.Room_StateId == 5)
{
room.Room_StateId = 7;
room_State.StateTxt = "待清洁";
flag = false;
}
}
if (flag)
{
return(false);
}
db.Entry(room).State = EntityState.Modified;
db.Room_State.Add(room_State);
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
//throw;
}
return(false);
}
/// <summary>
/// 添加员工
/// </summary>
/// <param name="staff">员工信息对象</param>
/// <returns></returns>
public bool AddStaff(Staff staff)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
db.Staff.Add(staff);
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
// throw;
}
return(false);
}
/// <summary>
/// 添加商品种类
/// </summary>
/// <param name="commodity">商品对象</param>
/// <returns></returns>
public bool AddCommodity(Commodity commodity)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
db.Commodity.Add(commodity);
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
//throw;
}
return(false);
}
/// <summary>
/// 添加通知
/// </summary>
/// <param name="regulations">要添加的所有数据</param>
/// <returns></returns>
public bool AddRegulations(Regulations regulations)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
db.Regulations.Add(regulations);
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
//throw;
}
return(false);
}
/// <summary>
/// 退房
/// </summary>
/// <param name="Id">房间编号</param>
/// <param name="Amount">退还金额</param>
/// <returns></returns>
public bool AddSignOut(int Id, decimal Amount)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
//写入退房表
CheckOut checkOut = new CheckOut();
checkOut.EstablishDate = DateTime.Now;
checkOut.IsDelete = false;
checkOut.OrderId = Id;
checkOut.CheckOutDate = DateTime.Now;
checkOut.refundAmount = Amount;
db.CheckOut.Add(checkOut);
//订单表标记完成
Order order = db.Order.Where(s => s.Id == Id).FirstOrDefault();
order.IsDelete = true;
order.DeleteDate = DateTime.Now;
db.Entry(order).State = EntityState.Modified;
//房间状态设置成待清洁
int? roomID = order.RoomId;
Room room = db.Room.Where(s => s.Id == roomID).FirstOrDefault();
room.Room_StateId = 7; // 7 待清洁
db.Entry(room).State = EntityState.Modified;
Room_State room_State = new Room_State();
room_State.EstablishDate = DateTime.Now;
room_State.IsDelete = false;
room_State.RoomId = roomID;
room_State.StateTxt = "待清洁";
db.Room_State.Add(room_State);
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
//throw;
}
return(false);
}
/// <summary>
/// 修改用户密码
/// </summary>
/// <param name="pwdx">要修改的密码</param>
/// <param name="name">当前用户</param>
/// <returns></returns>
public bool EditUserPwd(string pwdx, string name)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
var data = db.Staff.Where(s => s.Name == name).FirstOrDefault();
data.Password = pwdx;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
//throw;
}
return(false);
}
/// <summary>
/// 减少库存
/// </summary>
/// <param name="id">商品编号</param>
/// <param name="num">减少数量</param>
/// <returns></returns>
public bool ReduceCommodity(int id, int num)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
Commodity c = db.Commodity.Where(s => s.Id == id).FirstOrDefault();
c.Stock = c.Stock - num;
db.Entry(c).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
// throw;
}
return(false);
}
/// <summary>
/// 删除员工
/// </summary>
/// <param name="id">员工编号</param>
/// <returns></returns>
public bool DestroyStaff(int id)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
Staff staff = db.Staff.Where(s => s.Id == id).FirstOrDefault();
staff.IsDelete = true;
staff.DeleteDate = DateTime.Now;
db.Entry(staff).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
//throw;
}
return(false);
}
/// <summary>
/// 删除通知
/// </summary>
/// <param name="id">通知编号</param>
/// <returns></returns>
public bool DestroyRegulations(int id)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
Regulations date = db.Regulations.Where(s => s.Id == id).FirstOrDefault();
date.IsDelete = true;
date.DeleteDate = DateTime.Now;
db.Entry(date).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
//throw;
}
return(false);
}
/// <summary>
/// 修改用户的信息
/// </summary>
/// <param name="nation">民族</param>
/// <param name="email">邮箱</param>
/// <param name="sex">性别</param>
/// <param name="name">当前用户名字</param>
/// <returns></returns>
public bool EditUserIn(string nation, string email, bool sex, string name)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
Staff st = db.Staff.Where(s => s.Name == name).FirstOrDefault();
st.Nation = nation;
st.Email = email;
st.Sex = sex;
db.Entry(st).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
// throw;
}
return(false);
}
/// <summary>
/// 添加房间有商品表
/// </summary>
/// <param name="rc">房间有商品表对象</param>
/// <returns></returns>
public bool IncreaseCommodityCW(Room_Commodity rc)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
db.Room_Commodity.Add(rc);
Commodity c = db.Commodity.Where(s => s.Id == rc.CommodityId).FirstOrDefault();
c.SeparableNum = c.SeparableNum - rc.CommodityNum;
db.Entry(c).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
// throw;
}
return(false);
}
/// <summary>
/// 续住
/// </summary>
/// <param name="id">订单编号</param>
/// <param name="time">续住时间</param>
/// <returns></returns>
public bool AddContinue(int id, DateTime time)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
Order order = db.Order.Where(s => s.Id == id).FirstOrDefault();
order.EstimatedTime = time;
order.LiveDays = (order.EstimatedTime - order.EstablishDate).Days + 1;
order.ActualMoney = GetActualMoneyByRommId(order.RoomId) * (order.LiveDays ?? 0);
db.Entry(order).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
//throw;
}
return(false);
}
/// <summary>
/// 添加进货
/// </summary>
/// <param name="cp">进货信息对象</param>
/// <returns></returns>
public bool AddCommodityP(Commodity_Purchase cp)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
db.Commodity_Purchase.Add(cp);
Commodity commodity = db.Commodity.Where(s => s.Id == cp.CommodityId).FirstOrDefault();
commodity.Stock = commodity.Stock + cp.CommodityNum;
commodity.SeparableNum = commodity.SeparableNum + cp.CommodityNum;
db.Entry(commodity).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
//throw;
}
return(false);
}
/// <summary>
/// 添加房间商品分配
/// </summary>
/// <param name="Id">房间编号</param>
/// <param name="name">商品编号</param>
/// <param name="commodityNum">添加数量</param>
/// <returns></returns>
public bool IncreaseCommodityC(int Id, int name, int commodityNum)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
Room_Commodity rc = db.Room_Commodity.Where(s => s.RoomId == Id && s.CommodityId == name).FirstOrDefault();
rc.CommodityNum = rc.CommodityNum + commodityNum;
db.Entry(rc).State = EntityState.Modified;
Commodity c = db.Commodity.Where(s => s.Id == name).FirstOrDefault();
c.SeparableNum = c.SeparableNum - commodityNum;
db.Entry(c).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
// throw;
}
return(false);
}