public DataSet DeleteSkillGroup(UDC.SkillGroup skillGroupEntity, int accountId) { try { _sqlCommand = new SqlCommand(UDC.StoredProcedures.DELETE_SKILLGROUP, Connection); _sqlCommand.CommandType = CommandType.StoredProcedure; _sqlCommand.Parameters.Add(UDC.DataBaseParameters.SKILL_GROUP_ID, SqlDbType.Int).Value = skillGroupEntity.Id; _sqlCommand.Parameters.Add(UDC.DataBaseParameters.ACCOUNT_ID, SqlDbType.Int).Value = accountId; _sqlCommand.Parameters.Add(UDC.DataBaseParameters.SUCCESS, SqlDbType.Bit).Direction = ParameterDirection.Output; _sqlCommand.Parameters.Add(UDC.DataBaseParameters.MESSAGE, SqlDbType.VarChar, 1000).Direction = ParameterDirection.Output; _sqlDataAdapter = new SqlDataAdapter(_sqlCommand); _sqlDataAdapter.Fill(_dataSet = new DataSet()); _dataSet.Tables.Add(_helper.ConvertOutputParametersToDataTable(_sqlCommand.Parameters)); } catch (Exception e) { Utilities.Logger.Error(e.ToString()); ErrorMessage = e.Message; throw; } finally { _sqlCommand = null; _sqlDataAdapter = null; } return(_dataSet); }
public JObject DeleteSkillGroup(string connectionString, UDC.SkillGroup skillGroupEntity, int accountId) { try { if (skillGroupEntity.Id == 0) { _helper.CreateProperty(UDC.Label.SUCCESS, false); _helper.CreateProperty(UDC.Label.MESSAGE, "GroupId is mandatory"); } else { DataAccessLayer.SkillGroup skillObj = new DataAccessLayer.SkillGroup(connectionString); System.Data.DataSet ds = skillObj.DeleteSkillGroup(skillGroupEntity, accountId); if (ds.IsNull()) { _helper.CreateProperty(UDC.Label.SUCCESS, false); _helper.CreateProperty(UDC.Label.MESSAGE, skillObj.ErrorMessage); } else { _helper.ParseDataSet(ds); } } } catch (Exception e) { Utilities.Logger.Error(e.ToString()); _helper.InitializeResponseVariables(); _helper.CreateProperty(UDC.Label.SUCCESS, false); _helper.CreateProperty(UDC.Label.MESSAGE, e.Message); } return(_helper.GetResponse()); }
public DataSet UpdateSkillGroup(DataTable table, UDC.SkillGroup skillGroupEntity) { try { _sqlCommand = new SqlCommand(UDC.StoredProcedures.CREATE_OR_EDIT_SKILLGROUP, Connection); _sqlCommand.CommandType = CommandType.StoredProcedure; _sqlCommand.Parameters.Add(UDC.DataBaseParameters.AGENT_ID, SqlDbType.Int).Value = skillGroupEntity.AgentId; _sqlCommand.Parameters.Add(UDC.DataBaseParameters.SKILL_GROUP_SKILL_IDS, SqlDbType.Structured).Value = table; _sqlCommand.Parameters.Add(UDC.DataBaseParameters.SKILL_GROUP_ID, SqlDbType.Int).Value = skillGroupEntity.Id; _sqlCommand.Parameters.Add(UDC.DataBaseParameters.SKILL_GROUP_NAME, SqlDbType.VarChar).Value = skillGroupEntity.Name; _sqlCommand.Parameters.Add(UDC.DataBaseParameters.DESCRIPTION, SqlDbType.VarChar).Value = skillGroupEntity.Description; _sqlCommand.Parameters.Add(UDC.DataBaseParameters.ACCOUNT_ID, SqlDbType.Int).Value = skillGroupEntity.AccountId; _sqlCommand.Parameters.Add(UDC.DataBaseParameters.SUCCESS, SqlDbType.Bit).Direction = ParameterDirection.Output; _sqlCommand.Parameters.Add(UDC.DataBaseParameters.MESSAGE, SqlDbType.VarChar, 1000).Direction = ParameterDirection.Output; //_sqlDataAdapter = new SqlDataAdapter(_sqlCommand); //_sqlDataAdapter.Fill(_dataSet = new DataSet()); Connection.Open(); _sqlCommand.ExecuteNonQuery(); Connection.Close(); _dataSet = new DataSet(); _dataSet.Tables.Add(_helper.ConvertOutputParametersToDataTable(_sqlCommand.Parameters)); } catch (Exception e) { Utilities.Logger.Error(e.ToString()); ErrorMessage = e.Message; throw; } finally { _sqlCommand = null; _sqlDataAdapter = null; } return(_dataSet); }
public JObject Create(string connectionString, UDC.SkillGroup skillGroupEntity, string ids) { try { if (skillGroupEntity.AccountId == 0) { _helper.CreateProperty(UDC.Label.SUCCESS, false); _helper.CreateProperty(UDC.Label.MESSAGE, "AccountId is mandatory"); } else if (skillGroupEntity.Name == null || skillGroupEntity.Name.Trim().Length == 0) { _helper.CreateProperty(UDC.Label.SUCCESS, false); _helper.CreateProperty(UDC.Label.MESSAGE, "Group name is mandatory"); } else { DataTable table = GetTable(ids); DataAccessLayer.SkillGroup skillObj = new DataAccessLayer.SkillGroup(connectionString); System.Data.DataSet ds = skillObj.Create(skillGroupEntity, table); if (ds.IsNull()) { _helper.CreateProperty(UDC.Label.SUCCESS, false); _helper.CreateProperty(UDC.Label.MESSAGE, skillObj.ErrorMessage); } else { _helper.ParseDataSet(ds); } } } catch (Exception e) { Utilities.Logger.Error(e.ToString()); _helper.InitializeResponseVariables(); _helper.CreateProperty(UDC.Label.SUCCESS, false); _helper.CreateProperty(UDC.Label.MESSAGE, e.Message); } return(_helper.GetResponse()); }