private void 수정ToolStripMenuItem_Click(object sender, EventArgs e)
{
StudentInfoInsUpForm frm = new StudentInfoInsUpForm(StudentInfoInsUpForm.EditMode.Update);
try
{
Student stu;
stu.ID = StudentGrid[0, StudentGrid.CurrentRow.Index].Value.ToString();
stu.Name = StudentGrid[1, StudentGrid.CurrentRow.Index].Value.ToString();
stu.Phone = StudentGrid[2, StudentGrid.CurrentRow.Index].Value.ToString();
stu.Email = StudentGrid[3, StudentGrid.CurrentRow.Index].Value.ToString();
frm.StudentInfo = stu;
if (frm.ShowDialog() == DialogResult.OK)
{
StudentInfoDAC stdDB = new StudentInfoDAC();
stdDB.Update(frm.StudentInfo);
stdDB.Dispose();
LoadStudentGridData();
LoadStudentInfoData();
LoadStudentImage();
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void LoadStudentImage()
{
try
{
StudentInfoDAC stdDB = new StudentInfoDAC();
string image = stdDB.GetImage(txtStudentID.Text);
if (image == "" || image == null)
{
pictureBox1.Image = null;
return;
}
Image img;
img = Image.FromFile(Application.StartupPath.Replace("\\", "/") + "/" + image);
pictureBox1.Image = img;
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
stdDB.Dispose();
}
catch
{
return;
}
}
private void LoadStudentGridData()
{
StudentInfoDAC stdDB = new StudentInfoDAC();
DataSet ds = stdDB.GetAll();
StudentGrid.DataSource = ds.Tables[0];
stdDB.Dispose();
}
private void LoadStudentGridData()
{
StudentInfoDAC DAC = new StudentInfoDAC();
DataSet ds = DAC.GetIDName();
StudentGrid.DataSource = ds.Tables[0];
DAC.Dispose();
}
private void BtnSaveFile_Click(object sender, EventArgs e)
{
if (pictureBox1.Image == null)
{
MaterialMessageBox.Show("저장하실 이미지 정보를 입력하여 주십시오", "오류", MessageBoxButtons.OK);
return;
}
//Cursor currentCursor = this.Cursor;
string destFile = string.Empty;
string sPath = string.Empty;
string sFileName = string.Empty;
string sExt = string.Empty;
try
{
//this.Cursor = Cursors.WaitCursor;
StudentInfoDAC stdDB = new StudentInfoDAC();
string localFile = pictureBox1.Tag.ToString().Replace("\\", "/");
sPath = string.Format("studentImage/{0}/", txtStudentID.Text);
sExt = localFile.Substring(localFile.LastIndexOf("."));
sFileName = DateTime.Now.ToString("yyyyMMddHHmmss") + txtStudentID.Text + sExt;
DirectoryInfo di = new DirectoryInfo(sPath);
if (di.Exists == false)
{
di.Create();
}
// 현재 exe가 실행중인 경로에 생성
destFile = Path.Combine(Environment.CurrentDirectory.Replace("\\", "/"), sPath, sFileName);
File.Copy(pictureBox1.Tag.ToString(), destFile, true);
stdDB.SaveImageFile(sPath, sFileName, txtStudentID.Text);
stdDB.Dispose();
MaterialMessageBox.Show("사진저장 완료", "확인", MessageBoxButtons.OK);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
finally
{
//this.Cursor = currentCursor;
}
}
private void 삭제ToolStripMenuItem_Click(object sender, EventArgs e)
{
string msg = string.Format("{0} 학생을 삭제하시겠습니까?",
StudentGrid[1, StudentGrid.CurrentRow.Index].Value.ToString());
try
{
if (MaterialMessageBox.Show(msg, "삭제확인", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
string stuID = StudentGrid[0, StudentGrid.CurrentRow.Index].Value.ToString();
StudentInfoDAC stdDB = new StudentInfoDAC();
stdDB.Delete(stuID);
stdDB.Dispose();
LoadStudentGridData();
LoadStudentInfoData();
LoadStudentImage();
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void BtnCreate_Click(object sender, EventArgs e)
{
StudentInfoInsUpForm frm = new StudentInfoInsUpForm(StudentInfoInsUpForm.EditMode.Input);
try
{
if (frm.ShowDialog() == DialogResult.OK)
{
StudentInfoDAC stdDB = new StudentInfoDAC();
stdDB.Insert(frm.StudentInfo);
stdDB.Dispose();
MaterialMessageBox.Show("신규등록이 완료되었습니다.", "확인", MessageBoxButtons.OK);
LoadStudentGridData();
LoadStudentInfoData();
LoadStudentImage();
LoadStudentDetailInfoData();
}
}
catch (Exception err)
{
MetroFramework.MetroMessageBox.Show(this, err.Message, "경고");
}
}