/// <summary>
/// Deleting infomation by infomationId
/// </summary>
/// <param name="infomationId"></param>
/// <returns></returns>
public IActionResult DeleteInfoById(int id) //id = infomationId
{
var langRequest = Request.HttpContext.Features.Get <IRequestCultureFeature>();
var culture = langRequest.RequestCulture.Culture;
var _lang = culture.ToString();
var info = _db.Infomations.Find(id);
if (info == null)
{
var result = new
{
status = 400,
message = (_lang == "en-US") ? "Specified Infromation does not exist." : "指定されたお知らせは存在しません。"
};
return(Json(result));
}
else
{
_db.Infomations.Remove(info);
_db.SaveChanges();
var result = new
{
status = 200,
message = (_lang == "en-US") ? "Information was deleted." : "お知らせを削除しました。"
};
return(Json(result));
}
}
public IActionResult CreateUpdateMaintenanceRecord(MaintenanceRecord record)
{
var langRequest = Request.HttpContext.Features.Get <IRequestCultureFeature>();
var culture = langRequest.RequestCulture.Culture;
var _lang = culture.ToString();
if (record.RecordId != 0) // update
{
var getRecordById = _db.MaintenanceRecords.Find(record.RecordId);
if (getRecordById == null)
{
var result = new
{
status = 400,
message = (_lang == "en-US") ? "Specified Maintenance Record infromation does not exist" : "指定されたメンテナンス記録は存在しません。",
};
return(Json(result));
}
else
{
getRecordById.RecordDate = record.RecordDate;
getRecordById.Title = record.Title;
getRecordById.Note = record.Note;
_db.MaintenanceRecords.Update(getRecordById);
_db.SaveChanges();
var result = new
{
status = 200,
message = (_lang == "en-US") ? "Category information was updated." : "メンテナンス記録情報を更新しました。",
};
return(Json(result));
}
}
else // insert
{
var maintenance = new MaintenanceRecord()
{
MachineId = record.MachineId,
UserId = record.UserId,
RecordDate = record.RecordDate,
Title = record.Title,
Note = record.Note
};
_db.MaintenanceRecords.Add(maintenance);
_db.SaveChanges();
var result = new
{
status = 200,
message = (_lang == "en-US") ? "Category information was registed." : "メンテナンス記録情報を登録しました。",
};
return(Json(result));
}
}
public IActionResult DeletedReservation(int id)
{
Reservation data = _db.Reservations.Include(r => r.CustomFieldValues).Where(r => r.ReserveId == id).FirstOrDefault();
if (data == null)
{
var result = new
{
status = 400,
message = "Delete Fail! GroupId not exist"
};
return(Json(result));
}
else
{
data.CustomFieldValues.Clear();
//remove group
_db.Reservations.Remove(data);
try
{
_db.SaveChanges();
}
catch (Exception)
{
throw;
}
var result = new
{
status = 200,
message = "Delete Reservation Success"
};
return(Json(result));
}
}
/*
*
* Update group when moving
*
*/
public IActionResult MoveGroupUpdate(int childId, int parentId)
{
var langRequest = Request.HttpContext.Features.Get <IRequestCultureFeature>();
var culture = langRequest.RequestCulture.Culture;
var _lang = culture.ToString();
if (parentId == 1)
{
var result = new
{
status = 301,
message = (_lang == "en-US") ? "It is not possible to move." : "移動できません。"
};
return(Json(result));
}
var group = _db.Groups.Find(childId);
if (group.ParentGroupId == parentId || group.ParentGroupId == null && parentId == 0)
{
var result = new
{
status = 300,
message = (_lang == "en-US") ? "It is the same group. It is not possible to move." : "同じ所属です。移動できません。"
};
return(Json(result));
}
else
{
if (parentId == 0)
{
group.ParentGroupId = null;
}
else
{
group.ParentGroupId = parentId;
}
_db.Groups.Update(group);
_db.SaveChanges();
var result = new
{
status = 200,
message = (_lang == "en-US") ? "Group information was registed": "所属情報を登録しました。"
};
return(Json(result));
}
}
/*
* Create new category
* **/
public IActionResult CreateCategory(string categoryNameEn, string categoryNameJp)
{
Category cate = new Category();
cate.CategoryNameEn = categoryNameEn;
cate.CategoryNameJp = categoryNameJp;
cate.Status = 1;
_db.Add(cate);
_db.SaveChanges();
var result = new
{
status = 200,
message = "Create Category Success",
data = cate
};
return(Json(result));
}