コード例 #1
0
ファイル: SLM_SCR_038.aspx.cs プロジェクト: KKPBank/SLM
        private void SetData(kkslm_ms_teamtelesales ts)
        {
            hdfID.Value   = ts.slm_TeamTelesales_Id.ToString();
            txtDCode.Text = ts.slm_TeamTelesales_Code;
            txtDName.Text = ts.slm_TeamTelesales_Name;
            //AppUtil.SetComboValue(cmbDHeader, ts.slm_HeadStaff);
            rdoStatus.SelectedIndex = rdoStatus.Items.IndexOf(rdoStatus.Items.FindByValue(ts.is_Deleted.ToString()));
            hdfStaffID.Value        = ts.slm_HeadStaff;
            SlmScr038Biz biz = new SlmScr038Biz();
            string       empcode;
            var          stf = biz.GetStaffNameFromID(SLMUtil.SafeDecimal(ts.slm_HeadStaff), out empcode);

            if (stf != null)
            {
                txtDHeader.Text   = empcode; // stf.slm_EmpCode;
                lblStaffName.Text = stf;     // (stf.slm_PositionName == null ? "" : stf.slm_PositionName + " - ") + stf.slm_StaffNameTH ?? "";
            }
            else

            {
                txtDHeader.Text   = "";
                lblStaffName.Text = "";
            }
            txtDCode.ReadOnly = true;
            updModal.Update();
        }
コード例 #2
0
        private kkslm_ms_config_car_premium GetData()
        {
            kkslm_ms_config_car_premium cp = new kkslm_ms_config_car_premium();

            cp.slm_cc_pm_id   = SLMUtil.SafeDecimal(hdfID.Value);
            cp.slm_Brand_Code = cmbDBrand.SelectedValue;
            cp.is_Deleted     = rdoDStatus.SelectedValue == "True";
            return(cp);
        }
コード例 #3
0
ファイル: SLM_SCR_062.aspx.cs プロジェクト: KKPBank/SLM
        private bool ValidateData()
        {
            string err = "";

            //if (txtDCode.Text.Trim() == "") err += (err == "" ? "" : ", ") + "Team Telesales Code";
            //if (txtDName.Text.Trim() == "") err += (err == "" ? "" : ", ") + "ชื่อทีม Telesales";
            //if (cmbDHeader.SelectedValue == "") err += (err == "" ? "" : ", ") + "หัวหน้าทีม";
            if (cmbDRole.SelectedIndex == 0)
            {
                err += (err == "" ? "" : ", ") + "Role";
            }
            if (rdoInsuranceType.SelectedIndex < 0)
            {
                err += (err == "" ? "" : ", ") + "ผลตอบแทนธนาคาร";
            }
            if (txtDDiscountValue.Text.Trim() == "")
            {
                err += (err == "" ? "" : ", ") + "ส่วนลด";
            }


            if (err != "")
            {
                AppUtil.ClientAlert(this, "กรุณากรอก " + err);
                return(false);
            }

            #region Add by First -- 20/11/2016
            decimal temp;
            if (!decimal.TryParse(txtDDiscountValue.Text, out temp))
            {
                AppUtil.ClientAlert(this, "กรุณากรอกตัวเลขเท่านั้น");
                return(false);
            }
            // by PPP, 21/11/2016, หน้าจอป้องกันการคีย์ตัวอักษรแล้ว และ มีเช็คด้านล่างแล้ว
            //if (rdoDiscount.SelectedValue == "1" && SLMUtil.SafeInt(txtDDiscountValue.Text) == 0)
            //{
            //    AppUtil.ClientAlert(this, "กรุณากรอก ส่วนลด (%) เป็นตัวเลขจำนวนเต็มและไม่เกิน 100% เท่านั้น");//by PPP, 21/11/2016, เพิ่ม Wording
            //    return false;
            //}
            #endregion

            if (rdoDiscount.SelectedValue == "2" && SLMUtil.SafeDecimal(txtDDiscountValue.Text) > (decimal)9999999999999999.99)
            {
                AppUtil.ClientAlert(this, "ส่วนลด (บาท) ต้องไม่เกิน 9,999,999,999,999,999.99");
                return(false);
            }

            if (SLMUtil.SafeDecimal(txtDDiscountValue.Text) > 100 && rdoDiscount.SelectedValue == "1")
            {
                AppUtil.ClientAlert(this, "กรอกส่วนลดได้ไม่เกิน 100%");
                return(false);
            }


            return(true);
        }
コード例 #4
0
ファイル: SLM_SCR_038.aspx.cs プロジェクト: KKPBank/SLM
        protected void imbAction_Click(object sender, ImageClickEventArgs e)
        {
            var          id = SLMUtil.SafeDecimal(((ImageButton)sender).CommandArgument);
            SlmScr038Biz bz = new SlmScr038Biz();
            var          ts = bz.GetTeamData(id);

            if (ts != null)
            {
                SetData(ts);
                zPopDetail.Show();
            }
        }
コード例 #5
0
ファイル: SLM_SCR_038.aspx.cs プロジェクト: KKPBank/SLM
        private kkslm_ms_teamtelesales GetData()
        {
            kkslm_ms_teamtelesales ts = new kkslm_ms_teamtelesales();

            ts.slm_TeamTelesales_Id   = SLMUtil.SafeDecimal(hdfID.Value);
            ts.slm_TeamTelesales_Code = txtDCode.Text;
            ts.slm_TeamTelesales_Name = txtDName.Text;
            //ts.slm_HeadStaff = cmbDHeader.SelectedValue;
            ts.slm_HeadStaff = hdfStaffID.Value;
            ts.is_Deleted    = rdoStatus.SelectedValue == "True";
            return(ts);
        }
コード例 #6
0
ファイル: SLM_SCR_062.aspx.cs プロジェクト: KKPBank/SLM
        private kkslm_ms_discount GetData()
        {
            kkslm_ms_discount ds = new kkslm_ms_discount();

            ds.slm_Discount_Id       = SLMUtil.SafeInt(hdfID.Value);
            ds.slm_StaffTypeId       = SLMUtil.SafeDecimal(cmbDRole.SelectedValue);
            ds.slm_DiscountBath      = rdoDiscount.SelectedValue == "2" ? (decimal?)SLMUtil.SafeDecimal(txtDDiscountValue.Text) : null;
            ds.slm_DiscountPercent   = rdoDiscount.SelectedValue == "1" ? (int?)SLMUtil.SafeInt(txtDDiscountValue.Text) : null;
            ds.slm_InsuranceTypeCode = rdoInsuranceType.SelectedValue;
            //ds.slm_ActDiscountBaht = null;
            //ds.slm_ActDiscountPercent = null;
            ds.is_Deleted = rdoDStatus.SelectedValue == "True";
            return(ds);
        }
コード例 #7
0
        protected void btnPopupDoImportExcel_Click(object sender, EventArgs e)
        {
            try
            {
                string        message = "";
                ReceiveNoData data    = new ReceiveNoData();
                data.CodeName        = textCodeName.Text;
                data.InsComId        = SLMUtil.SafeDecimal(hiddenInsComId.Value);
                data.IsDeleted       = false;
                data.ProductId       = hiddenProductId.Value;
                data.ReceiveNoCancel = 0;
                data.ReceiveNoEnd    = SLMUtil.SafeDecimal(textEndReceiveNoNumber.Text);
                data.ReceiveNoStart  = SLMUtil.SafeDecimal(textStartReceiveNoNumber.Text);
                data.ReceiveNoRemain = data.ReceiveNoEnd - data.ReceiveNoStart;
                data.ReceiveNoTotal  = data.ReceiveNoRemain;
                data.ReceiveNoUsed   = 0;
                data.UpdatedBy       = HttpContext.Current.User.Identity.Name;
                data.UpdatedDate     = DateTime.Now;
                data.IsDeleted       = false;
                if (ObtScr002Biz.SaveReceiveData(data, out message))
                {
                    // rebind gridview
                    var result = ObtScr002Biz.GetSearchData(data.ProductId, data.InsComId, true);
                    BindGridview(pcReceiveNo, gvReceiveNoList, result.ToArray(), 0);

                    // hide add panel & clear data
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "hidePanel", "CancelAdd();", true);
                }
                else
                {
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "hidePanel", "AddReceiveNo();", true);
                }
                lblError.Text = message;
                mpePopupEdit.Show();
                mpePopupError.Show();
                upError.Update();
                //upnPopupEdit.Update();
            }
            catch (Exception ex)
            {
                string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
                _log.Error(message);
                AppUtil.ClientAlert(Page, message);
            }
        }
コード例 #8
0
ファイル: Tab004.ascx.cs プロジェクト: KKPBank/SLM
 protected void lbReloadPreleadInfo_Click(object sender, EventArgs e)
 {
     try
     {
         if (!string.IsNullOrEmpty(Request["ticketid"]))
         {
             var lead = SlmScr004Biz.SearchSCR004Data(Request["ticketid"]);
             GetLeadData(lead);
         }
         else if (!string.IsNullOrEmpty(Request["preleadid"]))
         {
             GetPreleadData(SLMUtil.SafeDecimal(Request["preleadid"]));
         }
     }
     catch (Exception ex)
     {
         string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
         _log.Error(message);
         AppUtil.ClientAlert(Page, message);
     }
 }
コード例 #9
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                if (!IsPostBack)
                {
                    ((Label)Page.Master.FindControl("lblTopic")).Text = "แก้ไขข้อมูล Prelead";
                    //ScreenPrivilegeData priData = RoleBiz.GetScreenPrivilege(HttpContext.Current.User.Identity.Name, "SLM_SCR_046");
                    //if (priData == null || priData.IsView != 1)
                    //    AppUtil.ClientAlertAndRedirect(Page, "คุณไม่มีสิทธิ์เข้าใช้หน้าจอนี้", "SLM_SCR_046.aspx");

                    var prid = SLMUtil.SafeDecimal(Request["preleadid"]);
                    LoadData(prid);
                }
            }
            catch (Exception ex)
            {
                string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
                _log.Error(message);
                AppUtil.ClientAlert(Page, message);
            }
        }
コード例 #10
0
        // upload popup
        protected void btnUpload_Click(object sender, EventArgs e)
        {
            tbResult.Visible  = false;
            pnlResult.Visible = false;
            pnlError.Visible  = false;
            if (!ValidateData(""))
            {
                popImport.Show();
                return;
            }

            string[] monabb   = { "jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec" };
            string   moncheck = monabb[cmbMonth.SelectedIndex - 1];

            if (fuData.HasFile)
            {
                try
                {
                    var ext = Path.GetExtension(fuData.FileName).ToLower();
                    if (ext != ".xls")
                    {
                        throw new Exception("กรุณาระบุไฟล์ให้ถูกต้อง (.xls)");
                    }

                    using (OleDbConnection conn = new OleDbConnection())
                    {
                        DataTable dt       = new DataTable();
                        string    filename = Path.GetTempFileName();
                        fuData.SaveAs(filename);
                        lblFilename.Text = fuData.FileName;
                        fuData.ClearAllFilesFromPersistedStore();


                        // อ่านข้อมูล excel
                        conn.ConnectionString = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;HDR=YES;IMEX=0;'", filename);
                        OleDbCommand cmd = new OleDbCommand();
                        cmd.Connection  = conn;
                        cmd.CommandType = CommandType.Text;
                        cmd.CommandText = "SELECT * FROM [Sheet1$]";
                        OleDbDataAdapter adp = new OleDbDataAdapter(cmd);
                        adp.Fill(dt);

                        // ตรวจสอบ column เดือน
                        if (dt.Columns[3].ColumnName.ToLower() != moncheck)
                        {
                            throw new Exception("ไม่พบข้อมูลสำหรับเดือนที่ระบุ");
                        }


                        // สร้าง data objects (ตัด row ที่มีค่าว่างทิ้ง)
                        List <SlmScr041Biz.ExcelData> lst = new List <SlmScr041Biz.ExcelData>();
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            var row = dt.Rows[i];
                            if (row[0].ToString() == "" && row[1].ToString() == "")
                            {
                                continue;
                            }

                            lst.Add(new SlmScr041Biz.ExcelData()
                            {
                                TeamCode    = row[0].ToString(),
                                EmpCode     = row[1].ToString(),
                                TAAName     = row[2].ToString(),
                                Performance = SLMUtil.SafeDecimal(row[3].ToString()),
                                Level       = row[4].ToString()
                            });
                        }

                        if (lst.Count == 0)
                        {
                            throw new Exception("ไม่พบข้อมูลสำหรับนำเข้า");
                        }
                        int succ, fail;
                        List <ControlListData> rs;
                        tbResult.Visible = false;

                        // นำเข้าข้อมูล
                        SlmScr041Biz bz = new SlmScr041Biz();
                        if (!bz.ImportTelesaleData(lst, cmbYear.SelectedValue, cmbMonth.SelectedValue, Page.User.Identity.Name, out succ, out fail, out rs))
                        {
                            throw new Exception(bz.ErrorMessage);
                        }
                        else
                        {
                            if (rs.Count == 0)
                            {
                                pnlError.Visible = false;
                                AppUtil.ClientAlert(this, "นำเข้าข้อมูลเรียบร้อย");
                            }
                            else
                            {
                                pnlError.Visible          = true;
                                gvUploadResult.DataSource = rs;
                                gvUploadResult.DataBind();
                                AppUtil.ClientAlert(this, "ข้อมูลไม่ถูกนำเข้า กรุณาตรวจสอบข้อผิดพลาด");
                            }

                            tbResult.Visible = true;
                            lblTotal.Text    = (succ + fail).ToString("#,##0");
                            lblSucc.Text     = succ.ToString("#,##0");
                            lblFail.Text     = fail.ToString("#,##0");
                            //lblResult.Text = String.Format("<b>ผลการนำเข้าข้อมูล :</b> ทั้งหมด {0} รายการ, สำเร็จ {1} รายการ, ผิดพลาด {2} รายการ ", succ + fail, succ, fail);
                        }
                    }
                }
                catch (Exception ex)
                {
                    fuData.ClearAllFilesFromPersistedStore();
                    if (ex.Message.Contains("Sheet1"))
                    {
                        lblUploadError.Text = "ไม่สามารถ Import ข้อมูลได้เนื่องจากไม่พบ Sheet : 'Sheet1'";
                    }
                    else if (ex.Message.Contains("External table is not in the expected format."))
                    {
                        lblUploadError.Text = "ไม่สามารถ Import ข้อมูลได้เนื่องจากรูปแบบไฟล์ไม่ถูกต้อง";
                    }
                    else
                    {
                        lblUploadError.Text = ex.Message;
                    }
                    _log.Error(ex.InnerException != null ? ex.InnerException.Message : ex.Message);
                }
            }
            else
            {
                lblUploadError.Text = "กรุณาระบุไฟล์ที่ต้องการนำเข้า";
            }
            popImport.Show();
        }
コード例 #11
0
        public List <LeadInfoBiz.LeadDetailAddress> GetInsAddrData()
        {
            List <LeadInfoBiz.LeadDetailAddress> adrLst = new List <LeadInfoBiz.LeadDetailAddress>();

            if (txtAddressNo.Text.Trim() != "" || cmbProvince.SelectedIndex >= 0)
            {
                adrLst.Add(new LeadInfoBiz.LeadDetailAddress()
                {
                    slm_RenewInsureAddressId = SLMUtil.SafeDecimal(hdfAddrID.Value),
                    slm_AddressType          = "C",
                    slm_AddressNo            = txtAddressNo.Text.Trim(),
                    slm_Moo          = txtMoo.Text.Trim(),
                    slm_BuildingName = txtBuildingName.Text.Trim(),
                    slm_Street       = txtStreet.Text.Trim(),
                    slm_Floor        = txtFloor.Text.Trim(),
                    slm_Soi          = txtSoi.Text.Trim(),
                    slm_Province     = SLMUtil.SafeInt(cmbProvince.SelectedValue),
                    slm_Amphur       = SLMUtil.SafeInt(cmbAmphur.SelectedValue),
                    slm_Tambon       = SLMUtil.SafeInt(cmbTambol.SelectedValue),
                    slm_PostalCode   = txtPostalCode.Text.Trim()
                });
            }

            if (txtOAddressNo.Text.Trim() != "" || cmbOProvince.SelectedIndex >= 0)
            {
                adrLst.Add(new LeadInfoBiz.LeadDetailAddress()
                {
                    slm_RenewInsureAddressId = SLMUtil.SafeDecimal(hdfOAddrID.Value),
                    slm_AddressType          = "O",
                    slm_AddressNo            = txtOAddressNo.Text.Trim(),
                    slm_Moo          = txtOMoo.Text.Trim(),
                    slm_BuildingName = txtOBuildingname.Text.Trim(),
                    slm_Street       = txtOStreet.Text.Trim(),
                    slm_Floor        = txtOFloor.Text.Trim(),
                    slm_Soi          = txtOSoi.Text.Trim(),
                    slm_Province     = SLMUtil.SafeInt(cmbOProvince.SelectedValue),
                    slm_Amphur       = SLMUtil.SafeInt(cmbOAmphur.SelectedValue),
                    slm_Tambon       = SLMUtil.SafeInt(cmbOTambol.SelectedValue),
                    slm_PostalCode   = txtOPostCode.Text.Trim()
                });
            }

            if (txtDAddressno.Text.Trim() != "" || cmbDProvince.SelectedIndex >= 0)
            {
                adrLst.Add(new LeadInfoBiz.LeadDetailAddress()
                {
                    slm_RenewInsureAddressId = SLMUtil.SafeDecimal(hdfDAddrID.Value),
                    slm_AddressType          = "D",
                    slm_AddressNo            = txtDAddressno.Text.Trim(),
                    slm_Moo          = txtDMoo.Text.Trim(),
                    slm_BuildingName = txtDBuilding.Text.Trim(),
                    slm_Street       = txtDStreet.Text.Trim(),
                    slm_Floor        = txtDFloor.Text.Trim(),
                    slm_Soi          = txtDSoi.Text.Trim(),
                    slm_Province     = SLMUtil.SafeInt(cmbDProvince.SelectedValue),
                    slm_Amphur       = SLMUtil.SafeInt(cmbDAmphur.SelectedValue),
                    slm_Tambon       = SLMUtil.SafeInt(cmbDTambol.SelectedValue),
                    slm_PostalCode   = txtDPostCode.Text.Trim(),
                });
            }


            return(adrLst);
        }
コード例 #12
0
        public LeadInfoBiz.LeadDetailInsData GetInsData()
        {
            var ins = new LeadInfoBiz.LeadDetailInsData();

            ins.slm_RenewInsureId = SLMUtil.SafeDecimal(hdfID.Value);
            ins.slm_ContractNo    = txtContractNo.Text.Trim();
            if (cmbCardType.SelectedIndex > 0)
            {
                ins.CardType = cmbCardType.SelectedValue;
            }
            if (cmbCountry.SelectedIndex > 0)
            {
                ins.CountryId = Convert.ToInt32(cmbCountry.SelectedValue);
            }
            ins.IsCustomer = chkOldCustomer.Checked;
            ins.CitizenId  = txtCitizenId.Text.Trim();
            if (tdBirthdate.DateValue.Year != 1)
            {
                ins.Birthdate = tdBirthdate.DateValue;
            }
            ins.MaritalStatus = rdoMarital.SelectedValue;
            if (cmbOccupation.SelectedIndex > 0)
            {
                ins.Occupation = cmbOccupation.SelectedValue;
            }
            ins.slm_CC = txtCarCC.Text.Trim();
            if (cmbBrand.SelectedIndex > 0)
            {
                ins.slm_RedbookBrandCode = cmbBrand.SelectedValue;
            }
            if (cmbModel.SelectedIndex > 0)
            {
                ins.slm_RedbookModelCode = cmbModel.SelectedValue;
            }
            if (cmbYearGroup.SelectedIndex > 0)
            {
                ins.slm_RedbookYearGroup = SLMUtil.SafeInt(cmbYearGroup.SelectedValue);
            }
            if (cmbSubModel.SelectedIndex > 0)
            {
                ins.slm_RedbookKKKey = cmbSubModel.SelectedValue;
            }
            //ins.slm_CoverageTypeId = SLMUtil.SafeInt(cmbCarType.SelectedValue);
            if (cmbCarType.SelectedIndex > 0)
            {
                ins.slm_InsurancecarTypeId = SLMUtil.SafeInt(cmbCarType.SelectedValue);
            }
            ins.slm_LicenseNo = txtCarLicense.Text.Trim();
            if (cmbProvinceRegis.SelectedItem.Value != "")
            {
                ins.ProvinceRegis = cmbProvinceRegis.SelectedItem.Value;
            }
            ins.slm_ChassisNo   = txtCarChassie.Text.Trim();
            ins.slm_EngineNo    = txtCarEngine.Text.Trim();
            ins.slm_SendDocFlag = chkSendToBranch.Checked ? "3" : "1";
            if (chkSendToBranch.Checked)
            {
                ins.slm_SendDocBrandCode = cmbDocBranch.SelectedValue;
            }

            // default?
            ins.slm_PolicyDiscountAmt       = SLMUtil.SafeInt(hdfPolicyDiscountAmt.Value);
            ins.slm_PolicyGrossVat          = SLMUtil.SafeInt(hdfPolicyGrossVat.Value);
            ins.slm_PolicyGrossStamp        = SLMUtil.SafeInt(hdfPolicyGrossStamp.Value);
            ins.slm_PolicyGrossPremium      = SLMUtil.SafeInt(hdfPolicyGrossPremium.Value);
            ins.slm_PolicyGrossPremiumTotal = SLMUtil.SafeInt(hdfPolicyGrossPremiumTotal.Value);
            ins.slm_ActGrossPremium         = SLMUtil.SafeInt(hdfActGrossPremium.Value);
            ins.slm_ActNetPremium           = SLMUtil.SafeInt(hdfActNetPremium.Value);
            ins.slm_ActVat   = SLMUtil.SafeInt(hdfActVat.Value);
            ins.slm_ActStamp = SLMUtil.SafeInt(hdfActStamp.Value);

            return(ins);
        }
コード例 #13
0
        protected void radioActive_CheckedChanged(object sender, EventArgs e)
        {
            try
            {
                string alertMessage = "";
                bool   inuse        = ObtScr002Biz.HasLotInUse(hiddenProductId.Value, SLMUtil.SafeDecimal(hiddenInsComId.Value));
                if (inuse)
                {
                    alertMessage           = "มี Lot ที่ใช้งานอยู่แล้ว ไม่สามารถเปลี่ยนสถานะได้";
                    trConfirmOK.Visible    = true;
                    trComfirmYesNo.Visible = false;
                }
                else
                {
                    alertMessage           = "ต้องการเปลี่ยนสถานะใช่หรือไม่?";
                    trConfirmOK.Visible    = false;
                    trComfirmYesNo.Visible = true;
                }

                GridViewRow row = ((RadioButton)sender).Parent.Parent as GridViewRow;
                txtEditRowIndex.Text = row.RowIndex.ToString();
                lblAlertMessage.Text = alertMessage;
                upConfirm.Update();
                mpePopupConfirm.Show();
                mpePopupEdit.Show();
            }
            catch (Exception ex)
            {
                string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
                _log.Error(message);
                AppUtil.ClientAlert(Page, message);
            }
        }
コード例 #14
0
        public SlmScr046Biz.PreleadDetails GetData()
        {
            var pl = new SlmScr046Biz.PreleadDetails();

            pl.slm_Prelead_Id      = SLMUtil.SafeDecimal(hdfPreleadId.Value);
            pl.slm_Contract_Number = txtContractNo.Text;
            if (cmbBranch.SelectedIndex > 0)
            {
                pl.slm_BranchCode = cmbBranch.SelectedValue;
            }
            pl.slm_Contract_Year = txtContractYear.Text;
            if (cmbContractStatus.SelectedIndex > 0)
            {
                pl.slm_Contract_Status = cmbContractStatus.SelectedValue;
            }
            if (cmbCarCategory.SelectedIndex > 0)
            {
                pl.slm_Car_Category = cmbCarCategory.SelectedValue;
            }
            pl.slm_Customer_Key = txtCustomerKey.Text;
            if (cmbCardTypeId.SelectedIndex > 0)
            {
                pl.slm_CardTypeId = SLMUtil.SafeInt(cmbCardTypeId.SelectedValue);
            }
            pl.slm_CitizenId = txtCitizenId.Text;
            if (cmbMaritalStatus.SelectedIndex > 0)
            {
                pl.slm_Marital_Status = cmbMaritalStatus.SelectedValue;
            }
            if (cmbTitleId.SelectedIndex > 0)
            {
                pl.slm_TitleId = SLMUtil.SafeInt(cmbTitleId.SelectedValue);
            }
            pl.slm_Name     = txtName.Text;
            pl.slm_LastName = txtLastName.Text;
            if (cmbOccupation.SelectedIndex > 0)
            {
                pl.slm_OccupationId = SLMUtil.SafeInt(cmbOccupation.SelectedValue);
            }
            pl.slm_Grade = txtGrade.Text;
            if (tdBirthDate.DateValue.Year != 1)
            {
                pl.slm_Birthdate = tdBirthDate.DateValue;
            }

            if (cmbCarByGovId.SelectedIndex > 0)
            {
                pl.slm_Car_By_Gov_Id = SLMUtil.SafeInt(cmbCarByGovId.SelectedValue);
            }
            if (cmbBrandCode.SelectedIndex > 0)
            {
                pl.slm_Brand_Code = cmbBrandCode.SelectedValue;
            }
            if (cmbModel.SelectedIndex > 0)
            {
                pl.slm_Model_Code = cmbModel.SelectedValue;
            }
            if (cmbYearGroup.SelectedIndex > 0)
            {
                pl.slm_Model_Year = cmbYearGroup.SelectedValue;
            }
            pl.slm_Engine_No      = txtEngineNo.Text;
            pl.slm_Chassis_No     = txtChassisNo.Text;
            pl.slm_Car_License_No = txtLicenseNo.Text;
            if (cmbProvinceRegis.SelectedIndex > 0)
            {
                pl.slm_ProvinceRegis = SLMUtil.SafeInt(cmbProvinceRegis.SelectedValue);
            }
            pl.slm_Cc = txtCC.Text;
            if (tdExpireDate.DateValue.Year != 1)
            {
                pl.slm_Expire_Date = tdExpireDate.DateValue;
            }

            // voluntary
            pl.slm_Voluntary_Mkt_Id = txtVolMktId.Text;
            if (cmbVolMktTitle.SelectedIndex > 0)
            {
                pl.slm_Voluntary_Mkt_TitleId = SLMUtil.SafeInt(cmbVolMktTitle.SelectedValue);
            }
            pl.slm_Voluntary_Mkt_First_Name = txtVolMktFName.Text;
            pl.slm_Voluntary_Mkt_Last_Name  = txtVolMktLName.Text;
            if (cmbVolCompanyCode.SelectedIndex > 0)
            {
                pl.slm_Voluntary_Company_Code = cmbVolCompanyCode.SelectedValue;
            }
            pl.slm_Voluntary_Policy_Number = txtVolPolicyNo.Text;
            if (cmbVolTypeKey.SelectedIndex > 0)
            {
                pl.slm_Voluntary_Type_Key = cmbVolTypeKey.SelectedValue;
            }
            pl.slm_Voluntary_Cov_Amt = SLMUtil.SafeDecimal(txtVolCarAmt.Text);
            if (tdVolPolicyEFDate.DateValue.Year != 1)
            {
                pl.slm_Voluntary_Policy_Eff_Date = tdVolPolicyEFDate.DateValue;
            }
            if (tdVolPolicyEPDate.DateValue.Year != 1)
            {
                pl.slm_Voluntary_Policy_Exp_Date = tdVolPolicyEPDate.DateValue;
            }
            pl.slm_Voluntary_Policy_Year      = txtVolPolicyYear.Text;
            pl.slm_Voluntary_Gross_Premium    = SLMUtil.SafeDecimal(txtVolGrossPreimum.Text);
            pl.slm_Voluntary_Policy_Exp_Year  = txtVolPolicyExpYear.Text;
            pl.slm_Voluntary_Policy_Exp_Month = txtVolPolicyExpMonth.Text;
            pl.slm_Voluntary_Channel_Key      = cmbVolChannelKey.Text;

            // benefit
            if (cmbBenTitleId.SelectedIndex > 0)
            {
                pl.slm_Benefit_TitleId = SLMUtil.SafeInt(cmbBenTitleId.SelectedValue);
            }
            pl.slm_Benefit_First_Name = txtBenFName.Text;
            pl.slm_Benefit_Last_Name  = txtBenLName.Text;
            pl.slm_Benefit_Telno      = txtBenTelNo.Text;

            // driver
            if (cmbDrv1TitleId.SelectedIndex > 0)
            {
                pl.slm_Driver_TitleId1 = SLMUtil.SafeInt(cmbDrv1TitleId.SelectedValue);
            }
            pl.slm_Driver_First_Name1 = txtDrv1FName.Text;
            pl.slm_Driver_Last_Name1  = txtDrv1LName.Text;
            if (tdDrv1Birthday.DateValue.Year != 1)
            {
                pl.slm_Driver_Birthdate1 = tdDrv1Birthday.DateValue;
            }
            pl.slm_Driver_Telno1 = txtDrv1TelNo.Text;
            if (cmbDrv2TitleId.SelectedIndex > 0)
            {
                pl.slm_Driver_TitleId2 = SLMUtil.SafeInt(cmbDrv2TitleId.SelectedValue);
            }
            pl.slm_Driver_First_Name2 = txtDrv2FName.Text;
            pl.slm_Driver_Last_Name2  = txtDrv2LName.Text;
            pl.slm_Driver_Telno2      = txtDrv2TelNo.Text;
            if (tdDrv2Birthday.DateValue.Year != 1)
            {
                pl.slm_Driver_Birthdate2 = tdDrv2Birthday.DateValue;
            }

            // compulsory
            if (cmbCompulCompCode.SelectedIndex > 0)
            {
                pl.slm_Compulsory_Company_Code = cmbCompulCompCode.SelectedValue;
            }
            pl.slm_Compulsory_Policy_Number = txtCompulPolicyNo.Text;
            pl.slm_Compulsory_Policy_Year   = txtCompulPolicyYear.Text;
            if (tdCompulPolicyEFDate.DateValue.Year != 1)
            {
                pl.slm_Compulsory_Policy_Eff_Date = tdCompulPolicyEFDate.DateValue;
            }
            if (tdCompulPolicyEPDate.DateValue.Year != 1)
            {
                pl.slm_Compulsory_Policy_Exp_Date = tdCompulPolicyEPDate.DateValue;
            }
            pl.slm_Compulsory_Gross_Premium = SLMUtil.SafeDecimal(txtCompulGrossPremium.Text);
            pl.slm_Compulsory_Cov_Amt       = SLMUtil.SafeDecimal(txtCompulCovAmt.Text);

            // guarantor
            pl.slm_Guarantor_Code1 = txtGuar1Code.Text;
            if (cmbGuar1Title.SelectedIndex > 0)
            {
                pl.slm_Guarantor_TitleId1 = SLMUtil.SafeInt(cmbGuar1Title.SelectedValue);
            }
            pl.slm_Guarantor_First_Name1 = txtGuar1FName.Text;
            pl.slm_Guarantor_Last_Name1  = txtGuar1LName.Text;
            pl.slm_Guarantor_Card_Id1    = txtGuar1CitizenId.Text;
            if (cmbGuar1Relation.SelectedIndex > 0)
            {
                pl.slm_Guarantor_RelationId1 = SLMUtil.SafeInt(cmbGuar1Relation.SelectedValue);
            }
            pl.slm_Guarantor_Telno1 = txtGuar1TelNo.Text;

            pl.slm_Guarantor_Code2 = txtGuar2Code.Text;
            if (cmbGuar2Title.SelectedIndex > 0)
            {
                pl.slm_Guarantor_TitleId2 = SLMUtil.SafeInt(cmbGuar2Title.SelectedValue);
            }
            pl.slm_Guarantor_First_Name2 = txtGuar2FName.Text;
            pl.slm_Guarantor_Last_Name2  = txtGuar2LName.Text;
            pl.slm_Guarantor_Card_Id2    = txtGuar2CitizenId.Text;
            if (cmbGuar2Relation.SelectedIndex > 0)
            {
                pl.slm_Guarantor_RelationId2 = SLMUtil.SafeInt(cmbGuar2Relation.SelectedValue);
            }
            pl.slm_Guarantor_Telno2 = txtGuar2TelNo.Text;

            pl.slm_Guarantor_Code3 = txtGuar3Code.Text;
            if (cmbGuar3Title.SelectedIndex > 0)
            {
                pl.slm_Guarantor_TitleId3 = SLMUtil.SafeInt(cmbGuar3Title.SelectedValue);
            }
            pl.slm_Guarantor_First_Name3 = txtGuar3FName.Text;
            pl.slm_Guarantor_Last_Name3  = txtGuar3LName.Text;
            pl.slm_Guarantor_Card_Id3    = txtGuar3CitizenId.Text;
            if (cmbGuar3Relation.SelectedIndex > 0)
            {
                pl.slm_Guarantor_RelationId3 = SLMUtil.SafeInt(cmbGuar3Relation.SelectedValue);
            }
            pl.slm_Guarantor_Telno3 = txtGuar3TelNo.Text;

            return(pl);
        }