public QuestionTypeDTO GetById(int entityId)
{
QuestionTypeDTO item = new QuestionTypeDTO();
string connectionString = ConnectionStringHelper.GetConnStringFromConfigFile();
string commandText = "SELECT * FROM [dbo].[QuestionTypes] WHERE [QuestionTypeId] = @entityId";
SqlParameter parameter = new SqlParameter("@entityId", entityId);
using (SqlDataReader reader = CommandHelper.ExecuteReader(connectionString, commandText, CommandType.Text, parameter))
{
if (reader.HasRows)
{
item = new QuestionTypeDTO
{
QuestionTypeId = (int)reader["QuestionTypeId"],
Description = reader["Description"].ToString(),
};
}
else
{
Console.WriteLine("Id not found");
}
return(item);
}
}
public void Update(QuestionTypeDTO questionTypeDTO)
{
QuestionType questionType = Mapper.Map <QuestionType>(questionTypeDTO);
_unitOfWork.QuestionTypes.Update(questionType);
_unitOfWork.Save();
}
public static QuestionType QuestionTypeDTOToEntity(QuestionTypeDTO dtoObject)
{
return(new QuestionType
{
QuestionTypeId = dtoObject.QuestionTypeId,
Description = dtoObject.Description,
CreateDate = dtoObject.CreateDate
});
}
public ActionResult Create([Bind(Include = "Name")] QuestionTypeVM questionTypeVM)
{
if (ModelState.IsValid)
{
QuestionTypeDTO questionTypeDTO = Mapper.Map <QuestionTypeDTO>(questionTypeVM);
QuestionTypeService.Add(questionTypeDTO);
return(RedirectToAction("Index"));
}
return(View());
}
public void Add(QuestionTypeDTO entity)
{
QuestionType result = DataConverter.QuestionTypeDTOToEntity(entity);
using (var context = new DemoContext())
{
context.QuestionTypes.Add(result);
context.SaveChanges();
}
}
public void Add(QuestionTypeDTO entity)
{
string connectionString = ConnectionStringHelper.GetConnStringFromConfigFile();
string commandText = "INSERT INTO [dbo].[QuestionTypes]([Description])VALUES(@Description)";
SqlParameter parameter = new SqlParameter("@Description", entity.Description);
int rows = CommandHelper.ExecuteNonQuery(connectionString, commandText, CommandType.Text, parameter);
Console.WriteLine("{0} row(s) inserted", rows);
}
public void Update(QuestionTypeDTO entity)
{
QuestionType result = DataConverter.QuestionTypeDTOToEntity(entity);
using (var context = new DemoContext())
{
var found = context.QuestionTypes.Find(result.QuestionTypeId);
found.Description = entity.Description;
context.SaveChanges();
}
}
public void Update(QuestionTypeDTO entity)
{
SqlParameter[] parameter = new SqlParameter[2];
string connectionString = ConnectionStringHelper.GetConnStringFromConfigFile();
string commandText = "UPDATE [dbo].[QuestionTypes] SET [Description] = @Description WHERE [QuestionTypeId] = @entityId";
parameter[0] = new SqlParameter("@Description", entity.Description);
parameter[1] = new SqlParameter("@entityId", entity.QuestionTypeId);
int count = CommandHelper.ExecuteNonQuery(connectionString, commandText, CommandType.Text, parameter);
Console.WriteLine("Items modified: {0}", count);
}
private static QuestionType ConvertDto(QuestionTypeDTO q, QuestionType instance)
{
instance = instance ?? new QuestionType();
instance.IsActive = q.isActive;
instance.Type = q.type;
instance.QuestionTypeOrder = q.questionTypeOrder;
instance.QuestionTypeDescription = q.questionTypeDescription;
instance.Instruction = q.instruction;
instance.CorrectText = q.correctText;
instance.IncorrectMessage = q.incorrectMessage;
instance.IconSource = q.iconSource;
return(instance);
}
public ActionResult Edit(int?id)
{
try
{
QuestionTypeDTO questionTypeDTO = QuestionTypeService.Get(id);
QuestionTypeVM questionTypeVM = Mapper.Map <QuestionTypeVM>(questionTypeDTO);
return(View(questionTypeVM));
}
catch (ArgumentNullException)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
catch (NotFoundException)
{
return(HttpNotFound());
}
}
public QuestionTypeDTO Save(QuestionTypeDTO resultDto)
{
ValidationResult validationResult;
if (this.IsValid(resultDto, out validationResult))
{
var typeModel = this.QuestionTypeModel;
var isTransient = resultDto.questionTypeId == 0;
var convertDto = isTransient ? null : typeModel.GetOneById(resultDto.questionTypeId).Value;
convertDto = ConvertDto(resultDto, convertDto);
typeModel.RegisterSave(convertDto);
return(new QuestionTypeDTO(convertDto));
}
var error = this.GenerateValidationError(validationResult);
this.LogError("QuestionType.Save", error);
throw new FaultException <Error>(error, error.errorMessage);
}
public static List <QuestionTypeDTO> getQuestionTypes()
{
List <QuestionTypeDTO> questionTypes = new List <QuestionTypeDTO>();
using (SqlConnection connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["connectionRRHHDatabase"].ConnectionString))
{
SqlCommand command = new SqlCommand("usp_get_questionTypes", connection);
command.CommandType = CommandType.StoredProcedure;
command.Connection.Open();
SqlDataReader rdr = command.ExecuteReader();
while (rdr.Read())
{
QuestionTypeDTO questionType = new QuestionTypeDTO();
questionType.id_questionType = rdr["id_questionType"].ToString();
questionType.name = rdr["name"].ToString();
questionTypes.Add(questionType);
}
};
return(questionTypes);
}
