public Residency ReadResidency(string id)
{
OpenConnection();
Residency residency = new Residency();
using (var cmd = new SqlCommand("select residency_id,residency_name,residency_cost from En_Residency" +
" where residency_id=@id", con))
{
cmd.Parameters.AddWithValue("@id", id);
using (var reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
if (reader.Read())
{
residency.Id = reader.GetGuid(0).ToString();
residency.Name = reader.GetString(1);
residency.Cost = reader.GetInt32(2);
}
}
}
}
return(residency);
}
public void Map_Residency_model_with_location_to_residency()
{
ResidencyModel residency = new ResidencyModel
{
CitizenshipStatus = "US",
CountryOfCitizenship = "AA",
DriversLicenseNumber = "NC12345",
DriversLicenseState = "NC",
EntityState = LogicBuilder.Domain.EntityStateType.Added,
HasValidDriversLicense = true,
ImmigrationStatus = "BB",
ResidentState = "AR",
UserId = 7,
StatesLivedIn = new List <StateLivedInModel>
{
new StateLivedInModel {
EntityState = LogicBuilder.Domain.EntityStateType.Added, State = "OH"
},
new StateLivedInModel {
EntityState = LogicBuilder.Domain.EntityStateType.Deleted, State = "TN", UserId = 7, StateLivedInId = 41
}
}
};
Residency mapped = mapper.Map <Residency>(residency);
Assert.Equal("US", mapped.CitizenshipStatus);
Assert.Equal("OH", mapped.StatesLivedIn.First().State);
Assert.Equal(LogicBuilder.Data.EntityStateType.Added, mapped.StatesLivedIn.First().EntityState);
}
/// <summary>
/// Gets the residency status of an array of resources.
/// </summary>
/// <remarks>
/// The information returned by the pResidencyStatus argument array describes the residency status at the time that the QueryResourceResidency method was called. Note that the residency status will constantly change. If you call the QueryResourceResidency method during a device removed state, the pResidencyStatus argument will return the DXGI_RESIDENCY_EVICTED_TO_DISK flag. Note??This method should not be called every frame as it incurs a non-trivial amount of overhead.
/// </remarks>
/// <param name="comObjects">An array of <see cref="SharpDX.DXGI.Resource"/> interfaces. </param>
/// <returns>Returns an array of <see cref="SharpDX.DXGI.Residency"/> flags. Each element describes the residency status for corresponding element in the ppResources argument array. </returns>
/// <unmanaged>HRESULT IDXGIDevice::QueryResourceResidency([In, Buffer] const IUnknown** ppResources,[Out, Buffer] DXGI_RESIDENCY* pResidencyStatus,[None] int NumResources)</unmanaged>
public Residency[] QueryResourceResidency(params ComObject[] comObjects)
{
int numResources = comObjects.Length;
var residencies = new Residency[numResources];
QueryResourceResidency(comObjects, residencies, numResources);
return residencies;
}
public async Task Can_edit_client()
{
var organization = new Organization {
Id = 1
};
var residency = new Residency {
Id = 2, Organization = organization, OrganizationId = organization.Id
};
var identifierTypes = new[] { new ClientIdentifierType {
Id = 1, Name = "foo"
} };
var client = new Client {
Id = 42, Residencies = new[] { residency }, Identifiers = Enumerable.Empty <ClientIdentifier>().ToList()
};
var command = GetCommand(add: false);
tentantOrganizationProvider.GetTenantOrganization().Returns(organization);
context.Clients = Substitute.For <IDbSet <Client>, IDbAsyncEnumerable <Client> >()
.Initialize(new [] { client }.AsQueryable());
context.ClientIdentifierTypes = Substitute.For <IDbSet <ClientIdentifierType>, IDbAsyncEnumerable <ClientIdentifierType> >()
.Initialize(identifierTypes.AsQueryable());
context.Payees = Substitute.For <IDbSet <Payee>, IDbAsyncEnumerable <Payee> >()
.Initialize(Enumerable.Empty <Payee>().AsQueryable());
var result = await handler.Handle(command);
Assert.IsInstanceOfType(result, typeof(SuccessResult));
context.Received().SaveChangesAsync()
.IgnoreAwaitForNSubstituteAssertion();
}
/// <summary>
/// Gets the residency status of an array of resources.
/// </summary>
/// <remarks>
/// The information returned by the pResidencyStatus argument array describes the residency status at the time that the QueryResourceResidency method was called. Note that the residency status will constantly change. If you call the QueryResourceResidency method during a device removed state, the pResidencyStatus argument will return the DXGI_RESIDENCY_EVICTED_TO_DISK flag. Note??This method should not be called every frame as it incurs a non-trivial amount of overhead.
/// </remarks>
/// <param name="comObjects">An array of <see cref="SharpDX.DXGI.Resource"/> interfaces. </param>
/// <returns>Returns an array of <see cref="SharpDX.DXGI.Residency"/> flags. Each element describes the residency status for corresponding element in the ppResources argument array. </returns>
/// <unmanaged>HRESULT IDXGIDevice::QueryResourceResidency([In, Buffer] const IUnknown** ppResources,[Out, Buffer] DXGI_RESIDENCY* pResidencyStatus,[None] int NumResources)</unmanaged>
public Residency[] QueryResourceResidency(params ComObject[] comObjects)
{
int numResources = comObjects.Length;
var residencies = new Residency[numResources];
QueryResourceResidency(comObjects, residencies, numResources);
return(residencies);
}
public ActionResult DeleteConfirmed(int id)
{
Residency residency = db.Residencies.Find(id);
db.Residencies.Remove(residency);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ResidencyID,ResidencyName")] Residency residency)
{
if (ModelState.IsValid)
{
db.Entry(residency).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(residency));
}
public ActionResult Create([Bind(Include = "ResidencyID,ResidencyName")] Residency residency)
{
if (ModelState.IsValid)
{
db.Residencies.Add(residency);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(residency));
}
public ImageHandle SetResidency(Residency residency, AccessMode m)
{
if (residency == Residency.Resident)
{
GL.Arb.MakeImageHandleResident(hndl, (All)m);
}
else
{
GL.Arb.MakeImageHandleNonResident(hndl);
}
return(this);
}
public void Add(ResidencyDTO dto)
{
using (var uow = new UnitOfWork(new DataContext()))
{
var obj = new Residency();
obj.PersonalInfoID = dto.PersonalInfoID;
obj.CreateTimeStamp = DateTime.Now;
obj.LengthOfResidency = dto.LengthOfResidency;
obj.RequestedBy = dto.RequestedBy;
uow.Residencies.Add(obj);
uow.Complete();
dto.ID = obj.ResidencyID;
}
}
private void Residency_Button(object sender, RoutedEventArgs e)
{
var rowSelected = v_data_grid.SelectedCells[0].Item as Resident;
Residency residency = new Residency();
residency.v_name1.Text = $"{rowSelected.FirstName} {rowSelected.MiddleName} {rowSelected.LastName}";
residency.v_name2.Text = $"{rowSelected.FirstName} {rowSelected.MiddleName} {rowSelected.LastName}";
residency.v_name3.Text = $"{rowSelected.FirstName} {rowSelected.MiddleName} {rowSelected.LastName}";
residency.v_civilstat.Text = rowSelected.CivilStatus;
residency.v_day.Text = DateTime.Now.Day.ToString();
residency.v_month.Text = $"{DateTime.Now.Month} {DateTime.Now.Year}";
residency.v_age.Text = ComputeAge((DateTime)rowSelected.BirthDate).ToString();
residency.Show();
}
public TextureHandle SetResidency(Residency residency)
{
if (residency == Residency.Resident && !isResident)
{
GL.Arb.MakeTextureHandleResident(hndl);
isResident = true;
}
else if (residency == Residency.NonResident && isResident)
{
GL.Arb.MakeTextureHandleNonResident(hndl);
isResident = false;
}
return(this);
}
// GET: Residencies/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Residency residency = db.Residencies.Find(id);
if (residency == null)
{
return(HttpNotFound());
}
return(View(residency));
}
public Order BuildOrder(ApplicationDbContext context, Organization organization, Residency residency)
{
return(new Order
{
OrderNumber = this.OrderNumber,
IsPropertyDamage = this.IsPropertyDamage,
Total = this.Amount.Value,
WithholdingPercent = this.Withholding.Value,
Balance = this.Ballance ?? this.Amount.Value,
Comments = this.Comments,
IsSatified = this.IsSatisfied,
SatisfiedReason = this.SatisfiedReason,
Payee = GetPayee(context),
Residency = residency,
Organization = organization
});
}
public static void FillData(ApplicationContext context, UserManager <User> _userManager)
{
if (!context.TypeOfDocuments.Any())
{
TypeOfDocument pasport = new TypeOfDocument {
Name = "Паспорт"
};
TypeOfDocument pasport1 = new TypeOfDocument {
Name = "ВоенныйБилет"
};
TypeOfDocument pasport2 = new TypeOfDocument {
Name = "СвидетельствоОрождении"
};
context.TypeOfDocuments.AddRange(pasport, pasport1, pasport2);
context.SaveChanges();
}
if (!context.Countries.Any())
{
Country country = new Country {
CountryName = "Кыргызстан"
};
Country country1 = new Country {
CountryName = "Таджикистан"
};
Country country2 = new Country {
CountryName = "Казахстан"
};
context.Countries.AddRange(country, country1, country2);
context.SaveChanges();
}
if (!context.LegalForms.Any())
{
LegalForm legalForm = new LegalForm {
LegalFormName = "ОсОО"
};
LegalForm legalForm1 = new LegalForm {
LegalFormName = "ОАО"
};
LegalForm legalForm2 = new LegalForm {
LegalFormName = "ЗАО"
};
context.LegalForms.AddRange(legalForm, legalForm1, legalForm2);
context.SaveChanges();
}
if (!context.PropertyTypes.Any())
{
PropertyType propertyType = new PropertyType {
PropertyTypeName = "Государственная"
};
PropertyType propertyType1 = new PropertyType {
PropertyTypeName = "Частная"
};
PropertyType propertyType2 = new PropertyType {
PropertyTypeName = "Смешанная"
};
context.PropertyTypes.AddRange(propertyType, propertyType1, propertyType2);
context.SaveChanges();
}
if (!context.Residencies.Any())
{
Residency residency = new Residency {
ResidencyName = "Резидент"
};
Residency residency1 = new Residency {
ResidencyName = "НеРезидент"
};
context.Residencies.AddRange(residency, residency1);
context.SaveChanges();
}
if (!context.TaxInspections.Any())
{
TaxInspection taxInspection = new TaxInspection {
TaxInspectionName = "Ленинский"
};
TaxInspection taxInspection1 = new TaxInspection {
TaxInspectionName = "Свердловский"
};
TaxInspection taxInspection2 = new TaxInspection {
TaxInspectionName = "Октябрьский"
};
context.TaxInspections.AddRange(taxInspection, taxInspection1, taxInspection2);
context.SaveChanges();
}
if (!context.TransactionTypes.Any())
{
List <TransactionType> transactions = new List <TransactionType>();
transactions.Add(TransactionType.Create(TransactionTypesEnum.Debit));
transactions.Add(TransactionType.Create(TransactionTypesEnum.Credit));
context.TransactionTypes.AddRange(transactions);
context.SaveChanges();
}
if (!context.ExchangeRateTypes.Any())
{
ExchangeRateType exchangeRateType = ExchangeRateType.Create(ExchangeRateTypesEnum.NBKR);
ExchangeRateType exchangeRateType1 = ExchangeRateType.Create(ExchangeRateTypesEnum.Market);
context.ExchangeRateTypes.AddRange(exchangeRateType, exchangeRateType1);
context.SaveChanges();
}
if (!context.TransferStates.Any())
{
context.AddRange(
TransferState.Create(TransferStatesEnum.Confirmed),
TransferState.Create(TransferStatesEnum.NotConfirmed),
TransferState.Create(TransferStatesEnum.Canceled),
TransferState.Create(TransferStatesEnum.BalanceNotEnough),
TransferState.Create(TransferStatesEnum.AccountIsLocked));
context.SaveChanges();
}
if (!context.TypeOfTransfers.Any())
{
context.AddRange(
TypeOfTransfer.Create(TypeOfTransfersEnum.InnerTransfer),
TypeOfTransfer.Create(TypeOfTransfersEnum.InterBankTransfer),
TypeOfTransfer.Create(TypeOfTransfersEnum.Conversion));
context.SaveChanges();
}
if (!context.Currencies.Any())
{
context.Currencies.Add
(
new Currency {
Code = "123", Name = "SOM", IsNativeCurrency = true
}
);
context.SaveChanges();
}
if (!context.OurBank.Any())
{
Currency currency = context.Currencies.FirstOrDefault(n => n.IsNativeCurrency == true);
Account bankAccount = new Account {
Locked = false, CurrencyId = currency.Id, Number = "1234567890123456"
};
context.Accounts.Add(bankAccount);
context.SaveChanges();
BankInfo bank = new BankInfo {
BankName = "OurBank", Email = "*****@*****.**"
};
context.BankInfos.Add(bank);
OurBank ourBank = new OurBank {
BIK = "123", AccountId = bankAccount.Id, BankInfoId = bank.Id
};
context.OurBank.Add(ourBank);
context.SaveChanges();
}
if (!context.IntervalTypes.Any())
{
List <IntervalType> intervalTypes = new List <IntervalType>();
intervalTypes.Add(IntervalType.Create(IntervalTypesEnum.OnceADay));
intervalTypes.Add(IntervalType.Create(IntervalTypesEnum.OnceAWeek));
intervalTypes.Add(IntervalType.Create(IntervalTypesEnum.OnceInTwoWeeks));
intervalTypes.Add(IntervalType.Create(IntervalTypesEnum.OnceAMonth));
intervalTypes.Add(IntervalType.Create(IntervalTypesEnum.OnceAQuarter));
intervalTypes.Add(IntervalType.Create(IntervalTypesEnum.OnceAHalfYear));
intervalTypes.Add(IntervalType.Create(IntervalTypesEnum.OnceAYear));
context.IntervalTypes.AddRange(intervalTypes);
context.SaveChanges();
}
if (!context.Roles.Any())
{
context.Roles.AddRange
(
new IdentityRole {
Name = "admin", NormalizedName = "ADMIN"
},
new IdentityRole {
Name = "user", NormalizedName = "USER"
}
);
context.SaveChanges();
}
if (context.Users.FirstOrDefault(u => u.UserName == "Admin") == null)
{
var result = _userManager.CreateAsync(new User
{
UserName = "******",
Email = "*****@*****.**",
IsTwoFactorOn = false,
IsPasswordChanged = true,
}, "Admin123@");
if (result.Result.Succeeded)
{
User user = context.Users.FirstOrDefault(u => u.UserName == "Admin");
IdentityRole role = context.Roles.FirstOrDefault(r => r.Name == "Admin");
context.UserRoles.Add(new IdentityUserRole <string>
{
RoleId = role.Id,
UserId = user.Id
});
context.SaveChanges();
}
}
if (!context.AddressTypes.Any())
{
List <AddressType> addressTypes = new List <AddressType>
{
AddressType.Create(AddressTypesEnum.FactAddress),
AddressType.Create(AddressTypesEnum.LegalAddress),
AddressType.Create(AddressTypesEnum.BirthAddress)
};
context.AddRange(addressTypes);
context.SaveChanges();
//List<Address> adresses = context.Addresses.ToList();
//AddressType factaddress =
// context.AddressTypes.FirstOrDefault(a => a.TypeName == AddressTypesEnum.FactAddress.ToString());
//AddressType legaladdress =
// context.AddressTypes.FirstOrDefault(a => a.TypeName == AddressTypesEnum.LegalAddress.ToString());
//AddressType birthaddress =
// context.AddressTypes.FirstOrDefault(a => a.TypeName == AddressTypesEnum.BirthAddress.ToString());
//foreach (Address address in adresses)
//{
// switch (address.TypeOfAddress)
// {
// case "factaddress": address.AddressType = factaddress;
// break;
// case "legaladdress": address.AddressType = legaladdress;
// break;
// case "birthaddress": address.AddressType = birthaddress;
// break;
// }
//}
//context.UpdateRange(adresses);
//context.SaveChanges();
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
residency = repository.ReadResidency(_residencyId);
lblResidencyName.Content = residency.Name;
}
public static StudentApplicationDataLookup GetApplicationAllLookups()
{
HttpResponse response = HttpContext.Current.Response;
//response.AppendHeader("Access-Control-Allow-Origin", "*");
//response.AppendHeader("Access-Control-Allow-Methods", "*");
//headers.set('Access-Control-Allow-Headers', 'true');
//headers.set('Access-Control-Allow-Methods','GET, POST, PATCH, PUT, DELETE, OPTIONS');
//headers.set('Access-Control-Allow-Credentials', 'Origin, Content-Type, X-Auth-Token');
Files.dbConnection con = new Files.dbConnection();
StudentApplicationDataLookup lkp = new StudentApplicationDataLookup();
try
{
#region Course List
List <Course> courses = new List <Course>();
string sqlCourses = string.Concat("[dbo].[sp_getCourses]");
DataTable tempTableCourse = null;
tempTableCourse = con.executeSelectNoParameter(sqlCourses); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempTableCourse != null) || (tempTableCourse.Rows.Count >= 0))
{
foreach (DataRow drr in tempTableCourse.Rows)
{
Course course = new Course();
course.CourseID = Convert.ToInt32(drr["CourseID"]);
course.CourseName = drr["Course"].ToString();
course.CourseCode = drr["CourseCode"].ToString();
courses.Add(course);
}
}
lkp.course = courses;
#endregion
#region Get Campus
List <Campus> campuses = new List <Campus>();
string sqlCampuses = string.Concat("[dbo].[sp_getAllCampus]");
DataTable tempTableCampus = null;
tempTableCampus = con.executeSelectNoParameter(sqlCampuses); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempTableCampus != null) || (tempTableCampus.Rows.Count >= 0))
{
foreach (DataRow drr in tempTableCampus.Rows)
{
Campus campus = new Campus();
campus.campusID = Convert.ToInt32(drr["CampusID"].ToString());
campus.campusName = drr["Campus"].ToString();
campuses.Add(campus);
}
}
lkp.campus = campuses;
#endregion
#region Get CourseCampus
List <CourseCampus> ccCollection = new List <CourseCampus>();
string sqlCC = string.Concat("[dbo].[sp_getCourseCampus]");
DataTable tempTableCC = null;
tempTableCC = con.executeSelectNoParameter(sqlCC); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempTableCC != null) || (tempTableCC.Rows.Count >= 0))
{
foreach (DataRow drr in tempTableCC.Rows)
{
CourseCampus cc = new CourseCampus();
cc.campusID = Convert.ToInt32(drr["CampusID"].ToString());
cc.courseID = Convert.ToInt32(drr["CourseId"].ToString());
cc.courseCampusID = Convert.ToInt32(drr["CourseCampusID"].ToString());
cc.campusName = drr["Campus"].ToString();
ccCollection.Add(cc);
}
}
lkp.courseCampus = ccCollection;
#endregion
#region Get Country
List <Country> countries = new List <Country>();
string sqlCountry = string.Concat("[dbo].[sp_getCountry]");
DataTable tempTableCountry = null;
tempTableCountry = con.executeSelectNoParameter(sqlCountry); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempTableCountry != null) || (tempTableCountry.Rows.Count >= 0))
{
foreach (DataRow drr in tempTableCountry.Rows)
{
Country country = new Country();
country.countryID = Convert.ToInt32(drr["CountryID"].ToString());
country.country = drr["Country"].ToString();
countries.Add(country);
}
}
lkp.country = countries;
#endregion
#region Get Residency
List <Residency> residencyCollection = new List <Residency>();
string sqlResidency = string.Concat("[dbo].[sp_getResidency]");
DataTable tempResidency = null;
tempResidency = con.executeSelectNoParameter(sqlResidency); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempResidency != null) || (tempResidency.Rows.Count >= 0))
{
foreach (DataRow drr in tempResidency.Rows)
{
Residency residency = new Residency();
residency.residencyId = Convert.ToInt32(drr["ResidencyId"].ToString());
residency.vrt_australiancitizenshipresidency = drr["Residency"].ToString();
residency.type = drr["Type"].ToString();
residencyCollection.Add(residency);
}
}
lkp.vrt_australiancitizenshipresidency = residencyCollection;
#endregion
#region Get Aboriginal
List <Aboriginal> aboriginalCollection = new List <Aboriginal>();
string sqlAboriginal = string.Concat("[dbo].[sp_getIndigenousAustralians]");
DataTable tempAboriginal = null;
tempAboriginal = con.executeSelectNoParameter(sqlAboriginal); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempAboriginal != null) || (tempAboriginal.Rows.Count >= 0))
{
foreach (DataRow drr in tempAboriginal.Rows)
{
Aboriginal aboriginal = new Aboriginal();
aboriginal.statusId = Convert.ToInt32(drr["StatusId"].ToString());
aboriginal.vrt_aboriginalortorresstraitislander = drr["Status"].ToString();
aboriginalCollection.Add(aboriginal);
}
}
lkp.vrt_aboriginalortorresstraitislander = aboriginalCollection;
#endregion
#region Get Qualification
List <Qualification> qualificationCollection = new List <Qualification>();
string sqlQualification = string.Concat("[dbo].[sp_getQualification]");
DataTable tempsqlQualification = null;
tempsqlQualification = con.executeSelectNoParameter(sqlQualification); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempsqlQualification != null) || (tempsqlQualification.Rows.Count >= 0))
{
foreach (DataRow drr in tempsqlQualification.Rows)
{
Qualification qualification = new Qualification();
qualification.qualificationID = Convert.ToInt32(drr["QualificationID"].ToString());
qualification.qualification = drr["Qualification"].ToString();
qualification.internalName = drr["internalName"].ToString();
qualification.selected = false;
qualification.qualificationCode = drr["qualificationCode"].ToString() ?? "";
qualificationCollection.Add(qualification);
}
}
lkp.txtQualification = qualificationCollection;
#endregion
#region Get State
List <State> stateCollection = new List <State>();
string sqlState = string.Concat("[dbo].[sp_getState]");
DataTable tempsqlState = null;
tempsqlState = con.executeSelectNoParameter(sqlState); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempsqlState != null) || (tempsqlState.Rows.Count >= 0))
{
foreach (DataRow drr in tempsqlState.Rows)
{
State state = new State();
state.stateID = Convert.ToInt32(drr["StateID"].ToString());
state.state = drr["State"].ToString();
stateCollection.Add(state);
}
}
lkp.state = stateCollection;
#endregion
#region Get IdProof
List <IdProof> idProofCollection = new List <IdProof>();
string idProofState = string.Concat("[dbo].[sp_getIdentityProof]");
DataTable tempsqlIdProof = null;
tempsqlIdProof = con.executeSelectNoParameter(idProofState); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempsqlIdProof != null) || (tempsqlIdProof.Rows.Count >= 0))
{
foreach (DataRow drr in tempsqlIdProof.Rows)
{
IdProof idProof = new IdProof();
idProof.proofId = Convert.ToInt32(drr["ProofId"].ToString());
idProof.idProofName = drr["IdentityProof"].ToString();
idProof.type = drr["Type"].ToString();
idProof.internalName = drr["InternalName"].ToString();
idProofCollection.Add(idProof);
}
}
lkp.idProof = idProofCollection;
#endregion
#region Get WhatBroughtYouHere
List <WhatBroughtYouHere> whatBroughtYouHereCollection = new List <WhatBroughtYouHere>();
string sqlwhatBroughtYouHereCollection = string.Concat("[dbo].[sp_getReasonToChooseBKI]");
DataTable tempsqlWhatBroughtYouHere = null;
tempsqlWhatBroughtYouHere = con.executeSelectNoParameter(sqlwhatBroughtYouHereCollection); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempsqlWhatBroughtYouHere != null) || (tempsqlWhatBroughtYouHere.Rows.Count >= 0))
{
foreach (DataRow drr in tempsqlWhatBroughtYouHere.Rows)
{
WhatBroughtYouHere state = new WhatBroughtYouHere();
state.reasonToChooseBKIID = Convert.ToInt32(drr["ReasonToChooseBKIID"].ToString());
state.vrt_whatbroughtyoutothekanganinstitutewebsite = drr["ReasonToChooseBKI"].ToString();
whatBroughtYouHereCollection.Add(state);
}
}
lkp.whatBroughtYouHere = whatBroughtYouHereCollection;
#endregion
}
catch (Exception e)
{
}
return(lkp);
}