public QuestionKit GetById(int id)
{
QuestionKit result = new QuestionKit();
using (IDbConnection conn = Connection)
{
string sql = "select * from QuestionKits where Id = {0}";
sql = string.Format(sql, id);
try
{
conn.Open();
result = conn.Query <QuestionKit>(sql).AsQueryable().FirstOrDefault();
}
catch (SqlException sqlEx)
{
Logger.ErrorException(sqlEx);
}
catch (Exception ex)
{
Logger.ErrorException(ex);
}
finally
{
if (conn != null && conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
}
return(result);
}
public ResponseModel Update(QuestionKit model)
{
var result = new ResponseModel();
using (var db = new KentEntities())
{
try
{
var questionKit = db.QuestionKits.Where(d => d.ID == model.ID).FirstOrDefault();
if (questionKit == null)
{
return(result);
}
questionKit.Name = model.Name;
questionKit.Description = model.Description;
questionKit.LastUpdate = DateTime.Now;
result.Success = db.SaveChanges() > 0 ? true : false;
}
catch (SqlException sqlEx)
{
result.Message = sqlEx.Message;
Logger.ErrorException(sqlEx);
}
catch (Exception ex)
{
result.Message = ex.Message;
Logger.ErrorException(ex);
}
}
return(result);
}
public QuestionKitModel(QuestionKit questionKit)
{
ID = questionKit.ID;
Name = questionKit.Name;
Description = questionKit.Description;
RecordOrder = questionKit.RecordOrder;
Created = questionKit.Created;
CreatedBy = questionKit.CreatedBy;
LastUpdate = questionKit.LastUpdate;
LastUpdateBy = questionKit.LastUpdateBy;
}
public ResponseModel Insert(QuestionKit model)
{
var result = new ResponseModel();
using (var db = new KentEntities())
{
try
{
db.QuestionKits.Add(model);
result.Success = db.SaveChanges() > 0 ? true : false;
}
catch (SqlException sqlEx)
{
result.Message = sqlEx.Message;
Logger.ErrorException(sqlEx);
}
catch (Exception ex)
{
result.Message = ex.Message;
Logger.ErrorException(ex);
}
}
return(result);
}
public ResponseModel Update(QuestionKit model)
{
return(_questionKitRepository.Update(model));
}
public ResponseModel Insert(QuestionKit model)
{
return(_questionKitRepository.Insert(model));
}