public Annotation Update(AnnotationSave obj, AuthUser authUser)
{
Person person = _employeeRepository.GetPersonByChapa(obj.Chapa);
_employeeRepository.Update(obj, authUser);
return(_employeeRepository.GetAnnotationByPersonAndNro(person, obj.Nro, authUser));
}
public AnnotationSave Update(AnnotationSave obj, AuthUser authUser)
{
var sql = "UPDATE PANOTAC SET TEXTO=@texto, DTANOTACAO=@dtanotacao, DTRESOLUCAO=@dtresolucao, RECMODIFIEDBY=@recmodifiedby, RECMODIFIEDON=@recmodifiedon WHERE CODPESSOA=@codpessoa AND NROANOTACAO=@nroanotacao AND TIPO=@tipo";
List <SqlParameter> paramsList = new List <SqlParameter>();
paramsList.Add(new SqlParameter("@codpessoa", obj.PersonId));
paramsList.Add(new SqlParameter("@nroanotacao", obj.Nro));
paramsList.Add(new SqlParameter("@texto", obj.Content));
paramsList.Add(new SqlParameter("@dtanotacao", obj.Date));
paramsList.Add(new SqlParameter("@dtresolucao", obj.ResolutionDate == null ? (object)DBNull.Value : obj.ResolutionDate));
paramsList.Add(new SqlParameter("@tipo", obj.AnnotationTypeId));
paramsList.Add(new SqlParameter("@recmodifiedby", authUser.CodUsuario));
paramsList.Add(new SqlParameter("@recmodifiedon", DateTime.Now));
SqlParameter[] parameters = paramsList.ToArray();
int nRowUpdated = Db.Database.ExecuteSqlCommand(sql, parameters);
return(obj);
}
public AnnotationSave Save(AnnotationSave obj, AuthUser authUser)
{
var sql = "INSERT INTO PANOTAC (CODPESSOA, NROANOTACAO, TEXTO, DTANOTACAO, DTRESOLUCAO, TIPO, RECCREATEDBY, RECCREATEDON, RECMODIFIEDBY, RECMODIFIEDON) VALUES (@codpessoa, @nroanotacao, @texto, @dtanotacao, @dtresolucao, @tipo, @reccreatedby, @reccreatedon, @recmodifiedby, @recmodifiedon)";
List <SqlParameter> paramsList = new List <SqlParameter>();
paramsList.Add(new SqlParameter("@codpessoa", obj.PersonId));
paramsList.Add(new SqlParameter("@nroanotacao", obj.Nro));
paramsList.Add(new SqlParameter("@texto", obj.Content));
paramsList.Add(new SqlParameter("@dtanotacao", obj.Date));
paramsList.Add(new SqlParameter("@dtresolucao", obj.ResolutionDate == null ? (object)DBNull.Value : obj.ResolutionDate));
paramsList.Add(new SqlParameter("@tipo", obj.AnnotationTypeId));
paramsList.Add(new SqlParameter("@reccreatedby", authUser.CodUsuario));
paramsList.Add(new SqlParameter("@reccreatedon", DateTime.Now));
paramsList.Add(new SqlParameter("@recmodifiedby", authUser.CodUsuario));
paramsList.Add(new SqlParameter("@recmodifiedon", DateTime.Now));
SqlParameter[] parameters = paramsList.ToArray();
int nRowInserted = Db.Database.ExecuteSqlCommand(sql, parameters);
return(obj);
}
public Annotation Update(AnnotationSave obj, AuthUser authUser)
{
return(_employeeService.Update(obj, authUser));
}
