private async Task CompanyGetAll_OnImplementation(CompanyCollection coll)
{
coll.Add(new Company {
Id = Guid.NewGuid(), Code = "XYZ", Text = "XYZ", IsActive = true, SortOrder = 1, ExternalCode = "usmf"
});
await Task.Delay(0);
}
private async Task InitiateAsync()
{
IsMainViewerInitiating = true;
await PowerCompany.LoadFromApplicationUriAsync();
foreach (var company in Enumerable.Range(0, PowerCompany.Companies.Count).Select(index => new PowerCompanyViewModel(index)))
{
CompanyCollection.Add(company);
}
await Site.LoadFromApplicationUriAsync();
CheckAreaCoordinates(Site.Sites, MainViewerSize);
RaisePropertyChanged(nameof(MainViewerZoomFactor));
RaisePropertyChanged(nameof(MainCanvasCenterPosition));
foreach (var site in Site.Sites.Select((x, index) => new SiteViewModel(index)
{
Location = ConvertPositionFromReal(x.Longitude, x.Latitude)
}))
{
SiteCollection.Add(site);
}
// Wait for all site members being loaded. Otherwise, subsequent restoring position
// may not work correctly.
while (SiteCollection.Any(x => !x.IsLoaded))
{
await Task.Delay(TimeSpan.FromMilliseconds(50));
}
IsMainViewerInitiating = false;
}
public static CompanyCollection Search(SearchFilter SearchKey)
{
CompanyCollection collection = new CompanyCollection();
using (var reader = SqlHelper.ExecuteReader("Company_Search", SearchFilterManager.SqlSearchParam(SearchKey)))
{
while (reader.Read())
{
Company obj = new Company();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static CompanyCollection GetAllItem()
{
CompanyCollection collection = new CompanyCollection();
using (var reader = SqlHelper.ExecuteReader("Company_GetAll", null))
{
while (reader.Read())
{
Company obj = new Company();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static CompanyCollection GetCompanies(string MembershipUserid)
{
CompanyCollection c = new CompanyCollection();
DataTable dt = Execute.FillDataTable(StoredProcedures.GetCompaniesByMembershipUserid, new System.Data.SqlClient.SqlParameter("MembershipUserid", MembershipUserid));
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
Company o = new Company();
LoadCompanyByReader(row, o);
c.Add(o);
}
}
return(c);
}
public static CompanyCollection GetCompanies()
{
CompanyCollection c = new CompanyCollection();
DataTable dt = Execute.FillDataTable(StoredProcedures.GetCompanies);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
Company o = new Company();
LoadCompanyByReader(row, o);
c.Add(o);
}
}
return(c);
}
public static CompanyCollection GetbyUser(string CreatedUser)
{
CompanyCollection collection = new CompanyCollection();
Company obj;
var sqlParams = new SqlParameter[]
{
new SqlParameter("@CreatedUser", CreatedUser),
};
using (var reader = SqlHelper.ExecuteReader("Company_GetAll_byUser", sqlParams))
{
while (reader.Read())
{
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public CompanyCollection GetCompanies()
{
CompanyCollection companies = null;
//Execute Query
using (MySqlDataReader rdr = MySqlHelper.ExecuteReader(MySqlHelper.SV_CONN_STRING, SQL_SELECT_COMPANIES))
{
if (rdr.Read())
{
//If there is one result
companies = new CompanyCollection();
//Scroll through the results
do
{
companies.Add(ConvertReaderToCompanyObject(rdr));
}while (rdr.Read());
}
}
return(companies);
}
public CompanyCollection GetCompanies()
{
CompanyCollection companies = null;
//Execute Query
using (MySqlDataReader rdr = MySqlHelper.ExecuteReader(MySqlHelper.SV_CONN_STRING, SQL_SELECT_COMPANIES))
{
if (rdr.Read())
{
//If there is one result
companies = new CompanyCollection();
//Scroll through the results
do
{
companies.Add(ConvertReaderToCompanyObject(rdr));
}
while (rdr.Read());
}
}
return companies;
}