public QuestionModel QuestionUpdate(QuestionModel model)
{
QuestionModel data = new QuestionModel();
using (evergreenfeedback_androidEntities context = new evergreenfeedback_androidEntities())
{
questionmaster response = new questionmaster();
response.StoreId = model.StoreId;
response.PositionId = model.PositionId;
response.id = model.id;
response.Question = model.Question;
response.IsActive = model.IsActive;
context.Entry(response).State = System.Data.Entity.EntityState.Modified;
var result = context.SaveChanges();
int id = response.id;
if (result > 0)
{
var resultData = context.questionmasters.Where(s => s.id == id).FirstOrDefault();
if (resultData != null)
{
data.id = resultData.id;
data.PositionId = (int)resultData.PositionId;
data.Question = resultData.Question;
data.StoreId = (int)resultData.StoreId;
data.IsActive = resultData.IsActive;
}
}
}
return(data);
}
public QuestionModel AddQuestion(QuestionModel model)
{
QuestionModel response = new QuestionModel();
using (evergreenfeedback_androidEntities context = new evergreenfeedback_androidEntities())
{
var qestionid = context.questionmasters.OrderByDescending(o => o.CreatedOn).Select(p => p.PositionId).FirstOrDefault();
questionmaster data = new questionmaster();
data.PositionId = qestionid + 1;
data.Question = model.Question;
data.StoreId = model.StoreId;
data.IsActive = model.IsActive;
context.questionmasters.Add(data);
var result = context.SaveChanges();
int id = data.id;
if (result > 0)
{
var resultData = context.questionmasters.Where(s => s.id == id).FirstOrDefault();
response.id = resultData.id;
response.PositionId = (int)resultData.PositionId;
response.Question = resultData.Question;
response.StoreId = (int)resultData.StoreId;
response.IsActive = resultData.IsActive;
}
}
return(response);
}
public QuestionModel QuestionDisableEnable(QuestionModel model)
{
QuestionModel response = new QuestionModel();
using (evergreenfeedback_androidEntities context = new evergreenfeedback_androidEntities())
{
questionmaster data = new questionmaster();
data.id = model.id;
data.StoreId = model.StoreId;
data.IsActive = model.IsActive;
context.questionmasters.Attach(data);
context.Entry(data).Property(x => x.IsActive).IsModified = true;
var result = context.SaveChanges();
int id = data.id;
if (result > 0)
{
var resultData = context.questionmasters.Where(s => s.id == id).Select(t => new QuestionModel()
{
id = t.id,
PositionId = (int)t.PositionId,
Question = t.Question,
StoreId = (int)t.StoreId,
IsActive = t.IsActive
}).FirstOrDefault();
response = resultData;
}
}
return(response);
}
