private void bindGrid()
{
List <DishDetailModel> dishlst = new List <DishDetailModel>();
OracleConnection conn = new OracleConnection(connectionString);
string query = "Select * from dish";
OracleCommand cmd = new OracleCommand(query, conn);
conn.Open();
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DishDetailModel dish = new DishDetailModel();
dish.ID = int.Parse(reader["Dish_ID"].ToString());
dish.DishCode = reader["Dish_code"].ToString();
dish.DishName = reader["DishName"].ToString();
dish.localName = reader["local_or_Another_Name"].ToString();
dishlst.Add(dish);
}
conn.Close();
List <int> ddlst = new List <int>();
ddlst.Add(1);
for (int i = 0; i < ddlst.Count; i++)
{
//ddlBooks.Items.Add(ddlst[i].ToString());
}
//ddlBooks.DataTextField = "";
//ddlBooks.DataValueField
//ddlBooks.DataSource=ddlst;
dgvDishDetail.DataSource = null;
dgvDishDetail.DataSource = dishlst;
dgvDishDetail.DataBind();
}
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
DishDetailModel dish = new DishDetailModel();
//ID, Name, Gender, Qualification FROM Author
GridViewRow row = dgvDishDetail.Rows[e.RowIndex];
dish.ID = int.Parse(dgvDishDetail.DataKeys[e.RowIndex].Values[0].ToString());
//dish.ID = Convert.ToInt32(dgvDishDetail.DataKeys[e.RowIndex].Values[0]);
dish.DishCode = (row.Cells[2].Controls[0] as TextBox).Text;
dish.DishName = (row.Cells[3].Controls[0] as TextBox).Text;
dish.localName = (row.Cells[4].Controls[0] as TextBox).Text;
using (OracleConnection con = new OracleConnection(connectionString))
{
using (OracleCommand cmd = new OracleCommand("update dish set Dish_Code = '" + dish.DishCode + "',DishName = '" + dish.DishName + "',Local_or_Another_Name='" + dish.localName + "' where Dish_ID = " + dish.ID))
{
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
dgvDishDetail.EditIndex = -1;
this.bindGrid();
}
protected void btnAdd_Click1(object sender, EventArgs e)
{
DishDetailModel dish = new DishDetailModel();
dish.DishCode = txtdishcode.Text.ToString();
dish.DishName = txtdishname.Text.ToString();
dish.localName = txtlocalname.Text.ToString();
using (OracleConnection con = new OracleConnection(connectionString))
{
using (OracleCommand cmd = new OracleCommand("Insert into dish(Dish_Code, DishName, Local_or_Another_Name)Values('" + dish.DishCode + "','" + dish.DishName + "','" + dish.localName + "')"))
{
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
txtdishcode.Text = "";
txtdishname.Text = "";
txtlocalname.Text = "";
}
this.bindGrid();
btnAdd.Attributes["onclick"] = "return confirm('Sucessfuully Added');";
}
}
