Пример #1
0
        private void bindOrderData()
        {
            Cart      c = Cart.Current;
            Requestor r = Requestor.Current;

            bool   isSMTA        = false;
            bool   isRestriction = false;
            string SMTAIds       = "";

            using (SecureData sd = new SecureData(false, UserManager.GetLoginToken())) {
                var ds = sd.GetData("web_cartview", ":idlist=" + Toolkit.Join(c.AccessionIDs.ToArray(), ",", ""), 0, 0);

                var dt = ds.Tables["web_cartview"];

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    CartItem ci = c.FindByAccessionID(dt.Rows[i], "accession_id");
                    if (ci != null)
                    {
                        //dt.Rows[i]["quantity"] = ci.Quantity; //Laura Temp
                    }

                    if (dt.Rows[i]["type_code"].ToString() == "MTA-SMTA")
                    {
                        isSMTA   = true;
                        SMTAIds += ", <a href='accessiondetail.aspx?id=" + ci.ItemID + "'>" + dt.Rows[i]["pi_number"].ToString() + "</a>";
                    }

                    if (dt.Rows[i]["type_code"].ToString().StartsWith("MTA-"))
                    {
                        isRestriction = true;
                    }
                }
                gvCart.DataSource = dt;
                gvCart.DataBind();

                int cnt = gvCart.Rows.Count;
                lblCnt.Text = " (" + cnt.ToString() + (cnt == 1 ? " item)" : " items)");
            }

            pnlSMTA.Visible = isSMTA;
            if (isSMTA)
            {
                SMTAIds         = SMTAIds.Substring(2);
                lblSMTAIds.Text = "(The items above flagged as SMTA are " + SMTAIds + ")";
            }

            gvCart.Columns[7].Visible = isRestriction;

            lblShippingName.Text = r.Firstname + " " + r.Lastname;
            lblShipping1.Text    = r.Addr1_s;
            lblShipping2.Text    = r.Addr2_s;
            if (lblShipping2.Text.Trim() == "")
            {
                lblShipping2.Visible = false;
            }
            else
            {
                lblShipping2.Text = lblShipping2.Text + "<br />";
            }
            lblShipping3.Text = r.Addr3_s;
            if (lblShipping3.Text.Trim() == "")
            {
                lblShipping3.Visible = false;
            }
            else
            {
                lblShipping3.Text = lblShipping3.Text + "<br />";
            }
            lblShipping4.Text        = r.City_s + ", " + r.State_s + " " + r.PostalIndex_s + ",  " + r.Country_s;
            lblShippingPhone.Text    = r.Phone;
            lblShippingAltPhone.Text = r.AltPhone;
            if (lblShippingAltPhone.Text.Trim() == "")
            {
                tr_altPhone.Visible = false;
            }
            lblShippingFax.Text = r.Fax;
            if (lblShippingFax.Text.Trim() == "")
            {
                tr_fax.Visible = false;
            }

            if (r.CarrierAcct.Trim() != "")
            {
                lblCarrier.Visible = true;
                lblCarrier.Text    = "<br /><b>" + "Your account for expediating this order is: Carrier - " + r.Carrier + " with account number - " + r.CarrierAcct + "</b>.<br />";
            }
            else
            {
                lblCarrier.Visible = false;
            }

            lblConfirmEmail.Text = "Confirmation of order will be sent to: " + r.Email;
            if (UserManager.IsAnonymousUser(UserManager.GetUserName()))
            {
                lblConfirmEmail.Visible = r.EmailOrder;
            }
            else
            {
                lblConfirmEmail.Visible = Toolkit.ToBoolean(UserManager.GetUserPref("EmailOrder"), false);
            }

            for (int i = 0; i < c.AccessionIDs.Count; i++)
            {
                _itemNotes.Add(c.AccessionIDs[i].ToString(), "");
            }
            ViewState["item_notes"] = _itemNotes;
            if (!hasFootNote)
            {
                lblFootNote.Visible = false;
            }
            if (hasComments)
            {
                pnlPlaceOrder.FindControl("ShowHideButton").Visible = true;
            }
            else
            {
                pnlPlaceOrder.FindControl("ShowHideButton").Visible = false;
            }
        }
Пример #2
0
        protected void gvCart_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.DataItemIndex > -1)
            {
                var    accessionID      = Toolkit.ToInt32(((DataRowView)e.Row.DataItem)["accession_id"], -1);
                var    lbl              = e.Row.FindControl("lblFormDistributed") as Label;
                var    c                = Cart.Current;
                string distributionForm = c.FindByAccessionID(accessionID).DistributionFormCode;
                lbl.Text = CartItem.GetMaterialDescription(distributionForm);

                var lblSign1 = e.Row.FindControl("lblNoteSign1") as Label;
                var lblSign2 = e.Row.FindControl("lblNoteSign2") as Label;

                var lblAvailCmt = e.Row.FindControl("lblAvailCmt") as Label;
                var ibtnPlus    = e.Row.FindControl("btnPlus") as ImageButton;
                var ibtnMinus   = e.Row.FindControl("btnMinus") as ImageButton;

                var lblFormD2  = e.Row.FindControl("lblFormD2") as Label;
                var ibtnPlusF  = e.Row.FindControl("btnPlusF") as ImageButton;
                var ibtnMinusF = e.Row.FindControl("btnMinusF") as ImageButton;

                // display footnote
                //if (distributionForm == "CT")
                //{
                //    hasFootNote = true;
                //    string note = " You will receive <i>Unrooted cuttings</i> not <i>Rooted plants</i> unless specific arrangements have been made with the curator.";

                //     lblSign1.Visible = true;
                //    //lblSign1.ToolTip = note.Replace("<i>", "").Replace("</i>", "");

                //    lblFootNote.Visible = true;
                //    if (!isCu)
                //    {
                //        lblFootNote.Text += "&nbsp;<font color='red'><b><small>! </b></small></font>" + note + "<br />";
                //        isCu = true;
                //    }
                //}

                string noteCutting = "You will receive <i>Unrooted cuttings</i> not <i>Rooted plants</i> unless specific arrangements have been made with the curator.";
                if (distributionForm == "CT")
                {
                    hasComments          = true;
                    lblFormD2.Visible    = true;
                    e.Row.Cells[5].Width = 165;
                    lblFormD2.Text       = "<br />" + noteCutting;
                    ibtnMinusF.Visible   = true;
                }

                //string statusCode = "", statusNote = "";
                //using (var sd = UserManager.GetSecureData(false))
                //{
                //    var dtAvail = sd.GetData("web_lookup_availability", ":accessionid=" + accessionID, 0, 0).Tables["web_lookup_availability"];

                //    foreach (DataRow dr in dtAvail.Rows)
                //    {
                //        statusCode = dr["availability_status_code"].ToString();
                //        statusNote = dr["availability_status_note"].ToString();

                //        if (statusCode == "WEED")
                //        {
                //            hasFootNote = true;
                //            var siteName = ((DataRowView)e.Row.DataItem)["site_code"].ToString();
                //            var siteID = ((DataRowView)e.Row.DataItem)["site_id"].ToString();

                //            string note = " <font color='red'><b>This accession is a restricted noxious weed</b></font>, contact <a href='site.aspx?id=" + siteID + "'>" + siteName + "</a> for availability.";

                //            lblSign2.Visible = true;
                //            lblFootNote.Visible = true;
                //            if (!isWeed)
                //            {
                //                lblFootNote.Text += "&nbsp;<font color='red'><b><small>+ </b></small></font>" + note + "<br />";
                //                isWeed = true;
                //            }
                //            break;
                //        }
                //    }
                //}

                using (var sd = UserManager.GetSecureData(true))
                {
                    var dtAvilCmt = sd.GetData("web_accessiondetail_action_note", ":actionName=" + "''AVAIL_CMT', 'SMTA''" + ";:accessionid=" + accessionID, 0, 0).Tables["web_accessiondetail_action_note"];

                    if (dtAvilCmt.Rows.Count > 0)
                    {
                        hasComments          = true;
                        lblAvailCmt.Visible  = true;
                        e.Row.Cells[1].Width = 200;
                        lblAvailCmt.Text     = "<br />" + dtAvilCmt.Rows[0]["note"].ToString();
                        ibtnMinus.Visible    = true;
                    }
                }

                if (e.Row.Cells[7].Text == "MTA-SMTA")
                {
                    e.Row.Cells[7].BackColor = System.Drawing.Color.Yellow;
                }
            }
        }
Пример #3
0
        private void bindData()
        {
            Cart c = Cart.Current;

            using (SecureData sd = new SecureData(false, UserManager.GetLoginToken(true))) {
                var ds = sd.GetData("web_cartview", ":idlist=" + Toolkit.Join(c.AccessionIDs.ToArray(), ",", ""), 0, 0);

                var dt = ds.Tables["web_cartview"];

//                using (DataManager dm = sd.BeginProcessing(true)) {


//                    DataTable dt = dm.Read(
//DataManager.ExpandIntegerList(
//@"
//select
//    0 as quantity,
//    a.accession_id,
//    concat(coalesce(a.accession_number_part1,''), ' ', coalesce(convert(varchar, a.accession_number),''), ' ', coalesce(a.accession_number_part3,'')) as pi_number,
//    a.site_code,
//    (select cvl.description from code_value cv left join code_value_lang cvl on cv.code_value_id = cvl.code_value_id where cv.code_group_code = 70 and cv.value = a.initial_material_type) as distributed_type,
//    (select TOP 1 name from accession_name an where a.accession_id = an.accession_id and plant_name_rank = (select MIN(plant_name_rank) from accession_name an2 where a.accession_id = an2.accession_id)) as top_name,
//    (select top 1 i.standard_distribution_quantity from inventory i where i.accession_id = a.accession_id and i.is_distributable = 'Y') as standard_distribution_quantity,
//    t.taxonomy_id,
//    t.name as taxonomy_name
//from
//    accession a left join taxonomy t
//		on a.taxonomy_id = t.taxonomy_id
//where
//    a.accession_id in (:idlist)
//", ":idlist", c.AccessionIDs));
                //}

                // HACK: need to push in the quantity from the cart object
                // we can't do this as a join between accession and sys_user_cart_item
                // because an anonymous user won't have any records in sys_user_cart_item.

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    CartItem ci = c.FindByAccessionID(dt.Rows[i], "accession_id");
                    if (ci != null)
                    {
                        //dt.Rows[i]["quantity"] = ci.Quantity; //Laura Temp
                    }
                }

                gvCart.DataSource = dt;
                gvCart.DataBind();

                if (gvCart.Rows.Count == 0)
                {
                    hlCheckout.Visible = false;
                }
                else
                {
                    if (UserManager.IsAnonymousUser(UserManager.GetUserName()))
                    {
                        hlCheckout.NavigateUrl = "~/login.aspx?action=checkout";
                    }
                    else
                    {
                        hlCheckout.NavigateUrl = "~/userinfor.aspx?action=checkout";
                    }

                    int cnt = gvCart.Rows.Count;
                    lblCnt.Text = " (" + cnt.ToString() + (cnt == 1 ? " item)" : " items)");
                }

                lnkPrevious.NavigateUrl  = Request.Params["HTTP_REFERER"];
                ViewState["previousURL"] = lnkPrevious.NavigateUrl;
            }
        }