public ActionResult Index() { var model = new List <DiamondStockViewModel>(); var Data = (dynamic)null; using (var httpClient = ApiHelper.GetHttpClient()) { var result = (dynamic)null; if (User.IsInRole(EnumTypes.RoleList.ADMIN.ToString())) { result = httpClient.GetAsync(Config.get_stock).Result; if (result.IsSuccessStatusCode) { var resultContent = result.Content.ReadAsStringAsync().Result; model = JsonConvert.DeserializeObject <List <DiamondStockViewModel> >(resultContent); } } else { var DB = new BG_DBEntities(); string ID = DB.AspNetUsers.FirstOrDefault(x => x.Email.Trim() == User.Identity.Name.Trim()).Id; ViewBag.BrokerColumns = GetBrokerColumn(ID); result = httpClient.GetAsync(Config.get_broker_stocks + "/" + User.Identity.Name + "/").Result; if (result.IsSuccessStatusCode) { var resultContent = result.Content.ReadAsStringAsync().Result; Data = JsonConvert.DeserializeObject <List <DiamondStockViewModel> >(resultContent); ViewBag.StockDatas = Data; } } } return(View(model)); }
public ActionResult SetPerimission(string UserID, List <BrokerColumnsViewModel> BrokerColumn) { int?[] BrokerID = null; if (BrokerColumn.Count() > 0 && BrokerColumn != null) { BrokerID = BrokerColumn.Select(x => (int?)x.ColumnId).ToArray(); } if (BrokerID != null) { var DB = new BG_DBEntities(); var BrkCol = DB.BrokerColumnMappingMsts.Where(x => x.UserId == UserID).ToList(); BrkCol = BrkCol.Where(x => !BrokerID.Contains(x.ColumnId)).ToList(); DB.BrokerColumnMappingMsts.RemoveRange(BrkCol); DB.SaveChanges(); foreach (var c in BrokerColumn) { var Col = DB.BrokerColumnMappingMsts.FirstOrDefault(x => x.UserId == UserID && x.ColumnId == c.ColumnId); if (Col == null) { var obj = new BrokerColumnMappingMst { ColumnId = c.ColumnId, Sort = c.Sort ?? c.ColumnId, UserId = UserID }; DB.BrokerColumnMappingMsts.Add(obj); DB.SaveChanges(); } else { Col.Sort = c.Sort ?? c.ColumnId; DB.SaveChanges(); } } return(Json(true, JsonRequestBehavior.AllowGet)); } return(Json(false, JsonRequestBehavior.AllowGet)); }
public List <string> GetBrokerColumn(string UserID) { var DB = new BG_DBEntities(); var Columns = DB.BrokerColumnMappingMsts.Where(x => x.UserId == UserID).OrderBy(c => c.Sort).ToList(); return(Columns.Select(x => x.BrokerColumnName.ColumnName).ToList()); }
public ActionResult CheckEmailAlreadyThere(string Email) { var DB = new BG_DBEntities(); bool status = DB.AspNetUsers.Any(x => x.Email.Trim().Equals(Email.Trim())); return(Json(status, JsonRequestBehavior.AllowGet)); }
public ActionResult AddBanner(BannerViewModel model) { try { var DB = new BG_DBEntities(); model.ImageString = model.ImageString.Split(',')[1]; // remove data:image/png;base64, byte[] ImageFile = null; if (model.ImageString != null && !string.IsNullOrEmpty(model.ImageString)) { ImageFile = Convert.FromBase64String(model.ImageString); } if (ImageFile != null) { string filePath = HttpContext.Server.MapPath(string.Format("~/Content/slider/" + model.ImageName + "")); System.IO.File.WriteAllBytes(filePath, ImageFile); } var obj = new BannerMst { Active = true, ImageName = model.ImageName, Title = model.Title, UploadDate = DateTime.Now }; DB.BannerMsts.Add(obj); DB.SaveChanges(); return(Json(true, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(false, JsonRequestBehavior.AllowGet)); } }
public ActionResult ChangeSalesPerson(string[] CustomerEmail, string SalesPersonID) { try { var DB = new BG_DBEntities(); string CurrentUserID = DB.AspNetUsers.FirstOrDefault(x => x.Email == User.Identity.Name).Id; if (CustomerEmail.Count() > 0) { foreach (var i in CustomerEmail) { var Old = DB.AssignSalesPersonMsts.Where(x => x.CustomerID == i).ToList(); if (Old.Count() > 0) { Old.ForEach(x => x.Active = false); DB.SaveChanges(); } var obj = new AssignSalesPersonMst { Active = true, CreatedDate = DateTime.Now, CreatedBy = CurrentUserID, SalesPersonID = SalesPersonID, CustomerID = i }; DB.AssignSalesPersonMsts.Add(obj); DB.SaveChanges(); } } return(Json(true, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(false, JsonRequestBehavior.AllowGet)); } }
public ActionResult Register(CounterViewModel model) { if (!ModelState.IsValid) { return(Json(new DefaultResponse().SetErrorMessages(this).AsDefault(), JsonRequestBehavior.AllowGet)); } try { bool IsSuccess = ApiHelper.CounterRegister(model); if (IsSuccess) { var DB = new BG_DBEntities(); string ID = DB.AspNetUsers.FirstOrDefault(x => x.Email.Trim() == model.Email.Trim()).Id; if (!string.IsNullOrEmpty(ID)) { var MenuNames = JsonConvert.DeserializeObject <List <string> >(model.MenuNames); var Columns = JsonConvert.DeserializeObject <List <BrokerColumnsViewModel> >(model.ColumnName); if (MenuNames.Count() > 0) { bool status = AddMenuPermission(ID, MenuNames); } if (Columns.Count() > 0) { bool status = AddColumnPermission(ID, Columns); } } } return(Json(new DefaultResponse(HttpStatusCode.OK, ""), JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new DefaultResponse(HttpStatusCode.NotFound, "Invalid email or password."))); } }
public ActionResult GetAllSalesPersonMenu(string UserID) { var DB = new BG_DBEntities(); var User = DB.AspNetUsers.Where(x => x.Id == UserID).Select(y => new ApplicationUserViewModel() { FirstName = y.FirstName, LastName = y.LastName }).FirstOrDefault(); ViewBag.SalesPersonName = User.FirstName + " " + User.LastName; ViewBag.SalesPersonID = UserID; var model = new List <SalesPersonMenuPermissionViewModel>(); model = DB.MainMenuMsts.Select(x => new SalesPersonMenuPermissionViewModel() { MenuID = x.MainMenuMstID, MenuName = x.MainMenuName, IsDisplay = x.UserMenuPermissionMsts.Any(c => c.MainMenuMstId == x.MainMenuMstID && c.UserId == UserID) }).ToList(); var SubMenu = DB.MenuMsts.Select(x => new SalesPersonMenuPermissionViewModel() { MenuID = x.MenuMstId, MenuName = x.MenuName, IsDisplay = x.UserMenuPermissionMsts.Any(c => c.MenuMstId == x.MenuMstId && c.UserId == UserID) }).ToList(); model.AddRange(SubMenu); return(PartialView("_MenuPermissions", model)); }
public ActionResult SetMenuPerimission(string UserID, string[] MenuNames) { var DB = new BG_DBEntities(); if (MenuNames != null) { MenuNames = MenuNames.Select(s => s.ToLowerInvariant().Trim()).ToArray(); var MainMenuIDs = DB.MainMenuMsts.Where(x => MenuNames.Contains(x.MainMenuName.ToLower().Trim())).Select(y => y.MainMenuMstID).ToList(); var SubMenuIDs = DB.MenuMsts.Where(x => MenuNames.Contains(x.MenuName.ToLower().Trim())).Select(y => y.MenuMstId).ToList(); var AlreadyMainMenu = DB.UserMenuPermissionMsts.Where(x => x.MenuMstId == null && x.UserId == UserID).ToList(); AlreadyMainMenu = AlreadyMainMenu.Where(x => !MainMenuIDs.Contains((int)x.MainMenuMstId)).ToList(); DB.UserMenuPermissionMsts.RemoveRange(AlreadyMainMenu); DB.SaveChanges(); var AlreadySubMenu = DB.UserMenuPermissionMsts.Where(x => x.MenuMstId != null && x.UserId == UserID).ToList(); AlreadySubMenu = AlreadySubMenu.Where(x => !SubMenuIDs.Contains((int)x.MenuMstId)).ToList(); DB.UserMenuPermissionMsts.RemoveRange(AlreadySubMenu); DB.SaveChanges(); foreach (var m in MainMenuIDs) { var MainMenu = DB.UserMenuPermissionMsts.FirstOrDefault(x => x.MainMenuMstId == m && x.UserId == UserID); if (MainMenu == null) { var obj = new UserMenuPermissionMst { MainMenuMstId = m, UserId = UserID, MenuMstId = null }; DB.UserMenuPermissionMsts.Add(obj); DB.SaveChanges(); } } foreach (var s in SubMenuIDs) { var SubMenu = DB.UserMenuPermissionMsts.FirstOrDefault(x => x.MenuMstId == s && x.UserId == UserID); if (SubMenu == null) { var obj = new UserMenuPermissionMst { MenuMstId = s, UserId = UserID, MainMenuMstId = DB.MenuMsts.FirstOrDefault(x => x.MenuMstId == s).MainMenuMstId }; DB.UserMenuPermissionMsts.Add(obj); DB.SaveChanges(); } } return(Json(true, JsonRequestBehavior.AllowGet)); } else { var AllMenus = DB.UserMenuPermissionMsts.Where(x => x.UserId == UserID).ToList(); DB.UserMenuPermissionMsts.RemoveRange(AllMenus); DB.SaveChanges(); return(Json(true, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetCity(int StateId) { var DB = new BG_DBEntities(); var City = DB.CityMsts.Where(x => x.StateId == StateId && x.Active == true).Select(y => new CityViewModel() { CityId = y.CityId, CityName = y.CityName }).OrderBy(c => c.CityName).ToList(); return(Json(City, JsonRequestBehavior.AllowGet)); }
public ActionResult GetStates(int CountryId) { var DB = new BG_DBEntities(); var State = DB.StateMsts.Where(x => x.CountryId == CountryId && x.Active == true).Select(y => new StateViewModel() { StateId = y.StateId, StateName = y.StateName }).OrderBy(c => c.StateName).ToList(); return(Json(State, JsonRequestBehavior.AllowGet)); }
public ActionResult GetBrokerColumn() { var DB = new BG_DBEntities(); var model = new List <BrokerColumnsViewModel>(); model = DB.BrokerColumnNames.Select(x => new BrokerColumnsViewModel() { ColumnName = x.ColumnName, ColumnId = x.ColumnId }).ToList(); return(PartialView("_ColumnPermission", model)); }
// GET: Inquiry public ActionResult Index() { var DB = new BG_DBEntities(); ViewBag.Country = DB.CountryMsts.Where(v => v.Active == true).Select(x => new CountryViewModel() { CountryId = x.CountryId, CountryName = x.CountryName }).OrderBy(c => c.CountryName).ToList(); ViewBag.State = new List <SelectListItem>(); ViewBag.City = new List <SelectListItem>(); return(View()); }
public bool AddMenuPermission(string UserID, List <string> MenuNames) { var DB = new BG_DBEntities(); if (MenuNames != null) { MenuNames = MenuNames.Select(s => s.ToLowerInvariant().Trim()).ToList(); var MainMenuIDs = DB.MainMenuMsts.Where(x => MenuNames.Contains(x.MainMenuName.ToLower().Trim())).Select(y => y.MainMenuMstID).ToList(); var SubMenuIDs = DB.MenuMsts.Where(x => MenuNames.Contains(x.MenuName.ToLower().Trim())).Select(y => y.MenuMstId).ToList(); var AlreadyMainMenu = DB.UserMenuPermissionMsts.Where(x => x.MenuMstId == null && x.UserId == UserID).ToList(); AlreadyMainMenu = AlreadyMainMenu.Where(x => !MainMenuIDs.Contains((int)x.MainMenuMstId)).ToList(); DB.UserMenuPermissionMsts.RemoveRange(AlreadyMainMenu); DB.SaveChanges(); var AlreadySubMenu = DB.UserMenuPermissionMsts.Where(x => x.MenuMstId != null && x.UserId == UserID).ToList(); AlreadySubMenu = AlreadySubMenu.Where(x => !SubMenuIDs.Contains((int)x.MenuMstId)).ToList(); DB.UserMenuPermissionMsts.RemoveRange(AlreadySubMenu); DB.SaveChanges(); foreach (var m in MainMenuIDs) { var MainMenu = DB.UserMenuPermissionMsts.FirstOrDefault(x => x.MainMenuMstId == m && x.UserId == UserID); if (MainMenu == null) { var obj = new UserMenuPermissionMst { MainMenuMstId = m, UserId = UserID, MenuMstId = null }; DB.UserMenuPermissionMsts.Add(obj); DB.SaveChanges(); } } foreach (var s in SubMenuIDs) { var SubMenu = DB.UserMenuPermissionMsts.FirstOrDefault(x => x.MenuMstId == s && x.UserId == UserID); if (SubMenu == null) { var obj = new UserMenuPermissionMst { MenuMstId = s, UserId = UserID, MainMenuMstId = DB.MenuMsts.FirstOrDefault(x => x.MenuMstId == s).MainMenuMstId }; DB.UserMenuPermissionMsts.Add(obj); DB.SaveChanges(); } } return(true); } return(false); }
public ActionResult Index() { var DB = new BG_DBEntities(); var model = DB.BannerMsts.Select(x => new BannerViewModel() { Active = x.Active, Title = x.Title, UploadDate = x.UploadDate, ImageName = x.ImageName, ImageID = x.ImageID }).ToList(); return(View(model)); }
public ActionResult GetSalesPerson() { var model = new List <SalesPersons>(); var DB = new BG_DBEntities(); string RoleId = DB.AspNetRoles.FirstOrDefault(x => x.Name.Equals(EnumTypes.RoleList.SALESPERSON.ToString())).Id; if (!string.IsNullOrEmpty(RoleId)) { model = DB.AspNetUsers.Where(x => x.Active == true && x.EmailConfirmed == true && x.AspNetRoles.Any(c => c.Id == RoleId)).Select(y => new SalesPersons() { SalesPersonID = y.Id, SalesPersonName = (y.FirstName + " " + y.LastName).Trim().ToUpper() }).OrderBy(v => v.SalesPersonName).ToList(); } return(PartialView("_AssignSalesPersonModal", model)); }
public ActionResult GetRegisterCustomers() { var model = new List <ApplicationUserViewModel>(); if (User.IsInRole(EnumTypes.RoleList.ADMIN.ToString())) { using (var httpClient = ApiHelper.GetHttpClient()) { var result = httpClient.GetAsync(Config.Register_customers).Result; if (result.IsSuccessStatusCode) { var resultContent = result.Content.ReadAsStringAsync().Result; model = JsonConvert.DeserializeObject <List <ApplicationUserViewModel> >(resultContent); } } } else { var DB = new BG_DBEntities(); string CurrentUserID = DB.AspNetUsers.FirstOrDefault(x => x.Email == User.Identity.Name).Id; model = (from a in DB.AssignSalesPersonMsts where a.SalesPersonID == CurrentUserID && a.Active == true select new ApplicationUserViewModel() { EmailConfirmed = a.AspNetUser1.EmailConfirmed, Id = a.AspNetUser1.Id, FirstName = a.AspNetUser1.FirstName, LastName = a.AspNetUser1.LastName, Email = a.AspNetUser1.Email, CompanyAddress = a.AspNetUser1.CompanyAddress, CompanyCityId = a.AspNetUser1.CompanyCityId, CompanyName = a.AspNetUser1.CompanyName, CompanyZipcode = a.AspNetUser1.CompanyZipcode, CompanyCityName = a.AspNetUser1.CityMst.CityName, ContactPerson = a.AspNetUser1.ContactPerson, Mobile = a.AspNetUser1.Mobile, RefBusiness = a.AspNetUser1.RefBusiness, RefMobile = a.AspNetUser1.RefMobile, RefName = a.AspNetUser1.RefName, UserCityName = a.AspNetUser1.CityMst1.CityName, Active = a.AspNetUser1.Active, UserGSTNO = a.AspNetUser1.UserGSTNO, SalesPersonName = a.AspNetUser2.FirstName + " " + a.AspNetUser2.LastName }).DistinctBy(v => v.Id).ToList(); } return(View(model)); }
// GET: Admin/InquiryAdmin public ActionResult Index() { var DB = new BG_DBEntities(); var inquirys = new List <InquiryViewModel>(); string CurrentUserID = DB.AspNetUsers.FirstOrDefault(x => x.Email == User.Identity.Name).Id; if (User.IsInRole(EnumTypes.RoleList.ADMIN.ToString())) { inquirys = DB.InquiryMsts.Select(x => new InquiryViewModel() { UserName = x.AspNetUser.FirstName + " " + x.AspNetUser.LastName, City = x.CityMst.CityName, State = x.StateMst.StateName, Country = x.CountryMst.CountryName, Comments = x.Comments, CompanyAddress = x.CompanyAddress, CompanyName = x.CompanyName, InquiryName = x.InquiryName, Type = x.Type, UserId = x.UserId, IsResolve = x.IsResolve }).ToList(); } else if (User.IsInRole(EnumTypes.RoleList.SALESPERSON.ToString())) { inquirys = (from I in DB.InquiryMsts join S in DB.AssignSalesPersonMsts on I.UserId equals S.CustomerID where S.SalesPersonID == CurrentUserID select new InquiryViewModel() { UserName = I.AspNetUser.FirstName + " " + I.AspNetUser.LastName, City = I.CityMst.CityName, State = I.StateMst.StateName, Country = I.CountryMst.CountryName, Comments = I.Comments, CompanyAddress = I.CompanyAddress, CompanyName = I.CompanyName, InquiryName = I.InquiryName, Type = I.Type, UserId = I.UserId, IsResolve = I.IsResolve }).ToList(); } return(View(inquirys)); }
public ActionResult ActiveInactiveBanner(int ImageID, bool Status) { try { var DB = new BG_DBEntities(); var Image = DB.BannerMsts.FirstOrDefault(x => x.ImageID == ImageID); if (Image != null) { Image.Active = Status ? true : false; DB.SaveChanges(); } return(Json(true, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(false, JsonRequestBehavior.AllowGet)); } }
public ActionResult Login(string returnUrl) { if (CurrentUser != null && CurrentUser.Identity.IsAuthenticated) { return(RedirectToRoute("Default")); } var DB = new BG_DBEntities(); ViewBag.Banner = DB.BannerMsts.Where(v => v.Active == true).Select(x => new BannerViewModel() { Active = x.Active, Title = x.Title, UploadDate = x.UploadDate, ImageName = x.ImageName, ImageID = x.ImageID }).ToList(); ViewBag.ReturnUrl = returnUrl; return(View()); }
public ActionResult GetMenuPermission() { var DB = new BG_DBEntities(); var model = new List <SalesPersonMenuPermissionViewModel>(); model = DB.MainMenuMsts.Select(x => new SalesPersonMenuPermissionViewModel() { MenuID = x.MainMenuMstID, MenuName = x.MainMenuName }).ToList(); var SubMenu = DB.MenuMsts.Select(x => new SalesPersonMenuPermissionViewModel() { MenuID = x.MenuMstId, MenuName = x.MenuName }).ToList(); model.AddRange(SubMenu); return(PartialView("_MenuPermission", model)); }
public ActionResult Index() { if (!CurrentUser.Identity.IsAuthenticated) { return(RedirectToAction("Login", "Account", new { area = "" })); } var DB = new BG_DBEntities(); string UserID = DB.AspNetUsers.FirstOrDefault(x => x.Email == User.Identity.Name).Id; ViewBag.IsMenuPErmission = DB.UserMenuPermissionMsts.Any(x => x.UserId == UserID); var model = new AdminDashboardViewModel(); if (User.IsInRole(EnumTypes.RoleList.ADMIN.ToString())) { using (var httpClient = ApiHelper.GetHttpClient()) { var result = httpClient.GetAsync(Config.dashboard).Result; if (result.IsSuccessStatusCode) { var resultContent = result.Content.ReadAsStringAsync().Result; model = JsonConvert.DeserializeObject <AdminDashboardViewModel>(resultContent); } } } else if (User.IsInRole(EnumTypes.RoleList.SALESPERSON.ToString())) { string CurrentUserID = DB.AspNetUsers.FirstOrDefault(x => x.Email == User.Identity.Name).Id; model.TilesCount.Customers_Count = DB.AssignSalesPersonMsts.Count(x => x.SalesPersonID == CurrentUserID && x.Active == true); } string RoleID = DB.AspNetRoles.FirstOrDefault(x => x.Name.Equals(EnumTypes.RoleList.SALESPERSON.ToString())).Id; model.SalesPerson = DB.AspNetUsers.Where(x => x.Active == true && x.EmailConfirmed == true && x.AspNetRoles.Any(c => c.Id == RoleID)).Select(y => new SalesPersonListViewModel() { SalesPersonID = y.Id, Email = y.Email, Name = y.FirstName + " " + y.LastName, CompanyName = y.CompanyName, RegisterDate = y.RegisterDate, Mobile = y.Mobile, TotalCustomer = DB.AssignSalesPersonMsts.Count(c => c.SalesPersonID == y.Id && c.Active == true) }).OrderByDescending(v => v.RegisterDate).Take(10).ToList(); return(View(model)); }
protected override bool AuthorizeCore(HttpContextBase httpContext) { string CurrentUserEmail = httpContext.User.Identity.Name; Permission = Permission.Replace("_", " "); //var ID = HttpContext.Current.Request.RequestContext.RouteData.Values["Id"]; //check your permissions var DB = new BG_DBEntities(); string UserID = DB.AspNetUsers.FirstOrDefault(x => x.Email == CurrentUserEmail).Id; bool IsAccess = DB.UserMenuPermissionMsts.Any(x => x.MainMenuMst.MainMenuName.ToLower().Trim().Equals(Permission.ToLower().Trim()) && x.UserId == UserID); if (!IsAccess) { return(DB.UserMenuPermissionMsts.Any(x => x.MenuMst.MenuName.ToLower().Trim().Equals(Permission.ToLower().Trim()) && x.UserId == UserID)); } else { return(true); } }
public PartialViewResult GetMenu() { var DB = new BG_DBEntities(); string UserID = DB.AspNetUsers.FirstOrDefault(x => x.Email == User.Identity.Name).Id; var menu = DB.UserMenuPermissionMsts.Where(x => x.UserId == UserID && x.MainMenuMst.Active == true).Select(y => new MenuViewModel() { MainMenuName = y.MainMenuMst.MainMenuName, URL = y.MainMenuMst.URL, Icon = y.MainMenuMst.Icon, Active = y.MainMenuMst.Active, MainMenuMstID = y.MainMenuMstId, SubMenu = DB.UserMenuPermissionMsts.Where(x => x.UserId == UserID && x.MenuMst.Active == true && x.MainMenuMstId == y.MainMenuMstId).Select(c => new SubMenuViewModel() { MenuName = c.MenuMst.MenuName, URL = c.MenuMst.URL, Active = c.MenuMst.Active, Icon = c.MenuMst.Icon, MenuMstId = c.MenuMst.MenuMstId }).OrderBy(v => v.MenuMstId).ToList() }).DistinctBy(b => b.MainMenuName).OrderBy(v => v.MainMenuMstID).ToList(); return PartialView("_MenuPartial", menu); }
public ActionResult GetAllBrokerColumn(string UserID) { var DB = new BG_DBEntities(); var User = DB.AspNetUsers.Where(x => x.Id == UserID).Select(y => new ApplicationUserViewModel() { FirstName = y.FirstName, LastName = y.LastName }).FirstOrDefault(); ViewBag.BrokerName = User.FirstName + " " + User.LastName; ViewBag.BrokerID = UserID; var model = new List <BrokerColumnsViewModel>(); model = DB.BrokerColumnNames.Select(x => new BrokerColumnsViewModel() { ColumnName = x.ColumnName, ColumnId = x.ColumnId, IsDisplay = x.BrokerColumnMappingMsts.Count(c => c.UserId == UserID) > 0 ? true : false, UserId = UserID, Sort = (int)x.BrokerColumnMappingMsts.FirstOrDefault(v => v.ColumnId == x.ColumnId && v.UserId == UserID).Sort }).ToList(); return(PartialView("_BrokerColumns", model)); }
public ActionResult Index(InquiryViewModel model) { var DB = new BG_DBEntities(); string UserID = DB.AspNetUsers.FirstOrDefault(x => x.Email == User.Identity.Name).Id; var obj = new InquiryMst { InquiryName = model.InquiryName, Type = model.Type, CompanyName = model.CompanyName, CompanyAddress = model.CompanyAddress, Comments = model.Comments, CountryId = model.CountryId, StateId = model.StateId, CityId = model.CityId, UserId = UserID, IsResolve = false }; DB.InquiryMsts.Add(obj); DB.SaveChanges(); return(Json(obj.InquiryId > 0 ? true : false, JsonRequestBehavior.AllowGet)); }
public ActionResult Index() { var DB = new BG_DBEntities(); ViewBag.Country = DB.CountryMsts.Where(v => v.Active == true).Select(x => new CountryViewModel() { CountryId = x.CountryId, CountryName = x.CountryName }).OrderBy(c => c.CountryName).ToList(); ViewBag.State = new List <SelectListItem>(); ViewBag.City = new List <SelectListItem>(); ViewBag.RoleList = Enum.GetValues(typeof(EnumTypes.RoleList)).Cast <EnumTypes.RoleList>().Select(x => new SelectListViewModel() { Text = x.ToString(), Value = x.ToString() }).ToList(); var MenuModel = new List <SalesPersonMenuPermissionViewModel>(); MenuModel = DB.MainMenuMsts.Select(x => new SalesPersonMenuPermissionViewModel() { MenuID = x.MainMenuMstID, MenuName = x.MainMenuName }).ToList(); var SubMenu = DB.MenuMsts.Select(x => new SalesPersonMenuPermissionViewModel() { MenuID = x.MenuMstId, MenuName = x.MenuName }).ToList(); MenuModel.AddRange(SubMenu); ViewBag.Menus = MenuModel; ViewBag.Columns = DB.BrokerColumnNames.Select(x => new BrokerColumnsViewModel() { ColumnName = x.ColumnName, ColumnId = x.ColumnId }).ToList(); return(View()); }
public ActionResult AssignSalesPersons(string CustomerEmail, string SalesPersonID) { try { var DB = new BG_DBEntities(); string CurrentUserID = DB.AspNetUsers.FirstOrDefault(x => x.Email == User.Identity.Name).Id; string CustomerID = DB.AspNetUsers.FirstOrDefault(x => x.Email == CustomerEmail).Id; var obj = new AssignSalesPersonMst { Active = true, CreatedDate = DateTime.Now, CreatedBy = CurrentUserID, SalesPersonID = SalesPersonID, CustomerID = CustomerID }; DB.AssignSalesPersonMsts.Add(obj); DB.SaveChanges(); return(Json(true, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(false, JsonRequestBehavior.AllowGet)); } }
protected List <DiamondStockViewModel> GetStocks() { var DB = new BG_DBEntities(); return(DB.DiamondStocks.Where(x => x.Sale != true).Select(y => new DiamondStockViewModel() { StockMSTID = y.StockMSTID, StoneID = y.StoneID, Cts = y.Cts, Location = y.Location, ReportNo = y.ReportNo, CertificateCode = y.CertificateCode, ShapeCode = y.ShapeCode, SizeCode = y.SizeCode, ColorCode = y.ColorCode, PurityCode = y.PurityCode, CutCode = y.CutCode, PolishCode = y.PolishCode, SymmetryCode = y.SymmetryCode, FlouCode = y.FlouCode, Rap = y.Rap, Disc = y.Disc, Asking = y.Asking, Amount = y.Amount, SPer = y.SPer, SRate = y.SRate, SAmount = y.SAmount, Length = y.Length, Width = y.Width, Depth = y.Depth, DepthPer = y.DepthPer, TablePer = y.TablePer, CrownAngle = y.CrownAngle, CrownHeight = y.CrownHeight, PavAngle = y.PavAngle, PavHeight = y.PavHeight, KeytoSymbol = y.KeytoSymbol, VideoLink = y.VideoLink, EyeClean = y.EyeClean, Comments = y.Comments, Girdle = y.Girdle, Culet = y.Culet, Star = y.Star, Lower = y.Lower, Milky = y.Milky, CBlack = y.CBlack, SBlack = y.SBlack, CWhite = y.CWhite, SWhite = y.SWhite, HA = y.HA, ResultVerify = y.ResultVerify, ReportDate = y.ReportDate, Inscription = y.Inscription, Sale = y.Sale, Broker = y.Broker, Hold = y.Hold, Basket = y.Basket, Inquiry = y.Inquiry, FancyColorCode = y.FancyColorCode, BGM = y.BGM, Diameter = y.Diameter, Ratio = y.Ratio, Table = y.Table, TOInclusion = y.TOInclusion, COInclusion = y.COInclusion, POInclusion = y.POInclusion, GOInclusion = y.GOInclusion, CertificateName = DB.CertificateMsts.FirstOrDefault(c => c.CertificateCode == y.CertificateCode).CertificateName, ShapeName = DB.ShapeMsts.FirstOrDefault(c => c.ShapeCode == y.ShapeCode).ShapeAliasName, Size = DB.SizeMsts.FirstOrDefault(c => c.SizeMstID == y.SizeCode).SizeAlias, ColorName = DB.ColorMsts.FirstOrDefault(c => c.ColorCode == y.ColorCode).ColorAliasName, Cut = DB.CutMsts.FirstOrDefault(c => c.CutCode == y.CutCode).CutAliasName, Flou = DB.FlouMsts.FirstOrDefault(c => c.FlouCode == y.FlouCode).FlouAliasName, Polish = DB.PolishMsts.FirstOrDefault(c => c.PolishCode == y.PolishCode).PolishAliasName, Purity = DB.PurityMsts.FirstOrDefault(c => c.PurityCode == y.PurityCode).PurityAliasName, Symmetry = DB.SymmetryMsts.FirstOrDefault(c => c.SymmetryCode == y.SymmetryCode).SymmetryAliasName, FancyColorName = DB.FancyColorMsts.FirstOrDefault(c => c.FancyColorCode == y.FancyColorCode).FancyColorName, UploadedDate = y.UploadedDate }).ToList()); }
public ActionResult Index(string StoneID) { var DB = new BG_DBEntities(); var Stone = DB.DiamondStocks.Where(x => x.StoneID.Trim().ToLower().Equals(StoneID.Trim().ToLower())).Select(y => new DNADisplayViewModel() { StoneID = y.StoneID, CaratWeight = y.Cts.ToString(), Clarity = DB.PurityMsts.FirstOrDefault(b => b.PurityCode == y.PurityCode).PurityName, PurityCode = y.PurityCode, Color = DB.ColorMsts.FirstOrDefault(b => b.ColorCode == y.ColorCode).ColorName, ColorCode = y.ColorCode, Cut = DB.CutMsts.FirstOrDefault(b => b.CutCode == y.CutCode).CutName, CutCode = y.CutCode, Shape = DB.ShapeMsts.FirstOrDefault(b => b.ShapeCode == y.ShapeCode).ShapeName, ShapeCode = y.ShapeCode }).FirstOrDefault(); if (Stone != null) { Stone.RelatedStone = DB.DiamondStocks.Where(x => x.PurityCode == Stone.PurityCode && x.ColorCode == Stone.ColorCode && x.CutCode == Stone.CutCode && x.ShapeCode == Stone.ShapeCode).Select(y => new RelatedStone() { StoneID = y.StoneID, CaratWeight = y.Cts.ToString(), Clarity = DB.PurityMsts.FirstOrDefault(b => b.PurityCode == y.PurityCode).PurityName, PurityCode = y.PurityCode, Color = DB.ColorMsts.FirstOrDefault(b => b.ColorCode == y.ColorCode).ColorName, ColorCode = y.ColorCode, Cut = DB.CutMsts.FirstOrDefault(b => b.CutCode == y.CutCode).CutName, CutCode = y.CutCode, Shape = DB.ShapeMsts.FirstOrDefault(b => b.ShapeCode == y.ShapeCode).ShapeName, ShapeCode = y.ShapeCode }).ToList(); if (Stone.RelatedStone.Count() > 0) { var removeStone = Stone.RelatedStone.FirstOrDefault(x => x.StoneID.ToLower().Trim().Equals(StoneID.ToLower().Trim())); if (removeStone != null) { Stone.RelatedStone.Remove(removeStone); } } } FileInfo pdfFiles = GetFiles(Server.MapPath(@"~/DNAReports/" + StoneID), "pdf").ToList().FirstOrDefault(); if (pdfFiles != null) { Stone.PDFFileName = pdfFiles.Name; } List <FileInfo> JPG_images = GetFiles(Server.MapPath(@"~/DNAReports/" + StoneID), "jpg").ToList(); List <FileInfo> PNG_images = GetFiles(Server.MapPath(@"~/DNAReports/" + StoneID), "png").ToList(); List <FileInfo> JPEG_images = GetFiles(Server.MapPath(@"~/DNAReports/" + StoneID), "jpeg").ToList(); Stone.ImageNames = new List <string>(); if (JPG_images.Count() > 0 && JPG_images != null) { Stone.ImageNames = JPG_images.Select(c => c.Name).ToList(); } if (PNG_images.Count() > 0 && PNG_images != null) { Stone.ImageNames.AddRange(PNG_images.Select(c => c.Name).ToList()); } if (JPEG_images.Count() > 0 && JPEG_images != null) { Stone.ImageNames.AddRange(JPEG_images.Select(c => c.Name).ToList()); } List <FileInfo> JSON_FIle = GetFiles(Server.MapPath(@"~/DNAReports/" + StoneID), "json").ToList(); Stone.JSONString = new List <string>(); if (JSON_FIle.Count() > 0 && JSON_FIle != null) { foreach (var i in JSON_FIle) { Stone.JSONString.Add(System.IO.File.ReadAllText(Server.MapPath(@"~/DNAReports/" + StoneID) + "/" + i.Name)); } } return(View(Stone)); }