public bool InsertLibrarian(Librarian librarian, byte[] images) { string query = "INSERT into Librarian VALUES ( '" + librarian.Id + "','" + librarian.Email + "','" + librarian.Contact + "','" + librarian.Address + "','" + librarian.Salary + "', '" + librarian.FirstName + "', '" + librarian.LastName + "', '" + librarian.Password + "', '" + librarian.Confirm + "', '" + @librarian.Image + "','" + librarian.Surname + "', '" + librarian.UserName + "')"; try { dcc.ConnectWithDB(); int n = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception exp) { return(false); } /* string sqlQuery = "Insert into Librarian(Image)values(@image) WHERE Id='" + librarian.Id + "'"; * try * { * myCommand = new SqlCommand(sqlQuery); * myCommand.Parameters.Add(new SqlParameter("@image", images)); * dcc.ConnectWithDB(); * int n = dcc.ExecuteSQL(query); * dcc.CloseConnection(); * // MessageBox.Show(N.ToString() + "Data Saved Successfully..!"); * } * catch * { * //MessageBox.Show("Please insert your image"); * } */ }
public bool InsertCustomer(Customer cust) { string query = "INSERT into Customers VALUES('" + cust.CustId + "', '" + cust.Name + "', '" + cust.PhnNumber + "')";// "+cust.Salary+", '"+cust.Designation+"')"; try { dcc.ConnectWithDB(); int n = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception exp) { return(false); } }
public bool InsertDoctor(Doctor doc) { string query = "INSERT into Doctor VALUES('" + doc.DocName + "','" + doc.DocEmail + "','" + doc.Specialist + "','" + doc.Time + "')"; try { dcc.ConnectWithDB(); int n = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception exp) { return(false); } }
public bool InsertEmployee(Employee emp) { string query = "INSERT into Employees VALUES('" + emp.EmpId + "', '" + emp.Name + "', '" + emp.PhnNumber + "', " + emp.Salary + ", '" + emp.Designation + "')"; try { dcc.ConnectWithDB(); int n = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception exp) { return(false); } }
public bool InsertEmployee(Employee emp) { string query = "INSERT into Employees values('" + emp.EmpId + "', '" + emp.EmpName + "', " + emp.EmpAge + " , '" + emp.EmpPhoneNum + "', " + emp.EmpSalary + " , '" + emp.EmpDesignation + "', '" + emp.EmpAddress + "')"; try { dcc.ConnectWithDB(); int n = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception exp) { return(false); } finally { dcc.CloseConnection(); } }
public bool InsertAdmin(Admin admin) { string query = "INSERT into Admin(id,Name,Contact,Pass) VALUES( '" + admin.Id + "','" + admin.Name + "','" + admin.Contact + "','" + admin.Password + "')"; try { dcc.ConnectWithDB(); int n = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception exp) { return(false); } }
public bool InsertTable(Table table) { string query = "INSERT into Tables VALUES ('" + table.TableId + "', '" + table.NumberOfSeats + "','" + table.Status + "')"; try { dcc.ConnectWithDB(); int n = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception exp) { return(false); } }
public bool InsertMedicine(Medicine md) { string query = "INSERT into Medicine values('" + md.MadId + "', '" + md.MadName + "', '" + md.MadCompanyname + "', '" + md.ManufacturingDate + "', '" + md.Expiringdate + "', '" + md.StockDate + "', " + md.Price + " , " + md.Quantity + ")"; try { dcc.ConnectWithDB(); int n = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception ex) { return(false); } finally { dcc.CloseConnection(); } }
public bool InsertOrder(Order order) { string query = "INSERT into Orders VALUES ('" + order.Id + "', '" + order.ProductId + "', " + order.TotalPrice + ", " + order.Discount + "," + order.Paid + "," + order.OrderStatus + " )"; try { dcc.ConnectWithDB(); int n = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception exp) { return(false); } }
public bool InsertProduct(Product item) { string query = "INSERT into Products VALUES ('" + item.ProductId + "', '" + item.Name + "', " + item.Price + ",'" + item.Description + "' )"; try { dcc.ConnectWithDB(); int n = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception exp) { return(false); } }
public bool InsertUser(Login l) { string query = "INSERT into Logins VALUES('" + l.Id + "', '" + l.Password + "', " + l.Role + ")"; try { dcc.ConnectWithDB(); int n = dcc.ExecuteSQL(query); return(true); } catch (Exception exp) { Console.WriteLine(exp.StackTrace); return(false); } finally { dcc.CloseConnection(); } }
public bool InsertUser(Login l) { string query = "INSERT into Login Values ('" + l.Id + "', '" + l.Password + "', " + l.Role + ")"; try { dcc.ConnectWithDB(); int n = dcc.ExecuteSQL(query); return(true); } catch (Exception exp) { return(false); } finally { dcc.CloseConnection(); } }
public bool InsertPlaces(Places p) { string query = "INSERT into Places VALUES('" + p.From + "', '" + p.To + "')"; try { dcc.ConnectWithDB(); int n = dcc.ExecuteSQL(query); return(true); } catch (Exception exp) { Console.WriteLine(exp.StackTrace); return(false); } finally { dcc.CloseConnection(); } }
public bool InsertCustomer(Customer cm) { string query = "INSERT into customers VALUES('" + cm.Name + "', '" + cm.PhoneNumber + "', '" + cm.From + "', '" + cm.To + "', '" + cm.BusId + "', '" + cm.Date + "', '" + cm.Time + "', '" + cm.Type + "','" + cm.SeatNumber + "', " + cm.Fare + ")"; try { dcc.ConnectWithDB(); dcc.ExecuteSQL(query); return(true); } catch (Exception exp) { //throw; return(false); } finally { dcc.CloseConnection(); } }
public bool InsertStudent(Student student, byte[] images) { string query = "INSERT into Student VALUES ('" + @student.Image + "', '" + student.Id + "', '" + student.Firstname + "', '" + student.Surname + "', '" + student.Lastname + "', '" + student.Contact + "', '" + student.Dept + "', '" + student.Year + "','" + student.Type + "', '" + student.Due + "', '" + student.Borrowed + "')"; try { dcc.ConnectWithDB(); int n = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception exp) { return(false); } string sqlQuery = "Insert into Student(Image)values(@image) WHERE Id='" + student.Id + "'"; try { myCommand = new SqlCommand(sqlQuery); myCommand.Parameters.Add(new SqlParameter("@image", images)); dcc.ConnectWithDB(); int n = dcc.ExecuteSQL(query); dcc.CloseConnection(); // MessageBox.Show(N.ToString() + "Data Saved Successfully..!"); } catch { //MessageBox.Show("Please insert your image"); } }
public bool MakeAppointment(Appointment app) { string query = "INSERT into Appointment VALUES('" + app.UserId + "','" + app.DocId + "','" + app.DocName + "','" + app.Time + "')"; try { dcc.ConnectWithDB(); int n = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception exp) { return(false); } }
public bool InsertUser(User user) { string query = "INSERT into Actors VALUES('" + user.UserPass + "','" + user.UserName + "','" + user.UserEmail + "','" + user.PhnNumber + "','1')"; try { dcc.ConnectWithDB(); int n = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception exp) { return(false); } }
public bool Insert2(CourseAssign s) { try { string query = "INSERT into CourseAssignTable VALUES ('" + s.AccountId + "', '" + s.AssignedCourse + "', '" + s.Semester + "', '" + s.Section + "')"; DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch { return(false); } }
public bool Insert(Notice a) { try { string query = "INSERT into NoticeTable VALUES ('" + a.CourseId + "','" + a.Section + "','" + a.Semester + "','" + a.Noticee + "','" + a.Date + "')"; DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch { return(false); } }
public bool UpdateInvalide2(StudentBalance s) { try { string query = "UPDATE StudentBalanceTable SET Validation = 'Valid', Balance = '" + s.Balance + "' WHERE AccountId = '" + s.AccountId + "'"; DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch { return(false); } }
public bool UpdateScholarshipEligible2(StudentBalance s) { try { string query = "UPDATE StudentBalanceTable SET Scholarship = '" + s.Scholarship + "' WHERE AccountId= '" + s.AccountId + "'"; DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch { return(false); } }
public bool Insert2(StudentBalance a) { try { string query = "INSERT into StudentBalanceTable VALUES ('" + a.AccountId + "', '" + a.Semester + "','" + a.Scholarship + "', " + a.Balance + ",'" + a.Validation + "')"; DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch { return(false); } }
public bool Insert2(Teacher a) { try { string query = "INSERT into TeacherTable VALUES ('" + a.AccountId + "', " + a.WeekHour + ",'" + a.Status + "', " + a.Salary + ")"; DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch { return(false); } }
public bool Update2(Teacher a) { try { string query = "UPDATE TeacherTable SET WeekHour = " + a.WeekHour + ", Status='" + a.Status + "', Salary=" + a.Salary + " WHERE AccountId= '" + a.AccountId + "'"; DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch { return(false); } }
public bool UpdateStatusShovon(string accountId, string status, int weekhour) { try { string query = "UPDATE TeacherTable SET Status = '" + status + "',WeekHour=" + weekhour + " WHERE AccountId='" + accountId + "'"; DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch { return(false); } }
public int UpdateRegistrationStatus2(string semesterId, string status) { try { string query = "UPDATE SemesterTable SET RegistrationStatus = '" + status + "' WHERE SemesterId = '" + semesterId + "'"; DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(x); } catch { return(0); } }
public bool Update2(string AccountId, double salary) { try { string query = " UPDATE TeacherTable SET Salary = '" + salary + "' WHERE AccountId = '" + AccountId + "' "; DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch { return(false); } }
public bool Insert2(Semester s) { try { string query = "INSERT into SemesterTable VALUES ('" + s.SemesterId + "', '" + s.Name + "', '" + s.RegistrationStatus + "')"; DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch { return(false); } }
public bool UpdateStatusNadim(string accountId) { try { string query = "UPDATE TeacherTable SET Status = 'Vacation Applied' WHERE AccountId='" + accountId + "'"; DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch { return(false); } }
public int Update2(Semester a, string newId) { try { string query = "UPDATE SemesterTable SET Name = '" + a.Name + "', SemesterId = '" + newId + "' WHERE SemesterId= '" + a.SemesterId + "'"; DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(x); } catch { return(0); } }