public void ValidateForBdf()
{
// 72 bytes are available for: patientname patientcode birthdate patient_additional + 3 commas
// 42 bytes are available for: admincode technician equipment recording_additional + 3 commas
// Birthdate takes 10 bytes.
// Recording additional is reserved 4 bytes
if ((SubjectName.Length + SubjectCode.Length + SubjectAdditional.Length) > NumberSubjectCharsAvailable)
{
int count = NumberSubjectCharsAvailable;
SubjectName = SubjectName.Substring(0, count);
count -= SubjectName.Length;
SubjectCode = SubjectCode.Substring(0, count);
count -= SubjectCode.Length;
SubjectAdditional = SubjectAdditional.Substring(0, count);
}
if (AdminCode.Length + Technician.Length + Device.Length > NumberTechnicianCharsAvailable)
{
int count = NumberTechnicianCharsAvailable;
AdminCode = AdminCode.Substring(0, count);
count -= AdminCode.Length;
Technician = Technician.Substring(0, count);
count -= Technician.Length;
Device = Device.Substring(0, count);
}
}
protected override void Save()
{
dgv.EndEdit();
if (!IsValid(dgv))
{
MsgBox.Show("請先修正錯誤");
return;
}
List <SubjectCode> newList = new List <SubjectCode>();
foreach (DataGridViewRow row in dgv.Rows)
{
if (row.IsNewRow)
{
continue;
}
SubjectCode sc = new SubjectCode();
//sc.Domain = "" + row.Cells[chDomain.Index].Value;
sc.Subject = "" + row.Cells[chSubject.Index].Value;
sc.Code = "" + row.Cells[chCode.Index].Value;
newList.Add(sc);
}
_accessHelper.DeletedValues(_list.ToArray());
_accessHelper.InsertValues(newList.ToArray());
SubjectCodeMapper.Instance.Reload();
this.DialogResult = DialogResult.OK;
}
private void Reset()
{
SubjectCode.Text = "";
SubjectName.Text = "";
cmbClass.Text = "";
btnSave.Enabled = true;
Delete.Enabled = false;
Update_record.Enabled = false;
SubjectCode.Focus();
}
public bool ValidateStrings()
{
if (SessionName.All(c => Char.IsLetterOrDigit(c) || c.Equals('_') || c.Equals(' ')) &&
SubjectName.All(c => Char.IsLetterOrDigit(c) || c.Equals('_') || c.Equals(' ')) &&
SubjectCode.All(c => Char.IsLetterOrDigit(c) || c.Equals('_') || c.Equals(' ')) &&
SubjectAdditional.All(c => Char.IsLetterOrDigit(c) || c.Equals('_') || c.Equals(' ')) &&
AdminCode.All(c => Char.IsLetterOrDigit(c) || c.Equals('_') || c.Equals(' ')) &&
Technician.All(c => Char.IsLetterOrDigit(c) || c.Equals('_') || c.Equals(' ')))
{
return(true);
}
return(false);
}
private void Delete_Click(object sender, EventArgs e)
{
if (SubjectCode.Text == "")
{
MessageBox.Show("Please enter subject code", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
SubjectCode.Focus();
return;
}
if (MessageBox.Show("Do you really want to delete this record?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
delete_records();
}
}
private void Reset()
{
SubjectCode.Text = "";
SubjectName.Text = "";
cmbCourse.Text = "";
cmbBranch.Text = "";
Semester.Text = "";
btnSave.Enabled = true;
Delete.Enabled = false;
Update_record.Enabled = false;
SubjectCode.Focus();
cmbBranch.Enabled = false;
Semester.Enabled = false;
}
public SubjectCodeModel(SubjectCode model) : base(model)
{
}
private void btnSave_Click(object sender, EventArgs e)
{
if (SubjectCode.Text == "")
{
MessageBox.Show("Please enter subject code", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
SubjectCode.Focus();
return;
}
if (SubjectName.Text == "")
{
MessageBox.Show("Please enter subject name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
SubjectName.Focus();
return;
}
if (cmbCourse.Text == "")
{
MessageBox.Show("Please select course name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
cmbCourse.Focus();
return;
}
if (cmbBranch.Text == "")
{
MessageBox.Show("Please select Branch name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
cmbBranch.Focus();
return;
}
if (Semester.Text == "")
{
MessageBox.Show("Please select semester", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Semester.Focus();
return;
}
try
{
con = new SqlConnection(cs.DBConn);
con.Open();
string ct = "select subjectcode from subjectinfo where subjectcode=@find";
cmd = new SqlCommand(ct);
cmd.Connection = con;
cmd.Parameters.Add(new SqlParameter("@find", System.Data.SqlDbType.NChar, 20, "subjectcode"));
cmd.Parameters["@find"].Value = SubjectCode.Text;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
MessageBox.Show("Subject Code Already Exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
SubjectCode.Text = "";
SubjectCode.Focus();
if ((rdr != null))
{
rdr.Close();
}
return;
}
con = new SqlConnection(cs.DBConn);
con.Open();
string cb = "insert into subjectinfo(subjectcode,subjectname,coursename,branch,semester) VALUES (@d1,@d2,@d4,@d5,@d6)";
cmd = new SqlCommand(cb);
cmd.Connection = con;
cmd.Parameters.Add(new SqlParameter("@d1", System.Data.SqlDbType.NChar, 20, "SubjectCode"));
cmd.Parameters.Add(new SqlParameter("@d2", System.Data.SqlDbType.VarChar, 250, "subjectname"));
cmd.Parameters.Add(new SqlParameter("@d4", System.Data.SqlDbType.NChar, 20, "coursename"));
cmd.Parameters.Add(new SqlParameter("@d5", System.Data.SqlDbType.NChar, 50, "branchname"));
cmd.Parameters.Add(new SqlParameter("@d6", System.Data.SqlDbType.NChar, 10, "semester"));
cmd.Parameters["@d1"].Value = SubjectCode.Text.Trim();
cmd.Parameters["@d2"].Value = SubjectName.Text.Trim();
cmd.Parameters["@d4"].Value = cmbCourse.Text.Trim();
cmd.Parameters["@d5"].Value = cmbBranch.Text.Trim();
cmd.Parameters["@d6"].Value = Semester.Text.Trim();
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully saved", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnSave.Enabled = false;
Autocomplete();
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (SubjectCode.Text == "")
{
MessageBox.Show("Please enter subject code", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
SubjectCode.Focus();
return;
}
if (SubjectName.Text == "")
{
MessageBox.Show("Please enter subject name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
SubjectName.Focus();
return;
}
if (cmbClass.Text == "")
{
MessageBox.Show("Please select course name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
cmbClass.Focus();
return;
}
try
{
con = new SqlConnection(cs.DBcon);
con.Open();
string ct = "select subjectcode from subject where subjectcode=@find";
cmd = new SqlCommand(ct);
cmd.Connection = con;
cmd.Parameters.Add(new SqlParameter("@find", System.Data.SqlDbType.NChar, 20, "subjectcode"));
cmd.Parameters["@find"].Value = SubjectCode.Text;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
MessageBox.Show("Subject Code Already Exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
SubjectCode.Text = "";
SubjectCode.Focus();
if ((rdr != null))
{
rdr.Close();
}
return;
}
con = new SqlConnection(cs.DBcon);
con.Open();
string cb = "insert into subject(subjectcode,subjectname,classname) VALUES (@d1,@d2,@d4)";
cmd = new SqlCommand(cb);
cmd.Connection = con;
cmd.Parameters.Add(new SqlParameter("@d1", System.Data.SqlDbType.NChar, 20, "SubjectCode"));
cmd.Parameters.Add(new SqlParameter("@d2", System.Data.SqlDbType.VarChar, 250, "subjectname"));
cmd.Parameters.Add(new SqlParameter("@d4", System.Data.SqlDbType.NChar, 20, "classname"));
cmd.Parameters["@d1"].Value = SubjectCode.Text.Trim();
cmd.Parameters["@d2"].Value = SubjectName.Text.Trim();
cmd.Parameters["@d4"].Value = cmbClass.Text;
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully saved", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
st1 = lblUser.Text;
st2 = "Added New subject whose subjectCode is'" + SubjectCode.Text + "'";
cf.LogFunc(st1, System.DateTime.Now, st2);
btnSave.Enabled = false;
Autocomplete();
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
