public IHttpActionResult Put(Cancellation value)
{
try
{
var data = from b in dbContext.Cancellation
where b.BookingId == value.BookingId && b.Status.Equals("New")
select b;
Cancellation old = data.SingleOrDefault();
old.Status = value.Status;
dbContext.SaveChanges();
try
{ if (value.Status == "Approved")
{
var data2 = from b2 in dbContext.Booking
where b2.BookingId == value.BookingId
select b2;
Booking old2 = data2.SingleOrDefault();
old2.Status = "Cancelled";
dbContext.SaveChanges();
return(Ok("Approved"));
}
else
{
return(Ok("Dispproved"));
} }
catch (Exception ex2) {
return(Ok("fail2" + ex2.Message));
}
}
catch (Exception ex)
{
string message = "fail " + ex.Message;
return(Ok(message));
}
}
public IHttpActionResult Put(Users value)
{
using (ezbookdatabaseContext db = new ezbookdatabaseContext())
{
var entity = db.Users.FirstOrDefault(e => e.UsersId == value.UsersId);
entity.Names = value.Names;
entity.Passwords = value.Passwords;
entity.Email = value.Email;
entity.Department = value.Department;
entity.Nationality = value.Nationality;
entity.Profilepic = value.Profilepic;
entity.Code = value.Code;
db.SaveChanges();
}
try
{
string message = "Added";
return(Ok(message));
}
catch (Exception ex)
{
string message = "Add Fail" + ex.Message;
return(Ok(message));
}
}
public IHttpActionResult Post(Room value)
{
if (!dbContext.Room.Any(RoomName => RoomName.Name.Equals(value.Name)))
{
Room temp = new Room();
temp.Name = value.Name;
temp.RoomId = value.RoomId;
temp.Location = value.Location;
temp.Image = value.Image;
try
{
dbContext.Add(temp);
dbContext.SaveChanges();
string message = "Registered";
return(Ok(message));
}
catch (Exception ex)
{
string message = "Register Fail" + ex.Message;
return(Ok(message));
}
}
else
{
string message = "Room name has been used";
return(Ok(message));
}
}
public IHttpActionResult Post(Testing value)
{
if (!dbContext.Testing.Any(User => User.Username.Equals(value.Username)))
{
Testing user = new Testing();
user.Username = value.Username;
user.Salt = Convert.ToBase64String(Common.GetRandomSalt(16));
user.Password = Convert.ToBase64String(Common.SaltHashPassword(
Encoding.ASCII.GetBytes(value.Password),
Convert.FromBase64String(user.Salt)));
try
{
dbContext.Add(user);
dbContext.SaveChanges();
string message = "Registered liao";
return(Ok(message));
}
catch (Exception ex)
{
string message = "Register failed " + ex.Message;
return(Ok(message));
}
}
else
{
string message = "Username has been used";
return(Ok(message));
}
}
public IHttpActionResult Put(Booking value)
{
try
{
var data = from b in dbContext.Booking
where b.BookingId == value.BookingId
select b;
Booking old = data.SingleOrDefault();
old.Status = value.Status;
dbContext.SaveChanges();
return(Ok("hello"));
}
catch (Exception ex)
{
string message = "fail " + ex.Message;
return(Ok(message));
}
}
public IHttpActionResult Post(Users value)
{
var Id = int.Parse(dbContext.Users.Max(z => z.UsersId)) + 1;
if (!dbContext.Users.Any(x => x.Email.Equals(value.Email)))
{
Users Nuser = new Users();
Nuser.UsersId = Id.ToString();
Nuser.Names = value.Names;
Nuser.Passwords = value.Passwords;
Nuser.Email = value.Email;
Nuser.Department = value.Department;
Nuser.StartDate = value.StartDate;
Nuser.Nationality = value.Nationality;
Nuser.Position = value.Position;
Nuser.Profilepic = value.Profilepic;
try
{
dbContext.Add(Nuser);
dbContext.SaveChanges();
string message = "Registered";
var example = new messageclass {
Message = message
};
return(Ok(example));
}
catch (Exception ex)
{
string message = "Submit Failed" + ex.Message;
var example = new messageclass {
Message = message
};
return(Ok(example));
}
}
else
{
string message = "The Email has been used";
var example = new messageclass {
Message = message
};
return(Ok(example));
}
}
public IHttpActionResult DeleteByName([FromUri] string id = null)
{
if (string.IsNullOrWhiteSpace(id))
{
return(BadRequest("empty"));
}
try
{
var data = from user in dbContext.Users
where user.UsersId == id
select user;
Users obj = data.SingleOrDefault();
dbContext.Users.Remove(obj);
dbContext.SaveChanges();
return(Ok("Delete successfully"));
}
catch (Exception Ex)
{
return(Ok(Ex));
}
}
public IHttpActionResult Post(Cancellation value)
{
var Id = (dbContext.Cancellation.Max(z => z.CancellationId)) + 1;
if (!dbContext.Cancellation.Any(cancel => cancel.BookingId.Equals(value.BookingId) && cancel.Status.Equals("New")))
{
Cancellation cancellation = new Cancellation();
cancellation.CancellationId = Id;
cancellation.BookingId = value.BookingId;
cancellation.Reason = value.Reason;
cancellation.Status = "New";
try
{
dbContext.Add(cancellation);
dbContext.SaveChanges();
string message = "Submit Successfully";
var example = new messageclass {
Message = message
};
return(Ok(example));
}
catch (Exception ex)
{
string message = "Submit Failed" + ex.Message;
var example = new messageclass {
Message = message
};
return(Ok(example));
}
}
else
{
string message = "You have made a cancellation for this Booking already, please wait for the approval";
var example = new messageclass {
Message = message
};
return(Ok(example));
}
}
public IHttpActionResult Post(Booking value)
{
if (!dbContext.Booking.Any(ID => ID.BookingId.Equals(value.BookingId)))
{
Booking temp = new Booking();
temp.BookingId = value.BookingId;
temp.UsersId = value.UsersId;
temp.RoomId = value.RoomId;
temp.Name = value.Name;
temp.Title = value.Title;
temp.Location = value.Location;
temp.Date = value.Date;
temp.Time = value.Time;
temp.Status = "New";
temp.StartTime = value.StartTime;
temp.EndTime = value.EndTime;
try
{
dbContext.Add(temp);
dbContext.SaveChanges();
string message = "Added";
return(Ok(message));
}
catch (Exception ex)
{
string message = "Add Fail" + ex.Message;
return(Ok(message));
}
}
else
{
string message = "Booking name has been used";
return(Ok(message));
}
}
