Hiiii,
I am trying to develope dashboard to show room booking system.
I am using Datalist and also Nested Datalist inside it.
I am not able to bind Nested DataList inside that list.
Based from Booking_Details table i want to change the Datalist Header color e.g if Status is Booked color = RED etc.
Suggest if any change is required in db structure also.
<asp:DataList ID="dlBooking" runat="server" RepeatColumns="4" RepeatLayout="Table" Width="100%"
OnItemDataBound="dlBooking_ItemDataBound" OnItemCommand="dlBooking_ItemCommand">
<ItemTemplate>
<div class="col-md-12 col-lg-12" style="padding: 5px; width: 100%">
<div class="panel panel-default pnlhover" style="margin-bottom: 10px;" id="pnlHead" runat="server" >
<div class="panel-heading">
<div class="panel-title">
<div class="row">
<div class="col-md-3 col-lg-4">
<b>
<asp:Label ID="lblRoomID" runat="server" Text='<%# Eval("Id") %>' Visible="false" /></b>
<asp:Label ID="lblRoomNo" runat="server" Text='<%# Eval("Room_No") %>' /></b>
</div>
<div class="col-md-8 col-lg-8">
<b>
<asp:Label ID="lblStatus" runat="server" Text='<%# Eval("Room_Status") %>' /></b>
</div>
</div>
</div>
</div>
<div class="panel-body">
<asp:DataList ID="dlBookingDetails" runat="server" RepeatLayout="Table" Width="100%" ShowHeader="true">
<ItemTemplate>
<div class="form-horizontal">
<div class="form-group">
<table class="table" style="margin-bottom: 0px" runat="server" id="listTable" >
<tr>
<td align="center"><b>Booked From :</b></td>
<td>
<asp:Label ID="lblBookFrom" runat="server" Text='<%# Eval("BookedFrom","{0:dd/MMM/yyyy}") %>' /></td>
</tr>
<tr>
<td align="center"><b>Booked To :</b></td>
<td>
<asp:Label ID="lblBookTill" runat="server" Text='<%# Eval("BookedTill","{0:dd/MMM/yyyy}") %>' /></td>
</tr>
</table>
</div>
</div>
</ItemTemplate>
</asp:DataList>
</div>
<div class="panel-footer">
<asp:LinkButton ID="btnBook" runat="server" Text="Book Now" CssClass="btn-success btn-block btn"></asp:LinkButton>
</div>
</div>
</div>
</ItemTemplate>
</asp:DataList>
protected void BindDashBoard()
{
try
{
//SqlCommand cmd = new SqlCommand("select rm.Id,rm.Number as Room_No,rs.Description as Room_Status from MstRoom rm inner join MstRoom_Status rs on rs.ID=rm.Room_Status", hmcon);
SqlCommand cmd = new SqlCommand("Select * ID,Number,Room_Status from MstRoom", hmcon);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
dlBooking.DataSource = dt;
dlBooking.DataBind();
}
catch (Exception)
{
throw;
}
}
Create Table [MstRoom_Type]
(
ID INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
Description NVARCHAR(150) Null
)
Create Table [MstFloor]
(
ID INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
Description NVARCHAR(150) Null
)
Create Table [MstRoom_Status]
(
ID INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
Description NVARCHAR(150) Null
)
Create Table [MstBookMode]
(
ID INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
Description NVARCHAR(150) Null
)
Create Table [MstBook_Status]
(
ID INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
Description NVARCHAR(150) Null
)
CREATE UNIQUE INDEX [piMstRoom] ON [MstRoom] ([ID] ASC);
Create UNIQUE INDEX [piMstRoom_Type] ON [MstRoom_Type] ([ID] ASC);
Create UNIQUE INDEX [piMstFloor] ON [MstFloor] ([ID] ASC);
Create UNIQUE INDEX [piMstRoom_Status] ON [MstRoom_Status] ([ID] ASC);
Create UNIQUE INDEX [piMstBookMode] ON [MstBookMode] ([ID] ASC);
Create UNIQUE INDEX [piMstBook_Status] ON [MstBook_Status] ([ID] ASC);
ALTER TABLE [MstRoom] ADD CONSTRAINT [fkMstRoomMstType] FOREIGN
KEY([Room_Type]) REFERENCES [MstRoom_Type] ([ID]);
ALTER TABLE [MstRoom] ADD CONSTRAINT [fkMstRoomMstFloor] FOREIGN
KEY([Floor_Num]) REFERENCES [MstFloor] ([ID]);
ALTER TABLE [MstRoom] ADD CONSTRAINT [fkMstRoomMstStatus] FOREIGN
KEY([Room_Status]) REFERENCES [MstRoom_Status] ([ID]);
Create table MstGuest
(
ID INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
Name NVARCHAR(150) Null,
LastName NVARCHAR(150) Null,
Gender INT Null,
Address NVARCHAR(150) Null,
City INT Null,
Mobile BIGINT Null,
Email NVARCHAR(200) Null,
Company NVARCHAR(200)
);
Create UNIQUE INDEX [piMstGuest] ON [MstGuest] ([ID] ASC );
Create table Booking_Master
(
ID INT IDENTITY (1,1) PRIMARY KEY NOT NULL,
NO_Persons INT Null,
NO_Rooms INT Null,
Book_Date DATE NOT Null,
Guest_ID INT NOT Null,
)
Create UNIQUE INDEX [piBooking_Master] ON [Booking_Master] ([ID] ASC );
ALTER TABLE [Booking_Master] ADD CONSTRAINT [fkMstBookMstGuest] FOREIGN
KEY([Guest_ID]) REFERENCES [MstGuest] ([ID]);
Create table Book_Details
(
ID INT IDENTITY (1,1) PRIMARY KEY NOT NULL,
CheckIN_Date DATE NOT Null,
CheckIN_Time Time Not Null,
CheckOUT_Date DATE NOT Null,
CheckOUT_Time Time Not Null,
Room_ID INT NOT Null,
Book_Status INT NOT Null,
Book_Mode INT NOT Null,
Book_Master_ID INT NOT Null
)
Create UNIQUE INDEX [piBook_Details] ON [Book_Details] ([ID] ASC );
ALTER TABLE [Book_Details] ADD CONSTRAINT [fkMstBookStatusBookDtl] FOREIGN
KEY([Room_ID]) REFERENCES [MstRoom] ([ID]);
ALTER TABLE [Book_Details] ADD CONSTRAINT [fkMstRoomBookDtl] FOREIGN
KEY([Book_Status]) REFERENCES [MstBook_Status] ([ID]);
ALTER TABLE [Book_Details] ADD CONSTRAINT [fkMstBookModeBookDtl] FOREIGN
KEY([Book_Mode]) REFERENCES [MstBookMode] ([ID]);
ALTER TABLE [Book_Details] ADD CONSTRAINT [fkMstBookBookDtl] FOREIGN
KEY([Book_Master_ID]) REFERENCES [Booking_Master] ([ID]);
Create Table [MstRoom]
(
ID INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
Number NVARCHAR(150) Null,
Price Float ,
Room_Type int,
Floor_Num int Null,
Room_Status INT Null
);
