public static Response SaveChanges(AtestContext db)
{
try
{
db.SaveChanges();
return(new Response {
Succeeded = true
});
}
catch (Exception ex)
{
var response = new Response {
Succeeded = false
};
if (ex.InnerException != null && ex.InnerException.InnerException != null && ex.InnerException.InnerException.Message.Contains("_Index"))
{
response.Message = "this record already exists";
}
else if (ex.InnerException != null && ex.InnerException.InnerException != null && ex.InnerException.InnerException.Message.Contains("REFERENCE"))
{
response.Message = "The record can't be deleted because it has related records.";
}
else
{
response.Message = ex.Message;
}
return(response);
}
}
public static int GetValue(string value, AtestContext db)
{
var testAnswer = db.TestAnswers.Where(s => s.Value == value).FirstOrDefault();
if (testAnswer == null)
{
testAnswer = new TestAnswer {
Value = value,
};
db.TestAnswers.Add(testAnswer);
db.SaveChanges();
}
return(testAnswer.TestAnswerID);
}
public static int GetState(string stateName, AtestContext db)
{
var state = db.States.Where(s => s.StateName == stateName).FirstOrDefault();
if (state == null)
{
state = new State {
StateName = stateName,
};
db.States.Add(state);
db.SaveChanges();
}
return(state.StateID);
}
public ActionResult EditSummaryDetailTmp(int id, string propertyName, string value)
{
var status = false;
var message = "";
//Update to database
using (AtestContext db = new AtestContext())
{
var testSummaryDetailTmp = db.TestSummaryDetailTmps.Find(id);
object updateValue = value;
bool isValid = true;
if (propertyName == "TestAnswerID")
{
int newTestAnswerID = 0;
if (int.TryParse(value, out newTestAnswerID))
{
updateValue = newTestAnswerID;
//update value field
value = db.TestAnswers.Where(a => a.TestAnswerID == newTestAnswerID).First().Value;
}
else
{
isValid = false;
}
}
if (testSummaryDetailTmp != null && isValid)
{
db.Entry(testSummaryDetailTmp).Entity.TestAnswerID = int.Parse(updateValue.ToString());
db.SaveChanges();
status = true;
}
else
{
message = "Error!";
}
}
var response = new { value = value, status = status, message = message };
JObject o = JObject.FromObject(response);
return(Content(o.ToString()));
}
public ActionResult saveuser(int id, string propertyName, string value)
{
var status = false;
var message = "";
//Update to database
using (AtestContext db = new AtestContext())
{
var pruebas = db.Pruebas.Find(id);
object updateValue = value;
bool isValid = true;
if (propertyName == "ListaId")
{
int newListaID = 0;
if (int.TryParse(value, out newListaID))
{
updateValue = newListaID;
//update value field
value = db.Listas.Where(a => a.ListaID == newListaID).First().Valor;
}
else
{
isValid = false;
}
}
if (pruebas != null && isValid)
{
db.Entry(pruebas).Entity.ListaID = int.Parse(updateValue.ToString());
db.SaveChanges();
status = true;
}
else
{
message = "Error!";
}
}
var response = new { value = value, status = status, message = message };
JObject o = JObject.FromObject(response);
return(Content(o.ToString()));
}
public ActionResult GetQuestionDetailTmpAnswer(int id)
{
//{'E':'Letter E','F':'Letter F','G':'Letter G', 'selected':'F'}
int selectedValueID = 0;
StringBuilder sb = new StringBuilder();
using (AtestContext db = new AtestContext())
{
var listValue = db.TestAnswers.OrderBy(a => a.Value).ToList();
foreach (var item in listValue)
{
sb.Append(string.Format("'{0}':'{1}',", item.TestAnswerID, item.Value));
}
selectedValueID = db.TestQuestionDetailTmps.Where(a => a.TestQuestionDetailTmpID == id).First().TestAnswerID;
}
sb.Append(string.Format("'selected': '{0}'", selectedValueID));
return(Content("{" + sb.ToString() + "}"));
}
public ActionResult GetListaValor(int id)
{
//{'E':'Letter E','F':'Letter F','G':'Letter G', 'selected':'F'}
int selectedValorID = 0;
StringBuilder sb = new StringBuilder();
using (AtestContext db = new AtestContext())
{
var listaValor = db.Listas.OrderBy(a => a.Valor).ToList();
foreach (var item in listaValor)
{
sb.Append(string.Format("'{0}':'{1}',", item.ListaID, item.Valor));
}
selectedValorID = db.Pruebas.Where(a => a.PruebaID == id).First().ListaID;
}
sb.Append(string.Format("'selected': '{0}'", selectedValorID));
return(Content("{" + sb.ToString() + "}"));
}
public ActionResult Edit(User user)
{
if (ModelState.IsValid)
{
var db2 = new AtestContext();
var currentUser = db2.Users.Find(user.UserID);
if (currentUser.UserName != user.UserName)
{
UsersHelper.UpdateUserName(currentUser.UserName, user.UserName);
}
db2.Dispose();
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
