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());
}
