public HttpResponseMessage GetMenus(MenuBindingParameter model) { if (model == null)// Incase Post Object Is Null or Not Match and Object value is null { result = new ReponseMessage(MsgNo: HttpStatusCode.BadRequest.ToCode(), MsgType: MsgTypeEnum.E.ToString(), Message: "Object is null"); return(Request.CreateResponse(HttpStatusCode.BadRequest, result)); } if (ModelState.IsValid) { List <MenuBindingDetailsParameter> _MenuBindingDetailsParameter = MenuBindingServices.GetMenus(model); if (_MenuBindingDetailsParameter != null) { if (_MenuBindingDetailsParameter.Count != 0) { return(Request.CreateResponse(HttpStatusCode.OK, JsonConvert.SerializeObject(_MenuBindingDetailsParameter))); } else { result = new ReponseMessage(MsgNo: HttpStatusCode.BadRequest.ToCode(), MsgType: MsgTypeEnum.E.ToString(), Message: "Object is null"); return(Request.CreateResponse(HttpStatusCode.BadRequest, result)); } } else { result = new ReponseMessage(MsgNo: HttpStatusCode.BadRequest.ToCode(), MsgType: MsgTypeEnum.E.ToString(), Message: "Object is null"); return(Request.CreateResponse(HttpStatusCode.BadRequest, result)); } } return(null); }
public static List <MenuBindingDetailsParameter> GetMenus(MenuBindingParameter filter) { List <MenuBindingDetailsParameter> menus = new List <MenuBindingDetailsParameter>(); try { //sp_auth_user using (MySqlConnection conn = new MySqlConnection(connectionString)) { MySqlCommand cmd = new MySqlCommand("sp_menu_getmenus", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@_user_code", MySqlDbType.String).Value = filter._user_code; conn.Open(); using (IDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { MenuBindingDetailsParameter _MenuBindingDetailsParameter = new MenuBindingDetailsParameter(); _MenuBindingDetailsParameter.id = dr.IsNull <int>("id"); _MenuBindingDetailsParameter.name = dr.IsNull <string>("name"); _MenuBindingDetailsParameter.iconClass = dr.IsNull <string>("iconClass"); //if (dr.IsNull<int>("active")==0) //{ // _MenuBindingDetailsParameter.active = false; //} //else //{ // _MenuBindingDetailsParameter.active = true; //} _MenuBindingDetailsParameter.url = dr.IsNull <string>("url"); menus.Add(_MenuBindingDetailsParameter); } } } return(menus); } catch (Exception e) { return(null); } }
public static List <MenuBindingDetailsParameter> GetMenus(MenuBindingParameter filter) { return(MenuBinding.GetMenus(filter)); }