private void BindGridData()
{
CustomerEntities jde = new CustomerEntities();
var result = from emp in jde.CustomerDatas
select
new
{
CustID = emp.CustId,
Name = emp.Name,
Country = emp.Country,
};
DataGrid.DataSource = result.ToList();
DataGrid.DataBind();
}
protected void Del_Click(object sender, EventArgs e)
{
try
{
CustomerData j = new CustomerData();
j.CustId = Convert.ToInt32(CustID_text.Text);
using (CustomerEntities jde = new CustomerEntities())
{
CustomerData del = jde.CustomerDatas.FirstOrDefault(d => (d.CustId == j.CustId));
jde.CustomerDatas.Remove(del);
jde.SaveChanges();
}
message.Text = "Deleted Sucessfully";
// BindGridData();
}
catch (Exception ex)
{
message.Text = "Somthing went wrong please check Employee ID details again.";
}
}
protected void Create_bttn_Click(object sender, EventArgs e)
{
try
{
CustomerData j = new CustomerData();
j.CustId = Convert.ToInt32(CustID_text.Text);
j.Name = Name_text.Text;
j.Country = Country_text.Text;
using (CustomerEntities jde = new CustomerEntities())
{
jde.CustomerDatas.Add(j);
jde.SaveChanges();
}
message.Text = "Inserted Sucessfully";
// BindGridData();
}
catch (Exception ex)
{
message.Text = "Something went wrong";
}
}
protected void update_bttn_Click(object sender, EventArgs e)
{
// VisibilityCheck(true, true, true);
try
{
CustomerData j = new CustomerData();
using (CustomerEntities jde = new CustomerEntities())
{
j.CustId = Convert.ToInt32(CustID_text.Text);
j = jde.CustomerDatas.FirstOrDefault(d => d.CustId == j.CustId);
j.Name = Name_text.Text;
j.Country = Country_text.Text;
jde.SaveChanges();
}
message.Text = "Updated Sucessfully";
// BindGridData();
}
catch (Exception ex)
{
message.Text = "Somthing went wrong, Employee Does not exist";
}
}
