public ActionResult GoToEdit(string QuizId)
{
int userId = (int)Session["UserId"];
MakeQuizModel model = new MakeQuizModel();
int qId = int.Parse(QuizId);
model.QuizId = qId;
//選択されたクイズデータをモデルへ
using (var db = new SakanaDBEntities1())
{
model = (from q in db.QUIZ
where q.USER_ID == userId
&& q.DELETE_FLG == 0
&& q.QUIZ_ID==qId
select new MakeQuizModel()
{
QuizName = q.QUIZ_NAME,
QuizDetail =q.QUIZ_DETAIL,
CategoryId = (int)q.CATEGORY_ID,
Answer = q.ANSWER,
AnswerHiragana = q.ANSWER_HIRAGANA,
AnswerDetail=q.ANSWER_DETAIL,
}).First();
}
model.HintList = GetHints(qId);
//カテゴリリストの項目取得
model.CategoryList = MakeCategoryList();
//画像リストの項目取得
//model.PictList = MakePictList();
return View("MakeQuiz", model);
}
/// <summary>
/// PICTから該当ユーザーの画像データを取得
/// </summary>
/// <returns></returns>
private List<PICT> SearchPictData()
{
List<PICT> retList=new List<PICT>();
using (var db = new SakanaDBEntities1())
{
retList = (from b in db.PICT
where b.USER_ID == 1
&& b.DELETE_FLG==0
select b).ToList<PICT>();
}
return retList;
}
/// <summary>
/// クイズ登録
/// </summary>
/// <param name="postedModel"></param>
private void RegisterQuiz(MakeQuizModel postedModel)
{
using (var db = new SakanaDBEntities1())
{
//新規登録
if (postedModel.QuizId == null)
{
//クイズテーブルへのインサート
var inserted = db.QUIZ.Add(new QUIZ()
{
QUIZ_NAME = postedModel.QuizName,
QUIZ_DETAIL = postedModel.QuizDetail,
USER_ID = (int)Session["UserId"],
CHALLENGE_NUM = 0,
CLEAR_NUM = 0,
CATEGORY_ID = postedModel.CategoryId,
ANSWER = postedModel.Answer,
ANSWER_HIRAGANA = postedModel.AnswerHiragana,
ANSWER_DETAIL = postedModel.AnswerDetail,
CREATED_DT = DateTime.Now,
EDITED_DT = DateTime.Now,
DELETE_FLG = 0
});
//クイズ画像テーブルへのインサート
int i = 1;
foreach (var hint in postedModel.HintList)
{
db.QUIZ_PICT.Add(new QUIZ_PICT()
{
QUIZ_ID = inserted.QUIZ_ID,
HINT_SEQ = i,
PICT_ID = hint.PictId,
HINT_TXT = hint.HintTxt
});
i++;
}
}
//編集
else
{
//クイズテーブル更新
var targetQUIZ = db.QUIZ.Single(q => q.QUIZ_ID==postedModel.QuizId);
targetQUIZ.QUIZ_NAME = postedModel.QuizName;
targetQUIZ.QUIZ_DETAIL = postedModel.QuizName;
targetQUIZ.CATEGORY_ID = postedModel.CategoryId;
targetQUIZ.ANSWER = postedModel.Answer;
targetQUIZ.ANSWER_HIRAGANA = postedModel.AnswerHiragana;
targetQUIZ.ANSWER_DETAIL = postedModel.AnswerDetail;
targetQUIZ.EDITED_DT = DateTime.Now;
//クイズ画像テーブル更新
int i = 1;
foreach (var hint in postedModel.HintList)
{
var targetQUIZPIC = db.QUIZ_PICT.Single
(q => q.QUIZ_ID == postedModel.QuizId
&& q.HINT_SEQ==i);
targetQUIZPIC.PICT_ID= hint.PictId;
targetQUIZPIC.HINT_TXT = hint.HintTxt;
i++;
}
}
db.SaveChanges();
}
}
/// <summary>
/// カテゴリリストボックスバインドデータ
/// </summary>
/// <returns></returns>
private List<SelectListItem> MakeCategoryList()
{
//カテゴリリストの項目取得
using (var db = new SakanaDBEntities1())
{
return (from q in db.CATEGORY
where q.DELETE_FLG == 0
select new SelectListItem()
{
Value = q.CATEGORY_ID.ToString(),
Text = q.CATEGORY_NAME
}).ToList<SelectListItem>();
}
}
/// <summary>
/// クイズ情報
/// </summary>
/// <param name="qId"></param>
/// <returns></returns>
private QuizData GetQuizData(int qId)
{
QuizData retData;
using (var db = new SakanaDBEntities1())
{
retData = (from q in db.QUIZ
where q.QUIZ_ID == qId
&& q.DELETE_FLG == 0
join c in db.CATEGORY on q.CATEGORY_ID equals c.CATEGORY_ID
join u in db.USERS on q.USER_ID equals u.USER_ID
select new QuizData()
{
Quiz = q,
CategoryName = c.CATEGORY_NAME,
UserName = u.USER_NAME
}).ToList<QuizData>().First();
}
return retData;
}
/// <summary>
/// ヒント
/// </summary>
/// <returns></returns>
private List<Hint> GetHints(int qId)
{
List<Hint> retList;
using (var db = new SakanaDBEntities1())
{
retList = (from q in db.QUIZ_PICT
where q.QUIZ_ID == qId
join j in db.PICT on q.PICT_ID equals j.PICT_ID
orderby q.HINT_SEQ
select new Hint()
{
HintTxt = q.HINT_TXT,
PictId = q.PICT_ID,
PictName=j.PICT_TITLE,
PictPath=j.PICT_PATH
}).ToList<Hint>();
}
return retList;
}
public ActionResult UploadPictPost(HttpPostedFileBase fl, string picTitle)
{
//仮想パス(DB保存用)
string upfileKasoPath;
string pictTitle = picTitle;
const string uploadFolder = "../N/";
UploadPictModel mdl = new UploadPictModel();
mdl.Picts = SearchPictData();
// コンテンツ・タイプが「image/*」であるか（画像ファイルか）
// をチェック
if (fl.ContentType.StartsWith("image/"))
{
// アップロード先のパスを生成
upfileKasoPath = uploadFolder + FileNameWithTimestamp(fl.FileName);
string upfileZettaiPath = Server.MapPath(uploadFolder) + FileNameWithTimestamp(fl.FileName);
// 同名のファイルが存在する場合はエラー
if (System.IO.File.Exists(upfileZettaiPath))
{
ViewBag.Msg = "同名のファイルが存在します。";
return View("UploadPict", mdl);
}
else
{
// 画像ファイルで同名のファイルが存在しない場合は保存処理
fl.SaveAs(upfileZettaiPath);
ViewBag.Msg = String.Format(
"{0}をアップロードしました。", fl.FileName);
}
}
else
{
// 画像ファイルでない場合はエラー
ViewBag.Msg = "画像以外はアップロードできません。";
return View("UploadPict", mdl);
}
Session["UserId"] = 1;
int userId = (int)Session["UserId"];
//DB登録処理
using (var db = new SakanaDBEntities1())
{
db.PICT.Add(new PICT
{
CREATE_DT=DateTime.Now,
EDIT_DT = DateTime.Now,
DELETE_FLG=0,
PICT_PATH=upfileKasoPath,
USER_ID = userId,
PICT_TITLE=pictTitle
});
// SaveChangesが呼び出された段階で初めてInsert文が発行される
db.SaveChanges();
}
ViewBag.Msg = "画像アップロードしました。";
// 入力元のフォームに結果を表示
return View("UploadPict", mdl);
}
/// <summary>
/// 作ったクイズ一覧
/// </summary>
/// <returns></returns>
public ActionResult MadeQuizList()
{
Session["UserId"] = 1;
MadeQuizListModel model = new MadeQuizListModel();
int userId = (int)Session["UserId"];
//ユーザー作成のクイズを取得
using (var db = new SakanaDBEntities1())
{
model.MadeQuizList = (from q in db.QUIZ
where q.USER_ID == userId
&& q.DELETE_FLG == 0
join c in db.CATEGORY on q.CATEGORY_ID equals c.CATEGORY_ID
select new QuizData()
{
Quiz=q,
CategoryName=c.CATEGORY_NAME
}).ToList<QuizData>();
}
return View(model);
}