public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_TRADUCCION_PR"
};
var c = (Traduccion)entity;
operation.AddIntParam(DB_COL_PALABRAID, c.palabraId);
operation.AddVarcharParam(DB_COL_USUARIOID, c.usuarioId);
operation.AddIntParam(DB_COL_DICCIONARIOID, c.diccionarioId);
operation.AddDatetimeParam(DB_COL_FECHA, c.fecha);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_TRANSLATION_HISTORY_PR"
};
var c = (TranslationsHistory)entity;
operation.AddVarcharParam(DB_COL_WORD, c.word);
operation.AddDatetimeParam(DB_COL_TRANSLATED_DATE, c.translatedDate);
operation.AddVarcharParam(DB_COL_TRANSLATED_WORD, c.translatedWord);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_TRANSLATION_HISTORY_PR"
};
var c = (TranslationsHistory)entity;
operation.AddVarcharParam(DB_COL_WORD, c.word);
operation.AddDatetimeParam(DB_COL_TRANSLATED_DATE, c.translatedDate);
operation.AddVarcharParam(DB_COL_TRANSLATED_WORD, c.translatedWord);
operation.AddIntParam(DB_COL_FK_USER_ID, c.FkUserId);
operation.AddIntParam(DB_COL_FK_LANGUAUGE_ID, c.FkLanguagueId);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_TRANSLATION_PR"
};
var c = (Translations)entity;
operation.AddIntParam(DB_COL_TRANSLATION_AMOUNT, c.translationAmount);
operation.AddVarcharParam(DB_COL_WORD, c.word);
operation.AddDatetimeParam(DB_COL_TRANSLATED_DATE, c.translatedDate);
operation.AddVarcharParam(DB_COL_TRANSLATED_WORD, c.translatedWord);
operation.AddIntParam(DB_COL_FK_LANGUAGUE_ID, c.FkLanguagueId);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_LOG_PR"
};
var c = (Log)entity;
operation.AddVarcharParam(DB_COL_USUARIOID, c.usuarioId);
operation.AddIntParam(DB_COL_DICCIONARIOID, c.diccionarioId);
operation.AddDatetimeParam(DB_COL_FECHA, c.fecha);
operation.AddVarcharParam(DB_COL_FRASE, c.frase.ToLower());
operation.AddVarcharParam(DB_COL_TRADUCCION, c.traduccion.ToLower());
operation.AddIntParam(DB_COL_POPULARIDAD, c.popularidad);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_CUSTOMER_PR"
};
var c = (Customer)entity;
operation.AddVarcharParam(DB_COL_ID, c.Id);
operation.AddVarcharParam(DB_COL_NAME, c.Name);
operation.AddVarcharParam(DB_COL_LAST_NAME, c.LastName);
operation.AddIntParam(DB_COL_AGE, c.Age);
operation.AddDatetimeParam(DB_COL_BORN_DATE, c.BornDate);
operation.AddVarcharParam(DB_COL_CIVIL_STATUS, c.CivilStatus);
operation.AddVarcharParam(DB_COL_GENDER, c.Gender);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_CREDIT_PR"
};
var c = (Credit)entity;
operation.AddIntParam(DB_COL_CREDIT_ID, c.CreditId);
operation.AddDoubleParam(DB_COL_AMOUNT, c.Amount);
operation.AddDoubleParam(DB_COL_RATE, c.Rate);
operation.AddVarcharParam(DB_COL_NAME, c.Name);
operation.AddDoubleParam(DB_COL_FEE, c.Fee);
operation.AddDatetimeParam(DB_COL_START_DATE, c.StartDate);
operation.AddVarcharParam(DB_COL_STATUS, c.Status);
operation.AddDoubleParam(DB_COL_OPERATIONAL_BALANCE, c.OperationalBalance);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_USUARIO_PR"
};
var u = (Usuario)entity;
operation.AddVarcharParam(DB_COL_CEDULA, u.cedula);
operation.AddVarcharParam(DB_COL_NOMBRE, u.nombre);
operation.AddVarcharParam(DB_COL_PRIMERAPELLIDO, u.apellido1);
operation.AddVarcharParam(DB_COL_SEGUNDOAPELLIDO, u.apellido2);
operation.AddDatetimeParam(DB_COL_FECHANACIMIENTO, u.dob);
operation.AddVarcharParam(DB_COL_CORREOUSUARIO, u.correoUsuario);
operation.AddVarcharParam(DB_COL_CONTRASENA, u.contrasena);
operation.AddIntParam(DB_COL_TELEFONO, u.telefono);
operation.AddVarcharParam(DB_COL_ESTADOUSUARIO, u.estadoUsuario);
operation.AddIntParam(DB_COL_IDROL, u.idRol);
return(operation);
}
