public IEnumerable <MenuVM> GetPluginMenuDetailList(string userId) { try { using (BSDBEntities EF = new BSDBEntities()) { var menus = EF.TBL_PlugIns.Where(x => x.IsFreeToAll.Value).Join(EF.TBL_Page_Plugins, x => x.PlugInID, y => y.PlugInID, (x, y) => new { x.PlugInID, y.PageID }).Join(EF.TBL_Page_Menues , p => p.PageID, m => m.PageID, (p, m) => new { p.PageID, p.PlugInID, m.MenuID }).Join(EF.TBL_Menues, pm => pm.MenuID , mid => mid.MenuID, (pm, mid) => new { pm.PageID, mid.MenuName, mid.MenuID, mid.ParentMenuId, mid.MenuIconPath }) .Join(EF.TBL_Pages, pmid => pmid.PageID, TP => TP.PageID, (pmid, TP) => new MenuVM() { PageId = pmid.PageID, MenuName = pmid.MenuName, MenuURL = TP.PageURL, ParentMenuId = pmid.ParentMenuId.Value, MenuID = pmid.MenuID, MenuIconPath = pmid.MenuIconPath }).Select(u => u) .Union(EF.TBL_Menues.Where(mainMenu => mainMenu.ParentMenuId == null).Select( mms => new MenuVM() { PageId = 0, MenuName = mms.MenuName, MenuURL = "#", ParentMenuId = 0, MenuID = mms.MenuID, MenuIconPath = mms.MenuIconPath } )) .ToArray(); // var result = new BSEntityFramework_ResultType(BSResult.Success, Menus, null, //"Success"); return(menus); } } catch (DbEntityValidationException dbValidationEx) { return(null); } catch (Exception ex) { var logact = new LoggerActivity(); var result = new BSEntityFramework_ResultType(BSResult.Fail, userId, null, "Technical issue"); logact.ErrorSetup("WebApp", "Menu list Failed", "", "", "", ex.Message); return(null); } }
public BSEntityFramework_ResultType ValidateLogin(string userId) { try { using (BSDBEntities EF = new BSDBEntities()) { var Userid = EF.TBL_ShopLoginDetails.Where(p => p.LoginName == userId).Select(x => x.ShopLoginDetailsID).First(); if (Userid > 0) { Plugins_Activity obj = new Plugins_Activity(); var menus = obj.GetPluginMenuDetailList(userId); var shopAssignedList = GetShopAssignedList(userId); var rslt = new LoginResult() { UserId = Userid, IsValid = true, MenuDetailList = menus, ShopAssignedList = shopAssignedList }; var result = new BSEntityFramework_ResultType(BSResult.Success, rslt, null, "Success"); return(result); } return(new BSEntityFramework_ResultType(BSResult.Success, new LoginResult() { UserId = 0, IsValid = false, MenuDetailList = null, ShopAssignedList = null } , null, "Success")); } } catch (DbEntityValidationException dbValidationEx) { return(FormatException(dbValidationEx, null)); } catch (Exception ex) { var logact = new LoggerActivity(); var result = new BSEntityFramework_ResultType(BSResult.Fail, null, null, "Technical issue"); logact.ErrorSetup("WebApp", "Signin Failed", "", "", "", ex.Message); return(result); } }
public BSEntityFramework_ResultType SignUp(TBL_ShopLoginDetails model) { try { using (BSDBEntities EF = new BSDBEntities()) { if (EF.TBL_ShopLoginDetails.Any(x => (x.LoginName == model.LoginName))) { var result = new BSEntityFramework_ResultType(BSResult.Success, model, null, "Login Name already exist"); return(result); } else if (EF.TBL_ShopLoginDetails.Any(x => (x.EmailID == model.EmailID))) { var result = new BSEntityFramework_ResultType(BSResult.Success, model, null, "Email ID already exist"); return(result); } else { EF.TBL_ShopLoginDetails.Add(model); EF.SaveChanges(); var result = new BSEntityFramework_ResultType(BSResult.Success, model, null, "Created Sucessfully"); return(result); } } } catch (DbEntityValidationException dbValidationEx) { return(FormatException(dbValidationEx, model)); } catch (Exception ex) { var logact = new LoggerActivity(); var result = new BSEntityFramework_ResultType(BSResult.Fail, model, null, "Technical issue"); logact.ErrorSetup("WebApp", "InsertShopOffer Failed", "", "", "", ex.Message); return(result); } }