private void BindTheGrid()
{
using (DemoDatabaseDB db = new DemoDatabaseDB())
{
var listP = db.PersonalDetails;
var listF = db.Files;
var data = from p in listP
join f in listF
on p.AutoId equals f.PersonalDetailsId
where p.FirstName.Contains("S")
select new
{
f.FileName,
p.Active,
p.Age,
p.AutoId,
p.FirstName,
p.LastName
};
GridView1.DataSource = data;
GridView1.DataBind();
}
}
void ListRecords()
{
using (DemoDatabaseDB db = new DemoDatabaseDB())
{
GridView1.DataSource = db.PersonalDetails;
GridView1.DataBind();
GridView2.DataSource = db.Menus;
GridView2.DataBind();
}
}
protected void DeleteRecord(object sender, EventArgs e)
{
using (DemoDatabaseDB db = new DemoDatabaseDB())
{
PersonalDetail p = db.PersonalDetails.Where(pp => pp.AutoId.Equals(52)).FirstOrDefault();
db.PersonalDetails.DeleteObject(p);
db.SaveChanges();
}
lblMessage.Text = "Record delete from the database successfully!";
}
/// <summary>
/// Binds the grid.
/// </summary>
private void BindTheGrid()
{
using (DemoDatabaseDB db = new DemoDatabaseDB())
{
var data = from d in db.PersonalDetails
where d.FirstName.Contains("S")
select d;
var datas = db.PersonalDetails.OrderBy(p => p.FirstName).Take(5).Skip(2);
GridView1.DataSource = db.PersonalDetails; //data;
GridView1.DataBind();
}
}
protected void UpdateRecord(object sender, EventArgs e)
{
using (DemoDatabaseDB db = new DemoDatabaseDB())
{
PersonalDetail p = db.PersonalDetails.Where(pp => pp.AutoId.Equals(52)).FirstOrDefault();
p.Active = false;
p.Age = 30;
p.FirstName = "Ranjit modified";
p.LastName = "Mahato modified";
db.SaveChanges();
}
lblMessage.Text = "Record updated to the database successfully!";
}
protected void InsertRecord(object sender, EventArgs e)
{
PersonalDetail p = new PersonalDetail()
{
Active = true,
Age = 20,
FirstName = "Ranjit",
LastName = "Mahato"
};
using (DemoDatabaseDB db = new DemoDatabaseDB())
{
db.PersonalDetails.AddObject(p);
db.SaveChanges();
}
lblMessage.Text = "Record added to the database successfully!";
}
protected void SubmitData(object sender, EventArgs e)
{
int id = 0;
int.TryParse(txtAutoId.Text.Trim(), out id);
if (!id.Equals(0))
{
using (DemoDatabaseDB db = new DemoDatabaseDB())
{
var data = db.GetRecords(id);
GridView1.DataSource = data;
GridView1.DataBind();
}
}
else
{
lblMessage.Text = "Please enter numeric value only !";
}
}
protected void SaveUsingLinqWithTransaction(object sender, EventArgs e)
{
using (TransactionScope scope = new TransactionScope())
{
try
{
using (DemoDatabaseDB db = new DemoDatabaseDB())
{
PersonalDetail p = new PersonalDetail()
{
Active = true,
Age = int.MaxValue,
FirstName = "firstnamne",
LastName = "lastname"
};
db.PersonalDetails.AddObject(p);
db.SaveChanges();
DemoDatabaseModel.Menu m = new DemoDatabaseModel.Menu()
{
MenuDescription = "description1",
MenuName = "Menu1Menu1Menu1Menu1Menu1Menu1Menu21", //Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1",
MenuUrl = "http://www.fundooVideo.com/",
ParentMenuId = 1,
MenuId = 127
};
db.Menus.AddObject(m);
db.SaveChanges();
}
scope.Complete();
}
catch (Exception ee)
{
Response.Write(ee.ToString());
}
}
}
