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