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> 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_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 SYS_Organization SelectSYS_Organization_GetByCode(string Code, string Connect)
{
SYS_Organization sys_organization = new SYS_Organization();
DbDataReader reader = null;
DbConnection dbConnection = Common.CreateConnection(Connect);
dbConnection.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter("Code", Code, false));
reader = _DbHelper.ExecuteReader(dbConnection, Common.DatabaseSchema + "[SYS_Organization_GetByCode]", para.ToArray());
if (reader.HasRows && reader.Read())
{
SYS_OrganizationDataAccess.SetSYS_OrganizationInfo(reader, ref sys_organization);
}
return(sys_organization);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_Organization_GetByCode: {0}", ex.Message));
}
finally
{
if (reader != null)
{
reader.Close();
}
dbConnection.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 SYS_Organization SelectSYS_Organization(int ID)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
SYS_Organization sys_organization = new 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_GetByID]", para.ToArray());
if (reader.HasRows && reader.Read())
{
SYS_OrganizationDataAccess.SetSYS_OrganizationInfo(reader, ref sys_organization);
}
return(sys_organization);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_OrganizationDataAccess.SelectById: {0}", ex.Message));
}
finally
{
if (reader != null)
{
reader.Close();
}
conn.Close();
}
}
private static void SetListSYS_OrganizationUserInfo(ref DbDataReader reader, ref List <SYS_Organization> sys_organizations)
{
SYS_Organization sys_organization = null;
while (reader.Read())
{
sys_organization = new SYS_Organization();
SYS_OrganizationDataAccess.SetSYS_OrganizationUserInfo(reader, ref sys_organization);
sys_organizations.Add(sys_organization);
}
}
private static void SetListSYS_RegionInfoAddOrganization(ref DbDataReader reader, ref List <SYS_Region> lstRegion)
{
SYS_Region sysRegion = null;
SYS_OrganizationDataAccess sysOrganizationDataAccess = new SYS_OrganizationDataAccess();
SYS_ProvinceDataAccess sysProvinceDataAccess = new SYS_ProvinceDataAccess();
while (reader.Read())
{
sysRegion = new SYS_Region();
SYS_RegionDataAccess.SetSYS_RegionInfo(reader, ref sysRegion);
sysRegion.LstOrganization = sysOrganizationDataAccess.SelectAllSYS_RegionByIDRegion(sysRegion.ID);
sysRegion.LstProvince = sysProvinceDataAccess.SelectAllSYS_RegionByIDRegion_Province(sysRegion.ID);
lstRegion.Add(sysRegion);
}
}
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();
}
}
