public List <SYS_Organization> SYS_Organization_SelectByCodeBV(DbConnection dbTransaction)
{
List <SYS_Organization> sys_organization = new List <SYS_Organization>();
DbDataReader reader = null;
try
{
reader = _DbHelper.ExecuteReader(dbTransaction, Common.DatabaseSchema + "[SYS_Organization_SelectByCodeBV]", (DbParameter[])null);
if (reader.HasRows)
{
SYS_OrganizationDataAccess.SetListSYS_OrganizationInfo(ref reader, ref sys_organization);
}
return(sys_organization);
}
catch (Exception ex)
{
throw new Exception(String.Format(" SYS_Organization_SelectByCodeBV.SelectAll: {0}", ex.Message));
}
finally
{
if (reader != null)
{
reader.Close();
}
}
}
public List <SYS_Organization> SelectAllSYS_OrganizationByType(int Type)
{
List <SYS_Organization> sys_region = new List <SYS_Organization>();
DbDataReader reader = null;
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_TYPE, Type, false));
reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Organization_GetByType]", para.ToArray());
if (reader.HasRows)
{
SYS_OrganizationDataAccess.SetListSYS_OrganizationInfo(ref reader, ref sys_region);
}
return(sys_region);
}
catch (Exception ex)
{
throw new Exception(String.Format(" SelectAllSYS_OrganizationByType: {0}", ex.Message));
}
finally
{
if (reader != null)
{
reader.Close();
}
conn.Close();
}
}
public List <SYS_Organization> SelectAllSYS_OrganizationGetRegion()
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
List <SYS_Organization> sys_organization = new List <SYS_Organization>();
DbDataReader reader = null;
try
{
reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Organization_GetRegion]", (DbParameter[])null);
if (reader.HasRows)
{
SYS_OrganizationDataAccess.SetListSYS_OrganizationInfo(ref reader, ref sys_organization);
}
return(sys_organization);
}
catch (Exception ex)
{
throw new Exception(String.Format(" SelectAllSYS_OrganizationGetRegion: {0}", ex.Message));
}
finally
{
if (reader != null)
{
reader.Close();
}
conn.Close();
}
}
public List <SYS_Organization> SelectAll_Tinh_SYS_OrganizationByStrCn(string connection)
{
SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess();
connection = connectionDataAccess.DecryptSYS_ConfigConnection(connection);
DbConnection conn = _DbHelper.CreateConnection(connection);
conn.Open();
List <SYS_Organization> sys_organization = new List <SYS_Organization>();
DbDataReader reader = null;
try
{
reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Organization_SelectAll_Tinh]", (DbParameter[])null);
if (reader.HasRows)
{
SYS_OrganizationDataAccess.SetListSYS_OrganizationInfo(ref reader, ref sys_organization);
}
return(sys_organization);
}
catch (Exception ex)
{
throw new Exception(String.Format(" SYS_OrganizationDataAccess.SelectAll: {0}", ex.Message));
}
finally
{
if (reader != null)
{
reader.Close();
}
conn.Close();
}
}
public List <SYS_Organization> SelectByCodeType(string Code)
{
SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess();
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
List <SYS_Organization> sys_organization = new List <SYS_Organization>();
DbDataReader reader = null;
try
{
if (!string.IsNullOrEmpty(Code))
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter("Code", Code, false));
reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Organization_SelectByCodeType]", para.ToArray());
}
else
{
reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Organization_SelectByCodeType]",
(DbParameter[])null);
}
if (reader.HasRows)
{
SYS_OrganizationDataAccess.SetListSYS_OrganizationInfo(ref reader, ref sys_organization);
}
return(sys_organization);
}
catch (Exception ex)
{
throw new Exception(String.Format(" SYS_OrganizationDataAccess.SelectByCodeType: {0}", ex.Message));
}
finally
{
if (reader != null)
{
reader.Close();
}
conn.Close();
}
}
public List <SYS_Organization> SelectAllSYS_Organization_GetByUserID(int ID, string connect)
{
SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess();
connect = connectionDataAccess.DecryptSYS_ConfigConnection(connect);
DbConnection conn = _DbHelper.CreateConnection(connect);
conn.Open();
List <SYS_Organization> sys_organization = new List <SYS_Organization>();
DbDataReader reader = null;
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, ID, false));
reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Organization_GetByUserID]", para.ToArray());
if (reader.HasRows)
{
SYS_OrganizationDataAccess.SetListSYS_OrganizationInfo(ref reader, ref sys_organization);
}
return(sys_organization);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_OrganizationDataAccess.SelectByUserId: {0}", ex.Message));
}
finally
{
if (reader != null)
{
reader.Close();
}
conn.Close();
}
}
