/// <summary> /// Creates a new sub entity and assigns the parent entity specified in the query strings. /// </summary> /// <returns></returns> public override IEntity Create() { IEntity entity = null; using (LogGroup logGroup = LogGroup.Start("Preparing the form to create a new sub entity.", NLog.LogLevel.Debug)) { if (EnsureAuthorised()) { Guid parentID = Guid.Empty; string parentUniqueKey = String.Empty; if (QueryStrings.Available) { parentID = QueryStrings.GetID("Parent"); parentUniqueKey = QueryStrings.GetUniqueKey("Parent"); } else { throw new InvalidOperationException("Query strings aren't available. Provide parent ID or parent unique key manually."); } LogWriter.Debug("Parent ID: " + parentID); LogWriter.Debug("Parent unique key: " + parentUniqueKey); entity = Create(parentID, parentUniqueKey); } } return(entity); }
/// <summary> /// This method requires a user id in order to get a user object from the database. /// </summary> /// <param name="id">The id</param> /// <returns>Returns a student object.</returns> public Student getSingleStudent(int id) { QueryStrings queryStrings = new QueryStrings(); Student singleStudent = queryStrings.getSingleStudentById(id); return(singleStudent); }
/// <summary> /// This method requires a course object to add a course entry to the database. /// </summary> /// <param name="course">The course object</param> /// <returns>Returns a bool whether it succeeded or not.</returns> public bool addCourse(Course course) { QueryStrings queryStrings = new QueryStrings(); string data = course.courseCode + "','" + course.name + "','" + course.schoolYear + "','" + course.blockPeriod + "','" + course.credits; return(queryStrings.addCourse(course, data)); }
/// <summary> /// This method requires a user id in order to get all the grades of that user. /// </summary> /// <param name="id">The id</param> /// <returns>Returns a list of all grades of the selected user.</returns> public List <PrestationIndicator> getAverageGradeById(int id) { QueryStrings queryStrings = new QueryStrings(); List <PrestationIndicator> gradeList = queryStrings.getAverageGradeById(id); return(gradeList); }
/// <summary> /// This method requires a user id and gets all courses that the user is not subscribed to. /// </summary> /// <param name="id">The id</param> /// <returns>Returns a list of the courses that the user is not subscribed to.</returns> public List <Course> getNonSubscribedCourses(int id) { QueryStrings queryStrings = new QueryStrings(); List <Course> allCourses = queryStrings.getNonSubscribedCourses(id); return(allCourses); }
/// <summary> /// This method gets all existing courses. /// </summary> /// <returns>Returns a list of all courses.</returns> public List <Course> allCourses() { QueryStrings queryStrings = new QueryStrings(); List <Course> allCourses = queryStrings.getAllCourses(); return(allCourses); }
/// <summary> /// This method requires a user id in order to get a list of courses that the student has completed. /// </summary> /// <param name="id">The id</param> /// <returns>Returns the list of courses completed by the student.</returns> public List <Course> coursesByStudent(int id) { QueryStrings queryStrings = new QueryStrings(); List <Course> coursesByStudent = queryStrings.getCouresesbyStudentId(id); return(coursesByStudent); }
public void LargeTableHandling() { InitConnection(); IQTable orderTable = qbApp.GetTable(qbSettings["qbBigTable"]); Query qry = new Query(); QueryStrings lstQry = new QueryStrings(1, ComparisonOperator.IR, "last 60 d", LogicalOperator.NONE); qry.Add(lstQry); int maxRec = 100000; orderTable.Query(qry, string.Format("skp-10.num-{0}", maxRec)); Assert.AreEqual(maxRec, orderTable.Records.Count); HashSet <string> idLst = new HashSet <string>(); foreach (QRecord rec in orderTable.Records) { string id = (string)rec["Record ID#"]; if (idLst.Contains(id)) { Assert.Fail("Duplicate ID found!"); } else { idLst.Add(id); } } }
public ActionResult Login(string returnUrl) { var context = new Context(); var log = new SysLogModel(context: context); if (Sessions.LoggedIn()) { if (QueryStrings.Bool("new")) { Authentications.SignOut(); } log.Finish(context: context); return(base.Redirect(Locations.Top())); } var html = UserUtilities.HtmlLogin( context: context, returnUrl: returnUrl, message: Request.QueryString["expired"] == "1" && !Request.IsAjaxRequest() ? Messages.Expired().Text : string.Empty); ViewBag.HtmlBody = html; log.Finish(context: context, responseSize: html.Length); return(View()); }
public ActionResult MyEmployeeDashboardSpendingHoursEmployeeBUOrganization(string Date, string Name) { string FDate = Date.Split(':').First(); string LastDate = Date.Split(':').Last(); string EMpId = Name.Split('(').Last().Split(')').First(); int UserId = Convert.ToInt32(EMpId);// 60814; DateTime Fromdate = Convert.ToDateTime(FDate); DateTime ToDate = Convert.ToDateTime(LastDate); DataTable BeingOntimeData = new QueryStrings().GetInOutTotalPunchData(FDate, LastDate, UserId); List <DateTime> DateData = new List <DateTime>(); List <string> Datestringdata = new List <string>(); List <double> FirstPuch = new List <double>(); List <double> LastPuch = new List <double>(); List <double> Totalhoursspent = new List <double>(); for (DateTime date = Fromdate; date <= ToDate; date = date.AddDays(1.0)) { DateData.Add(date); Datestringdata.Add(date.ToString("dd-MMM")); } for (DateTime date = DateData[0]; date <= DateData[DateData.Count - 1]; date = date.AddDays(1.0)) { string firstpunch = GetFirstPunchTimeValue(BeingOntimeData, date); var data = firstpunch.Split(':'); string time = data[0] + "." + data[1]; FirstPuch.Add(Convert.ToDouble(time)); } for (DateTime date = DateData[0]; date <= DateData[DateData.Count - 1]; date = date.AddDays(1.0)) { string firstpunch = GetLastPuchTimeValue(BeingOntimeData, date); var data = firstpunch.Split(':'); string time = data[0] + "." + data[1]; LastPuch.Add(Convert.ToDouble(time)); } for (DateTime date = DateData[0]; date <= DateData[DateData.Count - 1]; date = date.AddDays(1.0)) { string firstpunch = GetTotalhoursTimeValue(BeingOntimeData, date); var data = firstpunch.Split(':'); string time = data[0] + "." + data[1]; Totalhoursspent.Add(Convert.ToDouble(time)); } ArrayList EmployeeDashboardSpendingstatistics = new ArrayList(); //string[] categories = new string[] { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" }; //double[] Selecteduserdata = new double[] { 8.0, 6.9, 9.5, 8.5, 10.4, 9.5, 9.2, 8.5, 9.3, 7.3, 6.9, 9.6 }; //double[] BUdata = new double[] { 8.9, 2.2, 5.7, 8.5, 11.9, 15.2, 17.0, 12.6, 12.2, 10.3, 6.6, 4.8 }; //double[] Organizationdata = new double[] { 8.9, 8.2, 5.7, 8.5, 7.9, 8.2, 17.0, 9.6, 10.2, 9.3, 8.6, 10.8 }; EmployeeDashboardSpendingstatistics.Add(Datestringdata.ToArray()); EmployeeDashboardSpendingstatistics.Add(FirstPuch.ToArray()); EmployeeDashboardSpendingstatistics.Add(LastPuch.ToArray()); EmployeeDashboardSpendingstatistics.Add(Totalhoursspent.ToArray()); return(Json(EmployeeDashboardSpendingstatistics, JsonRequestBehavior.AllowGet)); }
public void ClearQueryStrings() { QueryStrings.Clear(); if (PageUrl != null) { SetPageUrl(new Uri(PageUrl).AbsolutePath); } }
/// <summary> /// This method requires a username in order to get the role id of that user. /// </summary> /// <param name="username">The username</param> /// <returns>Returns the role id.</returns> public int returnRoleId(string username) { QueryStrings queryStrings = new QueryStrings(); UserAccount user = new UserAccount(); user = queryStrings.selectSingleUser(username); return(user.roleId); }
/// <summary> /// This method requires a username in order to get the username of that user. /// </summary> /// <param name="username">The username</param> /// <returns>Returns the username.</returns> public string returnUsername(string username) { QueryStrings queryStrings = new QueryStrings(); UserAccount user = new UserAccount(); user = queryStrings.selectSingleUser(username); return(user.username); }
/// <summary> /// This method requires a user id in order to get all the prestation indicators of that user. /// </summary> /// <param name="id">The id</param> /// <returns>Returns a list of all the prestation indicators of the selected user.</returns> public List <PrestationIndicator> getPrestationIndicatorsById(int id) { // return list of prestation indicators QueryStrings queryStrings = new QueryStrings(); List <PrestationIndicator> piList = queryStrings.getPrestationIndicatorsById(id); return(piList); }
public ActionResult MyEmployeeDashboard() { DataTable EmployeeNames = new QueryStrings().GetUserNames(); var data = from dt in EmployeeNames.AsEnumerable() select dt.Field <string>("users"); ViewBag.Names = data.ToList(); return(View()); }
/// <summary> /// Method using for generating uri with custom attributes. /// </summary> /// <param name="pageName">Page name.</param> /// <param name="item">QuerString item which contains atttribute and value.</param> /// <returns>Return query string.</returns> protected string GenerateURI(string pageName, QueryStrings item) { string querystring = ""; if (item != null) { querystring = GetQueryStringBuilderInstance().AddQueryItem(item); } return(pageName + "?" + querystring); }
/// <summary> /// Fixed: /// </summary> public static string Search() { var dataSet = Get( searchIndexes: QueryStrings.Data("text").SearchIndexes(), offset: QueryStrings.Int("offset"), pageSize: Parameters.General.SearchPageSize); return(MainContainer( text: QueryStrings.Data("text"), offset: 0, results: dataSet?.Tables["Main"].AsEnumerable(), count: Rds.Count(dataSet)).ToString()); }
/// <summary> /// Fixed: /// </summary> public static string Search() { var ss = new SiteSettings(); var dataSet = Get( searchText: QueryStrings.Data("text"), dataTableName: "SearchResults", offset: QueryStrings.Int("offset"), pageSize: Parameters.General.SearchPageSize); return(MainContainer( ss: ss, text: QueryStrings.Data("text"), offset: 0, results: dataSet?.Tables["SearchResults"].AsEnumerable(), count: Rds.Count(dataSet)).ToString()); }
public ActionResult MyEmployeeDashboardSpendingHours(string Date, string Name) { string FDate = Date.Split(':').First(); string LastDate = Date.Split(':').Last(); string EMpId = Name.Split('(').Last().Split(')').First(); int UserId = Convert.ToInt32(EMpId);// 60814; DateTime Fromdate = Convert.ToDateTime(FDate); DateTime ToDate = Convert.ToDateTime(LastDate); DataTable BeingOntimeData = new QueryStrings().GetBeingOntimeData(FDate, LastDate, UserId); ArrayList EmployeeDashboardSpendingstatistics = new ArrayList(); #region commneted //string[] time = new string[] { "7:00", "7:30", "8:00", "8:30", "9:00", "9:30", "10:00", "10:30", "11:00", "11:30", "12:00", "12:30", "13:00", }; //int[] count = new int[] { 40, 10, 94, 272, 320, 10, 50, 2, 3, 7, 1, 2, 6 }; // var time = BeingOntimeData.AsEnumerable().Select(r => r[1]).ToList(); // var count = BeingOntimeData.AsEnumerable().Select(r => r[2]).ToList(); #endregion List <DateTime> DateData = new List <DateTime>(); List <string> CountData = new List <string>(); for (DateTime date = Fromdate; date <= ToDate; date = date.AddDays(1.0)) { DateData.Add(date); } for (DateTime date = DateData[0]; date <= DateData[DateData.Count - 1]; date = date.AddDays(1.0)) { CountData.Add(GetTimeValue(BeingOntimeData, date)); } for (int i = 0; i < CountData.Count(); i++) { string att_time = DateData[i].ToString("dd-MMM-yy"); string attendance = CountData[i].ToString(); EmployeeDashboardSpendingstatistics.Add(new { att_time, attendance }); } return(Json(EmployeeDashboardSpendingstatistics, JsonRequestBehavior.AllowGet)); }
private void ucf2_btnAddEventClick(object sender, EventArgs e) { UserControlGraph ucf2 = (UserControlGraph)sender; if (PrincipalHelper.GetUserPrincipal().HasSupervisor&& (model.StrankaZaposleni != null && model.StrankaZaposleni.Count > 0)) { List <QueryStrings> queryList = new List <QueryStrings>(); int employeeID = 0; if (model != null) { employeeID = model.StrankaZaposleni[0].idOsebe; } QueryStrings item = new QueryStrings() { Attribute = Enums.QueryStringName.action.ToString(), Value = "1" }; queryList.Add(item); item = new QueryStrings() { Attribute = Enums.QueryStringName.recordId.ToString(), Value = "0" }; queryList.Add(item); item = new QueryStrings() { Attribute = Enums.QueryStringName.eventClientId.ToString(), Value = clientID.ToString() }; queryList.Add(item); item = new QueryStrings() { Attribute = Enums.QueryStringName.eventCategorieId.ToString(), Value = ucf2 != null?ucf2.CategorieID.ToString() : (-1).ToString() }; queryList.Add(item); item = new QueryStrings() { Attribute = Enums.QueryStringName.eventEmployeeId.ToString(), Value = employeeID.ToString() }; queryList.Add(item); ClearSessionsAndRedirect(true, GenerateURI("../Events/EventsForm.aspx", queryList)); } else { ErrorLabel.Text = "Skrbnik in zaposlen za stranko ni izbran!"; } }
public IQueryable <DTO_CUS_DOC_File> Get() { var result = BS_CUS_DOC_File.get_CUS_DOC_File(db, PartnerID, QueryStrings, true).ToList(); if (QueryStrings.Any(d => d.Key == "IncludeOwner")) { var query = db.tbl_CUS_DOC_File .Where(d => d.IsDeleted == false && d.IsHidden != true && d.IDPartner == PartnerID && (d.ModifiedBy == Username || d.CreatedBy == Username)); if (QueryStrings.Any(d => d.Key == "IDFolder")) { var IDList = QueryStrings.FirstOrDefault(d => d.Key == "IDFolder").Value.Replace("[", "").Replace("]", "").Split(','); List <int> IDs = new List <int>(); foreach (var item in IDList) { if (int.TryParse(item, out int i)) { IDs.Add(i); } else if (item == "null") { query = query.Where(d => !d.tbl_CUS_DOC_FileInFolder.Any()); } } if (IDs.Count > 0) { query = query.Where(d => d.tbl_CUS_DOC_FileInFolder.Any(c => c.IDFolder.HasValue && IDs.Contains(c.IDFolder.Value))); } } var result2 = BS_CUS_DOC_File.ctoDTO(query).ToList(); if (result2.Count > 0) { foreach (var item in result2) { if (!result.Any(d => d.ID == item.ID)) { result.Add(item); } } } } return(result.AsQueryable()); }
/// <summary> /// Fixed: /// </summary> public static string SearchJson(Context context) { var ss = new SiteSettings(); var offset = QueryStrings.Int("offset"); var searchText = QueryStrings.Data("text"); var dataSet = Get( context: context, searchText: searchText, dataTableName: "SearchResults", offset: offset, pageSize: Parameters.General.SearchPageSize); var dataRows = dataSet?.Tables["SearchResults"].AsEnumerable(); var res = new ResponseCollection(); return(offset == 0 ? res .ReplaceAll( "#MainContainer", MainContainer( context: context, ss: ss, text: searchText, offset: 0, results: dataRows, count: Rds.Count(dataSet))) .Focus("#Search") .ToJson() : res .Append( "#SearchResults", new HtmlBuilder().Results( context: context, ss: ss, text: searchText, offset: offset, dataRows: dataRows)) .Val( "#SearchOffset", (dataRows != null && dataRows.Any() && dataRows.Count() == Parameters.General.SearchPageSize ? offset + Parameters.General.SearchPageSize : -1).ToString()) .ToJson()); }
/// <summary> /// Displays the page for viewing an entity. /// </summary> public virtual void View <T>() where T : IEntity { Guid id = QueryStrings.GetID(Command.TypeName); string uniqueKey = QueryStrings.GetUniqueKey(Command.TypeName); if (id != Guid.Empty) { View <T>(id); } else if (uniqueKey != String.Empty) { View <T>(uniqueKey); } else { throw new InvalidOperationException("Cannot view entity. No identifier found."); } }
/// <summary> /// Loads the entity specified by the query string and prepares it for viewing. /// </summary> /// <returns>The entity specified by the query string.</returns> public virtual T PrepareView <T>() where T : IEntity { Guid goalID = QueryStrings.GetID(Command.TypeName); string goalKey = QueryStrings.GetUniqueKey(Command.TypeName); if (goalID != Guid.Empty) { return((T)LoadEntity <T>(goalID)); } else if (goalKey != String.Empty) { return((T)LoadEntity <T>(goalKey)); } else { throw new InvalidOperationException("Cannot find entity ID or unique key in query string."); } }
/// <summary> /// Fixed: /// </summary> public static bool Login(Context context) { var demoModel = new DemoModel().Get( context: context, where : Rds.DemosWhere() .Passphrase(QueryStrings.Data("passphrase")) .CreatedTime( DateTime.Now.AddDays(Parameters.Service.DemoUsagePeriod * -1), _operator: ">=")); if (demoModel.AccessStatus == Databases.AccessStatuses.Selected) { var loginId = LoginId(demoModel, "User1"); var password = Strings.NewGuid().Sha512Cng(); if (!demoModel.Initialized) { var idHash = new Dictionary <string, long>(); demoModel.Initialize(context: context, idHash: idHash, password: password); } else { Rds.ExecuteNonQuery( context: context, statements: Rds.UpdateUsers( param: Rds.UsersParam().Password(password), where : Rds.UsersWhere().LoginId(loginId))); } new UserModel() { LoginId = loginId, Password = password }.Authenticate( context: context, returnUrl: string.Empty); SiteInfo.Reflesh(context: context, force: true); return(Sessions.LoggedIn()); } else { return(false); } }
public ActionResult Inpunch() { DataTable hourwiseData = new QueryStrings().GetInpunhData(DateTime.Now.ToString("yyyy-MM-dd")); //DataTable hourwiseData = new QueryStrings().GetInpunhData("2018-02-22"); ArrayList plannedvsunplanned = new ArrayList(); var Time = Enumerable.Range(0, 24).ToArray(); List <int> Data = new List <int>(); for (int hour = 0; hour < 24; hour++) { // plannedvsunplanned.Add(hour.ToString()); Data.Add(GetHourValue(hourwiseData, hour)); } plannedvsunplanned.Add(Time); plannedvsunplanned.Add(Data.ToArray()); return(Json(plannedvsunplanned, JsonRequestBehavior.AllowGet)); }
private static String RedirectToEvent(int eventID, int clientID, int categorieID, int employeeID = 0) { List <QueryStrings> queryList = new List <QueryStrings>(); QueryStrings item = new QueryStrings() { Attribute = Enums.QueryStringName.action.ToString(), Value = "2" }; //edit queryList.Add(item); item = new QueryStrings() { Attribute = Enums.QueryStringName.recordId.ToString(), Value = eventID.ToString() }; queryList.Add(item); item = new QueryStrings() { Attribute = Enums.QueryStringName.eventClientId.ToString(), Value = clientID.ToString() }; queryList.Add(item); item = new QueryStrings() { Attribute = Enums.QueryStringName.eventCategorieId.ToString(), Value = categorieID.ToString() }; queryList.Add(item); item = new QueryStrings() { Attribute = Enums.QueryStringName.eventEmployeeId.ToString(), Value = employeeID.ToString() }; queryList.Add(item); QueryStringBuilder instance = new QueryStringBuilder(queryList); if (HttpContext.Current.Request.IsLocal) { return("/Pages/CodeList/Events/EventsForm.aspx?" + instance.GenerateQueryString()); } else { return(ConfigurationManager.AppSettings["ServerTag"].ToString() + "Pages/CodeList/Events/EventsForm.aspx?" + instance.GenerateQueryString()); } }
private void Parse(string queryString) { string[] parts = queryString.Split('&'); foreach (string part in parts) { int equalToPosition = part.IndexOf('='); string name = part.Substring(0, equalToPosition); string val = part.Substring(equalToPosition + 1); val = HttpUtility.UrlDecode(val); if (StringHelper.IsEqual(name, ENCRYPTED_KEY)) { if (val.Length > 0) { string decryptedString = HttpUtility.UrlDecode(StringHelper.Decrypt(val)); string[] keyValue = decryptedString.Split('&'); for (int i = 0; i < keyValue.Length; i++) { string param = keyValue[i]; equalToPosition = param.IndexOf('='); if (equalToPosition > 0) { string paramName = param.Substring(0, equalToPosition); string paramValue = param.Substring(equalToPosition + 1); QueryStrings.Add(paramName, paramValue); } } } } else { QueryStrings.Add(name, val); } } }
public string Remind() { if (Parameters.Reminder.Enabled) { if (QueryStrings.Bool("NoLog")) { return(ReminderScheduleUtilities.Remind()); } else { var log = new SysLogModel(); var json = ReminderScheduleUtilities.Remind(); log.Finish(json.Length); return(json); } } else { return(null); } }
public string Do() { if (Parameters.BackgroundTask.Enabled) { if (QueryStrings.Bool("NoLog")) { return(BackgroundTasks.Do()); } else { var log = new SysLogModel(); var html = BackgroundTasks.Do(); log.Finish(html.Length); return(html); } } else { return(null); } }