public void UpdateOnExcel(InsureCarData newItem) { try { MemberData member = (MemberData)DataCommon.Get("DATA.MEMBER"); DBbase.Connect(); StringBuilder sql = new StringBuilder(); sql.Append("UPDATE MA_INSURE_CAR SET "); sql.Append(" COMPANY_CODE = N'" + newItem.COMPANY_CODE + "',"); sql.Append(" PACKAGE_NAME = N'" + newItem.PACKAGE_NAME + "',"); sql.Append(" CAR_ID = '" + newItem.CAR_ID + "',"); sql.Append(" INSURE_CATEGORY = N'" + newItem.INSURE_CATEGORY + "',"); //sql.Append(" INSURE_TYPE_REPAIR = '" + newItem.INSURE_TYPE_REPAIR + "',"); sql.Append(" CAR_YEAR = N'" + newItem.CAR_YEAR + "',"); sql.Append(" LIVE_COVERAGE_PEOPLE = '" + newItem.LIVE_COVERAGE_PEOPLE + "',"); sql.Append(" LIVE_COVERAGE_TIME = '" + newItem.LIVE_COVERAGE_TIME + "',"); sql.Append(" ASSET_TIME = '" + newItem.ASSET_TIME + "',"); sql.Append(" INSURE_TYPE_REPAIR = '" + newItem.INSURE_TYPE_REPAIR + "',"); sql.Append(" DAMAGE_TO_VEHICLE = '" + newItem.DAMAGE_TO_VEHICLE + "',"); sql.Append(" MISSING_FIRE_CAR = '" + newItem.MISSING_FIRE_CAR + "',"); sql.Append(" FIRST_DAMAGE_PRICE = '" + newItem.FIRST_DAMAGE_PRICE + "',"); sql.Append(" PERSONAL_ACCIDENT_AMT = '" + newItem.PERSONAL_ACCIDENT_AMT + "',"); sql.Append(" PERSONAL_ACCIDENT_PEOPLE = '" + newItem.PERSONAL_ACCIDENT_PEOPLE + "',"); sql.Append(" MEDICAL_FEE_AMT = '" + newItem.MEDICAL_FEE_AMT + "',"); sql.Append(" MEDICAL_FEE_PEOPLE = '" + newItem.MEDICAL_FEE_PEOPLE + "',"); sql.Append(" DRIVER_INSURANCE_AMT = '" + newItem.DRIVER_INSURANCE_AMT + "',"); sql.Append(" NET_PRICE = '" + newItem.NET_PRICE + "',"); sql.Append(" TOTAL_PRICE = '" + newItem.TOTAL_PRICE + "',"); sql.Append(" PRICE_ROUND = '" + newItem.PRICE_ROUND + "',"); sql.Append(" CAPITAL_INSURANCE = '" + newItem.CAPITAL_INSURANCE + "',"); sql.Append(" INSURE_PRIORITY = '" + newItem.INSURE_PRIORITY + "',"); sql.Append(" EFFECTIVE_DATE = '" + ConvertCommon.ConvertDateTime(newItem.EFFECTIVE_DATE) + "',"); sql.Append(" EXPIRE_DATE = '" + ConvertCommon.ConvertDateTime(newItem.EXPIRE_DATE) + "',"); sql.Append(" CONFIDENTIAL_STATUS = '" + newItem.CONFIDENTIAL_STATUS + "',"); sql.Append(" UPDATE_DATE = '" + ConvertCommon.ConvertDateTime(DateTime.Now) + "',"); sql.Append(" UPDATE_USER = '******'"); sql.Append(" WHERE COMPANY_CODE = '" + newItem.COMPANY_CODE + "'"); sql.Append(" AND PACKAGE_NAME = '"+ newItem.PACKAGE_NAME + "'"); sql.Append(" AND CAR_ID = '"+ newItem.CAR_ID + "'"); sql.Append(" AND INSURE_CATEGORY = '"+ newItem.INSURE_CATEGORY + "'"); sql.Append(" AND INSURE_TYPE_REPAIR = '"+ newItem.INSURE_TYPE_REPAIR + "'"); sql.Append(" AND CAR_YEAR = '"+ newItem.CAR_YEAR + "'"); sql.Append(" AND DAMAGE_TO_VEHICLE = '" + newItem.DAMAGE_TO_VEHICLE + "'"); SqlCommand cmd = new SqlCommand(sql.ToString(), DBbase.con); cmd.ExecuteNonQuery(); DBbase.DisConnect(); } catch (Exception ex) { throw ex; } }
public bool CheckItem(InsureCarData item) { try { DBbase.Connect(); string sql = @"SELECT A.INSURE_CAR_CODE, A.COMPANY_CODE, A.PACKAGE_NAME, A.CAR_ID, A.INSURE_CATEGORY, A.INSURE_TYPE_REPAIR, A.CAR_YEAR, A.LIVE_COVERAGE_PEOPLE, A.LIVE_COVERAGE_TIME, A.ASSET_TIME, A.DAMAGE_TO_VEHICLE, A.MISSING_FIRE_CAR, A.FIRST_DAMAGE_PRICE, A.PERSONAL_ACCIDENT_AMT, A.PERSONAL_ACCIDENT_PEOPLE, A.MEDICAL_FEE_AMT, A.MEDICAL_FEE_PEOPLE, A.DRIVER_INSURANCE_AMT, A.NET_PRICE, A.TOTAL_PRICE, A.PRICE_ROUND, A.CAPITAL_INSURANCE, A.INSURE_PRIORITY, A.EFFECTIVE_DATE, A.EXPIRE_DATE, A.CONFIDENTIAL_STATUS, A.CREATE_DATE, A.CREATE_USER, A.UPDATE_DATE, A.UPDATE_USER, A.INSURE_CAR_STATUS, C.CAR_CODE,C.CAR_NAME,C.CAR_MODEL,C.CAR_ENGINE ,I.COMPANY_FULLNAME FROM MA_INSURE_CAR A INNER JOIN MA_CAR C ON A.CAR_ID = C.CAR_ID INNER JOIN MA_INSURE_COMPANY I ON A.COMPANY_CODE = I.COMPANY_CODE WHERE I.COMPANY_CODE = '" + item.COMPANY_CODE + "' AND A.PACKAGE_NAME = '" + item.PACKAGE_NAME + "' AND A.CAR_ID = '" + item.CAR_ID + "' AND A.INSURE_CATEGORY = '" + item.INSURE_CATEGORY + "' AND A.INSURE_TYPE_REPAIR = '" + item.INSURE_TYPE_REPAIR + "' AND A.CAR_YEAR = '" + item.CAR_YEAR + "'" + "AND A.CAPITAL_INSURANCE = '" + item.CAPITAL_INSURANCE + "'"; SqlCommand cmd = new SqlCommand(sql, DBbase.con); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { DBbase.DisConnect(); return(true); } else { DBbase.DisConnect(); return(false); } } catch (Exception ex) { throw ex; } }
public void Insert(InsureCarData item) { try { MemberData member = (MemberData)DataCommon.Get("DATA.MEMBER"); DBbase.Connect(); StringBuilder sql = new StringBuilder(); sql.Append(@"INSERT INTO MA_INSURE_CAR (INSURE_CAR_CODE, COMPANY_CODE, PACKAGE_NAME, CAR_ID, INSURE_CATEGORY,INSURE_TYPE_REPAIR,CAR_YEAR,LIVE_COVERAGE_PEOPLE, LIVE_COVERAGE_TIME,ASSET_TIME,DAMAGE_TO_VEHICLE,MISSING_FIRE_CAR,FIRST_DAMAGE_PRICE,PERSONAL_ACCIDENT_AMT,PERSONAL_ACCIDENT_PEOPLE,MEDICAL_FEE_AMT, MEDICAL_FEE_PEOPLE,DRIVER_INSURANCE_AMT,NET_PRICE,TOTAL_PRICE,PRICE_ROUND,CAPITAL_INSURANCE,INSURE_PRIORITY,EFFECTIVE_DATE,EXPIRE_DATE,CONFIDENTIAL_STATUS, INSURE_CAR_STATUS,CREATE_DATE,CREATE_USER,UPDATE_DATE,UPDATE_USER) VALUES ("); string INSURE_CAR_CODE = DateTime.Now.ToString("yyyyMMdd") + "-" + item.COMPANY_CODE.ToUpper() + "-" + item.PACKAGE_NAME; INSURE_CAR_CODE += "-" + item.CAR_ID + "-" + item.INSURE_CATEGORY; INSURE_CAR_CODE += item.INSURE_TYPE_REPAIR == "ศูนย์" ? "C" : "G"; sql.Append(" N'" + INSURE_CAR_CODE + "',"); sql.Append(" N'" + item.COMPANY_CODE.ToUpper() + "',"); sql.Append(" N'" + item.PACKAGE_NAME + "',"); sql.Append(" '" + item.CAR_ID + "',"); sql.Append(" N'" + item.INSURE_CATEGORY + "',"); sql.Append(" N'" + item.INSURE_TYPE_REPAIR + "',"); sql.Append(" N'" + item.CAR_YEAR + "',"); sql.Append(" '" + item.LIVE_COVERAGE_PEOPLE + "',"); sql.Append(" '" + item.LIVE_COVERAGE_TIME + "',"); sql.Append(" '" + item.ASSET_TIME + "',"); sql.Append(" '" + item.DAMAGE_TO_VEHICLE + "',"); sql.Append(" '" + item.MISSING_FIRE_CAR + "',"); sql.Append(" '" + item.FIRST_DAMAGE_PRICE + "',"); sql.Append(" '" + item.PERSONAL_ACCIDENT_AMT + "',"); sql.Append(" '" + item.PERSONAL_ACCIDENT_PEOPLE + "',"); sql.Append(" '" + item.MEDICAL_FEE_AMT + "',"); sql.Append(" '" + item.MEDICAL_FEE_PEOPLE + "',"); sql.Append(" '" + item.DRIVER_INSURANCE_AMT + "',"); sql.Append(" '" + item.NET_PRICE + "',"); sql.Append(" '" + item.TOTAL_PRICE + "',"); sql.Append(" '" + item.PRICE_ROUND + "',"); sql.Append(" '" + item.CAPITAL_INSURANCE + "',"); sql.Append(" '" + item.INSURE_PRIORITY + "',"); sql.Append(" '" + ConvertCommon.ConvertDateTime(item.EFFECTIVE_DATE) + "',"); sql.Append(" '" + ConvertCommon.ConvertDateTime(item.EXPIRE_DATE) + "',"); sql.Append(" '" + item.CONFIDENTIAL_STATUS + "',"); sql.Append(" '" + item.INSURE_CAR_STATUS + "',"); sql.Append(" '" + ConvertCommon.ConvertDateTime(DateTime.Now) + "',"); sql.Append(" '" + member.MEMBER_USER + "',"); sql.Append(" '" + ConvertCommon.ConvertDateTime(DateTime.Now) + "',"); sql.Append(" '" + member.MEMBER_USER + "')"); SqlCommand cmd = new SqlCommand(sql.ToString(), DBbase.con); cmd.ExecuteNonQuery(); DBbase.DisConnect(); } catch (SqlException exception) { if (exception.Number == 1062) // Cannot insert duplicate key row in object error { } else { throw exception; // throw exception if this exception is unexpected } } catch (Exception ex) { throw ex; } }
public InsureCarData GetItem(string code) { try { DBbase.Connect(); string sql = @"SELECT A.INSURE_CAR_CODE, A.COMPANY_CODE, A.PACKAGE_NAME, A.CAR_ID, A.INSURE_CATEGORY, A.INSURE_TYPE_REPAIR, A.CAR_YEAR, A.LIVE_COVERAGE_PEOPLE, A.LIVE_COVERAGE_TIME, A.ASSET_TIME, A.DAMAGE_TO_VEHICLE, A.MISSING_FIRE_CAR, A.FIRST_DAMAGE_PRICE, A.PERSONAL_ACCIDENT_AMT, A.PERSONAL_ACCIDENT_PEOPLE, A.MEDICAL_FEE_AMT, A.MEDICAL_FEE_PEOPLE, A.DRIVER_INSURANCE_AMT, A.NET_PRICE, A.TOTAL_PRICE, A.PRICE_ROUND, A.CAPITAL_INSURANCE, A.INSURE_PRIORITY, A.EFFECTIVE_DATE, A.EXPIRE_DATE, A.CONFIDENTIAL_STATUS, A.CREATE_DATE, A.CREATE_USER, A.UPDATE_DATE, A.UPDATE_USER, A.INSURE_CAR_STATUS, C.CAR_CODE,C.CAR_NAME,C.CAR_MODEL,C.CAR_ENGINE ,I.COMPANY_FULLNAME FROM MA_INSURE_CAR A INNER JOIN MA_CAR C ON A.CAR_ID = C.CAR_ID INNER JOIN MA_INSURE_COMPANY I ON A.COMPANY_CODE = I.COMPANY_CODE WHERE INSURE_CAR_CODE = '" + code + "'"; SqlCommand cmd = new SqlCommand(sql, DBbase.con); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { InsureCarData item = new InsureCarData(); item.ASSET_TIME = Convert.ToDecimal(reader["ASSET_TIME"].ToString()); item.CAPITAL_INSURANCE = Convert.ToDecimal(reader["CAPITAL_INSURANCE"].ToString()); item.CAR_ID = Convert.ToInt32(reader["CAR_ID"].ToString()); item.CAR_CODE = reader["CAR_CODE"].ToString(); item.CAR_MODEL = reader["CAR_MODEL"].ToString(); item.CAR_NAME = reader["CAR_NAME"].ToString(); item.CAR_ENGINE = reader["CAR_ENGINE"].ToString(); item.CAR_YEAR = reader["CAR_YEAR"].ToString(); item.COMPANY_CODE = reader["COMPANY_CODE"].ToString(); item.COMPANY_FULLNAME = reader["COMPANY_FULLNAME"].ToString(); item.CONFIDENTIAL_STATUS = reader["CONFIDENTIAL_STATUS"].ToString(); item.DAMAGE_TO_VEHICLE = Convert.ToDecimal(reader["DAMAGE_TO_VEHICLE"].ToString()); item.DRIVER_INSURANCE_AMT = Convert.ToDecimal(reader["DRIVER_INSURANCE_AMT"].ToString()); item.EFFECTIVE_DATE = Convert.ToDateTime(reader["EFFECTIVE_DATE"].ToString()); item.EXPIRE_DATE = Convert.ToDateTime(reader["EXPIRE_DATE"].ToString()); item.FIRST_DAMAGE_PRICE = Convert.ToDecimal(reader["FIRST_DAMAGE_PRICE"].ToString()); item.INSURE_CAR_CODE = reader["INSURE_CAR_CODE"].ToString(); item.INSURE_CAR_STATUS = reader["INSURE_CAR_STATUS"].ToString(); item.INSURE_CATEGORY = reader["INSURE_CATEGORY"].ToString(); item.INSURE_TYPE_REPAIR = reader["INSURE_TYPE_REPAIR"].ToString(); item.LIVE_COVERAGE_PEOPLE = Convert.ToDecimal(reader["LIVE_COVERAGE_PEOPLE"].ToString()); item.LIVE_COVERAGE_TIME = Convert.ToDecimal(reader["LIVE_COVERAGE_TIME"].ToString()); item.MEDICAL_FEE_AMT = Convert.ToDecimal(reader["MEDICAL_FEE_AMT"].ToString()); item.MEDICAL_FEE_PEOPLE = Convert.ToInt32(reader["MEDICAL_FEE_PEOPLE"].ToString()); item.MISSING_FIRE_CAR = Convert.ToDecimal(reader["MISSING_FIRE_CAR"].ToString()); item.NET_PRICE = Convert.ToDecimal(reader["NET_PRICE"].ToString()); item.PACKAGE_NAME = reader["PACKAGE_NAME"].ToString(); item.PERSONAL_ACCIDENT_AMT = Convert.ToDecimal(reader["PERSONAL_ACCIDENT_AMT"].ToString()); item.PERSONAL_ACCIDENT_PEOPLE = Convert.ToInt32(reader["PERSONAL_ACCIDENT_PEOPLE"].ToString()); item.PRICE_ROUND = Convert.ToDecimal(reader["PRICE_ROUND"].ToString()); item.TOTAL_PRICE = Convert.ToDecimal(reader["TOTAL_PRICE"].ToString()); item.COMPANY_CODE = reader["COMPANY_CODE"].ToString(); item.INSURE_PRIORITY = Convert.ToInt32(reader["INSURE_PRIORITY"].ToString()); reader.Close(); DBbase.DisConnect(); return(item); } else { DBbase.DisConnect(); return(null); } } catch (Exception ex) { throw ex; } }
private void ProcessDatabase() { try { List <InsureCarData> listItem = (List <InsureCarData>)DataCommon.Get("ListInsureCarData"); MemberData member = (MemberData)DataCommon.Get("DATA.MEMBER"); List <InsureCarData> listInsert = new List <InsureCarData>(); foreach (InsureCarData item in listItem) { InsureCarData tmp = new InsureCarData(); tmp.ASSET_TIME = item.ASSET_TIME; tmp.CAPITAL_INSURANCE = item.CAPITAL_INSURANCE; if (comDal.CheckItem(item.COMPANY_CODE)) { tmp.COMPANY_CODE = item.COMPANY_CODE; } else { tmp.EXCEPTION = "รหัสบริษัทไม่มีในระบบ" + "ในบรรทัดที่ :" + item.INDEX_EXCEL; } tmp.CAR_CODE = item.CAR_CODE; //tmp.CAR_ENGINE = item.CAR_ENGINE; tmp.CAR_MODEL = item.CAR_MODEL; tmp.CAR_NAME = item.CAR_NAME; tmp.CAR_YEAR = item.CAR_YEAR; CarData tmpCar = carDal.GetItemForExcel(tmp.CAR_CODE, tmp.CAR_NAME, tmp.CAR_MODEL); if (tmpCar != null) { tmp.CAR_ID = tmpCar.CAR_ID; } else { tmp.EXCEPTION = "ไม่มีข้อมูลรหัสรถยนต์ : " + tmp.CAR_CODE + ", รถยนต์ยี่ห้อ : " + tmp.CAR_NAME + ", รุ่นรถยนต์ : " + tmp.CAR_MODEL + " ในบรรทัดที่ :" + item.INDEX_EXCEL; } tmp.COMPANY_FULLNAME = item.COMPANY_FULLNAME; tmp.CONFIDENTIAL_STATUS = item.CONFIDENTIAL_STATUS; tmp.CREATE_DATE = item.CREATE_DATE; tmp.CREATE_USER = item.CREATE_USER; tmp.DAMAGE_TO_VEHICLE = item.DAMAGE_TO_VEHICLE; tmp.DRIVER_INSURANCE_AMT = item.DRIVER_INSURANCE_AMT; tmp.EFFECTIVE_DATE = item.EFFECTIVE_DATE; tmp.EXPIRE_DATE = item.EXPIRE_DATE; tmp.FIRST_DAMAGE_PRICE = item.FIRST_DAMAGE_PRICE; tmp.INSURE_CAR_CODE = item.INSURE_CAR_CODE; tmp.INSURE_CAR_STATUS = item.INSURE_CAR_STATUS; tmp.INSURE_CATEGORY = item.INSURE_CATEGORY; tmp.INSURE_PRIORITY = item.INSURE_PRIORITY; tmp.INSURE_TYPE_REPAIR = item.INSURE_TYPE_REPAIR; tmp.LIVE_COVERAGE_PEOPLE = item.LIVE_COVERAGE_PEOPLE; tmp.LIVE_COVERAGE_TIME = item.LIVE_COVERAGE_TIME; tmp.MEDICAL_FEE_AMT = item.MEDICAL_FEE_AMT; tmp.MEDICAL_FEE_PEOPLE = item.MEDICAL_FEE_PEOPLE; tmp.MISSING_FIRE_CAR = item.MISSING_FIRE_CAR; tmp.NET_PRICE = item.NET_PRICE; tmp.PACKAGE_NAME = item.PACKAGE_NAME; tmp.PERSONAL_ACCIDENT_AMT = item.PERSONAL_ACCIDENT_AMT; tmp.PERSONAL_ACCIDENT_PEOPLE = item.PERSONAL_ACCIDENT_PEOPLE; tmp.PRICE_ROUND = item.PRICE_ROUND; tmp.TOTAL_PRICE = item.TOTAL_PRICE; tmp.UPDATE_DATE = item.UPDATE_DATE; tmp.UPDATE_USER = item.UPDATE_USER; tmp.INSURE_CAR_STATUS = "A"; if (tmp.EXCEPTION != "") { items.Add(new TextError() { Error = tmp.EXCEPTION, Index = item.INDEX_EXCEL.ToString() }); } else { if (insureDal.CheckItem(tmp)) { insureDal.UpdateOnExcel(tmp); } else { listInsert.Add(tmp); } } } if (listInsert.Count > 0) { insureDal.InsertList(listInsert); } ReloadDataForReFresh(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
/// <summary> /// Create List Object On Excel /// </summary> /// <param name="pathExcel"></param> /// <returns></returns> public List <InsureCarData> ReadExcel(string pathExcel) { try { List <InsureCarData> listInsureCarData = new List <InsureCarData>(); bool start = false; int index = 3; Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Range range; xlApp = new Excel.Application(); xlWorkBook = xlApp.Workbooks.Open(pathExcel, 0, true, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); foreach (Excel.Worksheet xlWorkSheet in xlWorkBook.Worksheets) { range = xlWorkSheet.UsedRange; DateTime dateValue; for (int row = 1; row <= range.Rows.Count; row++) { if (Convert.ToString((range.Cells[row, EXCEL_DATA.COMPANY_CODE] as Excel.Range).Text) == "#S") { start = true; continue; } else if (Convert.ToString((range.Cells[row, EXCEL_DATA.COMPANY_CODE] as Excel.Range).Text) == "#E") { start = false; break; } if (start) { InsureCarData item = new InsureCarData(); item.INDEX_EXCEL = index; //COMPANY_CODE if (Convert.ToString((range.Cells[row, EXCEL_DATA.COMPANY_CODE] as Excel.Range).Text) == "") { item.EXCEPTION = "ไม่มีข้อมูลรหัสบริษัทในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } else { item.COMPANY_CODE = Convert.ToString((range.Cells[row, EXCEL_DATA.COMPANY_CODE] as Excel.Range).Text); } //EFFECTIVE_DATE if (Convert.ToString((range.Cells[row, EXCEL_DATA.EFFECTIVE_DATE] as Excel.Range).Text) == "") { item.EXCEPTION = "ไม่มีข้อมูลวันที่มีผลในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } else { if (DateTime.TryParse(Convert.ToString((range.Cells[row, EXCEL_DATA.EFFECTIVE_DATE] as Excel.Range).Text), out dateValue)) { item.EFFECTIVE_DATE = dateValue; } else { item.EXCEPTION = "ไม่มีข้อมูลวันที่มีผลผิดในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } } //EXPIRE_DATE if (Convert.ToString((range.Cells[row, EXCEL_DATA.EXPIRE_DATE] as Excel.Range).Text) == "") { item.EXCEPTION = "ไม่มีข้อมูลวันที่สิ้นสุดในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } else { if (DateTime.TryParse(Convert.ToString((range.Cells[row, EXCEL_DATA.EXPIRE_DATE] as Excel.Range).Text), out dateValue)) { item.EXPIRE_DATE = dateValue; } else { item.EXCEPTION = "ไม่มีข้อมูลวันที่มีผลผิดในบรรทัดที่ " + row + "ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } } //INSURE_PRIORITY int INSURE_PRIORITY = 0; bool result = Int32.TryParse((range.Cells[row, EXCEL_DATA.INSURE_PRIORITY] as Excel.Range).Text, out INSURE_PRIORITY); if (result) { item.INSURE_PRIORITY = INSURE_PRIORITY; } else { item.INSURE_PRIORITY = 999; } //PACKAGE_NAME if (Convert.ToString((range.Cells[row, EXCEL_DATA.PACKAGE_NAME] as Excel.Range).Text) == "") { item.EXCEPTION = "ไม่มีข้อมูลชื่อ Package ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } else { item.PACKAGE_NAME = Convert.ToString((range.Cells[row, EXCEL_DATA.PACKAGE_NAME] as Excel.Range).Text); } //CAR_CODE if (Convert.ToString((range.Cells[row, EXCEL_DATA.CAR_CODE] as Excel.Range).Text) == "") { item.EXCEPTION = "ไม่มีข้อมูลรหัสรถยนต์ ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } else { item.CAR_CODE = Convert.ToString((range.Cells[row, EXCEL_DATA.CAR_CODE] as Excel.Range).Text).ToUpper(); } //CAR_NAME if (Convert.ToString((range.Cells[row, EXCEL_DATA.CAR_NAME] as Excel.Range).Text) == "") { item.EXCEPTION = "ไม่มีข้อมูลยี่ห้อรถยนต์ ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } else { item.CAR_NAME = Convert.ToString((range.Cells[row, EXCEL_DATA.CAR_NAME] as Excel.Range).Text).ToUpper(); } //CAR_MODEL if (Convert.ToString((range.Cells[row, EXCEL_DATA.CAR_MODEL] as Excel.Range).Text) == "") { item.EXCEPTION = "ไม่มีข้อมูลรุ่นรถยนต์ ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } else { item.CAR_MODEL = Convert.ToString((range.Cells[row, EXCEL_DATA.CAR_MODEL] as Excel.Range).Text).ToUpper(); } //CAR_YEAR if (Convert.ToString((range.Cells[row, EXCEL_DATA.CAR_YEAR] as Excel.Range).Text) == "") { item.EXCEPTION = "ไม่มีข้อมูลปีรถยนต์ ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } else { item.CAR_YEAR = Convert.ToString((range.Cells[row, EXCEL_DATA.CAR_YEAR] as Excel.Range).Text); } //INSURE_CATEGORY if (Convert.ToString((range.Cells[row, EXCEL_DATA.INSURE_CATEGORY] as Excel.Range).Text) == "") { item.EXCEPTION = "ไม่มีข้อมูลประเภทประกันรถยนต์ ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } else { item.INSURE_CATEGORY = Convert.ToString((range.Cells[row, EXCEL_DATA.INSURE_CATEGORY] as Excel.Range).Text); } //INSURE_TYPE_REPAIR if (Convert.ToString((range.Cells[row, EXCEL_DATA.INSURE_TYPE_REPAIR] as Excel.Range).Text) == "") { item.EXCEPTION = "ไม่มีข้อมูลประเภทการซ่อม ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } else { item.INSURE_TYPE_REPAIR = Convert.ToString((range.Cells[row, EXCEL_DATA.INSURE_TYPE_REPAIR] as Excel.Range).Text); } //NET_PRICE decimal NET_PRICE = 0; result = Decimal.TryParse((range.Cells[row, EXCEL_DATA.NET_PRICE] as Excel.Range).Text, out NET_PRICE); if (result) { item.NET_PRICE = NET_PRICE; } else { item.EXCEPTION = "ข้อมูล เบี้ยสุทธิ ไม่ได้เป็นตัวเลข ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } //TOTAL_PRICE decimal TOTAL_PRICE = 0; result = Decimal.TryParse((range.Cells[row, EXCEL_DATA.TOTAL_PRICE] as Excel.Range).Text, out TOTAL_PRICE); if (result) { item.TOTAL_PRICE = TOTAL_PRICE; } else { item.EXCEPTION = "ข้อมูล เบี้ยรวม ไม่ได้เป็นตัวเลข ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } //PRICE_ROUND decimal PRICE_ROUND = 0; result = Decimal.TryParse((range.Cells[row, EXCEL_DATA.PRICE_ROUND] as Excel.Range).Text, out PRICE_ROUND); if (result) { item.PRICE_ROUND = PRICE_ROUND; } else { item.EXCEPTION = "ข้อมูล เบี้ยกลม ไม่ได้เป็นตัวเลข ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } //CAPITAL_INSURANCE decimal CAPITAL_INSURANCE = 0; result = Decimal.TryParse((range.Cells[row, EXCEL_DATA.CAPITAL_INSURANCE] as Excel.Range).Text, out CAPITAL_INSURANCE); if (result) { item.CAPITAL_INSURANCE = CAPITAL_INSURANCE; } else { item.EXCEPTION = "ข้อมูล ทุนประกันภัย ไม่ได้เป็นตัวเลข ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } //CONFIDENTIAL_STATUS if (Convert.ToString((range.Cells[row, EXCEL_DATA.CONFIDENTIAL_STATUS] as Excel.Range).Text) == "") { item.CONFIDENTIAL_STATUS = "S"; } else { item.CONFIDENTIAL_STATUS = Convert.ToString((range.Cells[row, EXCEL_DATA.CONFIDENTIAL_STATUS] as Excel.Range).Text); } //LIVE_COVERAGE_PEOPLE decimal LIVE_COVERAGE_PEOPLE = 0; result = Decimal.TryParse((range.Cells[row, EXCEL_DATA.LIVE_COVERAGE_PEOPLE] as Excel.Range).Text, out LIVE_COVERAGE_PEOPLE); if (result) { item.LIVE_COVERAGE_PEOPLE = LIVE_COVERAGE_PEOPLE; } else { item.EXCEPTION = "ข้อมูล ชีวิต ร่างกาย หรืออนามัย /คน ไม่ได้เป็นตัวเลข ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } //LIVE_COVERAGE_TIME decimal LIVE_COVERAGE_TIME = 0; result = Decimal.TryParse((range.Cells[row, EXCEL_DATA.LIVE_COVERAGE_TIME] as Excel.Range).Text, out LIVE_COVERAGE_TIME); if (result) { item.LIVE_COVERAGE_TIME = LIVE_COVERAGE_TIME; } else { item.EXCEPTION = "ข้อมูล ชีวิต ร่างกาย หรืออนามัย /ครั้ง ไม่ได้เป็นตัวเลข ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } //ASSET_TIME decimal ASSET_TIME = 0; result = Decimal.TryParse((range.Cells[row, EXCEL_DATA.ASSET_TIME] as Excel.Range).Text, out ASSET_TIME); if (result) { item.ASSET_TIME = ASSET_TIME; } else { item.EXCEPTION = "ข้อมูล ทรัพย์สิน/ครั้ง ไม่ได้เป็นตัวเลข ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } //DAMAGE_TO_VEHICLE decimal DAMAGE_TO_VEHICLE = 0; result = Decimal.TryParse((range.Cells[row, EXCEL_DATA.DAMAGE_TO_VEHICLE] as Excel.Range).Text, out DAMAGE_TO_VEHICLE); if (result) { item.DAMAGE_TO_VEHICLE = DAMAGE_TO_VEHICLE; } else { item.EXCEPTION = "ข้อมูล ความเสียหายต่อรถยนต์ ไม่ได้เป็นตัวเลข ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } //MISSING_FIRE_CAR decimal MISSING_FIRE_CAR = 0; result = Decimal.TryParse((range.Cells[row, EXCEL_DATA.MISSING_FIRE_CAR] as Excel.Range).Text, out MISSING_FIRE_CAR); if (result) { item.MISSING_FIRE_CAR = MISSING_FIRE_CAR; } else { item.EXCEPTION = "ข้อมูล รถยนต์สูญหาย/ไฟไหม้ ไม่ได้เป็นตัวเลข ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } //FIRST_DAMAGE_PRICE decimal FIRST_DAMAGE_PRICE = 0; result = Decimal.TryParse((range.Cells[row, EXCEL_DATA.FIRST_DAMAGE_PRICE] as Excel.Range).Text, out FIRST_DAMAGE_PRICE); if (result) { item.FIRST_DAMAGE_PRICE = FIRST_DAMAGE_PRICE; } else { item.EXCEPTION = "ข้อมูล ค่าความเสียหายส่วนแรก ไม่ได้เป็นตัวเลข ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } //PERSONAL_ACCIDENT_AMT decimal PERSONAL_ACCIDENT_AMT = 0; result = Decimal.TryParse((range.Cells[row, EXCEL_DATA.PERSONAL_ACCIDENT_AMT] as Excel.Range).Text, out PERSONAL_ACCIDENT_AMT); if (result) { item.PERSONAL_ACCIDENT_AMT = PERSONAL_ACCIDENT_AMT; } else { item.EXCEPTION = "ข้อมูล อุบัติเหตุส่วนบุคคล ไม่ได้เป็นตัวเลข ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } //PERSONAL_ACCIDENT_PEOPLE int PERSONAL_ACCIDENT_PEOPLE = 0; result = Int32.TryParse((range.Cells[row, EXCEL_DATA.PERSONAL_ACCIDENT_PEOPLE] as Excel.Range).Text, out PERSONAL_ACCIDENT_PEOPLE); if (result) { item.PERSONAL_ACCIDENT_PEOPLE = PERSONAL_ACCIDENT_PEOPLE; } else { item.EXCEPTION = "ข้อมูล จำนวนคน/อุบัติเหตุส่วนบุคคล ไม่ได้เป็นตัวเลข ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } //MEDICAL_FEE_AMT decimal MEDICAL_FEE_AMT = 0; result = Decimal.TryParse((range.Cells[row, EXCEL_DATA.MEDICAL_FEE_AMT] as Excel.Range).Text, out MEDICAL_FEE_AMT); if (result) { item.MEDICAL_FEE_AMT = MEDICAL_FEE_AMT; } else { item.EXCEPTION = "ข้อมูล ค่ารักษาพยาบาล ไม่ได้เป็นตัวเลข ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } //MEDICAL_FEE_PEOPLE int MEDICAL_FEE_PEOPLE = 0; result = Int32.TryParse((range.Cells[row, EXCEL_DATA.MEDICAL_FEE_PEOPLE] as Excel.Range).Text, out MEDICAL_FEE_PEOPLE); if (result) { item.MEDICAL_FEE_PEOPLE = MEDICAL_FEE_PEOPLE; } else { item.EXCEPTION = "ข้อมูล จำนวนคน/ค่ารักษาพยาบาล ไม่ได้เป็นตัวเลข ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } //DRIVER_INSURANCE_AMT decimal DRIVER_INSURANCE_AMT = 0; result = Decimal.TryParse((range.Cells[row, EXCEL_DATA.DRIVER_INSURANCE_AMT] as Excel.Range).Text, out DRIVER_INSURANCE_AMT); if (result) { item.DRIVER_INSURANCE_AMT = DRIVER_INSURANCE_AMT; } else { item.EXCEPTION = "ข้อมูล ประกันตัวผู้ขับขี่ ไม่ได้เป็นตัวเลข ในบรรทัดที่ " + row + " ของ Sheet :" + xlWorkSheet.Name; item.EXCEPTION_INDEX = index; } if (item.EXCEPTION != "") { items.Add(new TextError() { Error = item.EXCEPTION, Index = item.EXCEPTION_INDEX.ToString() }); } else { listInsureCarData.Add(item); } } index++; } } xlWorkBook.Close(0); xlApp.Quit(); return(listInsureCarData); } catch (Exception ex) { throw ex; } }
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()); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { bool complete = false; MemberData member = (MemberData)DataCommon.Get("DATA.MEMBER"); InsureCarData newItem = new InsureCarData(); if (cbbCompany.Text == "") { MessageBox.Show("กรูณาเลือก บริษัทประกันภัย"); return; } newItem.COMPANY_CODE = new InsureCompanyDAL().GetCompanyCode(cbbCompany.Text); if (txtPackage.Text == "") { MessageBox.Show("กรูณากรอก ชื่อแพคเกจ"); return; } newItem.PACKAGE_NAME = txtPackage.Text; if (cbbCarName.Text == "") { MessageBox.Show("กรูณาเลือก ยี่ห้อรถยนต์"); return; } if (cbbCarModel.Text == "") { MessageBox.Show("กรูณาเลือก รุ่นรถยนต์"); return; } if (cbbCarEngine.Text == "") { MessageBox.Show("กรูณาเลือก เครื่องยนต์"); return; } CarData carItem = new CarDAL().GetItem(cbbCarName.Text, cbbCarModel.Text, cbbCarEngine.Text); newItem.CAR_ID = carItem.CAR_ID; newItem.CAR_CODE = carItem.CAR_CODE; newItem.CAR_ENGINE = carItem.CAR_ENGINE; newItem.CAR_MODEL = carItem.CAR_MODEL; newItem.CAR_NAME = carItem.CAR_NAME; newItem.CAR_YEAR = cbbCarYear.Text; newItem.CONFIDENTIAL_STATUS = cbbConfident.Text == "Show" ? "S" : "H"; newItem.CREATE_DATE = DateTime.Now; newItem.CREATE_USER = member.MEMBER_USER; newItem.INSURE_CAR_STATUS = cbbStatus.Text == "ใช้งาน" ? "A" : "I"; newItem.INSURE_CATEGORY = cbbInsureCat.Text; newItem.INSURE_TYPE_REPAIR = cbbTypeRepair.Text; newItem.UPDATE_DATE = DateTime.Now; newItem.UPDATE_USER = member.MEMBER_USER; if (txtCapitalInsure.Text == "") { MessageBox.Show("กรูณากรอก ทุนประกันภัย"); return; } newItem.CAPITAL_INSURANCE = Convert.ToDecimal(txtCapitalInsure.Text); if (txtNetPrice.Text == "") { MessageBox.Show("กรูณากรอก เบี้ยสุทธิ"); return; } newItem.NET_PRICE = Convert.ToDecimal(txtNetPrice.Text); if (txtTotalPrice.Text == "") { MessageBox.Show("กรูณากรอก เบี้ยรวม"); return; } newItem.TOTAL_PRICE = Convert.ToDecimal(txtTotalPrice.Text); if (txtRoundPrice.Text == "") { MessageBox.Show("กรูณากรอก เบี้ยกลม"); return; } newItem.PRICE_ROUND = Convert.ToDecimal(txtRoundPrice.Text); int priority = 0; bool result = Int32.TryParse(txtPriolity.Text, out priority); if (result) { newItem.INSURE_PRIORITY = priority; } else { newItem.INSURE_PRIORITY = 999; } if (txtEff.Text == "") { MessageBox.Show("กรูณาเลือก วันที่มีผล"); return; } newItem.EFFECTIVE_DATE = Convert.ToDateTime(txtEff.Text); if (txtExp.Text == "") { MessageBox.Show("กรูณาเลือก วันที่หมดอายุ"); return; } newItem.EXPIRE_DATE = Convert.ToDateTime(txtExp.Text); if (txtCoveragePeople.Text == "") { MessageBox.Show("กรูณากรอก ชีวิต ร่างกาย หรืออนามัย /คน"); return; } newItem.LIVE_COVERAGE_PEOPLE = Convert.ToDecimal(txtCoveragePeople.Text); if (txtCoverageTime.Text == "") { MessageBox.Show("กรูณากรอก ชีวิต ร่างกาย หรืออนามัย /ครั้ง"); return; } newItem.LIVE_COVERAGE_TIME = Convert.ToDecimal(txtCoverageTime.Text); if (txtAssetTime.Text == "") { MessageBox.Show("กรูณากรอก ทรัพย์สิน/ครั้ง"); return; } newItem.ASSET_TIME = Convert.ToDecimal(txtAssetTime.Text); if (txtDamageCar.Text == "") { MessageBox.Show("กรูณากรอก ความเสียหายต่อรถยนต์"); return; } newItem.DAMAGE_TO_VEHICLE = Convert.ToDecimal(txtDamageCar.Text); if (txtMissingCar.Text == "") { MessageBox.Show("กรูณากรอก รถยนต์สูญหาย/ไฟไหม้"); return; } newItem.MISSING_FIRE_CAR = Convert.ToDecimal(txtMissingCar.Text); if (txtFirstDamage.Text == "") { MessageBox.Show("กรูณากรอก ค่าความเสียหายส่วนแรก"); return; } newItem.FIRST_DAMAGE_PRICE = Convert.ToDecimal(txtFirstDamage.Text); if (txtInsureDriver.Text == "") { MessageBox.Show("กรูณากรอก ประกันตัวผู้ขับขี่"); return; } newItem.DRIVER_INSURANCE_AMT = Convert.ToDecimal(txtInsureDriver.Text); if (txtPERSONAL_ACCIDENT_AMT.Text == "") { MessageBox.Show("กรูณากรอก อุบัติเหตุส่วนบุคคล"); return; } newItem.PERSONAL_ACCIDENT_AMT = Convert.ToDecimal(txtPERSONAL_ACCIDENT_AMT.Text); if (txtPERSONAL_ACCIDENT_PEOPLE.Text == "") { MessageBox.Show("กรูณากรอก จำนวนคนต่ออุบัติเหตุส่วนบุคคล"); return; } newItem.PERSONAL_ACCIDENT_PEOPLE = Convert.ToInt32(txtPERSONAL_ACCIDENT_PEOPLE.Text); if (txtMEDICAL_FEE_AMT.Text == "") { MessageBox.Show("กรูณากรอก ค่ารักษาพยาบาล"); return; } newItem.MEDICAL_FEE_AMT = Convert.ToDecimal(txtMEDICAL_FEE_AMT.Text); if (txtMEDICAL_FEE_PEOPLE.Text == "") { MessageBox.Show("กรูณากรอก จำนวนคนต่อค่ารักษาพยาบาล"); return; } newItem.MEDICAL_FEE_PEOPLE = Convert.ToInt32(txtMEDICAL_FEE_PEOPLE.Text); if (MessageBox.Show("ยืนยันการบันทึกข้อมูล", "การบันทึกข้อมูล", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes) { if (DataCommon.Exists("INSURE_CAR_EDIT")) { InsureCarData oldItem = (InsureCarData)DataCommon.Get("INSURE_CAR_EDIT"); new InsureCarDAL().Update(oldItem, newItem); complete = true; } else { new InsureCarDAL().Insert(newItem); complete = true; } if (complete) { MessageBox.Show("บันทึกข้อมูลสำเร็จ"); this.Close(); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }