public TypedWriteParams(
RecordTypeConverter?recordTypeConverter,
RecordType?overflowRecordType)
{
RecordTypeConverter = recordTypeConverter;
OverflowRecordType = overflowRecordType;
}
public override async Task Load(XElement node, bool requireName = true)
{
await base.Load(node, requireName);
if (node.TryGetAttribute <string>("maleMarker", out var maleMarker))
{
MaleMarker = new RecordType(maleMarker);
}
if (node.TryGetAttribute <string>("femaleMarker", out var femaleMarker))
{
FemaleMarker = new RecordType(femaleMarker);
}
if (MaleMarker.HasValue != FemaleMarker.HasValue)
{
throw new ArgumentException("Both submarkers must be set at once.");
}
this.MarkerPerGender = node.GetAttribute <bool>("markerPerGender");
if (MaleMarker.HasValue)
{
this.SubTypeGeneration.NullableProperty.OnNext((true, true));
}
FemaleConversions = RecordTypeConverterModule.GetConverter(node.Element(XName.Get("FemaleTypeOverrides", LoquiGenerator.Namespace)));
MaleConversions = RecordTypeConverterModule.GetConverter(node.Element(XName.Get("MaleTypeOverrides", LoquiGenerator.Namespace)));
}
public void From_14_ThenInvoke_ExpectResultOfSourceFunc(
RecordType?sourceFuncResult)
{
var actual = Func.From <string, int, StructType, long, decimal?, RecordType, RefType?, string?, StructType?, RefType, object, int, string, decimal?, RecordType?>(
(_, _, _, _, _, _, _, _, _, _, _, _, _, _) => sourceFuncResult);
var actualResult = actual.Invoke(
LowerSomeString, PlusFifteen, SomeTextStructType, default, decimal.MinusOne, MinusFifteenIdNullNameRecord, PlusFifteenIdRefType, SomeString, NullTextStructType, PlusFifteenIdRefType, ZeroIdRefType, MinusFifteen, EmptyString, decimal.One);
public ParseResult(
int?parsedIndex,
RecordType?dupParse)
{
KeepParsing = true;
ParsedIndex = parsedIndex;
DuplicateParseMarker = dupParse;
}
public void From_12_ThenInvoke_ExpectResultOfSourceFunc(
RecordType?sourceFuncResult)
{
var actual = Func.From <RecordType, RefType, int, string?, StructType, RefType, RecordType, decimal?, RecordType?, RefType, long, int, RecordType?>(
(_, _, _, _, _, _, _, _, _, _, _, _) => sourceFuncResult);
var actualResult = actual.Invoke(
MinusFifteenIdSomeStringNameRecord, MinusFifteenIdRefType, int.MaxValue, null, LowerSomeTextStructType, PlusFifteenIdRefType, ZeroIdNullNameRecord, default, default, PlusFifteenIdRefType, long.MaxValue, PlusFifteen);
public async Task From_01_ThenInvokeAsync_ExpectResultOfSourceFunc(
RecordType?sourceFuncResult)
{
var actual = AsyncFunc.From <RefType, RecordType?>((_, _) => Task.FromResult(sourceFuncResult));
var cancellationToken = default(CancellationToken);
var actualResult = await actual.InvokeAsync(PlusFifteenIdRefType, cancellationToken);
Assert.Equal(sourceFuncResult, actualResult);
}
public ParseResult(
int?parsedIndex,
bool keepParsing,
RecordType?dupParse,
int?lengthOverride)
{
KeepParsing = keepParsing;
ParsedIndex = parsedIndex;
DuplicateParseMarker = dupParse;
LengthOverride = lengthOverride;
}
public override async Task Load(XElement node, bool requireName = true)
{
await base.Load(node, requireName);
if (node.TryGetAttribute("boolAsMarker", out var boolAsMarker))
{
BoolAsMarker = new RecordType(boolAsMarker.Value);
this.NullableProperty.OnNext((false, true));
}
this.GetFieldData().RecordType = BoolAsMarker;
ByteLength = node.GetAttribute <int>(Constants.ByteLength, 1);
}
public async ValueTask From_12_ThenInvokeAsync_ExpectResultOfSourceFunc(
RecordType?sourceFuncResult)
{
var actual = AsyncValueFunc.From <int, object, RecordType?, RefType, object, string?, string, decimal, byte, RecordType, StructType, object, RecordType?>(
(_, _, _, _, _, _, _, _, _, _, _, _, _) => ValueTask.FromResult(sourceFuncResult));
var cancellationToken = new CancellationToken(canceled: true);
var actualResult = await actual.InvokeAsync(
PlusFifteen, new { Name = UpperSomeString }, null, PlusFifteenIdRefType, null !, SomeString, EmptyString, decimal.MinusOne, byte.MaxValue, MinusFifteenIdSomeStringNameRecord, LowerSomeTextStructType, SomeTextStructType, cancellationToken);
Assert.Equal(sourceFuncResult, actualResult);
}
public async ValueTask From_07_ThenInvokeAsync_ExpectResultOfSourceFunc(
RecordType?sourceFuncResult)
{
var actual = AsyncValueFunc.From <string?, int, RefType?, object, RecordType, string, StructType, RecordType?>(
(_, _, _, _, _, _, _, _) => ValueTask.FromResult(sourceFuncResult));
var cancellationToken = new CancellationToken(canceled: true);
var actualResult = await actual.InvokeAsync(
SomeString, PlusFifteen, MinusFifteenIdRefType, SomeTextStructType, null !, EmptyString, LowerSomeTextStructType, cancellationToken);
Assert.Equal(sourceFuncResult, actualResult);
}
private Category AddCategory(string name, RecordType?recordType = null, Category parent = null)
{
var category = new Category()
{
Name = name,
RecordType = recordType,
ParentCategory = parent,
IsActive = true,
UserId = _userId
};
_context.Categories.Add(category);
return(category);
}
/// <summary>
/// Resolve DNS entry
/// </summary>
/// <param name="name"></param>
/// <param name="type"></param>
/// <param name="cd"></param>
/// <param name="ednsClientSubnet"></param>
/// <param name="randomPadding"></param>
/// <returns></returns>
public async Task <GooglePublicDnsResponse> Resolve(string name, RecordType?type = null, bool cd = false, string ednsClientSubnet = "", string randomPadding = "")
{
try
{
var query = "name=" + Uri.EscapeDataString(name);
if (type.HasValue)
{
query += "&type=" + type;
}
if (cd)
{
query += "&cd=true";
}
if (!string.IsNullOrEmpty(ednsClientSubnet))
{
query += "&edns_client_subnet=" + ednsClientSubnet;
}
if (!string.IsNullOrEmpty(randomPadding))
{
query += "&random_padding=" + randomPadding;
}
HttpResponseMessage response = await Client.GetAsync(BaseUrl + query).ConfigureAwait(false);
var body = await response.Content.ReadAsStringAsync().ConfigureAwait(false);
response.EnsureSuccessStatusCode();
if (response.IsSuccessStatusCode)
{
var dnsResponse = JsonConvert.DeserializeObject <GooglePublicDnsResponse>(body);
dnsResponse.RawJson = body;
return(dnsResponse);
}
return(null);
}
catch (TaskCanceledException)
{
// timeout
throw new TimeoutException();
}
}
private DnsMessage GetDnsMessage(string domainName, RecordType?type = null)
{
if (string.IsNullOrEmpty(domainName))
{
throw new ArgumentNullException("domainName");
}
var domain = DomainName.Parse(domainName);
var dnsMessage = type.HasValue ? _dnsClient.Resolve(domain, type.Value) : _dnsClient.Resolve(domain);
if ((dnsMessage == null) ||
((dnsMessage.ReturnCode != ReturnCode.NoError) && (dnsMessage.ReturnCode != ReturnCode.NxDomain)))
{
throw new SystemException(); // DNS request failed
}
return(dnsMessage);
}
/// <summary>
/// Exports a subrecord header, and creates disposable to track content length.
/// When disposed, header will automatically update its length bytes.
/// </summary>
/// <param name="writer">Writer to export header to</param>
/// <param name="record">RecordType of the header</param>
/// <param name="overflowRecord">RecordType to use for an extra preceding subrecord, if the length is too large</param>
/// <param name="writerToUse">Writer to write to for the contents of the header</param>
/// <returns>Object to dispose when header's content has been written</returns>
public static IDisposable Subrecord(
MutagenWriter writer,
RecordType record,
RecordType?overflowRecord,
out MutagenWriter writerToUse)
{
if (overflowRecord.HasValue)
{
var ret = new ExtraLengthHeaderExport(
writer,
record,
overflowRecord.Value);
writerToUse = ret.PrepWriter;
return(ret);
}
else
{
writerToUse = writer;
return(Subrecord(writer, record));
}
}
public void ReportIssue(RecordType?recordType, string note)
{
// Nothing for now. Need to implement
}
/// <summary>
///
/// </summary>
/// <param name="departments"></param>
/// <param name="searchKey"></param>
/// <param name="query"></param>
/// <param name="order"></param>
/// <param name="start"></param>
/// <param name="limit"></param>
/// <returns></returns>
public static DataTable GetListRecords(string departments, RecordType?type, string searchKey, string query, string order, int?start, int?limit)
{
var sql = string.Empty;
sql += " SELECT * FROM( "+
" SELECT "+
" rc.Id, "+
" rc.EmployeeCode, "+
" rc.FullName, "+
" rc.Alias, "+
" rc.BirthDate, "+
" DATEDIFF(YEAR, rc.BirthDate, GETDATE()) as Age, "+
" rc.Sex, "+
" rc.FunctionaryCode, "+
" rc.ImageUrl, "+
" rc.OriginalFile, "+
" rc.ResidentPlace, "+
" rc.Address, "+
" rc.PreviousJob, "+
" rc.RecruimentDepartment, "+
" rc.RecruimentDate, "+
" rc.ParticipationDate, "+
" rc.FunctionaryDate, "+
" rc.AssignedWork, "+
" rc.CPVJoinedDate, "+
" rc.CPVOfficialJoinedDate, "+
" rc.CPVCardNumber, "+
" rc.CPVJoinedPlace, "+
" rc.VYUJoinedDate, "+
" rc.VYUJoinedPlace, "+
" rc.ArmyJoinedDate, "+
" rc.ArmyLeftDate, "+
" rc.TitleAwarded, "+
" rc.Skills, "+
" rc.BloodGroup, "+
" rc.Height, "+
" rc.Weight, "+
" rc.RankWounded, "+
" rc.IDNumber, "+
" rc.IDIssueDate, "+
" rc.InsuranceNumber, "+
" rc.InsuranceIssueDate, "+
" rc.PersonalTaxCode, "+
" rc.CellPhoneNumber, "+
" rc.HomePhoneNumber, "+
" rc.WorkPhoneNumber, "+
" rc.WorkEmail, "+
" rc.PersonalEmail, "+
" rc.Biography, "+
" rc.ForeignOrganizationJoined, "+
" rc.RelativesAboard, "+
" rc.Review, "+
" rc.ContactPersonName, "+
" rc.ContactRelation, "+
" rc.ContactPhoneNumber, "+
" rc.ContactAddress, "+
" rc.WorkStatusDate, "+
" rc.WorkStatusReason, "+
" (SELECT TOP 1 dv.Name FROM cat_Department dv WHERE dv.Id = rc.DepartmentId) as DepartmentName, "+
" (SELECT TOP 1 cf.Name FROM cat_Folk cf WHERE cf.Id = rc.FolkId) as FolkName, "+
" (SELECT TOP 1 cr.Name FROM cat_Religion cr WHERE cr.Id = rc.ReligionId) as ReligionName, "+
" (SELECT TOP 1 cm.Name FROM cat_MaritalStatus cm WHERE cm.Id = rc.MaritalStatusId) as MaritalStatusName, "+
" (SELECT TOP 1 cw.Name FROM cat_WorkStatus cw WHERE cw.Id = rc.WorkStatusId) as WorkStatusName, "+
" (SELECT TOP 1 cp.Name FROM cat_PersonalClass cp WHERE cp.Id = rc.PersonalClassId) as PersonalClassName, "+
" (SELECT TOP 1 cfa.Name FROM cat_FamilyClass cfa WHERE cfa.Id = rc.FamilyClassId) as FamilyClassName, "+
" (SELECT TOP 1 cpo.Name FROM cat_Position cpo WHERE cpo.Id = rc.PositionId) as PositionName, "+
" (SELECT TOP 1 cj.Name FROM cat_JobTitle cj WHERE cj.Id = rc.JobTitleId) as JobTitleName, "+
" (SELECT TOP 1 cbe.Name FROM cat_BasicEducation cbe WHERE cbe.Id = rc.BasicEducationId) as BasicEducationName, "+
" (SELECT TOP 1 ced.Name FROM cat_Education ced WHERE ced.Id = rc.EducationId) as EducationName, "+
" (SELECT TOP 1 cpl.Name FROM cat_PoliticLevel cpl WHERE cpl.Id = rc.PoliticLevelId) as PoliticLevelName, "+
" (SELECT TOP 1 cml.Name FROM cat_ManagementLevel cml WHERE cml.Id = rc.ManagementLevelId) as ManagementLevelName, "+
" (SELECT TOP 1 cll.Name FROM cat_LanguageLevel cll WHERE cll.Id = rc.LanguageLevelId) as LanguageLevelName, "+
" (SELECT TOP 1 cit.Name FROM cat_ITLevel cit WHERE cit.Id = rc.ITLevelId) as ITLevelName, "+
" (SELECT TOP 1 cpv.Name FROM cat_CPVPosition cpv WHERE cpv.Id = rc.CPVPositionId) as CPVPositionName, "+
" (SELECT TOP 1 vyu.Name FROM cat_VYUPosition vyu WHERE vyu.Id = rc.VYUPositionId) as VYUPositionName, "+
" (SELECT TOP 1 al.Name FROM cat_ArmyLevel al WHERE al.Id = rc.ArmyLevelId) as ArmyLevelName, "+
" (SELECT TOP 1 chs.Name FROM cat_HealthStatus chs WHERE chs.Id = rc.HealthStatusId) as HealthStatusName, "+
" (SELECT TOP 1 cfp.Name FROM cat_FamilyPolicy cfp WHERE cfp.Id = rc.FamilyPolicyId) as FamilyPolicyName, "+
" (SELECT TOP 1 ip.Name FROM cat_IDIssuePlace ip WHERE ip.Id = rc.IDIssuePlaceId) as IDIssuePlaceName, "+
" (SELECT TOP 1 et.Name FROM cat_EmployeeType et WHERE et.Id = rc.EmployeeTypeId) as EmployeeTypeName, "+
" (CASE WHEN rc.BirthPlaceWardId IS NOT NULL THEN ( ISNULL((SELECT TOP 1 bpw.Name FROM cat_Location bpw WHERE bpw.Id = rc.BirthPlaceWardId) + ',', '') "+
" + isnull((SELECT TOP 1 bpd.Name FROM cat_Location bpd WHERE bpd.Id = rc.BirthPlaceDistrictId) + ',', '') + "+
" ISNULL((SELECT TOP 1 bpp.Name FROM cat_Location bpp WHERE bpp.Id = rc.BirthPlaceProvinceId), '')) "+
" END "+
" ) AS BirthPlace, "+
" (CASE WHEN rc.HometownWardId IS NOT NULL THEN ( ISNULL((SELECT TOP 1 bpw.Name FROM cat_Location bpw WHERE bpw.Id = rc.HometownWardId) + ',', '') "+
" + isnull((SELECT TOP 1 bpd.Name FROM cat_Location bpd WHERE bpd.Id = rc.HometownDistrictId) + ',', '') + "+
" ISNULL((SELECT TOP 1 bpp.Name FROM cat_Location bpp WHERE bpp.Id = rc.HometownProvinceId), '')) "+
" END "+
" ) AS Hometown, "+
" (SELECT TOP 1 hb.AccountNumber FROM hr_Bank hb WHERE hb.RecordId = rc.Id) as AccountNumber, "+
" (SELECT TOP 1 cb.Name FROM cat_Bank cb, hr_Bank hb WHERE cb.Id = hb.BankId AND hb.RecordId = rc.Id) as BankName, "+
" (SELECT TOP 1 sa.Factor FROM sal_SalaryDecision sa WHERE sa.RecordId = rc.Id ORDER BY sa.EffectiveDate DESC) as SalaryFactor, "+
" (SELECT TOP 1 sa.Grade FROM sal_SalaryDecision sa WHERE sa.RecordId = rc.Id ORDER BY sa.EffectiveDate DESC) as SalaryGrade, "+
" (SELECT TOP 1 sa.EffectiveDate FROM sal_SalaryDecision sa WHERE sa.RecordId = rc.Id ORDER BY sa.EffectiveDate DESC) as EffectiveDate, "+
//" (SELECT TOP 1 sa.PositionAllowance FROM sal_SalaryDecision sa WHERE sa.RecordId = rc.Id ORDER BY sa.EffectiveDate DESC) as PositionAllowance, " +
//" (SELECT TOP 1 sa.OtherAllowance FROM sal_SalaryDecision sa WHERE sa.RecordId = rc.Id ORDER BY sa.EffectiveDate DESC) as OtherAllowance, " +
" (SELECT TOP 1 cq.Code FROM cat_Quantum cq, sal_SalaryDecision sa WHERE cq.Id = sa.QuantumId AND sa.RecordId = rc.Id ORDER BY sa.EffectiveDate DESC) as QuantumCode, "+
" (SELECT TOP 1 cq.Name FROM cat_Quantum cq, sal_SalaryDecision sa WHERE cq.Id = sa.QuantumId AND sa.RecordId = rc.Id ORDER BY sa.EffectiveDate DESC) as QuantumName, "+
" ROW_NUMBER() OVER(ORDER BY rc.Id ASC) SK "+
" FROM hr_Record rc "+
" WHERE 1 =1 ";
if (!string.IsNullOrEmpty(searchKey))
{
sql += " AND (rc.FullName LIKE N'%{0}%'".FormatWith(searchKey) +
" OR rc.IDNumber LIKE N'%{0}%' ".FormatWith(searchKey) +
" OR rc.EmployeeCode LIKE N'%{0}%') ".FormatWith(searchKey);
}
if (!string.IsNullOrEmpty(departments))
{
sql += " AND rc.DepartmentId IN({0})".FormatWith(departments);
}
if (type != null)
{
sql += " AND rc.Type = {0}".FormatWith((int)type);
}
var queryCondition = GetSearchQuery(query);
if (!string.IsNullOrEmpty(queryCondition))
{
sql += queryCondition;
}
if (!string.IsNullOrEmpty(order))
{
sql += " ORDER BY {0} ".FormatWith(order);
}
sql += " )#tmp ";
if (start != null && limit != null)
{
sql += " WHERE #tmp.SK > {0}".FormatWith(start) +
" AND #tmp.SK <= {0}".FormatWith(start + limit);
}
return(SQLHelper.ExecuteTable(sql));
}
internal static string ToSerializedValue(this RecordType?value)
{
return(value == null ? null : ((RecordType)value).ToSerializedValue());
}
// GET: Fields
public ActionResult Index(string SearchName, string SearchFileVersion, ClaimLayoutType?SearchClaimLayout, RecordType?SearchRecordType, FormGrouping?SearchFormGrouping, int?page, int?PageSize, string sortOption)
{
TempData["MyFVM"] = null;
ViewBag.FileVersion = SearchFileVersion;
ViewBag.SearchName = SearchName;
ViewBag.ClaimLayout = SearchClaimLayout;
ViewBag.RecordType = SearchRecordType;
ViewBag.FormGrouping = SearchFormGrouping;
ViewBag.sortOption = sortOption;
List <Field> fields = new List <Field>();
if (!(String.IsNullOrEmpty(SearchName) && String.IsNullOrEmpty(SearchFileVersion) && SearchClaimLayout == null && SearchRecordType == null && SearchFormGrouping == null))
{
fields = db.Fields.ToList();
if (!String.IsNullOrEmpty(SearchName))
{
fields = fields.Where(x => x.DisplayName.ToLower().Contains(SearchName.ToLower()) || x.Name.ToLower().Contains(SearchName.ToLower())).ToList();
}
if (!String.IsNullOrEmpty(SearchFileVersion))
{
fields = fields.Where(x => x.FileVersion == SearchFileVersion).ToList();
}
if (SearchClaimLayout != null)
{
fields = fields.Where(x => x.ClaimType == SearchClaimLayout).ToList();
}
if (SearchRecordType != null)
{
fields = fields.Where(x => x.RecordType == SearchRecordType).ToList();
}
if (SearchFormGrouping != null)
{
fields = fields.Where(x => x.FormGroup == SearchFormGrouping).ToList();
}
switch (sortOption)
{
case "name_acs":
fields = fields.OrderBy(p => p.Name).ToList();
break;
case "name_desc":
fields = fields.OrderByDescending(p => p.Name).ToList();
break;
case "description_acs":
fields = fields.OrderBy(p => p.Description).ToList();
break;
case "description_desc":
fields = fields.OrderByDescending(p => p.Description).ToList();
break;
case "displayname_acs":
fields = fields.OrderBy(p => p.DisplayName).ToList();
break;
case "displayname_desc":
fields = fields.OrderByDescending(p => p.DisplayName).ToList();
break;
case "pseudocode_acs":
fields = fields.OrderBy(p => p.PseudoCode).ToList();
break;
case "pseudocode_desc":
fields = fields.OrderByDescending(p => p.PseudoCode).ToList();
break;
case "fileversion_acs":
fields = fields.OrderBy(p => p.FileVersion).ToList();
break;
case "fileversion_desc":
fields = fields.OrderByDescending(p => p.FileVersion).ToList();
break;
case "recordtype_acs":
fields = fields.OrderBy(p => p.RecordType).ToList();
break;
case "recordtype_desc":
fields = fields.OrderByDescending(p => p.RecordType).ToList();
break;
case "claimtype_acs":
fields = fields.OrderBy(p => p.ClaimType).ToList();
break;
case "claimtype_desc":
fields = fields.OrderByDescending(p => p.ClaimType).ToList();
break;
case "formgroup_acs":
fields = fields.OrderBy(p => p.FormGroup).ToList();
break;
case "formgroup_desc":
fields = fields.OrderByDescending(p => p.FormGroup).ToList();
break;
default:
fields = fields.OrderBy(p => p.FieldID).ToList();
break;
}
}
int DefaultPageSize = 10;
int currentPageIndex = page.HasValue ? page.Value - 1 : 0;
if (PageSize != null)
{
DefaultPageSize = (int)PageSize;
}
ViewBag.PageSize = DefaultPageSize;
int pageNumber = (page ?? 1);
ViewBag.Page = page;
FieldsViewModel fvm = new FieldsViewModel();
fvm.lsFields = fields.ToPagedList(pageNumber, DefaultPageSize);
fvm.slFileVersions = Utility.GetFileVersions();
fvm.SearchFileVersion = SearchFileVersion;
fvm.SearchClaimLayout = SearchClaimLayout;
TempData["MyFVM"] = fvm;
return(Request.IsAjaxRequest()
? (ActionResult)PartialView("FieldList", fvm.lsFields)
: View(fvm));
}
