/// <summary>
/// Event fired when Download Inventory Button is triggered.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDownloadProdInventory_Click(object sender, EventArgs e)
{
try
{
DataDownloadAdmin adminAccess = new DataDownloadAdmin();
DataManagerAdmin dataManager = new DataManagerAdmin();
DataSet ds = dataManager.GetProductQuantities(int.Parse(ddlProductType.SelectedValue));
//
if (ddlFileSaveType.SelectedValue == ".xls")
{
// Temp Grid control
GridView gView = new GridView();
gView.DataSource = ds;
gView.DataBind();
ExportDataToExcel("Inventory.xls", gView);
}
else
{
// Set Formatted Data from dataset object
string strData = adminAccess.Export(ds, true);
byte[] data = System.Text.ASCIIEncoding.ASCII.GetBytes(strData);
ExportDataToCSV("Inventory.csv", data);
}
}
catch
{
ltrlError.Text = "Failed to process your request. Please try again.";
}
}
/// <summary>
/// Event fired when Submit button is triggered.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
string dataFilePath = Server.MapPath(ZNode.Libraries.Framework.Business.ZNodeConfigManager.EnvironmentConfig.DataPath);
string filePath = dataFilePath + FileUpload.FileName;
try
{
if (FileUpload.HasFile)
{
// Save the file on the server
FileUpload.PostedFile.SaveAs(filePath);
FileInfo fileinfo = new FileInfo(filePath);
using (FileStream filestr = new FileStream(dataFilePath + "schema.ini",
FileMode.Create, FileAccess.Write))
{
using (StreamWriter writer = new StreamWriter(filestr))
{
writer.WriteLine("[" + fileinfo.Name + "]");
writer.WriteLine("ColNameHeader=True");
writer.WriteLine("MaxScanRows=0");
writer.WriteLine("Format=CSVDelimited");
writer.Close();
writer.Dispose();
}
filestr.Close();
filestr.Dispose();
}
DataManagerAdmin managerAdmin = new DataManagerAdmin();
DataDownloadAdmin dataAdmin = new DataDownloadAdmin();
// Get data table from csv file
DataTable dataTable = dataAdmin.GetDataTable(filePath);
managerAdmin.UploadProducts(dataTable);
// Release all resources
dataTable.Dispose();
}
else
{
ltrlError.Text = "Please select a valid CSV file.";
}
}
catch // Generic exception handler
{
ltrlError.Text = "Failed to process your request. Please try again.";
return;
}
finally
{
// Delete the temporary file
System.IO.File.Delete(filePath);
// Delete the
System.IO.File.Delete(dataFilePath + "schema.ini");
}
Response.Redirect("~/admin/Secure/DataManager/Default.aspx");
}
/// <summary>
/// Event fired when Download Product Button is triggered.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDownloadProduct_Click(object sender, EventArgs e)
{
try
{
DataDownloadAdmin adminAccess = new DataDownloadAdmin();
DataManagerAdmin dataManager = new DataManagerAdmin();
DataSet ds = dataManager.GetProductListByPortalId(ZNode.Libraries.Framework.Business.ZNodeConfigManager.SiteConfig.PortalID);
//
if (ddlFileSaveType.SelectedValue == ".xls")
{
// Temp Grid control
GridView gView = new GridView();
gView.DataSource = ds;
gView.DataBind();
ExportDataToExcel("Product.xls", gView);
}
else
{
// Set Formatted Data from dataset object
string strData = adminAccess.Export(ds, true);
byte[] data = System.Text.ASCIIEncoding.ASCII.GetBytes(strData);
ExportDataToCSV("Product.csv", data);
}
}
catch
{
ltrlError.Text = "Failed to process your request. Please try again.";
}
}
