Esempio n. 1
0
    protected void btnSave_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            ds_mainTableAdapters.listingTableAdapter listingTA = new ds_mainTableAdapters.listingTableAdapter();
            ds_main.listingDataTable listingDT = new ds_main.listingDataTable();
            ds_main.listingRow       listingR  = listingDT.NewlistingRow();

            listingR["listing_id"]    = tbListingID.Text;
            listingR["num_of_images"] = tbNumOfImages.Text;
            //listingR["ts"] = tbTimeStamp.Text;
            //listingR["path"] = tbPath.Text;
            listingDT.Rows.Add(listingR);

            listingTA.Update(listingDT);

            if (cbSale.Checked)
            {
                ds_mainTableAdapters.x_listing_typeTableAdapter x_listing_typeTA = new ds_mainTableAdapters.x_listing_typeTableAdapter();
                ds_main.x_listing_typeDataTable x_listing_typeDT = new ds_main.x_listing_typeDataTable();
                ds_main.x_listing_typeRow       x_listing_typeR  = x_listing_typeDT.Newx_listing_typeRow();
                x_listing_typeR.listing_id = Convert.ToInt32(tbListingID.Text);
                x_listing_typeR.type_id    = 100;
                x_listing_typeR.sort       = MLS.getMaxSortByTypeID(100) + 1;
                x_listing_typeDT.Rows.Add(x_listing_typeR);
                x_listing_typeTA.Update(x_listing_typeDT);
            }

            if (cbRental.Checked)
            {
                ds_mainTableAdapters.x_listing_typeTableAdapter x_listing_typeTA = new ds_mainTableAdapters.x_listing_typeTableAdapter();
                ds_main.x_listing_typeDataTable x_listing_typeDT = new ds_main.x_listing_typeDataTable();
                ds_main.x_listing_typeRow       x_listing_typeR  = x_listing_typeDT.Newx_listing_typeRow();
                x_listing_typeR.listing_id = Convert.ToInt32(tbListingID.Text);
                x_listing_typeR.type_id    = 200;
                x_listing_typeR.sort       = MLS.getMaxSortByTypeID(200) + 1;
                x_listing_typeDT.Rows.Add(x_listing_typeR);
                x_listing_typeTA.Update(x_listing_typeDT);
            }

            if (cbSale.Checked)
            {
                Response.Redirect("./listings.aspx?type_id=100");
            }
            else if (cbRental.Checked)
            {
                Response.Redirect("./listings.aspx?type_id=200");
            }
        }
    }
Esempio n. 2
0
    protected void btnSave_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            ds_mainTableAdapters.listingTableAdapter listingTA = new ds_mainTableAdapters.listingTableAdapter();
            ds_main.listingDataTable listingDT = listingTA.GetDataByID(Convert.ToInt32(Request.QueryString["id"].ToString()));
            listingDT.Rows[0]["selling_point"] = tbSellingPoint.Text;
            //listingDT.Rows[0]["price"] = tbPrice.Text.Replace("$", "");
            listingDT.Rows[0]["listing_id"]    = tbListingID.Text;
            listingDT.Rows[0]["num_of_images"] = tbNumOfImages.Text;
            //listingDT.Rows[0]["ts"] = tbTimeStamp.Text;
            //listingDT.Rows[0]["path"] = tbPath.Text;
            listingDT.Rows[0]["bed"]     = tbBed.Text;
            listingDT.Rows[0]["bath"]    = tbBath.Text;
            listingDT.Rows[0]["style"]   = ddlStyle.SelectedValue;
            listingDT.Rows[0]["address"] = tbAddress.Text;
            listingDT.Rows[0]["city"]    = tbCity.Text;
            listingDT.Rows[0]["zip"]     = tbZip.Text;
            Debug.WriteLine(RTESafe(Request.Form["message"].ToString()));
            listingDT.Rows[0]["description"] = RTESafe(Request.Form["message"].ToString());
            //bool featuredUpdated = false;
            if (cbFeatured.Checked)
            {
                //if (listingDT.Rows[0]["featured"].ToString() == "")
                //{
                //    featuredUpdated = true;
                //}
                //else
                //{
                //    if (!Convert.ToBoolean(listingDT.Rows[0]["featured"].ToString()))
                //    {
                //        featuredUpdated = true;
                //    }
                //}
                listingDT.Rows[0]["featured"]      = 1;
                listingDT.Rows[0]["featured_sort"] = MLS.getMaxFeaturedSort() + 1;
            }
            else
            {
                //if (listingDT.Rows[0]["featured"].ToString() == "")
                //{
                //    featuredUpdated = false;
                //}
                //else
                //{
                //    if (Convert.ToBoolean(listingDT.Rows[0]["featured"].ToString()))
                //    {
                //        featuredUpdated = true;
                //    }
                //}
                listingDT.Rows[0]["featured"] = 0;
            }

            listingDT.Rows[0]["status"] = ddlStatus.SelectedValue;



            listingTA.Update(listingDT);

            int sort = 0;
            ds_mainTableAdapters.x_listing_typeTableAdapter x_listing_typeTA = new ds_mainTableAdapters.x_listing_typeTableAdapter();

            if (cbSale.Checked)
            {
                ds_main.x_listing_typeDataTable x_listing_typeDT = x_listing_typeTA.GetDataByListingIDTypeID(Convert.ToInt32(tbListingID.Text), 100);
                if (x_listing_typeDT.Rows.Count > 0)
                {
                    x_listing_typeDT.Rows[0]["price"] = Convert.ToDecimal(tbPrice.Text.Replace("$", ""));
                    x_listing_typeTA.Update(x_listing_typeDT);
                }
                else//Not listed as 'Sale'. So add it!
                {
                    x_listing_typeTA.InsertData(Convert.ToInt32(Request.QueryString["id"].ToString()),
                                                100,
                                                Convert.ToDecimal(tbPrice.Text.Replace("$", "")),
                                                MLS.getMaxSortByTypeID(100) + 1);
                }
            }
            else
            {
                x_listing_typeTA.DeleteXListingTypeByListingIDTypeID(Convert.ToInt32(Request.QueryString["id"].ToString()), 100);
            }

            if (cbRental.Checked)
            {
                ds_main.x_listing_typeDataTable x_listing_typeDT = x_listing_typeTA.GetDataByListingIDTypeID(Convert.ToInt32(tbListingID.Text), 200);
                if (x_listing_typeDT.Rows.Count > 0)
                {
                    x_listing_typeDT.Rows[0]["price"] = Convert.ToDecimal(tbRent.Text.Replace("$", ""));
                    x_listing_typeTA.Update(x_listing_typeDT);
                }
                else//Not listed as 'Rental'. So add it!
                {
                    x_listing_typeTA.InsertData(Convert.ToInt32(Request.QueryString["id"].ToString()),
                                                200,
                                                Convert.ToDecimal(tbRent.Text.Replace("$", "")),
                                                MLS.getMaxSortByTypeID(200) + 1);
                }
            }
            else
            {
                x_listing_typeTA.DeleteXListingTypeByListingIDTypeID(Convert.ToInt32(Request.QueryString["id"].ToString()), 200);
            }

            MLS.InsertModifiedDate();


            //ds_main.x_listing_typeDataTable x_listing_typeDT = x_listing_typeTA.GetDataByListingID(Convert.ToInt32(tbListingID.Text));
            //if (x_listing_typeDT.Rows.Count > 0)
            //    sort = Convert.ToInt32(x_listing_typeDT.Rows[0]["sort"].ToString());

            //x_listing_typeTA.DeleteXListingTypeByListingID(Convert.ToInt32(Request.QueryString["id"].ToString()));

            //if (cbSale.Checked)
            //{
            //    x_listing_typeTA.InsertData(Convert.ToInt32(Request.QueryString["id"].ToString()),
            //                                100,
            //                                Convert.ToDecimal(tbPrice.Text.Replace("$", "")),
            //                                MLS.getMaxSortByTypeID(100) + 1);

            //    //ds_main.x_listing_typeDataTable x_listing_typeDT = new ds_main.x_listing_typeDataTable();
            //    //ds_main.x_listing_typeRow x_listing_TypeR = x_listing_typeDT.Newx_listing_typeRow();
            //    //x_listing_TypeR.listing_id = Convert.ToInt32(Request.QueryString["id"].ToString());
            //    //x_listing_TypeR.type_id = 100;
            //    //x_listing_TypeR.price = Convert.ToDecimal(tbPrice.Text.Replace("$", ""));
            //    //x_listing_TypeR.sort = MLS.getMaxSortByTypeID(100)+1;
            //    //x_listing_typeDT.Addx_listing_typeRow(x_listing_TypeR);
            //    //x_listing_typeTA.Update(x_listing_typeDT);
            //}

            //if (cbRental.Checked)
            //{
            //    x_listing_typeTA.InsertData(Convert.ToInt32(Request.QueryString["id"].ToString()),
            //                200,
            //                Convert.ToDecimal(tbPrice.Text.Replace("$", "")),
            //                MLS.getMaxSortByTypeID(200) + 1);

            //    //ds_main.x_listing_typeDataTable x_listing_typeDT = new ds_main.x_listing_typeDataTable();
            //    //ds_main.x_listing_typeRow x_listing_TypeR = x_listing_typeDT.Newx_listing_typeRow();
            //    //x_listing_TypeR.listing_id = Convert.ToInt32(Request.QueryString["id"].ToString());
            //    //x_listing_TypeR.type_id = 200;
            //    //x_listing_TypeR.sort = MLS.getMaxSortByTypeID(200) + 1;
            //    //x_listing_TypeR.price = Convert.ToDecimal(tbRent.Text.Replace("$", ""));
            //    //x_listing_typeDT.Addx_listing_typeRow(x_listing_TypeR);
            //    //x_listing_typeTA.Update(x_listing_typeDT);

            //}



            //ds_main.x_listing_typeDataTable x_listing_typeDT = x_listing_typeTA.GetDataByListingID(Convert.ToInt32(Request.QueryString["id"].ToString()));
            ////x_listing_typeDT.Rows[0]["price"] = "100";

            //foreach (ds_main.x_listing_typeRow r in x_listing_typeDT.Rows)
            //{
            //    if (r["type_id"].ToString() == "100")
            //    {
            //        if (cbSale.Checked)
            //        {
            //            r["price"] = tbPrice.Text.Replace("$", "");
            //        }
            //    }

            //    if (r["type_id"].ToString() == "200")
            //    {
            //        if (cbRental.Checked)
            //        {
            //            r["price"] = tbRent.Text.Replace("$", "");
            //        }
            //    }
            //}

            //x_listing_typeTA.Update(x_listing_typeDT);
            //if (featuredUpdated)
            //{
            //    Response.Redirect("./");
            //}
            //else if (cbSale.Checked)
            if (cbSale.Checked)
            {
                Response.Redirect("./listings.aspx?type_id=100&id=" + Request.QueryString["id"].ToString());
            }
            else if (cbRental.Checked)
            {
                Response.Redirect("./listings.aspx?type_id=200&id=" + Request.QueryString["id"].ToString());
            }
        }
    }