private void Button1_Click(object sender, EventArgs e)
{
Classes.Admin lib = new Classes.Admin();
DataTable tbl = lib.searchLibrarian(txt_search_key.ToString());
view_librarians.DataSource = tbl;
}
private void Btn_addLibrarian_Click(object sender, EventArgs e)
{
if ((txt_firstName.Text == "") || (txt_lastName.Text == "") || (txt_addLine1.Text == "") ||
(txt_addCity.Text == "") || (txt_contactNo.Text == "") || (cmb_libType.Text == "") ||
(txt_username.Text == "") || (txt_password.Text == ""))
{
MessageBox.Show("Required Fields are Empty", "Empty Fields", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
Classes.Admin lib = new Classes.Admin();
string fName = txt_firstName.Text;
string lName = txt_lastName.Text;
string line1 = txt_addLine1.Text;
string city = txt_addCity.Text;
string contact = txt_contactNo.Text;
string libtype = cmb_libType.Text;
string username = txt_username.Text;
string password = txt_password.Text;
//int r = book.testAdd(bname, auth);
int r = lib.addLibrarian(fName, lName, line1, city, contact, username, password, libtype);
if (r != 0)
{
MessageBox.Show("Data Saved");
}
else
{
MessageBox.Show("Data Not Saved");
}
clean();
}
}
public Information(Classes.Admin admin)
{
InitializeComponent();
txbUser.Text = admin.Login;
string connectionString = DataBase.data;
string getUsers = "GET_USERS";
string getInformation = "GET_INFORMATION";
try
{
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
SqlCommand getUsersCommand = new SqlCommand(getUsers, sqlConnection);
getUsersCommand.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader readerUser = getUsersCommand.ExecuteReader();
List <Classes.User> users = new List <Classes.User>();
if (readerUser.HasRows)
{
while (readerUser.Read())
{
Classes.User user = new Classes.User();
user.idUser = readerUser.GetValue(0);
user.login = readerUser.GetValue(1);
user.password = readerUser.GetValue(2);
user.idAdmin = readerUser.GetValue(3);
users.Add(user);
}
}
readerUser.Close();
usersGrid.ItemsSource = users;
SqlCommand getInformationCommand = new SqlCommand(getInformation, sqlConnection);
getInformationCommand.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader readerTheme = getInformationCommand.ExecuteReader();
List <Theme> themes = new List <Theme>();
if (readerTheme.HasRows)
{
while (readerTheme.Read())
{
Theme theme = new Theme();
theme.NameTheme = readerTheme.GetValue(0);
theme.NameTest = readerTheme.GetValue(1);
theme.NameQuestion = readerTheme.GetValue(2);
themes.Add(theme);
}
}
readerTheme.Close();
themsGrid.ItemsSource = themes;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!HasWriteAccess)
return;
Classes.Admin admin = null;
if (newAdmin)
{
admin = new Classes.Admin();
}
else
{
admin = Classes.Admin.Fetch(username);
}
if (admin != null)
{
#region Saving username
if (newAdmin)
{
try
{
Classes.User.ValidateUsername(txtUsername.Text);
if (Classes.Admin.IsUsernameTaken(txtUsername.Text))
{
MessageBox.Show(Lang.TransA("Username is already taken"), Misc.MessageType.Error);
return;
}
admin.Username = txtUsername.Text;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, Misc.MessageType.Error);
return;
}
}
#endregion
#region Saving passwords
if (ValidatePasswords(admin))
{
if (txtNewPassword.Text != "")
{
try
{
admin.Password = txtNewPassword.Text;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, Misc.MessageType.Error);
return;
}
}
}
else return;
#endregion
#region Saving permissions
if (Config.AdminSettings.AdminPermissionsEnabled && admin.Username != Config.Users.SystemUsername)
{
Classes.Admin.RawAdminPrivileges rawprivileges =
new Classes.Admin.RawAdminPrivileges();
foreach (DataGridItem item in gridPermissions.Items)
{
string section = ((Literal) item.FindControl("litSection")).Text;
bool read = ((CheckBox) item.FindControl("cbReadPermission")).Checked;
bool write = ((CheckBox) item.FindControl("cbWritePermission")).Checked;
rawprivileges.lSections.Add(section);
rawprivileges.lReadPermissions.Add(read);
rawprivileges.lWritePermissions.Add(write);
}
admin.Privileges = Classes.Admin.GetPrivilegesFromRawData(rawprivileges);
}
#endregion
if (newAdmin)
{
Classes.Admin.Create(admin);
MessageBox.Show(Lang.TransA("The account has been successfully created"), Misc.MessageType.Success);
}
else
{
admin.Update();
if (CurrentAdminSession.Username == admin.Username)
CurrentAdminSession.Load();
MessageBox.Show(Lang.TransA("The account has been successfully updated"), Misc.MessageType.Success);
}
}
else
{
//this admin no longer exists
}
}
private void PopulateDataGrid()
{
Classes.Admin admin;
if (newAdmin)
{
admin = new Classes.Admin();
}
else
{
admin = Classes.Admin.Fetch(username);
}
if (admin != null)
{
#region BindPermissions
DataTable dtPermissions = new DataTable("Permissions");
dtPermissions.Columns.Add("Section");
dtPermissions.Columns.Add("Read", typeof (Boolean));
dtPermissions.Columns.Add("Write", typeof (Boolean));
Classes.Admin.RawAdminPrivileges rawdata =
Classes.Admin.GetRawDataFromPrivileges(admin.Privileges);
for (int i = 0; i < rawdata.lSections.Count; ++i)
{
dtPermissions.Rows.Add(new object[]
{
rawdata.lSections[i],
rawdata.lReadPermissions[i],
rawdata.lWritePermissions[i]
}
);
}
gridPermissions.DataSource = dtPermissions;
gridPermissions.DataBind();
#endregion
}
else
{
//this admin no longer exists
}
}
