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);
}
}
public Member(int id, String name, int groupnumber, SubjectName sname)
{
Id = id;
Name = name;
GroupNumber = groupnumber;
SName = sname;
}
public override int GetHashCode()
{
// https://www.loganfranken.com/blog/692/overriding-equals-in-c-part-2/
unchecked
{
const int hashingBase = (int)2166136261;
const int hashingMultiplier = 16777619;
int hash = hashingBase;
hash = (hash * hashingMultiplier) ^
(!ReferenceEquals(null, SubjectName) ? SubjectName.GetHashCode() : 0);
hash = (hash * hashingMultiplier) ^
(!ReferenceEquals(null, TeacherName) ? TeacherName.GetHashCode() : 0);
hash = (hash * hashingMultiplier) ^
(!ReferenceEquals(null, ClassType) ? ClassType.GetHashCode() : 0);
hash = (hash * hashingMultiplier) ^
(!ReferenceEquals(null, DayOfWeek) ? DayOfWeek.GetHashCode() : 0);
hash = (hash * hashingMultiplier) ^
(!ReferenceEquals(null, TimeSegmentStart) ? TimeSegmentStart.GetHashCode() : 0);
hash = (hash * hashingMultiplier) ^
(!ReferenceEquals(null, TimeSegmentCount) ? TimeSegmentCount.GetHashCode() : 0);
return(hash);
}
}
public override string GetSubjectName(bool legacyV1Mode)
{
if (legacyV1Mode)
{
return(SubjectName.Decode(X500DistinguishedNameFlags.None));
}
return(SubjectName.Name);
}
/// <inheritdoc cref="object.GetHashCode"/>
public override int GetHashCode()
{
int hashCode = 625787162;
hashCode = (hashCode * -1521134295) + SubjectName.GetHashCode();
hashCode = (hashCode * -1521134295) + AvgAssessments.GetHashCode();
return(hashCode);
}
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);
}
public bool Equals(Exam other)
{
if (other is null)
{
return(false);
}
if (ReferenceEquals(this, other))
{
return(true);
}
return(SubjectName.Equals(other.SubjectName) &&
Grade.Equals(other.Grade) &&
DateOfPassing.Equals(other.DateOfPassing));
}
public void MemberSelectBySubject(WbMemberList memlist)
{
int subject = wbGlobal.InputInt("학과([[1]COM [2]IT [3]GAME [4]ETC) : ");
SubjectName sn = NumberToSubject(subject);
Console.WriteLine("아이디 | 이름 | 조 번호 | 학과");
Console.WriteLine("=================================");
foreach (Member mem in memlist)
{
if (mem.SName == sn)
{
mem.Print();
}
}
}
public override int GetHashCode()
{
return(SubjectName.GetHashCode()
^ Grade.GetHashCode()
^ DateOfPassing.GetHashCode());
}
/// <summary>
/// Overridden ToString method.
/// </summary>
/// <returns>The pair as a string.</returns>
public override string ToString()
{
return($"{AuthenticationMethodType} - {SubjectName.Format(false)}");
}
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);
}
}
public Subject(SubjectName subjectName)
{
this.Name = subjectName;
}
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);
}
}
