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 })); }