private void Clear_btn_Click(object sender, EventArgs e)
{
#region EDW - DSTR Test
//var confRef = SecurityAccessor.Instance.EncryptConfig;
//var clientConfigDB = confRef.GetOracleDBService();
////Print end of day reports
//var credentials = new Credentials
//{
// UserName = confRef.DecryptValue(clientConfigDB.DbUser),
// PassWord = confRef.DecryptValue(clientConfigDB.DbUserPwd),
// DBHost = confRef.DecryptValue(clientConfigDB.Server),
// DBPort = confRef.DecryptValue(clientConfigDB.Port),
// DBService = confRef.DecryptValue(clientConfigDB.AuxInfo),
// DBSchema = confRef.DecryptValue(clientConfigDB.Schema)
//};
//var o = new BalanceCash();
//o.ExecuteDSTR(credentials, GlobalDataAccessor.Instance.CurrentSiteId.StoreNumber, true);
#endregion
#region EDW Gunbook Inquiry test code
// EDW - Gunbook Inquiry test code
int gunnumber_begin = this.txtGunNumber.X <int>();
int gunnumber_end = this.txtGunNumberTo.X <int>();
int orggunnumber_begin = this.txtOriginalGunNumber.X <int>();
int orggunnumber_end = this.txtOriginalGunNumberTo.X <int>();
int ticketnumber = txtLoanTicketNumber.X <int>();
int icn_store = ucICN.Shop;
int icn_year = ucICN.Year;
int icn_doc = ucICN.Doc;
string icn_doc_type = ucICN.DocType;
int icn_item = ucICN.Item;
int icn_sub_item = ucICN.SubItem;
string bound = this.cbBound.X <string>();
string model = this.txtModel.X <string>();
string serialnumber = txtSerialNumber.X <string>();
string type = cbType.X <string>();
string status = cbStatus.X <string>();
int gunbook_begin = this.txtGunBookPage.X <int>();
int gunbook_end = this.txtGunBookPageTo.X <int>();
string acq_startDate = this.ucAcq.StartDate;
string acq_endDate = this.ucAcq.EndDate;
string acq_lastname = this.ucAcq.LastName;
string acq_firstname = this.ucAcq.FirstName;
string acq_customernumber = this.ucAcq.CustomerNumber;
string disp_startDate = this.ucDep.StartDate; // MM/DD/YYYY
string disp_endDate = this.ucDep.EndDate;
string disp_lastname = this.ucDep.LastName;
string disp_firstname = this.ucDep.FirstName;
string disp_customernumber = this.ucDep.CustomerNumber;
GunBookInquiry.sortField_enum sortBy = GunBookInquiry.sortField_enum.GUNNUMBER;
Inquiry.sortDir_enum sortDir = Inquiry.sortDir_enum.DESCENDING;
// EDW - Gunbook Inquiry COUNT test code
//DataSet ds = GunBookInquiry.getGunBookTestDataCount(
// gunnumber_begin,
// gunnumber_end,
// orggunnumber_begin,
// orggunnumber_end,
// ticketnumber,
// icn_store,
// icn_year,
// icn_doc,
// icn_doc_type,
// icn_item,
// icn_sub_item,
// bound,
// model,
// serialnumber,
// type,
// status,
// gunbook_begin,
// gunbook_end,
// acq_startDate , // MM/DD/YYYY
// acq_endDate ,
// acq_lastname ,
// acq_firstname ,
// acq_customernumber ,
// disp_startDate , // MM/DD/YYYY
// disp_endDate ,
// disp_lastname ,
// disp_firstname ,
// disp_customernumber
// );
//var columnNum = ds.Tables[0].Rows[0][0];
//var value = ds.Tables[0].Rows[0][1]; // <-- Count
// EDW - Gunbook Inquiry DATA test code
DataSet ds = GunBookInquiry.getData(
gunnumber_begin,
gunnumber_end,
orggunnumber_begin,
orggunnumber_end,
ticketnumber,
icn_store,
icn_year,
icn_doc,
icn_doc_type,
icn_item,
icn_sub_item,
bound,
model,
serialnumber,
type,
status,
gunbook_begin,
gunbook_end,
acq_startDate, // MM/DD/YYYY
acq_endDate,
acq_lastname,
acq_firstname,
acq_customernumber,
disp_startDate, // MM/DD/YYYY
disp_endDate,
disp_lastname,
disp_firstname,
disp_customernumber,
sortBy,
sortDir
);
if (ds != null)
{
var columnNum = ds.Tables[0].Rows[0][0];
var value = ds.Tables[0].Rows[0][1];
}
#endregion
// actual button code (e.g. non-test code)
clear_fields();
}
private void Find_btn_Click(object sender, EventArgs e)
{
#region Dates
string dateStartString = "01/01/2012"; // dateCalendarStart.SelectedDate;
string dateEndString = "05/01/2012"; // dateCalendarEnd.SelectedDate;
//if (dateCalendarStart.SelectedDate == "mm/dd/yyyy")
//{
// dateStartString = string.Empty;
//}
//if (dateCalendarEnd.SelectedDate == "mm/dd/yyyy")
//{
// dateEndString = string.Empty;
//}
DateTime dtStart = DateTime.MaxValue;
DateTime dtEnd = DateTime.MinValue;
DateTime.TryParse(dateStartString, out dtStart);
DateTime.TryParse(dateStartString, out dtEnd);
if (dtStart > dtEnd && dtEnd != DateTime.MinValue)
{
MessageBox.Show("'To:' date is greater than the 'From:' date. Please adjust the date.");
return;
}
#endregion
#region Amounts
decimal amtFrom = -1;
decimal amtTo = -1;
//if (fromAmount_tb.Text.Length != 0 && !decimal.TryParse(fromAmount_tb.Text, out amtFrom))
//{
// MessageBox.Show("'From' amount has an error. Please correct.");
// return;
//}
//if (toAmount_tb.Text.Length != 0 && !decimal.TryParse(toAmount_tb.Text, out amtTo))
//{
// MessageBox.Show("'To' amount has an error. Please correct.");
// return;
//}
if (amtFrom > amtTo)
{
MessageBox.Show("'To:' amount is greater than the 'From:' amount. Please adjust the amounts.");
return;
}
#endregion
#region TicketNumber
int loanTicketNumber = -1;
if (this.txtLoanTicketNumber.Text.Length != 0 && !int.TryParse(this.txtLoanTicketNumber.Text, out loanTicketNumber))
{
MessageBox.Show("'Loan Ticket Number:' is not a valid number. Please correct.");
return;
}
#endregion
#region DOB
string dob = string.Empty;
DateTime dtDob = DateTime.MinValue;
//if (txtDOB.DateTextBox.Text == "mm/dd/yyyy" || txtDOB.DateTextBox.Text.Length == 0)
//{
// dob = string.Empty;
//}
//else if (DateTime.TryParse(txtDOB.DateTextBox.Text, out dtDob))
//{
// if (dtDob.Year > DateTime.Now.Year)
// {
// dtDob = dtDob.AddYears(-100);
// }
// dob = dtDob.ToShortDateString();//.ToString("dd/MM/yyyy");
//}
//else
//{
// MessageBox.Show("'Date of Birth' is not a valid date. Please correct.");
// return;
//}
#endregion
Cursor.Current = Cursors.WaitCursor;
var gunBookInquiry = new GunBookInquiry()
{
startDate = dateStartString,
endDate = dateEndString,
lowAmount = amtFrom,
highAmount = amtTo,
//TODO
// lastName = this.txtLastName.Text,
// firstName = this.txtFirstName.Text,
dob = dob,
// customerNumber = this.txtCustomerNumber.Text,
loanTicketNumber = loanTicketNumber,
sortBy = (GunBookInquiry.sortField_enum)sortBy_cb.SelectedIndex,
sortDir = (Inquiry.sortDir_enum)sortDir_cb.SelectedIndex
};
DataSet dataSetReturned = null;
try
{
dataSetReturned = gunBookInquiry.getData();
if (dataSetReturned.IsNullOrEmpty())
{
throw new BusinessLogicException(ReportConstants.NODATA);
}
}
catch (BusinessLogicException blex)
{
MessageBox.Show(blex.Message);
return;
}
Cursor.Current = Cursors.Default;
this.Visible = false;
const string tableName = "PARTIAL_PAYMENT_INQ";
var resultsDisplay = new Forms.Inquiry.GunBookInquiry.GunBookSearchResults(dataSetReturned, gunBookInquiry, tableName);
resultsDisplay.ShowDialog();
if (resultsDisplay.DialogResult == DialogResult.Cancel)
{
this.Close();
}
else
{
this.Visible = true;
}
}