private void bttnAddNew_Click(object sender, System.EventArgs e)
{
FORMLibrarian_Modify.ADD_STATE = true;
FORMLibrarian_Modify sForm = new FORMLibrarian_Modify();
sForm.ShowDialog();
}
private void bttnModify_Click(object sender, System.EventArgs e)
{
if (lvLibrarian.Items[lvLibrarian.FocusedItem.Index].SubItems[0].Text == clsVariables.sLibrarianID)
{
if (lvLibrarian.Items.Count > 0)
{
try
{
FORMLibrarian_Modify.ADD_STATE = false;
FORMLibrarian_Modify.sLibrarianID = lvLibrarian.Items[lvLibrarian.FocusedItem.Index].SubItems[0].Text;
FORMLibrarian_Modify sForm = new FORMLibrarian_Modify();
sForm.ShowDialog();
}
catch (ArgumentOutOfRangeException aooreE) { MessageBox.Show("" + aooreE.Message); }
catch (NullReferenceException nreE) {}
}
else
{
MessageBox.Show("No record to edit.", clsVariables.sMSGBOX, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
else
{
MessageBox.Show("Cannot Edit the Profile of " + lvLibrarian.Items[lvLibrarian.FocusedItem.Index].SubItems[1].Text + ". Pls. try again later.", clsVariables.sMSGBOX, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void FORMLibrarian_Modify_Load(object sender, System.EventArgs e)
{
if (ADD_STATE == true)
{
picLOGO.Image = MDIFORM.i32x32.Images[13];
//Set Add OleDbCommand
cmdAddLibrarian = new OleDbCommand("INSERT INTO tblLibrarian(LibrarianID,FirstName,MiddleName,LastName,StreetAddress,ZipCode,ContactNo,EmailAddress,UserName,UPassword) VALUES(@getLibrarianID,@getFirstName,@getMiddleName,@getLastName,@getStreetAddress,@getZipCode,@getContactNo,@getEmailAddress,@getUserName,@getUPassword)", clsConnections.CN);
this.Text = "Add New";
}
else
{
picLOGO.Image = MDIFORM.i32x32.Images[14];
//Picture Details
try
{
if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + "\\@Pictures\\@Librarian\\" + sLibrarianID + ".lms") == true)
{
picLibrarian.Image = Image.FromFile(AppDomain.CurrentDomain.BaseDirectory + "\\@Pictures\\@Librarian\\" + sLibrarianID + ".lms", true);
}
}
catch (Exception ex) {}
txtLibraryID.ReadOnly = true;
//Set Edit OleDbCommand
cmdAddLibrarian = new OleDbCommand("UPDATE tblLibrarian SET LibrarianID =@getLibrarianID, FirstName =@getFirstName, MiddleName =@getMiddleName, LastName =@getLastName, StreetAddress =@getStreetAddress, ZipCode =@getZipCode, ContactNo =@getContactNo, EmailAddress =@getEmailAddress, UserName =@getUserName, UPassword =@getUPassword WHERE LibrarianID LIKE '" + sLibrarianID + "' ", clsConnections.CN);
FillFields();
this.Text = "Edit Existing";
}
cmdAddLibrarian.Parameters.Add("@getLibrarianID", OleDbType.VarChar);
cmdAddLibrarian.Parameters.Add("@getFirstName", OleDbType.VarChar);
cmdAddLibrarian.Parameters.Add("@getMiddleName", OleDbType.VarChar);
cmdAddLibrarian.Parameters.Add("@getLastName", OleDbType.VarChar);
cmdAddLibrarian.Parameters.Add("@getStreetAddress", OleDbType.VarChar);
cmdAddLibrarian.Parameters.Add("@getZipCode", OleDbType.VarChar);
cmdAddLibrarian.Parameters.Add("@getContactNo", OleDbType.VarChar);
cmdAddLibrarian.Parameters.Add("@getEmailAddress", OleDbType.VarChar);
cmdAddLibrarian.Parameters.Add("@getUserName", OleDbType.VarChar);
cmdAddLibrarian.Parameters.Add("@getUPassword", OleDbType.VarChar);
publcLibrarianList = this;
}