private void buttonDelete_Click(object sender, EventArgs e)
{
// delete button
try
{
LibriyanDB objt = new LibriyanDB();
String NicNumber;
NicNumber = dataGridViewUpdateLibariyan.SelectedCells[0].Value.ToString();
objt.NICNumber1 = NicNumber;
objt.DeleteLibrarian(objt);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
// refersh table
try
{
LibriyanDB obcj = new LibriyanDB();
SqlDataReader DR = obcj.getLibariyanInfo();
DataTable dt = new DataTable();
dt.Columns.Add("LibrarianID");
dt.Columns.Add("FristName");
dt.Columns.Add("LastName");
dt.Columns.Add("Email");
dt.Columns.Add("LibrarianPassword");
dt.Columns.Add("gender");
dt.Columns.Add("Adress");
dt.Columns.Add("Phone_Number");
dt.Columns.Add("Registerdate");
while (DR.Read())
{
DataRow row = dt.NewRow();
row["LibrarianID"] = DR["LibrarianID"];
row["FristName"] = DR["FristName"];
row["LastName"] = DR["LastName"];
row["Email"] = DR["Email"];
row["LibrarianPassword"] = DR["LibrarianPassword"];
row["gender"] = DR["gender"];
row["Adress"] = DR["Adress"];
row["Phone_Number"] = DR["Phone_Number"];
row["Registerdate"] = DR["Registerdate"];
dt.Rows.Add(row);
}
dataGridViewUpdateLibariyan.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
// clear text filed
textBoxFristName.Text = "";
textBoxLastName.Text = "";
textBoxEmail.Text = "";
textBoxPassword.Text = "";
textBoxConfirmpassword.Text = "";
richTextBoxAdress.Text = "";
textBoxPhonenumber.Text = "";
}
//delete Librarian
public void DeleteLibrarian(LibriyanDB objt)
{
DBConnection mycon = new DBConnection();
String SQL = "delete from Librarian where LibrarianID='" + objt.NICNumber + "'";
mycon.addvalues(SQL);
}
//update Librarian details
public void enterupdaeLibrarian(LibriyanDB obj)
{
String SQL = "update Librarian set FristName='" + obj.FristName + "',LastName='" + obj.LastName + "',Email='" + obj.Email + "',LibrarianPassword='******',gender='" + obj.Gender + "',Adress ='" + obj.Address + "',Phone_Number='" + obj.Phonenumber + "'where LibrarianID='" + obj.NICNumber + "'";
DBConnection mycon = new DBConnection();
mycon.addvalues(SQL);
}
//Adding Libariyan details Libariyan table
public void addNewLibariyan(LibriyanDB obj)
{
String SQL = "insert into Librarian values('" + obj.NICNumber + "','" + obj.FristName + "','" + obj.LastName + "','" + obj.Email + "','" + obj.password + "','" + obj.Gender + "','" + obj.Address + "','" + obj.Phonenumber + "','" + obj.regdate.ToString("yyyy-MM-dd") + "')";
DBConnection mycon = new DBConnection();
mycon.addvalues(SQL);
}
private void dataGridViewUpdateLibariyan_CellClick(object sender, DataGridViewCellEventArgs e)
{
//setting table value textfileds
try
{
String NICNO;
NICNO = dataGridViewUpdateLibariyan.SelectedCells[0].Value.ToString();
LibriyanDB obj = new LibriyanDB();
SqlDataReader DR = obj.getupdateLibariyan(NICNO);
DataTable dt = new DataTable();
dt.Columns.Add("LibrarianID");
dt.Columns.Add("FristName");
dt.Columns.Add("LastName");
dt.Columns.Add("Email");
dt.Columns.Add("LibrarianPassword");
dt.Columns.Add("gender");
dt.Columns.Add("Adress");
dt.Columns.Add("Phone_Number");
// dt.Columns.Add("Registerdate");
//dt.Columns.Add("Registationfee");
while (DR.Read())
{
DataRow row = dt.NewRow();
// row["MemberID"] = DR["MemberID"];
textBoxFristName.Text = DR["FristName"].ToString();
textBoxLastName.Text = DR["LastName"].ToString();
textBoxEmail.Text = DR["Email"].ToString();
textBoxPassword.Text = DR["LibrarianPassword"].ToString();
textBoxConfirmpassword.Text = DR["LibrarianPassword"].ToString();
comboBoxGender.Text = DR["gender"].ToString();
richTextBoxAdress.Text = DR["Adress"].ToString();
textBoxPhonenumber.Text = DR["Phone_Number"].ToString();
// textBoxRegistraionFee.Text = DR["Registationfee"].ToString();
dt.Rows.Add(row);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void textBoxSearchlibriyan_KeyUp(object sender, KeyEventArgs e)
{
// search button
try
{
LibriyanDB obj = new LibriyanDB();
SqlDataReader DR = obj.SearchLibrarian(textBoxSearchlibriyan.Text);
DataTable dt = new DataTable();
dt.Columns.Add("LibrarianID");
dt.Columns.Add("FristName");
dt.Columns.Add("LastName");
dt.Columns.Add("Email");
dt.Columns.Add("LibrarianPassword");
dt.Columns.Add("gender");
dt.Columns.Add("Adress");
dt.Columns.Add("Phone_Number");
dt.Columns.Add("Registerdate");
while (DR.Read())
{
DataRow row = dt.NewRow();
row["LibrarianID"] = DR["LibrarianID"];
row["FristName"] = DR["FristName"];
row["LastName"] = DR["LastName"];
row["Email"] = DR["Email"];
row["LibrarianPassword"] = DR["LibrarianPassword"];
row["gender"] = DR["gender"];
row["Adress"] = DR["Adress"];
row["Phone_Number"] = DR["Phone_Number"];
row["Registerdate"] = DR["Registerdate"];
dt.Rows.Add(row);
}
dataGridViewUpdateLibariyan.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void UpdateLibariyanDetail_Load(object sender, EventArgs e)
{
//geting all Libariyan details Libariyan table
try
{
LibriyanDB obj = new LibriyanDB();
SqlDataReader DR = obj.getLibariyanInfo();
DataTable dt = new DataTable();
dt.Columns.Add("LibrarianID");
dt.Columns.Add("FristName");
dt.Columns.Add("LastName");
dt.Columns.Add("Email");
dt.Columns.Add("LibrarianPassword");
dt.Columns.Add("gender");
dt.Columns.Add("Adress");
dt.Columns.Add("Phone_Number");
dt.Columns.Add("Registerdate");
while (DR.Read())
{
DataRow row = dt.NewRow();
row["LibrarianID"] = DR["LibrarianID"];
row["FristName"] = DR["FristName"];
row["LastName"] = DR["LastName"];
row["Email"] = DR["Email"];
row["LibrarianPassword"] = DR["LibrarianPassword"];
row["gender"] = DR["gender"];
row["Adress"] = DR["Adress"];
row["Phone_Number"] = DR["Phone_Number"];
row["Registerdate"] = DR["Registerdate"];
dt.Rows.Add(row);
}
dataGridViewUpdateLibariyan.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void ButtonSave_Click(object sender, EventArgs e)
{
if (textBoxNICNumber.Text == "")
{
MessageBox.Show("Insert NIC Number", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (textBoxFristName.Text == "")
{
MessageBox.Show("Insert Frist Name", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (textBoxLastName.Text == "")
{
MessageBox.Show("Insert Last Name", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (textBoxEmail.Text == "")
{
MessageBox.Show("Insert Email", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (textBoxPassword.Text == "")
{
MessageBox.Show("Insert password", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (textBoxConfirmpassword.Text == "")
{
MessageBox.Show("Insert Confirm Password", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (richTextBoxAdress.Text == "")
{
MessageBox.Show("Insert Adress", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (textBoxPhonenumber.Text == "")
{
MessageBox.Show("Insert PhoneNumber", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
// finding duplicate values
try
{
LibriyanDB objt = new LibriyanDB();
//obj.NICNumber1 = textBoxNICNumber.Text;
SqlDataReader DR = objt.SearchDuplicatevalues(textBoxNICNumber.Text);
SqlCommand cmd = new SqlCommand();
int count = 0;
while (DR.Read())
{
count += 1;
}
if (count == 1)
{
MessageBox.Show("This ID is Alradey in the database!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{//inserting data
LibriyanDB obj = new LibriyanDB();
obj.NICNumber1 = textBoxNICNumber.Text;
obj.FristName1 = textBoxFristName.Text;
obj.LastName1 = textBoxLastName.Text;
obj.Email1 = textBoxEmail.Text;
obj.Password = textBoxConfirmpassword.Text;
obj.Gender1 = Gender;
obj.Address1 = richTextBoxAdress.Text;
obj.Phonenumber1 = Convert.ToInt32(textBoxPhonenumber.Text);
obj.Regdate = DateTime.Now;
obj.addNewLibariyan(obj);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
// sending user password via gmail
try
{
SmtpClient smtp = new SmtpClient("smtp.gmail.com", 587);
smtp.EnableSsl = true;
smtp.UseDefaultCredentials = false;
smtp.Credentials = new NetworkCredential("*****@*****.**", "ishpvi928280");
MailMessage mail = new MailMessage("*****@*****.**", textBoxEmail.Text, "You Register as Libariyan !Your loinid is Your NIC Number and password given bellow ", textBoxConfirmpassword.Text);
mail.Priority = MailPriority.High;
smtp.Send(mail);
MessageBox.Show("Mail Send");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
// clear text fileds
textBoxNICNumber.Text = "";
textBoxFristName.Text = "";
textBoxLastName.Text = "";
textBoxEmail.Text = "";
textBoxPassword.Text = "";
textBoxConfirmpassword.Text = "";
richTextBoxAdress.Text = "";
textBoxPhonenumber.Text = "";
}
}
private void ButtonUpdate_Click(object sender, EventArgs e)
{
//Update button coding
if (textBoxFristName.Text == "")
{
MessageBox.Show("Insert Frist Name", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (textBoxLastName.Text == "")
{
MessageBox.Show("Insert Last Name", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (textBoxEmail.Text == "")
{
MessageBox.Show("Insert Email", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (textBoxPassword.Text == "")
{
MessageBox.Show("Insert password", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (textBoxConfirmpassword.Text == "")
{
MessageBox.Show("Insert Confirm Password", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (richTextBoxAdress.Text == "")
{
MessageBox.Show("Insert Adress", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (textBoxPhonenumber.Text == "")
{
MessageBox.Show("Insert PhoneNumber", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
LibriyanDB obj = new LibriyanDB();
String NICNO;
NICNO = dataGridViewUpdateLibariyan.SelectedCells[0].Value.ToString();
obj.NICNumber1 = NICNO;
obj.FristName1 = textBoxFristName.Text;
obj.LastName1 = textBoxLastName.Text;
obj.Email1 = textBoxEmail.Text;
obj.Password = textBoxPassword.Text;
obj.Gender1 = comboBoxGender.Text;
obj.Address1 = richTextBoxAdress.Text;
obj.Phonenumber1 = Convert.ToInt32(textBoxPhonenumber.Text);
obj.enterupdaeLibrarian(obj);
// refersh table
try
{
LibriyanDB obcj = new LibriyanDB();
SqlDataReader DR = obcj.getLibariyanInfo();
DataTable dt = new DataTable();
dt.Columns.Add("LibrarianID");
dt.Columns.Add("FristName");
dt.Columns.Add("LastName");
dt.Columns.Add("Email");
dt.Columns.Add("LibrarianPassword");
dt.Columns.Add("gender");
dt.Columns.Add("Adress");
dt.Columns.Add("Phone_Number");
dt.Columns.Add("Registerdate");
while (DR.Read())
{
DataRow row = dt.NewRow();
row["LibrarianID"] = DR["LibrarianID"];
row["FristName"] = DR["FristName"];
row["LastName"] = DR["LastName"];
row["Email"] = DR["Email"];
row["LibrarianPassword"] = DR["LibrarianPassword"];
row["gender"] = DR["gender"];
row["Adress"] = DR["Adress"];
row["Phone_Number"] = DR["Phone_Number"];
row["Registerdate"] = DR["Registerdate"];
dt.Rows.Add(row);
}
dataGridViewUpdateLibariyan.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
// send email
try
{
SmtpClient smtp = new SmtpClient("smtp.gmail.com", 587);
smtp.EnableSsl = true;
smtp.UseDefaultCredentials = false;
smtp.Credentials = new NetworkCredential("*****@*****.**", "ishpvi928280");
MailMessage mail = new MailMessage("*****@*****.**", textBoxEmail.Text, "Your detalis has been updated get more info please contact administor!!Your loinid is Your NIC Number and password given bellow ", textBoxConfirmpassword.Text);
mail.Priority = MailPriority.High;
smtp.Send(mail);
MessageBox.Show("Mail Send");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
// clear text filed
textBoxFristName.Text = "";
textBoxLastName.Text = "";
textBoxEmail.Text = "";
textBoxPassword.Text = "";
textBoxConfirmpassword.Text = "";
richTextBoxAdress.Text = "";
textBoxPhonenumber.Text = "";
}
}
