public void GenerateMaterialMasterTestData(int Records)
{
EasyMig.Utility.SampleCustomerRepository repository = new SampleCustomerRepository();
// to get sample data
var materialmasters = repository.GetMaterialMaster(Records);
//Create datatable
DataTable dt2 = CreateDataTableMaterialMaster(materialmasters);
//export data to excel file
string fileName = ExportToExcel(dt2);
SaveFile(fileName);
}
public void GenerateTestData(Int32 noOfRecords)
{
EasyMig.Utility.SampleCustomerRepository repository = new SampleCustomerRepository();
// to get sample data
var customers = repository.GetCustomers(noOfRecords);
//Create datatable
DataTable dt = CreateDataTable(customers);
//export data to excel file
string fileName = ExportToExcel(dt);
SaveFile(fileName);
}
public void GenerateMaterialSalesTestData(int Plantrecords)
{
EasyMig.Utility.SampleCustomerRepository repository = new SampleCustomerRepository();
// to get sample data
var materialsales = repository.GetMaterialSales(Plantrecords);
// var m = GeneratePlantData(materialplant);
//Create datatable
DataTable dt7 = CreateDataTableMaterialSales(materialsales);
//export data to excel file
string fileName = ExportToExcel(dt7);
SaveFile(fileName);
}
//material Plant
public List <Models.MaterialPlant> GenerateMaterialPlantTestData(int Plantrecords)
{
EasyMig.Utility.SampleCustomerRepository repository = new SampleCustomerRepository();
// to get sample data
var materialplant = repository.GetMaterialPlant(Plantrecords);
// var m = GeneratePlantData(materialplant);
//Create datatable
DataTable dt4 = CreateDataTableMaterialPlant(materialplant);
//export data to excel file
string fileName = ExportToExcel(dt4);
SaveFile(fileName);
return(materialplant.ToList());
}
////material sales list
//public List<MaterialSales> GenerateSalesData(IEnumerable<MaterialSales> materialsales)
//{
// List<MaterialSales> materialSales = new List<MaterialSales>();
// DataSet dt7 = new DataSet();
// return materialSales;
//}
////material sales
//List<int> sales_org = new List<int> { 1000, 1020, 2000, 3000, 3020, 7500};
//List<int> dist_channel = new List<int> { 10, 20, 12, 10, 30, 10};
//public DataTable CreateDataTableMaterialSales(IEnumerable<MaterialSales> materialsales)
//{
// DataRow dr7;
// //DataTable distinctTable = dt.DefaultView.ToTable( /*distinct*/ true);
// int rn = 0;
// DataTable dt7 = new DataTable("MaterialSales");
// dt7.Columns.Add("MaterialNo", typeof(Int64));
// dt7.Columns.Add("Sales_Org", typeof(Int64));
// dt7.Columns.Add("Dist_Channel", typeof(Int64));
// Int64 matNo = 1100000037;
// // Int64 plantNo = 1000;
// Int32 sameNoCount = 0;
// rn = RandomNumber(1, 6);
// for (int i = 1; i <= 20; i++)
// {
// int rns = RandomNumber(0, 5);
// dr7 = dt7.NewRow();
// dr7["MaterialNo"] = matNo;
// dr7["Sales_Org"] = sales_org[rns];
// dr7["Dist_Channel"] = dist_channel[rns];
// dt7.Rows.Add(dr7);
// if (sameNoCount == rn)
// {
// matNo++;
// sameNoCount = 0;
// rn = RandomNumber(1, 6);
// }
// sameNoCount++;
// }
// return dt7;
//}
public void GenerateMaterialClassificationTestData(int recorder)
{
EasyMig.Utility.SampleCustomerRepository repository = new SampleCustomerRepository();
// to get sample data
var materialclassification = repository.GetMaterialClassification(recorder);
var m = GenerateClassificationData(materialclassification);
//Create datatable
DataTable dt7 = CreateDataTableMaterialClassification(m);
// var materialPlant = GeneratePlantData(records);
//export data to excel file
string fileName = ExportToExcel(dt7);
SaveFile(fileName);
}