public IList<Core.Business.StdCredentials> GetAllStdCredentials()
{
IList<Core.Business.StdCredentials> stdCredentialslist = new List<Core.Business.StdCredentials>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllStdCredentials);
if (reader != null)
{
while (reader.Read())
{
Core.Business.StdCredentials stdCredentials = new Core.Business.StdCredentials();
if (!reader.IsDBNull(0)) stdCredentials.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) stdCredentials.InitialDate = reader.GetDateTime(1);
if (!reader.IsDBNull(2)) stdCredentials.CertDate = reader.GetDateTime(2);
if (!reader.IsDBNull(3)) stdCredentials.FirstCheckDate = reader.GetDateTime(3);
if (!reader.IsDBNull(4)) stdCredentials.SecondCheckDate = reader.GetDateTime(4);
if (!reader.IsDBNull(5)) stdCredentials.StartDate = reader.GetDateTime(5);
if (!reader.IsDBNull(6)) stdCredentials.StopDate = reader.GetDateTime(6);
if (!reader.IsDBNull(7)) stdCredentials.IsContinue = reader.GetBoolean(7);
if (!reader.IsDBNull(8)) stdCredentials.PraticeScore = reader.GetDecimal(8);
if (!reader.IsDBNull(9)) stdCredentials.StdCode = reader.GetString(9);
if (!reader.IsDBNull(10)) stdCredentials.ProjectCode = reader.GetString(10);
if (!reader.IsDBNull(11)) stdCredentials.CredentialCode = reader.GetString(11);
if (!reader.IsDBNull(12)) stdCredentials.CredentialCate = reader.GetString(12);
if (!reader.IsDBNull(13)) stdCredentials.CredentialIdentity = reader.GetString(13);
if (!reader.IsDBNull(14)) stdCredentials.PracticeProject = reader.GetString(14);
if (!reader.IsDBNull(15)) stdCredentials.CertUnit = reader.GetString(15);
if (!reader.IsDBNull(16)) stdCredentials.TheoryScore = reader.GetString(16);
if (!reader.IsDBNull(17)) stdCredentials.Remark3 = reader.GetString(17);
if (!reader.IsDBNull(18)) stdCredentials.Remark4 = reader.GetString(18);
if (!reader.IsDBNull(19)) stdCredentials.TrainUnit = reader.GetString(19);
if (!reader.IsDBNull(20)) stdCredentials.CheckRcd1 = reader.GetString(20);
if (!reader.IsDBNull(21)) stdCredentials.CheckRcd2 = reader.GetString(21);
if (!reader.IsDBNull(22)) stdCredentials.IsChecked = reader.GetString(22);
if (!reader.IsDBNull(23)) stdCredentials.FirstCheckTrain = reader.GetString(23);
if (!reader.IsDBNull(24)) stdCredentials.SecondCheckTrain = reader.GetString(24);
stdCredentials.MarkOld();
stdCredentialslist.Add(stdCredentials);
}
reader.Close();
}
return stdCredentialslist;
}
public Core.Business.StdCredentials Select(int id)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Id", SqlDbType.Int, id);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectStdCredentials);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.StdCredentials stdCredentials = new Core.Business.StdCredentials();
if (!reader.IsDBNull(0)) stdCredentials.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) stdCredentials.InitialDate = reader.GetDateTime(1);
if (!reader.IsDBNull(2)) stdCredentials.CertDate = reader.GetDateTime(2);
if (!reader.IsDBNull(3)) stdCredentials.FirstCheckDate = reader.GetDateTime(3);
if (!reader.IsDBNull(4)) stdCredentials.SecondCheckDate = reader.GetDateTime(4);
if (!reader.IsDBNull(5)) stdCredentials.StartDate = reader.GetDateTime(5);
if (!reader.IsDBNull(6)) stdCredentials.StopDate = reader.GetDateTime(6);
if (!reader.IsDBNull(7)) stdCredentials.IsContinue = reader.GetBoolean(7);
if (!reader.IsDBNull(8)) stdCredentials.PraticeScore = reader.GetDecimal(8);
if (!reader.IsDBNull(9)) stdCredentials.StdCode = reader.GetString(9);
if (!reader.IsDBNull(10)) stdCredentials.ProjectCode = reader.GetString(10);
if (!reader.IsDBNull(11)) stdCredentials.CredentialCode = reader.GetString(11);
if (!reader.IsDBNull(12)) stdCredentials.CredentialCate = reader.GetString(12);
if (!reader.IsDBNull(13)) stdCredentials.CredentialIdentity = reader.GetString(13);
if (!reader.IsDBNull(14)) stdCredentials.PracticeProject = reader.GetString(14);
if (!reader.IsDBNull(15)) stdCredentials.CertUnit = reader.GetString(15);
if (!reader.IsDBNull(16)) stdCredentials.TheoryScore = reader.GetString(16);
if (!reader.IsDBNull(17)) stdCredentials.Remark3 = reader.GetString(17);
if (!reader.IsDBNull(18)) stdCredentials.Remark4 = reader.GetString(18);
if (!reader.IsDBNull(19)) stdCredentials.TrainUnit = reader.GetString(19);
if (!reader.IsDBNull(20)) stdCredentials.CheckRcd1 = reader.GetString(20);
if (!reader.IsDBNull(21)) stdCredentials.CheckRcd2 = reader.GetString(21);
if (!reader.IsDBNull(22)) stdCredentials.IsChecked = reader.GetString(22);
if (!reader.IsDBNull(23)) stdCredentials.FirstCheckTrain = reader.GetString(23);
if (!reader.IsDBNull(24)) stdCredentials.SecondCheckTrain = reader.GetString(24);
reader.Close();
return stdCredentials;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}