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