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); } }