public JObject GetSkills(string connectionString, int accountId, int skillId = 0)
{
try
{
if (accountId == 0)
{
_helper.CreateProperty(UDC.Label.SUCCESS, false);
_helper.CreateProperty(UDC.Label.MESSAGE, "AccountId is mandatory");
}
else
{
DataAccessLayer.Skill skillObj = new DataAccessLayer.Skill(connectionString);
System.Data.DataSet ds = skillObj.GetSkills(accountId, skillId);
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 JObject Update(String connection, UDC.Skill skillEntity)
{
try
{
if (skillEntity.Id == 0)
{
_helper.CreateProperty(UDC.Label.SUCCESS, false);
_helper.CreateProperty(UDC.Label.MESSAGE, "Id is mandatory");
}
else
{
DataAccessLayer.Skill skillObj = new DataAccessLayer.Skill(connection);
DataSet ds = new DataSet();
ds = skillObj.Update(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 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());
}