public int Update(NominaEntityObject NominaInfo) { int nRes = 0; if (NominaInfo != null) { using (SqlConnection conn = new SqlConnection(this.ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = conn; cmd.CommandTimeout = 30000; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_CAL_SetConceptoTrabajador_"; cmd.Parameters.AddWithValue("@CLAVE_TRABAJADOR", NominaInfo.ClaveTrabajador); cmd.Parameters.AddWithValue("@CLAVE_CONCEPTO", NominaInfo.ClaveConcepto); cmd.Parameters.AddWithValue("@cap1", NominaInfo.Cap1); cmd.Parameters.AddWithValue("@cap2", NominaInfo.Cap2); cmd.Parameters.AddWithValue("@cap3", NominaInfo.Cap3); cmd.Parameters.AddWithValue("@total", NominaInfo.Total); cmd.Parameters.AddWithValue("@exento", NominaInfo.Exento); cmd.Parameters.AddWithValue("@PERIODO", NominaInfo.Periodo); cmd.Parameters.AddWithValue("@saldo", 0); conn.Open(); nRes = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); } } } return(0); }
private bool Exists(NominaEntityObject NominaInfo) { if (NominaInfo != null && NominaInfo.Id > 0) { return(true); } else { return(false); } }
public int Delete(NominaEntityObject NominaInfo) { int nRes = 0; string sql = string.Empty; try { if (NominaInfo != null) { sql = string.Format("DELETE FROM dbTRABNOMI_ACT WHERE ID={0};", NominaInfo.Id); nRes = ExecuteNonQuery(sql, null, null); } return(nRes); } catch (Exception ex) { throw ex; } }
private NominaEntityObject GetEntityObject(DataRow row) { NominaEntityObject _NominaInfo = new NominaEntityObject(); if (row != null) { _NominaInfo.Id = (row["ID"] != DBNull.Value) ? Convert.ToInt32(row["ID"].ToString()) : 0; _NominaInfo.Empresa = row["clave_empresa"].ToString(); _NominaInfo.Periodo = row["CLAVE_PERIODO"].ToString(); _NominaInfo.ClaveTrabajador = row["CLAVE_TRABAJADOR"].ToString(); _NominaInfo.Nombre = row["nombre_completo"].ToString(); _NominaInfo.ClaveConcepto = row["CLAVE_CONCEPTO"].ToString(); _NominaInfo.Descripcion = row["Descripcion"].ToString(); _NominaInfo.Cap1 = (row["cap1"] != DBNull.Value) ? (decimal)row["cap1"] : 0; _NominaInfo.Cap2 = (row["cap2"] != DBNull.Value) ? (decimal)row["cap2"] : 0; _NominaInfo.Cap3 = (row["cap3"] != DBNull.Value) ? (decimal)row["cap3"] : 0; _NominaInfo.Total = (row["total"] != DBNull.Value) ? (decimal)row["total"] : 0; _NominaInfo.IsCanculado = (row["total"] != DBNull.Value) ? (bool)row["capturado"] : false; } return(_NominaInfo); }
public int Insert(NominaEntityObject NominaInfo) { int nRes = 0; if (NominaInfo != null) { using (SqlConnection conn = new SqlConnection(this.ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = conn; cmd.CommandTimeout = 30000; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_CAP_InsertIncidenciaConceptoPorEmpresa_"; cmd.Parameters.AddWithValue("@CLAVE_TRABAJADOR", NominaInfo.ClaveTrabajador); cmd.Parameters.AddWithValue("@CLAVE_CONCEPTO", NominaInfo.ClaveConcepto); cmd.Parameters.AddWithValue("@cap1", NominaInfo.Cap1); cmd.Parameters.AddWithValue("@cap2", NominaInfo.Cap2); cmd.Parameters.AddWithValue("@cap3", NominaInfo.Cap3); cmd.Parameters.AddWithValue("@total", NominaInfo.Total); cmd.Parameters.AddWithValue("@exento", NominaInfo.Exento); cmd.Parameters.AddWithValue("@capturado", 1); cmd.Parameters.AddWithValue("@USUARIO", "NASA"); cmd.Parameters.AddWithValue("@CVEEMPRESA", NominaInfo.Empresa); cmd.Parameters.AddWithValue("@PERIODO", NominaInfo.Periodo); conn.Open(); nRes = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); } } } return(nRes); }