//GET SHOW ALL public DataTable GetData(DempresaMaestra entiti) { DataTable dt; using (SqlConnection cnn = RConexion.Getconectar()) { cnn.Open(); SqlDataAdapter da = new SqlDataAdapter(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = cnn; cmd.CommandText = "SP_SHOW_EMPRESA"; cmd.CommandType = CommandType.StoredProcedure; da.SelectCommand = cmd; using (dt = new DataTable()) { da.Fill(dt); da.Dispose(); } } } return(dt); }
//GUARDAR public int Add(DempresaMaestra entiti) { result = 0; using (SqlConnection conn = RConexion.Getconectar()) { conn.Open(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = conn; cmd.CommandText = "SP_INSERT_EMPRESA_MAESTRA"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@razon_social", entiti.Razon_social); cmd.Parameters.AddWithValue("@direccion", entiti.Direccion); cmd.Parameters.AddWithValue("@domicilio", entiti.Domicilio); cmd.Parameters.AddWithValue("@ruc", entiti.Ruc); cmd.Parameters.AddWithValue("@regimen", entiti.Regimen); cmd.Parameters.AddWithValue("@localidad", entiti.Localidad); cmd.Parameters.AddWithValue("@cod_empresa_validar", entiti.Ecodigo_empresa); cmd.Parameters.Add("@mesage", SqlDbType.VarChar, 100).Direction = ParameterDirection.Output; using (SqlCommand cmd1 = new SqlCommand()) { cmd1.Connection = conn; cmd1.CommandText = "SP_INSERT_EMPRESA"; cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@cod_empresa", entiti.Ecodigo_empresa); cmd1.Parameters.AddWithValue("@id_usuario", entiti.Eidusuario); result = cmd.ExecuteNonQuery(); entiti.mesages = cmd.Parameters["@mesage"].Value.ToString(); if (result > 0) { result = cmd1.ExecuteNonQuery(); } cmd.Parameters.Clear(); cmd1.Parameters.Clear(); } } } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.ToString()); } } return(result); }
//METODO GUARDAR CAMBIOS public string SaveChanges() { mensaje = ""; try { DempresaMaestra de = new DempresaMaestra(); de.Razon_social = razon_social; de.Direccion = direccion; de.Domicilio = domicilio; de.Ruc = ruc; de.Regimen = regimen; de.Localidad = localidad; de.Scodigo_sucursal = scodigo_sucursal; de.Eidemp_maestra = eidemp_maestra; de.Sid_empresa = sidempresa; de.Sidem_maestra = sidem_maestra; switch (state) { case EntityState.Guardar: sucursal_reposi.Add(de); mensaje = de.mesages; break; case EntityState.Modificar: sucursal_reposi.Edit(de); mensaje = "¡Modificado!"; break; case EntityState.Remover: sucursal_reposi.Delete(de); mensaje = de.mesages; break; default: mensaje = "Error in Transaction!"; break; } } catch (Exception ex) { mensaje = ex.ToString(); } finally { } return(mensaje); }
//EDIT public int Edit(DempresaMaestra entiti) { result = 0; using (SqlConnection conn = RConexion.Getconectar()) { conn.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = conn; cmd.CommandText = "SP_UPDATE_EMPRESAMAESTRA"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@razon_social", SqlDbType.VarChar, 50).Value = entiti.Razon_social; cmd.Parameters.Add("@direccion", SqlDbType.NVarChar, 250).Value = entiti.Direccion; cmd.Parameters.Add("@domicilio", SqlDbType.NVarChar, 250).Value = entiti.Domicilio; cmd.Parameters.Add("@ruc", SqlDbType.Char, 11).Value = entiti.Ruc; cmd.Parameters.Add("@regimen", SqlDbType.VarChar, 50).Value = entiti.Regimen; cmd.Parameters.Add("@localidad", SqlDbType.VarChar, 50).Value = entiti.Localidad; cmd.Parameters.Add("@id_emmaestra", SqlDbType.Int).Value = entiti.Eidemp_maestra; using (SqlCommand cmd1 = new SqlCommand()) { cmd1.Connection = conn; cmd1.CommandText = "SP_UPDATE_EMPRESA"; cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.Add("@cod_empresa", SqlDbType.VarChar, 8).Value = entiti.Ecodigo_empresa; cmd1.Parameters.Add("@id_usuario", SqlDbType.Int).Value = entiti.Eidusuario; cmd1.Parameters.Add("@id_emmaestra", SqlDbType.Int).Value = entiti.Eidemp_maestra; result = cmd.ExecuteNonQuery(); if (result > 0) { result = cmd1.ExecuteNonQuery(); } cmd.Parameters.Clear(); cmd1.Parameters.Clear(); } } } return(result); }
public int Add(DempresaMaestra entiti) { result = 0; using (SqlConnection conn = RConexion.Getconectar()) { using (SqlCommand cmd = new SqlCommand()) { conn.Open(); cmd.Connection = conn; cmd.CommandText = "SP_INSERT_EMPRESA_MAESTRA"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@razon_social", SqlDbType.VarChar, 50).Value = entiti.Razon_social; cmd.Parameters.Add("@direccion", SqlDbType.NVarChar, 250).Value = entiti.Direccion; cmd.Parameters.Add("@domicilio", SqlDbType.NVarChar, 250).Value = entiti.Domicilio; cmd.Parameters.Add("@ruc", SqlDbType.Char, 11).Value = entiti.Ruc; cmd.Parameters.Add("@regimen", SqlDbType.VarChar, 50).Value = entiti.Regimen; cmd.Parameters.Add("@localidad", SqlDbType.VarChar, 50).Value = entiti.Localidad; cmd.Parameters.Add("@cod_empresa_validar", SqlDbType.VarChar, 50).Value = entiti.Scodigo_sucursal; cmd.Parameters.Add("@mesage", SqlDbType.VarChar, 100).Direction = ParameterDirection.Output; using (SqlCommand cmd1 = new SqlCommand()) { cmd1.Connection = conn; cmd1.CommandText = "SP_INSERT_SUCURSAL"; cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.Add("@cod_sucursal", SqlDbType.VarChar, 8).Value = entiti.Scodigo_sucursal; cmd1.Parameters.Add("@id_empresa", SqlDbType.Int).Value = entiti.Sid_empresa; result = cmd.ExecuteNonQuery(); entiti.mesages = cmd.Parameters["@mesage"].Value.ToString(); if (result > 0) { result = cmd1.ExecuteNonQuery(); } cmd.Parameters.Clear(); cmd1.Parameters.Clear(); } } return(result); } }
//REMOVE public int Delete(DempresaMaestra entiti) { result = 0; using (SqlConnection cnn = RConexion.Getconectar()) { cnn.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = cnn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SP_REMOVE_EMPRESA"; cmd.Parameters.Add("@id_maestra", SqlDbType.Int).Value = entiti.Eidemp_maestra; cmd.Parameters.Add("@mesage", SqlDbType.VarChar, 50).Direction = ParameterDirection.Output; result = cmd.ExecuteNonQuery(); entiti.mesages = cmd.Parameters["@mesage"].Value.ToString(); cmd.Parameters.Clear(); } } return(result); }