public IList<Core.Business.INSTRAPPLICATION> GetAllINSTRAPPLICATION()
{
IList<Core.Business.INSTRAPPLICATION> iNSTRAPPLICATIONlist = new List<Core.Business.INSTRAPPLICATION>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectINSTRAPPLICATIONsAll");
if (reader != null)
{
while (reader.Read())
{
Core.Business.INSTRAPPLICATION iNSTRAPPLICATION = new Core.Business.INSTRAPPLICATION();
if (!reader.IsDBNull(0)) iNSTRAPPLICATION.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) iNSTRAPPLICATION.InstruId = reader.GetGuid(1);
if (!reader.IsDBNull(2)) iNSTRAPPLICATION.YEAR = reader.GetDateTime(2);
if (!reader.IsDBNull(3)) iNSTRAPPLICATION.FRUIT = reader.GetString(3);
if (!reader.IsDBNull(4)) iNSTRAPPLICATION.INFLUENTIALNUM = reader.GetInt32(4);
if (!reader.IsDBNull(5)) iNSTRAPPLICATION.FAMOUSUSERS = reader.GetString(5);
if (!reader.IsDBNull(6)) iNSTRAPPLICATION.TRAIT = reader.GetString(6);
if (!reader.IsDBNull(7)) iNSTRAPPLICATION.REMARK = reader.GetString(7);
if (!reader.IsDBNull(8)) iNSTRAPPLICATION.WRITEDATE = reader.GetDateTime(8);
if (!reader.IsDBNull(9)) iNSTRAPPLICATION.UPDATEDATE = reader.GetDateTime(9);
iNSTRAPPLICATION.MarkOld();
iNSTRAPPLICATIONlist.Add(iNSTRAPPLICATION);
}
reader.Close();
}
return iNSTRAPPLICATIONlist;
}
public IList<CY.CSTS.Core.Business.INSTRAPPLICATION> GetINSTRAPPLICATIONDynamic(string whereCondition, string orderByExpression)
{
if (string.IsNullOrEmpty(whereCondition))
{
return this.GetAllINSTRAPPLICATION();
}
IList<Core.Business.INSTRAPPLICATION> iNSTRAPPLICATIONlist = new List<Core.Business.INSTRAPPLICATION>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@WhereCondition", SqlDbType.NVarChar, whereCondition);
sql.AddParameter("@OrderByExpression", SqlDbType.NVarChar, orderByExpression);
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectINSTRAPPLICATIONsDynamic");
if (reader != null)
{
while (reader.Read())
{
Core.Business.INSTRAPPLICATION iNSTRAPPLICATION = new Core.Business.INSTRAPPLICATION();
if (!reader.IsDBNull(0)) iNSTRAPPLICATION.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) iNSTRAPPLICATION.InstruId = reader.GetGuid(1);
if (!reader.IsDBNull(2)) iNSTRAPPLICATION.YEAR = reader.GetDateTime(2);
if (!reader.IsDBNull(3)) iNSTRAPPLICATION.FRUIT = reader.GetString(3);
if (!reader.IsDBNull(4)) iNSTRAPPLICATION.INFLUENTIALNUM = reader.GetInt32(4);
if (!reader.IsDBNull(5)) iNSTRAPPLICATION.FAMOUSUSERS = reader.GetString(5);
if (!reader.IsDBNull(6)) iNSTRAPPLICATION.TRAIT = reader.GetString(6);
if (!reader.IsDBNull(7)) iNSTRAPPLICATION.REMARK = reader.GetString(7);
if (!reader.IsDBNull(8)) iNSTRAPPLICATION.WRITEDATE = reader.GetDateTime(8);
if (!reader.IsDBNull(9)) iNSTRAPPLICATION.UPDATEDATE = reader.GetDateTime(9);
iNSTRAPPLICATION.MarkOld();
iNSTRAPPLICATIONlist.Add(iNSTRAPPLICATION);
}
reader.Close();
}
return iNSTRAPPLICATIONlist;
}
public Core.Business.INSTRAPPLICATION Select(Guid id)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, id);
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectINSTRAPPLICATION");
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.INSTRAPPLICATION iNSTRAPPLICATION = new Core.Business.INSTRAPPLICATION();
if (!reader.IsDBNull(0)) iNSTRAPPLICATION.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) iNSTRAPPLICATION.InstruId = reader.GetGuid(1);
if (!reader.IsDBNull(2)) iNSTRAPPLICATION.YEAR = reader.GetDateTime(2);
if (!reader.IsDBNull(3)) iNSTRAPPLICATION.FRUIT = reader.GetString(3);
if (!reader.IsDBNull(4)) iNSTRAPPLICATION.INFLUENTIALNUM = reader.GetInt32(4);
if (!reader.IsDBNull(5)) iNSTRAPPLICATION.FAMOUSUSERS = reader.GetString(5);
if (!reader.IsDBNull(6)) iNSTRAPPLICATION.TRAIT = reader.GetString(6);
if (!reader.IsDBNull(7)) iNSTRAPPLICATION.REMARK = reader.GetString(7);
if (!reader.IsDBNull(8)) iNSTRAPPLICATION.WRITEDATE = reader.GetDateTime(8);
if (!reader.IsDBNull(9)) iNSTRAPPLICATION.UPDATEDATE = reader.GetDateTime(9);
reader.Close();
return iNSTRAPPLICATION;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public IEnumerable<INSTRAPPLICATION> GetInstrumentApplication(Guid id)
{
IList<Core.Business.INSTRAPPLICATION> iNSTRAPPLICATIONlist = new List<Core.Business.INSTRAPPLICATION>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@id", SqlDbType.UniqueIdentifier, id);
SqlDataReader reader = sql.ExecuteSqlReader(Sql_SelectInstrumentApplications);
if (reader != null)
{
while (reader.Read())
{
Core.Business.INSTRAPPLICATION iNSTRAPPLICATION = new Core.Business.INSTRAPPLICATION();
if (!reader.IsDBNull(0)) iNSTRAPPLICATION.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) iNSTRAPPLICATION.InstruId = reader.GetGuid(1);
if (!reader.IsDBNull(2)) iNSTRAPPLICATION.YEAR = reader.GetDateTime(2);
if (!reader.IsDBNull(3)) iNSTRAPPLICATION.FRUIT = reader.GetString(3);
if (!reader.IsDBNull(4)) iNSTRAPPLICATION.INFLUENTIALNUM = reader.GetInt32(4);
if (!reader.IsDBNull(5)) iNSTRAPPLICATION.FAMOUSUSERS = reader.GetString(5);
if (!reader.IsDBNull(6)) iNSTRAPPLICATION.TRAIT = reader.GetString(6);
if (!reader.IsDBNull(7)) iNSTRAPPLICATION.REMARK = reader.GetString(7);
if (!reader.IsDBNull(8)) iNSTRAPPLICATION.WRITEDATE = reader.GetDateTime(8);
if (!reader.IsDBNull(9)) iNSTRAPPLICATION.UPDATEDATE = reader.GetDateTime(9);
iNSTRAPPLICATION.MarkOld();
iNSTRAPPLICATIONlist.Add(iNSTRAPPLICATION);
}
reader.Close();
}
return iNSTRAPPLICATIONlist;
}
