partial void ConsultarSaldoVacaciones_Inserting(ConsultarSaldoVacacionesItem entity) { using (SqlConnection connection = new SqlConnection()) { string connectionStringName = this.DataWorkspace.Fin700v60Data.Details.Name; connection.ConnectionString = ConfigurationManager.ConnectionStrings[connectionStringName].ConnectionString; string procedure = "dbo.SicasSaldoVacaciones"; using (SqlCommand command = new SqlCommand(procedure, connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@EmpId", 1)); command.Parameters.Add(new SqlParameter("@RutTrabajador", entity.Rut)); command.Parameters.Add(new SqlParameter("@Contrato", entity.Contrato)); command.Parameters.Add(new SqlParameter("@Fecha", entity.Fecha)); command.Parameters.Add("@DiasDevengados", SqlDbType.Float).Direction = ParameterDirection.Output; command.Parameters.Add("@DiasGanados", SqlDbType.Float).Direction = ParameterDirection.Output; command.Parameters.Add("@DiasTomadosVacaciones", SqlDbType.Float).Direction = ParameterDirection.Output; command.Parameters.Add("@SaldoVacaciones", SqlDbType.Float).Direction = ParameterDirection.Output; connection.Open(); command.ExecuteNonQuery(); entity.Saldo = (double)(command.Parameters["@SaldoVacaciones"].Value); //connection.Close(); } } this.Details.DiscardChanges(); }
public void AddToConsultarSaldoVacaciones(ConsultarSaldoVacacionesItem consultarSaldoVacacionesItem) { base.AddObject("ConsultarSaldoVacaciones", consultarSaldoVacacionesItem); }
public static ConsultarSaldoVacacionesItem CreateConsultarSaldoVacacionesItem(int ID, global::System.DateTime fecha, string rut, int contrato) { ConsultarSaldoVacacionesItem consultarSaldoVacacionesItem = new ConsultarSaldoVacacionesItem(); consultarSaldoVacacionesItem.id = ID; consultarSaldoVacacionesItem.Fecha = fecha; consultarSaldoVacacionesItem.Rut = rut; consultarSaldoVacacionesItem.Contrato = contrato; return consultarSaldoVacacionesItem; }