public int OccupyRoom(string PRNO, int roomno, string guestname, string gender)
{
var alreaadyvacate = db.NC_TBL_ROOM_Status.Where(i => i.Room_No == roomno && i.Status == "Vacant" && i.Date_To == null).FirstOrDefault();
if (alreaadyvacate != null)
{
alreaadyvacate.Date_To = DateTime.Now;
alreaadyvacate.Modified_by = Session["LogedUserID"].ToString();
alreaadyvacate.Modified_dt = DateTime.Now;
db.NC_TBL_ROOM_Status.Attach(alreaadyvacate);
var vas = db.Entry(alreaadyvacate);
vas.State = EntityState.Modified;
vas.Property(e => e.Date_To).IsModified = true;
vas.Property(e => e.Modified_dt).IsModified = true;
vas.Property(e => e.Modified_by).IsModified = true;
db.SaveChanges();
}
NC_TBL_ROOM_Status Occupy = new NC_TBL_ROOM_Status();
Occupy.PRNO = PRNO;
Occupy.Room_No = roomno;
Occupy.Guest_Name = guestname;
Occupy.Gender = gender;
Occupy.Date_From = DateTime.Now;
Occupy.Created_by = Session["LogedUserID"].ToString();
Occupy.Created_dt = DateTime.Now;
Occupy.Status = "Occupied";
db.NC_TBL_ROOM_Status.Add(Occupy);
int count = db.SaveChanges();
return(count);
}
public int VacateRoom(int roomno, string prno)
{
int count = 0;
var vacatingroom = db.NC_TBL_ROOM_Status.Where(i => i.Room_No == roomno && i.Status == "Occupied" && i.Date_To == null && i.PRNO == prno).FirstOrDefault();
vacatingroom.Date_To = DateTime.Now;
vacatingroom.Modified_by = Session["LogedUserID"].ToString();
vacatingroom.Modified_dt = DateTime.Now;
db.NC_TBL_ROOM_Status.Attach(vacatingroom);
var vas = db.Entry(vacatingroom);
vas.State = EntityState.Modified;
vas.Property(e => e.Date_To).IsModified = true;
vas.Property(e => e.Modified_dt).IsModified = true;
vas.Property(e => e.Modified_by).IsModified = true;
count = db.SaveChanges();
var existing = db.NC_TBL_ROOM_Status.Where(i => i.Room_No == roomno && i.Status == "Occupied" && i.Date_To == null).Count();
if (existing == 0)
{
NC_TBL_ROOM_Status vacate = new NC_TBL_ROOM_Status();
vacate.Room_No = roomno;
vacate.Status = "Vacant";
vacate.Date_From = DateTime.Now;
vacate.Created_by = Session["LogedUserID"].ToString();
vacate.Created_dt = DateTime.Now;
db.NC_TBL_ROOM_Status.Add(vacate);
db.SaveChanges();
}
return(count);
}
public ActionResult Guestcheckin(FormCollection collection)
{
NC_TBL_ROOM_Status status = new NC_TBL_ROOM_Status();
status.Guest_Name = collection["fname"].ToString();
status.PRNO = collection["prno"].ToString();;
status.Room_No = Convert.ToInt32(collection["roomno"].ToString());
status.Gender = collection["gender"].ToString();
status.Status = "Occupied";
status.Date_From = Convert.ToDateTime(collection["Checkindate"]);
status.Created_by = Session["LogedUserID"].ToString();
status.Created_dt = DateTime.Now;
db.NC_TBL_ROOM_Status.Add(status);
db.SaveChanges();
int Room_NoNew = Convert.ToInt32(collection["roomno"].ToString());
var RoomDet = db.NC_TBL_ROOM_Status.Where(i => i.Room_No == Room_NoNew && i.Status == "Vacant" && i.Date_To == null).FirstOrDefault();
if (RoomDet != null)
{
RoomDet.Date_To = DateTime.Now;
RoomDet.Modified_by = Session["LogedUserID"].ToString();
RoomDet.Modified_dt = DateTime.Now;
db.NC_TBL_ROOM_Status.Attach(RoomDet);
var entry2 = db.Entry(RoomDet);
entry2.Property(e => e.Date_To).IsModified = true;
entry2.Property(e => e.Modified_dt).IsModified = true;
entry2.Property(e => e.Modified_by).IsModified = true;
int l2 = db.SaveChanges();
}
return(RedirectToAction("Guestcheckin"));
}
public ActionResult Index(FormCollection coll)
{
int room_no = Convert.ToInt32(coll["roomno"]);
var Room_Status = db.NC_TBL_ROOM_Status.Where(kkl => kkl.Room_No == room_no && kkl.Date_To == null).FirstOrDefault();
Room_Status.Date_To = DateTime.Now;
Room_Status.Modified_by = Session["LogedUserID"].ToString();
Room_Status.Modified_dt = DateTime.Now;
db.NC_TBL_ROOM_Status.Attach(Room_Status);
var entry1 = db.Entry(Room_Status);
entry1.State = EntityState.Modified;
entry1.Property(e => e.Date_To).IsModified = true;
entry1.Property(e => e.Modified_dt).IsModified = true;
entry1.Property(e => e.Modified_by).IsModified = true;
int kjjj = db.SaveChanges();
if (kjjj == 1)
{
NC_TBL_ROOM_Status status = new NC_TBL_ROOM_Status();
status.Room_No = Convert.ToInt32(coll["roomno"]);
status.Status = coll["Status"].ToString();
status.Date_From = DateTime.Now;
Room_Status.Created_by = Session["LogedUserID"].ToString();
Room_Status.Created_dt = DateTime.Now;
db.NC_TBL_ROOM_Status.Add(status);
db.SaveChanges();
return(Content("<script>alert('Status changed Successful'); window.location = './Index';</script>"));
}
else
{
return(Content("<script>alert('Not Successful'); window.location = './Index';</script>"));
}
}
public ActionResult Index(FormCollection collection)
{
var ID = collection["rowCount"];
for (int j = 0; j <= Convert.ToInt32(ID); j++)
{
string prnumber = collection["prno" + j].ToString();
var persondetails = db.NC_TBL_PERSONAL_DETAILS.Where(i => i.PRNO == prnumber).FirstOrDefault();
persondetails.FirstName = collection["fname" + j].ToString();
persondetails.LastName = collection["lname" + j].ToString();
persondetails.MobileNo = collection["mbl" + j].ToString();
persondetails.Age = Convert.ToInt32(collection["age" + j]);
persondetails.Gender = collection["Gender" + j].ToString();
persondetails.EmailId = collection["email" + j].ToString();
persondetails.FlatNo = collection["flat" + j];
persondetails.Street = collection["street" + j].ToString();
persondetails.City = collection["city" + j].ToString();
persondetails.Nationality = collection["NationalityDrop" + j];
persondetails.Country = collection["CountryDrop" + j].ToString();
//persondetails.Room_No = collection["roomno"].ToString();
persondetails.CheckinDate = DateTime.Now;
persondetails.CheckinProcess = "Y";
db.NC_TBL_PERSONAL_DETAILS.Attach(persondetails);
var entry = db.Entry(persondetails);
entry.State = EntityState.Modified;
entry.Property(e => e.CheckinDate).IsModified = true;
entry.Property(e => e.CheckinProcess).IsModified = true;
entry.Property(e => e.FirstName).IsModified = true;
entry.Property(e => e.LastName).IsModified = true;
entry.Property(e => e.MobileNo).IsModified = true;
entry.Property(e => e.Age).IsModified = true;
entry.Property(e => e.Gender).IsModified = true;
entry.Property(e => e.EmailId).IsModified = true;
entry.Property(e => e.FlatNo).IsModified = true;
entry.Property(e => e.Street).IsModified = true;
entry.Property(e => e.City).IsModified = true;
entry.Property(e => e.Nationality).IsModified = true;
entry.Property(e => e.Country).IsModified = true;
//entry.Property(e => e.Room_No).IsModified = true;
int k = db.SaveChanges();
NC_TBL_ROOM_Status status = new NC_TBL_ROOM_Status();
status.PRNO = collection["prno" + j].ToString();;
status.Room_No = Convert.ToInt32(collection["roomno"].ToString());
status.Status = "Occupied";
status.Date_From = DateTime.Now;
status.Created_by = Session["LogedUserID"].ToString();
status.Created_dt = DateTime.Now;
db.NC_TBL_ROOM_Status.Add(status);
db.SaveChanges();
var packagedetails = db.NC_TBL_BOOKED_DATES.Where(i => i.PRNO == prnumber).FirstOrDefault();
packagedetails.PackageName = collection["PackageNameDrop"].ToString();
packagedetails.RoomView = collection["RoomviewDrop"].ToString();
packagedetails.RoomType = collection["roomtypedrop"].ToString();
packagedetails.ArrivalDate = DateTime.ParseExact(collection["arrivaldate"].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
//packagedetails.ArrivalDate = Convert.ToDateTime(collection["arrivaldate"].ToString());
//packagedetails.DepartureDate = Convert.ToDateTime(collection["departuredate"].ToString());
//packagedetails.ArrivalDate = Convert.ToDateTime(collection["alternatearrivaldate"].ToString());
//packagedetails.DepartureDate = Convert.ToDateTime(collection["alternatedepartureldate"].ToString());
if (collection["AccompanyTypeDrop"].ToString() == "-1")
{
packagedetails.Accompany_Type = null;
}
else
{
packagedetails.Accompany_Type = collection["AccompanyTypeDrop"].ToString();
}
db.NC_TBL_BOOKED_DATES.Attach(packagedetails);
var entry1 = db.Entry(packagedetails);
entry1.Property(e => e.PackageName).IsModified = true;
entry1.Property(e => e.RoomView).IsModified = true;
entry1.Property(e => e.RoomType).IsModified = true;
entry1.Property(e => e.ArrivalDate).IsModified = true;
entry1.Property(e => e.Accompany_Type).IsModified = true;
int l = db.SaveChanges();
int Room_NoNew = Convert.ToInt32(collection["roomno"].ToString());
var RoomDet = db.NC_TBL_ROOM_Status.Where(i => i.Room_No == Room_NoNew && i.Status == "Vacant" && i.Date_To == null).FirstOrDefault();
if (RoomDet != null)
{
RoomDet.Date_To = DateTime.Now;
RoomDet.Modified_by = Session["LogedUserID"].ToString();
RoomDet.Modified_dt = DateTime.Now;
db.NC_TBL_ROOM_Status.Attach(RoomDet);
var entry2 = db.Entry(RoomDet);
entry2.Property(e => e.Date_To).IsModified = true;
entry2.Property(e => e.Modified_by).IsModified = true;
entry2.Property(e => e.Date_To).IsModified = true;
int l2 = db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
public ActionResult Index(HttpPostedFileBase billFile, IEnumerable <HttpPostedFileBase> DischargeFile, FormCollection coll)
{
int index = 1;
foreach (var file in DischargeFile)
{
if (file != null)
{
Session["DischargeFile" + index] = ConvertToBytes(file);
}
index++;
}
var ID = coll["rowCount"];
for (int j = 0; j <= Convert.ToInt32(ID); j++)
{
var guest = coll["Guest" + j];
if (guest != null)
{
TBL_CheckOut_File users = new TBL_CheckOut_File();
string PRNO = "";
try
{
PRNO = coll["guestid" + j].ToString();
}
catch
{
PRNO = null;
}
users.PRNO = PRNO;
string bill = "";
try
{
bill = coll["bill"].ToString();
}
catch
{
bill = null;
}
users.Bill = bill;
string Discharge = "";
try
{
Discharge = coll["Discharge"].ToString();
}
catch
{
Discharge = null;
}
users.Discharge = "on";
string CheckOut = "";
try
{
CheckOut = coll["CheckOut"].ToString();
}
catch
{
CheckOut = null;
}
users.CheckOut = CheckOut;
users.Bill_File = ConvertToBytes(billFile);
users.Discharge_Summery = Session["DischargeFile" + j] as byte[];
db.TBL_CheckOut_File.Add(users);
int i = db.SaveChanges();
if (i == 1)
{
string prnumber = coll["guestid" + j].ToString();
int room_no = Convert.ToInt32(coll["roomno" + j]);
var Room_Status = db.NC_TBL_ROOM_Status.Where(kkl => kkl.PRNO == prnumber && kkl.Room_No == room_no && kkl.Status == "Occupied").FirstOrDefault();
Room_Status.Date_To = DateTime.Now;
Room_Status.Modified_by = Session["LogedUserID"].ToString();
Room_Status.Modified_dt = DateTime.Now;
db.NC_TBL_ROOM_Status.Attach(Room_Status);
var entry1 = db.Entry(Room_Status);
entry1.State = EntityState.Modified;
entry1.Property(e => e.Modified_dt).IsModified = true;
entry1.Property(e => e.Modified_by).IsModified = true;
entry1.Property(e => e.Date_To).IsModified = true;
int kjjj = db.SaveChanges();
if (Convert.ToInt32(ID) == j)
{
NC_TBL_ROOM_Status status = new NC_TBL_ROOM_Status();
status.Room_No = Convert.ToInt32(coll["roomno" + j]);
status.Status = "Room Cleaning";
status.Created_by = Session["LogedUserID"].ToString();
status.Created_dt = DateTime.Now;
status.Date_From = DateTime.Now;
db.NC_TBL_ROOM_Status.Add(status);
db.SaveChanges();
return(Content("<script>alert('Check Out Successful'); window.location = './Index';</script>"));
}
}
}
}
return(View());
}
