//User Registration Portion //public void createUser(string userName, string passWord) //{ // query = "INSERT INTO user_info (user_name, pass) VALUES ('" + userName + "', '"+ passWord + "')"; // dbReadWrite.insertQuery(query); //} //public void writeUserInfo(string userName, string firstName, string lastName, string email, string phoneNumber, string jobPosition, string companyName, byte userType) //{ // subQuery = "(select company_id from company_info where company_name='" + companyName + "')"; // query = "UPDATE user_info SET first_name='" + firstName.Trim() + "',last_name='" + lastName.Trim() + "',email='" + email.Trim() + "',phone='" + phoneNumber.Trim() + "',job_position='" + jobPosition + "',company_id=" + subQuery + ",user_type=" + userType + " WHERE user_name='" + userName.Trim() + "'"; // dbReadWrite.insertQuery(query); //} //public void writeUserInfo(string userName, string passWord, string firstName, string lastName, string email, string phoneNumber, DateTime birthDay, string location, byte userType) //{ // query = "UPDATE user_info SET first_name='" + firstName.Trim() + "',last_name='" + lastName.Trim() + "',email='" + email.Trim() + "',phone='" + phoneNumber.Trim() + "',birth_day='" + birthDay.ToString("yyyy-MM-dd") + "',location='" + location.Trim() + "',user_type=" + userType + " WHERE user_name='" + userName.Trim() + "'"; // dbReadWrite.insertQuery(query); //} public void writeJobSeekerInfo(string userName, string passWord, string firstName, string lastName, string email, string phoneNumber, DateTime birthDay, string location, byte userType) { query = "INSERT INTO user_info (user_name, pass, first_name, last_name, email, phone, birth_day, location, user_type) VALUES ('" + userName.Trim() + "','" + passWord + "','" + firstName.Trim() + "','" + lastName.Trim() + "','" + email.Trim() + "','" + phoneNumber.Trim() + "','" + birthDay.ToString("yyyy-MM-dd") + "','" + location.Trim() + "'," + userType + ")"; dbReadWrite.insertQuery(query); }
public void AddSectionQuery(int userid, byte exptype, string title, string entity, DateTime sttime, DateTime edtime, string details) { query = "INSERT INTO user_experience (user_id, exp_type, title, entity, start_time, end_time, details) VALUES (" + userid + ", " + exptype + ", '" + title + "','" + entity + "', '" + sttime.ToString("yyyy-MM-dd") + "', '" + edtime.ToString("yyyy-MM-dd") + "', '" + details + "')"; dbReadWrite.insertQuery(query); }
public void NewMailQuery(string subject, string body, string senderid, string receiverid, DateTime time, byte isdraft) { query = "INSERT INTO mail_box (mail_subject, mail_body, sender_id, receiver_id, time, isdraft) VALUES ('" + subject.Trim() + "', '" + body.Trim() + "', '" + senderid.Trim() + "', '" + receiverid.Trim() + "', '" + time.ToString("yyyy-MM-dd HH:MM") + "', " + isdraft + ")"; dbReadWrite.insertQuery(query); }