public RefTransferHeader GetTransferHeader(int transferid)
{
bool result = false;
string sql = "sp_TransfetHeader_GetById";
RefTransferHeader header = null;
SqlCommand sqlCommand = null;
List <SqlParameter> paramList = new List <SqlParameter>();
SqlConnection conn = null;
SqlDataReader reader = null;
try
{
paramList = new List <SqlParameter>();
paramList.Add(new SqlParameter("@TransferId", transferid));
webdb.OpenConnection();
conn = webdb.Connection;
sqlCommand = new SqlCommand();
sqlCommand.CommandText = sql;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Connection = conn;
sqlCommand.Parameters.AddRange(paramList.ToArray());
reader = sqlCommand.ExecuteReader();
// if (reader.Read())
// {
header = Converting.ConvertDataReaderToObjList <RefTransferHeader>(reader).FirstOrDefault();
if (header != null)
{
reader.NextResult();
header.TransferDetail = Converting.ConvertDataReaderToObjList <TransferDetail>(reader);
reader.NextResult();
header.TransferRefHeader = Converting.ConvertDataReaderToObjList <TransferRefHeader>(reader);
}
// }
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
webdb.CloseConnection();
}
return(header);
}
public IList <T> FindByColumn <T>(string procName, List <SqlParameter> param)
{
string sql = procName;
List <SqlParameter> paramList = new List <SqlParameter>();
List <T> list = new List <T>();
SqlDataReader reader = null;
try
{
OpenConnection();
sqlCommand = new SqlCommand();
sqlCommand.CommandText = sql;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Connection = this.Connection;
sqlCommand.Parameters.AddRange(param.ToArray());
reader = sqlCommand.ExecuteReader();
// if (reader.Read())
// {
list = Converting.ConvertDataReaderToObjList <T>(reader);
// }
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally {
CloseConnection();
}
return(list);
}
