public bool addStaff(workticketclass c) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { //sql query to add data string sql = "INSERT INTO users(FullName,Email,Department,Passcode,UserRole,username,expertise) VALUES(@FullName,@Email,@Department,@Passcode,@UserRole,@username,@expertise)"; SqlCommand cmd = new SqlCommand(sql, conn); //create parameters to add data cmd.Parameters.AddWithValue("@FullName", c.FullName); cmd.Parameters.AddWithValue("@Email", c.Email); cmd.Parameters.AddWithValue("@Department", c.Department); cmd.Parameters.AddWithValue("@Passcode", c.Passcode); cmd.Parameters.AddWithValue("@UserRole", c.UserRole); cmd.Parameters.AddWithValue("@username", c.username); cmd.Parameters.AddWithValue("@expertise", c.Expertise); //open connection conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception) { } finally { conn.Close(); } return(isSuccess); }
/*public bool insertHD(workticketclass c) * { * bool isSuccess = false; * SqlConnection conn = new SqlConnection(myconnstrng); * try * { * //sql query to add data * string sql = "INSERT INTO raised_tickets (employee_id,ticket_id,description,date_raised,comments,employee_name,employee_department) VALUES(@employee_id,@ticket_id,@description,@date_raised,@comments,@employee_name,@employee_department)"; * SqlCommand cmd = new SqlCommand(sql, conn); * //create parameters to add data * cmd.Parameters.AddWithValue("@employee_id", c.employee_id); * cmd.Parameters.AddWithValue("@ticket_id", c.ticket_id); * cmd.Parameters.AddWithValue("@description", c.description); * cmd.Parameters.AddWithValue("@date_raised", c.date_raised); * cmd.Parameters.AddWithValue("@comments", c.comments); * cmd.Parameters.AddWithValue("@employee_name", c.employee_name); * cmd.Parameters.AddWithValue("@employee_department", c.Department); * * //open connection * conn.Open(); * int rows = cmd.ExecuteNonQuery(); * if (rows > 0) * { * isSuccess = true; * } * else * { * isSuccess = false; * } * } * catch (Exception ex) * { * * } * finally * { * conn.Close(); * } * return isSuccess; * }*/ /* public bool insertNT(workticketclass c) * { * bool isSuccess = false; * SqlConnection conn = new SqlConnection(myconnstrng); * try * { * //sql query to add data * string sql = "INSERT INTO NetwIssuesTBL (EmployeeIDNo,Full_Names,Department,Issues,Issue_Description,Date,Other_Complements) VALUES(@EmployeeIDNo,@Full_Names,@Department,@Issues,@Issue_Description,@Date,@Other_Complements)"; * SqlCommand cmd = new SqlCommand(sql, conn); * //create parameters to add data * cmd.Parameters.AddWithValue("@EmployeeIDNo", c.EmployeeIDNo); * cmd.Parameters.AddWithValue("@Full_Names", c.Full_Names); * cmd.Parameters.AddWithValue("@Department", c.Department); * cmd.Parameters.AddWithValue("@Issues", c.Issues); * cmd.Parameters.AddWithValue("@Issue_Description", c.Issue_Description); * cmd.Parameters.AddWithValue("@Date", c.Date); * cmd.Parameters.AddWithValue("@Other_Complements", c.Other_Complements); * * //open connection * conn.Open(); * int rows = cmd.ExecuteNonQuery(); * if (rows > 0) * { * isSuccess = true; * } * else * { * isSuccess = false; * } * } * catch (Exception) * { * * } * finally * { * conn.Close(); * } * return isSuccess; * }*/ /* public bool insertlgn(workticketclass c) * { * bool isSuccess = false; * * SqlConnection conn = new SqlConnection(myconnstrng); * try * { * //sql query to add data * string sql = "INSERT INTO EmpSignupTbl (User_Names,Password) VALUES(@User_Names,@Password)"; * SqlCommand cmd = new SqlCommand(sql, conn); * //create parameters to add data * * cmd.Parameters.AddWithValue("@User_Names", c.User_Names); * cmd.Parameters.AddWithValue("@Password", c.Password); * * //open connection * conn.Open(); * int rows = cmd.ExecuteNonQuery(); * if (rows > 0) * { * isSuccess = true; * } * else * { * isSuccess = false; * } * } * catch (Exception) * { * * } * finally * { * conn.Close(); * } * return isSuccess; * } */ /* public bool insertstaff(workticketclass c) * { * bool isSuccess = false; * * SqlConnection conn = new SqlConnection(myconnstrng); * try * { * //sql query to add data * string sql = "INSERT INTO StaffsignupTBL (Names,Expertise,Passcode) VALUES(@Names,@Expertise,@Passcode)"; * SqlCommand cmd = new SqlCommand(sql, conn); * //create parameters to add data * * cmd.Parameters.AddWithValue("@Names", c.Names); * cmd.Parameters.AddWithValue("@Expertise", c.Expertise); * cmd.Parameters.AddWithValue("@Passcode", c.Passcode); * * //open connection * conn.Open(); * int rows = cmd.ExecuteNonQuery(); * if (rows > 0) * { * isSuccess = true; * } * else * { * isSuccess = false; * } * } * catch (Exception) * { * * } * finally * { * conn.Close(); * } * return isSuccess; * }*/ /* * SqlConnection conn = new SqlConnection(myconnstrng); * try * { * //sql query to add data * string sql = "INSERT INTO staffsignupSoftTbl (Names,Expertise,Passcode) VALUES(@Names,@Expertise,@Passcode)"; * SqlCommand cmd = new SqlCommand(sql, conn); * //create parameters to add data * * cmd.Parameters.AddWithValue("@Names", c.Names); * cmd.Parameters.AddWithValue("@Expertise", c.Expertise); * cmd.Parameters.AddWithValue("@Passcode", c.Passcode); * * //open connection * conn.Open(); * int rows = cmd.ExecuteNonQuery(); * if (rows > 0) * { * isSuccess = true; * } * else * { * isSuccess = false; * } * } * catch (Exception) * { * * } * finally * { * conn.Close(); * } * return isSuccess; * }*/ /*public bool insertstaffHd(workticketclass c) * { * bool isSuccess = false; * * SqlConnection conn = new SqlConnection(myconnstrng); * try * { * //sql query to add data * string sql = "INSERT INTO users (FullName,expertise,Passcode) VALUES(@FullName,@expertise,@Passcode)"; * SqlCommand cmd = new SqlCommand(sql, conn); * //create parameters to add data * * cmd.Parameters.AddWithValue("@Names", c.FullName); * cmd.Parameters.AddWithValue("@Expertise", c.Expertise); * cmd.Parameters.AddWithValue("@Passcode", c.Passcode); * * //open connection * conn.Open(); * int rows = cmd.ExecuteNonQuery(); * if (rows > 0) * { * isSuccess = true; * } * else * { * isSuccess = false; * } * } * catch (Exception) * { * * } * finally * { * conn.Close(); * } * return isSuccess; * }*/ /*public bool insertseniorstaff(workticketclass c) * { * bool isSuccess = false; * * SqlConnection conn = new SqlConnection(myconnstrng); * try * { * //sql query to add data * string sql = "INSERT INTO SeniorStaffSignupTbl (StaffNames,SecurityCode) VALUES(@StaffNames,@SecurityCode)"; * SqlCommand cmd = new SqlCommand(sql, conn); * //create parameters to add data * * cmd.Parameters.AddWithValue("@StaffNames", c.StaffNames); * cmd.Parameters.AddWithValue("@SecurityCode", c.SecurityCode); * * //open connection * conn.Open(); * int rows = cmd.ExecuteNonQuery(); * if (rows > 0) * { * isSuccess = true; * } * else * { * isSuccess = false; * } * } * catch (Exception) * { * * } * finally * { * conn.Close(); * } * return isSuccess; * }*/ //method to update data from app /* public bool update(workticketclass c) * { * bool isSuccess = false; * SqlConnection conn = new SqlConnection(myconnstrng); * try * { * //sql to update data * string sql = "UPDATE EmployeeTbl SET EmmployeeIDNo = @EmployeeIDNo,Full_Names = @Full_Names,Department = @Department,Issues = @Issues,Issue_Description = @Issue_Description,Date = @Date,Other_Complements = @Other_Complements WHERE EmployeeIDNo = @EmployeeIDNo"; * * //sql command * SqlCommand cmd = new SqlCommand(sql, conn); * //create parameters to add value * cmd.Parameters.AddWithValue("@EmlpoyeeIDNo", c.EmployeeIDNo); * cmd.Parameters.AddWithValue("@Full_Names", c.Full_Names); * cmd.Parameters.AddWithValue("@Department", c.Department); * cmd.Parameters.AddWithValue("@Issues", c.Issues); * cmd.Parameters.AddWithValue("@Issue_Description", c.Issue_Description); * cmd.Parameters.AddWithValue("@Date", c.Date); * cmd.Parameters.AddWithValue("@Other_Complements", c.Other_Complements); * //open database connection * conn.Open(); * int rows = cmd.ExecuteNonQuery(); * if (rows > 0) * { * isSuccess = true; * } * else * { * isSuccess = false; * } * * } * catch (Exception) * { * * } * finally * { * conn.Close(); * } * return isSuccess; * } */ //method to delete data public bool Delete(workticketclass c) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { //sql to delete data string sql = "DELETE FROM raised_tickets WHERE id = @id"; //sql command SqlCommand cmd = new SqlCommand(sql, conn); //create parameters to add value cmd.Parameters.AddWithValue("@Ticket_No", c.ticket_id); //open database connection conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception) { } finally { conn.Close(); } return(isSuccess); }
internal void insertstaffHd(workticketclass c) { throw new NotImplementedException(); }