private void BuildAmphur()
{
//เขต/อำเภอ
cmbAmphur.DataSource = SlmScr010Biz.GetAmphurDataNew(SLMUtil.SafeInt(cmbProvince.SelectedItem.Value));
cmbAmphur.DataTextField = "TextField";
cmbAmphur.DataValueField = "ValueField";
cmbAmphur.DataBind();
cmbAmphur.Items.Insert(0, new ListItem("", ""));
}
private void BuildTambol()
{
//แขวง/ตำบล
cmbTambol.DataSource = SlmScr010Biz.GetTambolDataNew(SLMUtil.SafeInt(cmbAmphur.SelectedItem.Value));
cmbTambol.DataTextField = "TextField";
cmbTambol.DataValueField = "ValueField";
cmbTambol.DataBind();
cmbTambol.Items.Insert(0, new ListItem("", ""));
}
private kkslm_ms_mapping_brand_model_inscartype GetData()
{
kkslm_ms_mapping_brand_model_inscartype mm = new kkslm_ms_mapping_brand_model_inscartype();
mm.slm_BrandCode = cmbDBrand.SelectedValue;
mm.slm_ModelCode = cmbDModel.SelectedValue;
mm.slm_InsuranceCarTypeId = SLMUtil.SafeInt(cmbDType.SelectedValue);
mm.is_Deleted = rdoDStatus.SelectedValue == "True";
return(mm);
}
protected void imbAction_Click(object sender, ImageClickEventArgs e)
{
var id = SLMUtil.SafeInt(((ImageButton)sender).CommandArgument);
SlmScr063Biz bz = new SlmScr063Biz();
var cp = bz.GetDetail(id);
if (cp != null)
{
SetData(cp);
zPopDetail.Show();
}
}
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);
}
private void LoadDataList(int pageIdx)
{
try
{
SlmScr062Biz biz = new SlmScr062Biz();
var lst = biz.GetDataList(SLMUtil.SafeInt(cmbSRole.SelectedValue), chkSPolicy.Checked, chkSAct.Checked, cmbSStatus.SelectedValue);// biz.GetDataList(txtTeamCode.Text, txtTeamName.Text, cmbTeamHeader.SelectedValue, cmbStatus.SelectedValue);
BindGridview(pcTop, lst, pageIdx);
pcTop.Visible = gvResult.PageCount > 0;
gvResult.Visible = true;
upResult.Update();
}
catch (Exception ex)
{
string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
_log.Error(message);
AppUtil.ClientAlert(Page, message);
}
}
private void SetDataList(int page)
{
try
{
var mn = SLMUtil.SafeInt(cmbMonth.SelectedValue);
gvResult.Columns[5].HeaderText = SlmScr053Biz.GetMonthName(mn - 5);
gvResult.Columns[6].HeaderText = SlmScr053Biz.GetMonthName(mn - 4);
gvResult.Columns[7].HeaderText = SlmScr053Biz.GetMonthName(mn - 3);
gvResult.Columns[8].HeaderText = SlmScr053Biz.GetMonthName(mn - 2);
gvResult.Columns[9].HeaderText = SlmScr053Biz.GetMonthName(mn - 1);
gvResult.Columns[10].HeaderText = SlmScr053Biz.GetMonthName(mn);
gvResult.Columns[11].HeaderText = SlmScr053Biz.GetMonthName(mn + 1);
gvResult.Columns[12].HeaderText = SlmScr053Biz.GetMonthName(mn + 2);
SlmScr053Biz bz = new SlmScr053Biz();
var lst = SlmScr053Biz.GetSearchResult(SLMUtil.SafeInt(cmbYear.SelectedValue), SLMUtil.SafeInt(cmbMonth.SelectedValue), SLMUtil.SafeInt(cmbTelesalesTeam.SelectedValue), cmbTelesales.SelectedValue);
BindGridview(pcTop, gvResult, lst.ToArray(), page);
}
catch (Exception ex)
{
AppUtil.ClientAlert(this, ex.InnerException == null ? ex.Message : ex.InnerException.Message);
}
upResult.Update();
}
// load and save data override
public override bool SaveData(string leadID, string UserID)
{
bool ret = true;
try
{
// prepare data
var ins = ctlLeadIns.GetInsData();
var addrLst = ctlLeadIns.GetInsAddrData();
ins.slm_ActNo = txtActNo.Text.Trim();
ins.slm_ActStartCoverDate = tdActStart.DateValue;
ins.slm_ActEndCoverDate = tdActEnd.DateValue;
ins.slm_ActIssuePlace = SLMUtil.SafeInt(cmbActIssue.SelectedValue);
ins.slm_ActIssueBranch = cmbActIssueBranch.SelectedValue;
LeadData ldata = new LeadData();
ldata.TicketId = CommonData.TicketID;
ldata.TitleId = CommonData.TitleID;
ldata.Name = CommonData.FName;
ldata.LastName = CommonData.LName;
ldata.ChannelId = CommonData.ChannelID;
ldata.CampaignId = CommonData.CampaignID;
ldata.TelNo_1 = CommonData.Phone1;
ldata.TelNo_2 = CommonData.Phone2;
ldata.Owner_Branch = CommonData.Branch;
ldata.Owner = CommonData.Owner;
ldata.IsCustomer = ins.IsCustomer ? "Y" : "N";
ldata.CardType = SLMUtil.SafeInt(ins.CardType);
ldata.CitizenId = ins.CitizenId;
ldata.CountryId = ins.CountryId;
ldata.slm_SubStatus = "15";
ldata.Detail = txtDetails.Text.Trim();
if (ins.Birthdate.Year > 1)
{
ldata.Birthdate = ins.Birthdate;
}
ldata.Occupation = SLMUtil.SafeInt(ins.Occupation);
ldata.TicketIdRefer = CommonData.TicketIDRefer;
ldata.ProvinceRegis = string.IsNullOrEmpty(ins.ProvinceRegis) ? null : (int?)int.Parse(ins.ProvinceRegis);
//owner, delegate
ldata.HasNewOwner = CommonData.ActOwner;
ldata.HasNewDelegate = CommonData.ActDelegate;
//owner
if (CommonData.Owner != "") //owner lead
{
ldata.Owner = CommonData.Owner;
ldata.NewOwner = CommonData.Owner;
ldata.NewOwner2 = CommonData.Owner;
StaffData StaffData = SlmScr010Biz.GetStaffData(CommonData.Owner);
if (StaffData != null)
{
ldata.StaffId = Convert.ToInt32(StaffData.StaffId);
//LData.Owner_Branch = StaffData.BranchCode;
}
}
ldata.slmOldOwner = CommonData.OldOwner;
ldata.OldOwner = CommonData.OldOwner;
ldata.OldOwner2 = CommonData.OldOwner;
ldata.Type2 = CommonData.Type2;
ldata.Delegate_Branch = CommonData.DelegateBranch;
ldata.Delegate = CommonData.DelegateLead;
//delegate
if (!string.IsNullOrEmpty(CommonData.DelegateFlag))
{
ldata.Delegate_Flag = Convert.ToDecimal(CommonData.DelegateFlag); //Add
if (ldata.Delegate_Flag == 1)
{
ldata.Delegate_Branch = CommonData.DelegateBranch;
ldata.Delegate = CommonData.DelegateLead;
ldata.NewDelegate = CommonData.DelegateLead;
ldata.OldDelegate = CommonData.OldDelegateLead;
ldata.Type = CommonData.Type;
}
}
else
{
ldata.Delegate_Flag = 0;
}
if (string.IsNullOrEmpty(ldata.Delegate))
{
ldata.Delegate_Flag = 0;
}
if (ldata.CardType == 0)
{
ldata.CardType = null;
}
if (ldata.Occupation == 0)
{
ldata.Occupation = null;
}
// get create by branch
StaffData createbyData = SlmScr010Biz.GetStaffData(HttpContext.Current.User.Identity.Name);
if (createbyData != null)
{
ldata.CreatedBy_Branch = createbyData.BranchCode;
}
// saving
string ticketid;
LeadInfoBiz bz = new LeadInfoBiz();
if (!bz.SaveInsData(ldata, ins, addrLst, UserID, out ticketid, 2))
{
throw new Exception(bz.ErrorMessage);
}
// post action
CommonData.R_TicketID = ticketid;
if (ldata.HasAdamsUrl)
{
CommonData.R_Message = "ต้องการแนบเอกสารต่อใช่หรือไม่?";
CommonData.R_HasAdams = true;
}
else
{
CommonData.R_Message = "ต้องการไปหน้าแสดงรายละเอียดผู้มุ่งหวังใช่หรือไม่?";
CommonData.R_HasAdams = false;
}
}
catch (Exception ex)
{
string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
_log.Debug(message);
ret = false;
CommonData.R_Message = message;
}
return(ret);
}
protected void btnExcel1_Click(object sender, EventArgs e)
{
if (tdmIncFrom.DateValue.Year == 1 || tdmIncTo.DateValue.Year == 1)
{
AppUtil.ClientAlert(this, "กรุณาเลือกเลือกช่วงวันที่กดเบิก Incentive ที่ต้องการค้นหา"); return;
}
if (tdmIncFrom.DateValue.Year != 1 && tdmIncTo.DateValue.Year != 1)
{
TimeSpan datediff = tdmIncTo.DateValue.Subtract(tdmIncFrom.DateValue);
double totalday = datediff.TotalDays;
if (totalday >= 60)
{
AppUtil.ClientAlert(this, "ไม่สามารถค้นหาช่วงวันที่กดรับ Incentive มากกว่าหรือเท่ากับ 60 วันได้");
return;
}
}
SlmScr049Biz bz = new SlmScr049Biz();
var filename = Path.GetTempPath() + "\\tmpexcel_049_" + Page.User.Identity.Name + ".xls";// Path.GetTempFileName();
if (bz.CreateExcel1v2(filename, tdmIncFrom.DateValue, tdmIncTo.DateValue, tdmCallFrom.DateValue, tdmCallTo.DateValue, SLMUtil.SafeInt(cmbTelesale.SelectedValue), cmbTelesaleName.SelectedValue))
{
ExportExcel(filename, "BSAT_REPORT_" + DateTime.Now.ToString("yyyyMMdd_HHmm") + ".xls");
}
else
{
AppUtil.ClientAlert(this, bz.ErrorMessage);
}
}
protected void gvResult_DataBound(object sender, EventArgs e)
{
if (gvResult.HeaderRow != null)
{
gvResult.HeaderRow.Visible = false;
}
var mn = SLMUtil.SafeInt(cmbMonth.SelectedValue);
if (gvResult.Rows.Count == 0)
{
return;
}
GridViewRow row = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal);
TableHeaderCell cell = new TableHeaderCell();
cell.Text = "Team Code";
cell.RowSpan = 3;
row.Controls.Add(cell);
cell = new TableHeaderCell();
cell.RowSpan = 3;
cell.Text = "Telesales";
row.Controls.Add(cell);
cell = new TableHeaderCell();
cell.ColumnSpan = 13;
cell.Text = string.Format("Lead คุ้มครองเดือน {0}-{1}", SlmScr053Biz.GetMonthName(mn - 5), SlmScr053Biz.GetMonthName(mn + 2));
row.Controls.Add(cell);
gvResult.Controls[0].Controls.AddAt(0, row);
row = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal);
cell = new TableHeaderCell();
cell.Text = "Port ตั้งต้น";
cell.RowSpan = 2;
row.Controls.Add(cell);
cell = new TableHeaderCell();
cell.RowSpan = 2;
cell.Text = "Port คงค้าง";
row.Controls.Add(cell);
cell = new TableHeaderCell();
cell.RowSpan = 2;
cell.Text = "Port ที่ไม่ต่อประกัน";
row.Controls.Add(cell);
cell = new TableHeaderCell();
cell.ColumnSpan = 8;
cell.Text = "เดือนที่ชำระประกัน";
row.Controls.Add(cell);
cell = new TableHeaderCell();
cell.RowSpan = 2;
cell.Text = "Grand Total";
row.Controls.Add(cell);
cell = new TableHeaderCell();
cell.RowSpan = 2;
cell.Text = "%Success";
row.Controls.Add(cell);
gvResult.Controls[0].Controls.AddAt(1, row);
int month;
int.TryParse(cmbMonth.SelectedValue, out month);
row = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal);
for (int mnz = month - 5; mnz <= month + 2; mnz++)
{
cell = new TableHeaderCell();
cell.Text = SlmScr053Biz.GetMonthName(mnz);
row.Controls.Add(cell);
}
gvResult.Controls[0].Controls.AddAt(2, row);
}
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);
}
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);
}
private void SetStaffCombo()
{
AppUtil.BuildCombo(cmbTelesaleName, SlmScr032Biz.GetSearchStaffList(cmbTelesale.SelectedValue == "" ? -1 : SLMUtil.SafeInt(cmbTelesale.SelectedValue)), "ทั้งหมด");
}
protected void btnExcel2_Click(object sender, EventArgs e)
{
SlmScr049Biz bz = new SlmScr049Biz();
var filename = Path.GetTempPath() + "\\tmpexcel_049_" + Page.User.Identity.Name + ".xls";// Path.GetTempFileName();
if (bz.CreateExcel2(filename, tdmIncFrom.DateValue, tdmIncTo.DateValue, tdmCallFrom.DateValue, tdmCallTo.DateValue, SLMUtil.SafeInt(cmbTelesale.SelectedValue), cmbTelesaleName.SelectedValue))
{
ExportExcel(filename, "SLM049_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xls");
}
else
{
AppUtil.ClientAlert(this, bz.ErrorMessage);
}
}
private void SetTTACombo()
{
BuildCombo(cmbTTAName, SlmScr032Biz.GetSearchStaffList(SLMUtil.SafeInt(cmbTeamCode.SelectedValue)), "ทั้งหมด");
}
private void SetSubModelCombo()
{
BuildCombo(cmbSubModel, SlmScr010Biz.GetSubModelDataNew(cmbBrand.SelectedValue, cmbModel.SelectedValue, SLMUtil.SafeInt(cmbYearGroup.SelectedValue)), "กรุณาระบุ");
}
private void SetOTambol()
{
BuildCombo(cmbOTambol, SlmScr010Biz.GetTambolDataNew(SLMUtil.SafeInt(cmbOAmphur.SelectedValue)));
}
private void SetTelesaleName()
{
AppUtil.BuildCombo(cmbTelesales, SlmScr051Biz.GetTelesaleList(SLMUtil.SafeInt(cmbTelesalesTeam.SelectedValue)), "ทั้งหมด");
}
private void SetDAmphur()
{
BuildCombo(cmbDAmphur, SlmScr010Biz.GetAmphurDataNew(SLMUtil.SafeInt(cmbDProvince.SelectedValue)));
}
private void LoadDataList(int pageIdx)
{
try
{
SlmScr039Biz biz = new SlmScr039Biz();
var lst = biz.GetDataList(cmbSBrand.SelectedValue, cmbSModel.SelectedValue, SLMUtil.SafeInt(cmbSType.SelectedValue), cmbSStatus.SelectedValue);
BindGridview(pcTop, lst, pageIdx);
gvResult.Visible = true;
pcTop.Visible = gvResult.PageCount > 0;
upResult.Update();
}
catch (Exception ex)
{
string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
_log.Error(message);
AppUtil.ClientAlert(Page, message);
}
}
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);
}