public JsonResult Index(Set_Generic sg)
{
bool status = false;
Set_Generic generic_id = database.Set_Generic_id_Generate();
sg.Generic_id = generic_id.Generic_id;
database.Insert_Generic(sg);
status = true;
return(Json(new { success = status }));
}
public void Insert_Generic(Set_Generic sg)
{
using (SqlConnection conn = new SqlConnection(connectString))
{
using (SqlCommand cmd = new SqlCommand("insert into Set_Generic values (@generic_id,@Icate_id,@Isubcate_id,@Description)", conn))
{
conn.Open();
cmd.Parameters.AddWithValue("@generic_id", sg.Generic_id);
cmd.Parameters.AddWithValue("@Icate_id", sg.Icate_id);
cmd.Parameters.AddWithValue("@Isubcate_id", sg.Isubcate_id);
cmd.Parameters.AddWithValue("@Description", sg.Description);
cmd.ExecuteNonQuery();
}
}
}
//Item_SubCategory End
//Set_Generic start
public Set_Generic Set_Generic_id_Generate()
{
Set_Generic ads = new Set_Generic();
SqlConnection con = new SqlConnection(connectString);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select isnull(max(g.Generic_id),0)+1 Set_Generic from Set_Generic g";
cmd.Connection = con;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
ads.Generic_id = Convert.ToInt16(reader["Set_Generic"]);
reader.Close();
return(ads);
}
public IActionResult Index()
{
Set_Generic generic_id = database.Set_Generic_id_Generate();
ViewBag.Item_sub_cate = generic_id;
List <Item_Category> Item_Cat_dropdown = database.ItemCat_dropdown();
ViewBag.Item_Cat_DD = Item_Cat_dropdown;
List <Item_Sub_Cateogory> Item_Sub_Cat_dropdown = database.Item_Sub_Cat_dropdown();
ViewBag.Item_sub_cat_DD = Item_Sub_Cat_dropdown;
return(View());
}
public IActionResult GetData()
{
Set_Generic generic_id = database.Set_Generic_id_Generate();
return(Json(new { success = true, fetchdata = generic_id.Generic_id }));
}
