public void DA_Registrar_CONTRATO_ORG(AP_ContratoOrg c) { try { using (SqlConnection conexion = new SqlConnection(conexionString)) { SqlCommand cmd = new SqlCommand("GAP_CONTRATO_ORG_INSERT", conexion); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id_InscripcionOrg", c.Id_InscripcionOrg); cmd.Parameters.AddWithValue("@Num_Contrato", c.Num_Contrato); cmd.Parameters.AddWithValue("@Ci_RepLegalEmapa", c.Ci_RepLegalEmapa); cmd.Parameters.AddWithValue("@ResolucionAdmin", c.ResolucionAdmin); cmd.Parameters.AddWithValue("@FechaResAdmin", c.FechaResAdmin); cmd.Parameters.AddWithValue("@Domicilio", c.Domicilio); cmd.Parameters.AddWithValue("@Estado", c.Estado); conexion.Open(); cmd.ExecuteNonQuery(); conexion.Close(); } } catch (Exception err) { throw (new Exception(err.ToString() + "-" + err.Source.ToString() + "-" + err.Message.ToString())); } }
public void Registrar_CONTRATO(int IdInsOrg) { Generar_CODIGO_CONTRATO(); AP_ContratoOrg c = new AP_ContratoOrg(); c.Id_InscripcionOrg = IdInsOrg; c.Num_Contrato = LblNumero.Text; c.Ci_RepLegalEmapa = "3459923"; c.ResolucionAdmin = "01-016/2010"; c.FechaResAdmin = DateTime.Now; c.Domicilio = "CALACOTO CALLE 9"; c.Estado = "ACEPTADO"; DB_AP_ContratoOrg Ins = new DB_AP_ContratoOrg(); Ins.DB_Registrar_CONTRATO_ORG(c); }
public void DB_Registrar_CONTRATO_ORG(AP_ContratoOrg c) { DA_AP_ContratoOrg Ins = new DA_AP_ContratoOrg(); Ins.DA_Registrar_CONTRATO_ORG(c); }