/// <summary>
/// Get Order details click event
/// </summary>
protected void btnOrderFilter_Click(object sender, EventArgs e)
{
objReportViewer.Visible = true;
Mode = "271";
//Get Filetered Orders in DataSet
OrderAdmin _OrderAdmin = new OrderAdmin();
dsOrders = _OrderAdmin.ReportList(Mode, Year, ddlSupplier.SelectedValue);
dsOrdersLineItems = _OrderAdmin.GetAllOrderLineItems().ToDataSet(false);
DataView dv = new DataView(dsOrders.Tables[0]);
DataView dv1 = new DataView();
dsOrders = _OrderAdmin.ReportList(Mode, Year,ddlSupplier.SelectedValue);
dv = new DataView(dsOrders.Tables[0]);
DateTime StartDate = DateTime.Parse(txtStartDate.Text.Trim());
DateTime EndDate = DateTime.Parse(txtEndDate.Text.Trim());
dv.RowFilter = "orderdate >= '" + StartDate + "' and orderdate <= '" + EndDate.AddDays(1) + "'";
if (dv.ToTable().Rows.Count == 0)
{
lblErrorMsg.Text = "No records found";
objReportViewer.Visible = false;
return;
}
objReportViewer.LocalReport.DataSources.Clear();
ReportParameter param1 = new ReportParameter("CurrentLanguage", System.Globalization.CultureInfo.CurrentCulture.Name);
objReportViewer.LocalReport.SetParameters(new ReportParameter[] { param1 });
this.objReportViewer.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeOrderDataSet_ZNodeOrder", dv));
objReportViewer.LocalReport.Refresh();
}
protected void BindOrderStatus()
{
OrderAdmin orderAdmin = new OrderAdmin();
ddlOrderStateList.DataSource = orderAdmin.GetAllOrderStates();
ddlOrderStateList.DataTextField = "OrderStateName";
ddlOrderStateList.DataValueField = "OrderStateID";
ddlOrderStateList.DataBind();
}
protected void btnOrderFilter_Click(object sender, EventArgs e)
{
objReportViewer.Visible = true;
if (Request.Params["filter"] != null)
{
Mode = Request.Params["filter"];
}
//Get Filetered Orders in DataSet
OrderAdmin _OrderAdmin = new OrderAdmin();
DataView dv = new DataView();
if (dsOrders.Tables.Count == 0)
{
Mode = "25";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/TaxReport.rdlc";
dv = new DataView(dsOrders.Tables[0]);
DateTime StartDate = DateTime.Parse(txtStartDate.Text.Trim());
DateTime EndDate = DateTime.Parse(txtEndDate.Text.Trim());
dv.RowFilter = "orderdate >= '" + StartDate + "' and orderdate <= '" + EndDate.AddDays(1) + "'";
if (dv.Count == 0)
{
lblErrorMsg.Text = "No records found";
objReportViewer.Visible = false;
return;
}
objReportViewer.LocalReport.DataSources.Clear();
ReportParameter param1 = new ReportParameter("CurrentLanguage", System.Globalization.CultureInfo.CurrentCulture.Name);
objReportViewer.LocalReport.SetParameters(new ReportParameter[] { param1 });
this.objReportViewer.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeOrderDataSet_ZNodeOrder", dv));
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeTitleDataSet_ZNodeTitle", dv));
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/TaxReportMonth.rdlc";
string asas = this.objReportViewer.LocalReport.ReportPath;
objReportViewer.LocalReport.Refresh();
}
protected void btnOrderFilter_Click(object sender, EventArgs e)
{
objReportViewer.Visible = true;
DateTime StartDate = DateTime.MinValue;
//Get Filetered Orders in DataSet
OrderAdmin _OrderAdmin = new OrderAdmin();
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
DataView dv = new DataView(dsOrders.Tables[0]);
if (txtStartDate.Text.Length > 0)
StartDate = DateTime.Parse(txtStartDate.Text.Trim());
string Status = ddlLogCategory.SelectedItem.Text;
if (Status == "ALL" && txtStartDate.Text.Length > 0)
{
dv.RowFilter = "createDte >= '" + StartDate + "'";
}
else if(Status != "ALL" && txtStartDate.Text.Length > 0)
{
dv.RowFilter = "createDte >= '" + StartDate + "' and category = '" + Status + "'";
}
else if(Status != "ALL")
{
dv.RowFilter = "category = '" + Status + "'";
}
if (dv.ToTable().Rows.Count == 0)
{
lblErrorMsg.Text = "No records found";
objReportViewer.Visible = false;
return;
}
objReportViewer.LocalReport.DataSources.Clear();
ReportParameter param1 = new ReportParameter("CurrentLanguage", System.Globalization.CultureInfo.CurrentCulture.Name);
objReportViewer.LocalReport.SetParameters(new ReportParameter[] { param1 });
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZnodeActivityLog_ZnodeActivityLog", dv));
}
/// <summary>
/// Page Load Event
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Request.Params["filter"] != null)
{
Mode = Request.Params["filter"];
}
//Bind Supplier
SupplierAdmin supplier = new SupplierAdmin();
ddlSupplier.DataSource = supplier.GetAll();
ddlSupplier.DataTextField = "name";
ddlSupplier.DataValueField = "supplierid";
ddlSupplier.DataBind();
ListItem li1 = new ListItem("None", "0");
ddlSupplier.Items.Insert(0, li1);
//Get Filetered Orders in DataSet
OrderAdmin _OrderAdmin = new OrderAdmin();
DataView dv = new DataView();
dsOrders = _OrderAdmin.ReportList(Mode, Year,"");
dsOrdersLineItems = _OrderAdmin.GetAllOrderLineItems().ToDataSet(false);
dv = new DataView(dsOrders.Tables[0]);
if (Request.Params["filter"] != null)
{
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/SupplierReport.rdlc";
}
if (dv.ToTable().Rows.Count == 0)
{
lblErrorMsg.Text = "No records found";
objReportViewer.Visible = false;
return;
}
objReportViewer.LocalReport.DataSources.Clear();
ReportParameter param1 = new ReportParameter("CurrentLanguage", System.Globalization.CultureInfo.CurrentCulture.Name);
objReportViewer.LocalReport.SetParameters(new ReportParameter[] { param1 });
this.objReportViewer.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeOrderDataSet_ZNodeOrder", dv));
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeOrderLineItems_ZNodeOrderLineItem", dsOrdersLineItems.Tables[0]));
objReportViewer.LocalReport.Refresh();
}
}
/// <summary>
/// Page Load Event
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Request.Params["filter"] != null)
{
Mode = Request.Params["filter"];
}
OrderAdmin _OrderAdmin = new OrderAdmin();
dsOrders = _OrderAdmin.ReportList(Mode, Year,"");
DataView dv = new DataView(dsOrders.Tables[0]);
if (Request.Params["filter"] != null)
{
Mode = Request.Params["filter"];
if (Mode.Equals("25"))
{
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/TaxReport.rdlc";
}
}
if (dv.ToTable().Rows.Count == 0)
{
lblErrorMsg.Text = "No records found";
objReportViewer.Visible = false;
return;
}
objReportViewer.LocalReport.DataSources.Clear();
ReportParameter param1 = new ReportParameter("CurrentLanguage", System.Globalization.CultureInfo.CurrentCulture.Name);
objReportViewer.LocalReport.SetParameters(new ReportParameter[] { param1 });
this.objReportViewer.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeOrderDataSet_ZNodeOrder", dv));
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeTitleDataSet_ZNodeTitle", dv));
objReportViewer.LocalReport.Refresh();
}
}
protected void btnOrderFilter_Click(object sender, EventArgs e)
{
objReportViewer.Visible = true;
if (Request.Params["filter"] != null)
{
Mode = Request.Params["filter"];
}
//Get Filetered Orders in DataSet
OrderAdmin _OrderAdmin = new OrderAdmin();
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
DataView dv = new DataView();
string Status = ListOrderStatus.SelectedItem.Text;
if (Mode == "23")
{
this.objReportViewer.LocalReport.ReportPath = "admin/Secure/SEO/Reports/popularsearch.rdlc";
if (Status == "Day")
{
Mode = "231";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Week")
{
Mode = "232";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Month")
{
Mode = "233";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Quarter")
{
Mode = "234";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Year")
{
Mode = "235";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
dv = new DataView(dsOrders.Tables[0]);
}
if (dv.ToTable().Rows.Count == 0)
{
lblErrorMsg.Text = "No records found";
objReportViewer.Visible = false;
return;
}
objReportViewer.LocalReport.DataSources.Clear();
ReportParameter param1 = new ReportParameter("CurrentLanguage", System.Globalization.CultureInfo.CurrentCulture.Name);
objReportViewer.LocalReport.SetParameters(new ReportParameter[] { param1 });
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZnodeSEOMost_Search_ZnodeSEOSearch", dv));
objReportViewer.LocalReport.Refresh();
}
/// <summary>
///
/// </summary>
/// <param name="ds"></param>
/// <returns></returns>
private DataSet FormatReportDataSet(DataSet ds)
{
//This will copied the structure and data from the Original dataset
DataSet tempDataSet = ds.Copy();
# region Local Variables
OrderAdmin orderAdmin = new OrderAdmin();
ShippingAdmin shippingAdmin = new ShippingAdmin();
StoreSettingsAdmin storeAdmin = new StoreSettingsAdmin();
#endregion
//Initialize new columns for OrderStatus,ShippingType,Payment Type
//Add column to this temporary dataset
DataColumn columnOrderStatus = new DataColumn("OrderStatus");
tempDataSet.Tables[0].Columns.Add(columnOrderStatus);
//Add ShippingType column
DataColumn columnShippingType = new DataColumn("ShippingTypeName");
tempDataSet.Tables[0].Columns.Add(columnShippingType);
//Add Paymenttype column
DataColumn columnPaymentType = new DataColumn("PaymentTypeName");
tempDataSet.Tables[0].Columns.Add(columnPaymentType);
//Loop through the Orders in the dataset
foreach (DataRow dr in tempDataSet.Tables[0].Rows)
{
//Get Order Status
int OrderStateId = int.Parse(dr["OrderStateId"].ToString());
OrderState entity = orderAdmin.GetByOrderStateID(OrderStateId);
int shippingId = int.Parse(dr["ShippingId"].ToString());
Shipping shippingEntity = shippingAdmin.GetShippingOptionById(shippingId);
int paymentTypeId = 0;
if(dr["PaymentTypeId"].ToString().Length > 0)
//If PaymentTypeId value length is greater than Zero
paymentTypeId = int.Parse(dr["PaymentTypeId"].ToString());
PaymentType paymentType = storeAdmin.GetPaymentTypeById(paymentTypeId);
if (entity != null)
dr["OrderStatus"] = entity.OrderStateName;
if (shippingEntity != null)
dr["ShippingTypeName"] = (shippingAdmin.GetShippingTypeName(shippingEntity.ShippingTypeID));
if (paymentType != null)
dr["PaymentTypeName"] = paymentType.Name;
}
//Return dataset
return tempDataSet;
}
/// <summary>
/// Method to sort the grid in Ascending and Descending Order
/// </summary>
protected void SortGrid()
{
OrderAdmin _OrderAdmin = new OrderAdmin();
DataSet ds = _OrderAdmin.FindOrders(txtorderid.Text.Trim(), txtfirstname.Text.Trim(), txtlastname.Text.Trim(), txtcompanyname.Text.Trim(), txtaccountnumber.Text.Trim(), txtStartDate.Text.Trim(), txtEndDate.Text.Trim(), int.Parse(ListOrderStatus.SelectedValue.ToString()), ZNodeConfigManager.SiteConfig.PortalID);
uxGrid.DataSource = ds;
DataSet dataSet = uxGrid.DataSource as DataSet;
DataView dataView = new DataView(dataSet.Tables[0]);
// Apply sort filter and direction
dataView.Sort = SortField;
//If sortDirection is not Ascending
if (!SortAscending)
{
dataView.Sort += " DESC";
}
uxGrid.DataSource = null;
uxGrid.DataSource = dataView;
uxGrid.DataBind();
}
public void GetHighestOrderId()
{
OrderAdmin _OrderAdmin = new OrderAdmin();
int OrderId = _OrderAdmin.GetHighestOrderId();
OrderNumber.Text = OrderId.ToString();
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnOrderFilter_Click(object sender, EventArgs e)
{
objReportViewer.Visible = true;
if (Request.Params["filter"] != null)
{
Mode = Request.Params["filter"];
}
//Get Filetered Orders in DataSet
OrderAdmin _OrderAdmin = new OrderAdmin();
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
dsOrdersLineItems = _OrderAdmin.GetAllOrderLineItems().ToDataSet(false);
DataView dv = new DataView(dsOrders.Tables[0]);
DataView dv1 = new DataView();
pnlCustom.Visible = true;
string Status = ListOrderStatus.SelectedItem.Text;
if (Mode == "15")
{
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/FrequentCustomer.rdlc";
if (Status == "Day")
{
Mode = "151";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Week")
{
Mode = "152";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Month")
{
Mode = "153";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Quarter")
{
Mode = "154";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Year")
{
Mode = "155";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
dsOrdersLineItems = _OrderAdmin.GetAllOrderLineItems().ToDataSet(false);
dv1 = new DataView(dsOrders.Tables[0]);
}
else if (Mode == "16")
{
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/FrequentCustomer.rdlc";
if (Status == "Day")
{
Mode = "161";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Week")
{
Mode = "162";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Month")
{
Mode = "163";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Quarter")
{
Mode = "164";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Year")
{
Mode = "165";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
dsOrdersLineItems = _OrderAdmin.GetAllOrderLineItems().ToDataSet(false);
dv1 = new DataView(dsOrders.Tables[0]);
}
else if (Mode == "17")
{
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/PopularProduct.rdlc";
if (Status == "Day")
{
Mode = "171";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Week")
{
Mode = "172";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Month")
{
Mode = "173";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Quarter")
{
Mode = "174";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Year")
{
Mode = "175";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
dsOrdersLineItems = _OrderAdmin.ReportList(Mode, Year, "");
dv1 = new DataView(dsOrdersLineItems.Tables[0]);
}
else if (Mode == "20")
{
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/BestSellers.rdlc";
if (Status == "Day")
{
Mode = "201";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Week")
{
Mode = "202";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Month")
{
Mode = "203";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Quarter")
{
Mode = "204";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Year")
{
Mode = "205";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
dsOrdersLineItems = _OrderAdmin.ReportList(Mode, Year, "");
dv1 = new DataView(dsOrdersLineItems.Tables[0]);
}
else if (Mode == "24")
{
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/CouponUsage.rdlc";
if (Status == "Day")
{
Mode = "241";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Week")
{
Mode = "242";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Month")
{
Mode = "243";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Quarter")
{
Mode = "244";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Year")
{
Mode = "245";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
dsOrdersLineItems = _OrderAdmin.GetAllOrderLineItems().ToDataSet(false);
dv1 = new DataView(dsOrders.Tables[0]);
}
else if (Mode == "26")
{
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/Affiliate.rdlc";
if (Status == "Day")
{
Mode = "261";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Week")
{
Mode = "262";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Month")
{
Mode = "263";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Quarter")
{
Mode = "264";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
else if (Status == "Year")
{
Mode = "265";
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
}
dsOrdersLineItems = _OrderAdmin.GetAllOrderLineItems().ToDataSet(false);
dv1 = new DataView(dsOrders.Tables[0]);
}
if (dv1.ToTable().Rows.Count == 0)
{
lblErrorMsg.Text = "No records found";
objReportViewer.Visible = false;
return;
}
objReportViewer.LocalReport.DataSources.Clear();
ReportParameter param1 = new ReportParameter("CurrentLanguage", System.Globalization.CultureInfo.CurrentCulture.Name);
objReportViewer.LocalReport.SetParameters(new ReportParameter[] { param1 });
this.objReportViewer.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeAffiliate_ZNodeAffiliate", dv1));
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeOrderDataSet_ZNodeOrder", dv1));
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeCouponDataSet_ZNodeCoupon", dv1));
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeOrderLineItems_ZNodeOrderLineItem", dsOrdersLineItems.Tables[0]));
objReportViewer.LocalReport.Refresh();
}
/// <summary>
/// Page Load Event
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Request.Params["filter"] != null)
{
Mode = Request.Params["filter"];
}
//Get Filetered Orders in DataSet
OrderAdmin _OrderAdmin = new OrderAdmin();
DataView dv = new DataView();
// Mode 17 - For Top Earning Products
// Mode 18 - For Inventory Re-Orderlevel
// Mode 20 - For Best Sellers
if (Mode.Equals("17") || Mode.Equals("18") || Mode.Equals("20") || Mode.Equals("26"))
{
dsOrdersLineItems = _OrderAdmin.ReportList(Mode, Year, "");
dv = new DataView(dsOrdersLineItems.Tables[0]);
}
else if (Mode.Equals("19")) // Mode 19 - Customer Feedback
{
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
dsCaseRequest = _OrderAdmin.ReportList(Mode, Year, "");
dv = new DataView(dsOrders.Tables[0]);
}
else
{
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
dsOrdersLineItems = _OrderAdmin.GetAllOrderLineItems().ToDataSet(false);
dv = new DataView(dsOrders.Tables[0]);
}
if (Request.Params["filter"] != null)
{
Mode = Request.Params["filter"];
// Order Pick List
if (Mode.Equals("13"))
{
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/Inventory.rdlc";
}
// Email Opt-In Customers
if (Mode.Equals("14"))
{
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/EmailOptIn.rdlc";
}
// Most Frequent Customers
if (Mode.Equals("15"))
{
pnlCustom.Visible = true;
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/FrequentCustomer.rdlc";
}
// Highest Dollar Customers
if (Mode.Equals("16"))
{
pnlCustom.Visible = true;
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/VolumeCustomer.rdlc";
}
// Most Popular Product
if (Mode.Equals("17"))
{
pnlCustom.Visible = true;
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/PopularProduct.rdlc";
}
// Inventory Re-Order
if (Mode.Equals("18"))
{
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/ReOrder.rdlc";
}
// Customer Feedback
if (Mode.Equals("19"))
{
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/Feedback.rdlc";
}
// Best Sellers
if (Mode.Equals("20"))
{
pnlCustom.Visible = true;
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/BestSellers.rdlc";
}
// Coupon Usage
if (Mode.Equals("24"))
{
pnlCustom.Visible = true;
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/CouponUsage.rdlc";
}
// Affiliate Orders
if (Mode.Equals("26"))
{
pnlCustom.Visible = true;
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/Affiliate.rdlc";
}
}
if (dv.ToTable().Rows.Count == 0)
{
lblErrorMsg.Text = "No records found";
objReportViewer.Visible = false;
pnlCustom.Visible = false;
return;
}
objReportViewer.LocalReport.DataSources.Clear();
ReportParameter param1 = new ReportParameter("CurrentLanguage", System.Globalization.CultureInfo.CurrentCulture.Name);
objReportViewer.LocalReport.SetParameters(new ReportParameter[] { param1 });
this.objReportViewer.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
if (Mode.Equals("24"))
{
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeCouponDataSet_ZNodeCoupon", dv));
}
else if (!Mode.Equals("19"))
{
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeOrderDataSet_ZNodeOrder", dv));
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeAccountDataSet_ZNodeAccount", dv));
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeOrderLineItems_ZNodeOrderLineItem", dsOrdersLineItems.Tables[0]));
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeAffiliate_ZNodeAffiliate", dv));
}
else
{
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeTitleDataSet_ZNodeTitle", dv));
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeCaseRequestDataSet_ZNodeCaseRequest", dsCaseRequest.Tables[0]));
}
objReportViewer.LocalReport.Refresh();
}
}
public async Task <IActionResult> admin([FromHeader] string Authorization, [FromBody] OrderAdmin orderAdmin)
{
try
{
long timestamp = (long)DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1)).TotalSeconds;
AmazonDynamoDBClient amazonDynamoDBClient = new AmazonDynamoDBClient();
Table UserTable = Table.LoadTable(amazonDynamoDBClient, "UserDetailsRegistry");
Document searchdetails = new Document();
string socket;
try
{
string[] autharray = Authorization.Split(' ');
string authtype = autharray[0];
string authstring = autharray[1];
if (authtype == "Basic")
{
byte[] data = Convert.FromBase64String(authstring);
string decodedString = Encoding.UTF8.GetString(data);
string[] splitauth = decodedString.Split(":");
string id = splitauth[0];
string secret = splitauth[1]; Console.WriteLine(id + secret);
Document doc = await UserTable.GetItemAsync("testemail");
if (id == doc["DefaultId"].ToString() && secret == doc["DefaultSecret"].ToString())
{
//ok
searchdetails = doc;
}
else
{
return(BadRequest());
}
}
else
{
return(BadRequest("Bad authorization"));
}
}
catch
{
return(BadRequest("authorizaion failed"));
}
// send tcp message to engine
try
{
TcpClient tcpclnt = new TcpClient();
Console.WriteLine("Connecting.....");
tcpclnt.Connect("52.213.34.99", port);
// use the ipaddress as in the server program
Console.WriteLine("Connected");
Console.Write("Enter the string to be transmitted : ");
var enginepayload = new
{
Method = "Admin",
Admin = orderAdmin.Admin
};
using (SslStream sslStream = new SslStream(tcpclnt.GetStream(), false,
new RemoteCertificateValidationCallback(ValidateServerCertificate), null))
{
sslStream.AuthenticateAsClient("52.213.34.99");
// This is where you read and send data
String str = "enginekey" + JsonConvert.SerializeObject(enginepayload);
//Stream stm = tcpclnt.GetStream();
ASCIIEncoding asen = new ASCIIEncoding();
byte[] ba = asen.GetBytes(str);
Console.WriteLine("Transmitting.....");
sslStream.Write(ba, 0, ba.Length);
sslStream.Close();
/*byte[] bb = new byte[1000];
* int k = await sslStream.ReadAsync(bb, 0, 1000);
*
* var socketresult = Encoding.UTF8.GetString(bb).TrimEnd('\0');
* Console.WriteLine(socketresult);
* socket = socketresult;*/
}
tcpclnt.Close();
}
catch (Exception e)
{
Console.WriteLine("Error..... " + e.StackTrace);
return(BadRequest("error with engine"));
}
return(Ok());
}
catch
{
return(BadRequest("error"));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Params["filter"] != null)
{
Mode = Request.Params["filter"];
}
// Get Fietered Orders in DataSet
OrderAdmin _OrderAdmin = new OrderAdmin();
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
DataView dv = new DataView(dsOrders.Tables[0]);
if (!Page.IsPostBack)
{
// Load Order State Item
if (Request.Params["filter"] != null)
{
if (Mode.Equals("22"))
{
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/ActivityLog.rdlc";
}
}
if (dv.ToTable().Rows.Count == 0)
{
lblErrorMsg.Text = "No records found";
objReportViewer.Visible = false;
return;
}
objReportViewer.LocalReport.DataSources.Clear();
ReportParameter param1 = new ReportParameter("CurrentLanguage", System.Globalization.CultureInfo.CurrentCulture.Name);
objReportViewer.LocalReport.SetParameters(new ReportParameter[] { param1 });
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZnodeActivityLog_ZnodeActivityLog", dv));
}
}
protected void btnOrderFilter_Click(object sender, EventArgs e)
{
objReportViewer.Visible = true;
//Get Filetered Orders in DataSet
OrderAdmin _OrderAdmin = new OrderAdmin();
DataView dv = new DataView();
if (Mode.Equals("12"))
{
DataSet tempDs = FormatReportDataSet(_OrderAdmin.GetAllOrders(ZNodeConfigManager.SiteConfig.PortalID).ToDataSet(false));
dsOrdersLineItems = _OrderAdmin.GetAllOrderLineItems().ToDataSet(false);
dv = new DataView(tempDs.Tables[0]);
}
else if (Mode.Equals("21"))
{
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
dv = new DataView(dsOrders.Tables[0]);
}
DateTime StartDate = DateTime.Parse(txtStartDate.Text.Trim());
DateTime EndDate = DateTime.Parse(txtEndDate.Text.Trim());
if (Mode.Equals("12"))
{
string Status = ddlOrderStatus.SelectedItem.Text;
if (Status == "ALL")
{
dv.RowFilter = "orderdate >= '" + StartDate + "' and orderdate <= '" + EndDate.AddDays(1) + "'";
}
else
{
dv.RowFilter = "orderdate >= '" + StartDate + "' and orderdate <= '" + EndDate.AddDays(1) + "' and orderstatus = '" + Status + "'";
}
}
if (Mode.Equals("21"))
{
string Status = ddlProfilename.SelectedItem.Text;
if (Status == "ALL")
{
dv.RowFilter = "CreateDte >= '" + StartDate + "' and CreateDte <= '" + EndDate.AddDays(1) + "'";
}
else
{
dv.RowFilter = "CreateDte >= '" + StartDate + "' and CreateDte <= '" + EndDate.AddDays(1) + "' and ProfileName = '" + Status + "'";
}
}
if (dv.ToTable().Rows.Count == 0)
{
lblErrorMsg.Text = "No records found";
objReportViewer.Visible = false;
return;
}
objReportViewer.LocalReport.DataSources.Clear();
ReportParameter param1 = new ReportParameter("CurrentLanguage", System.Globalization.CultureInfo.CurrentCulture.Name);
objReportViewer.LocalReport.SetParameters(new ReportParameter[] { param1 });
this.objReportViewer.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
if (Mode.Equals("12"))
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeOrderDataSet_ZNodeOrder", dv));
else if (Mode.Equals("21"))
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeAccountDataSet_ZNodeAccount", dv));
objReportViewer.LocalReport.Refresh();
}
/// <summary>
/// Bind Order Grid
/// </summary>
protected void BindGrid()
{
OrderAdmin _OrderAdmin = new OrderAdmin();
//TList<Order> _Orders = _OrderAdmin.GetByAccountID(AccountID);
DataSet DataSetOrderList = _OrderAdmin.GetByAccountID(AccountID, ZNodeConfigManager.SiteConfig.PortalID);
uxGrid.DataSource = DataSetOrderList;
uxGrid.DataBind();
}
public DataSet BindSearchData(string startdate,string EndDate)
{
OrderAdmin _OrderAdmin = new OrderAdmin();
MyDataSet = _OrderAdmin.FindOrders(txtorderid.Text.Trim(), txtfirstname.Text.Trim(), txtlastname.Text.Trim(), txtcompanyname.Text.Trim(), txtaccountnumber.Text.Trim(), startdate.Trim(), EndDate.Trim(), int.Parse(ListOrderStatus.SelectedValue.ToString()), ZNodeConfigManager.SiteConfig.PortalID);
return MyDataSet;
}
/// <summary>
/// Display the Order State name for a Order state
/// </summary>
/// <param name="FieldValue"></param>
/// <returns></returns>
protected string DisplayOrderStatus(object FieldValue)
{
ZNode.Libraries.Admin.OrderAdmin _OrderStateAdmin = new OrderAdmin();
OrderState _OrderState = _OrderStateAdmin.GetByOrderStateID(int.Parse(FieldValue.ToString()));
return _OrderState.OrderStateName.ToString();
}
/// <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 Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Request.Params["filter"] != null)
{
Mode = Request.Params["filter"];
}
if (Request.Params["pagetype"] != null)
{
PageType = Request.Params["pagetype"];
}
else
{
PageType = "";
}
// Get Filetered Orders in DataSet
OrderAdmin _OrderAdmin = new OrderAdmin();
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
DataView dv = new DataView(dsOrders.Tables[0]);
// Set the Report Path
this.objReportViewer.LocalReport.ReportPath = "admin/Secure/SEO/Reports/popularsearch.rdlc";
if (dv.ToTable().Rows.Count == 0)
{
lblErrorMsg.Text = "No records found";
objReportViewer.Visible = false;
return;
}
objReportViewer.LocalReport.DataSources.Clear();
ReportParameter param1 = new ReportParameter("CurrentLanguage", System.Globalization.CultureInfo.CurrentCulture.Name);
objReportViewer.LocalReport.SetParameters(new ReportParameter[] { param1 });
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZnodeSEOMost_Search_ZnodeSEOSearch", dsOrders.Tables[0]));
objReportViewer.LocalReport.Refresh();
}
}
private DataSet GetOrderLineItems()
{
OrderAdmin _OrderAdmin = new OrderAdmin();
string stdate = String.Empty;
string enddate = String.Empty;
//Check for Search is enabled or not
if (SearchEnabled)
{
stdate = txtStartDate.Text.Trim();
enddate = txtEndDate.Text.Trim();
}
DataSet MyDataSet = _OrderAdmin.GetOrderLineItems(txtorderid.Text.Trim(),txtfirstname.Text.Trim(),txtlastname.Text.Trim(),txtcompanyname.Text.Trim(),txtaccountnumber.Text.Trim(),stdate ,enddate, int.Parse(ListOrderStatus.SelectedValue.ToString()), ZNodeConfigManager.SiteConfig.PortalID);
return MyDataSet;
}
/// <summary>
/// Page Load Event
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Params["filter"] != null)
{
Mode = Request.Params["filter"];
}
if (!Page.IsPostBack)
{
// Load Order State Item
OrderAdmin _OrderAdminAccess = new OrderAdmin();
ddlOrderStatus.DataSource = _OrderAdminAccess.GetAllOrderStates();
ddlOrderStatus.DataTextField = "orderstatename";
ddlOrderStatus.DataValueField = "Orderstateid";
ddlOrderStatus.DataBind();
ListItem item1 = new ListItem("ALL", "0");
ddlOrderStatus.Items.Insert(0, item1);
ddlOrderStatus.SelectedIndex = 0;
// Load Profile Types
ProfileAdmin profileAdmin = new ProfileAdmin();
ddlProfilename.DataSource = profileAdmin.GetAll();
ddlProfilename.DataTextField = "Name";
ddlProfilename.DataValueField = "ProfileID";
ddlProfilename.DataBind();
ListItem item2 = new ListItem("ALL", "0");
ddlProfilename.Items.Insert(0, item2);
ddlProfilename.SelectedIndex = 0;
// Get Filetered Orders in DataSet
OrderAdmin _OrderAdmin = new OrderAdmin();
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
dsOrdersLineItems = _OrderAdmin.GetAllOrderLineItems().ToDataSet(false);
DataView dv = new DataView(dsOrders.Tables[0]);
if (Request.Params["filter"] != null)
{
if (Mode.Equals("12"))
{
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/Orders.rdlc";
pnlOrderStatus.Visible = true;
lblOrderStatus.Visible = true;
lblOrderStatus.Text = "Order Status";
btnOrderFilter.Text = "Get Orders";
}
if (Mode.Equals("21"))
{
this.objReportViewer.LocalReport.ReportPath = "Admin/Secure/Reports/Accounts.rdlc";
pnlprofile.Visible = true;
lblProfileName.Visible = true;
lblProfileName.Text = "Profiles";
btnOrderFilter.Text = "Get Details";
}
}
if (dv.ToTable().Rows.Count == 0)
{
lblErrorMsg.Text = "No records found";
objReportViewer.Visible = false;
pnlCustom.Visible = false;
return;
}
objReportViewer.LocalReport.DataSources.Clear();
ReportParameter param1 = new ReportParameter("CurrentLanguage", System.Globalization.CultureInfo.CurrentCulture.Name);
objReportViewer.LocalReport.SetParameters(new ReportParameter[] { param1 });
this.objReportViewer.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
if (Mode.Equals("12"))
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeOrderDataSet_ZNodeOrder", dv));
else if(Mode.Equals("21"))
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeAccountDataSet_ZNodeAccount", dv));
objReportViewer.LocalReport.Refresh();
}
}
