private void btn_delete_user_Click(object sender, EventArgs e)
{
string user_name = tb_userName_user.Text.ToString().Trim();
UserControls userControls = new UserControls();
if (isValidString(user_name))
{
User user = userControls.SearchUser(user_name, "user");
if (user != null)
{
bool isDeleted = userControls.DeleteUser(user_name, "user");
if (isDeleted)
{
LoadUsers();
MessageBox.Show("User Deleted.");
}
else
{
MessageBox.Show("User can not be Deleted.");
}
}
else
{
MessageBox.Show("User Doesn't Exist.");
}
}
else
{
MessageBox.Show("Enter User Name.");
}
}
private void btn_user_name_enter_issue_Click(object sender, EventArgs e)
{
string user_name = tb_user_name_issue.Text.Trim();
if (isValidString(user_name))
{
UserControls userControls = new UserControls();
User user = userControls.SearchUser(user_name, "user");
if (user != null)
{
IssueControls issueControls = new IssueControls();
List <Issue> issues = issueControls.LoadIssuesByUser(user_name);
int issued = 0;
int returned = 0;
int expired = 0;
foreach (Issue i in issues)
{
if (i.Status.Equals("Issued"))
{
issued++;
}
else if (i.Status.Equals("Rerturned"))
{
returned++;
}
else
{
expired++;
}
}
lbl_user_info_issue.Text = "Returned: " + returned + " Issued: " + issued + " Expired: " + expired;
if (expired == 0)
{
tb_book_id_issue.Enabled = true;
btn_book_enter_issue.Enabled = true;
tb_user_name_issue.Enabled = false;
btn_user_name_enter_issue.Enabled = false;
}
}
else
{
MessageBox.Show("User Doesn't Exist.");
}
}
else
{
MessageBox.Show("Enter User Name.");
}
}
public void SearchIssue(int id)
{
IssueControls issueControls = new IssueControls();
Issue issue = issueControls.SearchIssue(id);
if (issue != null)
{
string user_name = issue.UserName;
int book_id = issue.BookId;
UserControls userControls = new UserControls();
User user = userControls.SearchUser(user_name, "user");
BookControls bookControls = new BookControls();
Book book = bookControls.SearchBook(book_id);
if (user != null && book != null)
{
tb_issue_id_issue.Text = issue.Id.ToString().Trim();
tb_user_name_issue.Text = issue.UserName.Trim();
tb_book_id_issue.Text = issue.BookId.ToString().Trim();
cb_status_issue.SelectedIndex = cb_status_issue.FindStringExact(issue.Status.Trim());
dtp_issue_date_issue.Value = DateTime.ParseExact(issue.IssueDate, "dd/MM/yyyy", CultureInfo.InvariantCulture);
dtp_tobe_return_issue.Value = DateTime.ParseExact(issue.TobeRetunDate, "dd/MM/yyyy", CultureInfo.InvariantCulture);
if (issue.ReturnDate.Equals("nill"))
{
dtp_return_date_issue.Value = DateTime.Now;
}
else
{
dtp_return_date_issue.Value = DateTime.ParseExact(issue.ReturnDate, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
EnableViews();
cb_search_issue.SelectedIndex = cb_search_issue.FindStringExact("User");
gv_info_issue.DataSource = issueControls.LoadIssuesByUser(user_name);
}
else
{
MessageBox.Show("User or Book Doesn't Exist.");
}
}
else
{
MessageBox.Show("Issue Doesn't Exist.");
}
}
private void SearchUser(string user_name)
{
UserControls userControls = new UserControls();
User user = userControls.SearchUser(user_name, "user");
if (user != null)
{
tb_userName_user.Text = user.User_Name;
tb_name_user.Text = user.Name;
tb_phone_user.Text = Convert.ToString(user.Phone);
tb_location_user.Text = user.Location;
tb_pass_user.Text = user.Password;
dtp_dob_user.Value = DateTime.ParseExact(user.DOB, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
else
{
MessageBox.Show("No User Found.");
}
}
private void btn_add_user_Click(object sender, EventArgs e)
{
string user_name = tb_userName_user.Text.ToString().Trim();
string name = tb_name_user.Text.ToString().Trim();
string sphone = tb_phone_user.Text.ToString().Trim();
string location = tb_location_user.Text.ToString().Trim();
string dob = dtp_dob_user.Value.ToString("dd/MM/yyyy").Trim();
string password = tb_pass_user.Text.ToString().Trim();
if (isValidString(user_name) && isValidString(name) && isValidString(location) && isValidString(password) && isValidString(sphone))
{
int phone = int.Parse(sphone);
UserControls userControls = new UserControls();
User user = userControls.SearchUser(user_name, "user");
if (user == null)
{
user = new User(user_name, name, phone, location, dob, "user", password);
userControls = new UserControls(user);
bool isAdded = userControls.AddUser();
if (isAdded)
{
LoadUsers();
MessageBox.Show("User Added.");
}
else
{
MessageBox.Show("User can not be Added.");
}
}
else
{
MessageBox.Show("User Already Exists.");
}
}
else
{
MessageBox.Show("Please Enter All Info.");
}
}
