public static bool AddFacTODB(FacultyObject faculty)
{
Console.WriteLine("Faculty: " + faculty.Firstname);
try
{
string connetionString = null;
string sql = null;
connetionString = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Users\\Giuseppe\\Documents\\SchoolManagement\\SchoolManagementSolution\\SchoolServer2\\DatabaseForSchool.mdf;Integrated Security=True";
using (SqlConnection cnn = new SqlConnection(connetionString))
{
sql = "insert into Faculty ([FirstName], [LastName], [Age], [Gender], [Class]) values(@first,@last,@age,@gender,@class)";
cnn.Open();
using (SqlCommand cmd = new SqlCommand(sql, cnn))
{
cmd.Parameters.AddWithValue("@first", faculty.Firstname);
cmd.Parameters.AddWithValue("@last", faculty.Lastname);
cmd.Parameters.AddWithValue("@age", faculty.Age);
cmd.Parameters.AddWithValue("@gender", faculty.Gender);
cmd.Parameters.AddWithValue("@class", faculty.Class);
cmd.ExecuteNonQuery();
Console.WriteLine("Row inserted !! ");
return(true);
}
}
}
catch
{
Console.WriteLine("FAILED");
return(false);
}
}
public static void AddFacultyInfoToDB(FacultyObject faculty)
{
try
{
TcpClient tcpclnt = new TcpClient();
MessageBox.Show("Connecting.....");
tcpclnt.Connect("192.168.1.114", 8000);
MessageBox.Show("Connected");
Stream stm = tcpclnt.GetStream();
byte[] ba = ObjectToByteArray(faculty);
stm.Write(ba, 0, ba.Length);
byte[] bb = new byte[100];
int k = stm.Read(bb, 0, 100);
tcpclnt.Close();
}
catch (Exception e)
{
MessageBox.Show("Error..... " + e.StackTrace);
}
}
private void addFacBtn_Click(object sender, EventArgs e)
{
FacultyObject faculty = new FacultyObject(firstNameTxt.Text, lastNameTxt.Text, ageTxt.Text, genderTxt.Text, classTxt.Text);
AddFacultyInfo.AddFacultyInfoToDB(faculty);
LoadFacultyInfo();
}
private static byte[] ObjectToByteArray(FacultyObject faculty)
{
using (MemoryStream ms = new MemoryStream())
{
BinaryWriter bw = new BinaryWriter(ms);
bw.Write("Add To Faculty Database");
bw.Write(faculty.Firstname);
bw.Write(faculty.Lastname);
bw.Write(faculty.Age);
bw.Write(faculty.Gender);
bw.Write(faculty.Class);
return(ms.ToArray());
}
}
public void ObjectInstruction(byte[] buffer)
{
using (MemoryStream ms = new MemoryStream(buffer))
{
BinaryReader br = new BinaryReader(ms);
string instruct = br.ReadString();
if (instruct == "Login")
{
LoginObject info = new LoginObject();
info.Username = br.ReadString();
info.Password = br.ReadString();
socket.Send(StringToByteArrayForLogin(ValidateLogin.ValidateCredentials(info)));
Console.WriteLine("\nSent Acknowledgement");
}
else if (instruct == "Add To Student Database")
{
StudentObject student = new StudentObject();
student.Firstname = br.ReadString();
student.Lastname = br.ReadString();
student.Grade = br.ReadString();
student.Age = br.ReadString();
student.Gender = br.ReadString();
student.Gpa = br.ReadString();
socket.Send(StringToByteArrayForLogin(AddStudent.AddStuTODB(student)));
}
else if (instruct == "Add To Faculty Database")
{
FacultyObject faculty = new FacultyObject();
faculty.Firstname = br.ReadString();
faculty.Lastname = br.ReadString();
faculty.Age = br.ReadString();
faculty.Gender = br.ReadString();
faculty.Class = br.ReadString();
socket.Send(StringToByteArrayForLogin(AddFaculty.AddFacTODB(faculty)));
}
}
}
