public IActionResult Index()
{
Item_Menuf_Type Item_Menuf = database.Item_Menuf_type_id_Generate();
ViewBag.Item_Menuf_id = Item_Menuf;
List <Item_Category> Item_Cat_dropdown = database.ItemCat_dropdown();
ViewBag.Item_Cat_DD = Item_Cat_dropdown;
return(View());
}
public JsonResult Index(Item_Menuf_Type imt)
{
bool status = false;
Item_Menuf_Type Item_Menuf = database.Item_Menuf_type_id_Generate();
imt.Mtype_id = Item_Menuf.Mtype_id;
database.Insert_Item_Menuf_Type(imt);
status = true;
return(Json(new { success = status }));
}
public void Insert_Item_Menuf_Type(Item_Menuf_Type imt)
{
using (SqlConnection conn = new SqlConnection(connectString))
{
using (SqlCommand cmd = new SqlCommand("insert into Item_Menuf_Type values (@Mtype_id,@Icate_id,@Description)", conn))
{
conn.Open();
cmd.Parameters.AddWithValue("@Mtype_id", imt.Mtype_id);
cmd.Parameters.AddWithValue("@Icate_id", imt.Icate_id);
cmd.Parameters.AddWithValue("@Description", imt.Description);
cmd.ExecuteNonQuery();
}
}
}
//Item_Category End
//Item_Menuf_Type start
public Item_Menuf_Type Item_Menuf_type_id_Generate()
{
Item_Menuf_Type ads = new Item_Menuf_Type();
SqlConnection con = new SqlConnection(connectString);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select isnull(max(c.Mtype_id),0)+1 Mtype_id from Item_Menuf_Type c";
cmd.Connection = con;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
ads.Mtype_id = Convert.ToInt16(reader["Mtype_id"]);
reader.Close();
return(ads);
}
public IActionResult GetData()
{
Item_Menuf_Type Item_Menuf = database.Item_Menuf_type_id_Generate();
return(Json(new { success = true, fetchdata = Item_Menuf.Mtype_id }));
}
