public int Ins_Menu(SGP_Entity.Menu CP) { try { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cnx"].ConnectionString)) { con.Open(); using (SqlCommand com = new SqlCommand("Sp_Ins_Menu", con)) { com.CommandType = CommandType.StoredProcedure; com.Parameters.Add("@de_menu", SqlDbType.VarChar, 100).Value = CP.de_menu; com.Parameters.Add("@nr_padre", SqlDbType.Int).Value = CP.nr_padre; com.Parameters.Add("@nr_hijo", SqlDbType.Int).Value = CP.nr_hijo; com.Parameters.Add("@nr_posicion", SqlDbType.Int).Value = CP.nr_posicion; com.Parameters.Add("@de_icono", SqlDbType.VarChar, 100).Value = CP.de_icono; com.Parameters.Add("@de_url", SqlDbType.VarChar, 100).Value = CP.de_url; com.ExecuteNonQuery(); return(0); } } } catch (Exception) { throw; } }
public List <SGP_Entity.Menu> Sel_Menu(SGP_Entity.Menu C) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cnx"].ConnectionString)) { con.Open(); using (SqlCommand com = new SqlCommand("Sp_Sel_MENU", con)) { com.CommandType = CommandType.StoredProcedure; com.Parameters.Add("@de_menu", SqlDbType.Int).Value = C.de_menu; List <SGP_Entity.Menu> list = new List <SGP_Entity.Menu>(); using (IDataReader dataReader = com.ExecuteReader()) { while (dataReader.Read()) { SGP_Entity.Menu obj = new SGP_Entity.Menu(); if (dataReader["co_menu"] != DBNull.Value) { obj.co_menu = (int)dataReader["co_menu"]; } if (dataReader["de_menu"] != DBNull.Value) { obj.de_menu = (string)dataReader["de_menu"]; } if (dataReader["nr_padre"] != DBNull.Value) { obj.nr_padre = (int)dataReader["nr_padre"]; } if (dataReader["nr_hijo"] != DBNull.Value) { obj.nr_hijo = (int)dataReader["nr_hijo"]; } if (dataReader["nr_posicion"] != DBNull.Value) { obj.nr_posicion = (int)dataReader["nr_posicion"]; } if (dataReader["de_icono"] != DBNull.Value) { obj.de_icono = (string)dataReader["de_icono"]; } if (dataReader["de_url"] != DBNull.Value) { obj.de_url = (string)dataReader["de_url"]; } list.Add(obj); } } return(list); } } }
public JsonResult Del_Menu(SGP_Entity.Menu Datos) { try { Datos.co_usuario_eliminacion = HttpContext.Application["gUsuario"].ToString(); var data = Menu.Instance.Del_Menu(Datos); return(Json(data, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(e.Message, JsonRequestBehavior.AllowGet)); } }
public int Del_Menu(SGP_Entity.Menu CP) { try { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cnx"].ConnectionString)) { con.Open(); using (SqlCommand com = new SqlCommand("Sp_Del_Menu", con)) { com.CommandType = CommandType.StoredProcedure; com.Parameters.Add("@co_menu", SqlDbType.Int).Value = CP.co_menu; com.Parameters.Add("@co_usuario_eliminacion", SqlDbType.Char, 20).Value = CP.co_usuario_eliminacion; com.ExecuteNonQuery(); return(0); } } } catch (Exception) { throw; } }
public JsonResult CargaGrilla(SGP_Entity.Menu Datos) { var data = Menu.Instance.Sel_Menu(Datos); return(Json(data, JsonRequestBehavior.AllowGet)); }