private void btnPrint_Click(object sender, RoutedEventArgs e)
{
Mouse.OverrideCursor = Cursors.Wait;
ImusCityHallEntities db = new ImusCityHallEntities();
CDSSignatory signatories = db.CDSSignatories.FirstOrDefault();
if (voucherlistdg.SelectedValue == null)
{
Mouse.OverrideCursor = null;
MessageBox.Show("Please select an item");
}
else if (signatories == null)
{
Mouse.OverrideCursor = null;
MessageBox.Show("Please add report signatories");
}
else if (signatories.CityAccountant.Equals(null) || signatories.CityTreasurer.Equals(null) || signatories.CityAdministrator.Equals(null))
{
Mouse.OverrideCursor = null;
MessageBox.Show("Please add report signatories");
}
else
{
ReportWindow report = new ReportWindow();
report.id = (int)voucherlistdg.SelectedValue;
App.ReportID = 1;
report.Show();
Mouse.OverrideCursor = null;
}
Mouse.OverrideCursor = null;
}
public void CheckReport(int id)
{
if (SystemClass.CheckConnection())
{
ImusCityHallEntities db = new ImusCityHallEntities();
CDSSignatory signatories = db.CDSSignatories.FirstOrDefault();
CheckModel check = new CheckModel();
ImusCityGovernmentSystem.Model.Check checklist = db.Checks.Find(id);
check.CheckNo = checklist.CheckNo;
check.CheckDate = checklist.DateCreated.Value;
check.CompanyName = checklist.Disbursement.Payee == null ? checklist.Disbursement.PayeeName : checklist.Disbursement.Payee.CompanyName;
CurrencyToWords convert = new CurrencyToWords();
double amount = Convert.ToDouble(checklist.Amount.Value);
check.AmountInWords = convert.NumberToWords(amount).ToUpper();
check.CheckDescription = checklist.CheckDescription;
check.VoucherNo = checklist.Disbursement.VoucherNo;
check.Amount = checklist.Amount.Value;
check.Signatory1 = SystemClass.GetSignatory(signatories.CityMayor);
check.Signatory2 = SystemClass.GetSignatory(signatories.CityTreasurer);
ReportDocument report;
switch (bankName)
{
case "LB":
report = new LBCheckReport();
report.SetDataSource(new[] { check });
reportviewer.ViewerCore.ReportSource = report;
break;
case "UCPB":
report = new UCPBCheckReport();
report.SetDataSource(new[] { check });
reportviewer.ViewerCore.ReportSource = report;
break;
case "DBP":
report = new DBPCheckReport();
report.SetDataSource(new[] { check });
reportviewer.ViewerCore.ReportSource = report;
break;
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
public void CheckDisbursementVoucher(int id)
{
if (SystemClass.CheckConnection())
{
ImusCityHallEntities db = new ImusCityHallEntities();
List <DisbursementVoucherModel> DVList = new List <DisbursementVoucherModel>();
db = new ImusCityHallEntities();
DVList = new List <DisbursementVoucherModel>();
var disburse = db.GetDisbursementVoucher(id).ToList();
CDSSignatory signatories = db.CDSSignatories.FirstOrDefault();
foreach (var x in disburse)
{
DisbursementVoucherModel dvl = new DisbursementVoucherModel();
dvl.Amount = x.Amount.HasValue ? x.Amount.Value : 0;
dvl.Certification = x.Certification;
dvl.CompanyAddress = x.CompanyAddress;
dvl.CompanyName = x.CompanyName;
dvl.DateCreated = x.DateCreated.Value;
dvl.DepartmentCode = x.DepartmentCode;
dvl.Description = x.Explanation;
dvl.DocumentCompleted = x.DocumentCompleted;
dvl.Obligated = x.Obligated;
dvl.ObligationRequestNo = x.ObligationRequestNo;
dvl.TIN_EmpNo = x.TIN_EmpNo;
dvl.Unit_Project = x.Unit_Project;
dvl.VoucherNo = x.VoucherNo;
dvl.PaymentName = x.PaymentType;
dvl.Name = x.FundName;
dvl.Signatory = SystemClass.GetSignatory(signatories.CityAccountant);
dvl.Signatory2 = SystemClass.GetSignatory(signatories.CityTreasurer);
dvl.Signatory3 = SystemClass.GetSignatory(signatories.CityMayor);
DVList.Add(dvl);
}
ReportDocument report;
report = new DisbursementVoucherReport();
report.SetDataSource(DVList);
report.SetParameterValue("employee", "Generated By: " + SystemClass.Employee(App.EmployeeID));
report.SetParameterValue("actingmayor", signatories.UseActingMayor);
reportviewer.ViewerCore.ReportSource = report;
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
private void checkbtn_Click(object sender, RoutedEventArgs e)
{
Mouse.OverrideCursor = Cursors.Wait;
if (voucherlistdg.SelectedValue == null)
{
Mouse.OverrideCursor = null;
MessageBox.Show("Please select an item");
}
else
{
CheckDisbursement.AddNewCheckEntryWindow addcheck = new CheckDisbursement.AddNewCheckEntryWindow();
Mouse.OverrideCursor = null;
addcheck.DisbursementID = (int)voucherlistdg.SelectedValue;
if (SystemClass.CheckConnection())
{
ImusCityHallEntities db = new ImusCityHallEntities();
CDSSignatory signatories = db.CDSSignatories.FirstOrDefault();
if (signatories == null)
{
MessageBox.Show("Please add report signatories");
}
else if (signatories.CityMayor.Equals(null) || signatories.CityTreasurer.Equals(null))
{
MessageBox.Show("Please add report signatories");
}
else
{
addcheck.ShowDialog();
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
Mouse.OverrideCursor = null;
}
private void generatebtn_Click(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
if (String.IsNullOrEmpty(startdatedp.Text) || String.IsNullOrEmpty(enddatedp.Text))
{
MessageBox.Show("Please select start date and end date");
}
else
{
//int accountId = (int)fundcb.SelectedValue;
ImusCityHallEntities db = new ImusCityHallEntities();
CDSSignatory signatories = db.CDSSignatories.FirstOrDefault();
//FundBank account = db.FundBanks.Find(accountId);
List <CheckListingModel> list = new List <CheckListingModel>();
if (db.GetCheckListing(startdatedp.SelectedDate, enddatedp.SelectedDate).Count() <= 0)
{
MessageBox.Show("There are no record in this selection");
return;
}
var result = db.GetCheckListing(startdatedp.SelectedDate, enddatedp.SelectedDate);
foreach (var x in result)
{
var check = new CheckListingModel
{
AccountNumber = x.AccountNumber,
BankID = x.BankID,
BankName = x.BankName,
CheckAmount = x.CheckAmount.Value,
CheckDateCreated = x.CheckDateCreated.Value,
CheckDescription = x.CheckDescription,
CheckNo = x.CheckNo,
CheckUser = x.CHECK_USER,
ControlNo = x.ControlNo,
FundID = x.FundID.Value,
ProjectName = x.ProjectName,
Status = x.Status,
StatusID = x.StatusID.Value,
VoucherDateCreated = x.VoucherDateCreated.Value,
VoucherNumber = x.VoucherNo,
CanDelBy = x.CAN_DELETE_EMP,
CanDelDate = x.CAN_DELETE_DATE
};
list.Add(check);
}
if (!String.IsNullOrEmpty(fundcb.Text))
{
int accountId = (int)fundcb.SelectedValue;
list = list.Where(m => m.FundID == accountId).ToList();
}
if (!String.IsNullOrEmpty(statuscb.Text))
{
if (statuscb.Text != "All")
{
list = list.Where(m => m.Status == statuscb.Text).ToList();
}
}
ReportDataSet ds = new ReportDataSet();
ds.Locale = CultureInfo.InvariantCulture;
// FillDataSet(ds);
DataTable chkList = ds.Tables["CheckListingDataTable"];
foreach (CheckListingModel ch in list)
{
DataRow dr = chkList.Rows.Add();
dr.SetField("AccountNumber", ch.AccountNumber);
dr.SetField("BankID", ch.BankID);
dr.SetField("BankName", ch.BankName);
dr.SetField("CanDelBy", ch.CanDelBy);
dr.SetField("CanDelDate", ch.CanDelDate);
dr.SetField("CheckAmount", ch.CheckAmount);
dr.SetField("CheckDateCreated", ch.CheckDateCreated);
dr.SetField("CheckDescription", ch.CheckDescription);
dr.SetField("CheckNo", ch.CheckNo);
dr.SetField("CheckUser", ch.CheckUser);
dr.SetField("ControlNo", ch.ControlNo);
dr.SetField("FundID", ch.FundID);
dr.SetField("ProjectName", ch.ProjectName);
dr.SetField("Status", ch.Status);
dr.SetField("StatusID", ch.StatusID);
dr.SetField("VoucherDateCreated", ch.VoucherDateCreated);
dr.SetField("VoucherNumber", ch.VoucherNumber);
}
ReportDocument report;
report = new CheckDisbursement.Report.CheckListingReport();
report.SetDataSource(chkList);
report.SetParameterValue("employee", "Generated By: " + SystemClass.Employee(App.EmployeeID));
reportviewer.ViewerCore.ReportSource = report;
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
private void generatebtn_Click(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
if (fundcb.SelectedValue == null)
{
MessageBox.Show("Please select fund");
}
else if (String.IsNullOrEmpty(startdatedp.Text) || String.IsNullOrEmpty(enddatedp.Text))
{
MessageBox.Show("Please select start date and end date");
}
else
{
DateTime dateToday = DateTime.Now;
string year = dateToday.Year.ToString().Substring(dateToday.Year.ToString().Length - 2);
string month = dateToday.Month.ToString().PadLeft(2, '0');
int accountId = (int)fundcb.SelectedValue;
ImusCityHallEntities db = new ImusCityHallEntities();
CDSSignatory signatories = db.CDSSignatories.FirstOrDefault();
FundBank account = db.FundBanks.Find(accountId);
List <CheckIssuedModel> list = new List <CheckIssuedModel>();
if (db.GetCheckIssued(startdatedp.SelectedDate, enddatedp.SelectedDate, accountId).Count() <= 0)
{
MessageBox.Show("There are no record in this selection");
return;
}
var result = db.GetCheckIssued(startdatedp.SelectedDate, enddatedp.SelectedDate, accountId);
string adviceNo = account.AdviceNo.HasValue ? account.AdviceNo.ToString() : null;
foreach (var checkIssued in result)
{
var check = new CheckIssuedModel
{
StartDate = startdatedp.SelectedDate.Value,
EndDate = enddatedp.SelectedDate.Value,
BankName = checkIssued.BankName,
AccoutNumber = checkIssued.AccountNumber,
ReportNumber = string.Join("-", checkIssued.FundPrefix, year, month, adviceNo),
DateCreated = checkIssued.DateCreated.Value,
CheckNo = checkIssued.CheckNo,
VoucherNo = checkIssued.VoucherNo,
Center = "",
CompanyName = checkIssued.CompanyName,
PaymentNature = checkIssued.PaymentNature,
Amount = checkIssued.Amount.Value,
DisbursingOfficer = SystemClass.GetSignatory(signatories.DisbursingOfficer),
CanDelBy = checkIssued.CAN_DELETE_EMP,
CanDelDate = checkIssued.CAN_DELETE_DATE,
Status = checkIssued.Status,
StatusID = checkIssued.StatusID.Value
};
list.Add(check);
}
ReportDataSet ds = new ReportDataSet();
ds.Locale = CultureInfo.InvariantCulture;
// FillDataSet(ds);
DataTable chIss = ds.Tables["CheckIssuedDataTable"];
foreach (CheckIssuedModel ci in list)
{
DataRow dr = chIss.Rows.Add();
dr.SetField("AccountNumber", ci.AccoutNumber);
dr.SetField("Amount", ci.Amount);
dr.SetField("BankName", ci.BankName);
dr.SetField("CanDelBy", ci.CanDelBy);
dr.SetField("CanDelDate", ci.CanDelDate);
dr.SetField("Center", ci.Center);
dr.SetField("CheckNo", ci.CheckNo);
dr.SetField("CompanyName", ci.CompanyName);
dr.SetField("DateCreated", ci.DateCreated);
dr.SetField("DisbursingOfficer", ci.DisbursingOfficer);
dr.SetField("EndDate", ci.EndDate);
dr.SetField("PaymentNature", ci.PaymentNature);
dr.SetField("ReportNumber", ci.ReportNumber);
dr.SetField("StartDate", ci.StartDate);
dr.SetField("Status", ci.Status);
dr.SetField("StatusID", ci.StatusID);
dr.SetField("VoucherNo", ci.VoucherNo);
}
ReportDocument report;
report = new CheckDisbursement.Report.CheckIssuedReport();
report.SetDataSource(chIss);
report.SetParameterValue("employee", "Generated By: " + SystemClass.Employee(App.EmployeeID));
reportviewer.ViewerCore.ReportSource = report;
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
private void savebtn_Click(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
ImusCityHallEntities db = new ImusCityHallEntities();
if (db.CDSSignatories.Any())
{
ImusCityGovernmentSystem.Model.CDSSignatory signatory = db.CDSSignatories.FirstOrDefault();
signatory.CityMayor = mayorcb.SelectedValue == null ? null : (int?)mayorcb.SelectedValue;
switch (mayorrb.IsChecked)
{
case true:
signatory.UseActingMayor = false;
break;
case false:
signatory.UseActingMayor = true;
break;
}
signatory.CityTreasurer = treasurercb.SelectedValue == null ? null : (int?)treasurercb.SelectedValue;
signatory.CityAccountant = accountantcb.SelectedValue == null ? null : (int?)accountantcb.SelectedValue;
signatory.AccountantRepresentative = accountantrepcb.SelectedValue == null ? null : (int?)accountantrepcb.SelectedValue;
signatory.CityAdministrator = administratorcb.SelectedValue == null ? null : (int?)administratorcb.SelectedValue;
signatory.DisbursingOfficer = disbursingcb.SelectedValue == null ? null : (int?)disbursingcb.SelectedValue;
db.SaveChanges();
MessageBox.Show("Signatories for CDS was updated");
var audit = new AuditTrailModel
{
Activity = "Updated CDS signatories",
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
}
else
{
ImusCityGovernmentSystem.Model.CDSSignatory signatory = new CDSSignatory();
switch (mayorrb.IsChecked)
{
case true:
signatory.UseActingMayor = false;
break;
case false:
signatory.UseActingMayor = true;
break;
}
signatory.CityMayor = mayorcb.SelectedValue == null ? null : (int?)mayorcb.SelectedValue;
signatory.CityTreasurer = treasurercb.SelectedValue == null ? null : (int?)treasurercb.SelectedValue;
signatory.CityAccountant = accountantcb.SelectedValue == null ? null : (int?)accountantcb.SelectedValue;
signatory.AccountantRepresentative = accountantrepcb.SelectedValue == null ? null : (int?)accountantrepcb.SelectedValue;
signatory.CityAdministrator = administratorcb.SelectedValue == null ? null : (int?)administratorcb.SelectedValue;
signatory.DisbursingOfficer = disbursingcb.SelectedValue == null ? null : (int?)disbursingcb.SelectedValue;
db.CDSSignatories.Add(signatory);
db.SaveChanges();
MessageBox.Show("Signatories for CDS was updated");
var audit = new AuditTrailModel
{
Activity = "Added new CDS Signatories",
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
private void generatebtn_Click(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
if (fundcb.SelectedValue == null)
{
MessageBox.Show("Please select fund");
}
else if (String.IsNullOrEmpty(startdatedp.Text) || String.IsNullOrEmpty(enddatedp.Text))
{
MessageBox.Show("Please select start date and end date");
}
else
{
int accountId = (int)fundcb.SelectedValue;
ImusCityHallEntities db = new ImusCityHallEntities();
CDSSignatory signatories = db.CDSSignatories.FirstOrDefault();
FundBank account = db.FundBanks.Find(accountId);
if (db.GetCheckRegister(startdatedp.SelectedDate, enddatedp.SelectedDate, accountId).Count() <= 0)
{
MessageBox.Show("There are no record in this selection");
return;
}
var result = db.GetCheckRegister(startdatedp.SelectedDate, enddatedp.SelectedDate, accountId).Where(m => m.Status == "Created" || m.Status == "Cancelled" || m.Status == "Damaged");
CurrencyToWords convert = new CurrencyToWords();
double totalAmount = Convert.ToDouble(db.GetCheckRegister(startdatedp.SelectedDate, enddatedp.SelectedDate, accountId).Sum(m => m.Amount).Value);
string amountInWords = convert.NumberToWords(totalAmount).ToUpper();
ReportDataSet ds = new ReportDataSet();
ds.Locale = CultureInfo.InvariantCulture;
DataTable checkRegisterList = ds.Tables["CheckRegisterDataTable"];
foreach (var checkregister in result)
{
DataRow dr = checkRegisterList.Rows.Add();
dr.SetField("FundName", checkregister.FundName);
dr.SetField("Branch", checkregister.Branch);
dr.SetField("AccountNumber", checkregister.AccountNumber);
dr.SetField("BankName", checkregister.BankName);
dr.SetField("DateCreated", checkregister.DateCreated);
dr.SetField("CheckNo", checkregister.CheckNo);
dr.SetField("CompanyName", checkregister.CompanyName);
dr.SetField("Amount", checkregister.Amount);
dr.SetField("AmountInWords", amountInWords);
dr.SetField("Status", checkregister.Status);
}
ReportDocument report;
report = new CheckDisbursement.Report.AccountantCheckDisbursementReport();
report.SetDataSource(checkRegisterList);
report.SetParameterValue("Signatory1", SystemClass.GetSignatory(signatories.CityAccountant));
report.SetParameterValue("Signatory2", SystemClass.GetSignatory(signatories.AccountantRepresentative));
report.SetParameterValue("AdviceNo", account.AdviceNo.HasValue ? account.AdviceNo.ToString() : "");
report.SetParameterValue("employee", "Generated By: " + SystemClass.Employee(App.EmployeeID));
reportviewer.ViewerCore.ReportSource = report;
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
private void savebtn_Click(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
try
{
ImusCityHallEntities db = new ImusCityHallEntities();
CDSSignatory signatories = db.CDSSignatories.FirstOrDefault();
if (payeecb.SelectedValue == null && optionpayeecb.IsChecked == false)
{
MessageBox.Show("Please select payee from the dropdown list");
}
else if (optionpayeecb.IsChecked == true && String.IsNullOrEmpty(optionalpayee.Text))
{
MessageBox.Show("Please enter payee name");
}
else if (paymenttypecb.SelectedValue == null)
{
MessageBox.Show("Please select payment type");
}
else if (signatories == null)
{
Mouse.OverrideCursor = null;
MessageBox.Show("Please add report signatories");
}
else if (String.IsNullOrEmpty(vouchernotb.Text))
{
MessageBox.Show("Please enter voucher number");
}
else if (voucherList.Count() == 0)
{
MessageBox.Show("Please input at least one voucher item");
}
else
{
Disbursement disbursement = new Disbursement();
disbursement.PayeeID = optionpayeecb.IsChecked == true ? null : payeecb.SelectedValue == null ? (int?)null : (int)payeecb.SelectedValue;
disbursement.PayeeName = optionalpayee.Text.ToUpper();
disbursement.PayeeRepID = payeerepcb.SelectedValue == null ? (int?)null : (int)payeerepcb.SelectedValue;
disbursement.DepartmentID = departmentcb.SelectedValue == null ? null : (int?)departmentcb.SelectedValue;
disbursement.PaymentType = paymenttypecb.Text;
disbursement.VoucherNo = voucherprefixtb.Text + vouchernotb.Text;
disbursement.DateCreated = DateTime.Now;
disbursement.ProjectName = projectnametb.Text;
disbursement.Obligated = obligatedcb.IsChecked;
disbursement.DocCompleted = documentcb.IsChecked;
disbursement.CreatedBy = App.EmployeeID;
foreach (var voucherItem in voucherList)
{
var item = new DisbursementItem()
{
Explanation = voucherItem.Explanation,
Amount = Convert.ToDecimal(voucherItem.Amount)
};
disbursement.DisbursementItems.Add(item);
}
var x = db.Disbursements.Add(disbursement);
db.SaveChanges();
var audit = new AuditTrailModel
{
Activity = "Created disbursement document",
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
MessageBox.Show("Check Disbursement Created!");
Print(x.DisbursementID);
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
