public static new IEnumerable<QueState> GetList() { var dt = Db.SpeCalc.ExecuteQueryStoredProcedure("get_question_state"); var lst = new List<QueState>(); foreach (DataRow row in dt.Rows) { var model = new QueState(row); lst.Add(model); } return lst; }
private void FillSelf(DataRow row) { Id = Db.DbHelper.GetValueInt(row["id"]); Manager = new Employee(row["manager_sid"].ToString()); DateLimit = Db.DbHelper.GetValueDateTime(row["date_limit"]); Descr = row["descr"].ToString(); State = new QueState(Db.DbHelper.GetValueInt(row["id_que_state"])); DateCreate = Db.DbHelper.GetValueDateTime(row["dattim1"]); //State = new QueState() { Id = Db.DbHelper.GetValueInt(row["id_que_state"]), Name = row["que_state"].ToString() }; }
public void Save() { if (Id <= 0) this.State = new QueState().GetFirstState(); SqlParameter pId = new SqlParameter() { ParameterName = "id", SqlValue = Id, SqlDbType = SqlDbType.Int }; SqlParameter pManagerAdSid = new SqlParameter() { ParameterName = "manager_sid", SqlValue = Manager.AdSid, SqlDbType = SqlDbType.VarChar }; SqlParameter pDateLimit = new SqlParameter() { ParameterName = "date_limit", SqlValue = DateLimit, SqlDbType = SqlDbType.DateTime }; SqlParameter pDescr = new SqlParameter() { ParameterName = "descr", SqlValue = Descr, SqlDbType = SqlDbType.NVarChar }; SqlParameter pCreatorAdSid = new SqlParameter() { ParameterName = "creator_sid", SqlValue = CurUserAdSid, SqlDbType = SqlDbType.VarChar }; SqlParameter pIdQueState = new SqlParameter() { ParameterName = "id_que_state", SqlValue = State.Id, SqlDbType = SqlDbType.Int }; var dt = Db.SpeCalc.ExecuteQueryStoredProcedure("save_question", pId, pManagerAdSid, pDateLimit, pDescr, pCreatorAdSid, pIdQueState); if (dt.Rows.Count > 0) { int id; int.TryParse(dt.Rows[0]["id"].ToString(), out id); Id = id; SetQuestionState(id, new QueState().GetFirstState().Id, null, CurUserAdSid); } }
public static QueState GetQuestionCurrState(int? idQuestion) { var state = new QueState(); SqlParameter pId = new SqlParameter() { ParameterName = "id_question", SqlValue = idQuestion, SqlDbType = SqlDbType.Int }; var dt = Db.SpeCalc.ExecuteQueryStoredProcedure("get_question_curr_state", pId); if (dt.Rows.Count > 0) { var row = dt.Rows[0]; state = new QueState(row); } return state; }