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;
}
