public static List <ATTOrganizationUnit> SrchOrganizationUnitHead(int?orgid, string searchValue)
{
List <ATTOrganizationUnit> lstOrgUnitHead = new List <ATTOrganizationUnit>();
try
{
foreach (DataRow row in DLLOrganizationUnit.SrchOrganizationUnitHead(orgid, searchValue).Rows)
{
ATTOrganizationUnit objOrgUnitHead = new ATTOrganizationUnit();
objOrgUnitHead.OrgID = int.Parse(row["ORG_ID"].ToString());
if (row["ORG_UNIT_ID"] != System.DBNull.Value)
{
objOrgUnitHead.UnitID = int.Parse(row["ORG_UNIT_ID"].ToString());
}
objOrgUnitHead.UnitName = (string)row["UNIT_NAME"];
if (row["EMP_ID"] != System.DBNull.Value)
{
objOrgUnitHead.EmpID = int.Parse(row["EMP_ID"].ToString());
}
objOrgUnitHead.EmpName = row["HEAD_P_NAME"].ToString();
lstOrgUnitHead.Add(objOrgUnitHead);
}
return(lstOrgUnitHead);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ATTOrganizationUnit> GetOrganizationUnits(int?orgID, int?unitID)
{
List <ATTOrganizationUnit> lstOrgUnits = new List <ATTOrganizationUnit>();
try
{
foreach (DataRow row in DLLOrganizationUnit.GetOrganizationUnits(orgID, unitID).Rows)
{
ATTOrganizationUnit objOrgUnits = new ATTOrganizationUnit(
int.Parse(row["ORG_ID"].ToString()),
int.Parse(row["UNIT_ID"].ToString()),
(string)row["UNIT_NAME"]);
if (row["PARENT_ORG_ID"] != System.DBNull.Value)
{
objOrgUnits.ParentOrgID = int.Parse(row["PARENT_ORG_ID"].ToString());
}
if (row["PARENT_UNIT_ID"] != System.DBNull.Value)
{
objOrgUnits.ParentUnitID = int.Parse(row["PARENT_UNIT_ID"].ToString());
}
objOrgUnits.UnitType = (row["UNIT_TYPE"] == System.DBNull.Value) ? "" : (string)row["UNIT_TYPE"];
lstOrgUnits.Add(objOrgUnits);
}
return(lstOrgUnits);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SaveOrganizationUnit(List <ATTOrganizationUnit> ListOrgUnit)
{
try
{
DLLOrganizationUnit.SaveOrganizationUnit(ListOrgUnit);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ATTOrganizationUnit> GetOrganizationUnits(string unitType, int orgID)
{
List <ATTOrganizationUnit> lstOrgUnits = new List <ATTOrganizationUnit>();
try
{
DataTable tbl = new DataTable();
tbl = DLLOrganizationUnit.GetOrganizationUnits(unitType, orgID);
foreach (DataRow row in tbl.Rows)
{
ATTOrganizationUnit objOrgUnits = new ATTOrganizationUnit(
int.Parse(row["ORG_ID"].ToString()),
int.Parse(row["UNIT_ID"].ToString()),
(string)row["UNIT_NAME"]
);
//ORG_ID,UNIT_ID,UNIT_NAME,PARENT_ORG_ID,PARENT_UNIT_ID,UNIT_TYPE
if (row["PARENT_ORG_ID"] != System.DBNull.Value)
{
objOrgUnits.ParentOrgID = int.Parse(row["PARENT_ORG_ID"].ToString());
}
if (row["PARENT_UNIT_ID"] != System.DBNull.Value)
{
objOrgUnits.ParentUnitID = int.Parse(row["PARENT_UNIT_ID"].ToString());
}
objOrgUnits.UnitType = row["UNIT_TYPE"].ToString();
lstOrgUnits.Add(objOrgUnits);
}
return(lstOrgUnits);
}
catch (Exception ex)
{
throw (ex);
}
}
public static List <ATTOrganizationUnit> GetOrgUnitWithChild(int?orgid, int?unitid)
{
List <ATTOrganizationUnit> lstOrgUnit = new List <ATTOrganizationUnit>();
try
{
foreach (DataRow row in DLLOrganizationUnit.GetOrgUnitWithChild(orgid, unitid).Rows)
{
ATTOrganizationUnit objOrgUnit = new ATTOrganizationUnit();
objOrgUnit.OrgID = int.Parse(row["ORG_ID"].ToString());
if (row["PARENT_ORG_ID"] != System.DBNull.Value)
{
objOrgUnit.ParentOrgID = int.Parse(row["PARENT_ORG_ID"].ToString());
}
if (row["UNIT_ID"] != System.DBNull.Value)
{
objOrgUnit.UnitID = int.Parse(row["UNIT_ID"].ToString());
}
objOrgUnit.UnitName = (string)row["UNIT_NAME"];
if (row["UNIT_TYPE"] != System.DBNull.Value)
{
objOrgUnit.UnitType = (string)row["UNIT_TYPE"];
}
if (row["PARENT_UNIT_ID"] != System.DBNull.Value)
{
objOrgUnit.ParentUnitID = int.Parse(row["PARENT_UNIT_ID"].ToString());
}
lstOrgUnit.Add(objOrgUnit);
}
return(lstOrgUnit);
}
catch (Exception ex)
{
throw ex;
}
}
