public async Task <bool> SaveDataInDatabase(TitleAndQuestions model)
{
bool status = false;
using (SqlConnection MyConnection = new SqlConnection("data source=AMX-MANIKANDAN;database=FEEDBACK_SYSTEM;User Id=sa;Password=sa5"))
{
MyConnection.Open();
//if (model.LoginHistoryId > 0)
//{
using (SqlCommand MyCommand = new SqlCommand("update Tbl_FeedBack_QuestionsAndComments set question=' " + model.Question + "' where questionId =' " + model.QuestionId + "' ", MyConnection))
{
await MyCommand.ExecuteNonQueryAsync();
status = true;
}
//}
//else
//{
// string query = "insert into LogIn_History_Table values('" + model.UserName + "','" + model.UserPassword + "')";
// SqlCommand MyCommand = new SqlCommand(query, MyConnection);
// MyCommand.ExecuteNonQuery();
// status = true;
//}
MyConnection.Close();
}
return(status);
}
public async Task <bool> SaveDataInDatabaseFromHome(TitleAndQuestions model, IAddTitleAndQuestions repository)
{
return(await repository.SaveDataInDatabase(model));
}
public async Task <JsonResult> SaveDataInDatabase(TitleAndQuestions model)
{
return(Json(await service.SaveDataInDatabaseFromHome(model, repository), JsonRequestBehavior.AllowGet));
}
