public IEnumerable <InactiveSubject> ListInActiveSubject(string siteId)
{
using (var con = new OracleConnection(OracleUtility.conString))
{
con.Open();
var cmd = con.CreateCommand();
cmd.CommandText = $"SELECT * FROM {OracleDbTableName.InactiveSubject} WHERE SiteId=:SiteId";
cmd.Parameters.Add("SiteId", siteId);
cmd.CommandType = CommandType.Text;
var da = new OracleDataAdapter();
da.SelectCommand = cmd;
var ds = new DataSet();
da.Fill(ds);
var dt = ds.Tables[0];
var subjects = Enumerable.Empty <InactiveSubject>().ToList();
for (int i = 0; i < dt.Rows.Count; i++)
{
subjects.Add(OracleUtility.GetInactiveSubject(dt.Rows[i]));
}
return(subjects);
}
}
public InactiveSubject GetInActiveSubject(string subjectId)
{
using (var con = new OracleConnection(OracleUtility.conString))
{
con.Open();
var cmd = con.CreateCommand();
cmd.CommandText = $"SELECT * FROM {OracleDbTableName.InactiveSubject} WHERE Id=:Id";
cmd.Parameters.Add("Id", subjectId);
cmd.CommandType = CommandType.Text;
var da = new OracleDataAdapter();
da.SelectCommand = cmd;
var ds = new DataSet();
da.Fill(ds);
var dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
return(OracleUtility.GetInactiveSubject(dt.Rows[0]));
}
return(null);
}
}