/// <summary>
/// Order ListItem Buttton Click Event
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButOrderLineItemsDownload_Click(object sender, EventArgs e)
{
DataDownloadAdmin csv = new DataDownloadAdmin();
OrderAdmin _OrderAdmin = new OrderAdmin();
string Orderid = Convert.ToString(OrderNumber.Text);
DataSet OrderLineItems = _OrderAdmin.GetOrderLineItemsByOrderId(Orderid);
if (OrderLineItems.Tables[0].Rows.Count > 0)
{
string strData = csv.Export(OrderLineItems, true, tabDelimeter);
byte[] data = ASCIIEncoding.ASCII.GetBytes(strData);
Response.Clear();
// Set as Excel as the primary format
Response.AddHeader("Content-Type", "application/Excel");
Response.AddHeader("Content-Disposition", "attachment;filename=OrderLineItems.csv");
Response.ContentType = "application/vnd.xls";
Response.BinaryWrite(data);
Response.End();
}
else
{
ltrlError.Text = "* No Orders to download";
return;
}
}
protected void download_Click(object sender, EventArgs e)
{
DataDownloadAdmin _DataDownloadAdmin = new DataDownloadAdmin();
CustomerHelper HelperAccess = new CustomerHelper();
DataSet _dataset = new DataSet();
//Check for Search enabled
if(CheckSearch)
{
if(Session["ContactList"]!=null)
_dataset = Session["ContactList"] as DataSet;
}
else
{
_dataset = HelperAccess.SearchCustomer(String.Empty, String.Empty, String.Empty, String.Empty, String.Empty, String.Empty, String.Empty, String.Empty, String.Empty, String.Empty, "0",String.Empty);
}
string StrData = _DataDownloadAdmin.Export(_dataset, true);
byte[] data = ASCIIEncoding.ASCII.GetBytes(StrData);
//Release Resources
_dataset.Dispose();
Response.Clear();
// Set as Excel as the primary format
Response.AddHeader("Content-Type", "application/Excel");
Response.AddHeader("Content-Disposition", "attachment;filename=Customer.csv");
Response.ContentType = "application/vnd.xls";
Response.BinaryWrite(data);
Response.End();
}
/// <summary>
/// Submit Button Click Event
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
DataDownloadAdmin adminAccess = new DataDownloadAdmin();
try
{
DataSet ds = BindAttributeData();
if (ds.Tables[0].Rows.Count != 0)
{
// Save as Excel Sheet
if (ddlFileSaveType.SelectedValue == ".xls")
{
// Temp Grid control
GridView gView = new GridView();
gView.DataSource = ds;
gView.DataBind();
ExportDataToExcel("Attributes.xls", gView);
}
else // Save as CSV Format
{
// Set Formatted Data from dataset object
string strData = adminAccess.Export(ds, true);
byte[] data = System.Text.ASCIIEncoding.ASCII.GetBytes(strData);
ExportDataToCSV("Attributes.csv", data);
}
}
else
{
ltrlError.Text = "No Sku Found";
return;
}
}
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 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 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.";
}
}
