private void cmd_save_Click(object sender, EventArgs e)
{
//f_mec.MentalDisorder = cbo_mendal.Text;
//f_mec.Cardiovascular = cbo_cardio.Text;
//f_mec.CircumferenceChest = cbo_circum.Text;
//f_mec.Infection = cbo_incfection.Text;
//f_mec.NervousSystem = cbo_nervous.Text;
//f_mec.Digestive = cbo_digestive.Text;
//f_mec.Liver = cbo_liver.Text;
//f_mec.Anemia = cbo_anemia.Text;
//f_mec.UrineSyphilisis = cbo_urine.Text;
//this.Close();
DataClasses2DataContext db = new DataClasses2DataContext(Properties.Settings.Default.MyConString);
var count = db.sp_countKrPan(this.Tag.ToString()).FirstOrDefault();
if (count.Column1.Value >= 1)
{
db.sp_update_krpan(cbo_mendal.Text, cbo_cardio.Text, cbo_circum.Text, cbo_incfection.Text, cbo_nervous.Text, cbo_digestive.Text, cbo_liver.Text, cbo_anemia.Text, cbo_urine.Text, this.Tag.ToString());
//db.ExecuteCommand("UPDATE [Centerport_Medical].[dbo].[tbl_krpan] SET [BloodDisorder]={0}, [MentalDisorder]={1}, [Cardiovascular]={2}, [CircumferenceChest]={3}, [Infection]={4}, [NervousSystem]={5}, [Digestive]={6}, [Liver]={7}, [Anemia]={8}, [UrineSyphilisis]={9} WHERE ([cn]='10')", "", cbo_mendal.Text, cbo_cardio.Text, cbo_circum.Text, cbo_incfection.Text, cbo_nervous.Text, cbo_digestive.Text, cbo_liver.Text, cbo_anemia.Text, cbo_urine.Text, this.Tag.ToString());
//, [Cardiovascular]={2}, [CircumferenceChest]={3}, [Infection]={4}, [NervousSystem]={5}, [Digestive]={6}, [Liver]={7}, [Anemia]={8}, [UrineSyphilisis]={9}
}
else
{
db.ExecuteCommand("INSERT INTO [Centerport_Medical].[dbo].[tbl_krpan] ([Resultid], [BloodDisorder], [MentalDisorder], [Cardiovascular], [CircumferenceChest], [Infection], [NervousSystem], [Digestive], [Liver], [Anemia], [UrineSyphilisis]) VALUES ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10})", this.Tag.ToString(), "", cbo_mendal.Text, cbo_cardio.Text, cbo_circum.Text, cbo_incfection.Text, cbo_nervous.Text, cbo_digestive.Text, cbo_liver.Text, cbo_anemia.Text, cbo_urine.Text);
} //[Resultid], [BloodDisorder], [MentalDisorder], [Cardiovascular], [CircumferenceChest], [Infection], [NervousSystem], [Digestive], [Liver], [Anemia], [UrineSyphilisis]
this.Close();
}
private void cmd_save_Click(object sender, EventArgs e)
{
string Levelcn = ((this.cbo_level.SelectedItem as ComboBoxItem).Value.ToString());
if (txt_name.Text == "" || txt_username.Text == "" || txt_password.Text == "" || txt_password.Text != txt_confirmPassword.Text || cbo_level.Text == "")
{
MessageBox.Show("Please check/Verify required informaion", "Action Denied", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
else
{
if (cmd_save.Text == "Save")
{
db.ExecuteCommand("INSERT INTO [Centerport_Medical].[dbo].[tbl_user] ([Fullname], [Username], [Password], [UserLevel], [Remark]) VALUES ({0},{1}, {2}, {3}, {4})", txt_name.Text, txt_username.Text, EncodeString.Encrypt(txt_password.Text), Levelcn, "1");
Availability(false, "Save");
cmd_edit.Enabled = false;
cmd_new.Enabled = true;
cmd_save.Enabled = false;
txt_name.Clear();
txt_username.Clear();
txt_password.Clear();
txt_confirmPassword.Clear();
cbo_level.SelectedIndex = -1;
cmd_new.Text = "New";
}
else
{
db.ExecuteCommand("UPDATE [Centerport_Medical].[dbo].[tbl_user] SET [Fullname]={0}, [Username]={1}, [Password]={2}, [UserLevel]={3} WHERE ([cn]={4})", txt_name.Text, txt_username.Text, EncodeString.Encrypt(txt_password.Text), Levelcn, dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
Availability(false, "Modify");
cmd_edit.Enabled = false;
cmd_new.Enabled = true;
cmd_save.Enabled = false;
txt_confirmPassword.Clear();
cmd_new.Text = "New";
}
}
loaduser();
}