Notes

package com.highradius.admin.cam.slimfast.dao.impl;
import java.util.List;
import com.highradius.admin.cam.slimfast.dao.CreditSlimfastManageSecurityTypesDao;
import com.highradius.common.util.HRCLog;
import com.highradius.common.util.HRCLogFactory;
import com.highradius.credit.model.MapAccountSecurityType;
import com.receivablesradius.deductions.dao.impl.GenericHibernateDAOImpl;
import com.receivablesradius.deductions.model.SortDTO;
import org.apache.commons.lang.StringUtils;
import org.hibernate.Query;


public class CreditSlimfastManageSecurityTypesDaoImpl extends GenericHibernateDAOImpl implements CreditSlimfastManageSecurityTypesDao {
private static final HRCLog LOGGER = HRCLogFactory.getLog(CreditSlimfastManageSecurityTypesDaoImpl.class);
@Override
public List<MapAccountSecurityType> getSecurityTypes(Integer startIndex, Integer rowsToFetch, Integer fkAccountId,
SortDTO sortObject) {
// TODO Auto-generated method stub
LOGGER.debug("Entered into getSecurityTypes method in DAO");
StringBuffer query = new StringBuffer();
List <MapAccountSecurityType> mapAccountSecurityType = null;
try {
//this query gives those records whose fileUploadType are mentioned in DMS Configuration screen.

String sql = " select * from map_account_security_type AS map where map.is_deleted= 0 AND map.account_id=:id";
query.append(sql);


if(sortObject != null){
sortObject.columnAlias = "map";
String tmp = sortObject.toString();
if (StringUtils.isNotBlank(tmp)) {
query.append(tmp);
}
}
else {
query = query.append(" ORDER BY map.create_time desc ");
}

Query query1 = getSession().createQuery(query.toString());
query1.setInteger("id", fkAccountId);
query1.setFirstResult(startIndex);
query1.setMaxResults(rowsToFetch);
mapAccountSecurityType = query1.list();



} catch (Exception e) {
LOGGER.error("Error in getSecurityTypes method in DAO", e);
}
LOGGER.debug("Finished the getSecurityTypes method in DAO");
return mapAccountSecurityType;
}
@Override
public Boolean deleteSecurityType(String[] toBeDeletedRecordIds) {

LOGGER.debug("Entered into getSecurityTypes method in DAO");
StringBuffer query = new StringBuffer();
try {

for(int i=0;i<toBeDeletedRecordIds.length;i++) {

String sql = " update map_account_security_type AS map set map.is_deleted= 1 where map.pk_map_account_security_type_id=:id";
query.append(sql);


Query query1 = getSession().createQuery(query.toString());
query1.setInteger("id",Integer.parseInt(toBeDeletedRecordIds[i]));
query1.executeUpdate();
}


} catch (Exception e) {
LOGGER.error("Error in getSecurityTypes method in DAO", e);
}
LOGGER.debug("Finished the getSecurityTypes method in DAO");
return true;
}
@Override
public Boolean addSecurityType(MapAccountSecurityType securityType) {
LOGGER.info("Inside addSecurityType");

try {

save(securityType);
return true;

} catch (Exception e) {
LOGGER.error("addSecurityType failure inside CreditSlimfastManageSecurityTypesDaoImpl : ", e);
}
return false;
}
@Override
public Boolean editSecurityType(MapAccountSecurityType securityType) {
LOGGER.info("Inside addSecurityType");

try {

update(securityType);
return true;

} catch (Exception e) {
LOGGER.error("editSecurityType failure inside CreditSlimfastManageSecurityTypesDaoImpl : ", e);
}
return false;
}

}