/// <summary>
/// Gets the hash code
/// </summary>
/// <returns>Hash code</returns>
public override int GetHashCode()
{
unchecked // Overflow is fine, just wrap
{
var hashCode = 41;
// Suitable nullity checks etc, of course :)
if (Id != null)
{
hashCode = hashCode * 59 + Id.GetHashCode();
}
if (ActivityId != null)
{
hashCode = hashCode * 59 + ActivityId.GetHashCode();
}
if (ElapsedTime != null)
{
hashCode = hashCode * 59 + ElapsedTime.GetHashCode();
}
if (StartDate != null)
{
hashCode = hashCode * 59 + StartDate.GetHashCode();
}
if (StartDateLocal != null)
{
hashCode = hashCode * 59 + StartDateLocal.GetHashCode();
}
if (Distance != null)
{
hashCode = hashCode * 59 + Distance.GetHashCode();
}
if (IsKom != null)
{
hashCode = hashCode * 59 + IsKom.GetHashCode();
}
return(hashCode);
}
}
public void EnterTenantDet()
{
_Wait.Until(ExpectedConditions.ElementExists(By.XPath("//*[@id='lname']")));
TenantEmail.SendKeys("*****@*****.**");
TenantFullname.SendKeys("Tenant");
TenantLastName.SendKeys("TenantLast");
RentAmt.SendKeys("200");
/* IJavaScriptExecutor js = (IJavaScriptExecutor)_driver;
* js.ExecuteScript(StartDate.startD);
*
* String startD = "24/09/2018";
*/
StartDate.Click();
StartDate.Clear();
StartDate.SendKeys("24/11/2018");
System.Threading.Thread.Sleep(500);
EndDate.Click();
EndDate.Clear();
EndDate.SendKeys("24/08/2028");
System.Threading.Thread.Sleep(500);
PaymentStartDate.Click();
PaymentStartDate.Clear();
PaymentStartDate.SendKeys("26/11/2018");
System.Threading.Thread.Sleep(500);
Liabilities.Click();
_Wait.Until(ExpectedConditions.ElementExists(By.XPath("//*[@id='LiabilityDetail']/div/div[1]/div[2]/div[1]/input")));
ValLiabilities.SendKeys("1000");
ClickSave.Click();
}
public Result CreateStraightLineAmortizationSchedule()
{
if (LoanAmount == 0)
{
return(new Result(false, "Loan Amount cannot be zero."));
}
_amortizationSchedule = new List <ScheduledPayment>();
decimal monthlyInterestRate = AnnualInterestRate / 12m;
decimal monthlyInterestAmount = LoanAmount * monthlyInterestRate;
decimal principal = LoanAmount / NumberOfPayments; // eto ung ibabawas monthly sa loan
decimal monthlyPayment = principal + monthlyInterestAmount;
decimal runningBalance = LoanAmount;
for (int i = 1; i <= NumberOfPayments; i++)
{
var scheduledPayment = new ScheduledPayment
{
PaymentNo = i,
Amount = monthlyPayment,
Interest = monthlyInterestAmount
};
scheduledPayment.Principal = principal;
scheduledPayment.Date = StartDate.AddMonths(i);
scheduledPayment.Balance = runningBalance - principal;
_amortizationSchedule.Add(scheduledPayment);
runningBalance = scheduledPayment.Balance;
}
// loan summary
MonthlyPayment = monthlyPayment;
TotalPayments = _amortizationSchedule.Sum(scheduledPayment => scheduledPayment.Amount);
TotalInterestPaid = _amortizationSchedule.Sum(scheduledPayment => scheduledPayment.Interest);
PayOffDate = StartDate.AddMonths(NumberOfPayments);
return(new Result(true, "CreateStraightLineAmortizationSchedule"));
}
public bool IsTrigger(DateTime currDate, int secondInterval)
{
if (currDate < StartDate || currDate >= StopDate || secondInterval <= 0)
{
return(false);
}
bool result = false;
var excuteDate = PreDate == DateTime.MinValue ? StartDate : PreDate.AddSeconds(secondInterval);
var nextExcuteDate = excuteDate.AddSeconds(secondInterval);
if (currDate < PreDate || currDate >= nextExcuteDate)
{
//修正当前时间位置
var ts = StopDate - StartDate;
var numberTimes = (int)ts.TotalSeconds / secondInterval;
int times = FindIntervalTimes(currDate, 0, numberTimes, secondInterval);
PreDate = StartDate.AddSeconds(secondInterval * (times - 1));
excuteDate = PreDate.AddSeconds(secondInterval);
nextExcuteDate = excuteDate.AddSeconds(secondInterval);
}
//Trace.WriteLine(string.Format("timing pre:{0}, cur:{1}, next:{2}", PreDate, currDate, excuteDate));
if (PreDate <= currDate && currDate < excuteDate)
{
//时间还没有到
}
else if (excuteDate <= currDate && currDate < nextExcuteDate)
{
PreDate = excuteDate;
result = currDate < excuteDate.AddSeconds(OffsetSecond);//整点处理
}
else
{
}
return(result);
}
protected override void OnDispatchPaint(SKCanvas c)
{
c.Clear();
// Translation
c.Translate(new SKPoint(-HorizontalOffset + hourBarOffset, -VerticalOffset));
// Header
this.DrawHourBar(c);
foreach (int hourOffset in this.GetIntersectHourOffsets())
{
this.DrawRowLine(c, hourOffset);
this.DrawHour(c, hourOffset);
}
this.DrawHeader(c);
foreach (int dayOffset in this.GetIntersectDayOffsets())
{
this.DrawColumnLine(c, dayOffset);
this.DrawColumnHeader(c, dayOffset);
}
this.CurrentDate = StartDate.AddDays(this.MeasureEndIndex());
#if DEBUG
// Debug
c.DrawText($"HorizontalOffset: {HorizontalOffset}", 10 + HorizontalOffset, 100 + VerticalOffset, debugPaint);
c.DrawText($"VerticalOffset: {VerticalOffset}", 10 + HorizontalOffset, 120 + VerticalOffset, debugPaint);
c.DrawText($"StartIndex: {this.MeasureStartIndex()}", 10 + HorizontalOffset, 140 + VerticalOffset, debugPaint);
c.DrawText($"EndIndex: {this.MeasureEndIndex()}", 10 + HorizontalOffset, 160 + VerticalOffset, debugPaint);
#endif
}
public DataList ToDataList()
{
DataList data = new DataList();
// Simple
data.Add(Id, "id");
data.Add(Author, "author");
data.Add(Name, "name");
data.Add(StartDate.ToString("O"), "start_date");
data.Add(Price, "price");
data.Add(Tags, "tags");
data.Add(Visible, "visible");
// Complex
DataList sportsDl = new DataList();
foreach (string sport in Sports)
{
sportsDl.Add(sport);
}
DataList imagesDl = new DataList();
foreach (string image in Images)
{
imagesDl.Add(image);
}
DataList coordinatesDl = new DataList();
coordinatesDl.Add(Latitude);
coordinatesDl.Add(Longitude);
data.Add(sportsDl, "sports");
data.Add(imagesDl, "images");
data.Add(coordinatesDl, "coordinates");
return(data);
}
protected override IEnumerable <Occurrence> GetNextOccurrences(Occurrence lastOccurrence, TimeSpan startTime, TimeSpan endTime)
{
DateTime startDate;
if (lastOccurrence != null)
{
startDate = lastOccurrence.Start.Date.Add(startTime).AddDays(1 - lastOccurrence.Start.Day).AddYears(Interval);
}
else
{
startDate = StartDate.Date.Add(startTime);
startDate = StartDate > startDate
? StartDate.AddDays(1 - startDate.Day)
: startDate.AddDays(1 - startDate.Day);
if (startDate.Month > (int)Month || (startDate.Month == (int)Month && startDate.Day > DayOfMonth))
{
startDate = startDate.AddDays(1 - startDate.Day).AddMonths((int)Month - startDate.Month).AddYears(1);
}
}
int daysInMonth = DateTime.DaysInMonth(startDate.Year, startDate.Month);
startDate = startDate.AddDays(((daysInMonth < DayOfMonth) ? daysInMonth : DayOfMonth) - 1);
DateTime endDate = startDate.Date.Add(endTime);
if (startDate <= endDate)
{
if (EndDate.HasValue && endDate >= EndDate.Value)
{
yield return(new Occurrence(startDate, EndDate.Value));
}
else
{
yield return(new Occurrence(startDate, endDate));
}
}
}
internal bool ShareSkillInvalid()
{
try
{
//Populate From Excel
GlobalDefinitions.ExcelLib.PopulateInCollection(Base.ExcelPath, "ShareSkill");
Thread.Sleep(2000);
//Enter Title
Title.SendKeys(ExcelLib.ReadData(3, "Title"));
//Enter Description
Description.SendKeys(ExcelLib.ReadData(3, "Description"));
Thread.Sleep(2000);
//Enter Tag
TagInner.SendKeys(ExcelLib.ReadData(3, "Tags"));
string SInDate = ExcelLib.ReadData(3, "StartDate");
string[] SInDateForm = SInDate.Split(' ');
StartDate.SendKeys(SInDateForm[0]);
string EInDate = ExcelLib.ReadData(2, "EndDate");
string[] EInDateForm = EInDate.Split(' ');
EndDate.SendKeys(EInDateForm[0]);
//Click Save
Save.Click();
return(true);
}
catch (Exception)
{
return(false);
}
}
// обновление курсов валют CurrenciesHistory
private void UpdateCurrenciesHistory()
{
var dateTime = DateTime.Now; // сегодняшняя дата
object LatestDataObj; // объект, хранящий последнюю дату в таблице курсов валют CurrenciesHistory
var DateTimes = new List <DateTime>(); // список дат между последней датой в таблице CurrenciesHistory и сегодняшней датой
using (var connection = new SqlConnection(connectionString)) // устанавливаем соединение с БД
{
connection.Open(); // открываем соединение
string sqlExpression = "SELECT MAX(Date) FROM CurrenciesHistory"; // строка запроса на получение последней даты в таблице CurrenciesHistory
SqlCommand command = new SqlCommand(sqlExpression, connection); // создаём команду
LatestDataObj = command.ExecuteScalar(); // выполняем команду
DateTime StartDate; // дата, начиная с которой (не влючая) будем добалять курсы валют в таблицу CurrenciesHistory
if (DBNull.Value == LatestDataObj) // если command вернула null, т.е. в таблице CurrenciesHistory нет записей
{
StartDate = dateTime.AddDays(-1).Date; // начнём заполнять таблицу со вчерашней даты
}
else
{
StartDate = ((DateTime)LatestDataObj).Date; // иначе присвоим переменной StartDate последнюю дату в таблице CurrenciesHistory
}
// заполняем список дат между начальной датой StartDate (не включая) и сегодняшней датой
while (dateTime.Date > StartDate)
{
StartDate = StartDate.AddDays(1);
DateTimes.Add(StartDate);
}
sqlExpression = "AddCurrencyValue"; // запрос на добаление курса валюты
foreach (var DateTime in DateTimes)
{
UpdateCurrenciesHistory(connection, DateTime);
}
}
}
public override bool Equals(object obj)
{
if (obj == null)
{
return(false);
}
if (obj == this)
{
return(true);
}
return(obj is CreateSubscriptionRequest other &&
((IdempotencyKey == null && other.IdempotencyKey == null) || (IdempotencyKey?.Equals(other.IdempotencyKey) == true)) &&
((LocationId == null && other.LocationId == null) || (LocationId?.Equals(other.LocationId) == true)) &&
((PlanId == null && other.PlanId == null) || (PlanId?.Equals(other.PlanId) == true)) &&
((CustomerId == null && other.CustomerId == null) || (CustomerId?.Equals(other.CustomerId) == true)) &&
((StartDate == null && other.StartDate == null) || (StartDate?.Equals(other.StartDate) == true)) &&
((CanceledDate == null && other.CanceledDate == null) || (CanceledDate?.Equals(other.CanceledDate) == true)) &&
((TaxPercentage == null && other.TaxPercentage == null) || (TaxPercentage?.Equals(other.TaxPercentage) == true)) &&
((PriceOverrideMoney == null && other.PriceOverrideMoney == null) || (PriceOverrideMoney?.Equals(other.PriceOverrideMoney) == true)) &&
((CardId == null && other.CardId == null) || (CardId?.Equals(other.CardId) == true)) &&
((Timezone == null && other.Timezone == null) || (Timezone?.Equals(other.Timezone) == true)));
}
public void CreateDiminishingAmortizationSchedule()
{
if (LoanAmount == 0)
{
return;
}
_amortizationSchedule = new List <ScheduledPayment>();
decimal monthlyInterestRate = AnnualInterestRate / 12m;
decimal presentValueOfAnnuity =
Convert.ToDecimal(Math.Pow((double)(1 + monthlyInterestRate), NumberOfPayments));
decimal monthlyPayment = ((monthlyInterestRate * LoanAmount * presentValueOfAnnuity) / (presentValueOfAnnuity - 1));
decimal runningBalance = LoanAmount;
for (int i = 1; i <= NumberOfPayments; i++)
{
var scheduledPayment = new ScheduledPayment
{
PaymentNo = i,
Amount = monthlyPayment,
Interest = runningBalance * monthlyInterestRate
};
scheduledPayment.Principal = monthlyPayment - scheduledPayment.Interest;
scheduledPayment.Date = StartDate.AddMonths(i);
scheduledPayment.Balance = runningBalance - scheduledPayment.Principal;
_amortizationSchedule.Add(scheduledPayment);
runningBalance = scheduledPayment.Balance;
}
// loan summary
MonthlyPayment = monthlyPayment;
TotalPayments = _amortizationSchedule.Sum(scheduledPayment => scheduledPayment.Amount);
TotalInterestPaid = _amortizationSchedule.Sum(scheduledPayment => scheduledPayment.Interest);
PayOffDate = StartDate.AddMonths(NumberOfPayments);
}
/// <summary>
/// Gets the hash code
/// </summary>
/// <returns>Hash code</returns>
public override int GetHashCode()
{
// credit: http://stackoverflow.com/a/263416/677735
unchecked // Overflow is fine, just wrap
{
int hash = 41;
// Suitable nullity checks
hash = hash * 59 + Id.GetHashCode();
hash = hash * 59 + MinistryDistrictID.GetHashCode();
if (Name != null)
{
hash = hash * 59 + Name.GetHashCode();
}
if (Region != null)
{
hash = hash * 59 + Region.GetHashCode();
}
hash = hash * 59 + StartDate.GetHashCode();
if (DistrictNumber != null)
{
hash = hash * 59 + DistrictNumber.GetHashCode();
}
if (EndDate != null)
{
hash = hash * 59 + EndDate.GetHashCode();
}
return(hash);
}
}
public ReservationRequest(ReservationDto res)
{
if (DateTime.TryParse(res.StartDate, out DateTime startDate))
{
StartDate = startDate;
}
else
{
throw new Exception($"StartDate parameter cannot be converted: '{res.StartDate}'");
}
if (TimeSpan.TryParse(res.StartTime, out TimeSpan fromTime))
{
FromTime = StartDate.Add(fromTime);
}
else
{
throw new Exception($"StartTime parameter cannot be converted: '{res.StartTime}'");
}
if (TimeSpan.TryParse(res.EndTime, out TimeSpan toTime))
{
ToTime = StartDate.Add(toTime);
}
else
{
throw new Exception($"EndTime parameter cannot be converted: '{res.EndTime}'");
}
Duration = new TimeSpan(0, res.Duration, 0);
Type = res.Type;
Login = res.Email;
Password = res.Password;
Exclude = res.Exclude;
}
public override int GetHashCode()
{
return(PersonId.GetHashCode() ^
ConceptId.GetHashCode() ^
(StartDate.GetHashCode()) ^
(EndDate.GetHashCode()) ^
TypeConceptId.GetHashCode() ^
VisitOccurrenceId.GetHashCode() ^
ValueAsNumber.GetHashCode() ^
RangeLow.GetHashCode() ^
RangeHigh.GetHashCode() ^
VisitOccurrenceId.GetHashCode() ^
ValueAsConceptId.GetHashCode() ^
(Time != null ? Time.GetHashCode() : 0) ^
ProviderId.GetHashCode() ^
RelevantConditionConceptId.GetHashCode() ^
QualifierConceptId.GetHashCode() ^
SourceConceptId.GetHashCode() ^
UnitsConceptId.GetHashCode() ^
(ValueAsString != null ? ValueAsString.GetHashCode() : 0) ^
(UnitsSourceValue != null ? UnitsSourceValue.GetHashCode() : 0) ^
(QualifierSourceValue != null ? QualifierSourceValue.GetHashCode() : 0) ^
(SourceValue != null ? SourceValue.GetHashCode() : 0));
}
/// <summary>
/// Converts this <c>DemoConstraint</c> to an Xml <c>String</c>.
/// </summary>
/// <returns>
/// A <c>String</c> representing the DemoConstraint as Xml data.
/// </returns>
protected override void ToXmlString(XmlTextWriter xmlWriter)
{
xmlWriter.WriteElementString("Duration", Convert.ToString(this.Duration));
xmlWriter.WriteElementString("InfoUrl", InfoURL);
xmlWriter.WriteElementString("PurchaseUrl", PurchaseURL);
xmlWriter.WriteElementString("Condition", Condition);
if (StartDate.Ticks != 0)
{
xmlWriter.WriteElementString("StartDate", StartDate.ToString(culture));
}
else
{
xmlWriter.WriteElementString("StartDate", String.Empty);
}
if (EndDate.Ticks != 0)
{
xmlWriter.WriteElementString("EndDate", EndDate.ToString(culture));
}
else
{
xmlWriter.WriteElementString("EndDate", String.Empty);
}
xmlWriter.WriteElementString("DateLastAccessed", this.dateLastAccessed.ToString(culture));
}
public List <Income> MakeIncome()
{
var endDate = EndDate ?? DateTime.Now;
Concepts.ToList().ForEach(concept =>
{
var startDate = StartDate.GetNextWeekday(concept.PayDay);
concept.Dates = startDate.RangeTo(endDate, Recurrence);
});
return(Concepts.Select(concept =>
{
return concept.Dates.Select(date => new Income
{
Date = date,
Amount = concept.Amount,
IsFixed = IsFixed,
Description = concept.Description,
Source = concept,
Destination = concept.Destination,
ExchangeRate = concept.ExchangeRate
});
}).SelectMany(x => x).ToList());
}
public QuarterlyInterval(DateTime startDate, int endDay) : base(Period.Quarterly)
{
var endDateAtEndOfQuarter = false;
EndDay = endDay;
if (EndDay == -1 || EndDay >= 90)
{
endDateAtEndOfQuarter = true;
}
int startDateDayOfQuarter = startDate.DayOfQuarter();
if (endDateAtEndOfQuarter)
{
StartDate = startDate.StartOfQuarter();
}
else if (endDay < startDateDayOfQuarter)// past this quarter, move to next
{
StartDate = startDate.AddDays(1 + endDay - startDateDayOfQuarter);
}
else
{
StartDate = startDate.AddDays(-1 - startDateDayOfQuarter).StartOfQuarter().AddDays(endDay);
}
if (endDateAtEndOfQuarter)
{
EndDate = StartDate.EndOfQuarter();
}
else
{
EndDate = StartDate.EndOfQuarter().AddDays(endDay);
}
}
public override int GetHashCode()
{
return(PersonId.GetHashCode() ^
ConceptId.GetHashCode() ^
TypeConceptId.GetHashCode() ^
(SourceValue != null ? SourceValue.GetHashCode() : 0) ^
(StopReason != null ? StopReason.GetHashCode() : 0) ^
Refills.GetHashCode() ^
VisitOccurrenceId.GetHashCode() ^
Quantity.GetHashCode() ^
DaysSupply.GetHashCode() ^
RouteConceptId.GetHashCode() ^
EffectiveDrugDose.GetHashCode() ^
DoseUnitConceptId.GetHashCode() ^
SourceConceptId.GetHashCode() ^
(Sig != null ? Sig.GetHashCode() : 0) ^
(LotNumber != null ? LotNumber.GetHashCode() : 0) ^
(RouteSourceValue != null ? RouteSourceValue.GetHashCode() : 0) ^
(DoseUnitSourceValue != null ? DoseUnitSourceValue.GetHashCode() : 0) ^
ProviderId.GetHashCode() ^
RelevantConditionConceptId.GetHashCode() ^
(StartDate.GetHashCode()) ^
(EndDate.GetHashCode()));
}
public override string ToString()
{
StringBuilder times = new StringBuilder();
times.Append("Week parity: ");
times.Append(Parity.ToString());
times.Append(", Day number: ");
times.Append(Day.ToString());
times.Append(", Time: ");
times.Append(StartDate.ToString());
times.Append(" - ");
times.Append(EndDate.ToString());
times.Append("\t");
return("Name of Event: " + EventName + "\n"
+ "Owner: " + EventOwner.Username + "\n"
+ "Location: " + Location + "\n"
+ "Description: " + Description + "\n"
+ "Due Times: " + times.ToString() + "\n"
+ "Category: " + Category.Name + "\n");
}
public bool GetObjectNeedsUpate(Service checkUpdateFrom)
{
if (!Name.Equals(checkUpdateFrom.Name))
{
return(true);
}
if (!StartDate.Equals(checkUpdateFrom.StartDate))
{
return(true);
}
if (!EndDate.Equals(checkUpdateFrom.EndDate))
{
return(true);
}
if (!Description.Equals(checkUpdateFrom.Description))
{
return(true);
}
if (!ExternalParentId.Equals(checkUpdateFrom.ExternalParentId))
{
return(true);
}
return(false);
}
private void BindData()
{
DataTable tb = SPDayReportWrapper.GetClientGroupPriceReport(ClientGroupID, StartDate.Date, EndDate.Date);
ReportDataSource rds = new ReportDataSource("DataSet1", tb);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
SPClientGroupWrapper clientGroupWrapper = SPClientGroupWrapper.FindById(ClientGroupID);
ReportParameter rpName = new ReportParameter();
rpName.Name = "ReportClientGroupName";
rpName.Values.Add(clientGroupWrapper.Name);
ReportParameter rpStartDate = new ReportParameter();
rpStartDate.Name = "ReportStartDate";
rpStartDate.Values.Add(StartDate.ToShortDateString());
ReportParameter rpEndDate = new ReportParameter();
rpEndDate.Name = "ReportEndDate";
rpEndDate.Values.Add(EndDate.ToShortDateString());
ReportViewer1.LocalReport.SetParameters(
new ReportParameter[] { rpName, rpStartDate, rpEndDate });
ReportViewer1.LocalReport.Refresh();
}
/// <summary>
/// 根据名字，日期查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSearch_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtPicName.Text.Trim()))
{
return;
}
if (string.IsNullOrEmpty(txtPicName.Tag.ToString().Trim()))
{
return;
}
if (string.IsNullOrEmpty(StartDate.Text.Trim()))
{
MessageService.ShowMessage(StringParser.Parse("${res:FanHai.Hemera.Addins.EMS.EquipmentLayout.msg.0002}"));//开始日期不能为空!
StartDate.Focus();
return;
}
if (string.IsNullOrEmpty(EndDate.Text.Trim()))
{
MessageService.ShowMessage(StringParser.Parse("${res:FanHai.Hemera.Addins.EMS.EquipmentLayout.msg.0003}"));//结束日期不能为空!
EndDate.Focus();
return;
}
if (Convert.ToDateTime(StartDate.Text) > Convert.ToDateTime(EndDate.Text))
{
MessageService.ShowMessage(StringParser.Parse("${res:FanHai.Hemera.Addins.EMS.EquipmentLayout.msg.0004}"));//开始日期不能大于结束日期!
return;
}
string msg = string.Empty;
DataSet dsReturn = EquLayoutEntity.GetEquipmentLayoutDetail(txtPicName.Tag.ToString(), out msg);
if (string.IsNullOrEmpty(msg))
{
QueryEquipmentData(dsReturn);
}
}
public override void ExecuteCmdlet()
{
if (!this.IsParameterBound(c => c.EndDate))
{
WriteVerbose(Resources.Properties.Resources.DefaultEndDateUsed);
EndDate = StartDate.AddYears(1);
}
CreatePSApplicationParameters createParameters = new CreatePSApplicationParameters
{
DisplayName = DisplayName,
HomePage = HomePage,
IdentifierUris = IdentifierUris,
ReplyUrls = ReplyUrls,
AvailableToOtherTenants = AvailableToOtherTenants
};
switch (ParameterSetName)
{
case ParameterSet.ApplicationWithPasswordPlain:
string decodedPassword = SecureStringExtensions.ConvertToString(Password);
createParameters.PasswordCredentials = new PSADPasswordCredential[]
{
new PSADPasswordCredential
{
StartDate = StartDate,
EndDate = EndDate,
KeyId = Guid.NewGuid(),
Password = decodedPassword
}
};
break;
case ParameterSet.ApplicationWithPasswordCredential:
createParameters.PasswordCredentials = PasswordCredentials;
break;
case ParameterSet.ApplicationWithKeyPlain:
createParameters.KeyCredentials = new PSADKeyCredential[]
{
new PSADKeyCredential
{
StartDate = StartDate,
EndDate = EndDate,
KeyId = Guid.NewGuid(),
CertValue = CertValue
}
};
break;
case ParameterSet.ApplicationWithKeyCredential:
createParameters.KeyCredentials = KeyCredentials;
break;
}
ExecutionBlock(() =>
{
if (ShouldProcess(target: createParameters.DisplayName, action: string.Format("Adding a new application with display name '{0}'", createParameters.DisplayName)))
{
WriteObject(ActiveDirectoryClient.CreateApplication(createParameters));
}
});
}
public override object ExecuteReport(MethodReturn refMr = null)
{
string servisIdQuery = $" = {ServisId}";
string dateQuery = "";
StartDate = StartDate.startOfDay();
FinishDate = FinishDate.endOfDay();
dateQuery = "" + StartDate.ToString("dd/MM/yyyy") + "' AND '" + FinishDate.ToString("dd/MM/yyyy") + "";
List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
SELECT
A.SERVISGARANTINO,
j.partnercode serviskodu,
A.PDFgarantiTARIHi garantitarihi,
A.PDFDMSNO dmsno,
pdftoplam gidentutar,
A.PDFONAYNETGENELTOPLAM gelentutar,
A.claimstatus statu,
j.isortakad yetkiliservis,
a.arizakodu,
a.CASENO,
a.CLAIMNO,
C.AD ayristirmatipi,
E.AD isemirislemtipi,
F.MUSTERIAD,
F.KAYITTARIH isemirbastarihi,
F.TAMAMLANMATARIH isemirbittarih,
f.SASENO,
F.ISEMIRNO,
G.AD musteri,
h.regnumber plaka,
h.ad Turu
FROM ayristirmalar a,vw_ayristirmatipler c, servisisemirislemler d,vw_isemirtipler e,servisisemirler f,servisvarliklar g,
(SELECT a.saseno,
m.regnumber,
m.vehicletype,
b.ad,
dilkod
FROM araclar a,
esaaraclar ea,
vx_vis_vehiclemaster m,vw_aracturler b
WHERE ea.vin = a.saseno
AND ea.id = m.esaaracid
and M.VEHICLETYPE=b.kod) h, vt_servisler j
where
a.AYRISTIRMATIPID=c.id
and c.dilkod='Turkish'
and a.SERVISISEMIRISLEMID=D.ID
and D.ISEMIRTIPID=E.ID
and e.dilkod=c.dilkod
and D.servisisemirid=f.id
and F.SERVISVARLIKID=G.ID
and h.saseno=f.saseno
and h.dilkod=c.dilkod
and a.servisid=j.servisid
and j.dilkod=e.dilkod
and a.tarih between '{dateQuery}'
and a.servisid {servisIdQuery}
and a.claimstatus in ('Z107','Z109','Z999')
ORDER BY a.tarih DESC
")
.GetDataTable()
.ToModels();
CloseCustomAppPool();
return(queryResults);
}
public override void ExecuteCmdlet()
{
ExecutionBlock(() =>
{
if (!this.IsParameterBound(c => c.EndDate))
{
WriteVerbose(Resources.Properties.Resources.DefaultEndDateUsed);
EndDate = StartDate.AddYears(1);
}
if (this.IsParameterBound(c => c.ApplicationObject))
{
ObjectId = ApplicationObject.ObjectId;
}
else if (this.IsParameterBound(c => c.ApplicationId))
{
ObjectId = ActiveDirectoryClient.GetAppObjectIdFromApplicationId(ApplicationId);
}
else if (this.IsParameterBound(c => c.DisplayName))
{
ObjectId = ActiveDirectoryClient.GetAppObjectIdFromDisplayName(DisplayName);
}
if (Password != null && Password.Length > 0)
{
string decodedPassword = SecureStringExtensions.ConvertToString(Password);
// Create object for password credential
var passwordCredential = new PasswordCredential()
{
EndDate = EndDate,
StartDate = StartDate,
KeyId = Guid.NewGuid().ToString(),
Value = decodedPassword
};
if (ShouldProcess(target: ObjectId.ToString(), action: string.Format("Adding a new password to application with objectId {0}", ObjectId)))
{
WriteObject(ActiveDirectoryClient.CreateAppPasswordCredential(ObjectId, passwordCredential));
}
}
else if (this.IsParameterBound(c => c.CertValue))
{
// Create object for key credential
var keyCredential = new KeyCredential()
{
EndDate = EndDate,
StartDate = StartDate,
KeyId = Guid.NewGuid().ToString(),
Value = CertValue,
Type = "AsymmetricX509Cert",
Usage = "Verify"
};
if (ShouldProcess(target: ObjectId.ToString(), action: string.Format("Adding a new certificate to application with objectId {0}", ObjectId)))
{
WriteObject(ActiveDirectoryClient.CreateAppKeyCredential(ObjectId, keyCredential));
}
}
else
{
throw new InvalidOperationException("No valid keyCredential or passowrdCredential to update!!");
}
});
}
public string ToString(string delimiter)
{
return(StartDate.ToString() + delimiter + EndDate.ToString() + delimiter + Status.ToString() + delimiter + Progress.ToString() + delimiter + Duration.ToString() + delimiter + Finished.ToString() + delimiter + RecordedDate.ToString() + delimiter + ResponseId.ToString() + delimiter + DistributionChannel.ToString() + delimiter + UserLanguage.ToString() + delimiter + TimePISFirstClick.ToString() + delimiter + TimePISLastClick.ToString() + delimiter + TimePISPageSubmit.ToString() + delimiter + TimePISClickCount.ToString() + delimiter + TimeConsentFirstClick.ToString() + delimiter + TimeConsentLastClick.ToString() + delimiter + TimeConsentPageSubmit.ToString() + delimiter + TimeConsentClickCount.ToString() + delimiter + Consent.ToString() + delimiter + ConsentMistake.ToString() + delimiter + Q177FirstClick.ToString() + delimiter + Q177LastClick.ToString() + delimiter + Q177PageSubmit.ToString() + delimiter + Q177ClickCount.ToString() + delimiter + ProlificId.ToString() + delimiter + TimeContext1FirstClick.ToString() + delimiter + TimeContext1LastClick.ToString() + delimiter + TimeContext1PageSubmit.ToString() + delimiter + TimeContext1ClickCount.ToString() + delimiter + TimeContext2FirstClick.ToString() + delimiter + TimeContext2LastClick.ToString() + delimiter + TimeContext2PageSubmit.ToString() + delimiter + TimeContext2ClickCount.ToString() + delimiter + TimeContext3FirstClick.ToString() + delimiter + TimeContext3LastClick.ToString() + delimiter + TimeContext3PageSubmit.ToString() + delimiter + TimeContext3ClickCount.ToString() + delimiter + TimeControlReportFirstClick.ToString() + delimiter + TimeControlReportLastClick.ToString() + delimiter + TimeControlReportPageSubmit.ToString() + delimiter + TimeControlReportClickCount.ToString() + delimiter + TimeUcdReportP1FirstClick.ToString() + delimiter + TimeUcdReportP1LastClick.ToString() + delimiter + TimeUcdReportP1PageSubmit.ToString() + delimiter + TimeUcdReportP1ClickCount.ToString() + delimiter + TimeUcdReportP2FirstClick.ToString() + delimiter + TimeUcdReportP2LastClick.ToString() + delimiter + TimeUcdReportP2PageSubmit.ToString() + delimiter + TimeUcdReportP2ClickCount.ToString() + delimiter + TimeS1FirstClick.ToString() + delimiter + TimeS1LastClick.ToString() + delimiter + TimeS1PageSubmit.ToString() + delimiter + TimeS1ClickCount.ToString() + delimiter + SubjUnderstanding.ToString() + delimiter + SubjClarity.ToString() + delimiter + SubjTrusted.ToString() + delimiter + TimeS2FirstClick.ToString() + delimiter + TimeS2LastClick.ToString() + delimiter + TimeS2PageSubmit.ToString() + delimiter + TimeS2ClickCount.ToString() + delimiter + SubjNext1.ToString() + delimiter + SubjNext3.ToString() + delimiter + SubjNext2.ToString() + delimiter + SubjNext4.ToString() + delimiter + SubjNext5.ToString() + delimiter + TimeOcStatusFirstClick.ToString() + delimiter + TimeOcStatusLastClick.ToString() + delimiter + TimeOcStatusPageSubmit.ToString() + delimiter + TimeOcStatusClickCount.ToString() + delimiter + OcStatusVerbal.ToString() + delimiter + OcStatusProb.ToString() + delimiter + OcStatusSlider1.ToString() + delimiter + TimeOcChildFirstClick.ToString() + delimiter + TimeOcChildLastClick.ToString() + delimiter + TimeOcChildPageSubmit.ToString() + delimiter + TimeOcChildClickCount.ToString() + delimiter + OcChildVerbal.ToString() + delimiter + OcChildProb.ToString() + delimiter + OcChildSlider1.ToString() + delimiter + TimeOcCompareFirstClick.ToString() + delimiter + TimeOcCompareLastClick.ToString() + delimiter + TimeOcComparePageSubmit.ToString() + delimiter + TimeOcCompareClickCount.ToString() + delimiter + ObjcompCompare.ToString() + delimiter + TimeOcHardFirstClick.ToString() + delimiter + TimeOcHardLastClick.ToString() + delimiter + TimeOcHardPageSubmit.ToString() + delimiter + TimeOcHardClickCount.ToString() + delimiter + Objcomp1000Hard.ToString() + delimiter + Objcomp800Hard.ToString() + delimiter + TimeSch1FirstClick.ToString() + delimiter + TimeSch1LastClick.ToString() + delimiter + TimeSch1PageSubmit.ToString() + delimiter + TimeSch1ClickCount.ToString() + delimiter + Scheuner1.ToString() + delimiter + Scheuner2.ToString() + delimiter + Scheuner3.ToString() + delimiter + TimeSch2FirstClick.ToString() + delimiter + TimeSch2LastClick.ToString() + delimiter + TimeSch2PageSubmit.ToString() + delimiter + TimeSch2ClickCount.ToString() + delimiter + Scheuner4.ToString() + delimiter + Scheuner5.ToString() + delimiter + Scheuner6.ToString() + delimiter + Scheuner7.ToString() + delimiter + Scheuner8.ToString() + delimiter + TimeSch3FirstClick.ToString() + delimiter + TimeSch3LastClick.ToString() + delimiter + TimeSch3PageSubmit.ToString() + delimiter + TimeSch3ClickCount.ToString() + delimiter + Scheuner9.ToString() + delimiter + Scheuner10.ToString() + delimiter + Scheuner11.ToString() + delimiter + Scheuner12.ToString() + delimiter + Scheuner13.ToString() + delimiter + TimeSch4FirstClick.ToString() + delimiter + TimeSch4LastClick.ToString() + delimiter + TimeSch4PageSubmit.ToString() + delimiter + TimeSch4ClickCount.ToString() + delimiter + Scheuner14.ToString() + delimiter + Scheuner15.ToString() + delimiter + Scheuner16.ToString() + delimiter + Scheuner17.ToString() + delimiter + Scheuner18.ToString() + delimiter + TimeLimitationsFirstClick.ToString() + delimiter + TimeLimitationsLastClick.ToString() + delimiter + TimeLimitationsPageSubmit.ToString() + delimiter + TimeLimitationsClickCount.ToString() + delimiter + Limitations.ToString() + delimiter + TimeNoticedFirstClick.ToString() + delimiter + TimeNoticedLastClick.ToString() + delimiter + TimeNoticedPageSubmit.ToString() + delimiter + TimeNoticedClickCount.ToString() + delimiter + ResultNoticed.ToString() + delimiter + ResultUnderstood.ToString() + delimiter + TimeSnumeracyFirstClick.ToString() + delimiter + TimeSnumeracyLastClick.ToString() + delimiter + TimeSnumeracyPageSubmit.ToString() + delimiter + TimeSnumeracyClickCount.ToString() + delimiter + SNumeracy1.ToString() + delimiter + SNumeracy2.ToString() + delimiter + SNumeracy3.ToString() + delimiter + SNumeracy4.ToString() + delimiter + SNumeracy5.ToString() + delimiter + SNumeracy6.ToString() + delimiter + SNumeracy7.ToString() + delimiter + SNumeracy8.ToString() + delimiter + TimePriorexp1FirstClick.ToString() + delimiter + TimePriorexp1LastClick.ToString() + delimiter + TimePriorexp1PageSubmit.ToString() + delimiter + TimePriorexp1ClickCount.ToString() + delimiter + CFExperience.ToString() + delimiter + CFExperienceDetail.ToString() + delimiter + TimePriorexp2FirstClick.ToString() + delimiter + TimePriorexp2LastClick.ToString() + delimiter + TimePriorexp2PageSubmit.ToString() + delimiter + TimePriorexp2ClickCount.ToString() + delimiter + TimeDemo1FirstClick.ToString() + delimiter + TimeDemo1LastClick.ToString() + delimiter + TimeDemo1PageSubmit.ToString() + delimiter + TimeDemo1ClickCount.ToString() + delimiter + Age.ToString() + delimiter + Gender.ToString() + delimiter + GenderOther.ToString() + delimiter + CombinedIncome.ToString() + delimiter + AdultsInHouse.ToString() + delimiter + ChildrenInHouse.ToString() + delimiter + Education.ToString() + delimiter + TimeDemo2FirstClick.ToString() + delimiter + TimeDemo2LastClick.ToString() + delimiter + TimeDemo2PageSubmit.ToString() + delimiter + TimeDemo2ClickCount.ToString() + delimiter + Comments.ToString() + delimiter + Design.ToString() + delimiter + TestResult.ToString() + delimiter + OCStatusAbsoluteTime.ToString() + delimiter + OCChildAbsoluteTime.ToString() + delimiter + OCCompareAbsoluteTime.ToString());
}
public override void ExecuteCmdlet()
{
ExecutionBlock(() =>
{
if (!this.IsParameterBound(c => c.EndDate))
{
WriteVerbose(Resources.Properties.Resources.DefaultEndDateUsed);
EndDate = StartDate.AddYears(1);
}
if (this.IsParameterBound(c => c.ServicePrincipalObject))
{
ObjectId = ServicePrincipalObject.Id;
}
if (this.IsParameterBound(c => c.ServicePrincipalName))
{
ObjectId = ActiveDirectoryClient.GetObjectIdFromSPN(ServicePrincipalName);
}
if (this.IsParameterBound(c => c.CertValue))
{
// Create object for key credential
var keyCredential = new KeyCredential()
{
EndDate = EndDate,
StartDate = StartDate,
KeyId = KeyId == default(Guid) ? Guid.NewGuid().ToString() : KeyId.ToString(),
Value = CertValue,
Type = "AsymmetricX509Cert",
Usage = "Verify"
};
if (ShouldProcess(target: ObjectId, action: string.Format("Adding a new caertificate to service principal with objectId {0}", ObjectId)))
{
WriteObject(ActiveDirectoryClient.CreateSpKeyCredential(ObjectId, keyCredential));
}
}
else
{
// If no credentials provided, set the password to a randomly generated GUID
var Password = Guid.NewGuid().ToString().ConvertToSecureString();
string decodedPassword = SecureStringExtensions.ConvertToString(Password);
var passwordCredential = new PasswordCredential()
{
EndDate = EndDate,
StartDate = StartDate,
KeyId = KeyId == default(Guid) ? Guid.NewGuid().ToString() : KeyId.ToString(),
Value = decodedPassword
};
if (ShouldProcess(target: ObjectId, action: string.Format("Adding a new password to service principal with objectId {0}", ObjectId)))
{
var spCred = new PSADCredentialWrapper(ActiveDirectoryClient.CreateSpPasswordCredential(ObjectId, passwordCredential));
spCred.Secret = Password;
WriteObject(spCred);
}
}
});
}
public DateTime GetStudySessionStart()
{
return(StartDate.Add(StartTime));
}
public override string ToString()
{
return($"[{Id} - {Name} ({EzName})]: From {StartDate.ToShortDateString()} To {EndDate.ToShortDateString()} With {Items?.Count()} {(Items.Count() == 1 ? "Item" : "Items")}");
}
private async Task RefreshAsync()
{
if (IsBusy)
{
return;
}
IsBusy = true;
try
{
var authToken = _settingsService.AuthAccessToken;
var trList = await _transactionService.GetTransactionsByDate(authToken, StartDate.ToUniversalTime(), EndDate.ToUniversalTime());
var trViewModelList = ObservableExtension.ToTransactionViewModels(trList);
TransactionsList = trViewModelList.OrderByDescending(c => c.OperationDateTime)
.GroupBy(c => c.OperationDateView)
.Select(c => new Grouping <string, TransactionViewModel>(c.Key, c))
.ToObservableCollection();
}
catch (ServiceAuthenticationException ex)
{
Debug.WriteLine($"[RetrieveData] Error Retrieve Data: {ex}");
await LogoutAsync();
}
catch (Exception ex)
{
Debug.WriteLine($"[RetrieveData] Error Retrieve Data: {ex}");
DialogService.ShowInformationUserMessage(this, "unable to retrieve data, check for Internet availability", "Cancel");
}
finally
{
IsBusy = false;
}
}
