//public JsonResult GetMenu([DataSourceRequest] DataSourceRequest request) //{ // IDbConnection db = new OrmliteConnection().openConn(); // try // { // var listMenu = db.Select<Auth_Menu>(p => p.IsVisible == true).OrderBy(p => p.MenuIndex).ToList(); // DataSourceResult dsr = new DataSourceResult(); // dsr.Data = listMenu; // return Json(dsr, JsonRequestBehavior.AllowGet); // } // catch (Exception e) // { // return Json(new { success = false, message = e.Message }); // } // finally { db.Close(); } //} //[HttpPost] public JsonResult GetMenu(string action, int roleID) { IDbConnection db = new OrmliteConnection().openConn(); try { //select list menu cha List <Auth_Menu> lstFirstMenu = db.Select <Auth_Menu>("IsVisible = 1 AND ParentMenuID ='' AND MenuID <> 'Home'").OrderBy(p => p.MenuIndex).ToList(); List <Auth_Menu> allAuthMenu = db.Select <Auth_Menu>("IsVisible = 1 AND MenuID <> 'Home'").OrderBy(p => p.MenuIndex).ToList(); var listAction = new List <Auth_Menu>(); if (!string.IsNullOrEmpty(action)) { listAction = db.SqlList <Auth_Menu>("p_Auth_Menu_Select_By_Action '" + action + "', " + roleID); } List <AuthMenuViewModel> lstMenuView = new List <AuthMenuViewModel>(); foreach (Auth_Menu der in lstFirstMenu) { AuthMenuViewModel node = new AuthMenuViewModel(); node.id = der.MenuID; node.text = der.MenuName; node.items = new List <AuthMenuViewModel>(); AddChidrenNode(ref node, allAuthMenu, listAction); lstMenuView.Add(node); } return(Json(new { success = true, Data = lstMenuView })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public JsonResult GetCustomerHirerachy(string customerid) { IDbConnection db = new OrmliteConnection().openConn(); try { //select list menu cha List <CustomerHirerachy> lstFirstMenu = db.Select <CustomerHirerachy>("Status = 1 AND ParentCustomerHirerachyID ='' ").OrderBy(p => p.CustomerHirerachyIndex).ToList(); List <CustomerHirerachy> allCustomerHirerachy = db.Select <CustomerHirerachy>("Status = 1 ").OrderBy(p => p.CustomerHirerachyIndex).ToList(); var listCustomer = new List <CustomerHirerachy>(); if (!string.IsNullOrEmpty(customerid)) { listCustomer = db.SqlList <CustomerHirerachy>("p_CustomerHirerachy_Select '" + customerid + "'"); } List <CustomerHirerachyViewModel> lstMenuView = new List <CustomerHirerachyViewModel>(); foreach (CustomerHirerachy der in lstFirstMenu) { CustomerHirerachyViewModel node = new CustomerHirerachyViewModel(); node.id = der.CustomerHirerachyID; node.text = der.CustomerHirerachyName; node.items = new List <CustomerHirerachyViewModel>(); AddChildrenNode(ref node, allCustomerHirerachy, listCustomer); lstMenuView.Add(node); } return(Json(new { success = true, Data = lstMenuView })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public List <Merchant_Product_Related> ReadAll(string connectionString, string ma_san_pham) { //List<SqlParameter> param = new List<SqlParameter>(); //return new SqlHelper(connectionString).ExecuteString("select * from Merchant_Product", param); using (var db = new OrmliteConnection().openConn(connectionString)) { return(db.SqlList <Merchant_Product_Related>("EXEC _p_Get_Product_Related @ma_san_pham", new { ma_san_pham = ma_san_pham })); } }