public List <SamasDepartment> GetsamasDepartments(CommonLibrary.Database database)
{
var parameters = new OracleParameter[]
{
new OracleParameter()
{
ParameterName = "phart_dept_key", Direction = ParameterDirection.Input, Value = KEY_GLOBAL_DEPT
},
new OracleParameter("presults", OracleDbType.RefCursor)
{
Direction = ParameterDirection.Output
}
};
var samsdata = database.GetDataFromProcedure("dept_assignment.get_samas_assigned_depts", parameters);
List <SamasDepartment> SamasList = new List <SamasDepartment>();
foreach (DataRow pRow in samsdata.Tables[0].Rows)
{
var samaslist = new SamasDepartment();
samaslist.KEY_SAMAS_DEPT = Convert.ToInt32(pRow["KEY_SAMAS_DEPT"].ToString());
samaslist.SAMAS_DEPT = pRow["SAMAS_DEPT"].ToString();
samaslist.SAMAS_TITLE = pRow["SAMAS_TITLE"].ToString();
SamasList.Add(samaslist);
}
return(SamasList);
}
public List <GemsDepartment> GetgemsDepartments(CommonLibrary.Database database)
{
var parameters = new OracleParameter[]
{
new OracleParameter()
{
ParameterName = "phart_dept_key", Direction = ParameterDirection.Input, Value = KEY_GLOBAL_DEPT
},
new OracleParameter("presults", OracleDbType.RefCursor)
{
Direction = ParameterDirection.Output
}
};
var gemsdata = database.GetDataFromProcedure("dept_assignment.get_gems_assigned_depts", parameters);
List <GemsDepartment> GemsList = new List <GemsDepartment>();
foreach (DataRow pRow in gemsdata.Tables[0].Rows)
{
var gemslist = new GemsDepartment();
gemslist.GEMS_DEPT_CODE = pRow["GEMS_DEPT_CODE"].ToString();
gemslist.GEMS_DEPT_DESC = pRow["GEMS_DEPT_DESC"].ToString();
gemslist.KEY_GEMS_DEPT = Convert.ToInt32(pRow["KEY_GEMS_DEPT"].ToString());
GemsList.Add(gemslist);
}
return(GemsList);
}
public List <FastDepartment> GetfastDepartments(CommonLibrary.Database database)
{
var parameters = new OracleParameter[]
{
new OracleParameter()
{
ParameterName = "phart_dept_key", Direction = ParameterDirection.Input, Value = KEY_GLOBAL_DEPT
},
new OracleParameter("presults", OracleDbType.RefCursor)
{
Direction = ParameterDirection.Output
}
};
var Fastdata = database.GetDataFromProcedure("dept_assignment.get_fast_assigned_depts", parameters);
List <FastDepartment> fastList = new List <FastDepartment>();
foreach (DataRow pRow in Fastdata.Tables[0].Rows)
{
var fastlist = new FastDepartment();
fastlist.USF_DEPT_NAME = pRow["USF_DEPT_NAME"].ToString();
fastlist.USF_DEPT_CODE = Convert.ToInt32(pRow["USF_DEPT_CODE"].ToString());
fastlist.KEY_USF_DEPT = Convert.ToInt32(pRow["KEY_USF_DEPT"].ToString());
fastList.Add(fastlist);
}
return(fastList);
}
public List <IdxDepartment> GetidxDepartments(CommonLibrary.Database database)
{
var parameters = new OracleParameter[]
{
new OracleParameter()
{
ParameterName = "phart_dept_key", Direction = ParameterDirection.Input, Value = KEY_GLOBAL_DEPT
},
new OracleParameter("presults", OracleDbType.RefCursor)
{
Direction = ParameterDirection.Output
}
};
var idxdata = database.GetDataFromProcedure("dept_assignment.get_idx_assigned_depts", parameters);
List <IdxDepartment> IDXList = new List <IdxDepartment>();
foreach (DataRow pRow in idxdata.Tables[0].Rows)
{
var idxlist = new IdxDepartment();
idxlist.DIV_MNEMONIC = pRow["DIV_MNEMONIC"].ToString();
idxlist.DIV_NAME = pRow["DIV_NAME"].ToString();
idxlist.DIV_REPORTINGCATEGORY3 = pRow["DIV_REPORTINGCATEGORY3"].ToString();
idxlist.KEY_USFPG_DIV = Convert.ToInt32(pRow["KEY_USFPG_DIV"].ToString());
IDXList.Add(idxlist);
}
return(IDXList);
}
public List <EpicDepartment> GetepicDepartments(CommonLibrary.Database database)
{
var parameters = new OracleParameter[]
{
new OracleParameter()
{
ParameterName = "phart_dept_key", Direction = ParameterDirection.Input, Value = KEY_GLOBAL_DEPT
},
new OracleParameter("presults", OracleDbType.RefCursor)
{
Direction = ParameterDirection.Output
}
};
var epicdata = database.GetDataFromProcedure("dept_assignment.get_epic_assigned_depts", parameters);
List <EpicDepartment> EpicList = new List <EpicDepartment>();
foreach (DataRow pRow in epicdata.Tables[0].Rows)
{
var epiclist = new EpicDepartment();
epiclist.DEPARTMENT_EPIC_ID = pRow["DEPARTMENT_EPIC_ID"].ToString();
epiclist.DEPARTMENT_EXTERNAL_NAME = pRow["DEPARTMENT_EXTERNAL_NAME"].ToString();
epiclist.DEPARTMENT_NAME = pRow["DEPARTMENT_NAME"].ToString();
epiclist.KEY_EPIC_DEPT = Convert.ToInt32(pRow["KEY_EPIC_DEPT"].ToString());
EpicList.Add(epiclist);
}
return(EpicList);
}
public List <BannerDepartment> GetbannerDepartments(CommonLibrary.Database database)
{
var parameters = new OracleParameter[]
{
new OracleParameter()
{
ParameterName = "phart_dept_key", Direction = ParameterDirection.Input, Value = KEY_GLOBAL_DEPT
},
new OracleParameter("presults", OracleDbType.RefCursor)
{
Direction = ParameterDirection.Output
}
};
var bannerdata = database.GetDataFromProcedure("dept_assignment.get_mdbanner_assigned_depts", parameters);
List <BannerDepartment> BannerList = new List <BannerDepartment>();
foreach (DataRow pRow in bannerdata.Tables[0].Rows)
{
var bannerlist = new BannerDepartment();
bannerlist.MDBANNER_DEPT_CODE = Convert.ToInt32(pRow["MDBANNER_DEPT_CODE"].ToString());
bannerlist.MDBANNER_DEPT_DESC = pRow["MDBANNER_DEPT_DESC"].ToString();
bannerlist.KEY_MDBANNER_DEPT = Convert.ToInt32(pRow["KEY_MDBANNER_DEPT"].ToString());
BannerList.Add(bannerlist);
}
return(BannerList);
}
public static void PopulateUser(User user, Database database)
{
if (string.IsNullOrEmpty(user.UID))
{
var parameters = new OracleParameter[]
{
new OracleParameter()
{
ParameterName = "p_hscnet_id", Direction = ParameterDirection.Input, Value = user.GetHSCNetIdFromEmail()
},
new OracleParameter()
{
ParameterName = "p_firstname", Direction = ParameterDirection.Output, Size = 5000
},
new OracleParameter()
{
ParameterName = "p_lastname", Direction = ParameterDirection.Output, Size = 5000
},
new OracleParameter()
{
ParameterName = "p_personid", Direction = ParameterDirection.Output, Size = 5000
},
};
database.FillParametersFromProcedure("hsc.health_account.get_accounts_by_hscnet_id", parameters);
//throw new Exception(parameters[1].Value.ToString());
user.FirstName = parameters[1].Value.ToString();
user.LastName = parameters[2].Value.ToString();
user.PersonID = parameters[3].Value.ToString();
}
else
{
var newparameters = new OracleParameter[]
{
new OracleParameter()
{
ParameterName = "p_uid", Direction = ParameterDirection.Input, Value = user.UID
},
new OracleParameter()
{
ParameterName = "p_firstname", Direction = ParameterDirection.Output, Size = 5000
},
new OracleParameter()
{
ParameterName = "p_lastname", Direction = ParameterDirection.Output, Size = 5000
},
new OracleParameter()
{
ParameterName = "p_personid", Direction = ParameterDirection.Output, Size = 5000
},
};
database.FillParametersFromProcedure("hsc.health_account.get_health_accounts_by_UID", newparameters);
//throw new Exception(parameters[1].Value.ToString());
user.FirstName = newparameters[1].Value.ToString();
user.LastName = newparameters[2].Value.ToString();
user.PersonID = newparameters[3].Value.ToString();
}
//StreamWriter sw = new StreamWriter(@"c:\inetpub\wwwroot\logcas.txt");
//sw.WriteLine("PersonID = " + user.PersonID);
//sw.WriteLine("First Name = " + user.FirstName);
//sw.WriteLine("Last Name = " + user.LastName);
//sw.WriteLine("UID = " + user.UID);
if (database == null)
{
throw new Exception("Database is null");
}
if (user.PersonID == null)
{
throw new Exception("PersonID is null");
}
var personID = new OracleParameter()
{
ParameterName = "p_person_id", Direction = ParameterDirection.Input, Value = user.PersonID
};
var cursor = new OracleParameter("curr_groups", OracleDbType.RefCursor)
{
Direction = ParameterDirection.Output
};
var data = database.GetDataFromProcedure("hsc.active_directory.sel_user_groups",
personID,
cursor
);
// data.WriteXml("C:\\inetpub\\wwwroot\\data.xml");
if (data == null)
{
throw new Exception("no groups to retrieve");
}
var table = data.Tables[0];
var rows = table.Rows;
//sw.WriteLine("Number of Rows = " + rows.Count);
//sw.Close();
//user.Groups.Add(rows[0]["sam_account_name"].ToString());
for (var i = 0; i < rows.Count; i++)
{
if (rows != null && rows[i] != null)
{
DataRow row = rows[i];
user.Groups.Add(row["sam_account_name"].ToString());
}
}
}
