public HttpResponseMessage Save(Question model) { HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.Created); try { model.CurUserAdSid = GetCurUser().Sid; model.Save(); response.Content = new StringContent(String.Format("{{\"id\":{0}, \"sid\":\"{1}\"}}", model.Id, model.CurUserAdSid)); } catch (Exception ex) { response = new HttpResponseMessage(HttpStatusCode.OK); response.Content = new StringContent(MessageHelper.ConfigureExceptionMessage(ex)); } return response; }
public static IEnumerable<Question> GetList(AdUser curUser, int? id = null, string managerSid = null, string queStates = null, int? top = null, string prodSid = null) { if (!top.HasValue) top = 30; SqlParameter pId = new SqlParameter() { ParameterName = "id", SqlValue = id, SqlDbType = SqlDbType.Int }; SqlParameter pManagerSid = new SqlParameter() { ParameterName = "manager_sid", SqlValue = managerSid, SqlDbType = SqlDbType.VarChar }; SqlParameter pQueStates = new SqlParameter() { ParameterName = "lst_que_states", SqlValue = queStates, SqlDbType = SqlDbType.NVarChar }; SqlParameter pTop = new SqlParameter() { ParameterName = "top", SqlValue = top, SqlDbType = SqlDbType.Int }; SqlParameter pProdSid = new SqlParameter() { ParameterName = "prod_sid", SqlValue = prodSid, SqlDbType = SqlDbType.VarChar }; if (!AdHelper.UserInGroup(curUser.User, AdGroup.SuperAdmin, AdGroup.SpeCalcKontroler)) { if (AdHelper.UserInGroup(curUser.User, AdGroup.SpeCalcManager)) { pManagerSid.SqlValue = curUser.Sid; } if (AdHelper.UserInGroup(curUser.User, AdGroup.SpeCalcProduct)) { pProdSid.SqlValue = curUser.Sid; } } var dt = Db.SpeCalc.ExecuteQueryStoredProcedure("get_question", pId, pManagerSid, pQueStates, pTop, pProdSid); var lst = new List<Question>(); foreach (DataRow row in dt.Rows) { var model = new Question(row); lst.Add(model); } return lst; }
public Question Get(int id) { var curSid = GetCurUser().Sid; var model = new Question(id) { CurUserAdSid = curSid }; return model; }
private void FillSelf(DataRow row) { Id = Db.DbHelper.GetValueInt(row["id"]); Question = new Question() { Id = Db.DbHelper.GetValueInt(row["id_question"]) }; string adSid = row["user_sid"].ToString(); User = new Employee(adSid); Descr = row["descr"].ToString(); QuePosAnswers = QuePosAnswer.GetList(Id); }