/// <summary>
/// Call pattern drawing methods, shows resulting pdf.
/// </summary>
private void doPattern_Click(object sender, EventArgs e)
{
patternChoicePanel.Visible = false;
measuresPanel.Visible = false;
viewerPanel.Visible = true;
// get measures data from measures form
MeasuresData m = fromFormToMeasures();
// initialize pattern control
PatternControl control = new PatternControl(m, drawNet.Checked);
// choose where to save pdf pattern
folderBrowserDialog.ShowDialog();
string path = folderBrowserDialog.SelectedPath;
// get choosed pattern
PatternControl.Pattern pattern = (PatternControl.Pattern)patternToDo.SelectedIndex;
// create pdf with pattern, return path to result
string viewPath = control.DoPdfPattern(pattern, path);
// view pdf with pattern
pdfViewer.Document = Patagames.Pdf.Net.PdfDocument.Load(viewPath);
}
/// <summary>
/// Insert measures set to database.
/// </summary>
/// <param name="name">name of data set</param>
/// <param name="note">note to data set</param>
/// <param name="m">MeasuresData data</param>
private bool InsertDataSetToDatabase(string name, string note, MeasuresData m)
{
string sql = $"INSERT INTO MeasuresSets " +
$"(name, note, height, circ_bust, circ_waist, circ_hips, len_back, wid_back, len_knee, " +
$"len_shoulder, len_sleeve, circ_neck, circ_sleeve, len_front, len_breast, len_hips)" +
$" VALUES " +
$"('{name}','{note}',{m.height},{m.circ_bust},{m.circ_waist},{m.circ_hips},{m.len_back},{m.wid_back},{m.len_knee}," +
$"{m.len_shoulder},{m.len_sleeve},{m.circ_neck},{m.circ_sleeve},{m.len_front},{m.len_breast},{m.len_hips})";
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
using (SqlCommand cmd = new SqlCommand(sql, con))
{
try { cmd.ExecuteNonQuery(); }
catch
{
string message = @"Něco se nepovedlo, zkuste to znovu. Možná tento název již v databázi existuje, zkuste sadu uložit pod jiným jménem.";
MessageBox.Show(message);
return(false);
}
}
}
return(true);
}
internal int LoadData(MeasuresData measuresData, ObservableCollection <Measure> measures)
{
measures.Clear();
foreach (MeasuresData.Body body in measuresData.Content)
{
int valueIndex = 0;
foreach (List <double?> value in body.Value)
{
AddMeasures(measures, body.BegTime.ToLocalDateTime().AddSeconds(body.StepTime * valueIndex), value);
valueIndex++;
}
}
_valueIndex++;
return(measures.Count);
}
internal async Task <MeasuresData> GetMeasure(string deviceId, MeasureScale scale, MeasuresFilters measureType, DateTime?dateBegin, DateTime?dateEnd, string moduleId = "", int limit = 1024)
{
if (!await CheckConnectionAsync().ConfigureAwait(false))
{
return(null);
}
var parameters = HttpUtility.ParseQueryString(string.Empty);
parameters["access_token"] = _accessToken;
parameters["device_id"] = deviceId;
parameters["scale"] = scale.ToJsonString();
parameters["type"] = measureType.ToJsonString();
if (dateBegin != null)
{
parameters["date_begin"] = dateBegin.FromLocalDateTime().ToString(CultureInfo.InvariantCulture);
}
if (dateEnd != null)
{
parameters["date_end"] = dateEnd.FromLocalDateTime().ToString(CultureInfo.InvariantCulture);
}
parameters["optimize"] = true.ToString(CultureInfo.InvariantCulture).ToUpperInvariant();
parameters["limit"] = limit.ToString(CultureInfo.InvariantCulture);
if (moduleId.Length > 0)
{
parameters["module_id"] = moduleId;
}
using (HttpClient client = new HttpClient())
using (HttpRequestMessage request = new HttpRequestMessage())
{
request.Method = HttpMethod.Post;
request.RequestUri = new Uri(host + apiPath + "/getmeasure");
request.Content = new StringContent(parameters.ToString(), Encoding.UTF8, "application/x-www-form-urlencoded");
HttpResponseMessage response = await client.SendAsync(request).ConfigureAwait(false);
string responseBody = await response.Content.ReadAsStringAsync().ConfigureAwait(false);
MeasuresData measuresData = new MeasuresData().FromJson(responseBody);
if (measuresData.Content == null)
{
ErrorMessageData errorMessageData = new ErrorMessageData().FromJson(responseBody);
_errorMessage = errorMessageData.Error.Message;
return(null);
}
return(measuresData);
}
}
/// <summary>
/// Get list of all Measure values
/// </summary>
/// <returns></returns>
public List <Measure> GetMeasureList()
{
MeasuresData.Add(new Measure()
{
DataId = 236, Measures = "Forward Dividend Yield"
});
MeasuresData.Add(new Measure()
{
DataId = 198, Measures = "Forward EV/EBITDA"
});
//MeasuresData.Add(new Measure() { DataId = 246, Measures = "Forward EV/EBITDA relative to Country" });
//MeasuresData.Add(new Measure() { DataId = 247, Measures = "Forward EV/EBITDA relative to Industry" });
//MeasuresData.Add(new Measure() { DataId = 248, Measures = "Forward EV/EBITDA relative to Country Industry" });
//MeasuresData.Add(new Measure() { DataId = 237, Measures = "Forward EV/Revenue" });
MeasuresData.Add(new Measure()
{
DataId = 238, Measures = "Forward P/NAV"
});
//MeasuresData.Add(new Measure() { DataId = 239, Measures = "Forward P/Appraisal Value" });
MeasuresData.Add(new Measure()
{
DataId = 188, Measures = "Forward P/BV"
});
//MeasuresData.Add(new Measure() { DataId = 249, Measures = "Forward P/BV relative to Country" });
//MeasuresData.Add(new Measure() { DataId = 250, Measures = "Forward P/BV relative to Industry" });
//MeasuresData.Add(new Measure() { DataId = 251, Measures = "Forward P/BV relative to Country Industry" });
MeasuresData.Add(new Measure()
{
DataId = 189, Measures = "Forward P/CE"
});
MeasuresData.Add(new Measure()
{
DataId = 187, Measures = "Forward P/E"
});
//MeasuresData.Add(new Measure() { DataId = 252, Measures = "Forward P/E relative to Country" });
//MeasuresData.Add(new Measure() { DataId = 253, Measures = "Forward P/E relative to Industry" });
//MeasuresData.Add(new Measure() { DataId = 254, Measures = "Forward P/E relative to Country Industry" });
//MeasuresData.Add(new Measure() { DataId = 241, Measures = "Forward P/E to 2 Year Growth" });
//MeasuresData.Add(new Measure() { DataId = 242, Measures = "Forward P/E to 3 Year Growth" });
//MeasuresData.Add(new Measure() { DataId = 245, Measures = "Forward P/Embedded Value" });
//MeasuresData.Add(new Measure() { DataId = 197, Measures = "Forward P/Revenue" });
return(MeasuresData);
}
// GET: Measures/Edit/1
public ActionResult Edit(int?id, int HosId = 0, int FromYear = 0)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OKTAServiceRepository okta = new OKTAServiceRepository();
var Okta = okta.GetUserProfile(HttpContext.GetOwinContext().Authentication.User.Claims);
if (!roleDB.IsSuperAdmin(Okta.email))
{
ViewBag.Hospitals = db.GetHospitals(HosId, Okta.email);
}
else
{
ViewBag.Hospitals = db.GetHospitals(HosId, string.Empty);
}
ViewBag.FromYear = db.GetYears(FromYear);
MeasuresData measuresData = new MeasuresData();
try
{
measuresData = db.GetMeasuresData((int)id, HosId, FromYear);
}
catch (Exception ex)
{
measuresData = new MeasuresData()
{
Measures = new List <Measure>()
};
Console.WriteLine(ex);
}
return(View(measuresData));
}
public MeasuresData GetMeasuresData(int id, int HosId, int FromYear)
{
var md = new MeasuresData();
var emm = db.EventMeasureMasters.Where(e => e.EMM_Id == id).Include(m => m.MeasureMaster).Include(e => e.EventTypeMaster).FirstOrDefault();
if (emm != null && emm.EMM_DisplayInApp)
{
md = new MeasuresData
{
MeasuresDataId = string.Format("{1}_{0}", id, HosId),
Measure = emm?.MeasureMaster.MEM_Measure ?? string.Empty,
EventType = emm?.EventTypeMaster.EVM_EventType ?? string.Empty,
TimePeriodType = emm?.EMM_TimePeriod ?? string.Empty,
OrgId = HosId.ToString()
};
if (HosId > 0 && FromYear > 0)
{
var cals = db.CalendarMasters.Where(y => y.CAL_Year == FromYear).ToList();
if (cals.Count() > 0)
{
var pfps = db.NYSPFPDatas.Where(e => e.NPD_HOS_Id == HosId &&
e.NPD_EMM_Id == id &&
e.CalendarMaster.CAL_Year == FromYear)
.Include(e => e.EventMeasureMaster)
.Include(e => e.EventMeasureMaster.MeasureMaster)
.Include(e => e.AnalysisPeriodMaster)
.ToList();
if ((emm?.EMM_TimePeriod ?? string.Empty).Replace(" ", "").ToLower().StartsWith("q"))
{
cals = db.CalendarMasters.Where(y => y.CAL_Year == FromYear && (y.CAL_Month == 1 || y.CAL_Month == 4 || y.CAL_Month == 7 || y.CAL_Month == 10)).ToList();
foreach (var c in cals)
{
c.CAL_MonthText = c.CAL_Month == 1 ? "Q1" : c.CAL_Month == 4 ? "Q2" : c.CAL_Month == 7 ? "Q3" : c.CAL_Month == 10 ? "Q4" : c.CAL_MonthText;
}
}
IEnumerable <Measure> measures = new List <Measure>();
List <AnalysisPeriod> apms = db.AnalysisPeriodMasters.Where(a => a.APM_Active == true).Select(p => new AnalysisPeriod {
AnalysisPeriodId = p.APM_Id, AnalysisPeriodName = p.APM_Period
}).ToList();
measures = from c1 in cals
join p1 in pfps on c1.CAL_Id equals p1.NPD_Cal_Id into ll
from l1 in ll.DefaultIfEmpty()
select new Measure()
{
MeasureId = string.Format("{1}_{0}_{2}", id, HosId, c1.CAL_Id),
HosId = HosId,
CalId = c1.CAL_Id,
EmmId = id,
MonthYear = string.Format("{0}-{1}", c1?.CAL_MonthText ?? string.Empty, c1?.CAL_Year.ToString() ?? string.Empty),
OrderBy = c1?.CAL_OrderBy ?? 1,
AnalysisPeriodId = l1?.NPD_APM_Id ?? null,
Numerator = l1?.NPD_Numerator ?? 0.0m,
Denominator = l1?.NPD_Denominator ?? 0.0m,
Multiplier = emm?.MeasureMaster.MEM_Multiplier ?? 0,
Measurement = l1?.NPD_Measurement ?? 0,
SourceType = l1?.NPD_SourceType ?? string.Empty,
AnalysisPeriod = apms
};
md.Measures = measures;
}
}
md.FromYear = FromYear;
}
else
{
md = new MeasuresData
{
MeasuresDataId = string.Format("{1}_{0}", id, HosId),
Measure = string.Empty,
EventType = string.Empty,
TimePeriodType = string.Empty,
OrgId = HosId.ToString(),
FromYear = FromYear
};
}
return(md);
}
