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);
}
}