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();
}
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);
}
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);
}
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();
}
}
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();
}
}
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);
}
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);
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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();
}
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);
}
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);
}
}
private void SetStaffCombo()
{
AppUtil.BuildCombo(cmbTelesaleName, SlmScr032Biz.GetSearchStaffList(cmbTelesale.SelectedValue == "" ? -1 : SLMUtil.SafeInt(cmbTelesale.SelectedValue)), "ทั้งหมด");
}
private void SetTTACombo()
{
BuildCombo(cmbTTAName, SlmScr032Biz.GetSearchStaffList(SLMUtil.SafeInt(cmbTeamCode.SelectedValue)), "ทั้งหมด");
}
// 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 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 SetTelesaleName()
{
AppUtil.BuildCombo(cmbTelesales, SlmScr051Biz.GetTelesaleList(SLMUtil.SafeInt(cmbTelesalesTeam.SelectedValue)), "ทั้งหมด");
}
// 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();
}
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);
}
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);
}
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 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);
}
}
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);
}
}