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