protected void btnAplly_Click(object sender, System.EventArgs e) { DateTime StartDate = new DateTime(0); DateTime EndDate = new DateTime(0); //SetDates(ddPeriod.Value, out StartDate, out EndDate, txtDateFrom.Text, txtDateTo.Text); UserReport.GetDates(ddPeriod.Value, out StartDate, out EndDate, dtcStartDate.SelectedDate.ToShortDateString(), dtcEndDate.SelectedDate.ToShortDateString()); pc["GroupAndUserStat_ddPeriod"] = ddPeriod.Value; if (ddPeriod.Value == "9") { pc["GroupAndUserStat_Start"] = StartDate.ToString(culture); pc["GroupAndUserStat_End"] = EndDate.ToString(culture); } if (UserID == 0) { BindGroupStat(SGroupID, StartDate, EndDate); tblGroupStat.Visible = true; tblUser1.Visible = false; tblUser2.Visible = false; tblUser3.Visible = false; } else { BindUserStat(UserID, StartDate, EndDate); tblGroupStat.Visible = false; tblUser1.Visible = true; tblUser2.Visible = true; tblUser3.Visible = true; } }
/// <summary> /// 举报视频 /// </summary> /// <param name="loginUserId">登录用户编号</param> /// <param name="videoId">视频编号</param> /// <returns></returns> public bool ReportVideo(int loginUserId, int videoId) { var success = Execute <bool>((db) => { var user = db.User.FirstOrDefault(u => u.State == false && u.Id == loginUserId); AssertUtil.IsNotNull(user, "用户不存在或者被禁用"); var video = db.Video.FirstOrDefault(v => v.VideoSource & (v.VideoState == 3 || v.VideoState == 2) && v.Id == videoId); AssertUtil.IsNotNull(video, "视频不存在或者审核不通过"); var userReport = db.UserReport.FirstOrDefault(v => v.State == false && v.UserId == user.Id && v.EntityId == video.Id && v.EntityType == (int)UserReportEnum.Video); AssertUtil.IsNull(userReport, "您已经举报过该视频"); var newUserReport = new UserReport() { CreateTime = DateTime.Now, CreateUserId = user.Id, EntityType = (int)UserReportEnum.Video, UserId = user.Id, EntityId = (int)video.Id }; db.UserReport.Add(newUserReport); video.ReportCount++; db.Entry(video).State = EntityState.Modified; db.Configuration.ValidateOnSaveEnabled = false; return(db.SaveChanges() > 0); }); if (success) { CreateCache <UserReport>(); CreateCache <Video>(); } return(success); }
private void GetIMStat() { lblContactGroup.Text = ddContactGroup.SelectedItem.Text; repUsers.DataSource = UserReport.GetListUsers(int.Parse(ddContactGroup.SelectedItem.Value)); repUsers.DataBind(); }
private void repTypes_Bound(object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e) { int OriginalId = (int)DataBinder.Eval(e.Item.DataItem, "OriginalId"); Repeater repSessions = (Repeater)e.Item.FindControl("repSessions"); Label lblNone = (Label)e.Item.FindControl("lblNone"); if (repSessions != null) { DateTime StartDate = DateTime.MinValue; DateTime EndDate = DateTime.MinValue; //SetDates(ddPeriod.Value, out StartDate, out EndDate, fromDate.Text, toDate.Text); UserReport.GetDates(ddPeriod.Value, out StartDate, out EndDate, dtcStartDate.SelectedDate.ToShortDateString(), dtcEndDate.SelectedDate.ToShortDateString()); string sFilter = " " + LocRM.GetString("tGroupName") + ": " + ddContactGroup.SelectedItem.Text; sFilter += "<br/> " + LocRM.GetString("tPeriod") + ": " + StartDate.ToShortDateString() + " - " + EndDate.ToShortDateString(); _header.Filter = sFilter; repSessions.DataSource = UserReport.GetListIMSessionsByUserAndDate(OriginalId, StartDate, EndDate); repSessions.DataBind(); if (repSessions.Items.Count > 0) { lblNone.Visible = false; TotalImSessions += repSessions.Items.Count; } else lblNone.Text = LocRM.GetString("NoneDuring"); } }
private void Submit() { this.submitting = false; if (Application.isPlaying) { if (UnityUserReporting.CurrentClient != null) { this.userReport.Summary = this.summary; this.userReport.Fields.Add(new UserReportNamedValue("Notes", this.description)); this.userReport.Dimensions.Add(new UserReportNamedValue("DevLog", "True")); this.userReport.IsHiddenWithoutDimension = true; // Send UnityUserReporting.CurrentClient.SendUserReport(this.userReport, (success, br2) => { this.userReport = null; if (EditorUtility.DisplayDialog("Dev Log", "Dev log submitted. Would you like to view it?", "View", "Don't View")) { string url = string.Format("https://developer.cloud.unity3d.com/userreporting/direct/projects/{0}/reports/{1}", br2.ProjectIdentifier, br2.Identifier); Application.OpenURL(url); } }); } else { EditorUtility.DisplayDialog("Dev Log", "Bug Reporting is not configured. Bug Reporting is required for dev logs. Call UnityUserReporting.Configure() to configure In-Game Bug Reporting or add the UserReportingPrefab to your scene.", "OK"); } } else { EditorUtility.DisplayDialog("Dev Log", "Dev logs can only be sent in play mode.", "OK"); } }
private void Create() { this.creating = false; if (Application.isPlaying) { if (UnityUserReporting.CurrentClient != null) { UnityUserReporting.CurrentClient.TakeScreenshot(2048, 2048, s => { }); UnityUserReporting.CurrentClient.TakeScreenshot(512, 512, s => { }); UnityUserReporting.CurrentClient.CreateUserReport((br) => { this.SetThumbnail(br); this.summary = string.Empty; this.description = string.Empty; this.userReport = br; }); } else { EditorUtility.DisplayDialog("Dev Log", "Bug Reporting is not configured. Bug Reporting is required for dev logs. Call UnityUserReporting.Configure() to configure Bug Reporting or add the UserReportingPrefab to your scene.", "OK"); } } else { EditorUtility.DisplayDialog("Dev Log", "Dev logs can only be sent in play mode.", "OK"); } }
//[ValidateAntiForgeryToken] public async Task <IActionResult> Edit(int id, [Bind("UserReportId,SignInDateFrom,SignInDateTo,AssitanceFrom,AssitanceTo,AgeFrom,AgeTo,AssitanceCountFrom,AssitanceCountTo,PayDateFrom,PayDateTo,MovementTypeId,PaymentMediaId")] UserReport userReport) { if (id != userReport.UserReportId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(userReport); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!UserReportExists(userReport.UserReportId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["MovementTypeId"] = new SelectList(_context.MovementType, "MovementTypeId", "Description", userReport.MovementTypeId); ViewData["PaymentMediaId"] = new SelectList(_context.PaymentMedia, "PaymentMediaId", "PaymentMediaDescription", userReport.PaymentMediaId); return(View(userReport)); }
private void deleteTransientUserReport(UserReport userReport, ReportProjectDBEntities entities) { // delete the summarize fields var sumFields = (from ursf in entities.UserReportSummarizeField where ursf.UserReportID == userReport.UserReportID select ursf).ToList(); foreach (UserReportSummarizeField sumField in sumFields) { entities.DeleteObject(sumField); } // delete the fields //TODO: NOt necessary, must be a cascade delete in the database // delete the parameters var userReportParms = (from urp in entities.UserReportParameter where urp.UserReportID == userReport.UserReportID select urp).ToList(); foreach (UserReportParameter userReportParameter in userReportParms) { entities.DeleteObject(userReportParameter); } // delete the user report entities.DeleteObject(userReport); entities.SaveChanges(); }
/// <inheritdoc cref="IUserReportingPlatform"/> public virtual void ModifyUserReport(UserReport userReport) { // Active Scene Scene activeScene = SceneManager.GetActiveScene(); userReport.DeviceMetadata.Add(new UserReportNamedValue("ActiveSceneName", activeScene.name)); // Main Camera Camera mainCamera = Camera.main; if (mainCamera != null) { userReport.DeviceMetadata.Add(new UserReportNamedValue("MainCameraName", mainCamera.name)); userReport.DeviceMetadata.Add(new UserReportNamedValue("MainCameraPosition", mainCamera.transform.position.ToString())); userReport.DeviceMetadata.Add(new UserReportNamedValue("MainCameraForward", mainCamera.transform.forward.ToString())); // Looking At RaycastHit hit; if (Physics.Raycast(mainCamera.transform.position, mainCamera.transform.forward, out hit)) { GameObject lookingAt = hit.transform.gameObject; userReport.DeviceMetadata.Add(new UserReportNamedValue("LookingAt", hit.point.ToString())); userReport.DeviceMetadata.Add(new UserReportNamedValue("LookingAtGameObject", lookingAt.name)); userReport.DeviceMetadata.Add(new UserReportNamedValue("LookingAtGameObjectPosition", lookingAt.transform.position.ToString())); } } }
/// <summary> /// 举报评论 /// </summary> /// <param name="loginUserId">登录用户编号</param> /// <param name="commentId">评论编号</param> /// <returns></returns> public bool ReportComment(int loginUserId, int commentId) { var success = Execute <bool>((db) => { var user = db.User.FirstOrDefault(u => u.State == false && u.Id == loginUserId); AssertUtil.IsNotNull(user, "用户不存在或者被禁用"); var comment = db.Comments.FirstOrDefault(c => c.State >= 0 & c.Id == commentId); AssertUtil.IsNotNull(comment, "评论不存在或者审核不通过"); var userReport = db.UserReport.FirstOrDefault(v => v.State == false && v.UserId == user.Id && v.EntityId == comment.Id && v.EntityType == (int)UserReportEnum.Comment); AssertUtil.IsNull(userReport, "您已经举报过该评论"); var newUserReport = new UserReport() { CreateTime = DateTime.Now, CreateUserId = user.Id, EntityType = (int)UserReportEnum.Comment, UserId = user.Id, EntityId = comment.Id }; db.UserReport.Add(newUserReport); comment.ReportCount++; db.Entry(comment).State = EntityState.Modified; db.Configuration.ValidateOnSaveEnabled = false; return(db.SaveChanges() > 0); }); if (success) { CreateCache <UserReport>(); CreateCache <Comments>(); } return(success); }
public async Task <UserReport> ReportUser(Guid userToReportId, Guid userReportingId, string text) { var users = await _context.Users.AsNoTracking().Where(u => u.Id.Equals(userReportingId) || u.Id.Equals(userToReportId)).ToListAsync(); if (users.Count != 2) { return(null); } var userReporting = users.FirstOrDefault(u => u.Id.Equals(userReportingId)); var userReported = users.FirstOrDefault(u => u.Id.Equals(userToReportId)); var admin = await _context.Admins.AsNoTracking().FirstOrDefaultAsync(a => a.UserReports.Count.Equals(_context.Admins.Min(ac => ac.UserReports.Count))); var userReport = new UserReport { Admin = admin, UserReporting = userReporting, UserReported = userReported, DateReporting = DateTimeOffset.Now, Text = text }; _context.Entry(admin).State = EntityState.Unchanged; _context.Entry(userReporting).State = EntityState.Unchanged; _context.Entry(userReported).State = EntityState.Unchanged; _context.UserReports.Add(userReport); await _context.SaveChangesAsync(); return(userReport); }
public async Task <IActionResult> OnGetAsync() { string ReportedUserId = HttpContext.Session.GetString("ReportedUserId"); if (string.IsNullOrEmpty(ReportedUserId)) { return(StatusCode(403)); } string Reason = HttpContext.Session.GetString("Reason"); string EvidenceFileName = HttpContext.Session.GetString("EvidenceFileName"); UserReport ur = new UserReport() { UserReportId = Guid.NewGuid().ToString(), ReportedUser = await _userManager.FindByIdAsync(ReportedUserId), ReportingUser = await _userManager.GetUserAsync(User), ReportedContent = Reason, ReportFileEvidence = EvidenceFileName, TimeStamp = DateTime.Now }; _context.UserReport.Add(ur); await _context.SaveChangesAsync(); HttpContext.Session.Clear(); return(Page()); }
private void BindGroups() { if (!IsAdmin) { GroupRow.Visible = false; lblUser.Visible = true; lstGroup1.Visible = false; lstUser.Visible = false; lblUser.Text = CommonHelper.GetUserStatus(iCurUserId); } using (IDataReader reader = UserReport.GetListGroupsAsTree(IsPartner)) { while (reader.Read()) { if (IsAdmin) { string GroupName = CommonHelper.GetResFileString(reader["GroupName"].ToString()); string GroupId = reader["GroupId"].ToString(); int Level = (int)reader["Level"]; for (int i = 0; i < Level; i++) { GroupName = " " + GroupName; } ListItem liItem = new ListItem(GroupName, GroupId); lstGroup1.Items.Add(liItem); if (GroupId == "2") //Admins { lstGroup1.SelectedItem.Selected = false; liItem.Selected = true; BindUser(int.Parse(GroupId)); } } } } }
private int saveUserReport(int reportID, int reportLayoutStyleID, string userReportName, bool isSummaryOnly, int userId, bool isCustom, string associationNumber, int formatTypeID, bool isTransient, bool isTurnOffPageBreak, bool includeTitlePage) { ReportProjectDBEntities entities = new ReportProjectDBEntities(); ReportLayoutStyle reportLayoutStyle = entities.ReportLayoutStyle.FirstOrDefault(rl => rl.ReportLayoutStyleID == reportLayoutStyleID); UserReport ur = new UserReport(); ur.ReportLayoutStyleID = reportLayoutStyle.ReportLayoutStyleID; ur.FormatTypeID = formatTypeID; ur.ReportID = reportID; ur.UserID = userId; ur.CreatedByUserID = userId; ur.CreatedDate = DateTime.Now; ur.ModifiedDate = DateTime.Now; ur.UserReportName = userReportName; ur.ModifiedByUserID = userId; ur.IsCustom = isCustom; ur.ClientNumber = associationNumber; ur.IsSummaryOnly = isSummaryOnly; ur.IsTransient = isTransient; ur.IsTurnOffPageBreak = isTurnOffPageBreak; ur.IncludeTitlePage = includeTitlePage; entities.AddToUserReport(ur); entities.SaveChanges(); return(ur.UserReportID); }
public async Task <IActionResult> GenerateUserReport(UserReport query) { // var orders = new List<OrderResponse>(); var documents = await documentRepository.GetReport(query); // foreach (var document in documents) // { // orders.Add(new OrderResponse // { // Document = document, // Detail = await detailRepository.Find(document.Type, document.Serie, document.Correlative), // Tax = await taxRepository.Find(document.Type, document.Serie, document.Correlative) // }); // } var binary = await reportService.GenerateUserReport(documents); var b64str = Convert.ToBase64String(binary); return(Json(new StandardResponse { Status = 200, Data = b64str })); }
public async Task <Unit> Handle(AddUserToReportCommand <Guid> request, CancellationToken cancellationToken) { var businessUseCaseExceptions = new List <string>(); var user = await _context.ApplicationUsers.FindAsync(request.UserId); if (user == null) { businessUseCaseExceptions.Add($"The object {nameof(ApplicationUser)} does not contain the {request.UserId} key!"); } var report = await _context.Reports.FindAsync(request.ReportId); if (report == null) { businessUseCaseExceptions.Add($"The object {nameof(Report<Guid>)} does not contain the {request.ReportId} key!"); } if (businessUseCaseExceptions.Any()) { throw new BusinessUseCaseException(businessUseCaseExceptions); } var userReport = new UserReport <Guid> { UserId = request.UserId, ReportId = request.ReportId }; await _context.UserReports.AddAsync(userReport, cancellationToken); return(Unit.Value); }
public async Task <IActionResult> PutUserReport(int id, UserReport userReport) { if (id != userReport.UserReportId) { return(BadRequest()); } _context.Entry(userReport).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!UserReportExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> GenerateUserRawReport(UserReport query) { var documents = await documentRepository.GetReport(query); if (query.Page > 0 && query.Size > 0) { var offset = (query.Page * query.Size) - query.Size; documents = documents.Skip(offset).Take(query.Size).ToList(); } var reports = new List <Report>(); foreach (var group in documents) { var service = await serviceRepository.Find(group.Key); reports.Add(new Report { Quantity = group.ToList().Count, Service = service.Name, Amount = group.Sum(d => d.TotalAmount) }); } return(Json(new StandardResponse { Status = 200, Data = reports })); }
public async Task <int> ReportUser(string id, string text) { if (string.IsNullOrEmpty(id)) { return(0); } User user = await _userManager.FindByIdAsync(id); User currentUser = await _userManager.GetUserAsync(User); if (user == null || currentUser.Id == user.Id || string.IsNullOrEmpty(text.Trim())) { return(0); } UserReport report = new UserReport() { Date = DateTime.Now, ReportFromId = currentUser.Id, ReportToId = id, Reason = text }; _db.UserReports.Add(report); await _db.SaveChangesAsync(); return(1); }
public async Task <UserReport> CreateUserReport(CreateUserReportRequest request) { var baseReport = await CreateBaseReport(request.Subject, request.Content, request.IsPrivate, request.EventDate, ReportCategoryType.User); if (await database.UserRepository.FindById(request.UserToReportId) == null) { throw new EntityNotFoundException("User to report not found"); } var userReport = UserReport.Create(baseReport.Id, request.UserToReportId, request.WitnessId); userReport.SetReport(baseReport); using (var transaction = database.BeginTransaction().Transaction) { if (!await database.ReportRepository.Insert(baseReport, false)) { throw new DatabaseException(); } if (!await database.UserReportRepository.Insert(userReport, false)) { throw new DatabaseException(); } transaction.Complete(); } await reportImageService.UploadReportImages(httpContextReader.CurrentUserId, baseReport, request.Images); return(userReport); }
public void CalculateMonthlySalary_GivenNumber_ShouldReturnNumberDividedBy12(int yearlySalary, int expected) { var instanceOfUserReport = new UserReport(); var result = instanceOfUserReport.CalculateMonthlySalary(yearlySalary); Assert.Equal(expected, result); }
private void CreateUserReportCallback(UserReport bugReport) { //IL_003d: Unknown result type (might be due to invalid IL or missing references) //IL_0042: Unknown result type (might be due to invalid IL or missing references) //IL_00ac: Unknown result type (might be due to invalid IL or missing references) if (string.IsNullOrEmpty(bugReport.get_ProjectIdentifier())) { Log.Warning("The user report's project identifier is not set. Please setup cloud services using the Services tab or manually specify a project identifier when calling UnityUserReporting.Configure().", 171, "C:\\BuildAgents\\AgentB\\work\\cub_client_win64_develop\\client\\DofusCube.Unity\\Assets\\Core\\Code\\States\\OptionLayer\\BugReportState.cs"); } string str = "Unknown"; string str2 = "0.0"; foreach (UserReportNamedValue deviceMetadatum in bugReport.get_DeviceMetadata()) { UserReportNamedValue current = deviceMetadatum; string name = current.get_Name(); if (!(name == "Platform")) { if (name == "Version") { str2 = current.get_Value(); } } else { str = current.get_Value(); } } bugReport.get_Dimensions().Add(new UserReportNamedValue("Platform.Version", str + "." + str2)); m_currentBugReport = bugReport; m_isCreatingUserReport = false; }
public void CalculateMagicYear_GivenNumber_ShouldReturnNumberPlus65(int startYear, int expected) { var instanceOfUserReport = new UserReport(); var result = instanceOfUserReport.CalculateMagicYear(startYear); Assert.Equal(expected, result); }
public MainPage() { InitializeComponent(); // LOAD DATA CHO LIST MYREPORT LoadData(); #region lv_UserReport // HÀNH ĐỘNG NHẬN ITEM ĐÃ TOUCH VÀO lv_UserReport.ItemSelected += (object sender, SelectedItemChangedEventArgs e) => { var item = (UserReport)e.SelectedItem; report = item; }; // HÀNH ĐỘNG REFRESH lv_UserReport.RefreshCommand = new Command(() => { LoadData(); lv_UserReport.IsRefreshing = false; }); #endregion #region lv_CallLog lv_CallLog.RefreshCommand = new Command(() => { LoadData(); lv_CallLog.IsRefreshing = false; }); #endregion }
public async Task <ActionResult <UserReport> > PostUserReport(UserReport userReport) { _context.UserReports.Add(userReport); await _context.SaveChangesAsync(); return(CreatedAtAction(nameof(GetUserReport), new { id = userReport.UserReportId }, userReport)); }
private int saveUserReportFields(int userReportID, List <RptField> fields, int userId, List <RptField> summarizeFields) { ReportProjectDBEntities entities = new ReportProjectDBEntities(); UserReport ur = entities.UserReport.Where(urp => urp.UserReportID == userReportID).First(); foreach (var field in fields) { string sortdir = "A"; if (field.SortDirection == SortDirectionEnum.Descending) { sortdir = "D"; } UserReportField urf = new UserReportField(); urf.UserReport = ur; urf.ReportField = entities.ReportField.Where(r => r.ReportFieldID == field.ReportFieldID).First(); urf.CreatedByUserID = userId; urf.CreatedDate = DateTime.Now; urf.ColumnOrder = field.ColumnOrder; urf.CustomName = field.Name; urf.SortDirection = sortdir; urf.SortOrder = field.SortOrder; urf.GroupOrder = field.GroupOrder; urf.IncludePageBreak = field.IncludePageBreak; urf.CoverageCode = field.CoverageCode; entities.AddToUserReportField(urf); } entities.SaveChanges(); saveUserReportSummarizeFields(summarizeFields, entities, ur, userId); return(ur.UserReportID); }
public async Task <ResultModel <bool> > ReportUserAsync(CreateUserReportRequestModel model, string reporterId) { var isBanned = await this.usersService.IsBanned(reporterId); if (isBanned) { return(new ResultModel <bool> { Errors = { StoryReportErrors.BannedUserReports } }); } var userReport = new UserReport { Title = model.Title, Content = model.Content, IsRead = false, ReportedId = model.ReportedId, ReporterId = reporterId, }; await this.dbContext.UserReports.AddAsync(userReport); await this.dbContext.SaveChangesAsync(); return(new ResultModel <bool> { Result = true, Success = true, }); }
protected void btnSubmit_Click(object sender, System.EventArgs e) { int userGroup = 1; // Alex Fix if (IsAdmin) { userGroup = int.Parse(lstGroup1.SelectedItem.Value); } else if (IsPartner /*Security.IsUserInGroup(InternalSecureGroups.Partner)*/) { userGroup = UserReport.GetGroupForPartnerUser(iCurUserId); } DataTable dt = UserReport.SearchHistory( /*DateTime.Parse(txtDateFrom.Text)*/ dtcStartDate.SelectedDate, /*DateTime.Parse(txtDateTo.Text).AddDays(1)*/ dtcEndDate.SelectedDate.AddDays(1).AddSeconds(-1), IsAdmin?int.Parse(lstUser.Value):iCurUserId, userGroup, int.Parse(lstContact.Value), int.Parse(lstGroup2.SelectedItem.Value), int.Parse(lstInOut.Value), txtKeyword.Text, chkOrder.Checked); MessRep.DataSource = dt.DefaultView; MessRep.DataBind(); //reader.Close(); }
public async Task <IActionResult> PutUserReport([FromRoute] string id, [FromBody] UserReport userReport) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != userReport.ReportID) { return(BadRequest()); } _context.Entry(userReport).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!UserReportExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
/// <summary> /// Saves a user report to disk. /// </summary> /// <param name="userReport">The user report.</param> public void SaveUserReportToDisk(UserReport userReport) { this.LogEvent(UserReportEventLevel.Info, "Saving user report to disk."); string json = this.Platform.SerializeJson(userReport); File.WriteAllText("UserReport.json", json); }
public List<UserReport> GetClientWiseUserReportsByProjectIdAndMonthAndYear(int projectId, Int32 Month, Int32 Year) { DataSet objDataSet = new DataSet(); List<UserReport> objlstUserReport = new List<UserReport>(); if (projectId <= 0) throw (new ArgumentOutOfRangeException("projectId")); SqlConnection myConnection = new SqlConnection(connectionString); SqlCommand sqlCmd = new SqlCommand("aspnet_starterkits_GetClientWiseUserReportsByProjectIdAndMonthAndYear", myConnection); sqlCmd.CommandType = CommandType.StoredProcedure; myConnection.Open(); SqlParameter SqlParamProjectId = new SqlParameter("@ProjectId", projectId); SqlParamProjectId.Direction = ParameterDirection.Input; sqlCmd.Parameters.Add(SqlParamProjectId); SqlParameter SqlParamMonth = new SqlParameter("@Month", Month); SqlParamProjectId.Direction = ParameterDirection.Input; sqlCmd.Parameters.Add(SqlParamMonth); SqlParameter SqlParamYear = new SqlParameter("@Year", Year); SqlParamProjectId.Direction = ParameterDirection.Input; sqlCmd.Parameters.Add(SqlParamYear); SqlDataAdapter objDataAdapter = new SqlDataAdapter(sqlCmd); objDataAdapter.Fill(objDataSet); DataRow objDataRow; if (objDataSet.Tables[0].Rows.Count > 0) { for (int iterator = 0; iterator < objDataSet.Tables[0].Rows.Count; iterator++) { objDataRow = objDataSet.Tables[0].Rows[iterator]; UserReport newUserReport = new UserReport((decimal)objDataRow["duration"], (string)objDataRow["UserName"], (string)objDataRow["Category"]); objlstUserReport.Add(newUserReport); } } myConnection.Close(); return objlstUserReport; }