public IActionResult Create(LoggerActivity book) { _loggerService.Create(book); Console.WriteLine("jchkjdhc", book.projectId); return(CreatedAtRoute("GetLoggerActivity", new { id = book.Id.ToString() }, book)); }
public IEnumerable <ShopAssignedToUser> GetShopAssignedList(string userID) { try { using (BSDBEntities EF = new BSDBEntities()) { var shopList = EF.TBL_ShopLoginDetails.Where(sld => sld.LoginName == userID) .Join(EF.TBL_UserAssignedShops, sld => sld.ShopLoginDetailsID, uas => uas.ShopLoginDetailsID, (sld, uas) => new { sld.ShopLoginDetailsID, uas.ShopID, uas.IsActive }) .Where(UAS => UAS.IsActive == true) .Join(EF.TBL_Shops, us => us.ShopID, ts => ts.ShopID, (us, ts) => new ShopAssignedToUser() { ShopId = ts.ShopID, ShopName = ts.ShopName }) .ToArray(); return(shopList); } } 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", "Shop list Failed", "", "", "", ex.Message); return(null); } }
public bool IsValidShopForUser(int userID, int ShopId) { try { using (BSDBEntities EF = new BSDBEntities()) { var isValidShopChange = EF.TBL_ShopLoginDetails .Where(sld => sld.ShopLoginDetailsID == userID) .Join(EF.TBL_UserAssignedShops, sld => sld.ShopLoginDetailsID, uas => uas.ShopLoginDetailsID, (sld, uas) => new { sld.ShopLoginDetailsID, uas.ShopID, uas.IsActive }) .Where(UAS => UAS.IsActive == true) .Join(EF.TBL_Shops, us => us.ShopID, ts => ts.ShopID, (us, ts) => new { ShopId = ts.ShopID, ShopName = ts.ShopName, isActive = ts.IsActive }).Any(x => x.isActive); return(isValidShopChange); } } catch (DbEntityValidationException dbValidationEx) { return(false); } catch (Exception ex) { var logact = new LoggerActivity(); var result = new BSEntityFramework_ResultType(BSResult.Fail, userID, null, "Technical issue"); logact.ErrorSetup("WebApp", "Shop Change IsValid Failed", "", "", "", ex.Message); return(false); } }
public void SendMessageToLoggerA(Logger_Activity log) { LoggerActivity loggeract = new LoggerActivity(); // public string type{get;set;} // public string userid{get;set;} // UserId // public DateTime published{get;set;} // public string description{get;set;} // public Data data{get;set;} // public string projectId{get;set;} loggeract.type = log.type; loggeract.userid = log.id; loggeract.published = log.published; loggeract.description = log.description; loggeract.data = log.details; loggeract.projectId = log.projectId; _loggerService.Create(loggeract); Console.WriteLine(log); Console.WriteLine("producer log"); Console.WriteLine(JsonConvert.SerializeObject(log)); byte[] messagebuffer = Encoding.Default.GetBytes(JsonConvert.SerializeObject(log)); _model.BasicPublish(IdeaExchange, "Kibin", null, messagebuffer); }
public IEnumerable <MenuVM> GetPluginMenuDetailList(int userId, int shopId) { try { using (BSDBEntities EF = new BSDBEntities()) { var menus = EF.TBL_PlugIns.Where(x => x.IsActive == true) .Join(EF.TBL_Shop_PlugIn , x => x.PlugInID , sp => sp.PlugInID , (x, sp) => new { x.PlugInID, sp.ShopID, x.IsFreeToAll } ).Where(sp => sp.ShopID == shopId || sp.IsFreeToAll == true) // .Join(EF.TBL_Shops,x=>x.ShopID,ts=>ts.ShopID,(x,ts)=>new {x.PlugInID,ts.ShopID}) .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 IActionResult Update(string id, LoggerActivity bookIn) { var book = _loggerService.Get(id); if (book == null) { return(NotFound()); } _loggerService.Update(id, bookIn); return(NoContent()); }
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); } }
public void Remove(LoggerActivity userIn) => _logger.DeleteOne(user => user.Id == userIn.Id);
public void Update(string id, LoggerActivity userIn) => _logger.ReplaceOne(user => user.Id == id, userIn);
public LoggerActivity Create(LoggerActivity user) { _logger.InsertOne(user); return(user); }
public IActionResult Create(LoggerActivity book) { _loggerService.Create(book); return(CreatedAtRoute("GetLoggerActivity", new { id = book.Id.ToString() }, book)); }