public void RegisterLibrarian(LibrarianDTO librarianDto)
{
sqlConnection.Open();
String query = "insert into librarian_tbl (first_name,last_name,username,password,gender,image) values('"
+ librarianDto.FIRSTNAME + "','"
+ librarianDto.LASTNAME + "','"
+ librarianDto.USERNAME + "','"
+ librarianDto.PASSWORD + "','"
+ librarianDto.GENDER + "',@img)";
sqlCommand = new SqlCommand(query, sqlConnection);
sqlCommand.Parameters.Add(new SqlParameter("@img", librarianDto.IMAGE));
sqlCommand.ExecuteNonQuery();
MessageBox.Show("Account has created successfully!");
sqlConnection.Close();
}
//checking muliple username
public Boolean CheckLibrarianExistance(LibrarianDTO librarianDto)
{
sqlConnection.Open();
//TeacherDTO teacherDto = new TeacherDTO(t_id.Text, t_firstname.Text, t_lastname.Text, t_mobnum.Text, t_username.Text, t_pass.Text, t_address.Text, t_designation.Text, t_bldgrp.Text, gender, img);
String query = "select * from librarian_tbl where username='******'";
sqlCommand = new SqlCommand(query, sqlConnection);
sqlDataAdapter = new SqlDataAdapter(sqlCommand);
sqlDataAdapter.Fill(ds);
sqlConnection.Close();
int count = ds.Tables[0].Rows.Count;
if (count > 0)
{
return(true);
}
return(false);
}