protected void LinkButtonupdate_click(object sender, System.EventArgs e) { CSLOrderingARCBAL.LinqToSqlDataContext db = null; try { pnlGradeDetails.Visible = true; pnlGradeList.Visible = false; litAction.Text = "You choose to <b>EDIT GRADE MAPPING</b>"; LinkButton lbctg = sender as LinkButton; if (lbctg != null) { GridViewRow gvr = (GridViewRow)lbctg.NamingContainer; Label lbl1 = gvr.FindControl("lblProductGradeID") as Label; ViewState["ProductGradeID"] = lbl1.Text; } db = new LinqToSqlDataContext(); var usrDtls = ProductBAL.GetProductGradeById(Convert.ToInt32(ViewState["ProductGradeID"].ToString())); if (usrDtls != null) { txtProductCode.Text = usrDtls.ProductCode; ddlGrade.SelectedValue = usrDtls.Grade.ToString(); } db.Dispose(); } catch (Exception objException) { db = new CSLOrderingARCBAL.LinqToSqlDataContext(); db.USP_SaveErrorDetails(Request.Url.ToString(), "LinkButtonupdate_click", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()])); db.Dispose(); } }
protected void Page_Load(object sender, EventArgs e) { try { if (Session[enumSessions.User_Id.ToString()] == null) { Response.Redirect("Login.aspx"); } if (!Page.IsPostBack) { LoadCategories(); } } catch (System.Threading.ThreadAbortException) { // ** Do Nothing } catch (Exception objException) { CSLOrderingARCBAL.LinqToSqlDataContext db; db = new CSLOrderingARCBAL.LinqToSqlDataContext(); db.USP_SaveErrorDetails(Request.Url.ToString(), "Page_Load", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()])); db.Dispose(); } }
public static List <OrderItemDetailsDTO> GetOrderDetailsforReport(int orderID) { CSLOrderingARCBAL.LinqToSqlDataContext db = null; try { db = new CSLOrderingARCBAL.LinqToSqlDataContext(); List <OrderItemDetailsDTO> orderItemDetails = new List <OrderItemDetailsDTO>(); orderItemDetails = (from o in db.Orders join oi in db.OrderItems on o.OrderId equals oi.OrderId join oid in db.OrderItemDetails on oi.OrderItemId equals oid.OrderItemId join ois in db.OrderStatusMasters on oi.OrderItemStatusId equals ois.OrderStatusId join op in db.Options on oid.OptionId equals op.OptID into x from Y in x.DefaultIfEmpty() select new OrderItemDetailsDTO { GPRSNo = oid.GPRSNo, PSTNNo = oid.PSTNNo, GSMNo = oid.GSMNo, LANNo = oid.LANNo, GPRSNoPostCode = oid.GPRSNoPostCode, ICCID = oid.ICCID, OrderItemStatus = ois.OrderStatus, OptionName = (Y == null ? String.Empty : Y.OptionName) }).ToList <OrderItemDetailsDTO>();; // (from o in db.Orders // join oi in db.OrderItems on o.OrderId equals oi.OrderId // join oid in db.OrderItemDetails on oi.OrderItemId equals oid.OrderItemId // join op in db.Options on oid.OptionId equals op.OptID // join ois in db.OrderStatusMasters on oi.OrderItemStatusId equals ois.OrderStatusId // where oi.OrderItemId == orderID && oid.GPRSNo !=String.Empty // select new OrderItemDetailsDTO // { // GPRSNo = oid.GPRSNo, // PSTNNo = oid.PSTNNo, // GSMNo = oid.GSMNo, // LANNo = oid.LANNo, // GPRSNoPostCode = oid.GPRSNoPostCode, // ICCID = oid.ICCID, // OrderItemStatus = ois.OrderStatus, // OptionName = op.OptionName // }).ToList<OrderItemDetailsDTO>(); db.Dispose(); return(orderItemDetails); } catch (Exception objException) { db = new CSLOrderingARCBAL.LinqToSqlDataContext(); db.USP_SaveErrorDetails("ARC Ordering", "GetOrderDetailsforReport", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, null); return(null); } }
protected void ddlDeliveryTypes_SelectedIndexChanged(object sender, EventArgs e) { try { int deliTypeID = 0; int.TryParse(ddlDeliveryTypes.SelectedValue, out deliTypeID); if (deliTypeID != 0) { lblDeliveryTotal.Text = OrdersBAL.CalculateOrderDeliverycharge(deliTypeID).ToString(); lblDtlsDeliveryTotal.Text = lblDeliveryTotal.Text; decimal amt = Convert.ToDecimal(String.IsNullOrEmpty(lblDtlsOrderTotal.Text) == true ? "0.00" : lblDtlsOrderTotal.Text) + Convert.ToDecimal(lblDtlsDeliveryTotal.Text); decimal?VAT = amt * VATRate; lblDtlsVAT.Text = Math.Round(Convert.ToDecimal(VAT), 2).ToString(); lblDtlsTotalToPay.Text = (amt + Math.Round(Convert.ToDecimal(VAT), 2)).ToString(); } } catch (Exception objException) { CSLOrderingARCBAL.LinqToSqlDataContext db; db = new CSLOrderingARCBAL.LinqToSqlDataContext(); db.USP_SaveErrorDetails(Request.Url.ToString(), "ddlDeliveryTypes_SelectedIndexChanged", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()])); db.Dispose(); } }
private string LoadARCEmailCC() { string val = string.Empty; LinqToSqlDataContext db = new LinqToSqlDataContext(); try { val = db.USP_GetARCEmailCC(Convert.ToInt32(Session[enumSessions.ARC_Id.ToString()].ToString())).FirstOrDefault().ARC_CCEMAIL; } catch (Exception objException) { db = new CSLOrderingARCBAL.LinqToSqlDataContext(); db.USP_SaveErrorDetails(Request.Url.ToString(), "LoadARCEmailCC", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()])); db.Dispose(); } finally { db.Dispose(); } return(val); }
public void LoadData() { CSLOrderingARCBAL.LinqToSqlDataContext db = null; try { ddlGrade.DataSource = ProductBAL.GradeList(); ddlGrade.DataTextField = "Grade"; ddlGrade.DataValueField = "Grade"; ddlGrade.DataBind(); gvGrade.DataSource = ProductBAL.GetProductGrade(); gvGrade.DataBind(); } catch (Exception objException) { db = new CSLOrderingARCBAL.LinqToSqlDataContext(); db.USP_SaveErrorDetails(Request.Url.ToString(), "LoadData", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()])); db.Dispose(); } }
protected void LinkButtondelete_click(object sender, System.EventArgs e) { CSLOrderingARCBAL.LinqToSqlDataContext db = null; try { LinkButton lbdel = sender as LinkButton; if (lbdel != null) { GridViewRow gvr = (GridViewRow)lbdel.NamingContainer; Label lbl2 = gvr.FindControl("lblProductGradeID") as Label; ViewState["ProductGradeID"] = lbl2.Text; } else { //Reset if (ViewState["ProductGradeID"] != null) { } else { //Do a cancel as no value in ViewState btnCancel_Click(sender, e); } } db = new LinqToSqlDataContext(); Boolean retunStatus = ProductBAL.DeleteProductGrade(Convert.ToInt32(ViewState["ProductGradeID"].ToString())); if (retunStatus == true) { LoadData(); string script = "alertify.alert('" + ltrGrade.Text + "');"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true); } } catch (Exception objException) { db = new CSLOrderingARCBAL.LinqToSqlDataContext(); db.USP_SaveErrorDetails(Request.Url.ToString(), "LinkButtondelete_click", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()])); db.Dispose(); } }
protected void ProductsRepeater_ItemBound(object sender, RepeaterItemEventArgs args) { try { if (args.Item.ItemType == ListItemType.Item || args.Item.ItemType == ListItemType.AlternatingItem) { USP_GetProductsByCategoryAndArcResult product = (USP_GetProductsByCategoryAndArcResult)args.Item.DataItem; TextBox txtProductQty = args.Item.FindControl("txtProductQty") as TextBox; RadioButtonList rdbCompanies = args.Item.FindControl("rdbCompanies") as RadioButtonList; HiddenField hdnIsDCC = null; hdnIsDCC = (HiddenField)args.Item.FindControl("hdnIsDCC"); LinqToSqlDataContext db = new LinqToSqlDataContext(); // using the truncated product code get the full product codes eligible for that ARc and displying radio button accordingly if (Convert.ToBoolean(hdnIsDCC.Value) == true) { //displayManufacturerRadioButtons(rdbCompanies, product.ProductId); // displayManufacturerRadioButtons(rdbCompanies); displayManufacturerRadioButtons(rdbCompanies, product.ProductCode); } if (Session[enumSessions.User_Role.ToString()] != null && Session[enumSessions.User_Role.ToString()].ToString() == enumRoles.ARC_Admin.ToString()) { Label lblProductPrice = args.Item.FindControl("lblProductPrice") as Label; lblProductPrice.Text = String.Empty; // 0.00 for ARC_admin roles } } } catch (Exception objException) { CSLOrderingARCBAL.LinqToSqlDataContext db; db = new CSLOrderingARCBAL.LinqToSqlDataContext(); db.USP_SaveErrorDetails(Request.Url.ToString(), "ProductsRepeater_ItemBound", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()])); db.Dispose(); } }
protected void rptrDependentProducts_ItemBound(object sender, RepeaterItemEventArgs args) { try { if (args.Item.ItemType == ListItemType.Item || args.Item.ItemType == ListItemType.AlternatingItem) { if (Session[enumSessions.User_Role.ToString()] != null && Session[enumSessions.User_Role.ToString()].ToString() == enumRoles.ARC_Admin.ToString()) { Label lblProductPrice = (Label)args.Item.FindControl("lblProductPrice"); lblProductPrice.Text = String.Empty;//0.00 Label lblProductPriceTotal = (Label)args.Item.FindControl("lblProductPriceTotal"); lblProductPriceTotal.Text = String.Empty;//0.00 } } } catch (Exception objException) { CSLOrderingARCBAL.LinqToSqlDataContext db; db = new CSLOrderingARCBAL.LinqToSqlDataContext(); db.USP_SaveErrorDetails(Request.Url.ToString(), "rptrDependentProducts_ItemBound", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()])); db.Dispose(); } }
protected void LoadDeliveryTypes() { ddlDeliveryTypes.Items.Clear(); //Calculating order total and other offers to populate delivery options OrdersBAL deliveryOptions = new OrdersBAL(); deliveryOptions.orderId = Convert.ToInt32(Session[enumSessions.OrderId.ToString()].ToString()); //Set the lowest priced as selected. int i = 0; int selectedIndex = 0; decimal leastPriceItem = decimal.MaxValue; try { //List<DeliveryType> shippingOptions = deliveryOptions.GetShippingOptions(); LinqToSqlDataContext db = new LinqToSqlDataContext(); List <USP_GetShippingOptionsResult> shippingOptions = new List <USP_GetShippingOptionsResult>(); shippingOptions = db.USP_GetShippingOptions(Convert.ToInt32(Session[enumSessions.ARC_Id.ToString()].ToString()), new Guid(Session[enumSessions.InstallerCompanyID.ToString()].ToString()), Convert.ToInt32(Session[enumSessions.OrderId.ToString()])).ToList(); foreach (USP_GetShippingOptionsResult delivery in shippingOptions) { System.Web.UI.WebControls.ListItem item = new System.Web.UI.WebControls.ListItem(); System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-GB", false); item.Text = delivery.DeliveryShortDesc + " - " + delivery.DeliveryPrice.Value.ToString("c"); item.Value = delivery.DeliveryTypeId.ToString(); if (leastPriceItem != decimal.Zero && delivery.DeliveryPrice < leastPriceItem) { leastPriceItem = delivery.DeliveryPrice.Value; ddlDeliveryTypes.ClearSelection(); ddlDeliveryTypes.SelectedIndex = i; selectedIndex = i; } ddlDeliveryTypes.Items.Add(item); i++; } ddlDeliveryTypes.DataBind(); ddlDeliveryTypes.SelectedIndex = selectedIndex; bool?isAncillary = false; db.USP_IsAncillaryOnlyOrders(Convert.ToInt32(Session[enumSessions.OrderId.ToString()]), ref isAncillary); if (isAncillary.Value == true) { lblIsAncillary.Visible = true; } else { lblIsAncillary.Visible = false; } } catch (Exception objException) { CSLOrderingARCBAL.LinqToSqlDataContext db; db = new CSLOrderingARCBAL.LinqToSqlDataContext(); db.USP_SaveErrorDetails(Request.Url.ToString(), "LoadDeliveryTypes", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()])); db.Dispose(); } }
protected void btnProceed_Click(object sender, EventArgs e) { try { Page.Validate(); if (Page.IsValid) { bool isQtyEntered = false; TextBox txtProductQty = null; TextBox lblProductType = null; TextBox lblProductId = null; RadioButtonList rdbCompanies = null; Label lblProductCode = null; HiddenField hdnIsDCC = null; LinqToSqlDataContext db = new LinqToSqlDataContext(); int OrderItemId = 0; int qtyCounter = 0; foreach (RepeaterItem item in dlProducts.Items) { txtProductQty = (TextBox)item.FindControl("txtProductQty"); lblProductType = (TextBox)item.FindControl("lblProductType"); lblProductId = (TextBox)item.FindControl("lblProductId"); rdbCompanies = (RadioButtonList)item.FindControl("rdbCompanies"); lblProductCode = (Label)item.FindControl("lblProductCode"); hdnIsDCC = (HiddenField)item.FindControl("hdnIsDCC"); //only display radio for ISDCC is true if (Convert.ToBoolean(hdnIsDCC.Value) == true) { // displayManufacturerRadioButtons(rdbCompanies); displayManufacturerRadioButtons(rdbCompanies, lblProductCode.Text); //displayManufacturerRadioButtons(rdbCompanies, Convert.ToInt32(lblProductId.Text)); } if (!string.IsNullOrEmpty(txtProductQty.Text) && Convert.ToInt32(txtProductQty.Text) > 0) { if (rdbCompanies.Visible == true && (Convert.ToBoolean(hdnIsDCC.Value) == true)) { if (rdbCompanies.SelectedItem.Text != rdbCompanies.Items[0].Text)//added by priya { string companyId = (from dcc in db.DCCCompanies where dcc.company_name == rdbCompanies.SelectedItem.Text select dcc.company_id).SingleOrDefault(); if (companyId != null) { string productCode = lblProductCode.Text + companyId; int productid = (from p in db.Products where p.ProductCode == productCode select p.ProductId).SingleOrDefault(); //validation to check if the productid exists needed if (productid != 0) { lblProductId.Text = productid.ToString(); } else { string script = "alertify.alert('" + ltrNotaValidProduct + "');"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true); return; } } } else { string script = "alertify.alert('" + ltrSelectManufacturer.Text + "');"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true); return; } } int CategoryID = Convert.ToInt32(Request.QueryString["CategoryId"]); //update product code and product id var orderitem = db.USP_SaveOrderItems(Convert.ToInt32(Session[enumSessions.OrderId.ToString()].ToString()), Convert.ToInt32(lblProductId.Text), Convert.ToInt32(txtProductQty.Text), new Guid(Session[enumSessions.User_Id.ToString()].ToString()), Session[enumSessions.User_Name.ToString()].ToString(), Convert.ToInt32(Request.QueryString["CategoryId"])).SingleOrDefault(); if (orderitem != null) { if (orderitem.OrderItemId.HasValue) { int.TryParse(orderitem.OrderItemId.Value.ToString(), out OrderItemId); } } if (OrderItemId != 0) { /* by ajitender * db.USP_DeleteOrderItemDetailsByOrderItemId(OrderItemId);*/ List <String> CategorieswithNoChipNo = (from app in db.ApplicationSettings where app.KeyName == "CategorieswithNoChipNo" select app.KeyValue).SingleOrDefault().Split(',').ToList(); string GPRSNo = string.Empty; if (CategorieswithNoChipNo.Contains(CategoryID.ToString())) { GPRSNo = "0000"; } for (qtyCounter = 0; qtyCounter < Convert.ToInt32(txtProductQty.Text); qtyCounter++) { db.USP_AddOrderItemDetailsToBasket(OrderItemId, GPRSNo, "", Session[enumSessions.User_Name.ToString()].ToString()); } } isQtyEntered = true; } } db.Dispose(); if (isQtyEntered) { Response.Redirect("Basket.aspx"); } else { string script = "alertify.alert('" + ltrEnterQntty.Text + "');"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true); return; } } } catch (System.Threading.ThreadAbortException ex) { // } catch (Exception objException) { CSLOrderingARCBAL.LinqToSqlDataContext db; db = new CSLOrderingARCBAL.LinqToSqlDataContext(); db.USP_SaveErrorDetails(Request.Url.ToString(), "btnProceed_Click", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()])); db.Dispose(); } }