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