public bool Update(FoodGroupModel fm)//method for update
{
base.DataAccess();
base.Connect();
string Query = "update FoodsGroup set Name=N'{0}' where ID={1}";
Query = string.Format(Query, fm.Name, fm.Id);
bool res = base.DoCommand(Query);
base.DisConnect();
return(res);
}
public bool Insert(FoodGroupModel fm) //method for adding item
{
base.DataAccess();
base.Connect();
string Query = "insert into FoodsGroup (Name) values (N'{0}')";
Query = string.Format(Query, fm.Name);
bool res = base.DoCommand(Query);
base.DisConnect();
return(res);
}
public bool Delete(FoodGroupModel fm)//method for delet
{
base.DataAccess();
base.Connect();
string Query = "delete from FoodsGroup where Id={0}";
Query = string.Format(Query, fm.Id);
bool res = base.DoCommand(Query);
base.DisConnect();
return(res);
}
protected void FoodGroup_RowCommand(object sender, GridViewCommandEventArgs e)
{
fm = new FoodGroupModel();
int index = Convert.ToInt32(e.CommandArgument);
fm.Id = Convert.ToInt32(FoodGroupList.Rows[index].Cells[3].Text);
if (e.CommandName == "DeleteRow")
{
//re.Id = Convert.ToInt32(RealEstateList.Rows[index].Cells[3].Text);
bool res = fr.Delete(fm);
if (res)
{
string message = "Deleting info was successfully";
string script = "window.onload = function(){ alert('";
script += message;
script += "')};";
ClientScript.RegisterStartupScript(this.GetType(), "SuccessMessage", script, true);
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Inserted Successfully')", true);
}
else
{
string message = "Deleting info was not successfully";
string script = "window.onload = function(){ alert('";
script += message;
script += "')};";
ClientScript.RegisterStartupScript(this.GetType(), "SuccessMessage", script, true);
}
GetData();
}
if (e.CommandName == "EditRow")
{
btnSave.Visible = false;
btnUpdate.Visible = true;
addNew.Visible = true;
showList.Visible = false;
FoodGroupId.Text = FoodGroupList.Rows[index].Cells[3].Text.ToString();
Name.Text = FoodGroupList.Rows[index].Cells[4].Text.ToString();
}
}
