private void BindProductbyproid() { DataTable dt = new DataTable(); dt = objProduct.GetProduct(Convert.ToInt32(Request.QueryString["proid"])); reponeitemdetails.DataSource = dt; reponeitemdetails.DataBind(); dt = objaccess.GetDatatable("select * from tblProduct where ProductID='" + Request.QueryString["id"] + "' "); if (dt.Rows.Count > 0) { labelDescription.Text = dt.Rows[0]["Description"].ToString(); } }
public void AddOrder() { if (cityid != 0 && Cusid != 0 && orderid != "" && orderid != null && deliverycharge != "") { double amountMain = 0; DataTable dtvalue = objaccess.GetDatatable("select * from CartMaster where CustomerID=" + Cusid + " "); #region Addorder if (dtvalue.Rows.Count > 0) { DataTable dtaddress = objaccess.GetDatatable("Select * from tblAddressMaster where Customer_ID='" + Cusid + "' and Isactive='true' "); if (dtaddress.Rows.Count > 0) { name = dtaddress.Rows[0]["Name"].ToString(); mobile = dtaddress.Rows[0]["Mobile_No"].ToString(); address = dtaddress.Rows[0]["Address"].ToString(); Country = dtaddress.Rows[0]["Country"].ToString(); state = dtaddress.Rows[0]["State"].ToString(); city = dtaddress.Rows[0]["City"].ToString(); zip = dtaddress.Rows[0]["Zip"].ToString(); landmark = dtaddress.Rows[0]["Landmark"].ToString(); locality = dtaddress.Rows[0]["Locality"].ToString(); Alternatemobileno = dtaddress.Rows[0]["Alternate_MobileNo"].ToString(); } foreach (DataRow row in dtvalue.Rows) { amountMain = amountMain + Convert.ToDouble(row["Totalamount"].ToString()); } int orderID = objorder.AddEditOrder(0, Convert.ToInt32(Cusid), "Pending", Convert.ToBoolean(0), "Cash On Devilary", cityid, deliverycharge, orderid, amountMain.ToString(), System.DateTime.Now.ToString(), name, mobile, address, Country, state, city, zip, locality, landmark, Alternatemobileno); if (orderID > 0) { foreach (DataRow row in dtvalue.Rows) { string cartID = row["AddCart_Id"].ToString(); string productID = row["ProductID"].ToString(); string qty = row["Quantity"].ToString(); string amount = row["Totalamount"].ToString(); DataTable dtproduct = objproduct.GetProduct(Convert.ToInt32(productID)); if (dtproduct.Rows.Count > 0) { string productname = dtproduct.Rows[0]["title"].ToString(); string weight = dtproduct.Rows[0]["weight"].ToString(); decimal price = Convert.ToDecimal(dtproduct.Rows[0]["Price"]); decimal Discount = Convert.ToDecimal(dtproduct.Rows[0]["Discount"]); decimal Afterdiscount = Convert.ToDecimal(dtproduct.Rows[0]["AfterDiscount"]); decimal taxrate = Convert.ToDecimal(dtproduct.Rows[0]["TaxRate"]); decimal totalamount = Convert.ToDecimal(dtproduct.Rows[0]["Total_Amount"]); string DeliveryCharge = dtproduct.Rows[0]["DeliveryCharge"].ToString(); string productImage = dtproduct.Rows[0]["ImageUrl"].ToString(); string sourcePath = @"C:\inetpub\wwwroot\gartak.codunite.com\images\Product\actual\" + productImage; string destinationPath = @"C:\inetpub\wwwroot\gartak.codunite.com\images\PurchaseProductImage\" + productImage; //string sourcePath = @"C:\inetpub\wwwroot\gartak.codunite.com\images\Product\actual"; //string destinationPath = @"C:\inetpub\wwwroot\gartak.codunite.com\images\PurchaseProductImage"; File.Copy(sourcePath, destinationPath, true); objorderdetails.AddEditOrderDetail(0, Cusid, Convert.ToInt32(productID), orderID, Convert.ToInt32(qty), amount, System.DateTime.Now.ToString("yyyyMMdd"), orderid, productname, weight, price, Discount, Afterdiscount, taxrate, totalamount, DeliveryCharge, productImage); objaccess.ExecuteQuery("delete from CartMaster where CustomerID=" + Cusid + " and AddCart_Id=" + cartID); //return value } else { DataTable dts = MasterMassage("Status", "false", "Message", "Some issue with find Profuct."); HttpContext.Current.Response.Write(JsonConvert.SerializeObject(dts, Newtonsoft.Json.Formatting.Indented)); } } string querygetDetails = "select Convert(nvarchar, OrderDetailID) as OrderDetailID, Convert(nvarchar, CustomerID) as CustomerID, Convert(nvarchar, ProductID) as ProductID,Convert(nvarchar, ID) as OrderID, DevilaryAddress,'true' as Status,'Success' as Message from tblOrderDetail where orderno=" + orderid + " "; DataTable dt = objaccess.GetDatatable(querygetDetails); HttpContext.Current.Response.Write(JsonConvert.SerializeObject(dt, Newtonsoft.Json.Formatting.Indented)); } } else { dt = MasterMassage("Status", "false", "Message", "Your Cart Is Empty."); HttpContext.Current.Response.Write(JsonConvert.SerializeObject(dt, Newtonsoft.Json.Formatting.Indented)); } #endregion } else { dt = MasterMassage("Status", "false", "Message", "CityId CustomerID and Delivery Charge Is required"); HttpContext.Current.Response.Write(JsonConvert.SerializeObject(dt, Newtonsoft.Json.Formatting.Indented)); } }
private void bindProduct() { if (Request.QueryString["fid"] != null) { Label1.Text = "Featured"; dt = objProduct.GetProductFeatured(0); } else if (Request.QueryString["pid"] != null) { Label1.Text = "Popular"; dt = objProduct.GetProductPopular(0); } else if (Request.QueryString["nid"] != null) { Label1.Text = "New"; dt = objProduct.GetProductLatest(0); } else if (Request.QueryString["sid"] != null) { Label1.Text = "Search"; dt = objProduct.GetProduct(Convert.ToInt32(Request.QueryString["sid"])); } else if (Request.QueryString["scid"] != null) { // Label1.Text = Convert.ToString(Request.QueryString["title"]); dt = objProduct.GetProductBySubCategoryID(Convert.ToInt32(Request.QueryString["scid"]), true); DataTable dt2 = new DataTable(); dt2 = objSubCategory.GetSubCategory(Convert.ToInt32(Request.QueryString["scid"])); Label1.Text = Convert.ToString(dt2.Rows[0]["Title"]); ltrDescription.Text = Convert.ToString(dt2.Rows[0]["Description"]); if (dt2.Rows.Count > 0) { ((HtmlTitle)Master.FindControl("_metaTitle")).Text = dt2.Rows[0]["MetaTitle"].ToString(); ((HtmlMeta)Master.FindControl("_metaKeywords")).Attributes.Add("Content", dt2.Rows[0]["MetaKeyword"].ToString()); ((HtmlMeta)Master.FindControl("_metaDescription")).Attributes.Add("Content", dt2.Rows[0]["MetaDescription"].ToString()); } } else if (Request.QueryString["cid"] != null) { // Label1.Text = Convert.ToString(Request.QueryString["title"]); dt = objProduct.GetProductByCategoryID(Convert.ToInt32(Request.QueryString["cid"])); DataTable dt2 = new DataTable(); dt2 = objCategory.GetCategory(Convert.ToInt32(Request.QueryString["cid"])); Label1.Text = Convert.ToString(dt2.Rows[0]["Title"]); ltrDescription.Text = Convert.ToString(dt2.Rows[0]["Description"]); if (dt2.Rows.Count > 0) { ((HtmlTitle)Master.FindControl("_metaTitle")).Text = dt2.Rows[0]["MetaTitle"].ToString(); ((HtmlMeta)Master.FindControl("_metaKeywords")).Attributes.Add("Content", dt2.Rows[0]["MetaKeyword"].ToString()); ((HtmlMeta)Master.FindControl("_metaDescription")).Attributes.Add("Content", dt2.Rows[0]["MetaDescription"].ToString()); } } else if (Request.QueryString["search"] != null) { Label1.Text = Convert.ToString(Request.QueryString["search"]); dt = objProduct.GetProductByProductName((Request.QueryString["search"].ToString())); } else { Label1.Text = "Popular"; dt = objProduct.GetProductPopular(0); } if (dt.Rows.Count > 0) { _PagedDataSource.DataSource = dt.DefaultView; _PagedDataSource.AllowPaging = true; _PagedDataSource.PageSize = 8; if (currentPage >= 0) { _PagedDataSource.CurrentPageIndex = currentPage; ViewState["TotalPages"] = _PagedDataSource.PageCount; this.btn_first.Enabled = !_PagedDataSource.IsFirstPage; this.btn_last.Enabled = !_PagedDataSource.IsFirstPage; this.btn_next.Enabled = !_PagedDataSource.IsLastPage; this.btn_last.Enabled = !_PagedDataSource.IsLastPage; repProducts.DataSource = _PagedDataSource; repProducts.DataBind(); this.doPaging(); } } }
public void AddOrder() { if (cityid != 0 && Cusid != 0 && orderid != "" && orderid != null && productid != "" && productid != null && quantity != "" && quantity != null && Amount != "" && Amount != null && deliverycharge != "") { #region address DataTable dtaddress = objaccess.GetDatatable("Select * from tblAddressMaster where Customer_ID=" + Cusid + " and Isactive='true' "); if (dtaddress.Rows.Count > 0) { name = dtaddress.Rows[0]["Name"].ToString(); mobile = dtaddress.Rows[0]["Mobile_No"].ToString(); address = dtaddress.Rows[0]["Address"].ToString(); Country = dtaddress.Rows[0]["Country"].ToString(); state = dtaddress.Rows[0]["State"].ToString(); city = dtaddress.Rows[0]["City"].ToString(); zip = dtaddress.Rows[0]["Zip"].ToString(); landmark = dtaddress.Rows[0]["Landmark"].ToString(); locality = dtaddress.Rows[0]["Locality"].ToString(); Alternatemobileno = dtaddress.Rows[0]["Alternate_MobileNo"].ToString(); } #endregion DataTable dtproduct = objproduct.GetProduct(Convert.ToInt32(productid)); if (dtaddress.Rows.Count > 0) { string productname = dtproduct.Rows[0]["title"].ToString(); string weight = dtproduct.Rows[0]["weight"].ToString(); decimal price = Convert.ToDecimal(dtproduct.Rows[0]["Price"]); decimal Discount = Convert.ToDecimal(dtproduct.Rows[0]["Discount"]); decimal Afterdiscount = Convert.ToDecimal(dtproduct.Rows[0]["AfterDiscount"]); decimal taxrate = Convert.ToDecimal(dtproduct.Rows[0]["TaxRate"]); decimal totalamount = Convert.ToDecimal(dtproduct.Rows[0]["Total_Amount"]); string DeliveryCharge = dtproduct.Rows[0]["DeliveryCharge"].ToString(); string productImage = dtproduct.Rows[0]["ImageUrl"].ToString(); int orderID = objorder.AddEditOrder(0, Cusid, "Pending", Convert.ToBoolean(0), "Cash On Devilary", cityid, deliverycharge, orderid, Amount, DelivaryDate, name, mobile, address, Country, state, city, zip, locality, landmark, Alternatemobileno); if (orderID > 0) { int OrderID = objaccess.ExecuteIntScalar("select ID From tblorder Where OrderID=" + orderid + " "); string sourcePath = @"C:\inetpub\wwwroot\gartak.codunite.com\images\Product\actual\" + productImage; string destinationPath = @"C:\inetpub\wwwroot\gartak.codunite.com\images\PurchaseProductImage\" + productImage; File.Copy(sourcePath, destinationPath, true); objorderdetails.AddEditOrderDetail(0, Cusid, Convert.ToInt32(productid), OrderID, Convert.ToInt32(quantity), Amount, DelivaryDate, orderid, productname, weight, price, Discount, Afterdiscount, taxrate, totalamount, DeliveryCharge, productImage); dt = MasterMassage("Status", "true", "Message", "Thank you for Your Order Your Order Successfully Placed."); HttpContext.Current.Response.Write(JsonConvert.SerializeObject(dt, Newtonsoft.Json.Formatting.Indented)); } else { dt = MasterMassage("Status", "false", "Message", "Some Issue With Add Order."); HttpContext.Current.Response.Write(JsonConvert.SerializeObject(dt, Newtonsoft.Json.Formatting.Indented)); } } else { dt = MasterMassage("Status", "false", "Message", "Some Issue With Product."); HttpContext.Current.Response.Write(JsonConvert.SerializeObject(dt, Newtonsoft.Json.Formatting.Indented)); } } else { dt = MasterMassage("Status", "false", "Message", "CustomerID, ProductID, Amount,Delivery Charge & Quantity Is required"); HttpContext.Current.Response.Write(JsonConvert.SerializeObject(dt, Newtonsoft.Json.Formatting.Indented)); } }