public async Task <Tuple <DataTable, String> > GetProductDownloadData(int companyId, int catalogId)
{
CatalogModel objCatalogModel = new CatalogModel();
objCatalogModel = await GetCompanyCatalog(companyId, catalogId);
DataTable dtAllCatalog = new DataTable();
ListtoDataTableConverter converter = new ListtoDataTableConverter();
foreach (var Product in objCatalogModel.Products)
{
var dty = converter.ToDataTable(Product.ProductItems, Product.Vendor + " " + Product.Name);
dtAllCatalog.Merge(dty);
}
///Removing unwanted Column
if (dtAllCatalog != null)
{
if (dtAllCatalog.Columns.Count > 0)
{
dtAllCatalog = RemoveRenameProductTable(dtAllCatalog);
}
}
return(Tuple.Create(dtAllCatalog, objCatalogModel.Name));
//return dtAllCatalog;
}
public ActionResult Export()
{
ExcelPackage excel = new ExcelPackage();
ApplicationDbContext db = new ApplicationDbContext();
DataTable dt = new DataTable();
ExcelWorksheet ws = excel.Workbook.Worksheets.Add("Demo");
//here you have to add your class like student etc.
List <Firma> firm = db.Firms.ToList <Firma>();
ListtoDataTableConverter converter = new ListtoDataTableConverter();
dt = converter.ToDataTable(firm);
ws.Cells["A1"].LoadFromDataTable(dt, true, TableStyles.Medium15);
ws.Cells.AutoFitColumns();
using (var memoryStream = new MemoryStream())
{
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment; filename=ExportTest" + excel + ".xlsx");
excel.SaveAs(memoryStream);
memoryStream.WriteTo(Response.OutputStream);
Response.Flush();
Response.End();
}
return(RedirectToAction("ViewFirms", "Firme"));
}
public int Save(MonthlyTransactionInsert monthlyTransaction)
{
DataTable inputTable = ListtoDataTableConverter.ToDataTable(monthlyTransaction.MonthlyTransactions);
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertMonthlyTransaction";
cmd.Parameters.AddWithValue("@MonthlyTransaction", inputTable);
cmd.Parameters.AddWithValue("@KamethiNumber", monthlyTransaction.KamethiNumber);
cmd.Parameters.AddWithValue("@HostId", monthlyTransaction.HostId);
cmd.Parameters.AddWithValue("@TotalTakenAmount", monthlyTransaction.TotalTakenAmount);
cmd.Parameters.AddWithValue("@TotalDepositAmount", monthlyTransaction.TotalDepositeAmount);
cmd.Parameters.AddWithValue("@RemainingBalance", monthlyTransaction.TotalBalanceAmount);
return(Execute(cmd, ConfigurationHelper.ConnectionString));
}
}
public JsonResult CreateUserRegistraion(UserModel objUserModel)
{
List <UserModel> UserRegistrationlist = new List <UserModel>();
UserRegistrationlist.Add(objUserModel);
ListtoDataTableConverter converter = new ListtoDataTableConverter();
DataTable dt = new DataTable();
dt = converter.ToDataTable(UserRegistrationlist);
Account mm = new Account();
string res = "";
try
{
res = loginLayer.CreateUserRegistration(dt);
string[] response = res.Split(',');
if (response[0] == "Success")
{
mm.SuccessMsg = response[1];
}
else if (response[0] == "Error")
{
mm.ErrorMsg = response[1];
}
}
catch (Exception ex)
{
mm.ErrorMsg = ex.Message;
}
return(Json(mm, JsonRequestBehavior.AllowGet));
}
public JsonResult CreateMasterSetting(MasterSettingModel objSettingModel)
{
List <MasterSettingModel> MasterSettingModellist = new List <MasterSettingModel>();
MasterSettingModellist.Add(objSettingModel);
ListtoDataTableConverter converter = new ListtoDataTableConverter();
DataTable dt = new DataTable();
dt = converter.ToDataTable(MasterSettingModellist);
homeModel hm = new homeModel();
string res = "";
try
{
res = admin_layer.CreateMasterSetting(dt);
string[] response = res.Split(',');
if (response[0] == "Success")
{
hm.SuccessMsg = response[1];
}
else if (response[0] == "Error")
{
hm.ErrorMsg = response[1];
}
}
catch (Exception ex)
{
hm.ErrorMsg = ex.Message;
}
return(Json(hm, JsonRequestBehavior.AllowGet));
}
public JsonResult save_hierarchy(string TableData)
{
successFailureModel sm = new successFailureModel();
try
{
var serializeData = JsonConvert.DeserializeObject <List <HierarchyModel> >(TableData);
ListtoDataTableConverter converter = new ListtoDataTableConverter();
DataTable dt = converter.ToDataTable(serializeData);
string res = dblayer.save_hierarchy(dt);
string[] response = res.Split(',');
if (response[0] == "Success")
{
sm.SuccessMsg = response[1];
}
else
{
sm.ErrorMsg = response[1];
}
}
catch (Exception ex)
{
sm.ErrorMsg = ex.Message;
}
return(Json(sm, JsonRequestBehavior.AllowGet));
}
private void LoadGridTable()
{
List <Users> users = usersService.GetUsers();
dataTable = converter.ToDataTable(users, dataTable);
grdvCrudOperation.DataSource = dataTable;
grdvCrudOperation.DataBind();
}
private void LoadGridTable()
{
List <UOM> uom = UomService.GetUOMs();
dataTable = converter.ToDataTable(uom, dataTable);
grdvCrudOperation.DataSource = dataTable;
grdvCrudOperation.DataBind();
}
private void LoadGridTable()
{
List <Department> departments = department.GetDepartment();
dataTable = converter.ToDataTable(departments, dataTable);
grdvCrudOperation.DataSource = dataTable;
grdvCrudOperation.DataBind();
}
private void LoadGridTable()
{
List <Location> locations = location.GetLocation();
dataTable = converter.ToDataTable(locations, dataTable);
grdvCrudOperation.DataSource = dataTable;
grdvCrudOperation.DataBind();
}
private void btnView_Click(object sender, EventArgs e)
{
reportViewerStudentAdmission.RefreshReport();
List <StudentPersonalInfo> studentpersoninfos = StudentPersonalInfoController.StudentPersonalInfoSelectAll();
ListtoDataTableConverter converter = new ListtoDataTableConverter();
DataTable dt = converter.ToDataTable(studentpersoninfos);
DataSet studentDataSet_PersonalInfo = new DataSet();
studentDataSet_PersonalInfo.Tables.Add(dt);
}
public string Create_Expense(int EMP_ID, ExpenseEntities EXP, List <ExpenseFiles> files)
{
string response = "";
ListtoDataTableConverter converter = new ListtoDataTableConverter();
try
{
DataTable dt_files = new DataTable();
if (files != null)
{
dt_files = converter.ToDataTable(files);
}
else
{
dt_files.Columns.Add("file_name");
}
connection();
using (SqlCommand cmd = new SqlCommand("Prc_InsertExpense", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", EXP.EXPENSE_ID);
cmd.Parameters.AddWithValue("@EXPENSE_CODE", EXP.EXPENSE_CODE);
cmd.Parameters.AddWithValue("@EMP_ID", EMP_ID);
cmd.Parameters.AddWithValue("@EXPENSE_TYPE_ID", EXP.EXPENSE_TYPE_ID);
cmd.Parameters.AddWithValue("@EXPENSE_DATE", EXP.EXPENSE_DATE);
cmd.Parameters.AddWithValue("@PROJECT_ID", EXP.PROJECT_ID);
cmd.Parameters.AddWithValue("@TRAVEL_FROM", EXP.TRAVEL_FROM);
cmd.Parameters.AddWithValue("@TRAVEL_TO", EXP.TRAVEL_TO);
cmd.Parameters.AddWithValue("@TRAVEL_DISTANCE", EXP.TRAVEL_DISTANCE);
cmd.Parameters.AddWithValue("@TRAVEL_MODE_ID", EXP.TRAVEL_MODE);
cmd.Parameters.AddWithValue("@EXPENSE_AMT", EXP.EXPENSE_AMOUNT);
cmd.Parameters.AddWithValue("@DESCRIPTION", EXP.DESCRIPTION);
cmd.Parameters.AddWithValue("@files_tbl", dt_files);
SqlParameter outData = new SqlParameter();
outData.ParameterName = "@MESSAGE";
outData.SqlDbType = SqlDbType.NVarChar;
outData.Size = 250;
outData.Direction = ParameterDirection.Output;
cmd.Parameters.Add(outData);
con.Open();
cmd.ExecuteNonQuery();
response = Convert.ToString(outData.Value);
con.Close();
}
}
catch (Exception ex)
{
response = ex.Message;
}
return(response);
}
public JsonResult CreateAnnualAppraisal(AnnualAppraisalModel objResponsibility, AppraisalPerformanceModel objPerformance, AppraisalRating objRating)
{
List <AnnualAppraisalModel> AnnualResponsibilitylist = new List <AnnualAppraisalModel>();
AnnualResponsibilitylist.Add(objResponsibility);
ListtoDataTableConverter converter = new ListtoDataTableConverter();
DataTable dt = new DataTable();
dt = converter.ToDataTable(AnnualResponsibilitylist);
List <AppraisalPerformanceModel> AnnualPerformanceList = new List <AppraisalPerformanceModel>();
AnnualPerformanceList.Add(objPerformance);
ListtoDataTableConverter PerformanceConverter = new ListtoDataTableConverter();
DataTable dt1 = new DataTable();
dt1 = PerformanceConverter.ToDataTable(AnnualPerformanceList);
List <AppraisalRating> RatingList = new List <AppraisalRating>();
RatingList.Add(objRating);
ListtoDataTableConverter RatingConverter = new ListtoDataTableConverter();
DataTable dt2 = new DataTable();
dt2 = RatingConverter.ToDataTable(RatingList);
MastersModel mm = new MastersModel();
string res = "";
try
{
res = ap_layer.CreateAnnualAppraisal(dt, dt1, dt2);
string[] response = res.Split(',');
if (response[0] == "Success")
{
mm.SuccessMsg = response[1];
}
else if (response[0] == "Error")
{
mm.ErrorMsg = response[1];
}
}
catch (Exception ex)
{
mm.ErrorMsg = ex.Message;
}
return(Json(mm, JsonRequestBehavior.AllowGet));
}
private void txt_SearchCatalogue_TextChanged(object sender, EventArgs e)
{
UserBL UserBL = new UserBL();
List<DO.User> ListUser = UserBL.GetUser();
ListtoDataTableConverter converter = new ListtoDataTableConverter();
DataTable dt = converter.ToDataTable(ListUser);
dgv_UserManagement.DataSource = dt;
dt.DefaultView.RowFilter = string.Format("UserName LIKE '%{0}%' or Sequence LIKE '%{0}%'", txt_SearchCatalogue.Text);
dgv_UserManagement.Columns["UserID"].Visible = false;
dgv_UserManagement.Columns["PassWord"].Visible = false;
dgv_UserManagement.Columns["Role"].Visible = false;
dgv_UserManagement.Columns["Sequence"].HeaderText = "STT";
dgv_UserManagement.Columns["UserName"].HeaderText = "Tên Tài khoản";
dgv_UserManagement.Columns["Sequence"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
}
public string CreateBulkCustomer(List <CustomerEntities> tempCustomer)
{
//List<CustomerEntities> custlist = new List<CustomerEntities>();
//custlist.Add(tempCustomer);
ListtoDataTableConverter converter = new ListtoDataTableConverter();
DataTable dt = new DataTable();
dt = converter.ToDataTable(tempCustomer);
string res = "";
try
{
connection();
using (SqlCommand cmd = new SqlCommand("spInsertMST_CUSTOMERBYTableType", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MST_CUSTOMERTableType", dt);
SqlParameter oblogin = new SqlParameter();
oblogin.ParameterName = "@message";
oblogin.SqlDbType = SqlDbType.NVarChar;
oblogin.Size = 50;
oblogin.Direction = ParameterDirection.Output;
cmd.Parameters.Add(oblogin);
con.Open();
cmd.ExecuteNonQuery();
res = Convert.ToString(oblogin.Value);
con.Close();
return(res);
}
}
catch (Exception ex)
{
res = ex.Message;
}
return(res);
}
public void Export <T>(List <T> items)
{
var dt = ListtoDataTableConverter.ToDataTable(items);
ExcelHelper.Export(dt, _filePath);
}
private void txt_SearchCatalogue_TextChanged(object sender, EventArgs e)
{
//QuestionBL questionBL = new QuestionBL();
//List<DO.Question> ListQuestion = questionBL.GetQuestion();
QuestionBL QuestionBL = new QuestionBL();
Catalogue Cat = new Catalogue();
Cat.IDCatalogue = IDCat;
List<DO.Question> QuestionList;
QuestionList = QuestionBL.GetQuestionByCatalogue(Cat);
//if (QuestionList != null)
//dgv_Question1.DataSource = QuestionList;
//loadQuestion();
ListtoDataTableConverter converter = new ListtoDataTableConverter();
DataTable dt = converter.ToDataTable(QuestionList);
dgv_Question1.DataSource = dt;
dt.DefaultView.RowFilter = string.Format("NameQuestion LIKE '%{0}%' or TypeQuestion LIKE '%{0}%' or NameCatalogue LIKE '%{0}%' or QuestionTitle LIKE '%{0}%'or Sequence LIKE '%{0}%'", txt_SearchCatalogue.Text);
dgv_Question1.Columns["IDCatalogue"].Visible = false;
dgv_Question1.Columns["IDQuestion"].Visible = false;
dgv_Question1.Columns["IDCatalogue"].Visible = false;
dgv_Question1.Columns["AnswerContent"].Visible = false;
dgv_Question1.Columns["AnswerList"].Visible = false;
dgv_Question1.Columns["Date"].Visible = false;
dgv_Question1.Columns["Sequence"].HeaderText = "STT";
dgv_Question1.Columns["NameQuestion"].HeaderText = "Tên Câu Hỏi";
dgv_Question1.Columns["NameCatalogue"].HeaderText = "Tên chủ Đề";
dgv_Question1.Columns["TypeQuestion"].HeaderText = "Loại Câu hỏi";
dgv_Question1.Columns["Sequence"].ReadOnly = true;
dgv_Question1.Columns["NameQuestion"].ReadOnly = false;
dgv_Question1.Columns["NameCatalogue"].ReadOnly = true;
dgv_Question1.Columns["TypeQuestion"].ReadOnly = true;
dgv_Question1.Columns["Sequence"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgv_Question1.Columns["NameCatalogue"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgv_Question1.Columns["TypeQuestion"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
}
public JsonResult CreateTranExit(TranExitModel objTranExitModel, TranExitDissatisfactionModel objDissatisfaction, TranExitAnotherJobModel objAnotherJob, TRANEXITFORMSUPERVISORModel objSupervisor, TRANEXITFORMORGANIZATIONASPECTSModel objOrganization, TRANEXITFORMJOBASPECTSModel objJobAspect)
{
//TRANEXITFORMSUPERVISORModel objSupervisor, TRANEXITFORMORGANIZATIONASPECTSModel objOrganization, TRANEXITFORMJOBASPECTSModel objJobAspect
List <TranExitModel> TranExitlist = new List <TranExitModel>();
TranExitlist.Add(objTranExitModel);
ListtoDataTableConverter converter = new ListtoDataTableConverter();
DataTable dt = new DataTable();
dt = converter.ToDataTable(TranExitlist);
List <TranExitDissatisfactionModel> DissatisfactionList = new List <TranExitDissatisfactionModel>();
DissatisfactionList.Add(objDissatisfaction);
ListtoDataTableConverter disstatisfactionConverter = new ListtoDataTableConverter();
DataTable dt1 = new DataTable();
dt1 = disstatisfactionConverter.ToDataTable(DissatisfactionList);
List <TranExitAnotherJobModel> AnotherJobList = new List <TranExitAnotherJobModel>();
AnotherJobList.Add(objAnotherJob);
ListtoDataTableConverter anotherjobConverter = new ListtoDataTableConverter();
DataTable dt2 = new DataTable();
dt2 = anotherjobConverter.ToDataTable(AnotherJobList);
List <TRANEXITFORMSUPERVISORModel> SupervisorList = new List <TRANEXITFORMSUPERVISORModel>();
SupervisorList.Add(objSupervisor);
ListtoDataTableConverter SupervisorConverter = new ListtoDataTableConverter();
DataTable dt3 = new DataTable();
dt3 = SupervisorConverter.ToDataTable(SupervisorList);
List <TRANEXITFORMORGANIZATIONASPECTSModel> OrganizationList = new List <TRANEXITFORMORGANIZATIONASPECTSModel>();
OrganizationList.Add(objOrganization);
ListtoDataTableConverter OrgConverter = new ListtoDataTableConverter();
DataTable dt4 = new DataTable();
dt4 = OrgConverter.ToDataTable(OrganizationList);
List <TRANEXITFORMJOBASPECTSModel> JobAspectList = new List <TRANEXITFORMJOBASPECTSModel>();
JobAspectList.Add(objJobAspect);
ListtoDataTableConverter JobAspectConverter = new ListtoDataTableConverter();
DataTable dt5 = new DataTable();
dt5 = JobAspectConverter.ToDataTable(JobAspectList);
MastersModel mm = new MastersModel();
string res = "";
try
{
res = tedb_layer.CreateTranExit(dt, dt1, dt2, dt3, dt4, dt5);
//objTranExitModel, objDissatisfaction, objAnotherJob
string[] response = res.Split(',');
if (response[0] == "Success")
{
mm.SuccessMsg = response[1];
}
else if (response[0] == "Error")
{
mm.ErrorMsg = response[1];
}
GetExit_id();
}
catch (Exception ex)
{
mm.ErrorMsg = ex.Message;
}
return(Json(mm, JsonRequestBehavior.AllowGet));
}
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();
}
}