public List <HCM_Module> GetModulesByProductID(int?ProductID)
{
List <HCM_Module> Modle_list = new List <HCM_Module>();
HCM_Module Modle_obj = new HCM_Module();
try
{
using (SqlConnection sql_obj = new SqlConnection())
{
sql_obj.ConnectionString = sql.GetConnection();
sql_obj.Open();
using (SqlCommand cmd = new SqlCommand("HCM_PROC_GetModulesBasedOnProductID", sql_obj))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
if (Convert.ToInt32(ProductID) != null)
{
cmd.Parameters.AddWithValue("@ProductID", Convert.ToInt32(ProductID));
}
else
{
cmd.Parameters.AddWithValue("@ProductID", 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++)
{
Modle_obj = new HCM_Module();
Modle_obj.ModuleID = Convert.ToInt32(dt.Rows[i]["ModuleID"]);
Modle_obj.ModuleName = Convert.ToString(dt.Rows[i]["ModuleName"]);
Modle_list.Add(Modle_obj);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(Modle_list);
}
public List <HCM_Module> GetAllModulesList()
{
List <HCM_Module> module_list = new List <HCM_Module>();
HCM_Module module_obj = new HCM_Module();
try
{
using (SqlConnection sql_obj = new SqlConnection())
{
sql_obj.ConnectionString = con.GetConnection();
sql_obj.Open();
using (SqlCommand cmd = new SqlCommand("HCM_PROC_GetModules", sql_obj))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.AddWithValue("@Status", true);
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++)
{
module_obj = new HCM_Module();
module_obj.ModuleID = Convert.ToInt32(dt.Rows[i]["ModuleID"]);
module_obj.ModuleName = Convert.ToString(dt.Rows[i]["ModuleName"]);
if (i == 0)
{
module_obj.Show = true;
}
else
{
module_obj.Show = false;
}
module_list.Add(module_obj);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(module_list);
}
public List <HCM_Module> GetAllModules()
{
List <HCM_Module> hcm_ModuleList_Obj = new List <HCM_Module>();
HCM_Module hcm_Modules_Obj = new HCM_Module();
try
{
using (SqlConnection sqlcon_obj = new SqlConnection())
{
sqlcon_obj.ConnectionString = con.GetConnection();
sqlcon_obj.Open();
using (SqlCommand sqlcmd_Obj = new SqlCommand("HCM_PROC_GetModules", sqlcon_obj))
{
sqlcmd_Obj.CommandTimeout = 0;
sqlcmd_Obj.CommandType = CommandType.StoredProcedure;
sqlcmd_Obj.Parameters.AddWithValue("@Status", DBNull.Value);
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_Modules_Obj = new HCM_Module();
hcm_Modules_Obj.Product.ProductID = Convert.ToInt32(dt.Rows[i]["ProductID"]);
hcm_Modules_Obj.Product.ProductName = Convert.ToString(dt.Rows[i]["ProductName"]);
hcm_Modules_Obj.ModuleID = Convert.ToInt32(dt.Rows[i]["ModuleID"]);
hcm_Modules_Obj.ModuleName = Convert.ToString(dt.Rows[i]["ModuleName"]);
hcm_Modules_Obj.ModuleDescription = Convert.ToString(dt.Rows[i]["ModuleDescription"]);
hcm_Modules_Obj.CreatedOn = Convert.ToDateTime(dt.Rows[i]["CreatedOn"]);
hcm_Modules_Obj.Status = Convert.ToBoolean(dt.Rows[i]["Status"]);
hcm_ModuleList_Obj.Add(hcm_Modules_Obj);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(hcm_ModuleList_Obj);
}
public List <HCM_Module> GetModules()
{
List <HCM_Module> hcmModules_List = new List <HCM_Module>();
HCM_Module hcm_Module_Obj = new HCM_Module();
try
{
using (SqlConnection sqlCon_Obj = new SqlConnection())
{
sqlCon_Obj.ConnectionString = con.GetConnection();
sqlCon_Obj.Open();
using (SqlCommand sqlcmd_Obj = new SqlCommand("HCM_PROC_GetModulesBasedOnProductID", sqlCon_Obj))
{
sqlcmd_Obj.CommandTimeout = 0;
sqlcmd_Obj.CommandType = CommandType.StoredProcedure;
sqlcmd_Obj.Parameters.AddWithValue("@ProductID", Convert.ToInt32(HttpContext.Current.Session["ProductID"]));
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_Module_Obj = new HCM_Module();
hcm_Module_Obj.ModuleID = Convert.ToInt32(dt.Rows[i]["ModuleID"]);
hcm_Module_Obj.ModuleName = Convert.ToString(dt.Rows[i]["ModuleName"]);
hcmModules_List.Add(hcm_Module_Obj);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(hcmModules_List);
}
