public JObject Delete(String connection, UDC.Skill skillEntity)
{
try
{
if (skillEntity.AccountId == 0)
{
_helper.CreateProperty(UDC.Label.SUCCESS, false);
_helper.CreateProperty(UDC.Label.MESSAGE, "AccountId is mandatory");
}
else
{
Press3.DataAccessLayer.Skill skillObj = new Press3.DataAccessLayer.Skill(connection);
System.Data.DataSet ds = skillObj.Delete(skillEntity);
if (ds == null)
{
_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 Update(UDC.Skill skillEntity)
{
try
{
_sqlCommand = new SqlCommand(UDC.StoredProcedures.CREATE_OR_EDIT_SKILL, Connection);
_sqlCommand.CommandType = CommandType.StoredProcedure;
_sqlCommand.Parameters.Add(UDC.DataBaseParameters.ACCOUNT_ID, SqlDbType.Int).Value = skillEntity.AccountId;
_sqlCommand.Parameters.Add(UDC.DataBaseParameters.AGENT_ID, SqlDbType.Int).Value = skillEntity.AgentId;
_sqlCommand.Parameters.Add(UDC.DataBaseParameters.SKILL_ID, SqlDbType.Int).Value = skillEntity.Id;
_sqlCommand.Parameters.Add(UDC.DataBaseParameters.SKILL_NAME, SqlDbType.VarChar, 50).Value = skillEntity.Name;
_sqlCommand.Parameters.Add(UDC.DataBaseParameters.DESCRIPTION, SqlDbType.VarChar, 1000).Value = skillEntity.Description;
_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.Skill skillEntity)
{
try
{
if (skillEntity.AccountId == 0)
{
_helper.CreateProperty(UDC.Label.SUCCESS, false);
_helper.CreateProperty(UDC.Label.MESSAGE, "AccountId is mandatory");
}
else if (skillEntity.Name == null || skillEntity.Name.Trim().Length == 0)
{
_helper.CreateProperty(UDC.Label.SUCCESS, false);
_helper.CreateProperty(UDC.Label.MESSAGE, "Skill name is mandatory");
}
else
{
DataAccessLayer.Skill skillObj = new DataAccessLayer.Skill(connectionString);
System.Data.DataSet ds = skillObj.Create(skillEntity);
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());
}
