private void DoBind() { int clientID = 0; clientID = SessionHelper.getClientId(); var predicate = PredicateBuilder.True <CRM.Data.Entities.Leads>(); int userLead = Convert.ToInt32(Session["UserId"]); if (!String.IsNullOrWhiteSpace(hfFromDate.Value)) { DateTime sDate = new DateTime(Convert.ToInt32(hfFromDate.Value.Trim().Substring(6, 4)), Convert.ToInt32(hfFromDate.Value.Trim().Substring(3, 2)), Convert.ToInt32(hfFromDate.Value.Trim().Substring(0, 2))); var datefrom = Convert.ToDateTime(sDate); predicate = predicate.And(Lead => Lead.OriginalLeadDate >= datefrom ); } if (!String.IsNullOrWhiteSpace(hfToDate.Value)) { DateTime sDate = new DateTime(Convert.ToInt32(hfToDate.Value.Trim().Substring(6, 4)), Convert.ToInt32(hfToDate.Value.Trim().Substring(3, 2)), Convert.ToInt32(hfToDate.Value.Trim().Substring(0, 2))); var dateto = Convert.ToDateTime(sDate); predicate = predicate.And(Lead => Lead.OriginalLeadDate <= dateto ); } predicate = predicate.And(Lead => Lead.UserId == userLead); // 2013-10-22 predicate = predicate.And(Lead => Lead.LeadPolicy.Any(x => x.IsActive)); // tortega 2013-08-02 - get lead for client id if ((roleID == (int)UserRole.Client || roleID == (int)UserRole.SiteAdministrator) && clientID > 0) { predicate = predicate.And(Lead => Lead.ClientID == clientID); } objLead = LeadsManager.GetPredicate(predicate); if (objLead != null && objLead.Count > 0) { gvUserLeads.DataSource = objLead; gvUserLeads.DataBind(); } else { gvUserLeads.DataSource = null; gvUserLeads.DataBind(); } bindAllLeads(); // 2013-07-17 bindTasks(); }
public void SortGrid(string expression, bool fromSort, string Grid) { int userLead = Convert.ToInt32(Session["UserId"]); var predicate = PredicateBuilder.True <CRM.Data.Entities.Leads>(); if (!String.IsNullOrWhiteSpace(hfFromDate.Value)) { DateTime sDate = new DateTime(Convert.ToInt32(hfFromDate.Value.Trim().Substring(6, 4)), Convert.ToInt32(hfFromDate.Value.Trim().Substring(3, 2)), Convert.ToInt32(hfFromDate.Value.Trim().Substring(0, 2))); var datefrom = Convert.ToDateTime(sDate); predicate = predicate.And(Lead => Lead.OriginalLeadDate >= datefrom ); } if (!String.IsNullOrWhiteSpace(hfToDate.Value)) { DateTime sDate = new DateTime(Convert.ToInt32(hfToDate.Value.Trim().Substring(6, 4)), Convert.ToInt32(hfToDate.Value.Trim().Substring(3, 2)), Convert.ToInt32(hfToDate.Value.Trim().Substring(0, 2))); var dateto = Convert.ToDateTime(sDate); predicate = predicate.And(Lead => Lead.OriginalLeadDate <= dateto ); } predicate = predicate.And(Lead => Lead.Status != 0); if (Grid == "gvUser") { predicate = predicate.And(Lead => Lead.UserId == userLead); } else { predicate = predicate.And(Lead => Lead.UserId == 0); } var objLead1 = LeadsManager.GetPredicate(predicate).ToList().AsEnumerable(); string sortExpression = expression; string direction = string.Empty; if (fromSort) { if (SortDirection == SortDirection.Ascending) { SortDirection = SortDirection.Descending; } else { SortDirection = SortDirection.Ascending; } } if (SortDirection == SortDirection.Ascending) { if (objLead1 != null) { switch (expression) { case "SecUser.UserName": objLead1 = objLead1.OrderBy(x => x.SecUser != null ? x.SecUser.UserName : "").ToList(); break; case "OriginalLeadDate": objLead1 = objLead1.OrderBy(x => x.OriginalLeadDate).ToList(); break; case "ClaimsNumber": objLead1 = objLead1.OrderBy(x => x.ClaimsNumber).ToList(); break; ////////////////////////////////////// //case "StatusMaster.StatusName": // objLead1 = objLead1.OrderBy(x => x.StatusMaster != null ? x.StatusMaster.StatusName : "").ToList(); // break; //case "SubStatusMaster.SubStatusName": // objLead1 = objLead1.OrderBy(x => x.SubStatusMaster != null ? x.SubStatusMaster.SubStatusName : "").ToList(); // break; case "SiteSurveyDate": objLead1 = objLead1.OrderBy(x => x.SiteSurveyDate).ToList(); break; //case "AllDocumentsOnFile": // objLead1 = objLead1.OrderBy(x => x.AllDocumentsOnFile).ToList(); // break; case "ClaimantFirstName": objLead1 = objLead1.OrderBy(x => x.ClaimantFirstName).ToList(); break; case "ClaimantLastName": objLead1 = objLead1.OrderBy(x => x.ClaimantLastName).ToList(); break; case "CityMaster_1.CityName": objLead1 = objLead1.OrderBy(x => x.CityMaster != null ? x.CityMaster.CityName : "").ToList(); break; case "StateMaster1.StateCode": objLead1 = objLead1.OrderBy(x => x.StateMaster != null ? x.StateMaster.StateCode : "").ToList(); break; case "Zip": objLead1 = objLead1.OrderBy(x => x.Zip).ToList(); break; case "LeadSourceMaster.LeadSourceName": objLead1 = objLead1.OrderBy(x => x.LeadSourceMaster != null ? x.LeadSourceMaster.LeadSourceName : "").ToList(); break; case "TypeOfDamageText": objLead1 = objLead1.OrderBy(x => x.TypeofDamageText).ToList(); break; case "TypeOfPropertyMaster.TypeOfProperty": objLead1 = objLead1.OrderBy(x => x.TypeOfPropertyMaster != null ? x.TypeOfPropertyMaster.TypeOfProperty : "").ToList(); break; } } } else { if (objLead1 != null) { switch (expression) { case "SecUser.UserName": objLead1 = objLead1.OrderByDescending(x => x.SecUser != null ? x.SecUser.UserName : "").ToList(); break; case "OriginalLeadDate": objLead1 = objLead1.OrderByDescending(x => x.OriginalLeadDate).ToList(); break; case "ClaimsNumber": objLead1 = objLead1.OrderByDescending(x => x.ClaimsNumber).ToList(); break; //case "StatusMaster.StatusName": // objLead1 = objLead1.OrderByDescending(x => x.StatusMaster != null ? x.StatusMaster.StatusName : "").ToList(); // break; //case "SubStatusMaster.SubStatusName": // objLead1 = objLead1.OrderByDescending(x => x.SubStatusMaster != null ? x.SubStatusMaster.SubStatusName : "").ToList(); // break; case "SiteSurveyDate": objLead1 = objLead1.OrderByDescending(x => x.SiteSurveyDate).ToList(); break; //case "AllDocumentsOnFile": // objLead1 = objLead1.OrderByDescending(x => x.AllDocumentsOnFile).ToList(); // break; case "ClaimantFirstName": objLead1 = objLead1.OrderByDescending(x => x.ClaimantFirstName).ToList(); break; case "ClaimantLastName": objLead1 = objLead1.OrderByDescending(x => x.ClaimantLastName).ToList(); break; case "CityMaster_1.CityName": objLead1 = objLead1.OrderByDescending(x => x.CityMaster != null ? x.CityMaster.CityName : "").ToList(); break; case "StateMaster1.StateCode": objLead1 = objLead1.OrderByDescending(x => x.StateMaster != null ? x.StateMaster.StateCode : "").ToList(); break; case "Zip": objLead1 = objLead1.OrderByDescending(x => x.Zip).ToList(); break; case "LeadSourceMaster.LeadSourceName": objLead1 = objLead1.OrderByDescending(x => x.LeadSourceMaster != null ? x.LeadSourceMaster.LeadSourceName : "").ToList(); break; case "TypeOfDamageText": objLead1 = objLead1.OrderByDescending(x => x.TypeofDamageText).ToList(); break; case "TypeOfPropertyMaster.TypeOfProperty": objLead1 = objLead1.OrderBy(x => x.TypeOfPropertyMaster != null ? x.TypeOfPropertyMaster.TypeOfProperty : "").ToList(); break; } } } if (Grid == "gvUser") { gvUserLeads.DataSource = objLead1; gvUserLeads.DataBind(); } else { grdAllLead.DataSource = objLead1; grdAllLead.DataBind(); } }
protected void bindReport() { List <Leads> objLead = null; var predicate = PredicateBuilder.True <CRM.Data.Entities.Leads>(); if (Cache["FromDate"] != null && Cache["FromDate"].ToString() != "") { DateTime sDate = new DateTime(Convert.ToInt32(Cache["FromDate"].ToString().Trim().Substring(6, 4)), Convert.ToInt32(Cache["FromDate"].ToString().Trim().Substring(3, 2)), Convert.ToInt32(Cache["FromDate"].ToString().Trim().Substring(0, 2))); var datefrom = Convert.ToDateTime(sDate); predicate = predicate.And(Lead => Lead.DateSubmitted >= datefrom ); } if (Cache["ToDate"] != null && Cache["ToDate"].ToString() != "") { DateTime sDate = new DateTime(Convert.ToInt32(Cache["ToDate"].ToString().Trim().Substring(6, 4)), Convert.ToInt32(Cache["ToDate"].ToString().Trim().Substring(3, 2)), Convert.ToInt32(Cache["ToDate"].ToString().Trim().Substring(0, 2))); var dateto = Convert.ToDateTime(sDate); predicate = predicate.And(Lead => Lead.DateSubmitted <= dateto ); } if (Cache["Criteria"] != null && Cache["Criteria"].ToString() != "") { var user = Cache["Criteria"].ToString(); predicate = predicate.And(Lead => Lead.SecUser.UserName == user); } objLead = LeadsManager.GetPredicate(predicate); List <AllUserLeads> resAllUserLeads = new List <AllUserLeads>(); AllUserLeads objAllUserLeadsGet = null; foreach (var get in objLead) { objAllUserLeadsGet = new AllUserLeads(); objAllUserLeadsGet.LeadId = get.LeadId; objAllUserLeadsGet.UserId = (int)get.UserId; objAllUserLeadsGet.UserName = get.SecUser.UserName; //objAllUserLeadsGet.DateSubmitted = (DateTime?)get.DateSubmitted; objAllUserLeadsGet.DateSubmitted = get.DateSubmitted == null ? "" : Convert.ToDateTime(get.DateSubmitted).ToString("dd/MMM/yy"); objAllUserLeadsGet.LFUUID = get.LFUUID; //objAllUserLeadsGet.OriginalLeadDate = (DateTime)get.OriginalLeadDate; objAllUserLeadsGet.OriginalLeadDate = get.OriginalLeadDate == null ? "" : Convert.ToDateTime(get.OriginalLeadDate).ToString("dd/MMM/yy"); objAllUserLeadsGet.ClaimsNumber = get.ClaimsNumber == null ? 0 : (int)get.ClaimsNumber; //objAllUserLeadsGet.ClaimantName = get.ClaimantName; objAllUserLeadsGet.ClaimantName = get.ClaimantFirstName + get.ClaimantLastName; //if (get.LeadSourceMaster != null) // objAllUserLeadsGet.LeadStatus = get.LeadSourceMaster.LeadSourceName == null ? "" : get.LeadSourceMaster.LeadSourceName; objAllUserLeadsGet.EmailAddress = get.EmailAddress; //if (get.AdjusterMaster != null) // objAllUserLeadsGet.Adjuster = get.AdjusterMaster.AdjusterName == null ? "" : get.AdjusterMaster.AdjusterName; ////objAllUserLeadsGet.LeadSource = get.LeadSource; if (get.LeadSourceMaster != null) { objAllUserLeadsGet.LeadSource = get.LeadSourceMaster.LeadSourceName == null ? "" : get.LeadSourceMaster.LeadSourceName; } if (get.PrimaryProducerId != null) { objAllUserLeadsGet.PrimaryProducerId = (int)get.PrimaryProducerId; } if (get.ProducerMaster != null) { objAllUserLeadsGet.PrimaryProducerName = get.ProducerMaster.ProducerName; } objAllUserLeadsGet.SecondaryProducerId = (int)(get.SecondaryProducerId ?? 0); //objAllUserLeadsGet.SecondaryProducerName = get.ProducerMaster1.ProducerName; if (get.SecondaryProducerMaster != null) { objAllUserLeadsGet.SecondaryProducerName = get.SecondaryProducerMaster.SecondaryProduceName == null ? "" : get.SecondaryProducerMaster.SecondaryProduceName; } objAllUserLeadsGet.EmailAddress = get.EmailAddress; if (get.InspectorMaster != null) { objAllUserLeadsGet.InspectorName = get.InspectorMaster.InspectorName == null ? "" : get.InspectorMaster.InspectorName; } objAllUserLeadsGet.InspectorCell = get.InspectorCell; objAllUserLeadsGet.InspectorEmail = get.InspectorEmail; objAllUserLeadsGet.PhoneNumber = get.PhoneNumber; //if (get.WebformSourceMaster != null) // objAllUserLeadsGet.WebformSource = get.WebformSourceMaster.WebformSource == null ? "" : get.WebformSourceMaster.WebformSource; objAllUserLeadsGet.ClaimantComments = get.ClaimantComments; //objAllUserLeadsGet.TypeOfDamage = get.TypeOfDamageMaster.TypeOfDamage == null ? "" : get.TypeOfDamageMaster.TypeOfDamage; objAllUserLeadsGet.TypeOfDamage = get.TypeofDamageText == null ? "" : get.TypeofDamageText; //objAllUserLeadsGet.TypeOfProperty = (int)get.TypeOfProperty; //objAllUserLeadsGet.TypeOfProperty = get.TypeOfProperty == 1 ? "Home" : "Hotel"; if (get.TypeOfPropertyMaster != null) { objAllUserLeadsGet.TypeOfProperty = get.TypeOfPropertyMaster.TypeOfProperty == null ? "" : get.TypeOfPropertyMaster.TypeOfProperty; } //objAllUserLeadsGet.ReporterToInsurer = get.ReporterToInsurer == null ? "NO" : get.ReporterToInsurer.ToString() == "Y" ? "YES" : "NO"; if (get.ReportedToInsurerMaster != null) { objAllUserLeadsGet.ReporterToInsurer = get.ReportedToInsurerMaster.ReportedToInsurer == null ? "" : get.ReportedToInsurerMaster.ReportedToInsurer; } resAllUserLeads.Add(objAllUserLeadsGet); } ListtoDataTableConverter converter = new ListtoDataTableConverter(); DataTable dt = converter.ToDataTable(resAllUserLeads); string xmlpath = Request.MapPath("~/Protected/Reports") + "/AllUserLeads.xml"; dt.WriteXml(xmlpath); if (dt != null && dt.Rows.Count > 0) { ReportDocument RptDoc = new ReportDocument(); string ReportFolderPath = System.Configuration.ConfigurationManager.AppSettings["ReportPath"].ToString(); RptDoc.Load(Request.MapPath(ReportFolderPath + "crptAllUserLeads1.rpt")); //CrystalReport1.rpt RptDoc.SetDataSource(dt); CrystalReportViewer1.ReportSource = RptDoc; CrystalReportViewer1.DataBind(); } else { CrystalReportViewer1.ReportSource = null; CrystalReportViewer1.DataBind(); } }