public void Insert_Item_SubCategory(Item_Sub_Cateogory isc, string Status)
{
using (SqlConnection conn = new SqlConnection(connectString))
{
using (SqlCommand cmd = new SqlCommand("insert into Item_SubCategory values (@Isubcate_id,@Icate_id,@Description,@Remarks,@Status)", conn))
{
conn.Open();
cmd.Parameters.AddWithValue("@Isubcate_id", isc.Isubcate_id);
cmd.Parameters.AddWithValue("@Icate_id", isc.Icate_id);
cmd.Parameters.AddWithValue("@Description", isc.Description);
if (String.IsNullOrEmpty(isc.Remarks))
{
cmd.Parameters.AddWithValue("@Remarks", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Remarks", isc.Remarks);
}
cmd.Parameters.AddWithValue("@Status", Status);
cmd.ExecuteNonQuery();
}
}
}
public JsonResult Index(Item_Sub_Cateogory isc)
{
string R_Status = null;
bool status = false;
if (isc.Status == true)
{
R_Status = "Y";
}
else
{
R_Status = "N";
}
Item_Sub_Cateogory Item_sub_cat = database.Item_Sub_Cateogory_id_Generate();
isc.Isubcate_id = Item_sub_cat.Isubcate_id;
database.Insert_Item_SubCategory(isc, R_Status);
status = true;
return(Json(new { success = status }));
}
public IActionResult Index()
{
Item_Sub_Cateogory Item_sub_cat = database.Item_Sub_Cateogory_id_Generate();
ViewBag.Item_sub_cate = Item_sub_cat;
List <Item_Category> Item_Cat_dropdown = database.ItemCat_dropdown();
ViewBag.Item_Cat_DD = Item_Cat_dropdown;
return(View());
}
//Item_Menuf_Type end
//Item_SubCategory start
public Item_Sub_Cateogory Item_Sub_Cateogory_id_Generate()
{
Item_Sub_Cateogory ads = new Item_Sub_Cateogory();
SqlConnection con = new SqlConnection(connectString);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select isnull(max(c.Isubcate_id),0)+1 isubcate from Item_SubCategory c";
cmd.Connection = con;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
ads.Isubcate_id = Convert.ToInt16(reader["isubcate"]);
reader.Close();
return(ads);
}
public List <Item_Sub_Cateogory> Item_Sub_Cat_dropdown()
{
List <Item_Sub_Cateogory> DBase = new List <Item_Sub_Cateogory>();
using (SqlConnection conn = new SqlConnection(connectString))
{
using (SqlCommand cmd = new SqlCommand("select s.Isubcate_id, s.Description from Item_SubCategory s", conn))
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Item_Sub_Cateogory emp = new Item_Sub_Cateogory();
emp.Isubcate_id = Convert.ToInt16(reader["Isubcate_id"]);
emp.Description = reader["Description"].ToString();
DBase.Add(emp);
}
}
}
return(DBase);
}
public IActionResult GetData()
{
Item_Sub_Cateogory Item_sub_cat = database.Item_Sub_Cateogory_id_Generate();
return(Json(new { success = true, fetchdata = Item_sub_cat.Isubcate_id }));
}
