private SearchLeadCondition GetSearchCondition() { SearchLeadCondition data = new SearchLeadCondition(); data.TicketId = txtTicketID.Text.Trim(); data.Firstname = txtFirstname.Text.Trim(); data.Lastname = txtLastname.Text.Trim(); data.CardType = cmbCardType.Items.Count > 0 ? cmbCardType.SelectedItem.Value : string.Empty; //ประเภทบุคคล data.CitizenId = txtCitizenId.Text.Trim(); data.CampaignId = cmbCampaign.SelectedItem.Value; data.ChannelId = cmbChannel.SelectedItem.Value; data.OwnerUsername = cmbOwnerLeadSearch.Items.Count > 0 ? cmbOwnerLeadSearch.SelectedItem.Value : string.Empty; //Owner Lead data.OwnerBranch = cmbOwnerBranchSearch.Items.Count > 0 ? cmbOwnerBranchSearch.SelectedItem.Value : string.Empty; //Owner Branch data.DelegateBranch = cmbDelegateBranchSearch.Items.Count > 0 ? cmbDelegateBranchSearch.SelectedItem.Value : string.Empty; //Delegate Branch data.DelegateLead = cmbDelegateLeadSearch.Items.Count > 0 ? cmbDelegateLeadSearch.SelectedItem.Value : string.Empty; //Delegate Lead data.CreateByBranch = cmbCreatebyBranchSearch.Items.Count > 0 ? cmbCreatebyBranchSearch.SelectedItem.Value : string.Empty; //CreateBy Branch data.CreateBy = cmbCreatebySearch.Items.Count > 0 ? cmbCreatebySearch.SelectedItem.Value : string.Empty; //CreateBy data.CreatedDate = tdmCreateDate.DateValue; data.AssignedDate = tdmAssignDate.DateValue; data.StatusList = GetStatusList(); data.PageIndex = pcTop.SelectedPageIndex > -1 ? pcTop.SelectedPageIndex : 0; data.StaffType = SlmScr003Biz.GetStaffType(HttpContext.Current.User.Identity.Name); data.SortExpression = SortExpressionProperty; data.SortDirection = SortDirectionProperty.ToString(); data.AdvancedSearch = txtAdvanceSearch.Text.Trim() == "Y" ? true : false; data.ContractNoRefer = txtContractNoRefer.Text.Trim(); return(data); }
public static List <SearchLeadResult> SearchLeadData(SearchLeadCondition data, string username, string orderByFlag) { SearchLeadModel search = new SearchLeadModel(); string createDate = data.CreatedDate.Year != 1 ? data.CreatedDate.Year + data.CreatedDate.ToString("-MM-dd") : string.Empty; string assignDate = data.AssignedDate.Year != 1 ? data.AssignedDate.Year + data.AssignedDate.ToString("-MM-dd") : string.Empty; return(search.SearchLeadData(data.TicketId, data.Firstname, data.Lastname, data.CardType, data.CitizenId, data.CampaignId, data.ChannelId, data.OwnerUsername, createDate, assignDate, data.StatusList, username, data.StaffType, data.OwnerBranch, data.DelegateBranch, data.DelegateLead, data.ContractNoRefer, data.CreateByBranch, data.CreateBy, orderByFlag)); }
public static bool CheckTicketIdPrivilege(string ticketId, string username, string recursiveList, string teamRecursiveList, string staffTypeId) { SearchLeadCondition condition = new SearchLeadCondition(); condition.TicketId = ticketId; List <SearchLeadData> list = SearchLeadDal.SearchLeadData(condition, username, recursiveList, teamRecursiveList, staffTypeId); return(list.Count > 0 ? true : false); }
private SearchLeadCondition GetSearchCondition() { SearchLeadCondition data = new SearchLeadCondition(); data.TicketId = txtTicketID.Text.Trim(); data.Firstname = txtFirstname.Text.Trim(); data.Lastname = txtLastname.Text.Trim(); data.CardType = cmbCardType.Items.Count > 0 ? cmbCardType.SelectedItem.Value : string.Empty; //ประเภทบุคคล data.CitizenId = txtCitizenId.Text.Trim(); data.CampaignId = cmbCampaign.SelectedItem.Value; data.ChannelId = cmbChannel.SelectedItem.Value; data.OwnerUsername = cmbOwnerLeadSearch.Items.Count > 0 ? cmbOwnerLeadSearch.SelectedItem.Value : string.Empty; //Owner Lead data.OwnerBranch = cmbOwnerBranchSearch.Items.Count > 0 ? cmbOwnerBranchSearch.SelectedItem.Value : string.Empty; //Owner Branch data.DelegateBranch = cmbDelegateBranchSearch.Items.Count > 0 ? cmbDelegateBranchSearch.SelectedItem.Value : string.Empty; //Delegate Branch data.DelegateLead = cmbDelegateLeadSearch.Items.Count > 0 ? cmbDelegateLeadSearch.SelectedItem.Value : string.Empty; //Delegate Lead data.CreateByBranch = cmbCreatebyBranchSearch.Items.Count > 0 ? cmbCreatebyBranchSearch.SelectedItem.Value : string.Empty; //CreateBy Branch data.CreateBy = cmbCreatebySearch.Items.Count > 0 ? cmbCreatebySearch.SelectedItem.Value : string.Empty; //CreateBy data.CreatedDate = tdmCreateDate.DateValue; data.AssignedDate = tdmAssignDate.DateValue; data.StatusList = GetStatusList(); data.PageIndex = pcTop.SelectedPageIndex > -1 ? pcTop.SelectedPageIndex : 0; data.PageSize = SLMConstant.GridviewPageSize; data.SortExpression = SortExpressionProperty; data.SortDirection = SortDirectionProperty.ToString(); data.AdvancedSearch = txtAdvanceSearch.Text.Trim() == "Y" ? true : false; data.ContractNoRefer = txtContractNoRefer.Text.Trim(); data.ScreenCode = "SLM_SCR_003"; //2016-12-26 --> SR:5905-123 data.SubStatus = txtSubStatus.Text.Trim(); data.ChangeStatusDate = tdmChangeStatusDate.DateValue; //Login Staff Info data.StaffType = txtStaffTypeId.Text.Trim() != "" ? (decimal?)decimal.Parse(txtStaffTypeId.Text.Trim()) : null; data.StaffBranchCode = txtStaffBranchCode.Text.Trim(); return(data); }
private void SetSearchCondition(SearchLeadCondition conn) { bool dosearch = false; try { if (!string.IsNullOrEmpty(conn.TicketId)) { txtTicketID.Text = conn.TicketId; dosearch = true; } if (!string.IsNullOrEmpty(conn.Firstname)) { txtFirstname.Text = conn.Firstname; dosearch = true; } if (!string.IsNullOrEmpty(conn.Lastname)) { txtLastname.Text = conn.Lastname; dosearch = true; } if (!string.IsNullOrEmpty(conn.CardType)) { cmbCardType.SelectedIndex = cmbCardType.Items.IndexOf(cmbCardType.Items.FindByValue(conn.CardType)); dosearch = true; } if (!string.IsNullOrEmpty(conn.CitizenId)) { txtCitizenId.Text = conn.CitizenId; dosearch = true; } if (!string.IsNullOrEmpty(conn.CampaignId)) { cmbCampaign.SelectedIndex = cmbCampaign.Items.IndexOf(cmbCampaign.Items.FindByValue(conn.CampaignId)); //GetOwnerLead(cmbCampaign.SelectedItem.Value); dosearch = true; } if (!string.IsNullOrEmpty(conn.ChannelId)) { cmbChannel.SelectedIndex = cmbChannel.Items.IndexOf(cmbChannel.Items.FindByValue(conn.ChannelId)); dosearch = true; } if (!string.IsNullOrEmpty(conn.ContractNoRefer)) { txtContractNoRefer.Text = conn.ContractNoRefer; dosearch = true; } if (!string.IsNullOrEmpty(conn.OwnerBranch)) { cmbOwnerBranchSearch.SelectedIndex = cmbOwnerBranchSearch.Items.IndexOf(cmbOwnerBranchSearch.Items.FindByValue(conn.OwnerBranch)); BindOwnerLead(); dosearch = true; } if (!string.IsNullOrEmpty(conn.OwnerUsername)) { cmbOwnerLeadSearch.SelectedIndex = cmbOwnerLeadSearch.Items.IndexOf(cmbOwnerLeadSearch.Items.FindByValue(conn.OwnerUsername)); dosearch = true; } if (!string.IsNullOrEmpty(conn.DelegateBranch)) { cmbDelegateBranchSearch.SelectedIndex = cmbDelegateBranchSearch.Items.IndexOf(cmbDelegateBranchSearch.Items.FindByValue(conn.DelegateBranch)); BindDelegateLead(); dosearch = true; } if (!string.IsNullOrEmpty(conn.DelegateLead)) { cmbDelegateLeadSearch.SelectedIndex = cmbDelegateLeadSearch.Items.IndexOf(cmbDelegateLeadSearch.Items.FindByValue(conn.DelegateLead)); dosearch = true; } if (!string.IsNullOrEmpty(conn.CreateByBranch)) { cmbCreatebyBranchSearch.SelectedIndex = cmbCreatebyBranchSearch.Items.IndexOf(cmbCreatebyBranchSearch.Items.FindByValue(conn.CreateByBranch)); BindCreateByLead(); dosearch = true; } if (!string.IsNullOrEmpty(conn.CreateBy)) { cmbCreatebySearch.SelectedIndex = cmbCreatebySearch.Items.IndexOf(cmbCreatebySearch.Items.FindByValue(conn.CreateBy)); dosearch = true; } if (conn.CreatedDate.Year != 1) { tdmCreateDate.DateValue = conn.CreatedDate; dosearch = true; } if (conn.AssignedDate.Year != 1) { tdmAssignDate.DateValue = conn.AssignedDate; dosearch = true; } //2016-12-26 --> SR:5905-123 if (conn.ChangeStatusDate.Year != 1) { tdmChangeStatusDate.DateValue = conn.ChangeStatusDate; dosearch = true; } if (!string.IsNullOrEmpty(conn.SubStatus)) { txtSubStatus.Text = conn.SubStatus; dosearch = true; } foreach (ListItem lst in cbOptionList.Items) { lst.Selected = false; } if (!string.IsNullOrEmpty(conn.StatusList)) { string[] vals = conn.StatusList.Split(','); foreach (string val in vals) { ListItem lst = cbOptionList.Items.FindByValue(val.Replace("'", "")); if (lst != null) { lst.Selected = true; } dosearch = true; } } CheckAllCondition(); if (conn.AdvancedSearch) { lbAdvanceSearch.Text = "[-] <b>Advance Search</b>"; pnAdvanceSearch.Style["display"] = "block"; txtAdvanceSearch.Text = "Y"; } else { lbAdvanceSearch.Text = "[+] <b>Advance Search</b>"; pnAdvanceSearch.Style["display"] = "none"; txtAdvanceSearch.Text = "N"; } SortExpressionProperty = conn.SortExpression; SortDirectionProperty = conn.SortDirection == SortDirection.Ascending.ToString() ? SortDirection.Ascending : SortDirection.Descending; if (dosearch) { DoSearchLeadData(conn.PageIndex, SortExpressionProperty, SortDirectionProperty); } } catch { throw; } }
public static List <SearchLeadData> SearchLeadData(SearchLeadCondition data, string username, string recursiveList, string teamRecursiveList, string staffTypeId) { return(SearchLeadDal.SearchLeadData(data, username, recursiveList, teamRecursiveList, staffTypeId)); }