private static void AddUserDashboard(UserDashboard userdashboard) { using (TeamDbContext dbContext = new TeamDbContext()) { dbContext.UserDashboards.Add(userdashboard); dbContext.SaveChanges(); } }
public int CreateUserDashboardWidget(int userId, UserDashboardWidgetDto userDashboardWidget) { int userDashboardId; if (userDashboardWidget.PageId == null) { var newUserDashboard = new UserDashboard { UserId = userId, Name = userDashboardWidget.PageName }; _context.UserDashboard.Add(newUserDashboard); _context.SaveChanges(); userDashboardId = newUserDashboard.Id; } else { var existingUserDashboard = _context.UserDashboard.Include(x => x.UserDashboardWidgets) .FirstOrDefault(x => x.Id == userDashboardWidget.PageId); if (existingUserDashboard == null) { return(0); } userDashboardId = existingUserDashboard.Id; _context.UserDashboardWidget.RemoveRange(existingUserDashboard.UserDashboardWidgets); _context.SaveChanges(); } foreach (var item in from lgDto in userDashboardWidget.Item.Lg.ToList() let widgetName = userDashboardWidget.Widget.FirstOrDefault(w => w.IndexId == Convert.ToInt32(lgDto.I)) ?.Name let widgetId = _context.Widget.SingleOrDefault(x => x.Name == widgetName)?.Id select new UserDashboardWidget { CreatedAt = DateTime.Now, CreatedById = userId, Height = lgDto.H, Width = lgDto.W, XAxis = lgDto.X, YAxis = lgDto.Y, UserDashboardId = userDashboardId, WidgetId = widgetId, Index = lgDto.I }) { _context.UserDashboardWidget.Add(item); _context.SaveChanges(); } return(userDashboardId); }
public bool DeleteUserDashboard(UserDashboard userDashboard) { if (userDashboard == null) { return(false); } _unitOfWork.UserDashboardRepository.Delete(userDashboard); _unitOfWork.Save(); return(true); }
private static void AddUserDashboard(UserDashboard userdashboard) { using (TeamDbContext dbContext = new TeamDbContext()) { if (dbContext.UserDashboards.FirstOrDefault(e => e.Id == userdashboard.Id) == null) { dbContext.UserDashboards.Add(userdashboard); dbContext.SaveChanges(); } } }
private static void UpdateUserDashboard(UserDashboard userdashboard) { using (TeamDbContext dbContext = new TeamDbContext()) { if (dbContext.UserDashboards.AsNoTracking().FirstOrDefault(e => e.Id == userdashboard.Id && e.Deleted == false) != null) { dbContext.UserDashboards.UpdateRange(userdashboard); dbContext.SaveChanges(); } } }
public static UserDashboard GetDashboard(string username) { using (ctaDBEntities entities = new ctaDBEntities()) { UserDashboard result = new UserDashboard(username); entities.Database.Connection.Open(); int user_id = UserService.GetUserId(username); string user_type = entities.Tenants.Where(t => t.Id == user_id).Select(t => t.Tenant_Type.Name).First(); var user_portfolios = entities.Portfolios.Where(ptfolio => ptfolio.user_id == user_id); foreach (var portfolio in user_portfolios) { DashboardItem dashboard_item = new DashboardItem() { Portfolio = portfolio.name, Symbols = new List <ctaCOMMON.Charts.Symbol>(), Portfolio_Id = portfolio.Id }; foreach (var stock in portfolio.Portfolio_Stock) { List <Candel> quotes = new List <Candel>(); Candel today_candel = null; foreach (var quote in stock.Stock.Stock_Quote.Where(s => s.date_round < DateTime.Now.AddDays(-1) || user_type != "FREE").OrderBy(itm => itm.date_round)) { Candel candel = new Candel() { Date = quote.date_round, Open = quote.opening, Close = quote.closing, Minimun = quote.minimun, Maximun = quote.maximun, Volume = (double)quote.volume }; quotes.Add(candel); today_candel = candel; } SymbolIntradiaryInfo symbolIntradiaryInfo = QuotesService.GetSymbolIntradiaryInfo(stock.stock_id); if (today_candel != null) { symbolIntradiaryInfo.Volume = today_candel.Volume; symbolIntradiaryInfo.Maximun = today_candel.Maximun; symbolIntradiaryInfo.Minimun = today_candel.Minimun; } ctaCOMMON.Charts.Symbol dashboard_item_symbol = new ctaCOMMON.Charts.Symbol() { Symbol_ID = stock.stock_id, Symbol_Name = stock.Stock.symbol, Symbol_Company_Name = stock.Stock.name, Symbol_Market_ID = stock.Stock.Market.Id, Symbol_Market = stock.Stock.Market.name, Quotes = quotes.OrderBy(q => q.Date).ToList(), Intradiary_Info = symbolIntradiaryInfo }; dashboard_item.Symbols.Add(dashboard_item_symbol); } result.AddDashboardItem(dashboard_item); } entities.Database.Connection.Close(); DashBoardCache = result; return(result); } }
protected void DashboardRepeater_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { UserDashboard obj = (UserDashboard)e.Item.DataItem; if (obj == null) { return; } if (IsAddedInMainDashboard.Value != "true" && obj.DashboardId == 0) { IsAddedInMainDashboard.Value = "true"; } } }
public UserDashboard GetDashboardData(int UserID) { UserDashboard dash = new UserDashboard(); DataSet ds = Db.ExecuteDataSet("prcGetUserDashboardData", CommandType.StoredProcedure, Db.CreateParameter("@UserID", UserID) ); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { dash.TotalAssignedCount = Convert.ToInt32(ds.Tables[0].Rows[0]["TotalAssignedCount"]); dash.TotalUploadedCount = Convert.ToInt32(ds.Tables[0].Rows[0]["TotalUploadedCount"]); dash.TotalDocsCount = Convert.ToInt32(ds.Tables[0].Rows[0]["TotalDocsCount"]); } return(dash); }
private void buttonLogin_Click(object sender, EventArgs e) { login.username = textBoxUserName.Text.Trim(); login.password = textBoxPassword.Text.Trim(); login.user_type = comboBoxUserType.Text.Trim(); //Checking the login credentials bool success = loginDAL.LoginCheck(login); if (success == true) { //Login successful MessageBox.Show("Login Successful"); //Open respective forms based on user type switch (login.user_type) { case "Admin": { //Display admin dashboard MainAdminDashboard admin = new MainAdminDashboard(); admin.Show(); this.Hide(); } break; case "User": { //Display user dashboard UserDashboard user = new UserDashboard(); user.Show(); this.Hide(); } break; default: { //Display error message MessageBox.Show("Invalid user type"); } break; } } else { //Login failed MessageBox.Show("Login failed. Try again"); } }
private void btnLogin_Click(object sender, EventArgs e) { l.username = txtUsername.Text.Trim(); l.password = txtPassword.Text.Trim(); l.user_type = cmbUserType.Text.Trim(); //Checking the login credentials bool success = dal.loginCheck(l); if (success == true) { MessageBox.Show("Login Successfull"); loggedIn = l.username; //Need to open forms based on usertype switch (l.user_type) { case "Admin": { AdminDashboard admin = new AdminDashboard(); admin.Show(); this.Hide(); } break; case "User": { UserDashboard user = new UserDashboard(); user.Show(); this.Hide(); } break; default: { MessageBox.Show("Invalid User Type"); } break; } } else { MessageBox.Show("Login Failed.Try again"); } }
public async Task <IActionResult> Index() { var key = $"dashboard::{this.CurrentUser.Id}"; var strResult = await this.m_cache.GetAsync(key).AwaitBackground(); if (strResult != null) { return(this.Content(strResult, MediaTypeHeaderValue.Parse("application/json"))); } UserDashboard board; var raw = await this.GetStatsFor(this.CurrentUser, DateTime.UtcNow.AddMonths(-1)).AwaitBackground(); List <SensorStatisticsEntry> stats; stats = raw?.ToList(); board = new UserDashboard { SensorCount = await this._sensors.CountAsync(this.CurrentUser).AwaitBackground(), ApiCallCount = await this.GetApiCallCountAsync().AwaitBackground(), MeasurementsTodayCount = await this.CountMeasurementsAsync().AwaitBackground(), SecurityTokenCount = await this.CountSecurityTokensAsync(), MeasurementsToday = await this.GetMeasurementStatsToday().AwaitBackground(), ApiCallsLastWeek = await this.GetApiCallsPerDayAsync().AwaitBackground() }; if (stats != null) { board.MeasurementsCumulative = GetMeasurementStatsCumulative(stats); board.MeasurementsPerDayCumulative = GetMeasurementStatsCumulativePerDay(stats); } else { board.MeasurementsCumulative = new Graph <DateTime, long>(); board.MeasurementsPerDayCumulative = new Graph <int, long>(); } var result = board.ToJson(); await this.m_cache.SetAsync(key, result.ToString(), CacheTimeout.TimeoutShort.ToInt()).AwaitBackground(); return(this.Ok(result)); }
public ActionResult Index() { // HandleRedirection if (_workContext.CurrentUser.UserType == (int)UserType.Tenant) { return(RedirectToAction("Portal", "Tenant")); } ///// var userDashboard = _userDashboardRepository.GetAll() .Where(d => d.UserId == this._workContext.CurrentUser.Id) .FirstOrDefault(); if (userDashboard == null) { //create a default dashboard for user if not have one userDashboard = new UserDashboard { UserId = this._workContext.CurrentUser.Id, DashboardLayoutType = (int?)DashboardLayoutType.ThirdsGrid, RegionCount = 1 }; _userDashboardRepository.InsertAndCommit(userDashboard); } var model = userDashboard.ToModel(); // My assignments // var myAssignmentSearchModel = _httpContext.Session[SessionKey.MyAssignmentSearchModel] as SearchModel; //If not exist, build search model if (myAssignmentSearchModel == null) { myAssignmentSearchModel = BuildMyAssignmentSearchModel(); //session save _httpContext.Session[SessionKey.MyAssignmentSearchModel] = myAssignmentSearchModel; } ViewBag.MyAssignmentSearchModel = myAssignmentSearchModel; return(View(model)); }
private void btnLogin_Click(object sender, EventArgs e) { l.username = txtUsername.Text.Trim(); l.password = txtPassword.Text.Trim(); l.user_type = cmbUserType.Text.Trim(); bool success = dal.loginCheck(l); if (success == true) { MessageBox.Show("Login Successfull."); loggedIn = l.username; switch (l.user_type) { case "Admin": { AdminDashboard admin = new AdminDashboard(); admin.Show(); this.Hide(); } break; case "User": { UserDashboard user = new UserDashboard(); user.Show(); this.Hide(); } break; default: { MessageBox.Show("Invalid user type!"); } break; } } else { MessageBox.Show("Login failed. Try again!!"); } }
public static UserDashboard GetUserDashboardById(int dashboardId) { if (dashboardId <= 0) { throw new ArgumentException("dashboardId cannot be equals or less than zero"); } DashboardDSTableAdapters.UserDashboardsTableAdapter adapter = new DashboardDSTableAdapters.UserDashboardsTableAdapter(); DashboardDS.UserDashboardsDataTable table = adapter.GetUserDashboardById(dashboardId); DashboardDS.UserDashboardsRow row = table[0]; UserDashboard obj = new UserDashboard() { DashboardId = row.dashboardId, Name = row.name, OwnerUserId = row.ownerUserId }; return(obj); }
// GET: UsersDash public async Task <ActionResult> Index() { userDash = new UserDashboard(); await GetBuilding(); await GetBills(); await GetMyAppart(); User currUser = new Models.User(); currUser.firstName = ParseUser.CurrentUser.Get <string>("firstName"); currUser.lastName = ParseUser.CurrentUser.Get <string>("lastName"); currUser.email = ParseUser.CurrentUser.Username; currUser.phoneNumber = ParseUser.CurrentUser.Get <string>("phoneNumber"); userDash.mUser = currUser; TempData["myUser"] = userDash.mUser; return(View(userDash)); }
private void loginButton_Click(object sender, EventArgs e) { if (!DBConnectionManager.hasConnection()) { //MessageBox.Show(this, "No database connection! Unable to login.", "Login"); MessageBox.Show(this, "No database connection! Unable to login.", "Login", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } String userName = userNameTextBox.Text; String password = passwordTextBox.Text; MySqlCommand authenticationDataCommand = new MySqlCommand(sqlStatementGetAuthenticationData); authenticationDataCommand.Parameters.AddWithValue("@paramUserName", userName); //Aducere informatii din baza de date DataTable authenticationData = DBConnectionManager.getData(authenticationDataCommand); //Verificarea existentei utilizatorului si a corectitudinii datelor introduse if (userExists(authenticationData) && hasValidCredentials(authenticationData, password)) { //Se extrage id-ul de utilizator int userID = getUserID(authenticationData); this.Visible = false; //Se trimite id-ul ca argument constructorului clasei UserDashboard pt a putea fi utilizat ulterior la interogarea bazei de date UserDashboard userDashboard = new UserDashboard(userID, userName); userDashboard.Visible = true; } else { //MessageBox.Show("Invalid username and/or password! Please try again", "Login"); MessageBox.Show("Invalid username and/or password! Please try again", "Login", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public async Task <ActionResult> CreateBuilding(Building building) { String bName = building.buildingName; String bLoc = building.location; int bNumApparts = building.numApparts; int bNumShares = building.totalShares; float bTreasury = building.treasuryBalance; String optionResult = Request.Form["exampleRadioz"]; String bCurrency; if (optionResult.Equals("option1")) { bCurrency = "$"; } else { bCurrency = "LBP"; } ParseObject buildingParse = new ParseObject("Building"); ParseObject appartParse = new ParseObject("Appartment"); buildingParse["Name"] = bName; buildingParse["location"] = bLoc; buildingParse["NumApparts"] = bNumApparts; buildingParse["totalShares"] = bNumShares; buildingParse["Manager"] = ParseUser.CurrentUser; buildingParse["Treasury"] = bTreasury; buildingParse["Currency"] = bCurrency; buildingParse["BillsList"] = new List <String>(); List <ParseObject> apparts = new List <ParseObject>(); for (int i = 1; i <= bNumApparts; i++) { appartParse = new ParseObject("Appartment"); appartParse["Name"] = "Appt " + i; String appShareConfig = "appShare" + i; double appShare = double.Parse(Request.Form[appShareConfig], System.Globalization.CultureInfo.InvariantCulture); appartParse["Building"] = buildingParse; appartParse["AppShare"] = appShare; appartParse["owners"] = new List <String>(); appartParse["Settlement"] = 0; apparts.Add(appartParse); } try { await buildingParse.SaveAsync(); await buildingParse.FetchAsync(); //Storing building info Building mBuilding = new Building(); mBuilding.id = buildingParse.ObjectId; mBuilding.buildingName = buildingParse.Get <string>("Name"); mBuilding.location = buildingParse.Get <string>("location"); mBuilding.treasuryBalance = buildingParse.Get <float>("Treasury"); mBuilding.totalShares = buildingParse.Get <int>("totalShares"); mBuilding.currency = buildingParse.Get <string>("Currency"); List <Object> tempList = buildingParse.Get <List <Object> >("BillsList"); String billId; List <String> billsListStr = new List <string>(); foreach (Object obj in tempList) { billId = obj.ToString(); billsListStr.Add(billId); } mBuilding.billsList = billsListStr; UserDashboard userDash = new UserDashboard(); userDash.mBuilding = mBuilding; TempData["myBuilding"] = userDash.mBuilding; ParseUser.CurrentUser["Building"] = buildingParse; await ParseUser.CurrentUser.SaveAsync(); await ParseObject.SaveAllAsync(apparts); return(RedirectToAction("Index", "AdminNavigation")); } catch (ParseException e) { return(new EmptyResult()); } }
private void btnLogin_Click(object sender, EventArgs e) { #region Throw Error Message if (txtUsername.Text == "" && txtPassword.Text == "" && cmbUserType.Text == "") { MessageBox.Show(" Please Fill All The Details..... !! "); } else if (txtPassword.Text == "" && cmbUserType.Text == "") { MessageBox.Show(" Please Enter Passsword & Select UserType ... !! "); } else if (txtUsername.Text == "") { MessageBox.Show(" Please Enter Username.... !! "); } else if (txtPassword.Text == "") { MessageBox.Show(" Please Enter Password ... !! "); } else if (cmbUserType.Text == "") { MessageBox.Show(" Please Select Usertype ... !! "); } #endregion else { l.username = txtUsername.Text.Trim(); l.password = txtPassword.Text.Trim(); l.user_type = cmbUserType.Text.Trim(); //Checking the login credentials bool success = dal.loginCheck(l); if (success == true) { MessageBox.Show("Login Successfull"); loggedIn = l.username; //Need to open forms based on usertype switch (l.user_type) { case "Admin": { AdminDashboard admin = new AdminDashboard(); admin.Show(); this.Hide(); } break; case "User": { UserDashboard user = new UserDashboard(); user.Show(); this.Hide(); } break; default: { MessageBox.Show("Invalid User Type"); } break; } } else { MessageBox.Show("Login Failed.Try again"); } } }
public bool EditUserDashboard(UserDashboard userDashboard) { _unitOfWork.UserDashboardRepository.Edit(userDashboard); _unitOfWork.Save(); return(true); }
private void btnLogin_Click(object sender, RoutedEventArgs e) { User validatedUser = new User(); bool login = false; string currentUser = txtUserName.Text; string currentPassword = txtPasswordbox.Password; bool credentialsValidated = ValidateUserInput(currentUser, currentPassword); try { if (credentialsValidated) { validatedUser = GetUserRecord(currentUser, currentPassword); if (validatedUser.UserId > 0) { login = true; } else { MessageBox.Show("The credentials you entered does not exist in database, Please check and try again", "User login", MessageBoxButton.OK, MessageBoxImage.Error); } } else { MessageBox.Show("Error with your UserName or Password. Please check and try again", "User login", MessageBoxButton.OK, MessageBoxImage.Error); } if (login) { CreateLogEntry("Login", "User logged in successfully", validatedUser.UserId, validatedUser.UserName); if (validatedUser.LevelId == 3) { ManagerDashboard MD = new ManagerDashboard(); MD.user = validatedUser; MD.ShowDialog(); this.Hide(); } if (validatedUser.LevelId == 2) { StaffDashboard SD = new StaffDashboard(); SD.user = validatedUser; SD.ShowDialog(); this.Hide(); } if (validatedUser.LevelId == 1) { UserDashboard UD = new UserDashboard(); UD.user = validatedUser; UD.ShowDialog(); this.Hide(); } } else { CreateLogEntry("Login", "User did not Login", validatedUser.UserId, validatedUser.Username); } } catch (Exception ex) { MessageBox.Show("exception", ex.Message); throw; } }
/// <summary> /// Constructor for UserDashboardVM takes in a UserDashboard /// </summary> /// <param name="dash"></param> /// <param name="current"></param> public UserDashboardVM(UserDashboard dash, User current) { dashboard = dash; currentUser = current; }
public MembersDashboard(UserDashboard userDash) { InitializeComponent(); _userDash = userDash; db = new masterEntities(); }
public LendingDashboard(UserDashboard userdash) { InitializeComponent(); _userDash = userdash; db = new masterEntities(); }
public async Task <DatabaseResponse> UserDashboardData(int UserId) { try { SqlParameter[] parameters = { new SqlParameter("@UserId", SqlDbType.Int) }; parameters[0].Value = UserId; _DataHelper = new DataAccessHelper("sps_DashboardReportByUserId", parameters, _configuration); DataSet ds = new DataSet(); int result = await _DataHelper.RunAsync(ds); UserDashboard reports = new UserDashboard(); List <LatestCourse> latestContent = new List <LatestCourse>(); if (ds != null && ds.Tables[0].Rows.Count > 0) { reports = (from model in ds.Tables[0].AsEnumerable() select new UserDashboard() { DraftCourses = model.Field <int>("DraftCourses"), DraftResources = model.Field <int>("DraftResources"), PublishedCourses = model.Field <int>("PublishedCourses"), PubishedResources = model.Field <int>("PubishedResources"), CourseToApprove = model.Field <int>("CourseToApprove"), ResourceToApprove = model.Field <int>("ResourceToApprove"), DownloadedResources = model.Field <int>("DownloadedResources"), DownloadedCourses = model.Field <int>("DownloadedCourses"), SharedCourses = model.Field <int>("SharedCourses"), SharedResources = model.Field <int>("SharedResources"), FirstName = model.Field <string>("FirstName"), MiddleName = model.Field <string>("MiddleName"), LastName = model.Field <string>("LastName"), Photo = model.Field <string>("Photo"), ProfileDescription = model.Field <string>("ProfileDescription"), }).FirstOrDefault(); } if (ds != null && ds.Tables[1].Rows.Count > 0) { latestContent = (from model in ds.Tables[1].AsEnumerable() select new LatestCourse() { Id = model.Field <int>("Id"), Title = model.Field <string>("Title"), Description = model.Field <string>("Description"), ContentType = model.Field <int>("ContentType"), Thumbnail = model.Field <string>("Thumbnail"), }).ToList(); } reports.LatestCourse = latestContent; return(new DatabaseResponse { ResponseCode = result, Results = reports }); } catch (Exception ex) { Log.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw; } finally { _DataHelper.Dispose(); } }