public int SaveTemplTemplateJustification(ref BaseEntity Entity, clsTemplateJustification objJust) { int i = 0; SqlCommand cmd = null; SqlConnection cn = clsConnection.GetConnection(); try { cmd = new SqlCommand("sp_xP_Guardar_Plantilla_Justificacion", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@EmpresaId", objJust.EmpresaId); cmd.Parameters.AddWithValue("@JustificacionPlantillaTipo", objJust.TypeJustification.ID); cmd.Parameters.AddWithValue("@JustificacionContenido", objJust.JustificacionContenido); cmd.Parameters.AddWithValue("@CreatedBy", objJust.Createdby); i = cmd.ExecuteNonQuery(); } catch (Exception ex) { Entity.Errors.Add(new BaseEntity.ListError(ex, "Error saving Template Memorandum")); } finally { cmd.Connection.Close(); } return(i); }
public clsTemplateJustification SearchTemplateJustification(ref BaseEntity Base, int loanId) { clsTemplateJustification busq = null; SqlDataReader dr = null; SqlCommand cmd = null; try { cmd = new SqlCommand("sp_xP_Buscar_Plantilla_Justificacion", clsConnection.GetConnection()); cmd.Parameters.AddWithValue("@prmId", loanId); cmd.CommandType = CommandType.StoredProcedure; dr = cmd.ExecuteReader(); if (dr.Read()) { busq = new clsTemplateJustification(); busq.ID = Convert.ToInt32(dr["JustificacionPlantillaId"]); busq.EmpresaId = Convert.ToInt32(dr["EmpresaId"]); clsTypeJustification t = new clsTypeJustification(); t.ID = Convert.ToInt32(dr["JustificacionPlantillaTipo"]); busq.TypeJustification = t; //busq.JustificacionPlantillaTipo = dr["JustificacionPlantillaTipo"].ToString(); busq.JustificacionContenido = dr["JustificacionContenido"].ToString(); } } catch (Exception ex) { busq = null; Base.Errors.Add(new BaseEntity.ListError(ex, "Error Template Justification search")); } return(busq); }
public clsJustification SearchJustificacion(ref BaseEntity Base, int loanId) { clsJustification busq = null; SqlDataReader dr = null; SqlCommand cmd = null; try { cmd = new SqlCommand("sp_xP_Buscar_Asignacion_Justificacion", clsConnection.GetConnection()); cmd.Parameters.AddWithValue("@prmId", loanId); cmd.CommandType = CommandType.StoredProcedure; dr = cmd.ExecuteReader(); if (dr.Read()) { busq = new clsJustification(); busq.ID = Convert.ToInt32(dr["IDJUSTIFICACION"]); busq.EmpresaId = Convert.ToInt32(dr["IDEMPRESA"]); busq.Archivo = dr["DOCUMENTO"].ToString(); //obtener empleado de lista (id, nombre) clsEmployee objEmp = new clsEmployee(); objEmp.Name = dr["NOMBEMPLEADO"].ToString(); //nombre busq.EmpleadoId = Convert.ToInt32(dr["EmpleadoId"]); busq.employee = objEmp; //guardo valores en mi objeto tipo clase //obtener valor del combo (id) clsTemplateJustification objTM = new clsTemplateJustification(); objTM.ID = Convert.ToInt32(dr["IDPLANTILLAJUSTIFICACION"]); busq.justificacion = objTM; // busq.Motivo = dr["RAZON"].ToString(); busq.Fecha = Convert.ToDateTime(dr["FECHA"].ToString()); } } catch (Exception ex) { busq = null; Base.Errors.Add(new BaseEntity.ListError(ex, "Error Justificación search")); } return(busq); }
public int JustificationTemplate_Update(ref BaseEntity Base, clsTemplateJustification objUpJust) { SqlCommand cmd = null; int isCorrect = 0; try { cmd = new SqlCommand("sp_xP_Editar_Plantilla_Justificacion", clsConnection.GetConnection()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@JustificacionPlantillaId", objUpJust.ID); cmd.Parameters.AddWithValue("@JustificacionPlantillaTipo", objUpJust.TypeJustification.ID); cmd.Parameters.AddWithValue("@JustificacionContenido", objUpJust.JustificacionContenido); cmd.Parameters.AddWithValue("@LastUpdateBy", objUpJust.Updatedby); isCorrect = cmd.ExecuteNonQuery(); } catch (Exception ex) { isCorrect = 0; Base.Errors.Add(new BaseEntity.ListError(ex, "An error occurred on Save Template Justification")); } finally { cmd.Connection.Close(); } return(isCorrect); }