public ActionResult SearchDataForBenificiary(SearchModel objmodel) { /*Set values for helper*/ Helper.CompanyName = Convert.ToString(objmodel.CompanyName); Helper.Address = Convert.ToString(objmodel.Address); Helper.City = Convert.ToString(objmodel.City); Helper.State = Convert.ToString(objmodel.State); Helper.PhoneNbr = Convert.ToString(objmodel.PhoneNbr); Helper.Zip = Convert.ToString(objmodel.Zip); Helper.Address1 = Convert.ToString(objmodel.Address2); APIResponse response; MainMatchEntity objmainMatchEntity = new MainMatchEntity(); CommonSearchData common = new CommonSearchData(); if (string.IsNullOrEmpty(objmodel.DUNS)) { objmainMatchEntity = common.LoadData(objmodel.CompanyName, objmodel.Address, objmodel.Address2, objmodel.City, objmodel.State, objmodel.Country, objmodel.Zip, objmodel.PhoneNbr, objmodel.ExcludeNonHeadQuarters, objmodel.ExcludeNonMarketable, objmodel.ExcludeOutofBusiness, objmodel.ExcludeUndeliverable, objmodel.ExcludeUnreachable, objmodel.Language, null, this.CurrentClient.ApplicationDBConnectionString, null); } else { CommonSearchData objCommonSearch = new CommonSearchData(); CommonMethod objCommon = new CommonMethod(); response = objCommonSearch.SearchByDUNS(objmodel.DUNS, this.CurrentClient.ApplicationDBConnectionString); objmainMatchEntity.ResponseErroeMessage = Helper.ResponseErroeMessage; if (response != null) { objCommon.InsertAPILogs(response.TransactionResponseDetail, this.CurrentClient.ApplicationDBConnectionString); CompanyFacade fcd = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.oUser.UserName); fcd.InsertCleanseMatchCallResults("", response.ResponseJSON, response.APIRequest, Helper.oUser.UserId, ""); objmainMatchEntity.lstMatches = response.MatchEntities; } if (!string.IsNullOrEmpty(response?.ResponseJSON)) { dynamic data = JObject.Parse(response.ResponseJSON); if (data.error != null && !string.IsNullOrEmpty(data.error.errorMessage.Value)) { objmainMatchEntity.ResponseErroeMessage = data.error.errorMessage.Value; return(Json(new { result = false, message = objmainMatchEntity.ResponseErroeMessage })); } } } if (objmainMatchEntity.lstMatches == null) { objmainMatchEntity.lstMatches = new List <MatchEntity>(); } SessionHelper.SearchMatch = JsonConvert.SerializeObject(objmainMatchEntity.lstMatches); SessionHelper.SearchModel = JsonConvert.SerializeObject(objmodel); return(View("_Index", objmainMatchEntity)); }
public static SelectList StewGetDataImportProcess(string ConnectionString, string Queue, bool IsMatchdata) { CompanyFacade fac = new CompanyFacade(ConnectionString, Helper.oUser.UserName); DataTable dt = fac.GetImportProcessesByQueue(Queue, IsMatchdata); List <SelectListItem> lstImportProcess = new List <SelectListItem>(); for (int i = 0; i < dt.Rows.Count; i++) { lstImportProcess.Add(new SelectListItem { Value = dt.Rows[i]["ImportProcess"].ToString(), Text = dt.Rows[i]["ImportProcess"].ToString() }); } return(new SelectList(lstImportProcess, "Value", "Text")); }
// Get State or region public static List <string> GetStates(string ConnectionString) { int totalrecords = 10; BadInputDataModel model = new BadInputDataModel(); CompanyFacade fac = new CompanyFacade(ConnectionString, Helper.UserName); //model.Companies = fac.GetBIDCompany(Helper.oUser.UserId, 1, 10, out totalrecords); Tuple <List <CompanyEntity>, string> tuplecompany = fac.GetBIDCompany(Helper.oUser.UserId, 1, 10, out totalrecords); model.Companies = tuplecompany.Item1; var states = (from a in model.Companies select a.State).Distinct().ToList(); return(states); }
public async Task <ActionResult> JobOfferList() { var company = await CompanyFacade.GetCompanyAccordingToUsernameAsync(User.Identity.Name); var filter = new JobOfferFilterDto { CompanyId = company.Id }; var result = await JobOfferFacade.GetJobOffersAsync(filter); var model = new JobOfferListModel { Filter = filter, JobOffers = new List <JobOfferDto>(result.Items) }; return(View(model)); }
public async Task <ActionResult> Create(StockItemCreation item) { int companyId = (await CompanyFacade.FindCompanyByEmployeeEmail(User.Identity.Name)).Id; await MenuItemFacade.Create(new MenuItemDto { CompanyId = companyId, Name = item.MenuItem.Name, SellPrice = item.MenuItem.SellPrice, BuyPrice = item.MenuItem.BuyPrice, Amount = 0 }); return(Stock().Result); }
public ActionResult ExportExcel() { long searchResultId = Convert.ToInt64(Session["Id"]); CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName); var data = fac.ExportBuildResult(searchResultId); if (searchResultId <= 0) { data = new System.Data.DataTable(); } string fileName = "BuildList_" + DateTime.Now.Ticks.ToString() + ".xlsx"; string SheetName = "BuildList"; byte[] response = CommonExportMethods.ExportExcelFile(data, fileName, SheetName); return(File(response, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName)); }
public ActionResult DataQueueDashboard() { // //report for Data Queue Dashboard DataTable dtDataQueue = new DataTable(); if (Session["lstDataQueue"] != null) { dtDataQueue = Session["lstDataQueue"] as DataTable; } else { CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName); dtDataQueue = fac.GetDataQueueDashboardReport(); } return(PartialView("DataQueueTitle", dtDataQueue)); }
public void CompanyFacadeTest() { var unit = new UnitOfWork(GetInMemoryOptions()); Seeder.Seed(unit); var userService = new UserService(unit, new UserQueryObject(unit)); var compService = new CompanyService(unit, new CompanyQueryObject(unit)); var companyFacade = new CompanyFacade(unit, mapper, compService, userService); // Null ID edit/update companyFacade.AddAsync(new CompanyDto() { Name = "Lol" }).Wait(); //unit.SaveChanges(); var lol = compService.ListCompaniesByNameAsync("Lol").Result.First(); Assert.NotNull(lol); Assert.NotNull(lol.Id); lol.Id = null; lol.Name = "new lol"; var excp2 = Assert.Throws <AggregateException>(() => companyFacade.EditInfoAsync(mapper.Map <CompanyDto>(lol)).Wait()); Assert.Contains("The property 'Id' on entity type 'Company' is part of a key " + "and so cannot be modified or marked as modified.", excp2.Message); // Addition with conflicting ID // This invalidates the database var id1Company = unit.CompanyRepository.GetById(1); Assert.NotNull(id1Company); // makes sure company with id 1 is already in database var excp = Assert.Throws <AggregateException>(() => companyFacade.AddAsync(new CompanyDto() { Id = 1 }).Wait()); Assert.Contains("The instance of entity type 'Company' cannot be tracked " + "because another instance with the same key value for {'Id'} is already being tracked.", excp.Message); unit.Dispose(); }
public ActionResult MixModeAPICredentials() { CleanseMatchSettingsModel model = new CleanseMatchSettingsModel(); SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString); // Fill all dropdown and value for setting value. model.Settings = fac.GetCleanseMatchSettings(); GetSettingIDs(model); SetMatchGradeContent(model); Clear(model); ViewBag.ApiLayer = model.Settings.Where(x => x.SettingName == "API_LAYER").FirstOrDefault().SettingValue; CompanyFacade fcd = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName); string APIFamily = fcd.GetAPILayer("Match and Cleanse"); ViewBag.APIFamily = APIFamily; return(PartialView(model)); }
//bulk insert for Secondary Auto-Acceptance Criteria public bool BulkInsert(DataTable dt, DataTable dtColumns, bool IsOverWrite = false, int?CommentId = null) { bool DataInsert = false; CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName); using (SqlConnection connection = new SqlConnection(this.CurrentClient.ApplicationDBConnectionString)) { if (connection.State == ConnectionState.Closed) { connection.Open(); } //Creating Transaction so that it can rollback if got any error while uploading SqlTransaction trans = connection.BeginTransaction(); //Start bulkCopy using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection, SqlBulkCopyOptions.TableLock | SqlBulkCopyOptions.FireTriggers, trans)) { //Setting timeout to 0 means no time out for this command will not timeout until upload complete. //Change as per you bulkCopy.BulkCopyTimeout = 0; foreach (DataRow drCol in dtColumns.Rows) { bulkCopy.ColumnMappings.Add(drCol["Excelcolumn"].ToString(), drCol["Tablecolumn"].ToString()); } bulkCopy.DestinationTableName = "ext.SecondaryAutoAcceptanceCriteriaGroup"; try { bulkCopy.WriteToServer(dt); trans.Commit(); DataInsert = true; SettingFacade sfac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString); string Message = sfac.MergeSecondaryAutoAcceptCriteria(IsOverWrite, Helper.oUser.UserId, Convert.ToInt32(CommentId)); TempData["BulkMessage"] = "Data Inserted Successfully."; if (!string.IsNullOrEmpty(Message)) { TempData["BulkMessage"] = Message; } } catch (Exception ex) { TempData["BulkMessage"] = ex.Message.ToString(); DataInsert = false; } } } return(DataInsert); }
// GET: Order public async Task <ActionResult> Order() { List <OrderWithFullDependencyDto> orders = await CompanyFacade.GetAllOrdersWithDependencies(User.Identity.Name); List <OrderInfo> ordersInfo = new List <OrderInfo>(); orders = orders.OrderBy(x => x.OrderStartTime).ToList(); orders.ForEach(o => ordersInfo.Add( new OrderInfo { Id = o.Id, OrderStartTime = o.OrderStartTime, OrderTable = o.OrderTable, isPaid = o.Items.TrueForAll(i => i.IsPaid), isClosed = o.IsClosed })); return(View(ordersInfo)); }
// GET: ReportsList public ActionResult Index(string id) { string UserGroup = ""; ViewBag.Id = id; CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName); DataTable dtDataQueue = fac.GetDataQueueDashboardReport(); Session["lstDataQueue"] = dtDataQueue; DataSet dtDataStewardStatistics = fac.GetdtDataStewardStatisticsReport(UserGroup); SessionHelper.dtDataStewardStatistics = JsonConvert.SerializeObject(dtDataStewardStatistics); DataSet dsDataAPIUsage = fac.GetdtAPIReport(); SessionHelper.dsDataAPIUsage = JsonConvert.SerializeObject(dsDataAPIUsage); return(View()); }
public JsonResult SetUserLayoutPreference(string userLayout) { CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName); fac.SetUserLayoutPreference(Helper.oUser.UserId, userLayout); if (userLayout == "PANEL") { Session["ApproveMatchDataDefaultView"] = "PANEL"; Session["ApproveMatchDataCurrentView"] = "PANEL"; } else { Session["ApproveMatchDataDefaultView"] = "GRID"; Session["ApproveMatchDataCurrentView"] = "GRID"; } return(new JsonResult { Data = "success" }); }
public ActionResult AddCorporateLinkageDuns(string Parameters) { string duns; if (!string.IsNullOrEmpty(Parameters)) { duns = StringCipher.Decrypt(Parameters.Replace(Utility.Utility.urlseparator, "+"), General.passPhrase); CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName); string message = fac.PopulateCorporateLinkageDuns(duns); return(new JsonResult { Data = new { Message = message, result = true } }); } else { return(Json(false, JsonRequestBehavior.AllowGet)); } }
public ActionResult ReMatchRecords(ReMatchRecordsEntity model) { //Implement re-match queue (MP-14) CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName); model.UserId = Helper.oUser.UserId; string Message = fac.StewReMatchBadInputData(model); var response = string.Empty; if (model.GetCountsOnly) { Message = "Total " + Message + " records are affected, are you sure you want to continue ?"; response = string.Format("<input id=\"ReMatchMessage\" name=\"ReMatchMessage\" type=\"hidden\" value=\"{0}\">", Message); } else { response = string.Format("<input id=\"ReMatchMessage\" name=\"ReMatchMessage\" type=\"hidden\" value=\"{0}\">", Message); } return(Content(response)); }
public ActionResult GetAPIUsageGrid() { // Get API Usage list for API Usage DataSet dsDataAPIUsage = new DataSet(); DataTable dtCurrentMonthCnt = new DataTable(); List <APIUsagesCurntMonthCntChart> lstAPIUsagesCurntMonthCnt = new List <APIUsagesCurntMonthCntChart>(); if (!string.IsNullOrEmpty(SessionHelper.dsDataAPIUsage)) { dsDataAPIUsage = JsonConvert.DeserializeObject <DataSet>(SessionHelper.dsDataAPIUsage); } else { CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName); dsDataAPIUsage = fac.GetdtAPIReport(); } SessionHelper.dsDataAPIUsage = JsonConvert.SerializeObject(dsDataAPIUsage); dtCurrentMonthCnt = dsDataAPIUsage.Tables[0]; return(PartialView("APIusageGrid", dtCurrentMonthCnt)); }
public ActionResult AddFamilyTreeNode(string Parameters) { int FamilyTreeId; string DetailId, NodeName, NodeDisplayDetail, NodeType; int? ParentFamilyTreeDetailId = null; try { if (!string.IsNullOrEmpty(Parameters)) { Parameters = StringCipher.Decrypt(Parameters.Replace(Utility.Utility.urlseparator, "+"), General.passPhrase); FamilyTreeId = Convert.ToInt32(Utility.Utility.SplitParameters(Parameters, Utility.Utility.Colonseparator, 0, 1)); DetailId = Utility.Utility.SplitParameters(Parameters, Utility.Utility.Colonseparator, 1, 1); NodeName = Utility.Utility.SplitParameters(Parameters, Utility.Utility.Colonseparator, 2, 1); NodeDisplayDetail = Utility.Utility.SplitParameters(Parameters, Utility.Utility.Colonseparator, 3, 1); NodeType = Utility.Utility.SplitParameters(Parameters, Utility.Utility.Colonseparator, 4, 1); if (!string.IsNullOrEmpty(Utility.Utility.SplitParameters(Parameters, Utility.Utility.Colonseparator, 5, 1))) { ParentFamilyTreeDetailId = Convert.ToInt32(Utility.Utility.SplitParameters(Parameters, Utility.Utility.Colonseparator, 5, 1)); } CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName); string message = fac.AddFamilyTreeNode(FamilyTreeId, DetailId, NodeName, NodeDisplayDetail, NodeType, ParentFamilyTreeDetailId, Convert.ToInt32(User.Identity.GetUserId())); if (message == string.Empty) { message = FamilyTreeLang.msgFamilyTreeCreated; } return(new JsonResult { Data = new { Message = message, result = true } }); } else { return(Json(false, JsonRequestBehavior.AllowGet)); } } catch (Exception) { return(Json(false, JsonRequestBehavior.AllowGet)); } }
public ActionResult popupCompanyAttribute(string Parameters) { // Get Query string in Encrypted mode and decrypt Query string and set Parameters if (!string.IsNullOrEmpty(Parameters)) { Parameters = StringCipher.Decrypt(Parameters.Replace(Utility.Utility.urlseparator, "+"), General.passPhrase); } string SrcRecordId = Parameters; //find custom attribute like tax id, Revenue etc.. by the id. DataTable dtAttributes = new DataTable(); if (!string.IsNullOrEmpty(SrcRecordId)) { CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName); dtAttributes = fac.GetComanyAttribute(SrcRecordId); } IPagedList <dynamic> pagedAttribute = new StaticPagedList <dynamic>(dtAttributes.AsDynamicEnumerable(), 1, 100000, 0); ViewBag.SrcRecordId = SrcRecordId; return(View(pagedAttribute)); }
public ActionResult Index(string FileType = null, string ImportProcess = null) { FileType = string.IsNullOrEmpty(FileType) ? CommonMessagesLang.lblMyFiles : FileType; ViewBag.FileType = FileType; if (!string.IsNullOrEmpty(ImportProcess)) { ImportProcess = StringCipher.Decrypt(ImportProcess, General.passPhrase); } CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.oUser.UserName); int? UserId; if (FileType == CommonMessagesLang.lblMyFiles) { UserId = Helper.oUser.UserId; } else { UserId = null; } ExportJobSettingsFacade efac = new ExportJobSettingsFacade(StringCipher.Decrypt(ConfigurationManager.ConnectionStrings["SolidQMasterWeb"].ConnectionString, General.passPhrase)); efac.UpdateExportJobSettingNotificationsStatus(this.CurrentClient.ApplicationId, Helper.oUser.UserId, ProviderType.DandB.ToString()); List <ExportJobSettingsEntity> lstExportJobs = efac.GetExportJobSettingsByUserId(ProviderType.DandB.ToString(), UserId, this.CurrentClient.ApplicationId); //set helper for display un-flag export button DataTable dtActiveDataStatistics = fac.GetDashboardGetDataQueueStatistics(Helper.oUser != null ? Helper.oUser.LOBTag : null, Helper.oUser != null ? Helper.oUser.Tags : null, Helper.oUser.UserId); if (dtActiveDataStatistics.Rows.Count != 0) { Helper.ArchivalQueueCount = dtActiveDataStatistics.Rows[0]["ArchivalQueueCount"] is DBNull ? 0 : Convert.ToInt32(dtActiveDataStatistics.Rows[0]["ArchivalQueueCount"]); } ViewBag.ImportProcess = ImportProcess; ViewBag.SelectedTab = "CompanyData"; if (Request.IsAjaxRequest()) { return(PartialView("CompanyData", lstExportJobs)); } return(View(lstExportJobs)); }
public void AcceptLCMMatches(string id, string MatchSeqence) { CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName); StewardshipPortalModel model = new StewardshipPortalModel(); if (TempData["TempCompanies"] != null) { model.Companies = (TempData["TempCompanies"] as List <CompanyEntity>).Copy(); } if (model.Companies.Any() && !string.IsNullOrEmpty(id)) { foreach (var company in model.Companies) { if (company.InputId == Convert.ToInt32(id)) { if (Convert.ToString(MatchSeqence).ToLower() == "rejectall") { company.Matches.ForEach(x => x.IsSelected = false); company.SelectedMatchCount = 0; company.RejectCompany = true; } else if (Convert.ToString(MatchSeqence).ToLower() == "unrejectall") { company.RejectCompany = false; } else { company.Matches.ForEach(x => x.IsSelected = false); company.Matches[Convert.ToInt32(MatchSeqence) - 1].IsSelected = true; company.SelectedMatchCount = 1; company.RejectCompany = false; } } } } TempData["TempCompanies"] = model.Companies; Helper.IsDirty = true; TempData.Keep(); }
public JsonResult GetDataQueue() { DataTable dtDataQueue = new DataTable(); List <DataQueueChart> lstDataQueue = new List <DataQueueChart>(); if (Session["lstDataQueue"] != null) { dtDataQueue = Session["lstDataQueue"] as DataTable; } else { CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName); dtDataQueue = fac.GetDataQueueDashboardReport(); } for (int i = 0; i < dtDataQueue.Rows.Count; i++) { DataQueueChart objDataQueue = new DataQueueChart(); objDataQueue.x = dtDataQueue.Rows[i]["Type"].ToString(); objDataQueue.y = Convert.ToInt32(dtDataQueue.Rows[i]["Number of Records"].ToString()); lstDataQueue.Add(objDataQueue); } return(Json(lstDataQueue, JsonRequestBehavior.AllowGet)); }
private bool BulkInsert(DataTable dt, out string msg) { bool DataInsert = false; CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName); using (SqlConnection connection = new SqlConnection(this.CurrentClient.ApplicationDBConnectionString)) { if (connection.State == ConnectionState.Closed) { connection.Open(); } //Creating Transaction so that it can rollback if got any error while uploading SqlTransaction trans = connection.BeginTransaction(); //Start bulkCopy using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection, SqlBulkCopyOptions.TableLock | SqlBulkCopyOptions.FireTriggers, trans)) { //Setting timeout to 0 means no time out for this command will not timeout until upload complete. //Change as per you bulkCopy.BulkCopyTimeout = 0; bulkCopy.ColumnMappings.Add("", ""); bulkCopy.DestinationTableName = "cmpl.ScreeningQueue"; try { bulkCopy.WriteToServer(dt); trans.Commit(); DataInsert = true; msg = DandBSettingLang.msgInsertUser; } catch (Exception ex) { msg = ex.Message; DataInsert = false; } } } return(DataInsert); }
public override void OnActionExecuting(ActionExecutingContext filterContext) { // if request was came from the outside or the other site at that time we redirect to the 404 page and we are not allow the reuest. // Get connection string. //string GetConnctionstring = Convert.ToString(GetClientConnectionString());// StringCipher.Encrypt(SBISCompanyCleanseMatchBusiness.Objects.General.databaseConnectionString, General.passPhrase); //CompanyFacade cfac = new CompanyFacade(GetConnctionstring,Helper.UserName); //var oUser = new UsersEntity(); //if (!string.IsNullOrEmpty(Helper.TempEmailAddress)) //{ // oUser = (Helper.oUser as UsersEntity).Copy(); // (Helper.oUser as UsersEntity).Copy(); // oUser = cfac.GetUserByLoginId(Helper.TempEmailAddress); //} //else { oUser = null; } string UserStatusCode = "101003";//Convert.ToString(fac.GetUserStatus().Where(x => x.Value.ToLower() == "account locked").Select(x => x.Code).FirstOrDefault()); if (Helper.oUser == null) { string GetConnctionstring = Convert.ToString(GetClientConnectionString());// StringCipher.Encrypt(SBISCompanyCleanseMatchBusiness.Objects.General.databaseConnectionString, General.passPhrase); CompanyFacade cfac = new CompanyFacade(GetConnctionstring, Helper.UserName); if (!string.IsNullOrEmpty(Helper.TempEmailAddress)) { Helper.oUser = cfac.GetUserByLoginId(Helper.TempEmailAddress); } } if (Helper.oUser != null && Helper.oUser.UserStatusCode == UserStatusCode) { filterContext.Result = new ViewResult { ViewName = "~/Account/Login", ViewData = filterContext.Controller.ViewData, TempData = filterContext.Controller.TempData }; } }
public ActionResult DuplicateFamilyTree(string Parameters) { int FamilyTreeId; string FamilyTreeName, FamilyTreeType; try { if (!string.IsNullOrEmpty(Parameters)) { Parameters = StringCipher.Decrypt(Parameters.Replace(Utility.Utility.urlseparator, "+"), General.passPhrase); FamilyTreeId = Convert.ToInt32(Utility.Utility.SplitParameters(Parameters, Utility.Utility.Colonseparator, 0, 1)); FamilyTreeName = Utility.Utility.SplitParameters(Parameters, Utility.Utility.Colonseparator, 1, 1); FamilyTreeType = Utility.Utility.SplitParameters(Parameters, Utility.Utility.Colonseparator, 2, 1); CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName); string message = fac.DuplicaeFamilyTree(FamilyTreeId, FamilyTreeName, FamilyTreeType, Convert.ToInt32(User.Identity.GetUserId())); if (message == string.Empty) { message = FamilyTreeLang.msgDuplicateFamilyTreeCreated; } return(new JsonResult { Data = new { Message = message, result = true } }); } else { return(new JsonResult { Data = new { Message = CommonMessagesLang.msgCommanErrorMessage, result = false } }); } } catch (Exception) { return(new JsonResult { Data = new { Message = CommonMessagesLang.msgCommanErrorMessage, result = false } }); } }
public async Task <ActionResult> Index(string FileType = null) { FileType = string.IsNullOrEmpty(FileType) ? "My Files" : FileType; ViewBag.FileType = FileType; string ApplicationId = Convert.ToString(this.CurrentClient.ApplicationId); CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.oUser.UserName); int? UserId; if (FileType == "My Files") { UserId = Helper.oUser.UserId; } else { UserId = null; } OIExportJobSettingsFacade efac = new OIExportJobSettingsFacade(StringCipher.Decrypt(ConfigurationManager.ConnectionStrings["SolidQMasterWeb"].ConnectionString, General.passPhrase)); efac.UpdateExportOIJobSettingNotificationsStatus(this.CurrentClient.ApplicationId, Helper.oUser.UserId, ProviderType.OI.ToString()); List <OIExportJobSettingsEntity> lstExportJobs = efac.GetExportJobSettingsByUserId(ProviderType.OI.ToString(), UserId, this.CurrentClient.ApplicationId); //set helper for display un-flag export button DataTable dtActiveDataStatistics = fac.GetDashboardGetDataQueueStatistics(Helper.oUser != null ? Helper.oUser.LOBTag : null, Helper.oUser != null ? Helper.oUser.Tags : null, Helper.oUser.UserId); if (dtActiveDataStatistics.Rows.Count != 0) { Helper.ArchivalQueueCount = dtActiveDataStatistics.Rows[0]["ArchivalQueueCount"] is DBNull ? 0 : Convert.ToInt32(dtActiveDataStatistics.Rows[0]["ArchivalQueueCount"]); } if (Request.IsAjaxRequest()) { return(PartialView("~/Views/OI/OIExportView/_index.cshtml", lstExportJobs)); } return(View("~/Views/OI/OIExportView/Index.cshtml", lstExportJobs)); }
public async Task <ActionResult> Register(NewCustomerDto customer) { var isIcoAlreadyRegistered = (await CompanyFacade.GetAsyncByIco(customer.Ico)) != null; var isEmailAlreadyRegistered = (await EmployeeFacade.GetAsyncByEmail(customer.Email)) != null; if (isIcoAlreadyRegistered) { ModelState.AddModelError("Ico", "Ico is already registered"); return(View()); } if (isEmailAlreadyRegistered) { ModelState.AddModelError("Email", "Account with that email already exists!"); return(View()); } await CompanyFacade.RegisterCompanyWithOwner(customer); AddAuthTicket(customer.Email, Role.Owner.ToString()); return(RedirectToAction("Index", "Home")); }
public JsonResult Search(BuildListSearchModel model, int?page, int?sortby, int?sortorder, int?pagevalue) { Response response = new Response(); try { #region pagination if (!(sortby.HasValue && sortby.Value > 0)) { sortby = 1; } if (!(sortorder.HasValue && sortorder.Value > 0)) { sortorder = 2; } int currentPageIndex = page.HasValue ? page.Value : 1; int pageSize = pagevalue.HasValue ? pagevalue.Value : 20; #endregion #region Set Viewbag ViewBag.SortBy = sortby; ViewBag.SortOrder = sortorder; ViewBag.pageno = currentPageIndex; ViewBag.pagevalue = pageSize; SessionHelper.BuildList_pageno = Convert.ToString(currentPageIndex); #endregion Utility.Utility api = new Utility.Utility(); model.Request.pageSize = ViewBag.pagevalue; model.Request.pageNumber = ViewBag.pageno; if (model.Request.usSicV4.Any()) { model.Request.usSicV4 = null; } if (model.Request.registrationNumbers.Any()) { model.Request.registrationNumbers = null; } model.Request.businessEntityType = null; model.Request.familytreeRolesPlayed = null; if (model.Request.locationRadius.lat == 0 && model.Request.locationRadius.lon == 0 && model.Request.locationRadius.radius == 0 && string.IsNullOrEmpty(model.Request.locationRadius.unit)) { model.Request.locationRadius = null; } if (!model.Request.yearlyRevenue.maximumValue.HasValue && !model.Request.yearlyRevenue.minimumValue.HasValue) { model.Request.yearlyRevenue = null; } if (model.Request.globalUltimateFamilyTreeMembersCount.maximumValue == 0 && model.Request.globalUltimateFamilyTreeMembersCount.minimumValue == 0) { model.Request.globalUltimateFamilyTreeMembersCount = null; } if (model.Request.numberOfEmployees.informationScope == 0 && model.Request.numberOfEmployees.maximumValue == null && model.Request.numberOfEmployees.minimumValue == null) { model.Request.numberOfEmployees = null; } if (model.Request.registrationNumbers.Count == 0) { model.Request.registrationNumbers = null; } if (model.Request.usSicV4.Count == 0) { model.Request.usSicV4 = null; } DateTime dtRequestedTime = DateTime.Now; DateTime?dtResponseTime = null; bool IsFetchData = true; List <SearchCandidate> lstsesstion = new List <SearchCandidate>(); // Checking APIType is there or not string APItype = CommonMethod.GetThirdPartyProperty(ThirdPartyCode.DNB_BUILD_A_LIST.ToString(), ThirdPartyProperties.APIType.ToString()); if (APItype != "") { for (int i = 1; i <= (model.NoOfRecored / 20); i++) { if (IsFetchData) { model.Request.pageNumber = i; model.Request.pageSize = 20; SearchCriteriaResponse objResponse = api.BuildAList(model.Request); if (objResponse.searchCandidates != null) { lstsesstion.AddRange(objResponse.searchCandidates); if ((i * 20) >= objResponse.candidatesMatchedQuantity) { IsFetchData = false; } } else { if (i == 1) { response.Success = false; response.ResponseString = objResponse.error != null ? objResponse.error.errorMessage : string.Empty; } IsFetchData = false; } } } } dtResponseTime = DateTime.Now; if (lstsesstion.Any()) { SessionHelper.BuildList_Data = JsonConvert.SerializeObject(lstsesstion); CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName); var RequestJson = new JavaScriptSerializer().Serialize(model); var ResponseJson = new JavaScriptSerializer().Serialize(lstsesstion); object obj = fac.InsertBuildSearch(Helper.oUser.UserId, RequestJson, ResponseJson, dtRequestedTime, dtResponseTime); Session["Id"] = Convert.ToInt64(obj); } if (lstsesstion.Any()) { var skip = pageSize * (currentPageIndex - 1); IPagedList <SearchCandidate> pglstpagedMonitorProfile = new StaticPagedList <SearchCandidate>(lstsesstion.Skip(skip).Take(pageSize).ToList(), currentPageIndex, pageSize, lstsesstion.Count); dtResponseTime = DateTime.Now; response.Success = true; response.ResponseString = RenderViewAsString.RenderPartialViewToString(this, "~/Views/BuildList/SearchGrid.cshtml", pglstpagedMonitorProfile); } else { if (APItype == "") { response.Success = false; response.ResponseString = CommonMessagesLang.msgNoDefaultKeyForSearch; } } return(Json(response)); } catch (Exception ex) { response.Success = false; response.ResponseString = ex.Message; return(Json(response)); } }
public CompanyController(CompanyFacade companyFacade, UserFacade userFacade) { this.companyFacade = companyFacade; this.userFacade = userFacade; }
// GET: Stock public async Task <ActionResult> MenuItems() { List <MenuItemDto> menuItems = await CompanyFacade.GetAllMenuItems(User.Identity.Name); return(View("MenuItems", menuItems)); }
public async Task <CompanyDto> GetCompany(int id) { return(await CompanyFacade.GetAsync(id)); }