|
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using SampleDbModel;
public partial class AddAsset : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false)
{
using (SampleDbEntities entities = new SampleDbEntities())
{
var roomsData = entities.Rooms;
drpRooms.DataSource = roomsData;
drpRooms.DataTextField = "RoomName";
drpRooms.DataValueField = "RoomID";
drpRooms.DataBind();
}
FetchAssetsData();
}
}
protected void drpRooms_SelectedIndexChanged(object sender, EventArgs e)
{
FetchAssetsData();
}
private void FetchAssetsData()
{
using (SampleDbEntities entities = new SampleDbEntities())
{
// Let us get the selected rooms ID
string selectedValue = drpRooms.SelectedValue;
int roomIndex = Convert.ToInt32(selectedValue);
// Now let us fetch the selected room entity
Room selectedRoom = entities.Rooms.SingleOrDefault<Room>(room => room.RoomID == roomIndex);
// Now let us utilize the relationship to extract the assets associated with this room
GridAssets.DataSource = selectedRoom.Assets;
GridAssets.DataBind();
}
}
protected void btnAddAsset_Click(object sender, EventArgs e)
{
using (SampleDbEntities entities = new SampleDbEntities())
{
// Let us get the selected rooms ID
string selectedValue = drpRooms.SelectedValue;
int roomIndex = Convert.ToInt32(selectedValue);
// Now let us fetch the selected room entity
Room selectedRoom = entities.Rooms.SingleOrDefault<Room>(room => room.RoomID == roomIndex);
// Lets create the new asset to add to db
Asset asset = new Asset();
asset.AssetName = txtAddAsset.Text;
// Now let us utilize the relationship to Add the asset into db with proper relation with selected room
selectedRoom.Assets.Add(asset);
// Persist the changes in the database
entities.SaveChanges();
}
FetchAssetsData();
}
}
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
I Started my Programming career with C++. Later got a chance to develop Windows Form applications using C#. Currently using C#, ASP.NET & ASP.NET MVC to create Information Systems, e-commerce/e-governance Portals and Data driven websites.
My interests involves Programming, Website development and Learning/Teaching subjects related to Computer Science/Information Systems. IMO, C# is the best programming language and I love working with C# and other Microsoft Technologies.
- Microsoft Certified Technology Specialist (MCTS): Web Applications Development with Microsoft .NET Framework 4
- Microsoft Certified Technology Specialist (MCTS): Accessing Data with Microsoft .NET Framework 4
- Microsoft Certified Technology Specialist (MCTS): Windows Communication Foundation Development with Microsoft .NET Framework 4
If you like my articles, please visit my website for more: www.rahulrajatsingh.com[^]