public bool changueStatusModule(Module_Entity module) { bool response = false; try { sqlConnection.Open(); sqlCommand = new SqlCommand("change_status_module", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; SqlParameter id_parameter = new SqlParameter(); id_parameter.ParameterName = "@idModule"; id_parameter.SqlDbType = SqlDbType.Int; id_parameter.Value = module.id_module; SqlParameter p_status = new SqlParameter(); p_status.ParameterName = "@statusModule"; p_status.SqlDbType = SqlDbType.Bit; p_status.Value = module.status_mode; sqlCommand.Parameters.Add(id_parameter); sqlCommand.Parameters.Add(p_status); sqlCommand.ExecuteNonQuery(); response = true; } catch (Exception e) { throw; } return(response); }
public List <Module_Entity> listModule() { List <Module_Entity> list = new List <Module_Entity>(); try { sqlConnection.Open(); sqlCommand = new SqlCommand("list_modules", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { Module_Entity module = new Module_Entity(); module.id_module = Convert.ToInt32(sqlDataReader["Identificador"]); module.name_module = sqlDataReader["Nombre Modulo"].ToString(); module.abb_module = sqlDataReader["Abreviacion"].ToString(); module.desc_module = sqlDataReader["Descripcion"].ToString(); module.is_default = Convert.ToBoolean(sqlDataReader["Es default"]); module.status_mode = Convert.ToBoolean(sqlDataReader["Estado"]); module.typeModule.id_type_module = Convert.ToInt32(sqlDataReader["ID Tipo Modulo"]); list.Add(module); } } catch (Exception e) { throw; } return(list); }
public ActionResult InsertModule(string module_name, string abreviation, string description, string cbxModule) { String script = ""; Module_Entity module = new Module_Entity(); module.name_module = module_name; module.abb_module = abreviation; module.desc_module = description; module.typeModule.id_type_module = Convert.ToInt32(cbxModule); if (module_Logic.addModule(module)) { script = "<script languaje='javascript'>" + "alert('Modulo agregado correctamente'); " + "window.location.href = '/Index/Home'; " + "</script>"; } else { script = "<script languaje='javascript'>" + "alert('No se pudo agregar');" + "window.location.href = '/ClientBusiness/AddClientBusiness'; " + "</script>"; } return(Content(script)); }
public bool addModule(Module_Entity module) { bool response = false; try { sqlConnection.Open(); sqlCommand = new SqlCommand("add_module", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; SqlParameter p_name = new SqlParameter(); p_name.ParameterName = "@name_module"; p_name.SqlDbType = SqlDbType.VarChar; p_name.Size = 20; p_name.Value = module.name_module; SqlParameter p_abbreviation = new SqlParameter(); p_abbreviation.ParameterName = "@abbreviation"; p_abbreviation.SqlDbType = SqlDbType.VarChar; p_abbreviation.Size = 10; p_abbreviation.Value = module.abb_module; SqlParameter p_description = new SqlParameter(); p_description.ParameterName = "@description"; p_description.SqlDbType = SqlDbType.VarChar; p_description.Size = 100; p_description.Value = module.desc_module; SqlParameter p_idTypeModule = new SqlParameter(); p_idTypeModule.ParameterName = "@idTypeModule"; p_idTypeModule.SqlDbType = SqlDbType.Int; p_idTypeModule.Value = module.typeModule.id_type_module; sqlCommand.Parameters.Add(p_name); sqlCommand.Parameters.Add(p_abbreviation); sqlCommand.Parameters.Add(p_description); sqlCommand.Parameters.Add(p_idTypeModule); sqlCommand.ExecuteNonQuery(); response = true; } catch (Exception e) { throw; } return(response); }
public List <Module_Entity> listModuleOfContact(int id) { List <Module_Entity> list = new List <Module_Entity>(); try { sqlConnection.Open(); sqlCommand = new SqlCommand("search_module_contact", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; SqlParameter id_parameter = new SqlParameter(); id_parameter.ParameterName = "@idModule"; id_parameter.SqlDbType = SqlDbType.Int; id_parameter.Value = id; sqlCommand.Parameters.Add(id_parameter); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { Module_Entity module = new Module_Entity(); module.id_module = Convert.ToInt32(sqlDataReader["Identificador"]); module.name_module = sqlDataReader["Nombre Modulo"].ToString(); module.abb_module = sqlDataReader["Abreviacion"].ToString(); module.desc_module = sqlDataReader["Descripcion"].ToString(); module.is_default = Convert.ToBoolean(sqlDataReader["Es default"]); module.status_mode = Convert.ToBoolean(sqlDataReader["Estado"]); module.clientBusiness.name_client_business = sqlDataReader["Nombre Cliente"].ToString(); module.typeModule.type_module = sqlDataReader["Tipo Modulo"].ToString(); list.Add(module); } } catch (Exception e) { throw; } return(list); }
public Module_Entity searchModule(int id) { Module_Entity module = new Module_Entity(); try { sqlConnection.Open(); sqlCommand = new SqlCommand("search_module", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; SqlParameter id_parameter = new SqlParameter(); id_parameter.ParameterName = "@idModule"; id_parameter.SqlDbType = SqlDbType.Int; id_parameter.Value = id; sqlCommand.Parameters.Add(id_parameter); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); sqlDataReader.Read(); if (sqlDataReader.HasRows) { module.id_module = Convert.ToInt32(sqlDataReader["Identificador"]); module.name_module = sqlDataReader["Nombre Modulo"].ToString(); module.abb_module = sqlDataReader["Abreviacion"].ToString(); module.desc_module = sqlDataReader["Descripcion"].ToString(); module.is_default = Convert.ToBoolean(sqlDataReader["Es default"]); module.status_mode = Convert.ToBoolean(sqlDataReader["Estado"]); module.typeModule.type_module = sqlDataReader["Tipo Modulo"].ToString(); } } catch (Exception e) { throw; } return(module); }
public List <Module_Entity> searchModuleOfContact(int id) { List <Module_Entity> list = new List <Module_Entity>(); try { sqlConnection.Open(); sqlCommand = new SqlCommand("search_module_for_contact", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; SqlParameter id_parameter = new SqlParameter(); id_parameter.ParameterName = "@idContact"; id_parameter.SqlDbType = SqlDbType.Int; id_parameter.Value = id; sqlCommand.Parameters.Add(id_parameter); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { Module_Entity module = new Module_Entity(); module.id_module = Convert.ToInt32(sqlDataReader["Identificador"]); module.name_module = sqlDataReader["Nombre Modulo"].ToString(); module.desc_module = sqlDataReader["Descripcion"].ToString(); list.Add(module); } sqlConnection.Close(); } catch (Exception e) { throw; } return(list); }
public ActionResult ChanguePassword(string id, string status) { Module_Entity module = new Module_Entity(); module.id_module = Convert.ToInt32(id); module.status_mode = Convert.ToBoolean(status); String script = ""; if (module_Logic.changueStatusModule(module)) { script = "<script languaje='javascript'>" + "window.location.href='/Module/EditModules/" + id + "'; " + "</script>"; } else { script = "<script languaje='javascript'>" + "alert('Registro no actualizado'); " + "</script>"; } return(Content(script)); }
public bool addModule(Module_Entity module) { return(module_Data.addModule(module)); }
public bool changueStatusModule(Module_Entity module) { return(module_Data.changueStatusModule(module)); }