[Link].

cs
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace HotelManagementSystem
{
public partial class HomePage1 : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
DateTime Today = [Link];
[Link] = "Now=" + [Link]();
[Link] = [Link];
}
protected void btnCheck_Click(object sender, EventArgs e)
{
DataTable tempTable = new DataTable();
[Link]("RoomNo");
Boolean IsPickedUpBookedRoomNo = false, Taken = false;
string indate = [Link] + "/" + [Link] + "/" + [Link];
string outdate = [Link] + "/" + [Link] + "/" + [Link];
string Formate = "dd/MM/yyyy";
DateTime GuestDateIn = [Link](indate, Formate,
[Link]);
DateTime GuestDateOut = [Link](outdate, Formate,
[Link]);
int CheckDate = [Link](GuestDateOut, GuestDateIn);
if (CheckDate >= 0)
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from BookedRooms ",
SqlCon);
DataSet ds = new DataSet();
[Link](ds, " BookedRooms");
DataTable dt = [Link][0];

int row = [Link][0].[Link];

if (row != 0)
{
int i = 0;
foreach (DataRow dr in [Link])
{
string CheckInDate = [Link][i][1].ToString();
DateTime TableDateIn = [Link](CheckInDate, Formate,
[Link]);
string CheckOutDate = [Link][i][2].ToString();
DateTime TableDateOut = [Link](CheckOutDate, Formate,
[Link]);

int result1 = [Link](GuestDateIn, TableDateIn);//guest datein

is less then old guest datein
int result2 = [Link](GuestDateOut, TableDateOut);//old guest
outdate is before then new guest checkin
int result3 = [Link](GuestDateIn, TableDateOut);
int result4 = [Link](GuestDateOut, TableDateIn);
if (result1 <= 0 && result2 >= 0)//true when Date1 is greter then
{
DataRow NewDr = [Link]();
string SelectedRoomNo = [Link][i][0].ToString();
NewDr["RoomNo"] = SelectedRoomNo;
[Link](NewDr);
[Link]();
IsPickedUpBookedRoomNo = true;
Taken = true;

}
if (result1 >= 0 && result2 <= 0 && !Taken)
{
DataRow NewDr = [Link]();
NewDr["RoomNo"] = [Link][i][0].ToString();
[Link](NewDr);
[Link]();
IsPickedUpBookedRoomNo = true;
Taken = true;

}
if (result1 > 1 && result3 > 0 && !Taken)
{

DataRow NewDr = [Link]();

NewDr["RoomNo"] = [Link][i][0].ToString();
[Link](NewDr);
[Link]();
IsPickedUpBookedRoomNo = true;
Taken = true;

}
if (result1 > 0 && result4 < 0 && !Taken)
{
DataRow NewDr = [Link]();
NewDr["RoomNo"] = [Link][i][0].ToString();
[Link](NewDr);
[Link]();
IsPickedUpBookedRoomNo = true;
Taken = true;

}
Taken = false;
i = i + 1;
}
}
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from Room ", SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "Room");
DataTable dt1 = [Link][0];
int row1 = [Link][0].[Link];
if (row1 != 0)
{

if (!IsPickedUpBookedRoomNo)
{
Session["AvailableRooms"] = dt1;
}
else
{
DataTable tempdt = new DataTable(); // creating temp table to store
Booked Room no details
[Link]("RoomNo");//adding culumns to temp table
[Link]("Type");
[Link]("Capacity");
[Link]("Rate");
[Link]("Status");

[Link]("Image");
int n = 0, l = 0;
Boolean IsMatchedBoothRoom = false;
foreach (DataRow dr2 in [Link])
{
int k = 0;
foreach (DataRow dr in [Link])
{
string AvailableRoomNo = [Link][l][0].ToString();
string BookedRoomNo = [Link][k][0].ToString();
if (AvailableRoomNo == BookedRoomNo) // finding all booked room
no from room table
{
IsMatchedBoothRoom = true;
}
k = k + 1;
}
if (!IsMatchedBoothRoom)
{
DataRow NewDR = [Link]();
NewDR["RoomNo"] = [Link][n][0].ToString();
NewDR["Type"] = [Link][n][1].ToString();
NewDR["Capacity"] = [Link][n][2].ToString();
NewDR["Rate"] = [Link][n][3].ToString();
NewDR["Status"] = [Link][n][4].ToString();
NewDR["Image"] = [Link][n][5].ToString();
[Link](NewDR);
[Link]();
n = n + 1;
}
IsMatchedBoothRoom = false;
l = l + 1;
}
ViewState["tempdt"] = tempdt;
int TempTableData = [Link];
if (TempTableData != 0)
{
Session["AvailableRooms"] = tempdt;
}
else
{
Session["Message"] = "Room Is Not Available For you Between The
Given Date...!!!";
}
}
Session["CheckInDate"] = indate;
Session["CheckOutDate"] = outdate;
[Link]("~/Account/[Link]");

}
}
else
{
[Link] = "Please Check Selected Date";
}
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace HotelManagementSystem
{
public partial class Feedback : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click1(object sender, EventArgs e)
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Feedback ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Feedback");
DataTable dt = [Link][0];
DataRow dr = [Link]();
dr[0] = [Link];
dr[1] = [Link];
dr[2] = [Link];
dr[3] = [Link];
dr[4] = [Link];
[Link](dr);
SqlCommandBuilder cd = new SqlCommandBuilder(Sqd);

[Link](dt);
[Link] = "Your feedback has been sent...!!!";
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace HotelManagementSystem
{
public partial class Gallary : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace HotelManagementSystem
{
public partial class HomePage : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

using
using
using
using

[Link];
[Link];
[Link];
[Link];

namespace HotelManagementSystem
{
public partial class Rules : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Rules ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Rules");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = ds;
[Link]();
}
}
}
}
}
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace HotelManagementSystem
{
public partial class Rules : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)

{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Rules ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Rules");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = ds;
[Link]();
}
}
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class AdminLogin : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnCheck0_Click(object sender, EventArgs e)
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Admin where
username='" +[Link]+ "' and password='"+[Link]+"'", SqlCon);
DataSet ds = new DataSet();

[Link](ds, "Admin");
DataTable dt = [Link][0];
int Room = [Link];
if (Room != 0)
{
Session["AdminId"] = [Link];
[Link]("../Admin/[Link]");
}
else
{
[Link] = "Please check User-Id and Password";
}
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class CustomerLogin : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if ( Session["UserId"]!=null)
{
Session["GuestName"] = Session["Name"].ToString();
[Link]= Session["UserId"].ToString();
[Link]= Session["Password"].ToString();
}

}
protected void btnCheck0_Click(object sender, EventArgs e)
{
PathStringClass path = new PathStringClass();

string DatabasePath = path.Get_path();

SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from GuestDetails where
GuestId='" + [Link] + "' and Password='" + [Link] + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "GuestDetails");
DataTable dt = [Link][0];
int Room = [Link];
if (Room != 0)
{
if ( Session["SelectedRoomNo"]!= null)
{
Session["GuestName"]= [Link][0][0].ToString();
Session["CheckInDate"] = Session["CheckInDate"].ToString();
Session["CheckOutDate"] = Session["CheckOutDate"].ToString();
Session["SelectedRoomNo"] = Session["SelectedRoomNo"].ToString();
[Link]("../Guest/[Link]");
}
else
{
Session["GuestName"] = [Link][0][0].ToString();
Session["GuestId"] =[Link];
[Link]("../Guest/[Link]");
}
}
else
{
[Link] = "Please check User-Id and Password";
}
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

using [Link];
namespace [Link]
{
public partial class GuestRegistration : [Link]
{
string ImgPath;//Image storing
Boolean value = false;
Boolean IsExistId = false;
protected void Page_Load(object sender, EventArgs e)
{
if (Session["SelectedRoomNo1"] != null)
{
string str = Session["SelectedRoomNo1"].ToString();
}
}
protected void btnregister_Click(object sender, EventArgs e)
{
if ([Link])
{
if ([Link])
{
ImgPath = ImagePath();
IsExistId = check_ID();
if (ImgPath != null && IsExistId)
{
Register_Guest(ImgPath);
Show_Guest_Registered_Iformation();
}
}
else
{
[Link] = "Please Select Image";
}
}
else
{
[Link] = "Uknown Error occured!!!";
}
[Link] = false;
}
private bool check_ID()
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from GuestDetails where
GuestId='" + [Link] + "'", SqlCon);

DataSet ds = new DataSet();

[Link](ds, "GuestDetails");
DataTable dt = [Link][0];
DataRow dr = [Link]();
int Room = 0;
Room = [Link];
if (Room != 0)
{
IsExistId = false;
[Link] = "A user is already registered with this User-Id";
}
else
{
IsExistId = true;
}
return IsExistId;
}
private void Register_Guest(string ImgPath)
{
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from GuestDetails",
SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "GuestDetails");
DataTable dt1 = [Link][0];
DataRow dr1 = [Link]();
dr1[0] = [Link]() + [Link];
dr1[1] = [Link]() + [Link];
dr1[2] = [Link]() + "/" + [Link]() +
"/" + [Link]();
dr1[3] = [Link]();
dr1[4] = [Link];
dr1[5] = [Link];
dr1[6] = [Link];
dr1[7] = [Link]();
dr1[8] = [Link];
dr1[9] = [Link];
dr1[10] = [Link];
dr1[11] = [Link];
dr1[12] = [Link];
dr1[13] = [Link];
dr1[14] = [Link];
dr1[15] = [Link];
dr1[16] = [Link];
dr1[17] = ImgPath;
[Link](dr1);
SqlCommandBuilder cd = new SqlCommandBuilder(Sqd1);
[Link](dt1);
}

private void Show_Guest_Registered_Iformation()

{
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd2 = new SqlDataAdapter("select * from GuestDetails where
GuestId='" + [Link] + "'", SqlCon1);
DataSet ds2 = new DataSet();
[Link](ds2, "GuestDetails");
DataTable dt2 = [Link][0];
int noofrow = [Link];
if (noofrow != 0)
{
[Link] = ds2;
[Link]();
}
else
{
[Link] = "There an error...!!!";
}
}
protected void btncheckExistingid_Click(object sender, EventArgs e)
{
Boolean IsIdExist = false;
IsIdExist = check_ID();
if (IsIdExist)
{
[Link] = "Entered Id is avilable for you";
}
else
{
[Link] = "Entered Id is not available for you";
}
}
private string ImagePath()
{
Boolean FileOK = false;
//Boolean FileSaved = false;
int k = 0;

Session["WorkingImage"] = [Link];
String FileExtension =
[Link](Session["WorkingImage"].ToString()).ToLower();
//renaming File
Random MyRandom = new Random();
string FilenameWithoutExtension =
[Link](Session["WorkingImage"].ToString());
string fileNameIncreament = [Link]([Link](10, 300000));

FilenameWithoutExtension = FilenameWithoutExtension + fileNameIncreament;

Session["ImageFileName"] = FilenameWithoutExtension + FileExtension;
String[] allowedExtensions = { ".png", ".jpeg", ".jpg", ".gif", ".htm" };
for (int i = 0; i < [Link]; i++)
{
k++;
if (FileExtension == allowedExtensions[i])
{
FileOK = true;
break;
}
}
if (FileOK)
{
try
{
string path = ([Link]("../GuestImages")).ToString();
[Link](path + "/" + Session["ImageFileName"].ToString());
}
catch (Exception ex)
{
}
}
string dbfilePath;
string fileName = [Link](Session["ImageFileName"].ToString());
dbfilePath = @"../GuestImages/" + fileName;
if (!FileOK)
{
dbfilePath = null;
}
return dbfilePath;
}
protected void btnLogin_Click1(object sender, EventArgs e)
{
Button btnLogin = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lbluserid = (Label)[Link]("lbluserid");
Label lblpassword = (Label)[Link]("lblpassword");
Label lblName = (Label)[Link]("lblName");
Session["Name"] = [Link];
Session["UserId"] = [Link];
Session["Password"] = [Link];
Session["CheckInDate"] = Session["CheckInDate"].ToString();
Session["CheckOutDate"] = Session["CheckOutDate"].ToString();
Session["SelectedRoomNo"] = Session["SelectedRoomNo"].ToString();
[Link]("~/Account/[Link]");
}
}
}
[Link]

using
using
using
using
using
using
using
using
using
using
using
using
using
using

System;
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];

namespace [Link]
{
public partial class ReceptionistLogin : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnCheck0_Click(object sender, EventArgs e)
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from ReceptionistDetails
where ReceptionistId='" +[Link]+ "' and Password='"+[Link]+"'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "ReceptionistDetails");
DataTable dt = [Link][0];
int Room = [Link];
if (Room != 0)
{
Session["ReceptionistId"] = [Link];
Session["ReceptionistName"] = [Link][0][0].ToString();
[Link]("../Receptionist/[Link]");
}
else
{
[Link] = "Please check User-Id and Password";
}
}
}
}
[Link]
using System;
using [Link];

using
using
using
using
using
using
using
using
using
using
using
using

[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];

namespace [Link]
{
public partial class RoomAvailability : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["CheckInDate"] != null && Session["CheckOutDate"]!=null)
{
Session["CheckInDate"] = Session["CheckInDate"].ToString();
Session["CheckOutDate"] = Session["CheckOutDate"].ToString();
}
if (Session["Message"] != null)
{
[Link] = Session["Message"].ToString();
}
if (!IsPostBack && Session["AvailableRooms"] != null)
{
DataTable dt = (DataTable)Session["AvailableRooms"];
[Link] = dt;
[Link]();
}

}
protected void BtnShow_Click(object sender, EventArgs e)
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Room ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Room");
DataTable dt = [Link][0];
int Room = [Link];
if (Room != 0)
{
[Link] = ds;

[Link]();
}
else
{
[Link] = "Not Available Room";
}
}
protected void btnregister_Click(object sender, EventArgs e)
{
[Link]("../[Link]");
}
protected void btnselect_Click(object sender, EventArgs e)
{
Button btnselect = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lblRoomNo = (Label)[Link]("lblRoomNo");
Session["CheckInDate"] = Session["CheckInDate"].ToString();
Session["CheckOutDate"] = Session["CheckOutDate"].ToString();
Session["SelectedRoomNo"] = [Link];
[Link]("~/Account/[Link]");
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class SelectedRoom : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
//Start Page load
if (!IsPostBack && Session["SelectedRoomNo"]!=null)
{

string str = Session["SelectedRoomNo"].ToString();

string InDate=Session["CheckInDate"].ToString();
string OutDate = Session["CheckOutDate"].ToString();
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Room where
RoomNo='" + str + "' ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Room");
DataTable dt = [Link][0];
int Room = [Link];
if (Room > 0)
{
DataTable TempTable = new DataTable();
[Link]("RoomNo");
[Link]("Type");
[Link]("Capacity");
[Link]("Rate");
[Link]("Status");
[Link]("Image");
[Link]("CheckInDate");
[Link]("CheckOutDate");
foreach (DataRow dr in [Link])
{
DataRow TempDr = [Link]();
TempDr["RoomNo"] = [Link][0][0].ToString();
TempDr["Type"] = [Link][0][1].ToString();
TempDr["Capacity"] = [Link][0][2].ToString();
TempDr["Rate"] = [Link][0][3].ToString();
TempDr["Status"] = [Link][0][4].ToString();
TempDr["Image"] = [Link][0][5].ToString();
TempDr["CheckInDate"] = InDate;
TempDr["CheckOutDate"] = OutDate;
[Link](TempDr);
[Link]();
ViewState["TempTable"] = TempTable;
}
if ([Link] > 0)
{
[Link] = TempTable;
[Link]();
}
}
}
else
{
[Link] = "you have not selected room";
}

}
protected void btnLogin_Click(object sender, EventArgs e)
{
Session["CheckInDate"] = Session["CheckInDate"].ToString();
Session["CheckOutDate"] = Session["CheckOutDate"].ToString();
Session["SelectedRoomNo"] = Session["SelectedRoomNo"].ToString();
[Link]("~/Account/[Link]");
}
protected void btnregister_Click(object sender, EventArgs e)
{
Session["CheckInDate"] = Session["CheckInDate"].ToString();
Session["CheckOutDate"] = Session["CheckOutDate"].ToString();
Session["SelectedRoomNo"] = Session["SelectedRoomNo"].ToString();
[Link]("~/Account/[Link]");
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class Admin : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminId"] != null)
{
[Link]("~/Account/[Link]");
}
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

using
using
using
using
using
using

[Link];
[Link];
[Link];
[Link];
[Link];
[Link];

namespace [Link]
{
public partial class CheckInGustRecords : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminId"] != null)
{
[Link] = Session["AdminId"].ToString();
Session["AdminId"] = Session["AdminId"].ToString();
}
}
protected void BtnRecord_Click1(object sender, EventArgs e)
{
if ([Link])
{
string RecordType = [Link]();
DataTable TempDt = new DataTable();
[Link]("GuestId");
switch (RecordType)
{
case "Daily":
{
string d1 = [Link] + "/" + [Link] + "/" + [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckInDate like '%" + d1 + "%'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, " BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
DataTable CheckDt = [Link][0];
int i = 0, j = 0;
Boolean IsMatched = false;
if (row != 0)
{
foreach (DataRow dr1 in [Link])
{
string PriviousGuestId = [Link][i][4].ToString();
j = 0;

if (i != 0)
{
foreach (DataRow dr in [Link])
{
string CurrentGuestId = [Link][j][4].ToString();
if (PriviousGuestId == CurrentGuestId)
{
if (i == j)
{
break;
}
IsMatched = true;
}
j = j + 1;

}
}
if (!IsMatched)
{
DataRow NewDr = [Link]();
NewDr["GuestId"] = PriviousGuestId;
[Link](NewDr);
[Link]();
ViewState["TempDt"] = TempDt;
}
IsMatched = false;
i = i + 1;
}
int GetRows = [Link];

}
else
{
[Link] = "Record Not Found...!!!";
[Link] = null;
[Link]();
}
}
break;
case "Monthly":
{
string d2 = [Link] + "/" + [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckInDate like '%" + d2 + "'", SqlCon);

DataSet ds = new DataSet();

[Link](ds, "BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
DataTable CheckDt = [Link][0];
int i = 0, j = 0;
Boolean IsMatched = false;
if (row != 0)
{
foreach (DataRow dr1 in [Link])
{
string PriviousGuestId = [Link][i][4].ToString();
j = 0;
if (i != 0)
{
foreach (DataRow dr in [Link])
{
string CurrentGuestId = [Link][j][4].ToString();
if (PriviousGuestId == CurrentGuestId)
{
if (i == j)
{
break;
}
IsMatched = true;
}
j = j + 1;

}
}
if (!IsMatched)
{
DataRow NewDr = [Link]();
NewDr["GuestId"] = PriviousGuestId;
[Link](NewDr);
[Link]();
ViewState["TempDt"] = TempDt;
}
IsMatched = false;
i = i + 1;
}
int GetRows = [Link];
}
else

{
[Link] = "Record Not Found...!!!";
[Link] = null;
[Link]();
}
}
break;
case "Yearly":
{
string d3 = [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckInDate like '%" + d3 + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
DataTable CheckDt = [Link][0];
int i = 0, j = 0;
Boolean DataLoaded = false;
Boolean Execute = false;
Boolean IsMatched = false;
if (row != 0)
{
foreach (DataRow dr in [Link])
{
DataTable MyTable = (DataTable)ViewState["TempDt"];
if (Execute)
{
int LoadedDataRow = [Link];
}
if (DataLoaded)
{
j = 0;
foreach (DataRow dr1 in [Link])
{
string GuestId = [Link][i][4].ToString();
string GuestIdTemp = [Link][j][0].ToString();
if (GuestId == GuestIdTemp)
{
IsMatched = true;
}
j = j + 1;
}
if (!IsMatched)

{
DataRow NewDr = [Link]();
NewDr["GuestId"] = [Link][i][4].ToString();
[Link](NewDr);
[Link]();
ViewState["TempDt"] = TempDt;
Execute = true;

}
}
else
{
DataRow NewDr = [Link]();
NewDr["GuestId"] = [Link][0][4].ToString();
[Link](NewDr);
[Link]();
ViewState["TempDt"] = TempDt;
Execute = true;
}
DataLoaded = true;
i = i + 1;
IsMatched = false;
}
}
else
{
[Link] = "Record Not Found...!!!";
[Link] = null;
[Link]();
}
}
break;
default:
{
}
break;
}
// ViewState["TempDt"] = TempDt;
DataTable ResultTable = new DataTable();
[Link]("Name");
[Link]("DOB");
[Link]("Gender");
[Link]("MobileNo");
[Link]("IdType");
[Link]("IdNo");
[Link]("State");
[Link]("PinNo");

[Link]("GuestId");
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from GuestDetails ",
SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "GuestDetails");
DataTable dt1 = [Link][0];
int row1 = [Link];
DataTable MyResultTable = (DataTable)ViewState["TempDt"];
//int RowData = [Link];
if (row1 != 0 && MyResultTable!=null )
{
int i = 0, j = 0;
foreach (DataRow dr in [Link])
{
i = 0;
foreach (DataRow dr1 in [Link])
{
if ([Link][j][0].ToString() == [Link][i][14].ToString())
{
DataRow NewDR = [Link]();
NewDR["Name"] = [Link][i][0].ToString();
NewDR["DOB"] = [Link][i][2].ToString();
NewDR["Gender"] = [Link][i][3].ToString();
NewDR["MobileNo"] = [Link][i][5].ToString();
NewDR["IdType"] = [Link][i][7].ToString();
NewDR["IdNo"] = [Link][i][8].ToString();
NewDR["State"] = [Link][i][11].ToString();
NewDR["PinNo"] = [Link][i][12].ToString();
NewDR["GuestId"] = [Link][i][14].ToString();
[Link](NewDR);
[Link]();
ViewState["ResultTable"] = ResultTable;
}
i = i + 1;
}
j = j + 1;
}
[Link] = " Total " + [Link]() + " Guest(s)
Records found....!!!";
[Link] = ResultTable;
[Link]();
}
else
{
[Link] = "Guest Records not Found.......!!!!!";

}
}
}
protected void ddlReportType_SelectedIndexChanged(object sender, EventArgs e)
{
string ReportType = [Link]();
switch (ReportType)
{
case "Daily":
{
[Link] = true;
[Link] = true;
[Link] = true;
}
break;
case "Monthly":
{
[Link] = false;
[Link] = true;
[Link] = true;
}
break;
case "Yearly":
{
[Link] = false;
[Link] = false;
[Link] = true;
}
break;
}
}
protected void BntOk_Click(object sender, EventArgs e)
{
[Link] = null;
[Link]();
[Link] = "";
}
protected void CustomValidator1_ServerValidate(object source,
ServerValidateEventArgs args)
{
if ([Link])
{
if ([Link]() == "Day")
{
[Link] = false;

}
else
{
[Link] = true;
}
}
else
{
[Link] = true;
}

}
protected void CustomValidator2_ServerValidate(object source,
ServerValidateEventArgs args)
{
if ([Link])
{
if ([Link]() == "Month")
{
[Link] = false;
}
else
{
[Link] = true;
}
}
else
{
[Link] = true;
}
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace [Link]
{
public partial class CheckOutGuestRecords : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminId"] != null)
{
[Link] = Session["AdminId"].ToString();
Session["AdminId"] = Session["AdminId"].ToString();
}
}
protected void BtnRecord_Click1(object sender, EventArgs e)
{
if ([Link])
{
string RecordType = [Link]();
DataTable TempDt = new DataTable();
[Link]("GuestId");
switch (RecordType)
{
case "Daily":
{
string d1 = [Link] + "/" + [Link] + "/" + [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckOutDate like '%" + d1 + "%'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, " BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
DataTable CheckDt = [Link][0];
int i = 0, j = 0;
Boolean IsMatched = false;
if (row != 0)
{
foreach (DataRow dr1 in [Link])
{
string PriviousGuestId = [Link][i][4].ToString();
j = 0;
if (i != 0)
{
foreach (DataRow dr in [Link])
{
string CurrentGuestId = [Link][j][4].ToString();

if (PriviousGuestId == CurrentGuestId)
{
if (i == j)
{
break;
}
IsMatched = true;
}
j = j + 1;

}
}
if (!IsMatched)
{
DataRow NewDr = [Link]();
NewDr["GuestId"] = PriviousGuestId;
[Link](NewDr);
[Link]();
ViewState["TempDt"] = TempDt;
}
IsMatched = false;
i = i + 1;
}
int GetRows = [Link];

}
else
{
[Link] = "Record Not Found...!!!";
[Link] = null;
[Link]();
}
}
break;
case "Monthly":
{
string d2 = [Link] + "/" + [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckOutDate like '%" + d2 + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
DataTable CheckDt = [Link][0];

int i = 0, j = 0;
Boolean IsMatched = false;
if (row != 0)
{
foreach (DataRow dr1 in [Link])
{
string PriviousGuestId = [Link][i][4].ToString();
j = 0;
if (i != 0)
{
foreach (DataRow dr in [Link])
{
string CurrentGuestId = [Link][j][4].ToString();
if (PriviousGuestId == CurrentGuestId)
{
if (i == j)
{
break;
}
IsMatched = true;
}
j = j + 1;

}
}
if (!IsMatched)
{
DataRow NewDr = [Link]();
NewDr["GuestId"] = PriviousGuestId;
[Link](NewDr);
[Link]();
ViewState["TempDt"] = TempDt;
}
IsMatched = false;
i = i + 1;
}
int GetRows = [Link];
}
else
{
[Link] = "Record Not Found...!!!";
[Link] = null;
[Link]();
}

}
break;
case "Yearly":
{
string d3 = [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckOutDate like '%" + d3 + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
DataTable CheckDt = [Link][0];
int i = 0, j = 0;
Boolean DataLoaded = false;
Boolean Execute = false;
Boolean IsMatched = false;
if (row != 0)
{
foreach (DataRow dr in [Link])
{
DataTable MyTable = (DataTable)ViewState["TempDt"];
if (Execute)
{
int LoadedDataRow = [Link];
}
if (DataLoaded)
{
j = 0;
foreach (DataRow dr1 in [Link])
{
string GuestId = [Link][i][4].ToString();
string GuestIdTemp = [Link][j][0].ToString();
if (GuestId == GuestIdTemp)
{
IsMatched = true;
}
j = j + 1;
}
if (!IsMatched)
{
DataRow NewDr = [Link]();
NewDr["GuestId"] = [Link][i][4].ToString();
[Link](NewDr);
[Link]();
ViewState["TempDt"] = TempDt;

Execute = true;

}
}
else
{
DataRow NewDr = [Link]();
NewDr["GuestId"] = [Link][0][4].ToString();
[Link](NewDr);
[Link]();
ViewState["TempDt"] = TempDt;
Execute = true;
}
DataLoaded = true;
i = i + 1;
IsMatched = false;
}
}
else
{
[Link] = "Record Not Found...!!!";
[Link] = null;
[Link]();
}
}
break;
default:
{
}
break;
}
// ViewState["TempDt"] = TempDt;
DataTable ResultTable = new DataTable();
[Link]("Name");
[Link]("DOB");
[Link]("Gender");
[Link]("MobileNo");
[Link]("IdType");
[Link]("IdNo");
[Link]("State");
[Link]("PinNo");
[Link]("GuestId");
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);

SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from GuestDetails ",

SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "GuestDetails");
DataTable dt1 = [Link][0];
int row1 = [Link];
DataTable MyResultTable = (DataTable)ViewState["TempDt"];
//int RowData = [Link];
if (row1 != 0 && MyResultTable != null)
{
int i = 0, j = 0;
foreach (DataRow dr in [Link])
{
i = 0;
foreach (DataRow dr1 in [Link])
{
if ([Link][j][0].ToString() == [Link][i][14].ToString())
{
DataRow NewDR = [Link]();
NewDR["Name"] = [Link][i][0].ToString();
NewDR["DOB"] = [Link][i][2].ToString();
NewDR["Gender"] = [Link][i][3].ToString();
NewDR["MobileNo"] = [Link][i][5].ToString();
NewDR["IdType"] = [Link][i][7].ToString();
NewDR["IdNo"] = [Link][i][8].ToString();
NewDR["State"] = [Link][i][11].ToString();
NewDR["PinNo"] = [Link][i][12].ToString();
NewDR["GuestId"] = [Link][i][14].ToString();
[Link](NewDR);
[Link]();
ViewState["ResultTable"] = ResultTable;
}
i = i + 1;
}
j = j + 1;
}
[Link] = " Total " + [Link]() + " Guest(s)
Records found....!!!";
[Link] = ResultTable;
[Link]();
}
else
{
[Link] = "Guest Records not Found.......!!!!!";
}
}
}

protected void ddlReportType_SelectedIndexChanged(object sender, EventArgs e)

{
string ReportType = [Link]();
switch (ReportType)
{
case "Daily":
{
[Link] = true;
[Link] = true;
[Link] = true;
}
break;
case "Monthly":
{
[Link] = false;
[Link] = true;
[Link] = true;
}
break;
case "Yearly":
{
[Link] = false;
[Link] = false;
[Link] = true;
}
break;
}
}
protected void BntOk_Click(object sender, EventArgs e)
{
[Link] = null;
[Link]();
[Link] = "";
}
protected void CustomValidator1_ServerValidate(object source,
ServerValidateEventArgs args)
{
if ([Link])
{
if ([Link]() == "Select")
{
[Link] = false;
}
else
{
[Link] = true;
}
}

else
{
[Link] = true;
}

}
protected void CustomValidator2_ServerValidate(object source,
ServerValidateEventArgs args)
{
if ([Link])
{
if ([Link]() == "Select")
{
[Link] = false;
}
else
{
[Link] = true;
}
}
else
{
[Link] = true;
}
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class AdminHome : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminId"] == null)
{
[Link]("../Account/[Link]");
}
}
}

}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class DeleteRoom : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminId"] != null)
{
[Link] = Session["AdminId"].ToString();
Session["AdminId"] = Session["AdminId"].ToString();
}
if (!IsPostBack)
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Room ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Room");
DataTable dt = [Link][0];
int Room = [Link];
if (Room != 0)
{
[Link] = ds;
[Link]();
}
else
{
[Link] = "Not Available Room";
}
}

}
protected void btnselect_Click(object sender, EventArgs e)
{
Button btnselect = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lblRoomNo = (Label)[Link]("lblRoomNo");
string RoomNo = [Link];
Session["RoomNo"] = RoomNo;
[Link]("~/Admin/[Link]");
}
protected void BtnCancel_Click(object sender, EventArgs e)
{
[Link]("~/Admin/[Link]");
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class DeleteSelectedRoom : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminId"] != null)
{
[Link] = Session["AdminId"].ToString();
Session["AdminId"] = Session["AdminId"].ToString();
}
if (!IsPostBack)
{
if (Session["RoomNo"] != null)
{

string RoomNo = Session["RoomNo"].ToString();

PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Room where
RoomNo='" + RoomNo + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Room");
DataTable dt = [Link][0];
int Room = [Link];
if (Room != 0)
{
[Link] = ds;
[Link]();
}
else
{
[Link] = "Room No Could not be selected!!!";
}
}
else
{
[Link] = "First select the room for deletion";
}
}
}
protected void DeleteRoom_Click(object sender, EventArgs e)
{
string SelectedRoomNo = Session["RoomNo"].ToString();
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Room where
RoomNo='" + SelectedRoomNo + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Room");
DataTable dt = [Link][0];
int room = [Link];
if (room != 0)
{
foreach (DataRow dr in [Link])
{
//[Link][0].Rows[0].Delete();
[Link]();
SqlCommandBuilder cb = new SqlCommandBuilder(Sqd);
[Link](dt);
break;

}
[Link] = null;
[Link]();
[Link] = "Room Is Deleted...........!!!!!!!";
[Link] = "Back";
}
else
{
[Link] = "First select a room..........!!!!!!";
}
}
protected void btnCancel_Click(object sender, EventArgs e)
{
if (Session["ComeBack"] == null)
{
if (Session["BackToUpdate"] != null)
{
[Link]("~/Admin/[Link]");
}
else
{
[Link]("~/Admin/[Link]");
}
}
else
{
[Link]("~/Admin/[Link]");
}
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]

{
public partial class DeleteSelectedStaff : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminId"] != null)
{
[Link] = Session["AdminId"].ToString();
Session["AdminId"] = Session["AdminId"].ToString();
}
if (Session[" Receptionist"] != null)
{
string Receptionist = Session[" Receptionist"].ToString();
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from ReceptionistDetails
where ReceptionistId='" + Receptionist + "' ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "ReceptionistDetails");
DataTable dt = [Link][0];
int ReceptionistRow = [Link];
if (ReceptionistRow != 0)
{
[Link] = ds;
[Link]();
}
else
{
[Link] = "Either Staff Is Deleted or Staff not Available ";
}
}
else
{
[Link] = "First Select Staff";
}

}
protected void DeleteStaff_Click(object sender, EventArgs e)
{
string Receptionist = Session[" Receptionist"].ToString();
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from ReceptionistDetails
where ReceptionistId='" + Receptionist + "'", SqlCon);

DataSet ds = new DataSet();

[Link](ds, "ReceptionistDetails");
DataTable dt = [Link][0];
int ReceptionistDetailsRow = [Link];
if (ReceptionistDetailsRow != 0)
{
foreach (DataRow dr in [Link])
{
[Link]();
SqlCommandBuilder cb = new SqlCommandBuilder(Sqd);
[Link](dt);
break;
}
[Link] = null;
[Link]();
[Link] = "Receptionist Is Deleted.........!!!!!!";
[Link] = "Back";
}
else
{
[Link] = "Select a Receptionist........!!!!!!";
}
}
protected void btnCancel_Click(object sender, EventArgs e)
{
[Link]("~/Admin/[Link]");
}
}
}
[Link]
<%@ Page Title="" Language="C#" MasterPageFile="~/Admin/[Link]"
AutoEventWireup="true"
CodeBehind="[Link]"
Inherits="[Link]" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
<style type="text/css">
.style1
{
width: 180px;
font-size: 16px;
color: #1c344b;
bgcolor: LightSteelBlue;
height: 21px;
}
.style4
{
width: 506px;
}

.style5
{
width: 616px;
}
.style17
{
width: 225px;
height: 21px;
}
.style18
{
height: 21px;
width: 337px;
}
.style19
{
width: 177px;
}
.style68
{
width: 311px;
font-size: 16px;
color: #1c344b;
bgcolor: LightSteelBlue;
height: 36px;
}
.style90
{
width: 158px;
height: 35px;
}
.style91
{
height: 35px;
}
.style95
{
width: 90px;
font-size: 16px;
color: #1c344b;
bgcolor: LightSteelBlue;
height: 34px;
}
.style96
{
width: 90px;
font-size: 16px;
color: #1c344b;
bgcolor: LightSteelBlue;
height: 35px;
}
.style97

{
width: 90px;
font-size: 16px;
color: #1c344b;
bgcolor: LightSteelBlue;
}
.style100
{
width: 146px;
height: 34px;
}
.style101
{
width: 146px;
height: 35px;
}
.style102
{
width: 142px;
}
.style103
{
width: 142px;
font-size: 16px;
color: #1c344b;
bgcolor: LightSteelBlue;
}
.style104
{
width: 311px;
font-size: 16px;
color: #1c344b;
bgcolor: LightSteelBlue;
height: 76px;
}
.style88
{
width: 628px;
border-top: 1px solid black;
border-bottom: 1px solid black;
}
.style105
{
width: 134px;
height: 36px;
font-size: 16px;
color: #dde4ec;
background-color: #336699;
text-align: center;
}

.style106
{
width: 85px;
}
</style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1"
runat="server">
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<table style="width: 1160px">
<tr>
<td style="width: 197px; height: 39px">
&nbsp;
</td>
<td style="width: 311px; color: #1c344b; font-size: 16px; bgcolor:
LightSteelBlue;
height: 39px">
<asp:Label ID="lblShowingName" Font-Size="15px" ForeColor="Green"
runat="server"></asp:Label>...!!!
</td>
</tr>
</table>
<h1 style="background-color: #336699; color: #dde4ec">
Deleting of Existing Receptionist</h1>
<table style="height: auto; margin: 20px 0px 35px 0px; width: 1090px;">
<tr>
<td class="style19">
<br />
</td>
<td class="style4">
<table style="width: 711px">
<tr>
<td class="style5">
<table style="height: 105px; width: 716px">
<tr>
<td colspan="3" class="PanelHeader">
Get Receptionist Information To be Deleted
</td>
</tr>
<tr>
<td class="style1">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs
p;&nbsp;&nbsp;
Position
</td>
<td class="style17">
<asp:DropDownList ID="DDlPost" runat="server"
BackColor="#F0F0F0" ForeColor="#003366"
Height="28px" Width="122px">

<asp:ListItem Value="-1">Select
Position</asp:ListItem>
<asp:ListItem>Receptionist</asp:ListItem>
<asp:ListItem>Waiter</asp:ListItem>
<asp:ListItem>Cooker</asp:ListItem>
<asp:ListItem>Cashier</asp:ListItem>
<asp:ListItem>Cleaner</asp:ListItem>
<asp:ListItem>IT Opereator</asp:ListItem>
</asp:DropDownList>
&nbsp;<asp:Label ID="LblMsg" runat="server" FontSize="14px" ForeColor="Red" Height="20px"
Width="74px"></asp:Label>
</td>
<td class="style18">
<asp:Button ID="btnShow" runat="server" Text="Show"
BackColor="#1C344B" ForeColor="White"
Height="36px" Width="93px" BorderColor="#5586B7"
BorderStyle="Solid" BorderWidth="3px"
ToolTip="Show All Receptionist as Selection Of their
Post" Style="margin-left: 28px"
OnClick="btnShow_Click" />
<asp:Button ID="btnShowAll" runat="server" Text="Show
All" BackColor="#1C344B" ForeColor="White"
Height="35px" Width="93px" BorderColor="#5586B7"
BorderStyle="Solid" BorderWidth="3px"
ToolTip="Show All Receptionist" Style="margin-left:
59px; margin-top: 0px; margin-bottom: 0px;"
OnClick="btnShowAll_Click" />
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="style5">
<table style="height: 63px; width: 717px; margin-top: 2px;
border: 4px solid #336699">
<tr>
<td colspan="3" class="PanelHeader">
Updated Information
</td>
</tr>
<tr>
<td colspan="3">
<table style="margin-left: 29px">
<tr>
<td>
<asp:Label ID="lblmessage" runat="server"
Height="24px" Width="638px" Font-Size="16px"
ForeColor="Red"></asp:Label>
<asp:GridView ID="GrdGuestDetails"
AutoGenerateColumns="False" runat="server" Width="640px"

BorderWidth="2px" BorderColor="Black"
Style="margin-top: 0px">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<table style="height: 327px; width:
638px">
<tr>
<td colspan="3" class="style105">
<table style="margin-left: 254px;
width: auto;">
<tr>
<td class="style106">
Guest-Id:--</td>
<td style="width: auto">
<asp:Label ID="id"
runat="server" Font-Bold="True" Font-Size="14px" ForeColor="White"
Text='<%#
Bind("ReceptionistId") %>'></asp:Label>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="style57">
<table style="height: 290px;
width: 234px">
<tr>
<td class="style95">
Name
</td>
<td class="style100">
<asp:Label ID="lblName"
runat="server" Font-Bold="True" Font-Size="14px" ForeColor="Black"
Text='<%#
Bind("Name") %>'></asp:Label>
</td>
</tr>
<tr>
<td class="style95">
F-Name
</td>
<td class="style100">
<asp:Label
ID="lblFname" runat="server" Font-Bold="True" Font-Size="14px" ForeColor="Black"
Text='<%#
Bind("FatherName") %>'></asp:Label>
</td>
</tr>
<tr>

<td class="style95">
D.O.B.
</td>
<td class="style100">
<asp:Label ID="lbldob"
runat="server" Font-Bold="True" Font-Size="14px" ForeColor="Black"
Text='<%#
Bind("DOB") %>'></asp:Label>
</td>
</tr>
<tr>
<td class="style95">
Sex
</td>
<td class="style100">
<asp:Label
ID="lblgender" runat="server" Font-Bold="True" Font-Size="14px" ForeColor="Black"
Text='<%#
Bind("Gender") %>'></asp:Label>
</td>
</tr>
<tr>
<td class="style95">
Id-Type
</td>
<td class="style100">
<asp:Label
ID="lblidtypes" runat="server" Font-Bold="True" Font-Size="14px" ForeColor="Black"
Text='<%#
Bind("IdType") %>'></asp:Label>
</td>
</tr>
<tr>
<td class="style96">
Id-No
</td>
<td class="style101">
<asp:Label ID="lblidno"
runat="server" Font-Bold="True" Font-Size="14px" ForeColor="Black"
Text='<%#
Bind("IdNo") %>'></asp:Label>
</td>
</tr>
<tr>
<td class="style96">
City
</td>
<td class="style101">
<asp:Label ID="lblcity"
runat="server" Font-Bold="True" Font-Size="14px" ForeColor="Black"
Text='<%# Bind("City")
%>'></asp:Label>

</td>
</tr>
<tr>
<td class="style96">
State
</td>
<td class="style101">
<asp:Label ID="lblstate"
runat="server" Font-Bold="True" Font-Size="14px" ForeColor="Black"
Text='<%#
Bind("State") %>'></asp:Label>
</td>
</tr>
</table>
</td>
<td class="style54">
<table style="height: 290px;
width: 230px;">
<tr>
<td class="style97">
Pin Code
</td>
<td class="style102">
<asp:Label ID="lblPinNo"
runat="server" Font-Bold="True" Font-Size="14px" ForeColor="Black"
Text='<%#
Bind("PinNo") %>'></asp:Label>
</td>
</tr>
<tr>
<td class="style97">
Mobile No
</td>
<td class="style102">
<asp:Label
ID="lblMobileNo" runat="server" Font-Bold="True" Font-Size="14px" ForeColor="Black"
Text='<%#
Bind("MobileNo") %>'></asp:Label>
</td>
</tr>
<tr>
<td class="style97">
Country
</td>
<td class="style102">
<asp:Label
ID="lblcountry" runat="server" Font-Bold="True" Font-Size="14px" ForeColor="Black"
Text='<%#
Bind("Country") %>'></asp:Label>
</td>
</tr>
<tr>

<td class="style97">
D.O.J.
</td>
<td class="style103">
<asp:Label ID="llbDOJ"
runat="server" Font-Bold="True" Font-Size="14px" ForeColor="Black"
Text='<%# Bind("DOJ")
%>'></asp:Label>
</td>
</tr>
<tr>
<td class="style97">
User-Id
</td>
<td class="style103">
<asp:Label ID="lbluserid"
runat="server" Font-Bold="True" Font-Size="14px" ForeColor="Black"
Text='<%#
Bind("ReceptionistId") %>'></asp:Label>
</td>
</tr>
<tr>
<td class="style97">
Password
</td>
<td class="style103">
<asp:Label
ID="lblpassword" runat="server" Font-Bold="True" Font-Size="14px" ForeColor="Black"
Text='<%#
Bind("Password") %>'></asp:Label>
</td>
</tr>
<tr>
<td class="style97">
Position
</td>
<td class="style103">
<asp:Label ID="lblPost"
runat="server" Font-Bold="True" Font-Size="14px" ForeColor="Black"
Text='<%# Bind("Post")
%>'></asp:Label>
</td>
</tr>
<tr>
<td class="style97">
&nbsp;Salary
</td>
<td class="style103">
<asp:Label ID="lblSalary"
runat="server" Font-Bold="True" Font-Size="14px" ForeColor="Black"
Text='<%#
Bind("Salary") %>'></asp:Label>

</td>
</tr>
</table>
</td>
<td>
<table style="width: 148px">
<tr>
<td class="style104">
</td>
</tr>
<tr>
<td class="style68">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Photo
</td>
</tr>
<tr>
<td>
<asp:Image ID="Image2"
runat="server" Height="165px" ImageUrl='<%#Eval("Image") %>'
Width="141px" />
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="3"
class="FieldName">
<table class="style88">
<tr>
<td class="style90">
Email-Id
</td>
<td class="style91">
<asp:Label ID="lblemail"
runat="server" Font-Bold="True" Font-Size="14px" ForeColor="Black"
Text='<%#
Bind("EmailId") %>'></asp:Label>
</td>
</tr>
<tr>
<td class="style90">
Identification Mark
</td>
<td class="style91">
<asp:Label
ID="lblIdmarks" runat="server" Font-Bold="True" Font-Size="14px" ForeColor="Black"
Text='<%#
Bind("IdMark") %>'></asp:Label>
</td>
</tr>

<tr>
<td class="style90">
Address
</td>
<td class="style91">
<asp:Label
ID="LblAddress" runat="server" Font-Bold="True" Font-Size="14px" ForeColor="Black"
Text='<%#
Bind("Address") %>'></asp:Label>
</td>
</tr>
</table>
</td>
<tr>
<td colspan="3">
<table style="width: 100%">
<tr>
<td>
<asp:Button
ID="BtnSelect" runat="server" BackColor="#1C344B" BorderColor="#5586B7"
BorderStyle="Solid"
BorderWidth="3px" ForeColor="White" Height="37px" OnClick="BtnSelect_Click"
Style="margin-left:
288px; margin-top: 12px; margin-bottom: 10px;" Text="Select"
ToolTip="Select "
Width="93px" />
</td>
</tr>
</table>
</td>
</tr>
</table>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</ContentTemplate>
</asp:UpdatePanel>
</asp:Content>
[Link]

using
using
using
using
using
using
using
using
using
using
using
using
using
using
using

System;
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];

namespace [Link]
{
public partial class GuestReport : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminId"] != null)
{
[Link] = Session["AdminId"].ToString();
Session["AdminId"] = Session["AdminId"].ToString();
}

}
protected void BtnRecord_Click1(object sender, EventArgs e)
{
if([Link] )
{
string GuestType = [Link]();
string RepotrType = [Link]();
if (GuestType == "Check-In-Date")
{
switch (RepotrType)
{
case "Daily":
{
string d1 = [Link] + "/" + [Link] + "/" + [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckInDate like '%" + d1 + "%'", SqlCon);

DataSet ds = new DataSet();

[Link](ds, " BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row >= 0)
{
[Link] = [Link]() + "---Report(s) Found...!!!";
[Link] = ds;
[Link]();
}
else
{
[Link] = "Record Not Found...!!!";
}
}
break;
case "Monthly":
{
string d2 = [Link] + "/" + [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckInDate like '%" + d2 + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, " BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row >= 0)
{
[Link] = [Link]() + "---Report(s) Found...!!!";
[Link] = ds;
[Link]();
}
else
{
[Link] = "Record Not Found...!!!";
}
}
break;
case "Yearly":
{
string d3 = [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckInDate like '%" + d3 + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, " BookedRooms");
DataTable dt = [Link][0];

int row = [Link];

if (row >= 0)
{
[Link] = [Link]() + "---Report(s) Found...!!!";
[Link] = ds;
[Link]();
}
else
{
[Link] = "Record Not Found...!!!";
}
}
break;
default:
{
}
break;
}
}
else
{
switch (RepotrType)
{
case "Daily":
{
string d4 = [Link] + "/" + [Link] + "/" + [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckOutDate like '%" + d4 + "%'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, " BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row >= 0)
{
[Link] = [Link]() + "---Report(s) Found...!!!";
[Link] = ds;
[Link]();
}
else
{
[Link] = "";
[Link] = "Record Not Found...!!!";
}
}
break;
case "Monthly":

{
string d5 = [Link] + "/" + [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckOutDate like '%" + d5 + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, " BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row >= 0)
{
[Link] = [Link]() + "---Report(s) Found...!!!";
[Link] = ds;
[Link]();
}
else
{
[Link] = "Record Not Found...!!!";
}
}
break;
case "Yearly":
{
string d6 = [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckOutDate like '%" + d6 + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, " BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row >= 0)
{
[Link] = [Link]() + "---Report(s) Found...!!!";
[Link] = ds;
[Link]();
}
else
{
[Link] = "Record Not Found...!!!";
}
}
break;
default:
{
}

break;
}
}
}
}
protected void BtnShowPaymentDetails_Click(object sender, EventArgs e)
{
Button BtnShowPaymentDetails = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lblBookingId = (Label)[Link]("lblBookingId");
Label LblCheckInDate = (Label)[Link]("LblCheckInDate");
Label LblCheckOutDate = (Label)[Link]("LblCheckOutDate");
string CheckIn = [Link];
string CheckOut = [Link];
string BookingId = [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from BookedRooms where
GuestId='" + BookingId + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, " BookedRooms");
DataTable dt = [Link][0];
int rows = [Link];
if (rows > 0)
{
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from PaymentDetails
where GuestId='" + BookingId + "'", SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, " PaymentDetails");
DataTable dt1 = [Link][0];
int rows1 = [Link];
if (rows1 > 0)
{
PathStringClass path2 = new PathStringClass();
string DatabasePath2 = path2.Get_path();
SqlConnection SqlCon2 = new SqlConnection(DatabasePath2);
SqlDataAdapter Sqd2 = new SqlDataAdapter("select * from BookedRooms
where CheckInDate='" + CheckIn + "' and CheckOutDate='" + CheckOut + "'",
SqlCon2);
DataSet ds2 = new DataSet();
[Link](ds2, " BookedRooms");
DataTable dt2 = [Link][0];
int row2 = [Link];
if (row2 > 0)
{

[Link] = ds2;
[Link]();
}
[Link] = "";
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = ds1;
[Link]();
}
else
{
[Link] = "Payment Report Not Found...!!!";
}

}
else
{
PathStringClass path3 = new PathStringClass();
string DatabasePath3 = path3.Get_path();
SqlConnection SqlCon3 = new SqlConnection(DatabasePath3);
SqlDataAdapter Sqd3 = new SqlDataAdapter("select * from
PaymentsFromReceptionist where BookingId='" + BookingId + "'", SqlCon3);
DataSet ds3 = new DataSet();
[Link](ds3, " PaymentsFromReceptionist");
DataTable dt3 = [Link][0];
int rows3 = [Link];
if (rows3 > 0)
{
PathStringClass path2 = new PathStringClass();
string DatabasePath2 = path2.Get_path();
SqlConnection SqlCon2 = new SqlConnection(DatabasePath2);
SqlDataAdapter Sqd2 = new SqlDataAdapter("select * from BookedRooms
where CheckInDate='" + CheckIn + "' and CheckOutDate='" + CheckOut + "'",
SqlCon2);
DataSet ds2 = new DataSet();
[Link](ds2, " BookedRooms");
DataTable dt2 = [Link][0];
int row2 = [Link];
if (row2 > 0)
{
[Link] = ds2;
[Link]();
}
[Link] = "";
[Link] = null;
[Link]();
[Link] = null;
[Link]();

[Link] = ds3;
[Link]();
}
else
{
[Link] = "Payment Report Not Found...!!!";
}
}

}
protected void btnShowGuestDetails_Click(object sender, EventArgs e)
{
Button btnShow = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label LblGuestId = (Label)[Link]("LblGuestId");
Label LblCheckInDate = (Label)[Link]("LblCheckInDate");
Label LblCheckOutDate = (Label)[Link]("LblCheckOutDate");
string CheckIn = [Link];
string CheckOut = [Link];
string GuestId = [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from GuestDetails where
GuestId='" + GuestId + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, " GuestDetails");
DataTable dt = [Link][0];
int rows = [Link];
if (rows != 0)
{
PathStringClass path2 = new PathStringClass();
string DatabasePath2 = path2.Get_path();
SqlConnection SqlCon2 = new SqlConnection(DatabasePath2);
SqlDataAdapter Sqd2 = new SqlDataAdapter("select * from BookedRooms
where CheckInDate='" + CheckIn + "' and CheckOutDate='" + CheckOut + "'",
SqlCon2);
DataSet ds2 = new DataSet();
[Link](ds2, " BookedRooms");
DataTable dt2 = [Link][0];
int row2 = [Link];
if (row2 > 0)
{
[Link] = ds2;
[Link]();
}

[Link] = "";
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = ds;
[Link]();
}
else
{
[Link] = "Record not found";
}
}
protected void btnClosePaymentDetailsFromGuest_Click(object sender, EventArgs e)
{
[Link] = "";
[Link] = null;
[Link]();
}
protected void btnClosePaymentDetailsFromReceptionist_Click(object sender,
EventArgs e)
{
[Link] = "";
[Link] = null;
[Link]();
}
protected void CloseAllReports_Click(object sender, EventArgs e)
{
[Link] = "";
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
}
protected void CloseGuestDetails_Click(object sender, EventArgs e)
{
[Link] = "";
[Link] = null;
[Link]();
}
protected void ddlReportType_SelectedIndexChanged(object sender, EventArgs e)

{
string ReportType = [Link]();
switch (ReportType)
{
case "Daily":
{
[Link] = true;
[Link] = true;
[Link] = true;
}
break;
case "Monthly":
{
[Link] = false;
[Link] = true;
[Link] = true;
}
break;
case "Yearly":
{
[Link] = false;
[Link] = false;
[Link] = true;
}
break;
}
}
protected void CustomValidator1_ServerValidate(object source,
ServerValidateEventArgs args)
{
if ([Link])
{
if ([Link]() == "Day")
{
[Link] = false;
}
else
{
[Link] = true;
}
}
else
{
[Link] = true;
}

protected void CustomValidator2_ServerValidate(object source,

ServerValidateEventArgs args)
{
if ([Link])
{
if ([Link]() == "Month")
{
[Link] = false;
}
else
{
[Link] = true;
}
}
else
{
[Link] = true;
}
}
protected void CustomValidator3_ServerValidate(object source,
ServerValidateEventArgs args)
{
if ([Link]() == "Select")
{
[Link] = false;
}
else
{
[Link] = true;
}
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class LogOut : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
[Link]();
[Link]();

[Link]("../Account/[Link]");
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class PaymentReport : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminId"] != null)
{
[Link] = Session["AdminId"].ToString();
Session["AdminId"] = Session["AdminId"].ToString();
}
}
protected void BtnRecord_Click1(object sender, EventArgs e)
{
if([Link] )
{
Int64 TotalAmount =0;
Boolean executeCont = false;
string ReportType = [Link]();
DataTable ReportTable = new DataTable();
[Link]("BookingId");
[Link]("GuestId");
[Link]("Name");
[Link]("RoomNo");
[Link]("CheckInDate");
[Link]("CheckOutDate");
[Link]("Amount");

switch (ReportType)

{
case "Daily":
{
string Report =ddldd .Text+ddlmm .Text+ [Link];
//Payment details from Guest
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from PaymentDetails
where DateOfPayment like '%" + Report + "%'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "PaymentDetails");
DataTable dt = [Link][0];
int rows = [Link];
int i = 0;
if (rows != 0)
{
foreach (DataRow dr in [Link]["PaymentDetails"].Rows)
{
DataRow NewDr = [Link]();
NewDr["BookingId"] = [Link][i][11].ToString();
NewDr["GuestId"] = [Link][i][0].ToString();
NewDr["Name"] = [Link][i][1].ToString();
NewDr["RoomNo"] = [Link][i][2].ToString();
NewDr["CheckInDate"] = [Link][i][3].ToString();
NewDr["CheckOutDate"] = [Link][i][4].ToString();
NewDr["Amount"] = [Link][i][5].ToString();
string amt = [Link][i][5].ToString();
TotalAmount = TotalAmount + [Link](amt);
[Link](NewDr);
[Link]();
ViewState["ReportTable"] = ReportTable;
executeCont = true;
i = i + 1;
}
}
//Pyment Details from Receptionist
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from
PaymentsFromReceptionist where DateOfPayment like '%" + Report + "'", SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "PaymentsFromReceptionist");
DataTable dt1 = [Link][0];
int rows1 = [Link];
if (rows1 != 0)
i = 0;
{

foreach (DataRow dr1 in

[Link]["PaymentsFromReceptionist"].Rows)
{
DataRow NewDr = [Link]();
NewDr["BookingId"] = [Link][i][11].ToString();
NewDr["GuestId"] = [Link][i][0].ToString();
NewDr["Name"] = [Link][i][1].ToString();
NewDr["RoomNo"] = [Link][i][2].ToString();
NewDr["CheckInDate"] = [Link][i][3].ToString();
NewDr["CheckOutDate"] = [Link][i][4].ToString();
NewDr["Amount"] = [Link][i][5].ToString();
string amt = [Link][i][5].ToString();
TotalAmount = TotalAmount + [Link](amt);
[Link](NewDr);
[Link]();
ViewState["ReportTable"] = ReportTable;
executeCont = true;
i = i + 1;
}
}
DataTable ResultTable = (DataTable)ViewState["ReportTable"];
int NoOfRows;
if (executeCont)
{
NoOfRows = [Link];
[Link] = ResultTable;
[Link]();
[Link] = [Link]();
[Link] = "Total Amount Is =";
}
else
{
[Link] = null;
[Link]();
[Link] = "Amount Report Not Found In This year...!!!";
[Link] = "";
}
}
break;
case "Monthly":
{
string Report = [Link] + [Link]();
//Payment details from Guest
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from PaymentDetails
where DateOfPayment like '%" + Report + "'", SqlCon);

DataSet ds = new DataSet();

[Link](ds, "PaymentDetails");
DataTable dt = [Link][0];
int rows = [Link];
int i = 0;
if (rows != 0)
{
foreach (DataRow dr in [Link]["PaymentDetails"].Rows)
{
DataRow NewDr = [Link]();
NewDr["BookingId"] = [Link][i][11].ToString();
NewDr["GuestId"] = [Link][i][0].ToString();
NewDr["Name"] = [Link][i][1].ToString();
NewDr["RoomNo"] = [Link][i][2].ToString();
NewDr["CheckInDate"] = [Link][i][3].ToString();
NewDr["CheckOutDate"] = [Link][i][4].ToString();
NewDr["Amount"] = [Link][i][5].ToString();
string amt = [Link][i][5].ToString();
TotalAmount = TotalAmount + [Link](amt);
[Link](NewDr);
[Link]();
ViewState["ReportTable"] = ReportTable;
executeCont = true;
i = i + 1;
}
}
//Pyment Details from Receptionist
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from
PaymentsFromReceptionist where DateOfPayment like '%" + Report + "'", SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "PaymentsFromReceptionist");
DataTable dt1 = [Link][0];
int rows1 = [Link];
if (rows1 != 0)
i = 0;
{
foreach (DataRow dr1 in
[Link]["PaymentsFromReceptionist"].Rows)
{
DataRow NewDr = [Link]();
NewDr["BookingId"] = [Link][i][11].ToString();
NewDr["GuestId"] = [Link][i][0].ToString();
NewDr["Name"] = [Link][i][1].ToString();
NewDr["RoomNo"] = [Link][i][2].ToString();
NewDr["CheckInDate"] = [Link][i][3].ToString();
NewDr["CheckOutDate"] = [Link][i][4].ToString();
NewDr["Amount"] = [Link][i][5].ToString();

string amt = [Link][i][5].ToString();

TotalAmount = TotalAmount + [Link](amt);
[Link](NewDr);
[Link]();
ViewState["ReportTable"] = ReportTable;
executeCont = true;
i = i + 1;
}
}
DataTable ResultTable = (DataTable)ViewState["ReportTable"];
int NoOfRows;
if (executeCont)
{
NoOfRows = [Link];
[Link] = ResultTable;
[Link]();
[Link] = [Link]();
[Link] = "Total Amount Is =";
}
else
{
[Link] = null;
[Link]();
[Link] = "Amount Report Not Found In This year...!!!";
[Link] = "";
}
}
break;
case "Yearly":
{
string Report = [Link]();
//Payment details from Guest
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from PaymentDetails
where DateOfPayment like '%" + Report + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "PaymentDetails");
DataTable dt = [Link][0];
int rows = [Link];
int i=0;
if(rows!=0)
{
foreach (DataRow dr in [Link]["PaymentDetails"].Rows)
{
DataRow NewDr = [Link]();
NewDr["BookingId"] = [Link][i][11].ToString();

NewDr ["GuestId"]=[Link] [i][0].ToString ();

NewDr ["Name"]=[Link] [i][1].ToString ();
NewDr ["RoomNo"]=[Link][i][2].ToString ();
NewDr["CheckInDate"]=[Link][i][3].ToString ();
NewDr ["CheckOutDate"]=[Link][i][4].ToString ();
NewDr ["Amount"]=[Link] [i][5].ToString ();
string amt = [Link][i][5].ToString();
TotalAmount = TotalAmount + [Link](amt);
[Link] .Add (NewDr );
ReportTable .AcceptChanges ();
ViewState["ReportTable"]=ReportTable ;
executeCont = true;
i=i+1;
}
}
//Pyment Details from Receptionist
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from
PaymentsFromReceptionist where DateOfPayment like '%" + Report + "'", SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "PaymentsFromReceptionist");
DataTable dt1 = [Link][0];
int rows1 = [Link];
if (rows1 != 0)
i = 0;
{
foreach (DataRow dr1 in
[Link]["PaymentsFromReceptionist"].Rows)
{
DataRow NewDr = [Link]();
NewDr["BookingId"] = [Link][i][11].ToString();
NewDr["GuestId"] = [Link][i][0].ToString();
NewDr["Name"] = [Link][i][1].ToString();
NewDr["RoomNo"] = [Link][i][2].ToString();
NewDr["CheckInDate"] = [Link][i][3].ToString();
NewDr["CheckOutDate"] = [Link][i][4].ToString();
NewDr["Amount"] = [Link][i][5].ToString();
string amt = [Link][i][5].ToString();
TotalAmount = TotalAmount + [Link](amt);
[Link](NewDr);
[Link]();
ViewState["ReportTable"] = ReportTable;
executeCont = true;
i = i + 1;
}
}
DataTable ResultTable = (DataTable)ViewState["ReportTable"];
int NoOfRows;

if (executeCont)
{
NoOfRows = [Link];
[Link] = ResultTable;
[Link]();
[Link] =[Link] ();
[Link] = "Total Amount Is =";
}
else
{
[Link] = null;
[Link]();
[Link] = "Amount Report Not Found In This year...!!!";
[Link] = "";
}
}
break;
}
}
}
protected void ddlReportType_SelectedIndexChanged(object sender, EventArgs e)
{
string ReportType = [Link]();
switch (ReportType)
{
case "Daily":
{
[Link] = true;
[Link] = true;
[Link] = true;
[Link] = "";
[Link] = "";
[Link] = "";
}
break;
case "Monthly":
{
[Link] = false;
[Link] = true;
[Link] = true;
[Link] = "";
[Link] = "";
[Link] = "";
}
break;

case "Yearly":
{
[Link] = false;
[Link] = false;
[Link] = true;
[Link] = "";
[Link] = "";
[Link] = "";
}
break;
}
}
protected void BtnOk_Click(object sender, EventArgs e)
{
[Link] = null;
[Link]();
[Link] = "";
[Link] = "";
}
protected void BtnPrint_Click(object sender, EventArgs e)
{
[Link] = "Please save all payment details for further use....!!!";
}
protected void CustomValidator1_ServerValidate(object source,
ServerValidateEventArgs args)
{
if ([Link])
{
if ([Link]() == "Day")
{
[Link] = false;
}
else
{
[Link] = true;
}
}
else
{
[Link] = true;
}

}
protected void CustomValidator2_ServerValidate(object source,
ServerValidateEventArgs args)
{

if ([Link])
{
if ([Link]() == "Month")
{
[Link] = false;
}
else
{
[Link] = true;
}
}
else
{
[Link] = true;
}
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class ReceptionistRecords : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminId"] != null)
{
[Link] = Session["AdminId"].ToString();
Session["AdminId"] = Session["AdminId"].ToString();
}

PathStringClass path = new PathStringClass();

string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);

SqlDataAdapter Sqd = new SqlDataAdapter("select * from ReceptionistDetails ",

SqlCon);
DataSet ds = new DataSet();
[Link](ds, "ReceptionistDetails");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = " Total " + [Link]() + " Receptionist(s) Records
found....!!!";
[Link] = ds;
[Link]();
}
else
{
[Link] = "Receptionist Records not Found.......!!!!!";
}
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class ReceptionistReport : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminId"] != null)
{
[Link] = Session["AdminId"].ToString();
Session["AdminId"] = Session["AdminId"].ToString();
}
}

protected void btnShow_Click(object sender, EventArgs e)

{
string Role = [Link]();
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from ReceptionistDetails
where Post='" + Role + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "ReceptionistDetails");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = "";
[Link] = ds;
[Link]();
}
else
{
[Link] = "Receptionist not found";
[Link] = null;
[Link]();
}
}
protected void btnShowAll_Click(object sender, EventArgs e)
{
[Link] = "";
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from ReceptionistDetails",
SqlCon);
DataSet ds = new DataSet();
[Link](ds, "ReceptionistDetails");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = "";
[Link] = ds;
[Link]();
}
else
{
[Link] = "Receptionist not found";
[Link] = null;
[Link]();
}
}

protected void BtnClose_Click(object sender, EventArgs e)

{
[Link] = "";
[Link] = null;
[Link]();
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class ReceptionistUpdation : [Link]
{
public string ImgPath;//veriable for storing image path
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminId"] != null)
{
[Link] = Session["AdminId"].ToString();
Session["AdminId"] = Session["AdminId"].ToString();
}
if (Session["ReceptionistId"] != null)
{
[Link] = Session["ReceptionistId"].ToString();
[Link] = true;
[Link] = "Enter Receptionist Information to be Updated...!!!";
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
if ([Link])
{

Boolean execute = false;

if ([Link])
{
ImgPath = ImagePath();
if (ImgPath != null)
{
execute = true;
}
}
else
{
[Link] = "Please select Picture...!!!";
}
if(execute )
{
Update_Receptionist_Details(ImgPath);
Show_Receptionist_Details();
}
}
}
private void Update_Receptionist_Details( string ImgPath)
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
ReceptionistDetails where ReceptionistId='" + [Link] + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "ReceptionistDetails");
DataTable dt = [Link][0];
int row = [Link];
foreach (DataRow dr in [Link])
{
dr[0] = [Link]() + [Link];
dr[1] = [Link]() + [Link];
dr[2] = [Link]() + "/" +
[Link]() + "/" + [Link]();
dr[3] = [Link]();
dr[4] = [Link];
dr[5] = [Link];
dr[6] = [Link];
dr[7] = [Link]();
dr[8] = [Link];
dr[9] = [Link];
dr[10] = [Link];
dr[11] = [Link];
dr[12] = [Link];
dr[13] = [Link];
dr[14] = [Link];

dr[15] = [Link];
dr[16] = [Link];
dr[17] = [Link];
dr[18] = ImgPath;
dr[19] = [Link]();
dr[20] = [Link];
SqlCommandBuilder cd = new SqlCommandBuilder(Sqd);
[Link](dt);
}
}
private void Show_Receptionist_Details()
{
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from ReceptionistDetails
where ReceptionistId='" + [Link] + "'", SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "ReceptionistDetails");
DataTable dt1 = [Link][0];
int row1 = [Link];
if (row1 > 0)
{
[Link] = ds1;
[Link]();
}
}
private string ImagePath()
{
Boolean FileOK = false;
//Boolean FileSaved = false;
int k = 0;

Session["WorkingImage"] = [Link];
String FileExtension =
[Link](Session["WorkingImage"].ToString()).ToLower();
//renaming File
Random MyRandom = new Random();
string FilenameWithoutExtension =
[Link](Session["WorkingImage"].ToString());
string fileNameIncreament = [Link]([Link](10, 300000));
FilenameWithoutExtension = FilenameWithoutExtension + fileNameIncreament;
Session["ImageFileName"] = FilenameWithoutExtension + FileExtension;
String[] allowedExtensions = { ".png", ".jpeg", ".jpg", ".gif", ".htm" };
for (int i = 0; i < [Link]; i++)
{

k++;
if (FileExtension == allowedExtensions[i])
{
FileOK = true;
break;
}
}
if (FileOK)
{
try
{
string path = ([Link]("../ReceptionistImages")).ToString();
[Link](path + "/" + Session["ImageFileName"].ToString());
}
catch (Exception ex)
{
}
}
string dbfilePath;
string fileName = [Link](Session["ImageFileName"].ToString());
dbfilePath = @"../ReceptionistImages/" + fileName;
if (!FileOK)
{
dbfilePath = null;
}
return dbfilePath;
}
protected void BtnClose_Click(object sender, EventArgs e)
{
[Link] = null;
[Link]();
}
protected void Validate_Entered_Phone_Number(object source,
ServerValidateEventArgs args)
{
if ([Link] == "")
{
[Link] = false;
}
else
{
Int64 number;
Boolean IsNumber = [Link]([Link], out number);
if (IsNumber && number <= 9999999999 && number >= 1000000000)
{
[Link] = true;
}
{

[Link] = false;
}
}
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace [Link]
{
public partial class RegisterExecutive : [Link]
{
string ImgPath;//Image storing
Boolean value = false;
Boolean IsExistId = false;
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminId"] != null)
{
[Link] = Session["AdminId"].ToString();
Session["AdminId"] = Session["AdminId"].ToString();
}
if (IsPostBack)
{
[Link] = [Link];
[Link] = "Please Select Image";
}
}
protected void btnok_Click1(object sender, EventArgs e)
{
[Link] = null;
[Link]();

[Link] = "";
[Link] = true;
}
protected void btnregister_Click(object sender, EventArgs e)
{
if ([Link])
{
if ([Link])
{
ImgPath = ImagePath();
IsExistId = check_ID();
if (ImgPath != null && IsExistId)
{
Register_Receptionist(ImgPath);
Show_Registered_Iformation();
}
}
else
{
[Link] = "Please Select Image";
}
}
else
{
[Link] = "Uknown Error occured!!!";
}
}
private string ImagePath()
{
Boolean FileOK = false;
int k = 0;
Session["WorkingImage"] = [Link];
String FileExtension =
[Link](Session["WorkingImage"].ToString()).ToLower();
//renaming File
Random MyRandom = new Random();
string FilenameWithoutExtension =
[Link](Session["WorkingImage"].ToString());
string fileNameIncreament = [Link]([Link](10, 300000));
FilenameWithoutExtension = FilenameWithoutExtension + fileNameIncreament;
Session["ImageFileName"] = FilenameWithoutExtension + FileExtension;
String[] allowedExtensions = { ".png", ".jpeg", ".jpg", ".gif", ".htm" };
for (int i = 0; i < [Link]; i++)
{
k++;
if (FileExtension == allowedExtensions[i])
{
FileOK = true;
break;

}
}
if (FileOK)
{
try
{
string path = ([Link]("../ReceptionistImages")).ToString();
[Link](path + "/" + Session["ImageFileName"].ToString());
}
catch (Exception ex)
{
}
}
else
{
[Link] = "Please Select Valid Image";
}
string dbfilePath;
string fileName = [Link](Session["ImageFileName"].ToString());
dbfilePath = @"../ReceptionistImages/" + fileName;
if (!FileOK)
{
dbfilePath = null;
}
return dbfilePath;
}
private bool check_ID()
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from ReceptionistDetails
where ReceptionistId='" + [Link] + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "ReceptionistDetails");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = ds;
[Link]();
[Link] = "This Id is already given to othere staff";
value = false;
}
else
{
value = true;
[Link] = "Id Is Available for Giving";
}

return value;
}
private void Register_Receptionist(string ImgPath)
{
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from GuestDetails",
SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "GuestDetails");
DataTable dt1 = [Link][0];
DataRow dr1 = [Link]();
dr1[0] = [Link]() + [Link];
dr1[1] = [Link]() + [Link];
dr1[2] = [Link]() + "/" + [Link]() +
"/" + [Link]();
dr1[3] = [Link]();
dr1[4] = [Link];
dr1[5] = [Link];
dr1[6] = [Link];
dr1[7] = [Link]();
dr1[8] = [Link];
dr1[9] = [Link];
dr1[10] = [Link];
dr1[11] = [Link];
dr1[12] = [Link];
dr1[13] = [Link];
dr1[14] = [Link];
dr1[15] = [Link];
dr1[16] = [Link];
dr1[17] = ImgPath;
[Link](dr1);
SqlCommandBuilder cd = new SqlCommandBuilder(Sqd1);
[Link](dt1);
[Link] = "Staff Has Got Registered, Informations are shown bellow";
}
private void Show_Registered_Iformation()
{
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd2 = new SqlDataAdapter("select * from GuestDetails where
GuestId='" + [Link] + "'", SqlCon1);
DataSet ds2 = new DataSet();
[Link](ds2, "GuestDetails");
DataTable dt2 = [Link][0];
int noofrow = [Link];
if (noofrow != 0)

{
[Link] = ds2;
[Link]();
}
else
{
[Link] = "There is An Error...!!!";
}
}
protected void BtnCheck_Click(object sender, EventArgs e)
{
Boolean IsThisIdExist = false;
IsThisIdExist = check_ID();
if (IsThisIdExist)
{
[Link] = "This id is already given to othere staff";
}
else
{
[Link] = "This id is not Avilable for giving";
}
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class CreationRoomAndOffice : [Link]
{
string ImgPath;
Boolean Value = false;
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminId"] != null)

{
[Link] = Session["AdminId"].ToString();
Session["AdminId"] = Session["AdminId"].ToString();
}
}
protected void btnaddroom_Click(object sender, EventArgs e)
{
if ([Link])
{
if ([Link])
{
Boolean IsExistRoomNo = false;
ImgPath = ImagePath();
IsExistRoomNo = Check_RoomNo();
if (ImgPath != null && IsExistRoomNo)
{
Add_This_Room(ImgPath);
Display_Added_Room();
}
}
else
{
[Link] = "Please select Picture...!!!";
}
}
else
{
[Link] = "Please check all given information";
}
}
private string ImagePath()
{
Boolean FileOK = false;
int k = 0;
Session["WorkingImage"] = [Link];
String FileExtension =
[Link](Session["WorkingImage"].ToString()).ToLower();
//renaming File
Random MyRandom = new Random();
string FilenameWithoutExtension =
[Link](Session["WorkingImage"].ToString());
string fileNameIncreament = [Link]([Link](10, 300000));
FilenameWithoutExtension = FilenameWithoutExtension + fileNameIncreament;
Session["ImageFileName"] = FilenameWithoutExtension + FileExtension;
String[] allowedExtensions = { ".png", ".jpeg", ".jpg", ".gif", ".htm" };
for (int i = 0; i < [Link]; i++)
{
k++;

if (FileExtension == allowedExtensions[i])
{
FileOK = true;
break;
}
}
if (FileOK)
{
try
{
string path = ([Link]("../RoomImages")).ToString();
[Link](path + "/" + Session["ImageFileName"].ToString());
}
catch (Exception ex)
{
}
}
else
{
[Link] = "Please Select Valid Image";
}
string dbfilePath;
string fileName = [Link](Session["ImageFileName"].ToString());
dbfilePath = @"../RoomImages/" + fileName;
if (!FileOK)
{
dbfilePath = null;
}
return dbfilePath;
}
private bool Check_RoomNo()
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd2 = new SqlDataAdapter("select * from Room where
RoomNo='" + [Link] + "'", SqlCon);
DataSet ds2 = new DataSet();
[Link](ds2, "Room");
DataTable dt2 = [Link][0];
int noofrow = [Link];
if (noofrow != 0)
{
[Link] = "This Room is already added";
[Link] = ds2;
[Link]();
Value = false;
}
else
{
Value = true;

}
return Value;
}
private void Add_This_Room(string ImgPath)
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Room ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Room");
DataTable dt = [Link][0];
DataRow dr = [Link]();
dr[0] = [Link];
dr[1] = [Link]();
dr[2] = [Link]();
dr[3] = [Link];
dr[4] = [Link]();
dr[5] = ImgPath;
[Link](dr);
SqlCommandBuilder cd = new SqlCommandBuilder(Sqd);
[Link](dt);
[Link] = "Room Is successfully added..";
[Link] = [Link];
}
private void Display_Added_Room()
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd2 = new SqlDataAdapter("select * from Room where
RoomNo='" + [Link] + "'", SqlCon);
DataSet ds2 = new DataSet();
[Link](ds2, "Room");
DataTable dt2 = [Link][0];
int noofrow = [Link];
if (noofrow != 0)
{
[Link] = ds2;
[Link]();
}
}
protected void btnselect_Click(object sender, EventArgs e)
{
Button imgbtn = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lblRoomNo = (Label)[Link]("lblRoomNo");
Session["RoomNo"] = [Link];

Session["ComeBack"] = "ComeBack";
[Link]("~/Admin/[Link]");
}
protected void ShowAllRooms_Click(object sender, EventArgs e)
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Room ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Room");
DataTable dt = [Link][0];
DataRow dr = [Link]();
int Room = 0;
Room = [Link];
if (Room != 0)
{
[Link] = ds;
[Link]();
[Link] = "";
}
else
{
[Link] = "There are no rooms found!!!";
}

}
protected void CustomValidator1_ServerValidate(object source,
ServerValidateEventArgs args)
{
Boolean check;
int number;
check = [Link]([Link] ,out number);
[Link] = check;
}
protected void CustomValidator2_ServerValidate(object source,
ServerValidateEventArgs args)
{
Boolean check;
int number;
check = [Link]([Link], out number);
[Link] = check;
}

}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class RoomReport : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminId"] != null)
{
[Link] = Session["AdminId"].ToString();
Session["AdminId"] = Session["AdminId"].ToString();
}
}
protected void BtnShow_Click1(object sender, EventArgs e)
{
string RoomStaus = [Link]();
switch (RoomStaus)
{
case "Booked":
case "Vacant":
{
if ([Link] == "Booked")
{
Boolean IsPickedUpBookedRoomNo = false;
string Formate = "dd/MM/yyyy";
string MyDate = [Link]("dd/MM/yyyy");
DateTime Today = [Link](MyDate, Formate,
[Link]);
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms ", SqlCon);

DataSet ds = new DataSet();

[Link](ds, " BookedRooms");
DataTable dt = [Link][0];
int row = [Link][0].[Link];
if (row != 0)
{
int i = 0;
int totalsRoom = 0;
DataTable tempTable = new DataTable();
[Link]("RoomNo");
[Link]("CheckInDate");
[Link]("CheckOutDate");
[Link]("BookingId");
[Link]("GuestId");
foreach (DataRow dr in [Link])
{
string CheckInDate = [Link][i][1].ToString();
DateTime TableDateIn = [Link](CheckInDate,
Formate, [Link]);
string CheckOutDate = [Link][i][2].ToString();
DateTime TableDateOut = [Link](CheckOutDate,
Formate, [Link]);
int result1 = [Link](Today, TableDateIn);//guest
datein is less then old guest datein
int result2 = [Link](Today, TableDateOut);//old guest
outdate is before then new guest checkin
if (result1 >= 0 && result2 < 0)//true when Date1 is greter then
{
DataRow NewDr = [Link]();
NewDr["RoomNo"] = [Link][i][0].ToString();
NewDr["CheckInDate"] = [Link][i][1].ToString();
NewDr["CheckOutDate"] = [Link][i][2].ToString();
NewDr["BookingId"] = [Link][i][3].ToString();
NewDr["GuestId"] = [Link][i][4].ToString();
[Link](NewDr);
[Link]();
ViewState["tempTable"] = tempTable;
IsPickedUpBookedRoomNo = true;
totalsRoom = totalsRoom + 1;
}
i = i + 1;
}
if (!IsPickedUpBookedRoomNo)
{
[Link] = "";
[Link] = [Link]() + "---Room(s) Found...!!!";
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = dt;
[Link]();

}
else
{
[Link] = "";
[Link] = totalsRoom + "---Room(s) Found...!!!";
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = ViewState["tempTable"];
[Link]();
}
}
else
{
[Link] = "";
[Link] = "Report Not Found...!!!";
}
}
else
{
Boolean IsPickedUpBookedRoomNo = false;
string Formate = "dd/MM/yyyy";
string MyDate = [Link]("dd/MM/yyyy");
DateTime Today = [Link](MyDate, Formate,
[Link]);
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, " BookedRooms");
DataTable dt = [Link][0];
int row = [Link][0].[Link];
if (row != 0)
{
int i = 0;
DataTable tempTable = new DataTable();
[Link]("RoomNo");
foreach (DataRow dr in [Link])
{
string CheckInDate = [Link][i][1].ToString();
DateTime TableDateIn = [Link](CheckInDate,
Formate, [Link]);
string CheckOutDate = [Link][i][2].ToString();
DateTime TableDateOut = [Link](CheckOutDate,
Formate, [Link]);
int result1 = [Link](Today, TableDateIn);//guest
datein is less then old guest datein
int result2 = [Link](Today, TableDateOut);//old guest
outdate is before then new guest checkin

if (result1 > 0 && result2 <= 0)//true when Date1 is greter then
{
DataRow NewDr = [Link]();
string SelectedRoomNo = [Link][i][0].ToString();
NewDr["RoomNo"] = SelectedRoomNo;
[Link](NewDr);
[Link]();
ViewState["tempTable"] = tempTable;
IsPickedUpBookedRoomNo = true;
}
i = i + 1;
}
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from Room ",
SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "Room");
DataTable dt1 = [Link][0];
int row1 = [Link][0].[Link];
if (row1 != 0)
{
if (!IsPickedUpBookedRoomNo)
{
[Link] = "";
[Link] = [Link]() + " Room(s) Available...!!!";
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = dt1;
[Link]();
}
else
{
DataTable tempdt = new DataTable(); // creating temp table to
store Booked Room no details
[Link]("RoomNo");//adding culumns to temp
table
[Link]("Type");
[Link]("Capacity");
[Link]("Rate");
[Link]("Status");
[Link]("Image");
int n = 0, l = 0;
Boolean IsMatchedBoothRoom = false;
foreach (DataRow dr2 in [Link])
{
int k = 0;
foreach (DataRow dr in [Link])

{
string AvailableRoomNo = [Link][l][0].ToString();
string BookedRoomNo = [Link][k][0].ToString();
if (AvailableRoomNo == BookedRoomNo) // finding all
booked room no from room table
{
IsMatchedBoothRoom = true;
}
k = k + 1;
}
if (!IsMatchedBoothRoom)
{
DataRow NewDR = [Link]();
NewDR["RoomNo"] = [Link][n][0].ToString();
NewDR["Type"] = [Link][n][1].ToString();
NewDR["Capacity"] = [Link][n][2].ToString();
NewDR["Rate"] = [Link][n][3].ToString();
NewDR["Status"] = [Link][n][4].ToString();
NewDR["Image"] = [Link][n][5].ToString();
[Link](NewDR);
[Link]();
n = n + 1;
}
IsMatchedBoothRoom = false;
l = l + 1;
}
ViewState["tempdt"] = tempdt;
int TempTableData = [Link];
if (TempTableData != 0)
{
[Link] = "";
[Link] = [Link]() + "---Room(s) Available...!!!";
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = tempdt;
[Link]();
}
else
{
[Link] = "";
[Link] = " Room Is Not Found...!!!";
}
}
}
}
}
}
break;

case "AC":
case "Non-AC":
case "General":
{
PathStringClass path1 = new PathStringClass(); // retriving room table
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from Room where
Type='" + RoomStaus + "' ", SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, " Room");
DataTable dt1 = [Link][0];
int row1 = [Link][0].[Link];
if (row1 != 0)
{
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = ds1;
[Link]();
[Link] = "";
[Link] = [Link]() + "---Room(s) Found...!!!";
}
else
{
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = "";
[Link] = "Room not found...!!!";
}
}
break;
default:
[Link] = "";
[Link] = "Report not found...!!!";
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
break;
}
}
protected void BtnGuest_Click(object sender, EventArgs e)
{

Button btnBookedShow = (Button)sender;

GridViewRow row = (GridViewRow)[Link];
Label LblGuestId = (Label)[Link]("LblGuestId");
string Guestid = [Link];
PathStringClass path3 = new PathStringClass();
string DatabasePath3 = path3.Get_path();
SqlConnection SqlCon3 = new SqlConnection(DatabasePath3);
SqlDataAdapter Sqd3 = new SqlDataAdapter("select * from GuestDetails where
GuestId='" + Guestid + "' ", SqlCon3);
DataSet ds3 = new DataSet();
[Link](ds3, "GuestDetails");
DataTable dt3 = [Link][0];
int PayentRow = [Link];
if (PayentRow != 0)
{
[Link] = "";
[Link] = ds3;
[Link]();
}
}
protected void BtnCloseReport_Click(object sender, EventArgs e)
{
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = "";
}
protected void CloseGuestDetails_Click(object sender, EventArgs e)
{
[Link] = null;
[Link]();
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

using [Link];
using [Link];
namespace [Link]
{
public partial class RoomUpdate : [Link]
{
string ImgPath;
Boolean Value = false;
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminId"] != null)
{
[Link] = Session["AdminId"].ToString();
Session["AdminId"] = Session["AdminId"].ToString();
}
if (Session["RoomNo"] != null)
{
[Link] = "Enter The Room Information To be Updated...!!!";
[Link] = Session["RoomNo"].ToString();
[Link] = true;
}
else
{
[Link] = "First Select The Room No...!!!";
[Link] = true;
[Link] = [Link];
[Link] = false;
[Link] = "Go To Select";
[Link] = "Go To Select The Room";
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
if ([Link])
{
if ([Link])
{
ImgPath = ImagePath();
if (ImgPath != null)
{
Update_This_Room(ImgPath);
Display_Added_Room();
}
}
else

{
[Link] = "Please select Picture...!!!";
}
}
else
{
[Link] = "Please check all given information";
}
}
private void Update_This_Room(string ImgPath)
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Room where
RoomNo='" + [Link] + "' ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Room");
DataTable dt = [Link][0];
int Room = [Link];
if (Room != 0)
{
foreach (DataRow dr in [Link])
{
dr[1] = [Link];
dr[2] = [Link];
dr[3] = [Link];
dr[4] = [Link];
dr[5] = ImgPath;
SqlCommandBuilder cd = new SqlCommandBuilder(Sqd);
[Link](dt);
}
[Link] = "Room Is Updated...!!!";
[Link] = "Go Back";
[Link] = "Go Back To Select Another Room";
}
else
{
[Link]="An Error Is Orrured";
}
}
private string ImagePath()
{
Boolean FileOK = false;
int k = 0;
Session["WorkingImage"] = [Link];
String FileExtension =
[Link](Session["WorkingImage"].ToString()).ToLower();
//renaming File

Random MyRandom = new Random();

string FilenameWithoutExtension =
[Link](Session["WorkingImage"].ToString());
string fileNameIncreament = [Link]([Link](10, 300000));
FilenameWithoutExtension = FilenameWithoutExtension + fileNameIncreament;
Session["ImageFileName"] = FilenameWithoutExtension + FileExtension;
String[] allowedExtensions = { ".png", ".jpeg", ".jpg", ".gif", ".htm" };
for (int i = 0; i < [Link]; i++)
{
k++;
if (FileExtension == allowedExtensions[i])
{
FileOK = true;
break;
}
}
if (FileOK)
{
try
{
string path = ([Link]("../RoomImages")).ToString();
[Link](path + "/" + Session["ImageFileName"].ToString());
}
catch (Exception ex)
{
}
}
else
{
[Link] = "Please Select Valid Image";
}
string dbfilePath;
string fileName = [Link](Session["ImageFileName"].ToString());
dbfilePath = @"../RoomImages/" + fileName;
if (!FileOK)
{
dbfilePath = null;
}
return dbfilePath;
}
private void Display_Added_Room()
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd2 = new SqlDataAdapter("select * from Room where
RoomNo='" + [Link] + "'", SqlCon);
DataSet ds2 = new DataSet();
[Link](ds2, "Room");
DataTable dt2 = [Link][0];
int noofrow = [Link];

if (noofrow != 0)
{
[Link] = ds2;
[Link]();
}
}
protected void btnselect_Click(object sender, EventArgs e)
{
Button imgbtn = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lblRoomNo = (Label)[Link]("lblRoomNo");
[Link] = false;
[Link] = [Link];
[Link] = true;
[Link] = "Again Enter Room Information...!!!";
[Link] = null;
[Link]();
[Link] = "";
}
protected void btnDelete_Click(object sender, EventArgs e)
{
Button imgbtn = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lblRoomNo = (Label)[Link]("lblRoomNo");
Session["RoomNo"] = [Link];
Session["BackToUpdate"] = "BackToUpdate";
[Link]("~/Admin/[Link]");
}
protected void btncancel_Click(object sender, EventArgs e)
{
[Link]("~/Admin/[Link]");
}
protected void CustomValidator1_ServerValidate(object source,
ServerValidateEventArgs args)
{
Boolean check;
int number;
check = [Link]([Link], out number);
[Link] = check;
}
protected void CustomValidator2_ServerValidate(object source,
ServerValidateEventArgs args)
{
Boolean check;

int number;
check = [Link]([Link], out number);
[Link] = check;
}

}
}
[Link]
ACAusing System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class RuleManagement : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminId"] != null)
{
[Link] = Session["AdminId"].ToString();
Session["AdminId"] = Session["AdminId"].ToString();
}
[Link] = false;
}
protected void BtnPublishedRules_Click(object sender, EventArgs e)
{
string today = [Link]();
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Rules ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Rules");
DataTable dt = [Link][0];
DataRow dr = [Link]();

dr[0] = today;
dr[1] = [Link];
[Link](dr);
SqlCommandBuilder cd = new SqlCommandBuilder(Sqd);
[Link](dt);
[Link] = "Entered Rules has been added to the list...!!!";
//Display current added rule
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from Rules where
TodaysDate='" + today + "' ", SqlCon);
DataSet ds1 = new DataSet();
[Link](ds1, "Rules");
DataTable dt1 = [Link][0];
int row1 = [Link];
if (row1 != 0)
{
[Link] = ds1;
[Link]();
}
[Link] = "";
}
protected void BtnShowRules_Click(object sender, EventArgs e)
{
[Link] = "";
show_allRulew();
}
private void show_allRulew()
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Rules ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Rules");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = ds;
[Link]();
[Link] = "All the previous rules are displayed in the bellow...";
}
else
{

[Link] = "Rules are not found...!!!";

}
}
protected void Btnupdate_Click(object sender, EventArgs e)
{
[Link] = true;
Button BtnDelete = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label LblDate = (Label)[Link]("LblDate");
string date = [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Rules where
TodaysDate='" + date + "' ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Rules");
DataTable dt = [Link][0];
int row1 = [Link];
if (row1 != 0)
{
[Link] = [Link][0][1].ToString();
}
[Link] = true;
}
protected void BtnDelete_Click(object sender, EventArgs e)
{
Button BtnDelete = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label LblDate = (Label)[Link]("LblDate");
string date = [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Rules where
TodaysDate='"+date+"' ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Rules");
DataTable dt = [Link][0];
int row1 = [Link];
if (row1 != 0)
{
foreach (DataRow dr in [Link])
{
[Link]();
SqlCommandBuilder cb = new SqlCommandBuilder(Sqd);
[Link](dt);
[Link] = "Rule is successfully deleted...!!!";

break;
}
show_allRulew();
}

}
protected void UpdateThis_Click(object sender, EventArgs e)
{
string today = [Link]();
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Rules ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Rules");
DataTable dt = [Link][0];
[Link][0][0] = today;
[Link][0][1] = [Link];
SqlCommandBuilder cd = new SqlCommandBuilder(Sqd);
[Link](dt);
[Link] = "Entered Rules has been Updated to the list...!!!";
}
protected void btncancel_Click(object sender, EventArgs e)
{
[Link]("~/Admin/[Link]");
}

}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace [Link]
{
public partial class UpdateReceptionistDetails : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminId"] != null)
{
[Link] = Session["AdminId"].ToString();
Session["AdminId"] = Session["AdminId"].ToString();
}

}
protected void btnShow_Click(object sender, EventArgs e)
{
string Role = [Link]();
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from ReceptionistDetails
where Post='" + Role + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "ReceptionistDetails");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = ds;
[Link]();
}
else
{
[Link] = "Receptionist not found";
}
}
protected void BtnSelect_Click(object sender, EventArgs e)
{
Button BtnSelect = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lbluserid = (Label)[Link]("lbluserid");
Session["ReceptionistId"] = [Link];
[Link]("~/Admin/[Link]");
}
protected void btnShowAll_Click(object sender, EventArgs e)
{

[Link] = "";
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from ReceptionistDetails",
SqlCon);
DataSet ds = new DataSet();
[Link](ds, "ReceptionistDetails");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = ds;
[Link]();
}
else
{
[Link] = "Receptionist not found";
}
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class UpdateRoom : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminId"] != null)
{
[Link] = Session["AdminId"].ToString();
Session["AdminId"] = Session["AdminId"].ToString();
}
[Link] = "";
}

protected void btnUpdate_Click(object sender, EventArgs e)

{
Button imgbtn = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lblRoomNo = (Label)[Link]("lblRoomNo");
Session["RoomNo"] = [Link];
[Link]("~/Admin/[Link]");

}
protected void ShowAllRooms_Click(object sender, EventArgs e)
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Room ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Room");
DataTable dt = [Link][0];
int Room = [Link];
if (Room != 0)
{
[Link] = ds;
[Link]();
}
else
{
[Link] = "Not Available Room";
}
}
protected void BtnGoToUpdate_Click1(object sender, EventArgs e)
{
if ([Link] =="")
{
[Link] = "Enter The Roo No...!!!";
}
else
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Room where
RoomNo='"+ [Link]+"'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Room");
DataTable dt = [Link][0];
int Room = [Link];

if (Room != 0)
{
Session["RoomNo"] = [Link];
[Link]("~/Admin/[Link]");
}
else
{
[Link] = "Room No Is Not Exist...!!!";
}

}
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace [Link]
{
public partial class AvailableRooms : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["GuestId"] != null && Session["GuestName"]!=null)
{
Session["GuestName"] = Session["GuestName"].ToString();
Session["GuestId"] = Session["GuestId"].ToString();
[Link] = "Hi... " + Session["GuestName"].ToString()+", "+ "
User-Id:- " + Session["GuestId"].ToString();
}
if (Session["CheckInDate"] != null && Session["CheckOutDate"] != null)
{
Session["CheckInDate"] = Session["CheckInDate"].ToString();
Session["CheckOutDate"] = Session["CheckOutDate"].ToString();
}

if (Session["Message"] != null)
{
[Link] = Session["Message"].ToString();
}
if (!IsPostBack && Session["AvailableRooms"] != null)
{
DataTable dt = (DataTable)Session["AvailableRooms"];
[Link] = dt;
[Link]();
}

}
protected void BtnShow_Click(object sender, EventArgs e)
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Room ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Room");
DataTable dt = [Link][0];
int Room = [Link];
if (Room != 0)
{
[Link] = ds;
[Link]();
}
else
{
[Link] = "Not Available Room";
}
}
protected void btnregister_Click(object sender, EventArgs e)
{
[Link]("../[Link]");
}
protected void btnselect_Click(object sender, EventArgs e)
{
Button btnselect = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lblRoomNo = (Label)[Link]("lblRoomNo");
Session["CheckInDate"] = Session["CheckInDate"].ToString();
Session["CheckOutDate"] = Session["CheckOutDate"].ToString();
Session["SelectedRoomNo"] = [Link];
[Link]("~/Guest/[Link]");
}

}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class BookingCancelation : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["GuestId"] != null && Session["GuestName"] != null)
{
Session["GuestName"] = Session["GuestName"].ToString();
Session["GuestId"] = Session["GuestId"].ToString();
[Link] = "Hi... " + Session["GuestName"].ToString() + ", " +"
User-Id:- " + Session["GuestId"].ToString();
}
if (Session["BookingId"] != null && !IsPostBack )
{
string BookingId = Session["BookingId"].ToString();
[Link] = BookingId;
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from BookedRooms where
BookingId ='" + BookingId + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = "";
[Link] = ds;
[Link]();
[Link] = null;

[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
}
else
{
[Link] = "Booked Room Not Found. Please Try Another...!!!";
}
}
}
protected void BtnFind_Click(object sender, EventArgs e)
{
string id = [Link]();
switch (id)
{
case "Guest-Id":
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from BookedRooms
where GuestId ='" + [Link] + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = "";
[Link] = ds;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
}
else
{
[Link] = "Booked Room Not Found. Please Try Another...!!!";
}
}
break;
case "Booking-Id":
{

PathStringClass path = new PathStringClass();

string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from BookedRooms
where BookingId ='" + [Link] + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = "";
[Link] = ds;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
}
else
{
[Link] = "Booked Room Not Found. Please Try Another...!!!";
}
}
break;
case "Name":
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from GuestDetails
where Name like '%" + [Link] + "%'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "GuestDetails");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = "";
[Link] = ds;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = null;

[Link]();
}
else
{
[Link] = "Booked Room Not Found. Please Try Another...!!!";
}

}
break;
}
}
protected void BtnFindGuestDetails_Click(object sender, EventArgs e)
{
Button BtnFindGuestDetails = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label LblUserId = (Label)[Link]("LblUserId");
string GuestId = [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from GuestDetails where
GuestId ='" + GuestId + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "GuestDetails");
DataTable dt = [Link][0];
int row1 = [Link];
if (row1 != 0)
{
[Link] = "";
[Link] = ds;
[Link]();
}
else
{
[Link] = "Not Found...!!!";
}
}
protected void BtnSelect_Click(object sender, EventArgs e)
{
Button BtnFindGuestDetails = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label LblBookingId = (Label)[Link]("LblBookingId");
string BookingId = [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();

SqlConnection SqlCon = new SqlConnection(DatabasePath);

SqlDataAdapter Sqd = new SqlDataAdapter("select * from BookedRooms where
BookingId ='" + BookingId + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "BookedRooms");
DataTable dt = [Link][0];
int row1 = [Link];
if (row1 != 0)
{
[Link] = "";
[Link] = ds;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
}
else
{
[Link] = "Room Could Not Selected. Please Try Again...!!!";
}
}
protected void BtnDelete_Click(object sender, EventArgs e)
{
Button BtnFindGuestDetails = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lblBookingId = (Label)[Link]("lblBookingId");
string BookingId = [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from BookedRooms where
BookingId ='" + BookingId + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "BookedRooms");
DataTable dt = [Link][0];
int row1 = [Link];
if (row1 != 0)
{
foreach (DataRow dr in [Link])
{
[Link]();
SqlCommandBuilder cd = new SqlCommandBuilder(Sqd);
[Link](dt);
break;
}
}
else
{

[Link] = "Cancelation Failured, Please try Again...!!!";

}
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from PaymentDetails
where BookingId ='" + BookingId + "'", SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "BookedRooms");
DataTable dt1 = [Link][0];
int row2 = [Link];
if (row2 != 0)
{
foreach (DataRow dr1 in [Link])
{
[Link]();
SqlCommandBuilder cd1 = new SqlCommandBuilder(Sqd1);
[Link](dt1);
break;
}
}
else
{
PathStringClass path11 = new PathStringClass();
string DatabasePath11 = path11.Get_path();
SqlConnection SqlCon11 = new SqlConnection(DatabasePath11);
SqlDataAdapter Sqd11 = new SqlDataAdapter("select * from PaymentDetails
where BookingId ='" + BookingId + "'", SqlCon11);
DataSet ds11 = new DataSet();
[Link](ds11, "BookedRooms");
DataTable dt11 = [Link][0];
int row21 = [Link];
if (row21 != 0)
{
foreach (DataRow dr11 in [Link])
{
[Link]();
SqlCommandBuilder cd11 = new SqlCommandBuilder(Sqd11);
[Link](dt11);
break;
}
}
}
[Link] = "Your Booking Has Been Canceled successfully!!!";
}
protected void BtnClose_Click(object sender, EventArgs e)

{
[Link] = "";
[Link] = null;
[Link]();
}
protected void BtnSelectGuest_Click(object sender, EventArgs e)
{
Button BtnSelectGuest = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lbluserid = (Label)[Link]("lbluserid");
Label LblMessageOfBooking = (Label)[Link]("LblMessageOfBooking");
string GuestId = [Link];

PathStringClass path = new PathStringClass();

string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from BookedRooms where
GuestId ='" + GuestId + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "BookedRooms");
DataTable dt = [Link][0];
int row22 = [Link];
if (row22 != 0)
{
[Link] = "";
[Link] = ds; ;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from GuestDetails where
GuestId ='" + GuestId + "'", SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "BookedRooms");
DataTable dt1 = [Link][0];
int row1 = [Link];
if (row1 != 0)
{
[Link] = "";
[Link] = null;
[Link]();

[Link] = ds1;
[Link]();
[Link] = null;
[Link]();
}
}
else
{
[Link] = "Booked Room Not Found With This User-Id....!!!";
}
}
protected void BtnSelectGuestClose_Click(object sender, EventArgs e)
{
[Link] = null;
[Link]();
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class BookingInformation : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["GuestId"] != null && Session["GuestName"] != null)
{
Session["GuestName"] = Session["GuestName"].ToString();
Session["GuestId"] = Session["GuestId"].ToString();
[Link] = "Hi... " + Session["GuestName"].ToString() + ", " + "
User-Id:- " + Session["GuestId"].ToString();
}
if (!IsPostBack)
{

if (Session["BookingId"] != null)
{
string BookingId = Session["BookingId"].ToString();
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from PaymentDetails
where BookingId='"+BookingId +"'", SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "PaymentDetails");
DataTable dt1 = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = ds1;
[Link]();
}
}
}
}
protected void btnBookedRoom_Click(object sender, EventArgs e)
{
Button btnRoomDetailsShow = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lblBookingId = (Label)[Link]("lblBookingId");
string Bookingid = [Link];

PathStringClass path4 = new PathStringClass();

string DatabasePath4 = path4.Get_path();
SqlConnection SqlCon4 = new SqlConnection(DatabasePath4);
SqlDataAdapter Sqd4 = new SqlDataAdapter("select * from BookedRooms where
BookingId='" + Bookingid + "'", SqlCon4);
DataSet ds4 = new DataSet();
[Link](ds4, "BookedRooms");
DataTable dt4 = [Link][0];
int rowno = [Link];
if (rowno != 0)
{
[Link]=ds4;
[Link]();
}
}

protected void BtnGuest_Click(object sender, EventArgs e)

{
Button btnBookedShow= (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label LblGuestId= (Label)[Link]("LblGuestId");
string Guestid=[Link];
PathStringClass path3 = new PathStringClass();
string DatabasePath3 = path3.Get_path();
SqlConnection SqlCon3 = new SqlConnection(DatabasePath3);
SqlDataAdapter Sqd3 = new SqlDataAdapter("select * from GuestDetails where
GuestId='"+Guestid+"' ",SqlCon3 );
DataSet ds3 = new DataSet();
[Link](ds3, "GuestDetails");
DataTable dt3 = [Link][0];
int PayentRow = [Link];
if (PayentRow != 0)
{
[Link] = ds3;
[Link]();
}
}
protected void btnCloseGuest_Click(object sender, EventArgs e)
{
[Link] = null;
[Link]();
}
protected void BtnClose_Click(object sender, EventArgs e)
{
[Link] = null;
[Link]();
}
protected void Payment_Click(object sender, EventArgs e)
{
Session["UserId"] = Session["UserId"].ToString();
[Link]("~/Guest/[Link]");
}
protected void btnok_Click(object sender, EventArgs e)
{
[Link]("~/Guest/[Link]");
}
}
}
[Link]
using System;
using [Link];

using
using
using
using
using
using
using
using
using
using
using
using

[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];
[Link];

namespace [Link]
{
public partial class BookingStatus : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["GuestId"] != null && Session["GuestName"] != null)
{
Session["GuestName"] = Session["GuestName"].ToString();
Session["GuestId"] = Session["GuestId"].ToString();
[Link] = "Hi... " + Session["GuestName"].ToString() + ", " + "
User-Id:- " + Session["GuestId"].ToString();

}
if (!IsPostBack)
{
Boolean DataLoaded = false;
string GuestId = Session["GuestId"].ToString();
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from PaymentDetails
where GuestId='" + GuestId + "'", SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "PaymentDetails");
DataTable dt1 = [Link][0];
int row1 = [Link];
if (row1 != 0)
{
[Link] = ds1;
[Link]();
DataLoaded = true;
}
PathStringClass path = new PathStringClass();

string DatabasePath = path.Get_path();

SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from TempBookedRooms
where GuestId='" + GuestId + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "TempBookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = "Please clear your payment of displayed bellow room(s) to
confirm your Booking...!!!";
[Link] = ds;
[Link]();
DataLoaded = true;
}
if (!DataLoaded)
{
[Link] = "You have not Booked Room....!!!";
}
}
}
protected void BtnOk_Click(object sender, EventArgs e)
{
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = "";
[Link] = "";
}
protected void BtnPay_Click(object sender, EventArgs e)
{
Button BtnPay = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label LblPaymentId = (Label)[Link]("LblPaymentId");
Session["PaymentId"] = [Link];
[Link]("~/Guest/[Link]");
}
protected void BtnCancelBooking_Click(object sender, EventArgs e)
{
Button BtnCancelBooking = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label LblBookingId = (Label)[Link]("LblBookingId");
Session["BookingId"] = [Link];
[Link]("~/Guest/[Link]");
}

protected void BtnPrint_Click(object sender, EventArgs e)

{
[Link] = "Please Collect the Booking Information for further use...!!!";
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class CancelPayment : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["GuestId"] != null && Session["GuestName"] != null)
{
Session["GuestName"] = Session["GuestName"].ToString();
Session["GuestId"] = Session["GuestId"].ToString();
[Link] = "Hi... " + Session["GuestName"].ToString() + ", " + "
User-Id:- " + Session["GuestId"].ToString();
}
if (!IsPostBack)
{
string GuestId = Session["GuestName"].ToString();
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from TempBookedRooms
where GuestId='" + GuestId + "' ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "TempBookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = ds;
[Link]();

[Link] = "Your Temporary payment daetails displayed in bellow..";

}
else
{
[Link] = "Your Temporary Payment information is not faound...";
}
}
}
protected void btnMakePayment_Click(object sender, EventArgs e)
{
Button btnMakePayment = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lblRoomNo = (Label)[Link]("lblRoomNo");
Label lblCheckInDate = (Label)[Link]("lblCheckInDate");
Label LblCheckOutDate = (Label)[Link]("LblCheckOutDate");
Label LblRate = (Label)[Link]("LblRate");
if (Session["GuestName"] != null)
{
string Guestid = Session["GuestName"].ToString();
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from GuestDetails where
GuestId='" + Guestid + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "GuestDetails");
DataTable dt = [Link][0];
int Room = [Link];
if (Room != 0)
{
string Name = [Link][0][0].ToString();
Session["Name"] = Name;
}
Session["Amount"] = [Link];
Session["GuestName"] = Session["GuestName"].ToString();
Session["Amount"] = [Link];
Session["CheckInDate"] = [Link];
Session["CheckOutDate"] = [Link];
Session["SelectedRoomNo"] = [Link];
[Link]("~/Guest/[Link]");
}
}
protected void btnMakePaymentLetter_Click(object sender, EventArgs e)
{
Button btnMakePayment = (Button)sender;
[Link] = true;
[Link] = false;

Button btnMakePaymentLetter = (Button)sender;

GridViewRow row = (GridViewRow)[Link];
Label lblRoomNo = (Label)[Link]("lblRoomNo");
Label lblCheckInDate = (Label)[Link]("lblCheckInDate");
Label LblCheckOutDate = (Label)[Link]("LblCheckOutDate");
Label LblRate = (Label)[Link]("LblRate");
Random MyRandom = new Random();
string TempBookingId = [Link]([Link](10, 3000));

PathStringClass path1 = new PathStringClass();

string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from TempBookedRooms",
SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "TempBookedRooms");
DataTable dt1 = [Link][0];
DataRow dr1 = [Link]();
dr1[0]
dr1[1]
dr1[2]
dr1[3]
dr1[4]
dr1[5]
dr1[6]

=
=
=
=
=
=
=

TempBookingId;
Session["GuestId"].ToString();
Session["GuestName"].ToString();
[Link];
[Link];
[Link];
[Link];

[Link](dr1);
SqlCommandBuilder cd = new SqlCommandBuilder(Sqd1);
[Link](dt1);
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from TempBookedRooms
where TempBookingId='" + TempBookingId + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "TempBookedRooms");
DataTable dt = [Link][0];
int Mydata = [Link];
if (Mydata != 0)
{
[Link] = ds;
[Link]();
[Link] = "Please Print your Temprary Booking information for further
use...!!!";
}

}
protected void BtnPrint_Click(object sender, EventArgs e)
{
[Link] = "Please save your temporary payment information for further
use";
}
protected void BtnOk_Click(object sender, EventArgs e)
{
[Link]("~/Guest/[Link]");
}
protected void BtnPay_Click(object sender, EventArgs e)
{
Button BtnPay = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label LblPaymentId = (Label)[Link]("LblPaymentId");
Label LblGuestId = (Label)[Link]("LblGuestId");
Label LblName = (Label)[Link]("LblName");
Label LblRoomNo = (Label)[Link]("LblRoomNo");
Label lblCheckInDate = (Label)[Link]("lblCheckInDate");
Label LblCheckOutDate = (Label)[Link]("LblCheckOutDate");
Label LblAmount = (Label)[Link]("LblAmount");
Session["PaymentId"] = [Link];
Session["GuestId"] = [Link];
Session["Amount"] = [Link];
Session["GuestName"] = [Link];
Session["CheckInDate"] = [Link];
Session["CheckOutDate"] = [Link];
Session["SelectedRoomNo"] = [Link];
[Link]("~/Guest/[Link]");
}
protected void btnCancel_Click(object sender, EventArgs e)
{
[Link]("~/Guest/[Link]");
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class CustomerHome : [Link]

{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["GuestId"] == null && Session["GuestName"] == null)
{
[Link]("../Account/[Link]");
}
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class CustomerHome1 : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["GuestId"] != null && Session["GuestName"] != null)
{
Session["GuestName"] = Session["GuestName"].ToString();
Session["GuestId"] = Session["GuestId"].ToString();
[Link] = "Hi... " + Session["GuestName"].ToString() + ", " + "
User-Id:- " + Session["GuestId"].ToString();
}
}
protected void btnCheck_Click(object sender, EventArgs e)
{
DataTable tempTable = new DataTable();
[Link]("RoomNo");
Boolean IsPickedUpBookedRoomNo = false, Taken = false;
string indate = [Link] + "/" + [Link] + "/" + [Link];
string outdate = [Link] + "/" + [Link] + "/" + [Link];
string Formate = "dd/MM/yyyy";

DateTime GuestDateIn = [Link](indate, Formate,

[Link]);
DateTime GuestDateOut = [Link](outdate, Formate,
[Link]);
int CheckDate = [Link](GuestDateOut, GuestDateIn);
if (CheckDate >= 0)
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from BookedRooms ",
SqlCon);
DataSet ds = new DataSet();
[Link](ds, " BookedRooms");
DataTable dt = [Link][0];
int row = [Link][0].[Link];
if (row != 0)
{
int i = 0;
foreach (DataRow dr in [Link])
{
string CheckInDate = [Link][i][1].ToString();
DateTime TableDateIn = [Link](CheckInDate, Formate,
[Link]);
string CheckOutDate = [Link][i][2].ToString();
DateTime TableDateOut = [Link](CheckOutDate, Formate,
[Link]);

int result1 = [Link](GuestDateIn, TableDateIn);//guest datein

is less then old guest datein
int result2 = [Link](GuestDateOut, TableDateOut);//old guest
outdate is before then new guest checkin
int result3 = [Link](GuestDateIn, TableDateOut);
int result4 = [Link](GuestDateOut, TableDateIn);
if (result1 <= 0 && result2 >= 0)//true when Date1 is greter then
{
DataRow NewDr = [Link]();
string SelectedRoomNo = [Link][i][0].ToString();
NewDr["RoomNo"] = SelectedRoomNo;
[Link](NewDr);
[Link]();
IsPickedUpBookedRoomNo = true;
Taken = true;

}
if (result1 >= 0 && result2 <= 0 && !Taken)
{
DataRow NewDr = [Link]();
NewDr["RoomNo"] = [Link][i][0].ToString();
[Link](NewDr);
[Link]();
IsPickedUpBookedRoomNo = true;
Taken = true;

}
if (result1 > 1 && result3 > 0 && !Taken)
{
DataRow NewDr = [Link]();
NewDr["RoomNo"] = [Link][i][0].ToString();
[Link](NewDr);
[Link]();
IsPickedUpBookedRoomNo = true;
Taken = true;

}
if (result1 > 0 && result4 < 0 && !Taken)
{
DataRow NewDr = [Link]();
NewDr["RoomNo"] = [Link][i][0].ToString();
[Link](NewDr);
[Link]();
IsPickedUpBookedRoomNo = true;
Taken = true;

}
Taken = false;
i = i + 1;
}
}
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from Room ", SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "Room");
DataTable dt1 = [Link][0];
int row1 = [Link][0].[Link];
if (row1 != 0)
{

if (!IsPickedUpBookedRoomNo)
{
Session["AvailableRooms"] = dt1;
}
else
{
DataTable tempdt = new DataTable(); // creating temp table to store
Booked Room no details
[Link]("RoomNo");//adding culumns to temp table
[Link]("Type");
[Link]("Capacity");
[Link]("Rate");
[Link]("Status");
[Link]("Image");
int n = 0, l = 0;
Boolean IsMatchedBoothRoom = false;
foreach (DataRow dr2 in [Link])
{
int k = 0;
foreach (DataRow dr in [Link])
{
string AvailableRoomNo = [Link][l][0].ToString();
string BookedRoomNo = [Link][k][0].ToString();
if (AvailableRoomNo == BookedRoomNo) // finding all booked room
no from room table
{
IsMatchedBoothRoom = true;
}
k = k + 1;
}
if (!IsMatchedBoothRoom)
{
DataRow NewDR = [Link]();
NewDR["RoomNo"] = [Link][n][0].ToString();
NewDR["Type"] = [Link][n][1].ToString();
NewDR["Capacity"] = [Link][n][2].ToString();
NewDR["Rate"] = [Link][n][3].ToString();
NewDR["Status"] = [Link][n][4].ToString();
NewDR["Image"] = [Link][n][5].ToString();
[Link](NewDR);
[Link]();
n = n + 1;
}
IsMatchedBoothRoom = false;
l = l + 1;
}
ViewState["tempdt"] = tempdt;

int TempTableData = [Link];

if (TempTableData != 0)
{
Session["AvailableRooms"] = tempdt;
}
else
{
Session["Message"] = "Room Is Not Available For you Between The
Given Date...!!!";
}
}
Session["CheckInDate"] = indate;
Session["CheckOutDate"] = outdate;
[Link]("~/Guest/[Link]");
}
}
else
{
[Link] = "Please Check Input Dates...!!!";
}
}
}
}
[Link]
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class Gallery : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["GuestId"] != null && Session["GuestName"] != null)
{
Session["GuestName"] = Session["GuestName"].ToString();
Session["GuestId"] = Session["GuestId"].ToString();
[Link] = "Hi... " + Session["GuestName"].ToString() + ", " + "
User-Id:- " + Session["GuestId"].ToString();
}
}
}
}
[Link]
using System;

using
using
using
using
using

[Link];
[Link];
[Link];
[Link];
[Link];

namespace [Link]
{
public partial class LogOut : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
[Link]();
[Link]();
[Link]("../Account/[Link]");
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace [Link]
{
public partial class MakePayment : [Link]
{
public void Page_Load(object sender, EventArgs e)
{
if (Session["GuestId"] != null && Session["GuestName"] != null)
{
Session["GuestName"] = Session["GuestName"].ToString();
Session["GuestId"] = Session["GuestId"].ToString();
[Link] = "Hi... " + Session["GuestName"].ToString() + ", " + "
User-Id:- " + Session["GuestId"].ToString();
}
//Loading session value to the payment page
if (Session["SelectedRoomNo"] != null)
{

[Link] = Session["GuestName"].ToString();
if (Session["GuestId"] != null)
{
[Link] = Session["GuestId"].ToString();
}
else
{
[Link] = Session["GuestName"].ToString();
}
[Link] = Session["Amount"].ToString();
[Link] = Session["CheckInDate"].ToString();
[Link] = Session["CheckOutDate"].ToString();
[Link] = Session["SelectedRoomNo"].ToString();
[Link] = true;
[Link] = true;
[Link] = true;
[Link] = true;
[Link] = true;
[Link] = true;
}
if (Session["PaymentId"] != null)
{
//Loading session value to the payment information page from temp booking
string PamentId = Session["PaymentId"].ToString();
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from TempBookedRooms
where TempBookingId='" + PamentId + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "TempBookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = [Link][0][1].ToString();
[Link]=[Link][0][2].ToString ();
txtRoomNo .Text=[Link][0][3].ToString ();
txtInDate .Text =[Link] [0][4].ToString ();
[Link] =[Link][0][5].ToString ();
[Link] =[Link] [0][6].ToString ();
[Link] = true;
[Link] = true;
[Link] = true;
[Link] = true;
[Link] = true;
[Link] = true;
}
}
}

protected void ddlpaymentmode_SelectedIndexChanged(object sender, EventArgs

e)
{
if ([Link]() == "Using Net Banking")
{
[Link] = false;
[Link] = false;
[Link] = false;
[Link] = false;
[Link] = false;
}
if ([Link]() == "Using Credit Card")
{
[Link] = true;
[Link] = true;
[Link] = true;
[Link] = true;
[Link] = true;
}
}
protected void Payment_Click(object sender, EventArgs e)
{
Random MyRandom = new Random();
string BookingId = [Link]([Link](10, 3000));
string Today=[Link]("dd/MM/yyyy");
//Storing Payment details
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from PaymentDetails",
SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "PaymentDetails");
DataTable dt1 = [Link][0];
DataRow dr1 = [Link]();
if ([Link]() == "Using Credit Card")
{
dr1[0] = [Link];
dr1[1] = [Link];
dr1[2] = [Link];
dr1[3] = [Link];
dr1[4] = [Link];
dr1[5] = [Link] ;
dr1[6] = [Link];
dr1[7] = [Link];
dr1[8] = [Link];
dr1[9] = [Link] + [Link];
dr1[10] = [Link];
dr1[11] = BookingId;
dr1[12] = Today;

}
else
{
dr1[0] = [Link];
dr1[1] = [Link];
dr1[2] = [Link];
dr1[3] = [Link];
dr1[4] = [Link];
dr1[5] = [Link];
dr1[6] = [Link];
dr1[7] = "XXXXXXXXXXXX";
dr1[8] = "XXXXXXXXXXXX";
dr1[9] = "XXXXXXXXXXXX";
dr1[10] = "XXXXXXXXXXXX";
dr1[11] = BookingId;
dr1[12] = Today;
}

[Link](dr1);
Session["BookingId"] = BookingId;
SqlCommandBuilder cd = new SqlCommandBuilder(Sqd1);
[Link](dt1);
//storing room information
PathStringClass path2 = new PathStringClass();
string DatabasePath2 = path2.Get_path();
SqlConnection SqlCon2 = new SqlConnection(DatabasePath2);
SqlDataAdapter Sqd2 = new SqlDataAdapter("select * from BookedRooms",
SqlCon2);
DataSet ds2 = new DataSet();
[Link](ds2, "BookedRooms");
DataTable dt2 = [Link][0];
DataRow dr2 = [Link]();
dr2[0]
dr2[1]
dr2[2]
dr2[3]
dr2[4]

=
=
=
=
=

[Link];
[Link];
[Link];
BookingId;
[Link];

[Link](dr2);
SqlCommandBuilder cd2 = new SqlCommandBuilder(Sqd2);
[Link](dt2);
//deleting temp Booking information
if (Session["PaymentId"] != null)
{
string PaymentId = Session["PaymentId"].ToString();
PathStringClass path3 = new PathStringClass();
string DatabasePath3 = path3.Get_path();
SqlConnection SqlCon3 = new SqlConnection(DatabasePath3);

SqlDataAdapter Sqd3 = new SqlDataAdapter("select * from c where

TempBookingId='" + PaymentId + "'", SqlCon3);
DataSet ds3 = new DataSet();
[Link](ds3, "TempBookedRoom");
DataTable dt3 = [Link][0];
int row3 = [Link];
if (row3 != 0)
{
foreach (DataRow dr3 in [Link])
{
[Link]();
SqlCommandBuilder cb = new SqlCommandBuilder(Sqd3);
[Link](dt3);
break;
}
}

Session["BookingId"] = BookingId;
Session["GuestId"] = Session["GuestId"].ToString();
[Link]("~/Guest/[Link]");//going to Booking
conformation page by taking payment information
}
protected void btnregister_Click(object sender, EventArgs e)
{
[Link]("~/Guest/[Link]");
Session["GuestId"] = [Link];
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{

public partial class PaymentStatus : [Link]

{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["GuestId"] != null && Session["GuestName"] != null)
{
Session["GuestName"] = Session["GuestName"].ToString();
Session["GuestId"] = Session["GuestId"].ToString();
[Link] = "Hi... " + Session["GuestName"].ToString() + ", " + "
User-Id:- " + Session["GuestId"].ToString();
}
}
protected void BtnStatus_Click(object sender, EventArgs e)
{
string StatusType = [Link]();
switch (StatusType)
{
case "Booking-Id":
{
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from
PaymentDetails where BookingId='"+ TxtId .Text +"'", SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "PaymentDetails");
DataTable dt1 = [Link][0];
int row1 = [Link];
if (row1 != 0)
{
[Link] = ds1;
[Link]();
[Link] = "Your payment information(s) are displayed in the
bellow:--";
[Link] = "";
[Link] = null;
[Link]();
}
else
{
[Link] = "Your payment information is not found...!!!";
[Link] = "";
}
}
break;
case "TepmBooking-Id":
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();

SqlConnection SqlCon = new SqlConnection(DatabasePath);

SqlDataAdapter Sqd = new SqlDataAdapter("select * from
TempBookedRooms where TempBookingId='" + TxtId .Text + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "TempBookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = ds;
[Link]();
[Link] = "";
[Link] = "Your payment(s) is/are if process, please clear your
payment to confirm your booking Status:--";
[Link] = null;
[Link]();
}
else
{
[Link] = "Your Temparary Booked room not found...!!!";
[Link] = "";
}
}
break;
case "Guest-Id":
{
Boolean booked = false;
Boolean Unbooked = false;
//Payments of Booked rooms
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from
PaymentDetails where GuestId='" + [Link] + "'", SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "PaymentDetails");
DataTable dt1 = [Link][0];
int row1 = [Link];
if (row1 != 0)
{
[Link] = ds1;
[Link]();
[Link] = "Your payment information(s) are displayed in the
bellow:--";
booked = true;
}
else
{
[Link] = null;
[Link]();

//payment information of temprary booked rooms

PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
TempBookedRooms where GuestId='" + [Link] + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "TempBookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = ds;
[Link]();
[Link] = "Your payment(s) is/are in process, please clear your
payment to confirm your booking Status:--";
Unbooked = true;
}
else
{
[Link] = null;
[Link]();
}
if (!booked)
{
[Link] = "";
}
if (!Unbooked)
{
[Link] = "";
}
}
break;
}
}
protected void BtnPay_Click(object sender, EventArgs e)
{
Button BtnPay = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label LblPaymentId = (Label)[Link]("LblPaymentId");
Session["PaymentId"] = [Link];
[Link]("~/Guest/[Link]");
}
protected void BtnOk_Click(object sender, EventArgs e)
{
[Link] = null;

[Link]();
[Link] = null;
[Link]();
[Link] = "";
[Link] = "";
}
protected void BtnPrint_Click(object sender, EventArgs e)
{
[Link] = "Please Collect your booking information for further use...!!!";
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class RoomSearching : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["GuestId"] != null && Session["GuestName"] != null)
{
Session["GuestName"] = Session["GuestName"].ToString();
Session["GuestId"] = Session["GuestId"].ToString();
[Link] = "Hi... " + Session["GuestName"].ToString() + ", " + "
User-Id:- " + Session["GuestId"].ToString();
}
}
protected void BtnSearch_Click(object sender, EventArgs e)
{
DataTable tempTable = new DataTable();
[Link]("RoomNo");
Boolean IsPickedUpBookedRoomNo = false, Taken = false;
string indate = [Link] + "/" + [Link] + "/" + [Link];

string outdate = [Link] + "/" + [Link] + "/" + [Link];

string Formate = "dd/MM/yyyy";
DateTime GuestDateIn = [Link](indate, Formate,
[Link]);
DateTime GuestDateOut = [Link](outdate, Formate,
[Link]);
int CheckDate = [Link](GuestDateOut, GuestDateIn);
if (CheckDate >= 0)
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from BookedRooms ",
SqlCon);
DataSet ds = new DataSet();
[Link](ds, " BookedRooms");
DataTable dt = [Link][0];
int row = [Link][0].[Link];
if (row != 0)
{
int i = 0;
foreach (DataRow dr in [Link])
{
string CheckInDate = [Link][i][1].ToString();
DateTime TableDateIn = [Link](CheckInDate, Formate,
[Link]);
string CheckOutDate = [Link][i][2].ToString();
DateTime TableDateOut = [Link](CheckOutDate, Formate,
[Link]);

int result1 = [Link](GuestDateIn, TableDateIn);//guest datein

is less then old guest datein
int result2 = [Link](GuestDateOut, TableDateOut);//old guest
outdate is before then new guest checkin
int result3 = [Link](GuestDateIn, TableDateOut);
int result4 = [Link](GuestDateOut, TableDateIn);
if (result1 <= 0 && result2 >= 0)//true when Date1 is greter then
{
DataRow NewDr = [Link]();
string SelectedRoomNo = [Link][i][0].ToString();
NewDr["RoomNo"] = SelectedRoomNo;
[Link](NewDr);
[Link]();
IsPickedUpBookedRoomNo = true;

Taken = true;

}
if (result1 >= 0 && result2 <= 0 && !Taken)
{
DataRow NewDr = [Link]();
NewDr["RoomNo"] = [Link][i][0].ToString();
[Link](NewDr);
[Link]();
IsPickedUpBookedRoomNo = true;
Taken = true;

}
if (result1 > 1 && result3 > 0 && !Taken)
{
DataRow NewDr = [Link]();
NewDr["RoomNo"] = [Link][i][0].ToString();
[Link](NewDr);
[Link]();
IsPickedUpBookedRoomNo = true;
Taken = true;

}
if (result1 > 0 && result4 < 0 && !Taken)
{
DataRow NewDr = [Link]();
NewDr["RoomNo"] = [Link][i][0].ToString();
[Link](NewDr);
[Link]();
IsPickedUpBookedRoomNo = true;
Taken = true;

}
Taken = false;
i = i + 1;
}
}
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from Room ", SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "Room");
DataTable dt1 = [Link][0];

int row1 = [Link][0].[Link];

if (row1 != 0)
{

if (!IsPickedUpBookedRoomNo)
{
[Link] = dt1;
[Link]();
}
else
{
DataTable tempdt = new DataTable(); // creating temp table to store
Booked Room no details
[Link]("RoomNo");//adding culumns to temp table
[Link]("Type");
[Link]("Capacity");
[Link]("Rate");
[Link]("Status");
[Link]("Image");
int n = 0, l = 0;
Boolean IsMatchedBoothRoom = false;
foreach (DataRow dr2 in [Link])
{
int k = 0;
foreach (DataRow dr in [Link])
{
string AvailableRoomNo = [Link][l][0].ToString();
string BookedRoomNo = [Link][k][0].ToString();
if (AvailableRoomNo == BookedRoomNo) // finding all booked room
no from room table
{
IsMatchedBoothRoom = true;
}
k = k + 1;
}
if (!IsMatchedBoothRoom)
{
DataRow NewDR = [Link]();
NewDR["RoomNo"] = [Link][n][0].ToString();
NewDR["Type"] = [Link][n][1].ToString();
NewDR["Capacity"] = [Link][n][2].ToString();
NewDR["Rate"] = [Link][n][3].ToString();
NewDR["Status"] = [Link][n][4].ToString();
NewDR["Image"] = [Link][n][5].ToString();
[Link](NewDR);
[Link]();
n = n + 1;

}
IsMatchedBoothRoom = false;
l = l + 1;
}
ViewState["tempdt"] = tempdt;
int TempTableData = [Link];
if (TempTableData != 0)
{
[Link] = tempdt;
[Link]();
}
else
{
[Link] = "Room Is Not Available For you Between The Given
Date...!!!";
}
}
}
}
else
{
[Link] = "Please Check Entered Dates";
}
}
protected void btnselect_Click(object sender, EventArgs e)
{
Button btnselect = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lblRoomNo = (Label)[Link]("lblRoomNo");
Session["SelectedRoomNo"] = [Link];
string indate = [Link] + "/" + [Link] + "/" + [Link];
string outdate = [Link] + "/" + [Link] + "/" + [Link];
Session["CheckInDate"] = indate;
Session["CheckOutDate"] = outdate;
[Link]("~/Guest/[Link]");
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

using
using
using
using
using
using

[Link];
[Link];
[Link];
[Link];
[Link];
[Link];

namespace [Link]
{
public partial class SelelectedRoom : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["GuestId"] != null && Session["GuestName"] != null)
{
Session["GuestName"] = Session["GuestName"].ToString();
Session["GuestId"] = Session["GuestId"].ToString();
[Link] = "Hi... " + Session["GuestName"].ToString() + ", " + "
User-Id:- " + Session["GuestId"].ToString();
}
if (!IsPostBack && Session["SelectedRoomNo"] != null)
{

string str = Session["SelectedRoomNo"].ToString();

string Indate = Session["CheckInDate"].ToString();
string OutDate = Session["CheckOutDate"].ToString();

PathStringClass path = new PathStringClass();

string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Room where
RoomNo='" + str + "' ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Room");
DataTable dt = [Link][0];
int Room = [Link];

DataTable TempTable = new DataTable();

[Link]("RoomNo");
[Link]("Type");
[Link]("Capacity");
[Link]("Rate");
[Link]("Status");
[Link]("Image");
[Link]("CheckInDate");
[Link]("CheckOutDate");
foreach (DataRow dr in [Link])

{
DataRow TempDr = [Link]();
TempDr["RoomNo"] = [Link][0][0].ToString();
TempDr["Type"] = [Link][0][1].ToString();
TempDr["Capacity"] = [Link][0][2].ToString();
TempDr["Rate"] = [Link][0][3].ToString();
TempDr["Status"] = [Link][0][4].ToString();
TempDr["Image"] = [Link][0][5].ToString();
TempDr["CheckInDate"] = Indate;
TempDr["CheckOutDate"] = OutDate;
[Link](TempDr);
[Link]();
ViewState["TempTable"] = TempTable;
}
if ([Link] > 0)
{
[Link] = TempTable;
[Link]();
}
}
[Link] = false;
[Link] = false;
}
protected void btnMakePayment_Click(object sender, EventArgs e)
{
Button btnMakePayment = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lblRoomNo = (Label)[Link]("lblRoomNo");
Label lblCheckInDate = (Label)[Link]("lblCheckInDate");
Label LblCheckOutDate = (Label)[Link]("LblCheckOutDate");
Label LblRate = (Label)[Link]("LblRate");

if (Session["GuestName"] != null)
{
string Guestid = Session["GuestName"].ToString();
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from GuestDetails where
GuestId='" + Guestid + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "GuestDetails");
DataTable dt = [Link][0];
int Room = [Link];
if (Room != 0)

{
string Name = [Link][0][0].ToString();
Session["Name"] = Name;
}
Session["Amount"] = [Link];
Session["GuestName"] = Session["GuestName"].ToString();
Session["Amount"] = [Link];
Session["CheckInDate"] = [Link];
Session["CheckOutDate"] = [Link];
Session["SelectedRoomNo"] = [Link];
[Link]("~/Guest/[Link]");
}
}
protected void btnMakePaymentLetter_Click(object sender, EventArgs e)
{
Button btnMakePayment = (Button)sender;
[Link] = true;
[Link] = false;

Button btnMakePaymentLetter = (Button)sender;

GridViewRow row = (GridViewRow)[Link];
Label lblRoomNo = (Label)[Link]("lblRoomNo");
Label lblCheckInDate = (Label)[Link]("lblCheckInDate");
Label LblCheckOutDate = (Label)[Link]("LblCheckOutDate");
Label LblRate = (Label)[Link]("LblRate");
Random MyRandom = new Random();
string TempBookingId = [Link]([Link](10, 3000));

PathStringClass path1 = new PathStringClass();

string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from TempBookedRooms",
SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "TempBookedRooms");
DataTable dt1 = [Link][0];
DataRow dr1 = [Link]();
dr1[0]
dr1[1]
dr1[2]
dr1[3]
dr1[4]
dr1[5]
dr1[6]

=
=
=
=
=
=
=

TempBookingId;
Session["GuestId"].ToString();
Session["GuestName"].ToString();
[Link];
[Link];
[Link];
[Link];

[Link](dr1);

SqlCommandBuilder cd = new SqlCommandBuilder(Sqd1);

[Link](dt1);
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from TempBookedRooms
where TempBookingId='" + TempBookingId + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "TempBookedRooms");
DataTable dt = [Link][0];
int Mydata= [Link];
if (Mydata != 0)
{
[Link] = null;
[Link]();
[Link] = ds;
[Link]();
[Link] = "Please Print your Temprary Booking information for further
use...!!!";
}
}
protected void BtnPrint_Click(object sender, EventArgs e)
{
[Link] = true;
[Link] = null;
[Link]();
}
protected void BtnOk_Click(object sender, EventArgs e)
{
[Link]("~/Guest/[Link]");
}
protected void BtnPay_Click(object sender, EventArgs e)
{
Button BtnPay = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label LblPaymentId = (Label)[Link]("LblPaymentId");
Label LblGuestId = (Label)[Link]("LblGuestId");
Label LblName = (Label)[Link]("LblName");
Label LblRoomNo = (Label)[Link]("LblRoomNo");
Label lblCheckInDate = (Label)[Link]("lblCheckInDate");
Label LblCheckOutDate = (Label)[Link]("LblCheckOutDate");
Label LblAmount = (Label)[Link]("LblAmount");
Session["PaymentId"] = [Link];
Session["GuestId"]=LblGuestId .Text ;
Session["Amount"] =LblAmount .Text;
Session["GuestName"] =[Link];

Session["CheckInDate"] =[Link];
Session["CheckOutDate"] =[Link];
Session["SelectedRoomNo"] =LblRoomNo .Text;
[Link]("~/Guest/[Link]");
}
protected void btnCancel_Click(object sender, EventArgs e)
{
[Link]("~/Guest/[Link]");
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class AddingCustomerDetails : [Link]
{
string ImgPath;//Image storing
Boolean value = false;
Boolean IsExistId = false;
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ReceptionistId"] != null && Session["ReceptionistName"] != null)
{
Session["ReceptionistName"] = Session["ReceptionistName"].ToString();
Session["ReceptionistId"] = Session["ReceptionistId"].ToString();
[Link] = "Hi... " + Session["ReceptionistName"].ToString() + ", "
+ " User-Id:- " + Session["ReceptionistId"].ToString();
}
}
protected void BtnRegisterGuest_Click(object sender, EventArgs e)
{
if ([Link])

{
if ([Link])
{
ImgPath = ImagePath();
IsExistId = check_ID();
if (ImgPath != null && IsExistId)
{
Register_Guest(ImgPath);
Show_Guest_Registered_Iformation();
}
}
else
{
[Link] = "Please Select Image";
}
}
else
{
[Link] = "Uknown Error occured!!!";
}
[Link] = false;
}
private string ImagePath()
{
Boolean FileOK = false;
//Boolean FileSaved = false;
int k = 0;

Session["WorkingImage"] = [Link];
String FileExtension =
[Link](Session["WorkingImage"].ToString()).ToLower();
//renaming File
Random MyRandom = new Random();
string FilenameWithoutExtension =
[Link](Session["WorkingImage"].ToString());
string fileNameIncreament = [Link]([Link](10, 300000));
FilenameWithoutExtension = FilenameWithoutExtension + fileNameIncreament;
Session["ImageFileName"] = FilenameWithoutExtension + FileExtension;
String[] allowedExtensions = { ".png", ".jpeg", ".jpg", ".gif", ".htm" };
for (int i = 0; i < [Link]; i++)
{
k++;
if (FileExtension == allowedExtensions[i])
{
FileOK = true;
break;
}
}
if (FileOK)
{

try
{
string path = ([Link]("../GuestImages")).ToString();
[Link](path + "/" + Session["ImageFileName"].ToString());
}
catch (Exception ex)
{
}
}
string dbfilePath;
string fileName = [Link](Session["ImageFileName"].ToString());
dbfilePath = @"../GuestImages/" + fileName;
if (!FileOK)
{
dbfilePath = null;
}
return dbfilePath;
}
private bool check_ID()
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from GuestDetails where
GuestId='" + [Link] + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "GuestDetails");
DataTable dt = [Link][0];
DataRow dr = [Link]();
int Room = 0;
Room = [Link];
if (Room != 0)
{
[Link] = ds;
[Link]();
IsExistId = false;
[Link] = "A user is already registered with this User-Id";
}
else
{
IsExistId = true;
}
return IsExistId;
}
private void Register_Guest(string ImgPath)
{
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);

SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from GuestDetails",

SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "GuestDetails");
DataTable dt1 = [Link][0];
DataRow dr1 = [Link]();
dr1[0] = [Link]() + [Link];
dr1[1] = [Link]() + [Link];
dr1[2] = [Link]() + "/" + [Link]() +
"/" + [Link]();
dr1[3] = [Link]();
dr1[4] = [Link];
dr1[5] = [Link];
dr1[6] = [Link];
dr1[7] = [Link]();
dr1[8] = [Link];
dr1[9] = [Link];
dr1[10] = [Link];
dr1[11] = [Link];
dr1[12] = [Link];
dr1[13] = [Link];
dr1[14] = [Link];
dr1[15] = [Link];
dr1[16] = [Link];
dr1[17] = ImgPath;
[Link](dr1);
SqlCommandBuilder cd = new SqlCommandBuilder(Sqd1);
[Link](dt1);
}
private void Show_Guest_Registered_Iformation()
{
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd2 = new SqlDataAdapter("select * from GuestDetails where
GuestId='" + [Link] + "'", SqlCon1);
DataSet ds2 = new DataSet();
[Link](ds2, "GuestDetails");
DataTable dt2 = [Link][0];
int noofrow = [Link];
if (noofrow != 0)
{
[Link] = ds2;
[Link]();
}
else
{
[Link] = "There an error...!!!";
}
}

protected void btncheckExistingid_Click(object sender, EventArgs e)

{
Boolean IsIdExist = false;
IsIdExist = check_ID();
if (IsIdExist)
{
[Link] = "Entered Id is avilable for you";
}
else
{
[Link] = "Entered Id is not available for you";
}
}
protected void BtnClose_Click(object sender, EventArgs e)
{
[Link] = "";
[Link] = null;
[Link]();
}
protected void BtnRoomBooking_Click(object sender, EventArgs e)
{
Button BtnRoomBooking = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lblName = (Label)[Link]("lblName");
Label lbluserid = (Label)[Link]("lbluserid");
Session["lblName"] = [Link];
Session["UserId"] = [Link];
[Link]("~/Receptionist/[Link]");
}
protected void BtnOk_Click(object sender, EventArgs e)
{
[Link]("~/Receptionist/[Link]");
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

using [Link];
using [Link];
namespace [Link]
{
public partial class AddingRoom : [Link]
{
string ImgPath;
Boolean Value = false;
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ReceptionistId"] != null && Session["ReceptionistName"] != null)
{
Session["ReceptionistName"] = Session["ReceptionistName"].ToString();
Session["ReceptionistId"] = Session["ReceptionistId"].ToString();
[Link] = "Hi... " + Session["ReceptionistName"].ToString() + ", "
+ " User-Id:- " + Session["ReceptionistId"].ToString();
}
}
protected void btnaddroom_Click(object sender, EventArgs e)
{
if ([Link])
{
if ([Link])
{
Boolean IsExistRoomNo = false;
ImgPath = ImagePath();
IsExistRoomNo = Check_RoomNo();
if (ImgPath != null && IsExistRoomNo)
{
Add_This_Room(ImgPath);
Display_Added_Room();
}
}
else
{
[Link] = "Please select Picture...!!!";
}
}
else
{
[Link] = "Please check all given information";
}
}
private string ImagePath()
{
Boolean FileOK = false;
int k = 0;
Session["WorkingImage"] = [Link];

String FileExtension =
[Link](Session["WorkingImage"].ToString()).ToLower();
//renaming File
Random MyRandom = new Random();
string FilenameWithoutExtension =
[Link](Session["WorkingImage"].ToString());
string fileNameIncreament = [Link]([Link](10, 300000));
FilenameWithoutExtension = FilenameWithoutExtension + fileNameIncreament;
Session["ImageFileName"] = FilenameWithoutExtension + FileExtension;
String[] allowedExtensions = { ".png", ".jpeg", ".jpg", ".gif", ".htm" };
for (int i = 0; i < [Link]; i++)
{
k++;
if (FileExtension == allowedExtensions[i])
{
FileOK = true;
break;
}
}
if (FileOK)
{
try
{
string path = ([Link]("../RoomImages")).ToString();
[Link](path + "/" + Session["ImageFileName"].ToString());
}
catch (Exception ex)
{
}
}
else
{
[Link] = "Please Select Valid Image";
}
string dbfilePath;
string fileName = [Link](Session["ImageFileName"].ToString());
dbfilePath = @"../RoomImages/" + fileName;
if (!FileOK)
{
dbfilePath = null;
}
return dbfilePath;
}
private bool Check_RoomNo()
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd2 = new SqlDataAdapter("select * from Room where
RoomNo='" + [Link] + "'", SqlCon);
DataSet ds2 = new DataSet();

[Link](ds2, "Room");
DataTable dt2 = [Link][0];
int noofrow = [Link];
if (noofrow != 0)
{
[Link] = "This Room is already added";
[Link] = ds2;
[Link]();
Value = false;
}
else
{
Value = true;
}
return Value;
}
private void Add_This_Room(string ImgPath)
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Room ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Room");
DataTable dt = [Link][0];
DataRow dr = [Link]();
dr[0] = [Link];
dr[1] = [Link]();
dr[2] = [Link]();
dr[3] = [Link];
dr[4] = [Link]();
dr[5] = ImgPath;
[Link](dr);
SqlCommandBuilder cd = new SqlCommandBuilder(Sqd);
[Link](dt);
[Link] = "Room Is successfully added..";
[Link] = [Link];
}
private void Display_Added_Room()
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd2 = new SqlDataAdapter("select * from Room where
RoomNo='" + [Link] + "'", SqlCon);
DataSet ds2 = new DataSet();
[Link](ds2, "Room");
DataTable dt2 = [Link][0];
int noofrow = [Link];

if (noofrow != 0)
{
[Link] = ds2;
[Link]();
}
}
protected void ShowAllRooms_Click(object sender, EventArgs e)
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Room ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Room");
DataTable dt = [Link][0];
DataRow dr = [Link]();
int Room = 0;
Room = [Link];
if (Room != 0)
{
[Link] = ds;
[Link]();
[Link] = "";
}
else
{
[Link] = "There are no rooms found!!!";
}

}
protected void btnselect_Click(object sender, EventArgs e)
{
Button imgbtn = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lblRoomNo = (Label)[Link]("lblRoomNo");
Session["RoomNo"] = [Link];
Session["ComeBack"] = "ComeBack";
[Link]("~/Admin/[Link]");
}
protected void CustomValidator1_ServerValidate(object source,
ServerValidateEventArgs args)
{
Boolean check;
int number;
check = [Link]([Link], out number);

[Link] = check;
}
protected void CustomValidator2_ServerValidate(object source,
ServerValidateEventArgs args)
{
Boolean check;
int number;
check = [Link]([Link], out number);
[Link] = check;
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class BookingCancelation : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ReceptionistId"] != null && Session["ReceptionistName"] != null)
{
Session["ReceptionistName"] = Session["ReceptionistName"].ToString();
Session["ReceptionistId"] = Session["ReceptionistId"].ToString();
[Link] = "Hi... " + Session["ReceptionistName"].ToString() + ", "
+ " User-Id:- " + Session["ReceptionistId"].ToString();
}
}
protected void BtnFind_Click(object sender, EventArgs e)
{
string id = [Link]();
switch (id)
{

case "Guest-Id":
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from BookedRooms
where GuestId ='" + [Link] + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = "";
[Link] = ds;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
}
else
{
[Link] = "Booked Room Not Found. Please Try Another...!!!";
}
}
break;
case "Booking-Id":
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from BookedRooms
where BookingId ='" + [Link] + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = "";
[Link] = ds;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();

}
else
{
[Link] = "Booked Room Not Found. Please Try Another...!!!";
}
}
break;
case "Name":
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from GuestDetails
where Name like '%" + [Link] + "%'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "GuestDetails");
DataTable dt = [Link][0];
int row = [Link];
if (row != 0)
{
[Link] = "";
[Link] = ds;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
}
else
{
[Link] = "Booked Room Not Found. Please Try Another...!!!";
}

}
break;
}
}
protected void BtnFindGuestDetails_Click(object sender, EventArgs e)
{
Button BtnFindGuestDetails = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label LblUserId = (Label)[Link]("LblUserId");
string GuestId = [Link];

PathStringClass path = new PathStringClass();

string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from GuestDetails where
GuestId ='" + GuestId + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "GuestDetails");
DataTable dt = [Link][0];
int row1 = [Link];
if (row1 != 0)
{
[Link] = "";
[Link] = ds;
[Link]();
}
else
{
[Link] = "Not Found...!!!";
}
}
protected void BtnSelect_Click(object sender, EventArgs e)
{
Button BtnFindGuestDetails = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label LblBookingId = (Label)[Link]("LblBookingId");
string BookingId = [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from BookedRooms where
BookingId ='" + BookingId + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "BookedRooms");
DataTable dt = [Link][0];
int row1 = [Link];
if (row1 != 0)
{
[Link] = "";
[Link] = ds;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
}
else
{

[Link] = "Room Could Not Selected. Please Try Again...!!!";

}
}
protected void BtnDelete_Click(object sender, EventArgs e)
{
Button BtnFindGuestDetails = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lblBookingId = (Label)[Link]("lblBookingId");
string BookingId = [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from BookedRooms where
BookingId ='" + BookingId + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "BookedRooms");
DataTable dt = [Link][0];
int row1 = [Link];
if (row1 != 0)
{
foreach (DataRow dr in [Link])
{
[Link]();
SqlCommandBuilder cd = new SqlCommandBuilder(Sqd);
[Link](dt);
break;
}
}
else
{
[Link] = "Cancelation Failured, Please try Again...!!!";
}
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from PaymentDetails
where BookingId ='" + BookingId + "'", SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "BookedRooms");
DataTable dt1 = [Link][0];
int row2 = [Link];
if (row2 != 0)
{
foreach (DataRow dr1 in [Link])
{
[Link]();
SqlCommandBuilder cd1 = new SqlCommandBuilder(Sqd1);
[Link](dt1);
break;

}
}
else
{
PathStringClass path11 = new PathStringClass();
string DatabasePath11 = path11.Get_path();
SqlConnection SqlCon11 = new SqlConnection(DatabasePath11);
SqlDataAdapter Sqd11 = new SqlDataAdapter("select * from PaymentDetails
where BookingId ='" + BookingId + "'", SqlCon11);
DataSet ds11 = new DataSet();
[Link](ds11, "BookedRooms");
DataTable dt11 = [Link][0];
int row21 = [Link];
if (row21 != 0)
{
foreach (DataRow dr11 in [Link])
{
[Link]();
SqlCommandBuilder cd11 = new SqlCommandBuilder(Sqd11);
[Link](dt11);
break;
}
}
}
[Link] = "Your Booking Has Been Canceled successfully!!!";
[Link] = null;
[Link]();
}
protected void BtnClose_Click(object sender, EventArgs e)
{
[Link] = "";
[Link] = null;
[Link]();
}
protected void BtnSelectGuest_Click(object sender, EventArgs e)
{
Button BtnSelectGuest = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lbluserid = (Label)[Link]("lbluserid");
Label LblMessageOfBooking = (Label)[Link]("LblMessageOfBooking");
string GuestId = [Link];

PathStringClass path = new PathStringClass();

string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from BookedRooms where
GuestId ='" + GuestId + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "BookedRooms");
DataTable dt = [Link][0];
int row22 = [Link];
if (row22 != 0)
{
[Link] = "";
[Link] = ds; ;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from GuestDetails where
GuestId ='" + GuestId + "'", SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "BookedRooms");
DataTable dt1 = [Link][0];
int row1 = [Link];
if (row1 != 0)
{
[Link] = "";
[Link] = null;
[Link]();
[Link] = ds1;
[Link]();
[Link] = null;
[Link]();
}
}
else
{
[Link] = "Booked Room Not Found With This User-Id....!!!";
}
}
protected void BtnSelectGuestClose_Click(object sender, EventArgs e)
{
[Link] = null;
[Link]();
}

protected void BtnCancel_Click(object sender, EventArgs e)

{
[Link]("~/Receptionist/[Link]");
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class BookingInformation : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ReceptionistId"] != null && Session["ReceptionistName"] != null)
{
Session["ReceptionistName"] = Session["ReceptionistName"].ToString();
Session["ReceptionistId"] = Session["ReceptionistId"].ToString();
[Link] = "Hi... " + Session["ReceptionistName"].ToString() + ", "
+ " User-Id:- " + Session["ReceptionistId"].ToString();
}
if (!IsPostBack)
{
if (Session["BookingId"] != null)
{
string BookingId = Session["BookingId"].ToString();
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from
PaymentsFromReceptionist where BookingId='" + BookingId + "'", SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "PaymentsFromReceptionist");
DataTable dt1 = [Link][0];
int row = [Link];
if (row != 0)

{
[Link] = ds1;
[Link]();
}
}
}
}
protected void btnBookedRoom_Click(object sender, EventArgs e)
{
Button btnRoomDetailsShow = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lblBookingId = (Label)[Link]("lblBookingId");
string Bookingid = [Link];

PathStringClass path4 = new PathStringClass();

string DatabasePath4 = path4.Get_path();
SqlConnection SqlCon4 = new SqlConnection(DatabasePath4);
SqlDataAdapter Sqd4 = new SqlDataAdapter("select * from BookedRooms where
BookingId='" + Bookingid + "'", SqlCon4);
DataSet ds4 = new DataSet();
[Link](ds4, "BookedRooms");
DataTable dt4 = [Link][0];
int rowno = [Link];
if (rowno != 0)
{
[Link] = ds4;
[Link]();
}
}
protected void BtnGuest_Click(object sender, EventArgs e)
{
Button btnBookedShow = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label LblGuestId = (Label)[Link]("LblGuestId");
string Guestid = [Link];
PathStringClass path3 = new PathStringClass();
string DatabasePath3 = path3.Get_path();
SqlConnection SqlCon3 = new SqlConnection(DatabasePath3);
SqlDataAdapter Sqd3 = new SqlDataAdapter("select * from GuestDetails where
GuestId='" + Guestid + "' ", SqlCon3);
DataSet ds3 = new DataSet();

[Link](ds3, "PaymentDetails");
DataTable dt3 = [Link][0];
int PayentRow = [Link];
if (PayentRow != 0)
{
[Link] = ds3;
[Link]();
}
}
protected void btnCloseGuest_Click(object sender, EventArgs e)
{
[Link] = null;
[Link]();
}
protected void BtnClose_Click(object sender, EventArgs e)
{
[Link] = null;
[Link]();
}
protected void Payment_Click(object sender, EventArgs e)
{
}
protected void btnok_Click(object sender, EventArgs e)
{
if (Session["UserId"] != null)
{
Session["UserId"] = Session["UserId"].ToString();
}
[Link]("~/Receptionist/[Link]");
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class BookingRoom : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ReceptionistId"] != null && Session["ReceptionistName"] != null)
{
Session["ReceptionistName"] = Session["ReceptionistName"].ToString();
Session["ReceptionistId"] = Session["ReceptionistId"].ToString();
[Link] = "Hi... " + Session["ReceptionistName"].ToString() + ", "
+ " User-Id:- " + Session["ReceptionistId"].ToString();
}
if (Session["BookRoomNo"] != null)
{
string str = Session["BookRoomNo"].ToString();
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Room where
RoomNo='" + str + "' ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Room");
DataTable dt = [Link][0];
int Room = [Link];
if (Room != 0)
{
[Link] = ds;
[Link]();
}
else
{
[Link] = "System Error!!!";
}
}
else
{
[Link] = "You have not selected any room";
[Link] = false;
}
}
protected void BtnBooking_Click(object sender, EventArgs e)
{
Session["SelectedRoomNo"] = Session["BookRoomNo"].ToString();
[Link]("~/Receptionist/[Link]");

}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class CheckInGuestMonitoring : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ReceptionistId"] != null && Session["ReceptionistName"] != null)
{
Session["ReceptionistName"] = Session["ReceptionistName"].ToString();
Session["ReceptionistId"] = Session["ReceptionistId"].ToString();
[Link] = "Hi... " + Session["ReceptionistName"].ToString() + ", "
+ " User-Id:- " + Session["ReceptionistId"].ToString();
}
}
protected void BtnRecord_Click1(object sender, EventArgs e)
{
if ([Link])
{
string RecordType = [Link]();
DataTable TempDt = new DataTable();
[Link]("GuestId");
switch (RecordType)
{
case "Daily":
{
string d1 = [Link] + "/" + [Link] + "/" + [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckInDate like '%" + d1 + "%'", SqlCon);

DataSet ds = new DataSet();

[Link](ds, " BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
DataTable CheckDt = [Link][0];
int i = 0, j = 0;
Boolean IsMatched = false;
if (row != 0)
{
foreach (DataRow dr1 in [Link])
{
string PriviousGuestId = [Link][i][4].ToString();
j = 0;
if (i != 0)
{
foreach (DataRow dr in [Link])
{
string CurrentGuestId = [Link][j][4].ToString();
if (PriviousGuestId == CurrentGuestId)
{
if (i == j)
{
break;
}
IsMatched = true;
}
j = j + 1;

}
}
if (!IsMatched)
{
DataRow NewDr = [Link]();
NewDr["GuestId"] = PriviousGuestId;
[Link](NewDr);
[Link]();
ViewState["TempDt"] = TempDt;
}
IsMatched = false;
i = i + 1;
}
int GetRows = [Link];

}
else

{
[Link] = "Record Not Found...!!!";
[Link] = null;
[Link]();
}
}
break;
case "Monthly":
{
string d2 = [Link] + "/" + [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckInDate like '%" + d2 + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
DataTable CheckDt = [Link][0];
int i = 0, j = 0;
Boolean IsMatched = false;
if (row != 0)
{
foreach (DataRow dr1 in [Link])
{
string PriviousGuestId = [Link][i][4].ToString();
j = 0;
if (i != 0)
{
foreach (DataRow dr in [Link])
{
string CurrentGuestId = [Link][j][4].ToString();
if (PriviousGuestId == CurrentGuestId)
{
if (i == j)
{
break;
}
IsMatched = true;
}
j = j + 1;

}
}
if (!IsMatched)
{

DataRow NewDr = [Link]();

NewDr["GuestId"] = PriviousGuestId;
[Link](NewDr);
[Link]();
ViewState["TempDt"] = TempDt;
}
IsMatched = false;
i = i + 1;
}
int GetRows = [Link];
}
else
{
[Link] = "Record Not Found...!!!";
[Link] = null;
[Link]();
}
}
break;
case "Yearly":
{
string d3 = [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckInDate like '%" + d3 + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
DataTable CheckDt = [Link][0];
int i = 0, j = 0;
Boolean DataLoaded = false;
Boolean Execute = false;
Boolean IsMatched = false;
if (row != 0)
{
foreach (DataRow dr in [Link])
{
DataTable MyTable = (DataTable)ViewState["TempDt"];
if (Execute)
{
int LoadedDataRow = [Link];
}
if (DataLoaded)
{

j = 0;
foreach (DataRow dr1 in [Link])
{
string GuestId = [Link][i][4].ToString();
string GuestIdTemp = [Link][j][0].ToString();
if (GuestId == GuestIdTemp)
{
IsMatched = true;
}
j = j + 1;
}
if (!IsMatched)
{
DataRow NewDr = [Link]();
NewDr["GuestId"] = [Link][i][4].ToString();
[Link](NewDr);
[Link]();
ViewState["TempDt"] = TempDt;
Execute = true;

}
}
else
{
DataRow NewDr = [Link]();
NewDr["GuestId"] = [Link][0][4].ToString();
[Link](NewDr);
[Link]();
ViewState["TempDt"] = TempDt;
Execute = true;
}
DataLoaded = true;
i = i + 1;
IsMatched = false;
}
}
else
{
[Link] = "Record Not Found...!!!";
[Link] = null;
[Link]();
}
}
break;
default:
{

}
break;
}
// ViewState["TempDt"] = TempDt;
DataTable ResultTable = new DataTable();
[Link]("Name");
[Link]("DOB");
[Link]("Gender");
[Link]("MobileNo");
[Link]("IdType");
[Link]("IdNo");
[Link]("State");
[Link]("PinNo");
[Link]("GuestId");
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from GuestDetails ",
SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, "GuestDetails");
DataTable dt1 = [Link][0];
int row1 = [Link];
DataTable MyResultTable = (DataTable)ViewState["TempDt"];
//int RowData = [Link];
if (row1 != 0 && MyResultTable != null)
{
int i = 0, j = 0;
foreach (DataRow dr in [Link])
{
i = 0;
foreach (DataRow dr1 in [Link])
{
if ([Link][j][0].ToString() == [Link][i][14].ToString())
{
DataRow NewDR = [Link]();
NewDR["Name"] = [Link][i][0].ToString();
NewDR["DOB"] = [Link][i][2].ToString();
NewDR["Gender"] = [Link][i][3].ToString();
NewDR["MobileNo"] = [Link][i][5].ToString();
NewDR["IdType"] = [Link][i][7].ToString();
NewDR["IdNo"] = [Link][i][8].ToString();
NewDR["State"] = [Link][i][11].ToString();
NewDR["PinNo"] = [Link][i][12].ToString();
NewDR["GuestId"] = [Link][i][14].ToString();
[Link](NewDR);
[Link]();

ViewState["ResultTable"] = ResultTable;
}
i = i + 1;
}
j = j + 1;
}
[Link] = " Total " + [Link]() + " Guest(s)
Records found....!!!";
[Link] = ResultTable;
[Link]();
}
else
{
[Link] = "Guest Records not Found.......!!!!!";
}
}
}
protected void ddlReportType_SelectedIndexChanged(object sender, EventArgs e)
{
string ReportType = [Link]();
switch (ReportType)
{
case "Daily":
{
[Link] = true;
[Link] = true;
[Link] = true;
}
break;
case "Monthly":
{
[Link] = false;
[Link] = true;
[Link] = true;
}
break;
case "Yearly":
{
[Link] = false;
[Link] = false;
[Link] = true;
}
break;
}
}

protected void BntOk_Click(object sender, EventArgs e)

{
[Link] = null;
[Link]();
[Link] = "";
}
protected void CustomValidator1_ServerValidate(object source,
ServerValidateEventArgs args)
{
if ([Link])
{
if ([Link]() == "Day")
{
[Link] = false;
}
else
{
[Link] = true;
}
}
else
{
[Link] = true;
}

}
protected void CustomValidator2_ServerValidate(object source,
ServerValidateEventArgs args)
{
if ([Link])
{
if ([Link]() == "Month")
{
[Link] = false;
}
else
{
[Link] = true;
}
}
else
{
[Link] = true;
}
}
}
}

[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class DeleteRoom : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ReceptionistId"] != null && Session["ReceptionistName"] != null)
{
Session["ReceptionistName"] = Session["ReceptionistName"].ToString();
Session["ReceptionistId"] = Session["ReceptionistId"].ToString();
[Link] = "Hi... " + Session["ReceptionistName"].ToString() + ", "
+ " User-Id:- " + Session["ReceptionistId"].ToString();
}
if (!IsPostBack)
{
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Room ", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Room");
DataTable dt = [Link][0];
int Room = [Link];
if (Room != 0)
{
[Link] = ds;
[Link]();
}
else
{
[Link] = "Not Available Room";
}
}
}

protected void DeleteRoom_Click(object sender, EventArgs e)

{
Button DeleteRoom = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lblRoomNo = (Label)[Link]("lblRoomNo");
string RoomNo = [Link];
Session["RoomNo"] = RoomNo;
[Link]("~/Receptionist/[Link]");
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class DeleteSelectedRoom : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ReceptionistId"] != null && Session["ReceptionistName"] != null)
{
Session["ReceptionistName"] = Session["ReceptionistName"].ToString();
Session["ReceptionistId"] = Session["ReceptionistId"].ToString();
[Link] = "Hi... " + Session["ReceptionistName"].ToString() + ", "
+ " User-Id:- " + Session["ReceptionistId"].ToString();
}
if (!IsPostBack)
{
if (Session["RoomNo"] != null)
{
string RoomNo = Session["RoomNo"].ToString();
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Room where
RoomNo='" + RoomNo + "'", SqlCon);

DataSet ds = new DataSet();

[Link](ds, "Room");
DataTable dt = [Link][0];
int Room = [Link];
if (Room != 0)
{
[Link] = ds;
[Link]();
}
else
{
[Link] = "Room No Could not be selected!!!";
}
}
else
{
[Link] = "First select the room for deletion";
}
}
}
protected void DeleteRoom_Click(object sender, EventArgs e)
{
string SelectedRoomNo = Session["RoomNo"].ToString();
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from Room where
RoomNo='" + SelectedRoomNo + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, "Room");
DataTable dt = [Link][0];
int room = [Link];
if (room != 0)
{
foreach (DataRow dr in [Link])
{
//[Link][0].Rows[0].Delete();
[Link]();
SqlCommandBuilder cb = new SqlCommandBuilder(Sqd);
[Link](dt);
break;
}
[Link] = null;
[Link]();
[Link] = "Room Is Deleted...........!!!!!!!";
[Link] = "Back";

}
else
{
[Link] = "First select a room..........!!!!!!";
}
}
protected void btnCancel_Click(object sender, EventArgs e)
{
if (Session["ComeBack"] == null)
{
if (Session["BackToUpdate"] != null)
{
[Link]("~/Receptionist/[Link]");
}
else
{
[Link]("~/Receptionist/[Link]");
}
}
else
{
[Link]("~/Admin/[Link]");
}
}
}
}
Guest [Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class CustomerReports : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{

if (Session["ReceptionistId"] != null && Session["ReceptionistName"] != null)

{
Session["ReceptionistName"] = Session["ReceptionistName"].ToString();
Session["ReceptionistId"] = Session["ReceptionistId"].ToString();
[Link] = "Hi... " + Session["ReceptionistName"].ToString() + ", "
+ " User-Id:- " + Session["ReceptionistId"].ToString();
}
}
protected void BtnRecord_Click1(object sender, EventArgs e)
{
if ([Link])
{
string GuestType = [Link]();
string RepotrType = [Link]();
if (GuestType == "Check-In-Date")
{
switch (RepotrType)
{
case "Daily":
{
string d1 = [Link] + "/" + [Link] + "/" + [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckInDate like '%" + d1 + "%'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, " BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row >= 0)
{
[Link] = [Link]() + "---Report(s) Found...!!!";
[Link] = ds;
[Link]();
}
else
{
[Link] = "Record Not Found...!!!";
}
}
break;
case "Monthly":
{
string d2 = [Link] + "/" + [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckInDate like '%" + d2 + "'", SqlCon);

DataSet ds = new DataSet();

[Link](ds, " BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row >= 0)
{
[Link] = [Link]() + "---Report(s) Found...!!!";
[Link] = ds;
[Link]();
}
else
{
[Link] = "Record Not Found...!!!";
}
}
break;
case "Yearly":
{
string d3 = [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckInDate like '%" + d3 + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, " BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row >= 0)
{
[Link] = [Link]() + "---Report(s) Found...!!!";
[Link] = ds;
[Link]();
}
else
{
[Link] = "Record Not Found...!!!";
}
}
break;
default:
{
}
break;
}
}
else
{
switch (RepotrType)

{
case "Daily":
{
string d4 = [Link] + "/" + [Link] + "/" + [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckOutDate like '%" + d4 + "%'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, " BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row >= 0)
{
[Link] = [Link]() + "---Report(s) Found...!!!";
[Link] = ds;
[Link]();
}
else
{
[Link] = "";
[Link] = "Record Not Found...!!!";
}
}
break;
case "Monthly":
{
string d5 = [Link] + "/" + [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckOutDate like '%" + d5 + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, " BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row >= 0)
{
[Link] = [Link]() + "---Report(s) Found...!!!";
[Link] = ds;
[Link]();
}
else
{
[Link] = "Record Not Found...!!!";
}
}
break;
case "Yearly":

{
string d6 = [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from
BookedRooms where CheckOutDate like '%" + d6 + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, " BookedRooms");
DataTable dt = [Link][0];
int row = [Link];
if (row >= 0)
{
[Link] = [Link]() + "---Report(s) Found...!!!";
[Link] = ds;
[Link]();
}
else
{
[Link] = "Record Not Found...!!!";
}
}
break;
default:
{
}
break;
}
}
}
}
protected void BtnShowPaymentDetails_Click(object sender, EventArgs e)
{
Button BtnShowPaymentDetails = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label lblBookingId = (Label)[Link]("lblBookingId");
Label LblCheckInDate = (Label)[Link]("LblCheckInDate");
Label LblCheckOutDate = (Label)[Link]("LblCheckOutDate");
string CheckIn = [Link];
string CheckOut = [Link];
string BookingId = [Link];
PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from BookedRooms where
GuestId='" + BookingId + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, " BookedRooms");

DataTable dt = [Link][0];
int rows = [Link];
if (rows > 0)
{
PathStringClass path1 = new PathStringClass();
string DatabasePath1 = path1.Get_path();
SqlConnection SqlCon1 = new SqlConnection(DatabasePath1);
SqlDataAdapter Sqd1 = new SqlDataAdapter("select * from PaymentDetails
where GuestId='" + BookingId + "'", SqlCon1);
DataSet ds1 = new DataSet();
[Link](ds1, " PaymentDetails");
DataTable dt1 = [Link][0];
int rows1 = [Link];
if (rows1 > 0)
{
PathStringClass path2 = new PathStringClass();
string DatabasePath2 = path2.Get_path();
SqlConnection SqlCon2 = new SqlConnection(DatabasePath2);
SqlDataAdapter Sqd2 = new SqlDataAdapter("select * from BookedRooms
where CheckInDate='" + CheckIn + "' and CheckOutDate='" + CheckOut + "'",
SqlCon2);
DataSet ds2 = new DataSet();
[Link](ds2, " BookedRooms");
DataTable dt2 = [Link][0];
int row2 = [Link];
if (row2 > 0)
{
[Link] = ds2;
[Link]();
}
[Link] = "";
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = ds1;
[Link]();
}
else
{
[Link] = "Payment Report Not Found...!!!";
}

}
else
{
PathStringClass path3 = new PathStringClass();
string DatabasePath3 = path3.Get_path();
SqlConnection SqlCon3 = new SqlConnection(DatabasePath3);

SqlDataAdapter Sqd3 = new SqlDataAdapter("select * from

PaymentsFromReceptionist where BookingId='" + BookingId + "'", SqlCon3);
DataSet ds3 = new DataSet();
[Link](ds3, " PaymentsFromReceptionist");
DataTable dt3 = [Link][0];
int rows3 = [Link];
if (rows3 > 0)
{
PathStringClass path2 = new PathStringClass();
string DatabasePath2 = path2.Get_path();
SqlConnection SqlCon2 = new SqlConnection(DatabasePath2);
SqlDataAdapter Sqd2 = new SqlDataAdapter("select * from BookedRooms
where CheckInDate='" + CheckIn + "' and CheckOutDate='" + CheckOut + "'",
SqlCon2);
DataSet ds2 = new DataSet();
[Link](ds2, " BookedRooms");
DataTable dt2 = [Link][0];
int row2 = [Link];
if (row2 > 0)
{
[Link] = ds2;
[Link]();
}
[Link] = "";
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = ds3;
[Link]();
}
else
{
[Link] = "Payment Report Not Found...!!!";
}
}

}
protected void btnShowGuestDetails_Click(object sender, EventArgs e)
{
Button btnShow = (Button)sender;
GridViewRow row = (GridViewRow)[Link];
Label LblGuestId = (Label)[Link]("LblGuestId");
Label LblCheckInDate = (Label)[Link]("LblCheckInDate");
Label LblCheckOutDate = (Label)[Link]("LblCheckOutDate");
string CheckIn = [Link];
string CheckOut = [Link];

string GuestId = [Link];

PathStringClass path = new PathStringClass();
string DatabasePath = path.Get_path();
SqlConnection SqlCon = new SqlConnection(DatabasePath);
SqlDataAdapter Sqd = new SqlDataAdapter("select * from GuestDetails where
GuestId='" + GuestId + "'", SqlCon);
DataSet ds = new DataSet();
[Link](ds, " GuestDetails");
DataTable dt = [Link][0];
int rows = [Link];
if (rows != 0)
{
PathStringClass path2 = new PathStringClass();
string DatabasePath2 = path2.Get_path();
SqlConnection SqlCon2 = new SqlConnection(DatabasePath2);
SqlDataAdapter Sqd2 = new SqlDataAdapter("select * from BookedRooms
where CheckInDate='" + CheckIn + "' and CheckOutDate='" + CheckOut + "'",
SqlCon2);
DataSet ds2 = new DataSet();
[Link](ds2, " BookedRooms");
DataTable dt2 = [Link][0];
int row2 = [Link];
if (row2 > 0)
{
[Link] = ds2;
[Link]();
}
[Link] = "";
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = ds;
[Link]();
}
else
{
[Link] = "Record not found";
}
}
protected void btnClosePaymentDetailsFromGuest_Click(object sender, EventArgs e)
{
[Link] = "";
[Link] = null;
[Link]();
}

protected void btnClosePaymentDetailsFromReceptionist_Click(object sender,

EventArgs e)
{
[Link] = "";
[Link] = null;
[Link]();
}
protected void CloseAllReports_Click(object sender, EventArgs e)
{
[Link] = "";
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
[Link] = null;
[Link]();
}
protected void CloseGuestDetails_Click(object sender, EventArgs e)
{
[Link] = "";
[Link] = null;
[Link]();
}
protected void ddlReportType_SelectedIndexChanged(object sender, EventArgs e)
{
string ReportType = [Link]();
switch (ReportType)
{
case "Daily":
{
[Link] = true;
[Link] = true;
[Link] = true;
}
break;
case "Monthly":
{
[Link] = false;
[Link] = true;
[Link] = true;
}
break;
case "Yearly":
{
[Link] = false;
[Link] = false;

[Link] = true;
}
break;
}
}
protected void CustomValidator1_ServerValidate(object source,
ServerValidateEventArgs args)
{
if ([Link])
{
if ([Link]() == "Day")
{
[Link] = false;
}
else
{
[Link] = true;
}
}
else
{
[Link] = true;
}

}
protected void CustomValidator2_ServerValidate(object source,
ServerValidateEventArgs args)
{
if ([Link])
{
if ([Link]() == "Month")
{
[Link] = false;
}
else
{
[Link] = true;
}
}
else
{
[Link] = true;
}
}
protected void CustomValidator3_ServerValidate(object source,
ServerValidateEventArgs args)

{
if ([Link]() == "Select")
{
[Link] = false;
}
else
{
[Link] = true;
}
}
}
}
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class LogOut : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
[Link]();
[Link]();
[Link]("~/Account/[Link]");
}
}