public long AddSublevel(LevelBO objlevelCodes, SqlTransaction objSqlTransaction = null) { try { DBManager objDBManager = new DBManager(objSqlTransaction); //check objDBManager.AddParameter("LevelId", objlevelCodes.LevelId); objDBManager.AddParameter("LevelItemId", objlevelCodes.LevelItemId); objDBManager.AddParameter("LevelItemName", objlevelCodes.LevelItemName); objDBManager.AddParameter("Weightage", objlevelCodes.weightage); objDBManager.AddParameter("CreatedById", objlevelCodes.CreatedById); objDBManager.AddParameter("CreatedDate", objlevelCodes.CreatedDate); objDBManager.ExecuteNonQuery("LevelItems_Add"); return(long.Parse(objDBManager.Parameters[0].Value.ToString())); } catch (Exception ex) { throw ex; } }
public int DeleteSublevel(LevelBO objlevelCodes, SqlTransaction objSqlTransaction = null) {// need check try { DBManager objDBManager = new DBManager(objSqlTransaction); objDBManager.AddParameter("LevelItemId", objlevelCodes.LevelItemId); objDBManager.AddParameter("ModifiedById", objlevelCodes.ModifiedById); objDBManager.AddParameter("ModifiedDate", objlevelCodes.ModifiedDate); return(objDBManager.ExecuteNonQuery("Sublevel_Delete")); } catch (Exception ex) { throw ex; } }
//EditSubLevel public int EditSubLevel(LevelBO objlevelCodes, SqlTransaction objSqlTransaction = null) { try { DBManager objDBManager = new DBManager(); objDBManager.AddParameter("LevelId", objlevelCodes.LevelId); objDBManager.AddParameter("LevelItemId", objlevelCodes.LevelItemId); objDBManager.AddParameter("LevelItemName", objlevelCodes.LevelItemName); objDBManager.AddParameter("Weightage", objlevelCodes.weightage); objDBManager.AddParameter("ModifiedById", objlevelCodes.ModifiedById); objDBManager.AddParameter("ModifiedDate", objlevelCodes.ModifiedDate); return(objDBManager.ExecuteNonQuery("Update_SubLevel")); } catch (Exception ex) { throw ex; } }