/// <summary>
/// Lay danh sach ung dung
/// </summary>
/// <returns></returns>
public ApplicationCollection GetAllApplications()
{
try
{
ApplicationCollection appCollection = new ApplicationCollection();
appCollection.Clear();
using (IDataReader dr = Database.ExecuteReader("UspGetAllApplications", CommandType.StoredProcedure))
{
while (dr.Read())
{
Application app = Populate(dr);
appCollection.Add(app);
}
}
return(appCollection);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
///
/// </summary>
/// <param name="strUserName"></param>
/// <returns></returns>
public ApplicationCollection GetApplicationByUser(string strUserName)
{
try
{
ApplicationCollection appCollection = new ApplicationCollection();
appCollection.Clear();
// create sql parameters
SqlParameter prmUsername = new SqlParameter("@Username", SqlDbType.VarChar, 128);
prmUsername.Direction = ParameterDirection.Input;
prmUsername.Value = strUserName;
using (IDataReader dr = Database.ExecuteReader("UspGetApplicationByUser", CommandType.StoredProcedure, prmUsername))
{
while (dr.Read())
{
Application app = Populate(dr);
appCollection.Add(app);
}
}
return(appCollection);
}
catch (Exception ex)
{ throw ex; }
}
/*
*
* Collection fill callbacks and event handlers.
*
*/
public void FillApplicationCollection(ApplicationOrganizationItem[] applicationArray)
{
ApplicationCollection.Clear();
foreach (ApplicationOrganizationItem item in applicationArray)
{
ApplicationCollection.Add(new ApplicationOrganizationVMItem(item));
}
SelectedApplication = ApplicationCollection.Count() > 0 ? ApplicationCollection[0] : null;
}