public IList<Core.Business.CommissionedApplication> GetAllCommissionedApplication()
{
IList<Core.Business.CommissionedApplication> commissionedApplicationlist = new List<Core.Business.CommissionedApplication>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectCommissionedApplicationsAll");
if (reader != null)
{
while (reader.Read())
{
Core.Business.CommissionedApplication commissionedApplication = new Core.Business.CommissionedApplication();
if (!reader.IsDBNull(0)) commissionedApplication.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) commissionedApplication.CommissionedUint = reader.GetString(1);
if (!reader.IsDBNull(2)) commissionedApplication.AdmissibilityID = reader.GetGuid(2);
if (!reader.IsDBNull(3)) commissionedApplication.InstrumentID = reader.GetGuid(3);
if (!reader.IsDBNull(4)) commissionedApplication.Address = reader.GetString(4);
if (!reader.IsDBNull(5)) commissionedApplication.Zip = reader.GetString(5);
if (!reader.IsDBNull(6)) commissionedApplication.CommissionedPerson = reader.GetGuid(6);
if (!reader.IsDBNull(7)) commissionedApplication.Phone = reader.GetString(7);
if (!reader.IsDBNull(8)) commissionedApplication.ProjectName = reader.GetString(8);
if (!reader.IsDBNull(9)) commissionedApplication.Fax = reader.GetString(9);
if (!reader.IsDBNull(10)) commissionedApplication.ProjectContractNo = reader.GetString(10);
if (!reader.IsDBNull(11)) commissionedApplication.ProjectLeader = reader.GetString(11);
if (!reader.IsDBNull(12)) commissionedApplication.ProjectType = reader.GetGuid(12);
if (!reader.IsDBNull(13)) commissionedApplication.ContenAndRequirements = reader.GetString(13);
if (!reader.IsDBNull(14)) commissionedApplication.Status = reader.GetInt32(14);
if (!reader.IsDBNull(15)) commissionedApplication.AdmissibilityDes = reader.GetString(15);
if (!reader.IsDBNull(16)) commissionedApplication.Feedback = reader.GetInt32(16);
if (!reader.IsDBNull(17)) commissionedApplication.Advice = reader.GetString(17);
if (!reader.IsDBNull(18)) commissionedApplication.AdviceFillTime = reader.GetDateTime(18);
if (!reader.IsDBNull(19)) commissionedApplication.ApplicateTime = reader.GetDateTime(19);
commissionedApplication.MarkOld();
commissionedApplicationlist.Add(commissionedApplication);
}
reader.Close();
}
return commissionedApplicationlist;
}
public IEnumerable<CommissionedApplication> GetCommissionApplications(Guid instrumentId)
{
try
{
IList<Core.Business.CommissionedApplication> commissionedApplicationlist = new List<Core.Business.CommissionedApplication>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@instrument", SqlDbType.UniqueIdentifier, instrumentId);
SqlDataReader reader = sql.ExecuteSqlReader(Sql_GetCommissionApplications);
if (reader != null)
{
while (reader.Read())
{
Core.Business.CommissionedApplication commissionedApplication = new Core.Business.CommissionedApplication();
if (!reader.IsDBNull(0)) commissionedApplication.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) commissionedApplication.CommissionedUint = reader.GetString(1);
if (!reader.IsDBNull(2)) commissionedApplication.AdmissibilityID = reader.GetGuid(2);
if (!reader.IsDBNull(3)) commissionedApplication.InstrumentID = reader.GetGuid(3);
if (!reader.IsDBNull(4)) commissionedApplication.Address = reader.GetString(4);
if (!reader.IsDBNull(5)) commissionedApplication.Zip = reader.GetString(5);
if (!reader.IsDBNull(6)) commissionedApplication.CommissionedPerson = reader.GetGuid(6);
if (!reader.IsDBNull(7)) commissionedApplication.Phone = reader.GetString(7);
if (!reader.IsDBNull(8)) commissionedApplication.ProjectName = reader.GetString(8);
if (!reader.IsDBNull(9)) commissionedApplication.Fax = reader.GetString(9);
if (!reader.IsDBNull(10)) commissionedApplication.ProjectContractNo = reader.GetString(10);
if (!reader.IsDBNull(11)) commissionedApplication.ProjectLeader = reader.GetString(11);
if (!reader.IsDBNull(12)) commissionedApplication.ProjectType = reader.GetGuid(12);
if (!reader.IsDBNull(13)) commissionedApplication.ContenAndRequirements = reader.GetString(13);
if (!reader.IsDBNull(14)) commissionedApplication.Status = reader.GetInt32(14);
if (!reader.IsDBNull(15)) commissionedApplication.AdmissibilityDes = reader.GetString(15);
if (!reader.IsDBNull(16)) commissionedApplication.Feedback = reader.GetInt32(16);
if (!reader.IsDBNull(17)) commissionedApplication.Advice = reader.GetString(17);
if (!reader.IsDBNull(18)) commissionedApplication.AdviceFillTime = reader.GetDateTime(18);
if (!reader.IsDBNull(19)) commissionedApplication.ApplicateTime = reader.GetDateTime(19);
commissionedApplication.MarkOld();
commissionedApplicationlist.Add(commissionedApplication);
}
reader.Close();
}
return commissionedApplicationlist;
}
catch (Exception ex)
{
throw ex;
}
}
public IList<Core.Business.CommissionedApplication> GetAllCommissionedGroup()
{
IList<Core.Business.CommissionedApplication> commissionedApplicationlist = new List<Core.Business.CommissionedApplication>();
SqlServerUtility sql = new SqlServerUtility();
string sqlwhere = "SELECT TOP 5 COUNT([InstrumentID]) AS A,[InstrumentID] FROM [dbo].[CommissionedApplication] GROUP BY [InstrumentID] ORDER BY A DESC";
SqlDataReader reader = sql.ExecuteSqlReader(sqlwhere);
if (reader != null)
{
while (reader.Read())
{
Core.Business.CommissionedApplication commissionedApplication = new Core.Business.CommissionedApplication();
if (!reader.IsDBNull(0)) commissionedApplication.InstrumentID = reader.GetGuid(1);
if (!reader.IsDBNull(1)) commissionedApplication.Status = reader.GetInt32(0);
commissionedApplication.MarkOld();
commissionedApplicationlist.Add(commissionedApplication);
}
reader.Close();
}
return commissionedApplicationlist;
}
public Core.Business.CommissionedApplication Select(Guid id)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, id);
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectCommissionedApplication");
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.CommissionedApplication commissionedApplication = new Core.Business.CommissionedApplication();
if (!reader.IsDBNull(0)) commissionedApplication.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) commissionedApplication.CommissionedUint = reader.GetString(1);
if (!reader.IsDBNull(2)) commissionedApplication.AdmissibilityID = reader.GetGuid(2);
if (!reader.IsDBNull(3)) commissionedApplication.InstrumentID = reader.GetGuid(3);
if (!reader.IsDBNull(4)) commissionedApplication.Address = reader.GetString(4);
if (!reader.IsDBNull(5)) commissionedApplication.Zip = reader.GetString(5);
if (!reader.IsDBNull(6)) commissionedApplication.CommissionedPerson = reader.GetGuid(6);
if (!reader.IsDBNull(7)) commissionedApplication.Phone = reader.GetString(7);
if (!reader.IsDBNull(8)) commissionedApplication.ProjectName = reader.GetString(8);
if (!reader.IsDBNull(9)) commissionedApplication.Fax = reader.GetString(9);
if (!reader.IsDBNull(10)) commissionedApplication.ProjectContractNo = reader.GetString(10);
if (!reader.IsDBNull(11)) commissionedApplication.ProjectLeader = reader.GetString(11);
if (!reader.IsDBNull(12)) commissionedApplication.ProjectType = reader.GetGuid(12);
if (!reader.IsDBNull(13)) commissionedApplication.ContenAndRequirements = reader.GetString(13);
if (!reader.IsDBNull(14)) commissionedApplication.Status = reader.GetInt32(14);
if (!reader.IsDBNull(15)) commissionedApplication.AdmissibilityDes = reader.GetString(15);
if (!reader.IsDBNull(16)) commissionedApplication.Feedback = reader.GetInt32(16);
if (!reader.IsDBNull(17)) commissionedApplication.Advice = reader.GetString(17);
if (!reader.IsDBNull(18)) commissionedApplication.AdviceFillTime = reader.GetDateTime(18);
if (!reader.IsDBNull(19)) commissionedApplication.ApplicateTime = reader.GetDateTime(19);
reader.Close();
return commissionedApplication;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
