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); }