public ActionResult Edit_Item(int id) { List <Item_Model> item_list = new List <Item_Model>(); Item_Model item = new Item_Model(); dict.Clear(); dict.Add("@id", id); dict.Add("@mode", "Getall_Items_ById"); DataTable dt = common_class.return_datatable(dict, "proc_item"); int j = dt.Rows.Count; if (j > 0) { item.id = Convert.ToInt32(dt.Rows[0]["id"].ToString()); item.Item_id = dt.Rows[0]["item_id"].ToString(); item.item_name = dt.Rows[0]["Item_Name"].ToString(); item.category = dt.Rows[0]["category"].ToString(); item.sub_category = dt.Rows[0]["Sub_category"].ToString(); item.UOM = dt.Rows[0]["Uom"].ToString(); item.UOM_value = Convert.ToInt32(dt.Rows[0]["Uom_value"].ToString()); item.rate = Convert.ToDouble(dt.Rows[0]["rate"].ToString()); item.Scheme_values = Convert.ToInt32(dt.Rows[0]["Scheme_value"].ToString()); item.scheme_qty = Convert.ToInt32(dt.Rows[0]["Scheme_Quantity"].ToString()); item.gst = Convert.ToInt32(dt.Rows[0]["Gst"].ToString()); } ViewBag.get_Edit_item = item; return(View(item)); }
public ActionResult Insert_Item(Item_Model item) { dict.Clear(); // dict.Add("@id",item.id); dict.Add("@Item_Name", item.item_name); dict.Add("@category", item.category); dict.Add("@Sub_category", item.sub_category); dict.Add("@Uom", item.UOM); dict.Add("@Uom_value", item.UOM_value); dict.Add("@rate", item.rate); dict.Add("@Scheme_value", item.Scheme_values); dict.Add("@Scheme_Quantity", item.scheme_qty); dict.Add("@Gst", item.gst); dict.Add("@mode", "insert"); var Result = common_class.return_nonquery(dict, "proc_item"); return(Json(Result, JsonRequestBehavior.AllowGet)); }
public void elimItem() { Item_Model obj = new Item_Model(); obj.elim_item(); }
public void updItem() { Item_Model obj = new Item_Model(); obj.upt_item(); }
public void insertItem() { Item_Model obj = new Item_Model(); obj.insert_item(); }
//Insertar items public void selCmbox() { Item_Model obj = new Item_Model(); obj.sel_cmbox(); }
//Listar items public void listarItems() { Item_Model obj = new Item_Model(); obj.listar_items(); }