async void PrintPermit()
{
PermitModel permit = new PermitModel();
permit.Affidavit = AffidavitInfo;
permit.Contractor = ContractorInfo;
permit.Permit = PermitInfo;
permit.Applicant = ApplicantInfo;
permit.AffidavitCostDetails = AffidavitCostsDetails.ToList();
//MainWindow window = new MainWindow();
//ApprovedPermitReport rpt = new ApprovedPermitReport(permit.Permit.PermitID.ToString(), permit.Affidavit.aff_no.ToString());
//rpt.Show();
//DirectoryInfo dirInfo = new DirectoryInfo(@"\\pdotfile1\apps\SidewalkPosting\Documents\PDF\Test");
//DirectoryInfo dirInfo = new DirectoryInfo(@"\\pdotfile1\apps\SidewalkPosting\Documents\PDF");
//FileInfo[] pdfFiles = dirInfo.GetFiles(permit.Permit.PermitNo.ToString() + ".pdf");
//if (pdfFiles.Length == 1)
//{
// Process.Start(pdfFiles[0].FullName);
//}
//GeneratePDF(PermitInfo.PermitID.ToString(), PermitInfo.PermitNo);
//DirectoryInfo dirInfo = new DirectoryInfo(@"\\pdotfile1\apps\SidewalkPosting\Documents\PDF\Test");
//FileInfo[] pdfFiles = dirInfo.GetFiles(PermitInfo.Permit.PermitNo.ToString() + ".pdf");
var permitUpdateObj = await _dataService.GetPermitByAffidavit(PermitInfo.AffidavitID.Value);
if (!String.IsNullOrEmpty(ConfigurationManager.AppSettings["PDFPath"].ToString()))
{
string path = ConfigurationManager.AppSettings["PDFPath"].ToString() + permitUpdateObj.PermitNo + ".pdf";
Process.Start(path);
}
}
/// <summary>
/// this method will get list of permits by its status
/// </summary>
/// <param name="status"></param>
/// <returns></returns>
public List <PermitModel> GetPermitsByStatus(string status)
{
List <PermitModel> result = new List <PermitModel>();
try
{
if (!string.IsNullOrEmpty(status))
{
var permits = context.Permit.Include("PermitApplicant").Include("PermitStatus1").Where(x => x.PermitStatus1.PermitStatusValue.Equals(status)).ToList();
if (permits != null)
{
foreach (var item in permits)
{
string affidavitID = item.AffidavitID.ToString();
string contractorID = item.ContractorID.ToString();
var permit = new PermitModel();
item.PermitStatus1 = null;
item.PermitApplicant.Permit = null;
permit.Permit = item;
permit.Applicant = item.PermitApplicant;
// permit.Affidavit = affidavitLogic.GetAffidavitDetails(affidavitID);
// permit.Contractor = contractorLogic.SearchContractor(contractorID);
result.Add(permit);
}
}
}
}
//try
//{
// if (!string.IsNullOrEmpty(status))
// {
// //var permits = context.Permit.Include("PermitStatus1").Where(x => x.PermitStatus1.PermitStatusValue.Equals(status)).OrderByDescending(x => x.DateIssued).ToList();
// result = (from item in context.Permit.Include("PermitStatus1")
// join aff in context.sw_posting on item.AffidavitID equals aff.aff_no
// join app in context.PermitApplicant on item.ApplicantID equals app.ApplicantID
// where item.PermitStatus1.PermitStatusValue == status
// select new PermitModel()
// {
// Permit = item,
// Affidavit = aff,
// FullAddress = aff.st_no.Trim() + " " + aff.district.Trim() + " " + aff.st_name.Trim() + " " + aff.designator.Trim(),
// Applicant= app
// }).ToList<PermitModel>();
// Parallel.ForEach(result, item =>
// {
// item.Contractor = contractorLogic.SearchContractor(item.Permit.ContractorID);
// item.Permit.PermitApplicant = null;
// });
// }
//}
catch (Exception ex)
{
result = null;
}
return(result);
}
//public RelayCommand SelectCountriesCommand
//{
// get { return _selectCountriesCommand; }
//}
//public RelayCommand DeSelectCountriesCommand
//{
// get { return _deSelectCountriesCommand; }
//}
public ContractorPermitProcessViewModel(IDataService dataService, PermitModel permit, MdiContainer container)
{
_container = container;
_dataService = dataService;
AffidavitInfo = new sw_posting();
ContractorInfo = new CCBContractor();
GetAffidavitByNumber(permit.Permit.AffidavitID.ToString());
GetContractorByCCB(permit.Permit.BuilderBoardNo);
ApplicantInfo = permit.Applicant;
PermitHistoryInfo = new ApplicantPermitHistory();
GetPermitHistory(ApplicantInfo.Name);
TotalFee = "0.00";
Permits = new ObservableCollection <ContractorPermit>();
PermitPaymentInfo = new PermitPayment();
NewExpireDate = DateTime.Now;
//GetPermitByContractor(permit.Permit.ContractorID);
GetPermitByContractor(permit.Permit.PermitApplicant.Name);
PermitInfo = permit;
//PermitNumber = permit.Permit.PermitNo.ToString();
if (permit.Applicant.ApplicantType == "Contractor")
{
ContractorRadio = true;
}
if (permit.Applicant.ApplicantType == "Owner")
{
OwnerRadio = true;
}
if (permit.Applicant.ApplicantType == "Other")
{
OtherRadio = true;
}
//GetAffidavitCostsDetails();
AcceptButtonModel = true;
PermitPaymentInfo.IssueDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
PermitPaymentInfo.IssuedBy = new string(Environment.UserName.ToUpper().Take(3).ToArray());
this.CalculateAmountCommand = new RelayCommand(AcceptPermit);
AcceptPermitFeeCommand = new RelayCommand(AcceptPermitFee);
RejectAllPermitsCommand = new RelayCommand(RejectAllPermits);
HoldPermitCommand = new RelayCommand(HoldPermit);
string env = ConfigurationManager.AppSettings["AppEnvironment"];
PermitReportFactory.AppEnvironment = env;
showPermitDetailsCommand = new RelayCommand <long>((s) => ShowPermitDetails(s));
//Full Set=2 Copies +Instructions, CustomerSet = 1 Copy +Instructions, FileCopy = Our Copy, Instructions =Instructions only, Permit = 1 Copy, None = No print
PrintOptionData.Add("None");
//PrintOptionData.Add("Permit");
//PrintOptionData.Add("Instructions");
PrintOptionData.Add("File Copy");
PrintOptionData.Add("Customer Copy");
PrintOptionData.Add("Customer and File Copy");
SelectedPrintOption = "Customer and File Copy";
}
internal void processStaffPermits(PermitModel permitModel, MdiContainer container)
{
StaffPermitProcess permitProcessView = new StaffPermitProcess();
permitProcessView.DataContext = new StaffPermitProcessViewModel(_dataService, permitModel, container);
container.Children.Clear();
container.Children.Add(new MdiChild()
{
Title = "Process Permits",
Height = (System.Windows.SystemParameters.PrimaryScreenHeight - 15),
Width = (System.Windows.SystemParameters.PrimaryScreenWidth - 15),
Style = null,
//Here UserRegistration is the class that you have created for mainWindow.xaml user control.
Content = permitProcessView
});
}
internal void editSubmittedPermits(PermitModel permitModel, MdiContainer container)
{
ReviewModifyTransferPermit reviewPermitView = new ReviewModifyTransferPermit();
reviewPermitView.DataContext = new ReviewModifyTransferPermitViewModel(_dataService, permitModel, container);
container.Children.Clear();
container.Children.Add(new MdiChild()
{
Title = "Update Permits",
Height = (System.Windows.SystemParameters.PrimaryScreenHeight - 15),
Width = (System.Windows.SystemParameters.PrimaryScreenWidth - 15),
Style = null,
//Here UserRegistration is the class that you have created for mainWindow.xaml user control.
Content = reviewPermitView
});
}
/// <summary>
/// this method will get list of permits by its status
/// </summary>
/// <param name="applicantName"></param>
/// <returns></returns>
public List <PermitModel> GetPermitsByApplicant(string applicantName)
{
List <PermitModel> result = new List <PermitModel>();
try
{
if (!string.IsNullOrEmpty(applicantName))
{
var permits = context.Permit.Include("PermitStatus1").Include("PermitApplicant").Where(x => x.PermitApplicant.Name == applicantName && x.PermitStatus1.PermitStatusValue.Equals("Submitted")).OrderByDescending(x => x.DateIssued).ToList();
if (permits != null)
{
foreach (var item in permits)
{
string affidavitID = item.AffidavitID.ToString();
string contractorID = item.ContractorID.ToString();
var permit = new PermitModel();
item.PermitStatus1 = null;
permit.Permit = item;
permit.Affidavit = affidavitLogic.GetAffidavitDetails(affidavitID);
if (item.ApplicantType == "Contractor")
{
permit.Contractor = contractorLogic.SearchContractor(item.PermitApplicant.Name);
}
else
{
permit.Contractor = new CCBContractor();
}
permit.AffidavitCostDetails = affidavitCostLogic.GetAffidavitCostDetails(affidavitID, "E");
// permit.Applicant = GetPermitApplicant(item.ApplicantID.Value);
item.PermitApplicant.Permit = null;
result.Add(permit);
}
}
}
}
catch (Exception ex)
{
result = null;
}
return(result);
}
public void Update(PermitModel permitModel)
{
try
{
using (MySqlConnection con = new MySqlConnection(_connectionString))
{
string sql = "UPDATE permits SET permitName=@permitName WHERE permitId=@permitId;";
using (MySqlCommand cmd = new MySqlCommand(sql, con))
{
cmd.Parameters.AddWithValue("@permitName", permitModel.PermitName);
cmd.Parameters.AddWithValue("@permitId", permitModel.PermitId);
con.Open();
cmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public void Add(PermitModel permitModel)
{
try
{
using (MySqlConnection con = new MySqlConnection(_connectionString))
{
string sql = "INSERT INTO permits (permitName) VALUES(@permitName);";
using (MySqlCommand cmd = new MySqlCommand(sql, con))
{
cmd.Parameters.AddWithValue("@permitName", permitModel.PermitName);
con.Open();
cmd.ExecuteNonQuery();
permitModel.PermitId = Convert.ToInt32(cmd.LastInsertedId);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public StaffPermitProcessViewModel(IDataService dataService, PermitModel permit, MdiContainer container)
{
_container = container;
_dataService = dataService;
AffidavitInfo = new sw_posting();
ContractorInfo = new CCBContractor();
GetAffidavitByNumber(permit.Permit.AffidavitID.ToString());
GetContractorByCCB(permit.Permit.BuilderBoardNo);
ApplicantInfo = permit.Applicant;
PermitPaymentInfo = new PermitPayment();
PermitInfo = permit;
AcceptButtonModel = true;
//PermitNumber = permit.Permit.PermitNo.ToString();
if (permit.Applicant.ApplicantType == "Contractor")
{
ContractorRadio = true;
}
if (permit.Applicant.ApplicantType == "Owner")
{
OwnerRadio = true;
}
if (permit.Applicant.ApplicantType == "Other")
{
OtherRadio = true;
}
AffidavitCostsDetails = new ObservableCollection <sw_action_detail>();
GetAffidavitCostsDetails(permit.Permit.AffidavitID.ToString());
PermitPaymentInfo.IssueDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
PermitPaymentInfo.IssuedBy = new string(Environment.UserName.ToUpper().Take(3).ToArray());
AcceptPermitCommand = new RelayCommand(AcceptPermit);
RejectPermitCommand = new RelayCommand(RejectPermit);
HoldPermitCommand = new RelayCommand(HoldPermit);
//Configuration config = ConfigurationManager.OpenExeConfiguration(Application.ExecutablePath);
string env = ConfigurationManager.AppSettings["AppEnvironment"];
PermitReportFactory.AppEnvironment = env;
}
public PermitModel Get(int quizId)
{
PermitModel item;
try
{
using (MySqlConnection con = new MySqlConnection(_connectionString))
{
string sql = "SELECT permitId, permitName FROM permits WHERE permitId = @permitId;";
using (MySqlCommand cmd = new MySqlCommand(sql, con))
{
cmd.Parameters.AddWithValue("@permitId", quizId);
con.Open();
using (MySqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
item = new PermitModel();
item.PermitId = Convert.ToInt32(dr["permitId"]);
item.PermitName = dr["permitName"].ToString();
return(item);
}
}
}
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
return(null);
}
public ReviewModifyTransferPermitViewModel(IDataService dataService, PermitModel permit, MdiContainer container)
{
_container = container;
_dataService = dataService;
//AffidavitInfo = new sw_posting();
ContractorInfo = new CCBContractor();
GetAffidavitByNumber(permit.Permit.AffidavitID.ToString());
GetContractorByCCB(permit.Permit.BuilderBoardNo);
IsDatePickerEnabled = true;
ApplicantInfo = permit.Applicant;
PreviousApplicantID = permit.Applicant.ApplicantID;
CCBNumber = permit.Permit.BuilderBoardNo;
CCBNumberOld = permit.Permit.BuilderBoardNo;
PermitInfo = permit.Permit;
ApplicantName = permit.Applicant.Name;
Contact = permit.Applicant.Contact;
Address = permit.Applicant.Address;
City = permit.Applicant.City;
ST = permit.Applicant.State;
Zip = permit.Applicant.Zip;
PhoneNumber = permit.Applicant.PhoneNumber;
GetPermitPayment(permit.Permit.PermitID);
ContractorList = new ObservableCollection <string>();
PermitNumber = permit.Permit.PermitID.ToString();
if (permit.Applicant.ApplicantType == "Contractor")
{
ContractorRadio = true;
}
if (permit.Applicant.ApplicantType == "Owner")
{
OwnerRadio = true;
}
if (permit.Applicant.ApplicantType == "Other")
{
OtherRadio = true;
}
AffidavitCostsDetails = new ObservableCollection <sw_action_detail>();
//GetAffidavitCostsDetails(permit.Permit.AffidavitID.ToString());
PermitCostsDetails = new ObservableCollection <PermitCostsDetail>();
GetPermitCostsDetails(permit.Permit.AffidavitID.ToString());
IssuedBy = "NA";
IssuedDate = DateTime.MaxValue;
IsPermitExtended = (PermitInfo.PermitExtended.Equals("Yes")) ? true : false;
UpdateCommand = new RelayCommand(UpdatePermit);
ContractorChecked = new RelayCommand(UpdateContractor);
CancelCommand = new RelayCommand(Cancel);
SearchContractorCommand = new RelayCommand(ContractorSearch);
ContractorSelectCommand = new RelayCommand(ContractorSelect);
PrintCommand = new RelayCommand(PrintPermit);
OwnerChecked = new RelayCommand(OwnerRadioChanged);
OtherChecked = new RelayCommand(OtherRadioChanged);
ShowPermitHistoryCommand = new RelayCommand(ShowPermitHistory);
//PermitInfo.DateExpiredNew = PermitInfo.DateExpired;
PermitReportFactory.AppEnvironment = ConfigurationManager.AppSettings["AppEnvironment"];
SaveButtonModel = true;
//Full Set=2 Copies +Instructions, CustomerSet = 1 Copy +Instructions, FileCopy = Our Copy, Instructions =Instructions only, Permit = 1 Copy, None = No print
PrintOptionData.Add("None");
//PrintOptionData.Add("Permit");
//PrintOptionData.Add("Instructions");
PrintOptionData.Add("File Copy");
PrintOptionData.Add("Customer Copy");
PrintOptionData.Add("Customer and File Copy");
SelectedPrintOption = "None";
}
