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