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); }