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