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