public void Insert(CompetitionInfoVO item, string std_id)
{
string sql = "INSERT INTO Awards(std_id, competition_id, award_details) VALUES(@std_id, @competition_id, @award_details) ";
MySqlCommand cmd = new MySqlCommand(sql, conn);
FillParameters(cmd, item, std_id);
cmd.ExecuteNonQuery();
}
public void Delete(CompetitionInfoVO item, string std_id)
{
string sql = "DELETE FROM Awards WHERE award_id=@award_id";
MySqlCommand cmd = new MySqlCommand(sql, conn);
FillParameters(cmd, item, std_id);
cmd.ExecuteNonQuery();
}
public void Update(CompetitionInfoVO item, string std_id)
{
string sql = "UPDATE Awards Set competition_id=@competition_id, award_details=@award_details WHERE award_id=@award_id AND std_id=@std_id";
MySqlCommand cmd = new MySqlCommand(sql, conn);
FillParameters(cmd, item, std_id);
cmd.ExecuteNonQuery();
}
private CompetitionInfoVO SetInsertAwardInfoVo(DataRow dr)
{
CompetitionInfoVO item = new CompetitionInfoVO();
item.competition_id = dr["competition_id"].ToString();
item.comp_date = Convert.ToDateTime(dr["comp_date"]);
item.comp_name = dr["comp_name"].ToString();
item.comp_details = dr["comp_details"].ToString();
item.award_details = dr["award_details"].ToString();
item.comp_host = dr["comp_host"].ToString();
return(item);
}
//네비게이터의 저장버튼
private void ToolStripButton1_Click(object sender, EventArgs e)
{
if (AwardGrid.Rows.Count == 0)
{
if (string.IsNullOrEmpty(txtAwarddetails.Text) && AwardGrid.Rows.Count > 0)
{
MaterialMessageBox.Show("수상내역을 입력해주세요.", "경고", MessageBoxButtons.OK);
return;
}
}
CompetitionInfoService service = new CompetitionInfoService();
try
{
DataRow[] insRows = dt.Select(null, null, DataViewRowState.Added);
foreach (DataRow dr in insRows)
{
CompetitionInfoVO item = SetInsertAwardInfoVo(dr);
service.Insert(item, lblStudentID.Text);
}
DataRow[] upsRows = dt.Select(null, null, DataViewRowState.ModifiedCurrent);
foreach (DataRow dr in upsRows)
{
CompetitionInfoVO item = SetAwardInfoVo(dr);
service.Update(item, lblStudentID.Text);
}
DataRow[] delRows = dt.Select(null, null, DataViewRowState.Deleted);
foreach (DataRow dr in delRows)
{
CompetitionInfoVO item = SetDelAwardInfoVo(dr);
service.Delete(item, lblStudentID.Text);
}
MaterialMessageBox.Show("저장완료", "확인", MessageBoxButtons.OK);
}
catch (InvalidCastException)
{
MaterialMessageBox.Show("항목을 입력해주세요", "경고", MessageBoxButtons.OK);
}
catch (Exception err)
{
MaterialMessageBox.Show(err.Message, "경고", MessageBoxButtons.OK);
}
finally
{
service.Dispose();
}
}
private CompetitionInfoVO SetDelAwardInfoVo(DataRow dr)
{
CompetitionInfoVO item = new CompetitionInfoVO();
item.award_id = Convert.ToInt32(dr["award_id", DataRowVersion.Original]);
item.competition_id = dr["competition_id", DataRowVersion.Original].ToString();
item.comp_date = Convert.ToDateTime(dr["comp_date", DataRowVersion.Original]);
item.comp_name = dr["comp_name", DataRowVersion.Original].ToString();
item.comp_details = dr["comp_details", DataRowVersion.Original].ToString();
item.award_details = dr["award_details", DataRowVersion.Original].ToString();
item.comp_host = dr["comp_host", DataRowVersion.Original].ToString();
return(item);
}
private void FillParameters(MySqlCommand cmd, CompetitionInfoVO item, string std_id)
{
MySqlParameter param1 = new MySqlParameter("std_id", MySqlDbType.VarChar, 10);
param1.Value = std_id;
cmd.Parameters.Add(param1);
MySqlParameter param2 = new MySqlParameter("competition_id", MySqlDbType.VarChar, 10);
param2.Value = item.competition_id;
cmd.Parameters.Add(param2);
MySqlParameter param3 = new MySqlParameter("award_details", MySqlDbType.VarChar, 10);
param3.Value = item.award_details;
cmd.Parameters.Add(param3);
MySqlParameter param4 = new MySqlParameter("award_id", MySqlDbType.Int32);
param4.Value = item.award_id;
cmd.Parameters.Add(param4);
}
public void Delete(CompetitionInfoVO item, string std_id)
{
CompetitionInfoDAC DAC = new CompetitionInfoDAC(conn);
DAC.Delete(item, std_id);
}
public void Insert(CompetitionInfoVO item, string std_id)
{
CompetitionInfoDAC DAC = new CompetitionInfoDAC(conn);
DAC.Insert(item, std_id);
}
