private bool Check_Control(ENROLL_TYPE type) { switch (type) { case ENROLL_TYPE.COMPANY: if (string.IsNullOrEmpty(tbCompanyName.Text)) { tbCompanyName.Focus(); return(false); } break; } return(true); }
private void Enroll_Data(ENROLL_TYPE etype) { MySql mysql = MySql.Instance; string query = ""; try { switch (etype) { case ENROLL_TYPE.COMPANY: if (!Check_Control(ENROLL_TYPE.COMPANY)) { return; } query = string.Format("INSERT INTO t_company(name, area_main, area_sub) VALUES('{0}', '{1}', '{2}');", tbCompanyName.Text, cbAreaMain.Text, cbAreaSub.Text); mysql.Set_SqlQuery(query); lblStatusCompany.Text = string.Format("Finished enroll the '{0}'...", tbCompanyName.Text); tbCompanyName.Text = ""; Console.WriteLine("Insert a data in t_company"); break; } } catch (MySqlException) { if (etype == ENROLL_TYPE.COMPANY) { MessageBox.Show(string.Format("'{0}'은(는) 이미 등록 되어있습니다.", tbCompanyName.Text)); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }