/// <summary>
/// M78_SYKのリスト登録
/// </summary>
/// <param name="p出勤区分ID">出勤区分ID</param>
/// <returns>M78_SYK_Member</returns>
public void GetListSYK(List <M78_SYK_Member> m78syk)
{
using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString()))
{
// トランザクションのインスタンス化(開始)
using (var tran = new TransactionScope())
{
context.Connection.Open();
#region M78_SYK(出勤区分)
var ret1 = (from x in context.M78_SYK
select x).ToList();
foreach (var rec in ret1)
{
context.DeleteObject(rec);
}
int no = 1;
foreach (M78_SYK_Member syk in m78syk.OrderBy(x => x.出勤区分ID))
{
var dat = new M78_SYK()
{
出勤区分ID = syk.出勤区分ID,
出勤区分名 = syk.出勤区分名,
登録日時 = syk.登録日時,
更新日時 = DateTime.Now,
削除日付 = null
};
context.M78_SYK.ApplyChanges(dat);
}
context.SaveChanges();
tran.Complete();
}
#endregion
}
}
/// <summary>
/// M78_SYKの新規追加
/// </summary>
/// <param name="m78syk">M78_SYK_Member</param>
public void Insert(M78_SYK_Member m78syk)
{
using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString()))
{
context.Connection.Open();
M78_SYK m78 = new M78_SYK();
m78.出勤区分ID = m78syk.出勤区分ID;
m78.登録日時 = m78syk.登録日時;
m78.更新日時 = m78syk.更新日時;
m78.出勤区分名 = m78syk.出勤区分名;
try
{
// newﾉｴﾝﾃｨﾃｨﾆ対ｼﾃﾊAcceptChangesﾃﾞ新規追加ﾄﾅﾙ
context.M78_SYK.ApplyChanges(m78);
context.SaveChanges();
}
catch (UpdateException ex)
{
// PKey違反等
Console.WriteLine(ex);
}
}
}
