public static SqlDataReader GetReader(int departmentID)
{
SqlParameter[] sps = new SqlParameter[1];
sps[0] = new SqlParameter("@DepartmentID", SqlDbType.Int);
sps[0].Value = departmentID;
return(SPHelper.ExecuteReader(SpNames.List, sps));
}
public static List <DocumentFile> GetList(SqlTransaction trans, int documentID)
{
List <DocumentFile> list = new List <DocumentFile>();
SqlParameter[] sps = new SqlParameter[1];
sps[0] = new SqlParameter("@DocumentID", SqlDbType.Int);
sps[0].Value = documentID;
if (trans == null)
{
using (SqlDataReader dataReader = SPHelper.ExecuteReader(SpNames.List, sps))
{
DocumentFile df;
while (dataReader.Read())
{
df = new DocumentFile();
df.DocumentID = (int)dataReader["DocumentID"];
df.DepartmentID = (int)dataReader["DepartmentID"];
df.WorkerID = (int)dataReader["WorkerID"];
df.FileID = (int)dataReader["FileID"];
df.FileName = Convert.ToString(dataReader["FileName"]) + "." +
Convert.ToString(dataReader["Extension"]);
df.Extension = Convert.ToString(dataReader["Extension"]);
list.Add(df);
}
}
}
else
{
using (SqlDataReader dataReader = SPHelper.ExecuteReader(trans, SpNames.List, sps))
{
DocumentFile df;
while (dataReader.Read())
{
df = new DocumentFile();
df.DocumentID = (int)dataReader["DocumentID"];
df.DepartmentID = (int)dataReader["DepartmentID"];
df.WorkerID = (int)dataReader["WorkerID"];
df.FileID = (int)dataReader["FileID"];
df.FileName = Convert.ToString(dataReader["FileName"]) + "." +
Convert.ToString(dataReader["Extension"]);
df.Extension = Convert.ToString(dataReader["Extension"]);
list.Add(df);
}
}
}
return(list);
}
public static SqlDataReader GetReader(SqlTransaction trans, Post postFilter)
{
SqlParameter[] p = new SqlParameter[2];
p[0] = new SqlParameter("@DepartmentID", SqlDbType.Int);
p[0].Value = postFilter.DepartmentID;
p[1] = new SqlParameter("@Name", SqlDbType.NVarChar, 256);
p[1].Value = postFilter.Name;
if (trans == null)
{
return(SPHelper.ExecuteReader(StoredProcedures.GetList, p));
}
return(SPHelper.ExecuteReader(trans, StoredProcedures.GetList, p));
}
public static SqlDataReader GetReader(SqlConnection conectionString)
{
return(SPHelper.ExecuteReader(conectionString, SpNames.List));
}
public static SqlDataReader GetReader()
{
return(SPHelper.ExecuteReader(SpNames.List));
}
public static SqlDataReader GetReader(SqlConnection conectionString, int departmentId)
{
return SPHelper.ExecuteReader(conectionString, SpNames.List, departmentId);
}
