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