public StudentCompanyInformation AddNotes(string id, int sid, string additionalNotes = null) { StudentCompanyInformation info = new StudentCompanyInformation(); using (var cn = DbConnSingleton.getDbInstance().GetDBConnection()) { var query = "insert into student_company_info(student_id,company_id,interest,notes) values(@sid,@id, 1,@notes)"; MySqlCommand cmd = new MySqlCommand(query, cn); cmd.Parameters.AddWithValue("@notes", additionalNotes.ToString()); cmd.Parameters.AddWithValue("@id", id); cmd.Parameters.AddWithValue("@sid", sid); cmd.ExecuteNonQuery(); } info = getStudentCompanyDetails(id, sid); return(info); }
public StudentCompanyInformation getStudentCompanyDetails(string companyid = null, int studentID = 1, string id = null) { Job job; StudentCompanyInformation information = new StudentCompanyInformation(); var company_id = ""; using (var cn = DbConnSingleton.getDbInstance().GetDBConnection()) { string query = null; if (companyid != null) { query = "select sc.notes,sc.interest, c.name from company c join student_company_info sc on c.id = sc.company_id join job j on c.id = j.company_id where student_id = @sid and c.id = " + companyid; company_id = companyid; } else { query = "select sc.notes,sc.interest, c.name from company c join student_company_info sc on c.id = sc.company_id join job j on c.id = j.company_id where student_id = @sid and c.id = " + id; company_id = id; } MySqlCommand cmd = new MySqlCommand(query, cn); cmd.Parameters.AddWithValue("@sid", studentID); MySqlDataAdapter adap = new MySqlDataAdapter(cmd); DataTable dt = new DataTable(); adap.Fill(dt); foreach (DataRow dr in dt.Rows) { // information = new StudentCompanyInformation(); // job = new Job(); information.notes = dr["notes"].ToString(); information.isInterested = dr["interest"].ToString(); //job.seeking_degree = dr["seeking_degree"].ToString(); //job.type = dr["type"].ToString(); //job.visa_sponsorship = dr["visa_sponsorhip"].ToString(); //job.title = dr["title"].ToString(); information.companyName = dr["name"].ToString(); // information.jobs.Add(job); } } information.jobs = getJobs(company_id); // jobs posted by company (if any) return(information); }
public StudentCompanyInformation editBoothQueue(string id, int studentID, bool inQueue) { StudentCompanyInformation info = new StudentCompanyInformation(); using (var cn = DbConnSingleton.getDbInstance().GetDBConnection()) { if (inQueue) { MySqlCommand cmd = new MySqlCommand("EditBoothQueue", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@companyid", id); // cmd.Parameters.AddWithValue("@queueval", inQueue); cmd.Parameters.AddWithValue("@studentID", studentID); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); } } info = getStudentCompanyDetails(id, studentID); return(info); }
public StudentCompanyInformation UpdateNotes(string id, int sid, string notes = null, string isInterested = null, bool inQueue = false) { // StudentCompanyDetails compdetails = new StudentCompanyDetails(); StudentCompanyInformation info = new StudentCompanyInformation(); using (var cn = DbConnSingleton.getDbInstance().GetDBConnection()) { //var query = "insert into student_company_info(student_id,company_id,interest,notes) values(1,?companyID, ?isInterested, ?notes)"; var query = "Update student_company_info set notes = @notes where company_id = @id and student_id = @sid"; MySqlCommand cmd = new MySqlCommand(query, cn); cmd.Parameters.AddWithValue("@notes", notes); cmd.Parameters.AddWithValue("@id", id); cmd.Parameters.AddWithValue("@sid", sid); // cmd.Parameters.AddWithValue("?companyID", HttpUtility.ParseQueryString("id").ToString()); // cmd.Parameters.AddWithValue("?isInterested", 1); // cmd.Parameters.AddWithValue("?notes", notes); cmd.ExecuteNonQuery(); } info = getStudentCompanyDetails(id, sid); return(info); }