public int SaveTemplTemplateMemorandum(ref BaseEntity Entity, clsTemplateMemorandumcs objMemo) { int i = 0; SqlCommand cmd = null; SqlConnection cn = clsConnection.GetConnection(); try { cmd = new SqlCommand("sp_xP_Guardar_Plantilla_memorandum", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@EmpresaId", objMemo.EmpresaId); cmd.Parameters.AddWithValue("@MemorandumPlantillaTipo", objMemo.MemorandumPlantillaTipo); cmd.Parameters.AddWithValue("@MemorandumContenido", objMemo.MemorandumContenido); cmd.Parameters.AddWithValue("@Principal", objMemo.Principal); cmd.Parameters.AddWithValue("@CreatedBy", objMemo.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 clsTemplateMemorandumcs SearchTemplateMemorandum(ref BaseEntity Base, int loanId) { clsTemplateMemorandumcs busq = null; SqlDataReader dr = null; SqlCommand cmd = null; try { cmd = new SqlCommand("sp_xP_Buscar_Plantilla_Memorandum", clsConnection.GetConnection()); cmd.Parameters.AddWithValue("@prmId", loanId); cmd.CommandType = CommandType.StoredProcedure; dr = cmd.ExecuteReader(); if (dr.Read()) { busq = new clsTemplateMemorandumcs(); busq.ID = Convert.ToInt32(dr["MemorandumPlantillaId"]); busq.EmpresaId = Convert.ToInt32(dr["EmpresaId"]); busq.MemorandumPlantillaTipo = dr["MemorandumPlantillaTipo"].ToString(); busq.MemorandumContenido = dr["MemorandumContenido"].ToString(); busq.Principal = Convert.ToInt32(dr["Principal"]); } } catch (Exception ex) { busq = null; Base.Errors.Add(new BaseEntity.ListError(ex, "Error Template Memorandum search")); } return(busq); }
public int MemorandumTemplate_Update(ref BaseEntity Base, clsTemplateMemorandumcs objMemo) { SqlCommand cmd = null; int isCorrect = 0; try { cmd = new SqlCommand("sp_xP_Editar_Plantilla_Memorandum", clsConnection.GetConnection()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MemorandumPlantillaId", objMemo.ID); cmd.Parameters.AddWithValue("@MemorandumPlantillaTipo", objMemo.MemorandumPlantillaTipo); cmd.Parameters.AddWithValue("@MemorandumContenido", objMemo.MemorandumContenido); cmd.Parameters.AddWithValue("@Principal", objMemo.Principal); cmd.Parameters.AddWithValue("@LastUpdateBy", objMemo.Updatedby); isCorrect = cmd.ExecuteNonQuery(); } catch (Exception ex) { isCorrect = 0; Base.Errors.Add(new BaseEntity.ListError(ex, "An error occurred on Save Memorandum Template")); } finally { cmd.Connection.Close(); } return(isCorrect); }
public clsMemorandums SearchMemorandum(ref BaseEntity Base, int loanId) { clsMemorandums busq = null; SqlDataReader dr = null; SqlCommand cmd = null; try { cmd = new SqlCommand("sp_xP_Buscar_Asignacion_Memorandum", clsConnection.GetConnection()); cmd.Parameters.AddWithValue("@prmId", loanId); cmd.CommandType = CommandType.StoredProcedure; dr = cmd.ExecuteReader(); if (dr.Read()) { busq = new clsMemorandums(); busq.ID = Convert.ToInt32(dr["IDMEMORANDUM"]); 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) clsTemplateMemorandumcs objTM = new clsTemplateMemorandumcs(); objTM.ID = Convert.ToInt32(dr["IDPLANTILLAMEMORANDUM"]); busq.memorandum = objTM; // busq.Motivo = dr["RAZON"].ToString(); busq.Descripcion = dr["DESCRIPCION"].ToString(); busq.Fecha = Convert.ToDateTime(dr["FECHA"].ToString()); busq.TipoMemorandum = Convert.ToInt32(dr["TIPOMEMORANDUM"].ToString()); } } catch (Exception ex) { busq = null; Base.Errors.Add(new BaseEntity.ListError(ex, "Error Memorandum search")); } return(busq); }