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());
}
}
