public override SqlParameter[] CreateParameters(MasterVO vo, ActionDatabaseENUM action)
{
if (action == ActionDatabaseENUM.insert)
{
SqlParameter[] parameters =
{
new SqlParameter("@name", (vo as TypesVO).Name),
new SqlParameter("@description", (vo as TypesVO).Description),
new SqlParameter("@action", (vo as TypesVO).Action)
};
return(parameters);
}
else if (action == ActionDatabaseENUM.update)
{
SqlParameter[] parameters =
{
new SqlParameter("@id", (vo as TypesVO).Id),
new SqlParameter("@name", (vo as TypesVO).Name),
new SqlParameter("@description", (vo as TypesVO).Description),
new SqlParameter("@action", (vo as TypesVO).Action)
};
return(parameters);
}
else
{
throw new Exception("Escolha um método válido para executar.");
}
}
public override SqlParameter[] CreateParameters(MasterVO vo, ActionDatabaseENUM action)
{
if (action == ActionDatabaseENUM.insert)
{
SqlParameter[] parameters =
{
new SqlParameter("@name", (vo as InvestmentsVO).Name),
new SqlParameter("@userId", (vo as InvestmentsVO).UserId),
new SqlParameter("@value", (vo as InvestmentsVO).Value),
new SqlParameter("@start", (vo as InvestmentsVO).StartDate),
new SqlParameter("@end", (vo as InvestmentsVO).EndDate),
};
return(parameters);
}
else if (action == ActionDatabaseENUM.update)
{
SqlParameter[] parameters =
{
new SqlParameter("@id", (vo as InvestmentsVO).Id),
new SqlParameter("@name", (vo as InvestmentsVO).Name),
new SqlParameter("@userId", (vo as InvestmentsVO).UserId),
new SqlParameter("@value", (vo as InvestmentsVO).Value),
new SqlParameter("@start", (vo as InvestmentsVO).StartDate),
new SqlParameter("@end", (vo as InvestmentsVO).EndDate),
};
return(parameters);
}
else
{
throw new Exception("Escolha um método válido para executar.");
}
}
public override SqlParameter[] CreateParameters(MasterVO vo, ActionDatabaseENUM action)
{
if (action == ActionDatabaseENUM.insert)
{
SqlParameter[] parameters =
{
new SqlParameter("@name", (vo as UsersVO).Name),
new SqlParameter("@picture", (vo as UsersVO).Picture),
new SqlParameter("@dateBirth", (vo as UsersVO).DateBirth),
new SqlParameter("@password", (vo as UsersVO).Password),
};
return(parameters);
}
else if (action == ActionDatabaseENUM.update)
{
SqlParameter[] parameters =
{
new SqlParameter("@id", (vo as UsersVO).Id),
new SqlParameter("@name", (vo as UsersVO).Name),
new SqlParameter("@picture", (vo as UsersVO).Picture),
new SqlParameter("@dateBirth", (vo as UsersVO).DateBirth),
new SqlParameter("@password", (vo as UsersVO).Password),
};
return(parameters);
}
else
{
throw new Exception("Escolha um método válido para executar.");
}
}
public abstract SqlParameter[] CreateParameters(MasterVO vo, ActionDatabaseENUM action);
