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