/// <summary>
/// Request data to current special url
/// </summary>
/// <param name="o">request data</param>
private void Request(object o)
{
//Check login
if (!LoginList.ContainsKey(modelProvider.CurrentSiteName))
{
($"Please Login Site : { modelProvider.CurrentSiteName } \n{DateTime.Now.ToString()}").showInMessageBox();
return;
}
//Set encoding
if (netRequestProvider.encoding != modelProvider.Encoding)
{
netRequestProvider.encoding = modelProvider.Encoding;
}
//Request
if (IsHttpPost)
{
string[] postdata = getPostValue();
if (postdata == null || postdata.Length < 1)
{
developerMessage("Post string error, action not do");
}
else
{
string poststring = string.Empty;
poststring = modelProvider.postFormat(postdata);
requestWith(modelProvider.getUrl(), poststring);
}
}
else
{
requestWith(modelProvider.getUrl());
}
}
private Series LoadCpuSeries(WorkloadAnalysis analysis, OxyColor color, double baseOffset)
{
if (analysis == null)
{
return(null);
}
LineSeries cpuSeries = new LineSeries()
{
StrokeThickness = 2,
MarkerSize = 3,
MarkerStroke = OxyColor.Parse("#FF0000"), //Red
MarkerType = MarkerType.None,
CanTrackerInterpolatePoints = false,
Title = analysis.Name,
Color = color,
Smooth = false
};
if (baseOffset == 0)
{
cpuSeries.TrackerFormatString = "Offset: {2:0}\n{0}: {4:0}";
}
var Table = from t in analysis.Points
where ApplicationList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.ApplicationName) &&
HostList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.HostName) &&
DatabaseList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.DatabaseName) &&
LoginList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.LoginName)
group t by new
{
offset = t.OffsetMinutes
}
into grp
orderby grp.Key.offset
select new
{
offset_minutes = grp.Key.offset,
cpu = grp.Sum(t => t.SumCpuUs)
};
foreach (var p in Table)
{
double xValue = 0;
if (baseOffset > 0)
{
xValue = DateTimeAxis.ToDouble(DateTimeAxis.ToDateTime(baseOffset).AddMinutes(p.offset_minutes));
}
else
{
xValue = p.offset_minutes;
}
cpuSeries.Points.Add(new DataPoint(xValue, p.cpu));
}
return(cpuSeries);
}
public IActionResult Dashboard(LoginList model)
{
if (model.UserName != null)
{
return(View(model));
}
return(RedirectToAction("Index"));
}
public IActionResult ViewLoginDetails(int?Id)
{
var test = _context.Login.Where(a => a.Id == Id).ToList();
LoginList loginModel = new LoginList
{
LoginAll = test
};
return(View(loginModel));
}
// GET: ViewLoginDetails
public IActionResult ViewLoginDetails()
{
var test = _context.Login.ToList();
LoginList loginModel = new LoginList
{
LoginAll = test
};
return(View(loginModel));
}
public frmOutput() : base()
{
userList = new LoginList();
IsValid = (((BizObject)userList).ErrorNumber == 0);
if (IsValid)
{
InitializeComponent();
}
}
public IActionResult Index(LoginModel loginModel)
{
List <LoginList> loginList = dBOperations.GetAllUser();
LoginList result = loginList
.Where(x => x.UserName == loginModel.UserName && x.UserPassword == loginModel.Password)?
.FirstOrDefault();
if (result != null)
{
return(RedirectToAction("Dashboard", result));
}
return(RedirectToAction("LoginDenied"));
}
private Series LoadBatchesSeries(WorkloadAnalysis analysis, OxyColor color)
{
if (analysis == null)
{
return(null);
}
LineSeries batchesSeries = new LineSeries()
{
StrokeThickness = 2,
MarkerSize = 3,
MarkerStroke = OxyColor.Parse("#FF0000"), //Red
MarkerType = MarkerType.None,
CanTrackerInterpolatePoints = false,
TrackerFormatString = "Offset: {2:0}\n{0}: {4:0}",
Title = analysis.Name,
Color = color,
Smooth = false
};
var Table = from t in analysis.Points
where ApplicationList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.ApplicationName) &&
HostList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.HostName) &&
DatabaseList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.DatabaseName) &&
LoginList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.LoginName)
group t by new
{
offset = t.OffsetMinutes
}
into grp
orderby grp.Key.offset
select new
{
offset_minutes = grp.Key.offset,
execution_count = grp.Sum(t => t.ExecutionCount / ((t.DurationMinutes == 0 ? 1 : t.DurationMinutes) * 60))
};
foreach (var p in Table)
{
batchesSeries.Points.Add(new DataPoint(p.offset_minutes, p.execution_count));
}
return(batchesSeries);
}
internal void LoginSuccessfull()
{
// Populating the data from Excel
ExcelLib.PopulateInCollection(Base.ExcelPath, "Login");
// Navigating to Login page using value from Excel
Driver.driver.Navigate().GoToUrl(ExcelLib.ReadData(2, "Url"));
//Click on LoginNavigation button
LoginNavigation.Click();
//click on Login from the menu list
LoginList.Click();
// Sending the username
Email.SendKeys(ExcelLib.ReadData(2, "Email"));
// Sending the password
PassWord.SendKeys(ExcelLib.ReadData(2, "Password"));
// Clicking on the login button
LoginButton.Click();
}
public LoginList CheckPass(string uid, string upass, string utype)
{
LoginList ll = new LoginList();
SqlConnection con = new SqlConnection("Data Source=ALAUDDIN\\SQLEXPRESS;Initial Catalog=dbase;Integrated Security=True");
SqlCommand cmd = new SqlCommand("select userMail,userPass,userType from UserAcc where userMail=@umail ", con);
cmd.Parameters.AddWithValue("@umail", uid);
SqlDataReader dr;
con.Open();
dr = cmd.ExecuteReader();
if (dr.Read())
{
ll.Uid = dr.GetValue(0).ToString();
ll.Pass = dr.GetValue(1).ToString();
ll.Type = dr.GetValue(2).ToString();
//ll.Type = dr.GetValue(3).ToString();
}
con.Close();
return(ll);
}
public ActionResult Login(FormCollection c)
{
if (c["signin"] != null)
{
string uid = c["uname"].ToString();
string upass = c["pass"].ToString();
string utype = c["utype"].ToString();
//string utypeR = c["utypeR"].ToString();
LoginList l = CheckPass(uid, upass, utype);
if (l.Uid == uid && l.Pass == upass && l.Type == utype)
{
return(RedirectToAction("Index", "SMS"));
}
//ViewBag.Msg = "Matched";
else
{
ViewBag.Msg = "Not Matched";
}
}
return(View());
}
private void InitializeQueries()
{
// Initialize the queries
logger.Info("Entering baseline evaluation");
bool zoomIsSet = PlotModels[0].DefaultXAxis != null;
double xstart = 0;
double xend = 0;
if (zoomIsSet)
{
xstart = PlotModels[0].DefaultXAxis.ActualMinimum;
xend = PlotModels[0].DefaultXAxis.ActualMaximum;
if (xstart < 0)
{
xstart = 0;
}
}
var baseline = from t in _baselineWorkloadAnalysis.Points
where ApplicationList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.ApplicationName) &&
HostList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.HostName) &&
DatabaseList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.DatabaseName) &&
LoginList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.LoginName) &&
(!zoomIsSet || t.OffsetMinutes >= xstart) &&
(!zoomIsSet || t.OffsetMinutes <= xend)
group t by new
{
query = t.NormalizedQuery
}
into grp
select new
{
query = grp.Key.query,
sum_duration_us = grp.Sum(t => t.SumDurationUs),
avg_duration_us = grp.Average(t => t.AvgDurationUs),
sum_cpu_us = grp.Sum(t => t.SumCpuUs),
avg_cpu_us = grp.Average(t => t.AvgCpuUs),
sum_reads = grp.Sum(t => t.SumReads),
avg_reads = grp.Average(t => t.AvgReads),
execution_count = grp.Sum(t => t.ExecutionCount)
};
logger.Info("Baseline evaluation completed");
logger.Info("Entering benchmark evaluation");
var benchmark = from t in baseline where false select new { t.query, t.sum_duration_us, t.avg_duration_us, t.sum_cpu_us, t.avg_cpu_us, t.sum_reads, t.avg_reads, t.execution_count };
if (_benchmarkWorkloadAnalysis != null)
{
benchmark = from t in _benchmarkWorkloadAnalysis.Points
where ApplicationList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.ApplicationName) &&
HostList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.HostName) &&
DatabaseList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.DatabaseName) &&
LoginList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.LoginName) &&
(!zoomIsSet || t.OffsetMinutes >= xstart) &&
(!zoomIsSet || t.OffsetMinutes <= xend)
group t by new
{
query = t.NormalizedQuery
}
into grp
select new
{
query = grp.Key.query,
sum_duration_us = grp.Sum(t => t.SumDurationUs),
avg_duration_us = grp.Average(t => t.AvgDurationUs),
sum_cpu_us = grp.Sum(t => t.SumCpuUs),
avg_cpu_us = grp.Average(t => t.AvgCpuUs),
sum_reads = grp.Sum(t => t.SumReads),
avg_reads = grp.Average(t => t.AvgReads),
execution_count = grp.Sum(t => t.ExecutionCount)
};
}
logger.Info("Benchmark evaluation completed");
logger.Info("Merging sets");
var leftOuterJoin =
from b in baseline
join k in benchmark
on b.query.Hash equals k.query.Hash
into joinedData
from j in joinedData.DefaultIfEmpty()
select new
{
query_hash = b.query.Hash,
query_text = b.query.ExampleText,
query_normalized = b.query.NormalizedText,
b.sum_duration_us,
b.avg_duration_us,
b.sum_cpu_us,
b.avg_cpu_us,
b.sum_reads,
b.avg_reads,
b.execution_count,
sum_duration_us2 = j == null ? 0 : j.sum_duration_us,
diff_sum_duration_us = j == null ? 0 : j.sum_duration_us - b.sum_duration_us,
avg_duration_us2 = j == null ? 0 : j.avg_duration_us,
sum_cpu_us2 = j == null ? 0 : j.sum_cpu_us,
diff_sum_cpu_us = j == null ? 0 : j.sum_cpu_us - b.sum_cpu_us,
avg_cpu_us2 = j == null ? 0 : j.avg_cpu_us,
sum_reads2 = j == null ? 0 : j.sum_reads,
avg_reads2 = j == null ? 0 : j.avg_reads,
execution_count2 = j == null ? 0 : j.execution_count,
querydetails = new QueryDetails(b.query, _baselineWorkloadAnalysis, _benchmarkWorkloadAnalysis),
document = new ICSharpCode.AvalonEdit.Document.TextDocument()
{
Text = b.query.ExampleText
}
};
var rightOuterJoin =
from b in benchmark
join k in baseline
on b.query.Hash equals k.query.Hash
into joinedData
from j in joinedData.DefaultIfEmpty()
select new
{
query_hash = b.query.Hash,
query_text = b.query.ExampleText,
query_normalized = b.query.NormalizedText,
b.sum_duration_us,
b.avg_duration_us,
b.sum_cpu_us,
b.avg_cpu_us,
b.sum_reads,
b.avg_reads,
b.execution_count,
sum_duration_us2 = j == null ? 0 : j.sum_duration_us,
diff_sum_duration_us = j == null ? 0 : j.sum_duration_us - b.sum_duration_us,
avg_duration_us2 = j == null ? 0 : j.avg_duration_us,
sum_cpu_us2 = j == null ? 0 : j.sum_cpu_us,
diff_sum_cpu_us = j == null ? 0 : j.sum_cpu_us - b.sum_cpu_us,
avg_cpu_us2 = j == null ? 0 : j.avg_cpu_us,
sum_reads2 = j == null ? 0 : j.sum_reads,
avg_reads2 = j == null ? 0 : j.avg_reads,
execution_count2 = j == null ? 0 : j.execution_count,
querydetails = new QueryDetails(b.query, _baselineWorkloadAnalysis, _benchmarkWorkloadAnalysis),
document = new ICSharpCode.AvalonEdit.Document.TextDocument()
{
Text = b.query.ExampleText
}
};
var merged = leftOuterJoin.Union(rightOuterJoin);
Queries = merged;
logger.Info("Sets merged");
RaisePropertyChanged("Queries");
RaisePropertyChanged("CompareModeVisibility");
RaisePropertyChanged("CompareMode");
string sortCol = CompareMode ? "diff_sum_duration_us" : "sum_duration_us";
var msg = new SortColMessage(sortCol, System.ComponentModel.ListSortDirection.Descending);
Messenger.Default.Send <SortColMessage>(msg);
}
/// <summary>
/// Request data to login page
/// </summary>
/// <param name="o"></param>
private async void LoginRequest(object o)
{
if (isRightUserName(UserName))
{
string siteName = SiteName;
//0.SET MODEL TO LOGIN STATE
modelProvider.useSite(siteName.ToLower() == "szhxy" ? StoredSiteName.Szhxy : StoredSiteName.Bkjw);
modelProvider.setLogin();
netRequestProvider.encoding = modelProvider.Encoding;
//1.LOGOUT LOGINED USER
if (LoginList.ContainsKey(siteName))
{
RequestResult = await netRequestProvider.HttpGet(modelProvider.LogoutUrl, "");
LoginList.Remove(siteName);
}
//2.GET PASSWORD AND SAVE BYTE[] FOR STORE USER DATA
byte[] tempBytes = null;
IntPtr p = System.Runtime.InteropServices.Marshal.SecureStringToBSTR(((o as System.Windows.Controls.PasswordBox).SecurePassword));
string psw = System.Runtime.InteropServices.Marshal.PtrToStringBSTR(p);
if (RememberUser || rememberFailUser)
{
tempBytes = UTF8Encoding.UTF8.GetBytes(psw);
if (rememberFailUser)
{
storeUser(ref tempBytes);
}
}
//3.COMBINE POST DATA AND SHOW DEVELOPER MESSAGE
string data = modelProvider.postFormat(UserName, psw);
developerMessage(modelProvider.getUrl() + "\n" + data);
//4.REQUEST POST ACTION
RequestResult = await basicHttpRuquest(new RunHttpRequest(netRequestProvider.HttpPost), modelProvider.LoginUrl, data);
//5.HAND RESULT BY CHECK LOGIN STATE
bool loginState = false;
if (siteName == "Szhxy")
{
modelProvider.usePage(SpecialPage.szhxyCheckLogin);
string rule = modelProvider.getParsingRules();
string result = await basicHttpRuquest(new RunHttpRequest(netRequestProvider.HttpGet), modelProvider.getUrl(), string.Empty);
loginState = Regex.IsMatch(result, rule);
}
else
{
loginState = checkBkjwLogin(RequestResult, UserName);
}
if (loginState)
{
Dictionary <string, string> tempList = new Dictionary <string, string>(loginList);
tempList.Add(siteName, UserName);
LoginList = tempList;
if (RememberUser)
{
storeUser(ref tempBytes);
}
SetRequest(MenuItems[0]);
sendToConsole(UserName + "(" + siteName + ") Login successful!");
}
}
}
