public Result <Skill> Save(Skill userinfo)
{
var result = new Result <Skill>();
try
{
DbContext.Skills.FirstOrDefault(u => u.SkillId == userinfo.SkillId);
var objtosave = DbContext.Skills.FirstOrDefault(u => u.SkillId == userinfo.SkillId);
if (objtosave == null)
{
objtosave = new Skill();
DbContext.Skills.Add(objtosave);
}
objtosave.SkillName = userinfo.SkillName;
objtosave.CategoryId = userinfo.CategoryId;
if (!IsValid(objtosave, result))
{
return(result);
}
DbContext.SaveChanges();
}
catch (Exception ex)
{
result.HasError = true;
result.Message = ex.Message;
}
return(result);
}
private bool IsValid(Skill obj, Result <Skill> result)
{
if (!ValidationHelper.IsStringValid(obj.SkillName))
{
result.HasError = true;
result.Message = "Invalid SkillName";
return(false);
}
if (!ValidationHelper.IsStringValid(obj.CategoryId.ToString()))
{
result.HasError = true;
result.Message = "Invalid CategoryId";
return(false);
}
return(true);
}
private Skill ConvertToEntity(DataRow row)
{
try
{
Skill u = new Skill();
u.SkillId = Int32.Parse(row["SkillID"].ToString());
u.CategoryId = Int32.Parse(row["CategoryID"].ToString());
u.SkillName = row["SkillName"].ToString();
return(u);
}
catch (Exception)
{
return(null);
}
}
public List <Skill> GetAll()
{
var result = new List <Skill>();
try
{
string query = "select * from Skill";
var dt = DataAccess.GetDataTable(query);
if (dt != null && dt.Rows.Count != 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Skill u = ConvertToEntity(dt.Rows[i]);
result.Add(u);
}
}
}
catch (Exception ex)
{
return(result);
}
return(result);
}