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);
}
}
