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