public ActionResult Create()
{
SubMenuHeading subMenuHeading = new SubMenuHeading();
subMenuHeading.MainMenuList = BindMainMenu();
return(View(subMenuHeading));
}
public ActionResult EditPost(SubMenuHeading subMenuHeading)
{
if (ModelState.IsValid)
{
IObjSubMenuData.UpdateSubMenuHeading(subMenuHeading);
}
subMenuHeading.MainMenuList = BindMainMenu();
return(View(subMenuHeading));
}
public int DeleteSubMenuHeading(SubMenuHeading subMenuHeading)
{
using (SqlConnection con = new SqlConnection(dbcs))
{
var parameter = new DynamicParameters();
parameter.Add("@SubMenuHeadingID", subMenuHeading.SubMenuHeadingID);
parameter.Add("@SubMenuHeadingIDD", dbType: System.Data.DbType.Int32, direction: ParameterDirection.Output);
con.Execute("Delete_SubMenuHeading", parameter, null, 0, commandType: CommandType.StoredProcedure);
int value = parameter.Get <int>("SubMenuHeadingIDD");
return(value);
}
}
public int InsertSubMenuHeading(SubMenuHeading subMenuHeading)
{
using (SqlConnection con = new SqlConnection(dbcs))
{
var parameter = new DynamicParameters();
parameter.Add("@SubMenuHeadingText", subMenuHeading.SubMenuHeadingText);
parameter.Add("@MainMenuID", subMenuHeading.MainMenuID);
parameter.Add("@IsActive", subMenuHeading.IsActive);
parameter.Add("@SubMenuHeadingID", dbType: DbType.Int32, direction: ParameterDirection.Output);
con.Execute("Save_SubMenuHeading", parameter, null, 0, commandType: CommandType.StoredProcedure);
int value = parameter.Get <int>("SubMenuHeadingID");
return(value);
}
}
public ActionResult Edit(int id)
{
SubMenuHeading subMenuHeading = new SubMenuHeading();
subMenuHeading.SubMenuHeadingID = id;
subMenuHeading = IObjSubMenuData.GetSubMenuHeadingByID(subMenuHeading);
subMenuHeading.MainMenuList = BindMainMenu();
subMenuHeading.MainMenuList.Select(x => x.MainMenuID = id);
return(View(subMenuHeading));
}
public ActionResult Create(SubMenuHeading subMenuHeading)
{
if (ModelState.IsValid)
{
IObjSubMenuData.InsertSubMenuHeading(subMenuHeading);
}
else
{
ModelState.AddModelError("Error", "Please Enter Full Details");
}
subMenuHeading.MainMenuList = BindMainMenu();
return(View(subMenuHeading));
}
public SubMenuHeading GetSubMenuHeadingByID(SubMenuHeading subMenuHeading)
{
using (SqlConnection con = new SqlConnection(dbcs))
{
var parameter = new DynamicParameters();
parameter.Add("@SubMenuHeadingID", subMenuHeading.SubMenuHeadingID);
try
{
return(con.Query <SubMenuHeading>("Load_SubMenuHeading_By_ID", parameter, null, true, 0, commandType: CommandType.StoredProcedure).Single());
}
catch
{
return(null);
}
}
}
public ActionResult DeletePerManent(int id)
{
SubMenuHeading subMenuHeading = new SubMenuHeading();
subMenuHeading.SubMenuHeadingID = id;
int value = IObjSubMenuData.DeleteSubMenuHeading(subMenuHeading);
if (value > 0)
{
TempData["Message"] = "Record Deleted Successfully";
}
else
{
TempData["Message"] = "Something Went Wrong";
}
return(View("Delete"));
}
public ActionResult Delete(int id)
{
SubMenuHeading subMenuHeading = new SubMenuHeading();
subMenuHeading.SubMenuHeadingID = id;
subMenuHeading.MainMenuList = BindMainMenu();
subMenuHeading.MainMenuList.Select(x => x.MainMenuID = id);
subMenuHeading = IObjSubMenuData.GetSubMenuHeadingByID(subMenuHeading);
if (subMenuHeading == null)
{
TempData["Message"] = "No Records Found";
return(View());
}
return(View(subMenuHeading));
}
