private void ReloadData() { try { DataTable listMember = new InsureCompanyDAL().GetAll(); grdInsure.ItemsSource = listMember.DefaultView; DataCommon.Set("LIST_COMPANY", listMember); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void Button_Click(object sender, RoutedEventArgs e) { try { int index = grdInsure.SelectedIndex; string code = ((DataRowView)grdInsure.SelectedItem).Row.ItemArray[0].ToString(); InsureCompanyData item = new InsureCompanyDAL().GetItem(code); DataCommon.Set("COMPANY_EDIT", item); PopupCompanyInsure pop = new PopupCompanyInsure(); pop.ShowDialog(); ReloadData(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public PopupInsureCar() { try { InitializeComponent(); DataTable listCar = new CarDAL().GetComboBoxCarName(); cbbCarName.ItemsSource = listCar.DefaultView; DataTable listCompany = new InsureCompanyDAL().GetComboBoxCompanyName(); cbbCompany.ItemsSource = listCompany.DefaultView; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void btnStart_Click(object sender, RoutedEventArgs e) { try { //WaitProcess wp = new WaitProcess(); //wp.ShowDialog(); carDal = new CarDAL(); comDal = new InsureCompanyDAL(); insureDal = new InsureCarDAL(); List <InsureCarData> listItem = ReadExcel(txtPath.Text); DataCommon.Set("ListInsureCarData", listItem); ProcessDatabase(); btnClose.IsEnabled = true; btnSelect.IsEnabled = true; //wp.Close(); MessageBox.Show("นำเข้าข้อมูลเรียนร้อย"); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { if (txtCompantCode.Text == "") { MessageBox.Show("กรุณากรอก รหัสบริษัท"); return; } if (txtCompantFullName.Text == "") { MessageBox.Show("กรุณากรอก ชื่อเต็มบริษัท"); return; } if (MessageBox.Show("ยืนยันการบันทึกข้อมูล", "การบันทึกข้อมูล", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes) { bool complete = false; InsureCompanyDAL dal = new InsureCompanyDAL(); if (DataCommon.Exists("COMPANY_EDIT")) { item = (InsureCompanyData)DataCommon.Get("COMPANY_EDIT"); item.COMPANY_CODE = txtCompantCode.Text; item.COMPANY_FULLNAME = txtCompantFullName.Text; item.COMPANY_PATH_PIC = ""; item.COMPANY_REMARK = txtRemark.Text; item.COMPANY_SHORTNAME = ""; item.COMPANY_STATUS = cbbStatus.Text == "ใช้งาน" ? "A" : "I"; dal.Update(item); DataCommon.Remove("COMPANY_EDIT"); complete = true; } else { if (dal.GetItem(txtCompantCode.Text) == null) { item = new InsureCompanyData(); item.COMPANY_CODE = txtCompantCode.Text; item.COMPANY_FULLNAME = txtCompantFullName.Text; item.COMPANY_PATH_PIC = ""; item.COMPANY_REMARK = txtRemark.Text; item.COMPANY_SHORTNAME = ""; item.COMPANY_STATUS = cbbStatus.Text == "ใช้งาน" ? "A" : "I"; new InsureCompanyDAL().Insert(item); complete = true; } else { MessageBox.Show("รหัสบริษัทนี้ซ้ำในระบบ กรุณาเปลี่ยนรหัสบริษัท"); } } if (complete) { MessageBox.Show("บันทึกข้อมูลสำเร็จ"); this.Close(); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public PopupInsureCar(string mode) { try { InitializeComponent(); InsureCarData item = (InsureCarData)DataCommon.Get("INSURE_CAR_EDIT"); txtAssetTime.Text = item.ASSET_TIME.ToString(); txtCapitalInsure.Text = item.CAPITAL_INSURANCE.ToString(); txtCoveragePeople.Text = item.LIVE_COVERAGE_PEOPLE.ToString(); txtCoverageTime.Text = item.LIVE_COVERAGE_TIME.ToString(); txtDamageCar.Text = item.DAMAGE_TO_VEHICLE.ToString(); txtFirstDamage.Text = item.FIRST_DAMAGE_PRICE.ToString(); txtInsureDriver.Text = item.DRIVER_INSURANCE_AMT.ToString(); txtMEDICAL_FEE_AMT.Text = item.MEDICAL_FEE_AMT.ToString(); txtMEDICAL_FEE_PEOPLE.Text = item.MEDICAL_FEE_PEOPLE.ToString(); txtMissingCar.Text = item.MISSING_FIRE_CAR.ToString(); txtNetPrice.Text = item.NET_PRICE.ToString(); txtPackage.Text = item.PACKAGE_NAME; txtPERSONAL_ACCIDENT_AMT.Text = item.PERSONAL_ACCIDENT_AMT.ToString(); txtPERSONAL_ACCIDENT_PEOPLE.Text = item.PERSONAL_ACCIDENT_PEOPLE.ToString(); txtPriolity.Text = item.INSURE_PRIORITY.ToString(); txtRoundPrice.Text = item.PRICE_ROUND.ToString(); txtTotalPrice.Text = item.TOTAL_PRICE.ToString(); txtEff.Text = item.EFFECTIVE_DATE.ToShortDateString(); txtExp.Text = item.EXPIRE_DATE.ToShortDateString(); cbbCarYear.SelectedValue = item.CAR_YEAR.ToString(); DataTable listCar = new CarDAL().GetComboBoxCarName(); cbbCarName.ItemsSource = listCar.DefaultView; cbbCarName.Text = item.CAR_NAME.ToString(); DataTable listCarModel = new CarDAL().GetComboBoxCarModel(item.CAR_NAME); cbbCarModel.ItemsSource = listCarModel.DefaultView; cbbCarModel.Text = item.CAR_MODEL.ToString(); DataTable listCarEngine = new CarDAL().GetComboBoxCarEngine(item.CAR_NAME, item.CAR_MODEL); cbbCarEngine.ItemsSource = listCarEngine.DefaultView; cbbCarEngine.Text = item.CAR_ENGINE.ToString(); DataTable listCompany = new InsureCompanyDAL().GetComboBoxCompanyName(); cbbCompany.ItemsSource = listCompany.DefaultView; cbbCompany.Text = item.COMPANY_FULLNAME; cbbConfident.SelectedValue = item.CONFIDENTIAL_STATUS == "S" ? "Show" : "Hidden"; cbbInsureCat.SelectedValue = item.INSURE_CATEGORY.ToString(); cbbTypeRepair.SelectedValue = item.INSURE_TYPE_REPAIR.ToString(); if (mode == "VIEW") { txtAssetTime.IsEnabled = false; txtCapitalInsure.IsEnabled = false; txtCoveragePeople.IsEnabled = false; txtCoverageTime.IsEnabled = false; txtDamageCar.IsEnabled = false; txtFirstDamage.IsEnabled = false; txtInsureDriver.IsEnabled = false; txtMEDICAL_FEE_AMT.IsEnabled = false; txtMEDICAL_FEE_PEOPLE.IsEnabled = false; txtMissingCar.IsEnabled = false; txtNetPrice.IsEnabled = false; txtPackage.IsEnabled = false; txtPERSONAL_ACCIDENT_AMT.IsEnabled = false; txtPERSONAL_ACCIDENT_PEOPLE.IsEnabled = false; txtPriolity.IsEnabled = false; txtRoundPrice.IsEnabled = false; txtTotalPrice.IsEnabled = false; txtEff.IsEnabled = false; txtExp.IsEnabled = false; cbbCarYear.IsEnabled = false; cbbCarName.IsEnabled = false; cbbCarModel.IsEnabled = false; cbbCarEngine.IsEnabled = false; cbbCompany.IsEnabled = false; cbbConfident.IsEnabled = false; cbbInsureCat.IsEnabled = false; cbbTypeRepair.IsEnabled = false; cbbStatus.IsEnabled = false; btnSave.Visibility = System.Windows.Visibility.Hidden; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }