public List <IntakeProviderDocument> Select(gbmodel.user.User oUser, gbmodel.intakeprovider.IntakeProvider oProvider, gbmodel.casetype.CaseType oCasetype)
{
List <SqlParameter> oParams = new List <SqlParameter>();
List <IntakeProviderDocument> oList = new List <IntakeProviderDocument>();
oParams.Add(new SqlParameter("@i_provider_id", "" + oProvider.Id));
oParams.Add(new SqlParameter("@sz_case_type_id", oCasetype.ID));
oParams.Add(new SqlParameter("@sz_company_id", oUser.Account.ID));
DataSet ds = null;
ds = DBUtil.DataSet(dbconstant.Procedures.PR_INTAKE_DOCUMENT, oParams);
if (ds != null)
{
IntakeProviderDocument oType;
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
oType = new IntakeProviderDocument();
DataRow dr = dt.Rows[i];
oType.Id = "" + dr["i_document_id"];
oType.Name = "" + dr["sz_name"];
//oType.CreatedDate = Convert.ToDateTime(dr["dt_created"]);
//oType.CreatedBy = oUser;
//oType.Comapany = oUser.Account;
gbmodel.casetype.CaseType obj = new gbmodel.casetype.CaseType();
obj.ID = "" + dr["sz_case_type_id"];
obj.Name = "" + dr["sz_case_type_name"];
oType.CaseType = obj;
oList.Add(oType);
}
}
return(oList);
}
public List <gbmodel.casetype.CaseType> Select(gbmodel.user.User oUser)
{
SqlConnection sqlConnection = null;
List <gbmodel.casetype.CaseType> oList = new List <gbmodel.casetype.CaseType>();
try
{
sqlConnection = new SqlConnection(DBUtil.ConnectionString);
sqlConnection.Open();
SqlCommand sqlCommand = null;
sqlCommand = new SqlCommand(Procedures.PR_SELECT_CASETYPE, sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(new SqlParameter("@sz_company_id", oUser.Account.ID));
SqlDataAdapter da = new SqlDataAdapter(sqlCommand);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
gbmodel.casetype.CaseType oElement = new gbmodel.casetype.CaseType();
oElement.Name = dr["Name"].ToString(); //to do
oElement.ID = dr["ID"].ToString(); //TODO
oList.Add(oElement);
}
}
}
catch (Exception ex)
{
}
finally
{
if (sqlConnection.State == ConnectionState.Open)
{
sqlConnection.Close();
}
}
return(oList);
}