private void SetKoma(MS_KYOUKA value, int SearchKoma)
{
var data = MsWeeks.Where(x => x.KOMA == SearchKoma).FirstOrDefault();
if (data == null)
{
data = new MS_WEEK();
data.KOMA = SearchKoma;
data.DAY = Day;
MsWeeks.Add(data);
}
data.MS_KYOUKA_ID = value.MS_KYOUKA_ID;
}
private void Insert(MS_WEEK MsWeek)
{
#region SQL
string SQL = @"
insert into MS_WEEK(
DAY,
KOMA,
MS_KYOUKA_ID)
values(
@DAY,
@KOMA,
@MS_KYOUKA_ID)
";
#endregion
using (MySqlCommand command = new MySqlCommand(SQL, DBConnect.GetConnection()))
{
command.Parameters.AddWithValue("@DAY", MsWeek.DAY);
command.Parameters.AddWithValue("@KOMA", MsWeek.KOMA);
command.Parameters.AddWithValue("@MS_KYOUKA_ID", MsWeek.MS_KYOUKA_ID);
command.ExecuteNonQuery();
}
}
