public List <HCM_WorkStream> GetAllWorkStreams()
{
List <HCM_WorkStream> hcmWorkStream_List = new List <HCM_WorkStream>();
HCM_WorkStream hcm_WorkStream_Obj = new HCM_WorkStream();
try
{
using (SqlConnection sqlCon_Obj = new SqlConnection())
{
sqlCon_Obj.ConnectionString = con.GetConnection();
sqlCon_Obj.Open();
using (SqlCommand sqlcmd_Obj = new SqlCommand("HCM_PROC_GetWorkStreamsList", sqlCon_Obj))
{
sqlcmd_Obj.CommandTimeout = 0;
sqlcmd_Obj.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(sqlcmd_Obj);
DataTable dt = new DataTable();
da.Fill(dt);
sqlCon_Obj.Close();
if (dt.Rows.Count > 0)
{
for (var i = 0; i < dt.Rows.Count; i++)
{
hcm_WorkStream_Obj = new HCM_WorkStream();
hcm_WorkStream_Obj.WorkStreamID = Convert.ToInt32(dt.Rows[i]["WorkStreamID"]);
hcm_WorkStream_Obj.Product.ProductID = dt.Rows[i]["ProductID"] == DBNull.Value ? (int?)null : Convert.ToInt32(dt.Rows[i]["ProductID"]);
hcm_WorkStream_Obj.Product.ProductName = Convert.ToString(dt.Rows[i]["ProductName"]);
hcm_WorkStream_Obj.Module.ModuleID = Convert.ToInt32(dt.Rows[i]["ModuleID"]);
hcm_WorkStream_Obj.Module.ModuleName = Convert.ToString(dt.Rows[i]["ModuleName"]);
hcm_WorkStream_Obj.WorkStreamName = Convert.ToString(dt.Rows[i]["WorkStreamName"]);
hcm_WorkStream_Obj.WorkStreamDescription = Convert.ToString(dt.Rows[i]["WorkStreamDescription"]);
hcm_WorkStream_Obj.Status = Convert.ToBoolean(dt.Rows[i]["Status"]);
hcm_WorkStream_Obj.CreatedOn = Convert.ToDateTime(dt.Rows[i]["CreatedOn"]);
hcm_WorkStream_Obj.CreatedBy = Convert.ToInt32(dt.Rows[i]["CreatedBy"]);
hcmWorkStream_List.Add(hcm_WorkStream_Obj);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(hcmWorkStream_List);
}
public List <HCM_WorkStream> GetWorkStreamByModuleID(int ModuleID)
{
List <HCM_WorkStream> workStream_list = new List <HCM_WorkStream>();
HCM_WorkStream workStream_obj = new HCM_WorkStream();
try
{
using (SqlConnection sql_obj = new SqlConnection())
{
sql_obj.ConnectionString = sql.GetConnection();
sql_obj.Open();
using (SqlCommand cmd = new SqlCommand("HCM_PROC_GetWorkStreamsByModuleID", sql_obj))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
if (ModuleID != null)
{
cmd.Parameters.AddWithValue("@ModuleID", ModuleID);
}
else
{
cmd.Parameters.AddWithValue("@ModuleID", DBNull.Value);
}
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
sql_obj.Close();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
workStream_obj = new HCM_WorkStream();
workStream_obj.WorkStreamID = Convert.ToInt32(dt.Rows[i]["WorkStreamID"]);
workStream_obj.WorkStreamName = Convert.ToString(dt.Rows[i]["WorkStreamName"]);
workStream_list.Add(workStream_obj);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(workStream_list);
}
