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