private void Button1_Click(object sender, EventArgs e) { //Approve if (cmbStatusID.SelectedIndex == 0) { int rowIndex = issueRequestGridView.CurrentCell.RowIndex; DataGridViewRow row = issueRequestGridView.Rows[rowIndex]; int memberID = Convert.ToInt32(row.Cells[1].Value); int bookID = Convert.ToInt32(row.Cells[3].Value); int totalCurrentIssues = SelectQueries.CountCurrentIssuedBooks(memberID); int allowedIssues = SelectQueries.CountMemberIssueLimit(memberID); //MEMBER IS IN HIS ISSUE LIMIT if (totalCurrentIssues < allowedIssues) { int bookIssueCount = SelectQueries.BookIssuedCount(memberID, bookID, "YES"); int bookIssueLimit = SelectQueries.BookReissueLimitCount(bookID, memberID); //member is in limit of reissuing current book if (bookIssueCount < bookIssueLimit) { string issueDate = DateTime.Now.Date.ToShortDateString(); string returnDate = issueReturnDate.Value.ToShortDateString(); if (SelectQueries.GetCopiesAvailable(bookID) > 0) { InsertQueries.IssueBook(bookID, memberID, issueDate, returnDate, "NO"); UpdateQueries.DecreaseBookQuantitiy(bookID); UpdateQueries.FinishIssueRequest("APPROVED", Convert.ToInt32(cmbIssueRequestID.SelectedValue.ToString())); MessageBox.Show("BOOK ISSUED SUCCESSFULLY", "RESULT", MessageBoxButtons.OK, MessageBoxIcon.Information); ViewIssueRequests(); } else { MessageBox.Show("NO COPIES AVAILABLE IN THE LIBRARY \n " + "PLEASE WAIT TILL COPIES BECOME AVAILABLE", "REJECTED", MessageBoxButtons.OK, MessageBoxIcon.Hand); } } else { MessageBox.Show("REISSUE LIMIT OF THIS PARTICULAR BOOK REACHED \n " + "CAN NO MORE ISSUE THIS SAME BOOK", "REJECTED", MessageBoxButtons.OK, MessageBoxIcon.Hand); } } else { MessageBox.Show("ISSUE LIMIT OF MEMBER REACHED \n " + "CAN NO MORE ISSUE ANY BOOK", "REJECTED", MessageBoxButtons.OK, MessageBoxIcon.Hand); } } //DECLINED if (cmbStatusID.SelectedIndex == 1) { UpdateQueries.FinishIssueRequest("DECLINED", Convert.ToInt32(cmbIssueRequestID.SelectedValue.ToString())); ViewIssueRequests(); MessageBox.Show("ISSUE REQUEST DECLINED\n ", "DECLINED", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void Button3_Click(object sender, EventArgs e) { int bookID = Convert.ToInt32(cmbBookID.SelectedValue.ToString()); string status = "PENDING"; InsertQueries.InsertIntoIssueRequest(memberID, bookID, status); MessageBox.Show("Issue request successfully sent"); }
private void Button2_Click(object sender, EventArgs e) { double dueAmount = 0; int rowIndex = returnRequestGridView.CurrentCell.RowIndex; DataGridViewRow row = returnRequestGridView.Rows[rowIndex]; DateTime returnDate = Convert.ToDateTime(row.Cells[3].Value); int issueID = Convert.ToInt32(row.Cells[0].Value); try { if (DateTime.Compare(DateTime.Today, returnDate) > 0) { if (txtOverdueAmount.Text.Trim() == "") { MessageBox.Show("AMOUNT CANNOT BE EMPTY"); } else { dueAmount = Convert.ToDouble(txtOverdueAmount.Text.Trim()); try { InsertQueries.InsertIntoOverdue(issueID, dueAmount, cmbPaidStatus.SelectedValue.ToString()); UpdateQueries.FinishReturnRequest(Convert.ToInt32(cmbReturnRequestID.SelectedValue.ToString())); UpdateQueries.UpdateIssueReturnRequest(issueID); UpdateQueries.IncreaseBookQuantity(SelectQueries.GetBookidFromIssueId(issueID)); MessageBox.Show("Return request successfully served"); ViewReturnRequests(); } catch (Exception exc) { Console.WriteLine(exc); } } } else { try { InsertQueries.InsertIntoReturn(issueID, DateTime.Now.Date.ToShortDateString()); UpdateQueries.FinishReturnRequest(Convert.ToInt32(cmbReturnRequestID.SelectedValue.ToString())); UpdateQueries.UpdateIssueReturnRequest(issueID); UpdateQueries.IncreaseBookQuantity(SelectQueries.GetBookidFromIssueId(issueID)); MessageBox.Show("Return request successfully served"); ViewReturnRequests(); } catch (Exception exc) { Console.WriteLine(exc); } } } catch (Exception ex) { MessageBox.Show("Due amount can only be in number"); Console.WriteLine(ex); } }
static void Main(string[] args) { InsertQueries iq = new InsertQueries(); string uName, uPass, email, contact; Console.WriteLine("What is your Username?"); uName = Console.ReadLine(); Console.WriteLine("What is your Password?"); uPass = Console.ReadLine(); Console.WriteLine("What is your Email?"); email = Console.ReadLine(); Console.WriteLine("What is your Contact Number?"); contact = Console.ReadLine(); iq.CreateUser(uName, uPass, email, contact); Console.WriteLine("User Has Been Saved!"); // To keep the CONSOLE OPEN Console.Read(); }
//public static ILog Logger; internal static void StartAudit() { AuditMaster audit = winaudits.ReadQueries.GetAuditMaster("auditmaster", 0); if (audit != null) { winaudits.UpdateQuery.ExcecuteUpdateQuery(1, audit.ClientJobID); try { if (audit.IncludeUser == 1) { List <User> users = UserProfileAuditor.StartAudit(); InsertQueries.InsertUserDetails(users, audit.ClientJobID); } if (audit.IncludeProcess == 1) { List <RunningProcess> process = ProcessList.StartAudit(); InsertQueries.InsertProcessDetails(process, audit.ClientJobID); } if (audit.IncludeServices == 1) { List <Services> service = ServiceEnum.StartAudit(); InsertQueries.InsertServicesDetails(service, audit.ClientJobID); } if (audit.IncludeNetworkInfo == 1) { List <winaudits.Networkconnection> networkconnection = winaudits.NetworkAuditor.StartAudit(); InsertQueries.InsertNetworkconnectionDetails(networkconnection, audit.ClientJobID); } if (audit.IncludeInstalledApp == 1) { List <InstalledApp> recentinstall = InstalledAppAuditor.StartAudit(); InsertQueries.InsertRecentlyInstall(recentinstall, audit.ClientJobID); } if (audit.IncludeAutoRunPoints == 1) { List <winaudits.Autorunpoints> runPoints = winaudits.AutoRunManager.StartAudit(); InsertQueries.InsertAutorunpointsDetails(runPoints, audit.ClientJobID); } if (audit.IncludePrefetch == 1) { List <Prefetch> recentinstall = PrefetchAuditor.StartAudit(); InsertQueries.InsertPrefetchDetails(recentinstall, audit.ClientJobID); } if (audit.IncludeTask == 1) { List <RunningTasks> runningtasks = TaskAuditor.StartAudit(); InsertQueries.InsertTaskDetails(runningtasks, audit.ClientJobID); } if (audit.IncludeArp == 1) { List <ARP> runningtasks = ARPAuditor.StartAudit(); InsertQueries.InsertArpDetails(runningtasks, audit.ClientJobID); } } catch (System.Exception ex) { //AuditManager.Logger.Error(ex); } winaudits.UpdateQuery.ExcecuteUpdateQuery(2, audit.ClientJobID); } }