public string GenerateHtmlReport()
{
RPCSHtmlReport htmlReport = new RPCSHtmlReport();
string reportTitle = "Отчет о синхронизации с Active Directory";
htmlReport.AddHeaderColumn("ФИО");
htmlReport.AddHeaderColumn("Принят");
htmlReport.AddHeaderColumn("ADLogin");
htmlReport.AddHeaderColumn("E-mail");
htmlReport.AddHeaderColumn("EmployeeID");
htmlReport.AddHeaderColumn("Должность (title)");
htmlReport.AddHeaderColumn("Подразделение (department)");
htmlReport.AddHeaderColumn("Руководитель (manager)");
htmlReport.AddHeaderColumn("Организация");
htmlReport.AddHeaderColumn("Офис (№ кабинета)");
htmlReport.AddHeaderColumn("Рабочий тел.");
htmlReport.AddHeaderColumn("Моб. (общедоступный)");
htmlReport.AddHeaderColumn("Терр. расп.");
htmlReport.AddHeaderColumn("Статус синхронизации ");
htmlReport.AddReportSection("Обновлены данные в на основе AD для сотрудников: ");
htmlReport = NewUsers.GenerateHtmlReportEntry(htmlReport);
htmlReport.AddReportSection("Обновлены данные в AD для учетных записей сотрудников: ");
htmlReport = UpdatedUsers.GenerateHtmlReportEntry(htmlReport);
htmlReport.AddReportSection("Не найдены в AD учетные записи для сотрудников: ");
htmlReport = NotFoundInAD.GenerateHtmlReportEntry(htmlReport);
return(htmlReport.GetHtmlReportContent(reportTitle));
}
/// <summary>
//add new users to the system
private void AddUsersLabel_Click(object sender, EventArgs e)
{
NewUsers newuser = new NewUsers();
//newuser.MdiParent = this;
newuser.ShowDialog();
}
public string[] GetData()
{
return(new string[] { Date.ToShortDateString(), SellsProfit.ToString() + "$", AdvsProfit.ToString() + "$",
DAU.ToString(), MAU.ToString(), LAU.ToString(), NewUsers.ToString(), PAU.ToString(),
NetworkPostsCount.ToString(), AvgSessionTime.ToString(), AvgSessionCount.ToString(),
ARPU.ToString(), ARPPU.ToString(), Involvement.ToString() + "%", ConversionRate.ToString() + "%" });
}
/// <summary>
/// Add a follower ID to a list, indicating that at the next iteration user must to be processed
/// </summary>
/// <param name="followerId">a follower ID</param>
public static void MarkNewFollower(String followerId)
{
lock (newUserLock)
{
NewUsers.Add(followerId);
}
}
/// <summary>
/// Return and remove from a list market followers
/// </summary>
/// <returns>a list of marked folloers</returns>
public static List <String> ReturnMarkedFollowers()
{
List <String> retUsers = new List <string>();
lock (newUserLock)
{
retUsers.AddRange(NewUsers);
NewUsers.Clear();
}
return(retUsers);
}
private NewUsers CreateObjects(IDataReader oReader)
{
NewUsers oNewUsers = new NewUsers();
NullHandler oHandler = new NullHandler(oReader);
while (oReader.Read())
{
NewUser oItem = CreateObject(oHandler);
oNewUsers.Add(oItem);
}
return(oNewUsers);
}
private string GetMailContent()
{
StreamReader sr = new StreamReader(@"ScriptsAndReferences\DailyStatusReport.htm");
string mailBody = sr.ReadToEnd();
sr.Close();
mailBody = mailBody.Replace("{availability}", Availability.ToString("f2") + "%");
mailBody = mailBody.Replace("{downloads}", Downloads.ToString("#,##0"));
mailBody = mailBody.Replace("{restore}", Restore.ToString("#,##0"));
if (Downloads == 0 || Restore == 0)
{
mailBody = mailBody.Replace("{warning}", "Please note that this report will not show the correct numbers for download and restore when ReplicatePackageStats Job is disabled or failing.");
}
else
{
mailBody = mailBody.Replace("{warning}", "");
}
mailBody = mailBody.Replace("{searchqueries}", SearchQueries.ToString("#,##0"));
mailBody = mailBody.Replace("{uploads}", Uploads.ToString());
mailBody = mailBody.Replace("{uniqueuploads}", UniqueUploads.ToString());
mailBody = mailBody.Replace("{newusers}", NewUsers.ToString());
mailBody = mailBody.Replace("{TrafficPerHour}", TrafficPerHour.ToString("#,##0"));
mailBody = mailBody.Replace("{trafficmax}", TrafficMax.ToString("#,##0"));
mailBody = mailBody.Replace("{trafficmin}", TrafficMin.ToString("#,##0"));
mailBody = mailBody.Replace("{RequestPerHour}", RequestPerHour.ToString());
mailBody = mailBody.Replace("{requestmax}", RequestMax.ToString());
mailBody = mailBody.Replace("{requestmin}", RequestMin.ToString());
mailBody = mailBody.Replace("{ErrorsPerHour}", ErrorsPerHour.ToString());
mailBody = mailBody.Replace("{errormax}", ErrorsMax.ToString());
mailBody = mailBody.Replace("{errormin}", ErrorsMin.ToString());
mailBody = mailBody.Replace("{IndexLag}", IndexLag.ToString());
mailBody = mailBody.Replace("{indexmax}", IndexMax.ToString());
mailBody = mailBody.Replace("{indexmin}", IndexMin.ToString());
mailBody = mailBody.Replace("{InstanceCount}", InstanceCount.ToString());
mailBody = mailBody.Replace("{instancemax}", InstanceMax.ToString());
mailBody = mailBody.Replace("{instancemin}", InstanceMin.ToString());
mailBody = mailBody.Replace("{overallworkercount}", OverallWorkerCount.ToString());
mailBody = mailBody.Replace("{successcount}", SuccessCount.ToString());
mailBody = mailBody.Replace("{failedjobnames}", string.Join(", ", FailedJobNames));
mailBody = mailBody.Replace("{notableissues}", string.Join("<br/>", NotableIssues));
mailBody = mailBody.Replace("{InstallUpdatesRestoresPerNuGetVersion}", InstallUpdatesRestoresByNuGetVersion());
mailBody = mailBody.Replace("{InstallUpdatesRestoresPerVSVersion}", InstallUpdatesRestoresByVSVersion());
mailBody = mailBody.Replace("{IISRequestsDistribution}", CreateTableForIISRequestsDistribution());
mailBody = mailBody.Replace("{IPRequestDistribution}", IPDetails());
mailBody = mailBody.Replace("{ResponseTime}", ResponseTimeDetails());
mailBody = mailBody.Replace("{UserAgent}", UserAgentDetails());
return(mailBody);
}
public JsonResult AddNewUsers(NewUsers newUsers)
{
var data = DataAccess.Account.AddNewUsers(newUsers.Users, newUsers.ClientId, newUsers.Permissions, UserHelper.Username);
if (data.Success)
{
foreach (var user in newUsers.Users.ToList())
{
string email = DataAccess.Account.GetAccountEmailAddress(user.Username);
Guid act = DataAccess.Account.GetAccountIdByUsername(user.Username);
var verifyUrl = System.Web.HttpContext.Current.Request.Url.GetLeftPart
(UriPartial.Authority) + "/Account/Verify/" + act;
SendRegistrationEmailLink(verifyUrl, email, user.Username, act.ToString(), user.FirstName, "");
}
}
return(Json(data));
}
public NewUsers Get()
{
NewUsers oNewUsers = null;
try
{
IDataReader reader = null;
reader = ExecuteQueryFunctions.ExeReader(_conn, "SELECT * FROM User_Table AS ut WHERE user_id !=1");
oNewUsers = CreateObjects(reader);
reader.Close();
_conn.Close();
}
catch (Exception e)
{
throw new ServiceException(e.Message, e);
}
return(oNewUsers);
}
public NewUsers GetsByeString(string sStr)
{
NewUsers oNewUsers = null;
try
{
IDataReader reader = null;
string QueryString = "SELECT * FROM User_Table WHERE user_id !=1 AND " + sStr;
reader = ExecuteQueryFunctions.ExeReader(_conn, QueryString);
oNewUsers = CreateObjects(reader);
reader.Close();
_conn.Close();
}
catch (Exception e)
{
throw new ServiceException(e.Message, e);
}
return(oNewUsers);
}
private string GetMailContent()
{
StreamReader sr = new StreamReader(@"ScriptsAndReferences\WeeklyStatusReport.htm");
string mailBody = sr.ReadToEnd();
sr.Close();
mailBody = mailBody.Replace("{availability}", Availability.ToString("f2") + "%");
mailBody = mailBody.Replace("{downloads}", Downloads.ToString("#,##0"));
mailBody = mailBody.Replace("{restore}", Restore.ToString("#,##0"));
mailBody = mailBody.Replace("{searchqueries}", SearchQueries.ToString("#,##0"));
mailBody = mailBody.Replace("{uniqueuploads}", UniqueUploads.ToString());
mailBody = mailBody.Replace("{uploads}", Uploads.ToString());
mailBody = mailBody.Replace("{newusers}", NewUsers.ToString());
mailBody = mailBody.Replace("{TrafficPerHour}", TrafficPerHour.ToString("#,##0"));
mailBody = mailBody.Replace("{trafficmax}", TrafficMax.ToString("#,##0"));
mailBody = mailBody.Replace("{trafficmin}", TrafficMin.ToString("#,##0"));
mailBody = mailBody.Replace("{RequestPerHour}", RequestPerHour.ToString());
mailBody = mailBody.Replace("{requestmax}", RequestMax.ToString());
mailBody = mailBody.Replace("{requestmin}", RequestMin.ToString());
mailBody = mailBody.Replace("{ErrorsPerHour}", ErrorsPerHour.ToString());
mailBody = mailBody.Replace("{errormax}", ErrorsMax.ToString());
mailBody = mailBody.Replace("{errormin}", ErrorsMin.ToString());
mailBody = mailBody.Replace("{IndexLag}", IndexLag.ToString());
mailBody = mailBody.Replace("{indexmax}", IndexMax.ToString());
mailBody = mailBody.Replace("{indexmin}", IndexMin.ToString());
mailBody = mailBody.Replace("{InstanceCount}", InstanceCount.ToString());
mailBody = mailBody.Replace("{instancemax}", InstanceMax.ToString());
mailBody = mailBody.Replace("{instancemin}", InstanceMin.ToString());
mailBody = mailBody.Replace("{InstallUpdatesRestoresPerNuGetVersion}", InstallUpdatesRestoresByNuGetVersion());
mailBody = mailBody.Replace("{InstallUpdatesRestoresPerVSVersion}", InstallUpdatesRestoresByVSVersion());
mailBody = mailBody.Replace("{IISRequestsDistribution}", CreateTableForIISRequestsDistribution());
mailBody = ReplaceWorkJobDetails(mailBody, DatesInWeek);
return(mailBody);
}
