public ActionResult <Remove> Delete(Remove param)
{
if (param == null)
{
param._message = _localizer["No parameters."];
return(BadRequest(param));
}
try
{
var model = new Kintai();
model = (from a in _context.Kintais
where a.KintaiId.Equals(param.KintaiId)
select a).FirstOrDefault();
if (model == null)
{
param._message = _localizer["It has already been deleted."];
return(BadRequest(param));
}
//削除
_context.Kintais.Remove(model);
_context.SaveChanges();
return(Ok(param));
}
catch (Exception ex)
{
param._message = _localizer["System error Please inform system personnel.({0})", ex.Message];
return(BadRequest(param));
}
}
public IActionResult Rec(KintaiViewModel viewModel)
{
if (ModelState.IsValid)
{
//トランザクション開始
using (var transaction = _context.Database.BeginTransaction())
{
try
{
// 現在時刻
DateTime nowTime = DateTime.Now;
// ユーザー情報を取得
var user = _context.ApplicationUsers.Where(t => t.UserName == User.Identity.Name)
.FirstOrDefault();
Kintai model = new Kintai();
// 現在時刻をセット
model.RecordingDate = nowTime;
// ユーザーをセット
model.ApplicationUser = user;
// viewModelに値を渡す
viewModel.TimeIn = model.RecordingDate.ToString("HH:mm");
// DBに追加
_context.Add(model);
// データベースに変更が反映
_context.SaveChanges();
// データベースの更新内容が有効
transaction.Commit();
// 勤怠管理画面に戻る
//return RedirectToAction(nameof(Index));
return(View("Index", viewModel));
}
catch (Exception ex)
{
transaction.Rollback();
ModelState.AddModelError(string.Empty, "エラーが発生しました。");
}
}
}
return(View("Index", viewModel));
}
public ActionResult <Edit> Store([FromBody] Edit param)
{
if (param == null)
{
param = new Edit();
param._message = _localizer["No parameters."];
return(BadRequest(param));
}
if (!TryValidateModel(param))
{
param._message = _localizer["The input is incorrect."];
return(BadRequest(param));
}
//新規の場合
if (param.KintaiId == null)
{
try
{
var storeModel = new Kintai();
ReflectionUtility.Model2Model(param, storeModel);
//時間の書式統一
storeModel.Sykjk = Hhmmformater(storeModel.Sykjk);
storeModel.Tkjk = Hhmmformater(storeModel.Tkjk);
storeModel.SykjkDkk = Hhmmformater(storeModel.SykjkDkk);
storeModel.TkjkDkk = Hhmmformater(storeModel.TkjkDkk);
storeModel.KykJkn = Hhmmformater(storeModel.KykJkn);
storeModel.Zgyjkn = Hhmmformater(storeModel.Zgyjkn);
storeModel.Zgyjkn36 = Hhmmformater(storeModel.Zgyjkn36);
storeModel.KintaiId = (Guid.NewGuid()).ToString();
storeModel.Owner = HttpContext.User.Identity.Name;
storeModel.Registed = DateTime.Now;
storeModel.Updated = DateTime.Now;
storeModel.Version = 1;
//登録
_context.Kintais.Add(storeModel);
_context.SaveChanges();
ReflectionUtility.Model2Model(storeModel, param);
return(Ok(param));
}
catch (Exception ex)
{
param._message = _localizer["System error Please inform system personnel.({0})", ex.Message];
return(BadRequest(param));
}
}
else
{
//更新の場合
try
{
//更新前データを取得する
var storeModel = (from a in _context.Kintais
where a.KintaiId.Equals(param.KintaiId)
select a).FirstOrDefault();
if (storeModel == null)
{
param._message = _localizer["It has already been deleted."];
return(BadRequest(param));
}
if (storeModel.Version != param.Version)
{
param._message = _localizer["Other people have been updated."];
return(BadRequest(param));
}
ReflectionUtility.Model2Model(param, storeModel);
//時間の書式統一
storeModel.Sykjk = Hhmmformater(storeModel.Sykjk);
storeModel.Tkjk = Hhmmformater(storeModel.Tkjk);
storeModel.SykjkDkk = Hhmmformater(storeModel.SykjkDkk);
storeModel.TkjkDkk = Hhmmformater(storeModel.TkjkDkk);
storeModel.KykJkn = Hhmmformater(storeModel.KykJkn);
storeModel.Zgyjkn = Hhmmformater(storeModel.Zgyjkn);
storeModel.Zgyjkn36 = Hhmmformater(storeModel.Zgyjkn36);
storeModel.Updated = DateTime.Now;
storeModel.Version += 1;
//更新
_context.Kintais.Update(storeModel);
_context.SaveChanges();
ReflectionUtility.Model2Model(storeModel, param);
return(Ok(param));
}
catch (Exception ex)
{
param._message = _localizer["System error Please inform system personnel.({0})", ex.Message];
return(BadRequest(param));
}
}
}
