protected void updateMemberInfoSession()
{
DataTable dtUser = new DataTable();
dtUser = clscon.ReturnDataTable("Login_MembersLogin", new SqlParameter("@Email", txtEmailR.Text.Trim()), new SqlParameter("@Password", ViewState["Password"]));
if (dtUser.Rows.Count > 0)
{
if (dtUser.Rows[0]["memberId"].ToString() == "0")
{
//MsgBox("Invalid EmailId or Password");
//return;
}
else
{
Session["MemberInfo"] = dtUser;
//Response.Redirect("MemberDashboard.aspx");
}
}
//update billing info
clsBSD = new BillingShippingDetails();
DataTable dtBill = new DataTable();
dtBill = clsBSD.BindBillShip();
foreach (DataRow dr in dtUser.Rows)
{
if (dtBill.Rows.Count > 0)
{
clsBSD.RemoveItem(0);
}
clsBSD.AddToBillShipTable(dr["Tinno"].ToString(), dr["Cstno"].ToString(), dr["BCompany"].ToString(), dr["BContact"].ToString(), dr["BAddress1"].ToString(), dr["BAddress2"].ToString(), dr["BCity"].ToString(), dr["BState"].ToString(), dr["BCountry"].ToString(), dr["BZipcode"].ToString(), dr["Name"].ToString(), dr["Email"].ToString(), dr["Company"].ToString(), dr["Contact"].ToString(), dr["Address1"].ToString(), dr["Address2"].ToString(), dr["City"].ToString(), dr["State"].ToString(), dr["Country"].ToString(), dr["Zipcode"].ToString());
}
}
protected void BindOrder()
{
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_InvoiceBillShipDetailsFromID", new SqlParameter("@InvoiceId", invoiceid));
DataTable dt1 = new DataTable();
dt1 = cls.ReturnDataTable("Select_InvoiceWiseOrderDetailsFromID", new SqlParameter("@InvoiceId", invoiceid),
new SqlParameter("@InvoiceDispatchID", invoicedispatchid));
rptOrderDetails.DataSource = dt1;
rptOrderDetails.DataBind();
rptBilling.DataSource = dt;
rptBilling.DataBind();
rptShipping.DataSource = dt;
rptShipping.DataBind();
rptrCutomerTin.DataSource = dt;
rptrCutomerTin.DataBind();
rptHeader.DataSource = dt;
rptHeader.DataBind();
}
protected void BindOrder()
{
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_InvoiceBillShipDetailsFromID", new SqlParameter("@InvoiceId", invoiceid));
DataTable dt1 = new DataTable();
dt1 = cls.ReturnDataTable("Select_InvoiceWiseOrderDetailsFromID", new SqlParameter("@InvoiceId", invoiceid),
new SqlParameter("@InvoiceDispatchID", invoicedispatchid));
rptOrderDetails.DataSource = dt1;
rptOrderDetails.DataBind();
rptBilling.DataSource = dt;
rptBilling.DataBind();
rptShipping.DataSource = dt;
rptShipping.DataBind();
rptrCutomerTin.DataSource = dt;
rptrCutomerTin.DataBind();
if (dt1.Rows.Count > 0)
{
invoiceno = dt1.Rows[0]["InvoiceNumber"].ToString();
}
if (dt.Rows.Count > 0 && dt1.Rows.Count > 0)
{
lblOrderNo.Text = dt.Rows[0]["OrderID"].ToString() + " ( " + dt1.Rows[0]["InvoiceNumber"].ToString() + " ) ";
}
}
protected void BindOrderDetails()
{
dt = cls.ReturnDataTable("Select_OrdersDetailsFromOrderId", new SqlParameter("@InvoiceId", invoiceid));
rptOrder.DataSource = dt;
rptOrder.DataBind();
if (dt.Rows.Count > 0)
{
//txtTracking.Text = dt.Rows[0]["TrackingDetails"].ToString();
// ddlOrderStatus.SelectedValue = dt.Rows[0]["OrderStatus"].ToString();
//if (dt.Rows[0]["PaymentMode"].ToString() == "Cash On Delivery")
//{
// lblPaid.Visible = false;
// chkCOD.Visible = true;
// chkCOD.Checked = Convert.ToBoolean(dt.Rows[0]["IsPaid"]);
//}
//else
//{
// lblPaid.Visible = true;
// chkCOD.Visible = false;
//}
}
//if (ddlOrderStatus.SelectedValue.ToString() == "Dispatched" || ddlOrderStatus.SelectedValue.ToString() == "Delivered")
//{
// BindDrpCourier();
// pnlShip.Visible = true;
// // txtTrackingNo.Text = dt.Rows[0]["TrackingNumber"].ToString();
// //drpCourier.SelectedValue = dt.Rows[0]["CourierName"].ToString();
// //drpCourier.Items.FindByText(dt.Rows[0]["CourierName"].ToString()).Selected=true;
// // drpCourier.Items.FindByText("UPS") = true;
//}
}
protected void BindOrder()
{
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_InvoiceBillShipDetailsFromID", new SqlParameter("@InvoiceId", invoiceid));
if (dt.Rows.Count <= 0)
{
Response.Write("<script language='javascript'> { alert('Invalid OrderId') }</script>");
Response.Write("<script language='javascript'> { self.close() }</script>");
}
else
{
rptOrderDetails.DataSource = dt;
rptOrderDetails.DataBind();
rptBilling.DataSource = dt;
rptBilling.DataBind();
rptShipping.DataSource = dt;
rptShipping.DataBind();
rptrCutomerTin.DataSource = dt;
rptrCutomerTin.DataBind();
}
}
protected void BindOrders()
{
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_AllOrders");
rptr.DataSource = dt;
rptr.DataBind();
}
protected void BindDrpCourier()
{
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_CourierMaster");
drpCourier.DataSource = dt;
drpCourier.DataTextField = "CourierName";
drpCourier.DataValueField = "URL";
drpCourier.DataBind();
}
protected void BindOrder()
{
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_OrdersDetailsFromOrderId", new SqlParameter("@InvoiceId", invoiceid));
if (dt.Rows.Count > 0)
{
lblOrderNo.Text = dt.Rows[0]["OrderId"].ToString();
}
}
protected void BindNewsletter()
{
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_Newsletter");
drpNewsletter.DataSource = dt;
drpNewsletter.DataTextField = "Title";
drpNewsletter.DataValueField = "NewsletterID";
drpNewsletter.DataBind();
}
protected void BindProduct()
{
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_Product");
drpProduct.DataSource = dt;
drpProduct.DataTextField = "ProductName";
drpProduct.DataValueField = "Id";
drpProduct.DataBind();
}
protected void BindSize()
{
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_ProductSize");
cblSizeoption.DataSource = dt;
cblSizeoption.DataTextField = "SizeName";
cblSizeoption.DataValueField = "SizeID";
cblSizeoption.DataBind();
}
protected void rptrProductDetail_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
Panel pnl;
RadioButtonList rdbSize = (RadioButtonList)e.Item.FindControl("rdbSize");
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_AvailableSizeOnId", new SqlParameter("@pid", pid));
rdbSize.DataSource = dt;
rdbSize.DataTextField = "SizeName";
rdbSize.DataValueField = "SizeId";
rdbSize.DataBind();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
if (dr["SizeName"].ToString() == "NA")
{
pnl = new Panel();
pnl = (Panel)e.Item.FindControl("pnlSize");
pnl.Visible = false;
break;
}
}
}
RadioButtonList rdbColor = (RadioButtonList)e.Item.FindControl("rdbColor");
DataTable dt1 = new DataTable();
dt1 = cls.ReturnDataTable("Select_AvailableColorOnId", new SqlParameter("@pid", pid));
rdbColor.DataSource = dt1;
rdbColor.DataTextField = "ColourName";
rdbColor.DataValueField = "ColourID";
rdbColor.DataBind();
if (dt1.Rows.Count > 0)
{
foreach (DataRow dr in dt1.Rows)
{
if (dr["ColourName"].ToString() == "NA")
{
pnl = new Panel();
pnl = (Panel)e.Item.FindControl("pnlColour");
pnl.Visible = false;
break;
}
}
}
}
protected void BindAdvDetail(string id)
{
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_HomeAdvDetailOnId", new SqlParameter("@id", id));
if (dt.Rows.Count > 0)
{
ViewState["ImageBanner"] = dt.Rows[0]["Image"];
}
else
{
Response.Redirect("SubCategory.aspx");
}
}
protected DataTable getStateCityOnPincode(float pincode)
{
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_PinCodeCheckOnId", new SqlParameter("@pincode", pincode));
return(dt);
}
protected void BindNewsletter()
{
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_Newsletter");
rptr.DataSource = dt;
rptr.DataBind();
}
protected void BindData()
{
DataTable dt1 = new DataTable();
dt1 = clscon.ReturnDataTable("Select_CourierMaster");
rptr.DataSource = dt1;
rptr.DataBind();
}
protected void BindData()
{
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_Coupon");
rptr.DataSource = dt;
rptr.DataBind();
}
protected void BindImageBanner(string sid)
{
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_SubCategoryImageMap", new SqlParameter("@SubCategoryId", sid));
if (dt.Rows.Count > 0)
{
mapAreas.ImageUrl = dt.Rows[0]["ImageBanner"].ToString();
BindHotSpot(mapAreas);
}
else
{
mapAreas.Visible = false;
}
//rptrImageMap.DataSource = dt;
//rptrImageMap.DataBind();
}
protected void BindOrders(int MemberId)
{
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_AllInvoiceOnMemberId", new SqlParameter("@MemberId", MemberId));
rptrCart.DataSource = dt;
rptrCart.DataBind();
}
protected void BindImageBanner()
{
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_HomeAddImageMap");
if (dt.Rows.Count > 0)
{
mapAreas.ImageUrl = dt.Rows[0]["ImageBanner"].ToString();
BindHotSpot1(mapAreas);
}
else
{
mapAreas.Visible = false;
}
//rptrImageMap.DataSource = dt;
//rptrImageMap.DataBind();
}
protected void BindCurrentOpenings()
{
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_AllCurrentOpenings");
rptr.DataSource = dt;
rptr.DataBind();
}
protected void btnCheckStatus_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_InvoiceBillShipDetailsFromIDForTracking", new SqlParameter("@ID", txtOrderNumber.Text), new SqlParameter("@EmailId", txtEmailId.Text));
if (dt.Rows.Count > 0)
{
rptOrderDetails.DataSource = dt;
rptOrderDetails.DataBind();
rptBilling.DataSource = dt;
rptBilling.DataBind();
rptShipping.DataSource = dt;
rptShipping.DataBind();
rptrCutomerTin.DataSource = dt;
rptrCutomerTin.DataBind();
invoiceid = dt.Rows[0]["InvoiceId"].ToString();
BindProduct(dt.Rows[0]["InvoiceId"].ToString());
pnlTrack.Visible = true;
if (!string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["CouponName"])))
{
lblCoupon.Text = "Using Voucher Code (" + dt.Rows[0]["CouponName"] + ")";
}
else
{
lblCoupon.Text = "";
}
lblDisPer.Text = "(" + dt.Rows[0]["DiscountPer"] + "%)";
lblDisVal.Text = Math.Round(Convert.ToDouble(dt.Rows[0]["DiscountAmount"])).ToString();
}
else
{
rptOrderDetails.DataSource = null;
rptOrderDetails.DataBind();
pnlTrack.Visible = false;
MsgBox("Enter valid number or Correct Email Id which used in Shipping Address");
}
}
public static void Login(string UserName, string Password)
{
Clsconnection cls = new Clsconnection();
DataTable dtUser = new DataTable();
dtUser = cls.ReturnDataTable("Login_UserLogin", new SqlParameter("@UserName", UserName), new SqlParameter("@Pwd", Password));
UserObject usr = new UserObject((Guid)dtUser.Rows[0]["UserID"], dtUser.Rows[0]["UserName"].ToString());
HttpContext.Current.Session["UserObject"] = usr;
}
protected void BindOrderDetails()
{
dt = cls.ReturnDataTable("Select_InvoiceWiseOrderDetailsFromID", new SqlParameter("@InvoiceId", invoiceid),
new SqlParameter("@InvoiceDispatchID", invoicedispatchid));
rptOrder.DataSource = dt;
rptOrder.DataBind();
if (dt.Rows.Count > 0)
{
drpStatus.SelectedValue = dt.Rows[0]["OrderStatus"].ToString();
orderno = dt.Rows[0]["OrderId"].ToString();
lblInvoiceNo.Text = dt.Rows[0]["InvoiceNumber"].ToString();
txtDate.Text = cls.FormatDate_US_Ind(dt.Rows[0]["InvoiceDate"].ToString());
txtTrackingNo.Text = dt.Rows[0]["TrackingNumber"].ToString();
txtOtherDetails.Text = dt.Rows[0]["OtherDetails"].ToString();
drpCourier.SelectedValue = dt.Rows[0]["URL"].ToString();
invno = dt.Rows[0]["InvoiceNo"].ToString();
lblInvoiceNoMail.Text = "TSM_Invoice_" + orderno + "-" + invno;
}
}
protected void Binduser(string mode)
{
DataTable dtUser = new DataTable();
if (mode == "L")
{
dtUser = cls.ReturnDataTable("Login_MembersLogin", new SqlParameter("@Email", txtEmailL.Text.Trim()), new SqlParameter("@Password", txtPasswordL.Text.Trim()));
Session["Memberid"] = dtUser.Rows[0]["MemberId"].ToString();
}
else
{
//dtUser = cls.ReturnDataTable("Login_MembersLogin", new SqlParameter("@Email", txtEmailR.Text.Trim()), new SqlParameter("@Password", txtPasswordR.Text.Trim()));
}
if (dtUser.Rows.Count > 0 && Convert.ToInt32(dtUser.Rows[0]["MemberId"]) != 0)
{
if (Convert.ToBoolean(dtUser.Rows[0]["IsApproved"]))
{
if (mode == "R")
{
//MailAdminRegistration();
//MailUserRegistration();
}
Session["MemberInfo"] = dtUser;
BindBillingInfo();
Session["CameAgain"] = "1";
BindWishList(Convert.ToInt32(dtUser.Rows[0]["MemberId"]));
if (Session["CameFrom"] != null)
{
if (Session["CameFrom"].ToString() == "CheckOut_Login")
{
Response.Redirect("Register.aspx");
}
else if (Session["CameFrom"].ToString() == "Wishlist")
{
Response.Redirect("WishList.aspx");
}
}
Response.Redirect("Default.aspx");
}
else
{
MsgBox("You are blocked...!!");
return;
}
}
else
{
MsgBox("Invalid Username or Password...!!");
return;
}
}
//Insert into DB functions
protected string InsertIntoDB()
{
clsCart = new clsAddToCart();
long orderid;
A:
orderid = (long)cls.ReturnScaler("Select_MaxOrderID");
if (cls.CheckExistField("CheckExistField", "InvoiceMaster", "OrderId", orderid.ToString(), " and IsActive=1"))
{
goto A;
}
long Memberid = 0;
DataTable dtMember = new DataTable();
dtMember = (DataTable)Session["MemberInfo"];
foreach (DataRow dr in dtMember.Rows)
{
Memberid = Convert.ToInt64(dr["MemberId"]);
}
bool IsPaid = false;
bool IsCOD = false;
double discount = 0;
double discountValue = 0;
if (Session["Discount"] != null)
{
discount = (double)Session["Discount"];
discountValue = (double)Session["DiscountValue"];
}
//Insert into invoice master
Int32 invoiceid;
invoiceid = (Int32)cls.ReturnScaler("Insert_InvoiceMasterForOnlinePay", new SqlParameter("MemberId", Memberid),
new SqlParameter("@OrderId", orderid),
new SqlParameter("@ShippingCharges", "0"),
new SqlParameter("@OrderAmount", clsCart.TotalPrice()),
new SqlParameter("@OrderQty", clsCart.TotalQty()),
new SqlParameter("@PaypalId", ""),
new SqlParameter("@IsPaid", IsPaid),
new SqlParameter("@IsCOD", IsCOD),
new SqlParameter("@PaymentMode", Session["PayMode"].ToString()),
new SqlParameter("@DiscountPer", discount),
new SqlParameter("@DiscountAmount", discountValue),
new SqlParameter("@OriginalAmount", clsCart.TotalPriceWithoutDiscount()));
//Insert into invoice coupon
if (Session["CouponCode"] != null)
{
DataTable dtCoupon = new DataTable();
dtCoupon = cls.ReturnDataTable("Select_CouponOnName", new SqlParameter("@CouponName", Session["CouponCode"].ToString()));
if (dtCoupon.Rows.Count > 0)
{
cls.ExecuteDA("Insert_InvoiceCoupon", new SqlParameter("@InvoiceId", invoiceid),
new SqlParameter("@CouponName", dtCoupon.Rows[0]["CouponName"]),
new SqlParameter("@CriteriaAVal", dtCoupon.Rows[0]["CriteriaAVal"]),
new SqlParameter("@CriteriaBVal", dtCoupon.Rows[0]["CriteriaBVal"]),
new SqlParameter("@CriteriaCVal", dtCoupon.Rows[0]["CriteriaCVal"]));
}
}
//insert into invoice product table
DataTable dt = new DataTable();
dt = clsCart.BindCart();
foreach (DataRow dr in dt.Rows)
{
cls.ExecuteDA("Insert_InvoiceProduct", new SqlParameter("@InvoiceId", invoiceid),
new SqlParameter("@ProductId", Convert.ToInt32(dr["ProductId"])),
new SqlParameter("@CategoryName", dr["CategoryName"]),
new SqlParameter("@SubCategoryName", dr["SubCategoryName"]),
new SqlParameter("@ProductName", dr["ProductName"]),
new SqlParameter("@Productdescp", dr["Productdescp"]),
new SqlParameter("@BrandName", dr["BrandName"]),
new SqlParameter("@SupplierName", dr["SupplierName"]),
new SqlParameter("@Unit", dr["Unit"]),
new SqlParameter("@ColourName", dr["ColourName"]),
new SqlParameter("@SizeName", dr["SizeName"]),
new SqlParameter("@ProductCode", dr["ProductCode"]),
new SqlParameter("@SupplierProductCode", dr["SupplierProductCode"]),
new SqlParameter("@PackSize", dr["PackSize"]),
new SqlParameter("@ProductCost", dr["ProductCost"]),
new SqlParameter("@ProductWeight", dr["ProductWeight"]),
new SqlParameter("@Image", dr["Image"]),
new SqlParameter("@Certification", dr["Certification"]),
new SqlParameter("@Description", dr["Description"]),
new SqlParameter("@Margin", Convert.ToDouble(dr["Margin"])),
new SqlParameter("@SalePrice", Convert.ToDouble(dr["SalePrice"])),
new SqlParameter("@Tax", Convert.ToDouble(dr["Tax"])),
new SqlParameter("@SalesPrice_Incl", Convert.ToDouble(dr["SalesPrice_Incl"])),
new SqlParameter("@MRP", Convert.ToDouble(dr["MRP"])),
new SqlParameter("@Discount", Convert.ToDouble(dr["Discount"])),
new SqlParameter("@CalDiscount", Convert.ToDouble(dr["CalDiscount"])),
new SqlParameter("@ShippingCost", Convert.ToDouble(dr["ShippingCost"])),
new SqlParameter("@FinalSellingPrice", Convert.ToDouble(dr["FinalSellingPrice"])),
new SqlParameter("@TaxFinalPrice", Convert.ToDouble(dr["TaxFinalPrice"])),
new SqlParameter("@Quantity", Convert.ToDouble(dr["Qty"])),
new SqlParameter("@ShippingDays", dr["ShippingDays"]),
new SqlParameter("@IsCOD", Convert.ToBoolean(dr["IsCOD"])));
}
//inserting into billing and delivery details
clsBSD = new BillingShippingDetails();
DataTable dtbilship = new DataTable();
dtbilship = clsBSD.BindBillShip();
foreach (DataRow drow in dtbilship.Rows)
{
ViewState["ToMail"] = drow["SEmail"];
cls.ExecuteDA("Insert_InvoiceBillingShipping", new SqlParameter("@InvoiceId", invoiceid),
new SqlParameter("@Name", drow["Name"]),
new SqlParameter("@Email", drow["Email"]),
new SqlParameter("@Company", drow["Company"]),
new SqlParameter("@Contact", drow["Contact"]),
new SqlParameter("@Address1", drow["Address1"]),
new SqlParameter("@Address2", drow["Address2"]),
new SqlParameter("@City", drow["City"]),
new SqlParameter("@State", drow["State"]),
new SqlParameter("@Country", drow["Country"]),
new SqlParameter("@Zipcode", drow["Zipcode"]),
new SqlParameter("@SName", drow["SName"]),
new SqlParameter("@SEmail", drow["SEmail"]),
new SqlParameter("@SCompany", drow["SCompany"]),
new SqlParameter("@SContact", drow["SContact"]),
new SqlParameter("@SAddress1", drow["SAddress1"]),
new SqlParameter("@SAddress2", drow["SAddress2"]),
new SqlParameter("@SCity", drow["SCity"]),
new SqlParameter("@SState", drow["SState"]),
new SqlParameter("@SCountry", drow["SCountry"]),
new SqlParameter("@SZipcode", drow["SZipcode"]));
}
// Session["OrderId"] = orderid.ToString();
// lblOredrId.Text = orderid.ToString();
setPdfandMail(invoiceid, orderid);
return(orderid.ToString());
}
protected void BindSubCategory(string cid)
{
DataTable dt = new DataTable();
dt = cls.ReturnDataTable("Select_SubCategoryOnCatId", new SqlParameter("@catid", cid));
if (dt.Rows.Count > 0)
{
//binding breadcrumb
DataTable dttile = new DataTable();
dttile = dt.DefaultView.ToTable(true, "ProductCategoryId", "CategoryName");
rptrBreadCrumb.DataSource = dttile;
rptrBreadCrumb.DataBind();
DataTable dt1 = new DataTable();
dt1.Columns.Add("ProductCategoryId1", Type.GetType("System.String"));
dt1.Columns.Add("id1", Type.GetType("System.String"));
dt1.Columns.Add("SubCategoryName1", Type.GetType("System.String"));
dt1.Columns.Add("Image1", Type.GetType("System.String"));
dt1.Columns.Add("ProductCategoryId2", Type.GetType("System.String"));
dt1.Columns.Add("id2", Type.GetType("System.String"));
dt1.Columns.Add("SubCategoryName2", Type.GetType("System.String"));
dt1.Columns.Add("Image2", Type.GetType("System.String"));
dt1.Columns.Add("ProductCategoryId3", Type.GetType("System.String"));
dt1.Columns.Add("id3", Type.GetType("System.String"));
dt1.Columns.Add("SubCategoryName3", Type.GetType("System.String"));
dt1.Columns.Add("Image3", Type.GetType("System.String"));
dt1.Columns.Add("ProductCategoryId4", Type.GetType("System.String"));
dt1.Columns.Add("id4", Type.GetType("System.String"));
dt1.Columns.Add("SubCategoryName4", Type.GetType("System.String"));
dt1.Columns.Add("Image4", Type.GetType("System.String"));
dt1.Columns.Add("ProductCategoryId5", Type.GetType("System.String"));
dt1.Columns.Add("id5", Type.GetType("System.String"));
dt1.Columns.Add("SubCategoryName5", Type.GetType("System.String"));
dt1.Columns.Add("Image5", Type.GetType("System.String"));
dt1.Columns.Add("ProductCategoryId6", Type.GetType("System.String"));
dt1.Columns.Add("id6", Type.GetType("System.String"));
dt1.Columns.Add("SubCategoryName6", Type.GetType("System.String"));
dt1.Columns.Add("Image6", Type.GetType("System.String"));
for (int i = 0; i < dt.Rows.Count; i = i + 6)
{
if (i + 1 < dt.Rows.Count)
{
if (i + 2 < dt.Rows.Count)
{
if (i + 3 < dt.Rows.Count)
{
if (i + 4 < dt.Rows.Count)
{
if (i + 5 < dt.Rows.Count)
{
dt1.Rows.Add(dt.Rows[i]["ProductCategoryId"].ToString(), dt.Rows[i]["id"].ToString(), dt.Rows[i]["SubCategoryName"].ToString(), dt.Rows[i]["Image"].ToString(), dt.Rows[i + 1]["ProductCategoryId"].ToString(), dt.Rows[i + 1]["id"].ToString(), dt.Rows[i + 1]["SubCategoryName"].ToString(), dt.Rows[i + 1]["Image"].ToString(), dt.Rows[i + 2]["ProductCategoryId"].ToString(), dt.Rows[i + 2]["id"].ToString(), dt.Rows[i + 2]["SubCategoryName"].ToString(), dt.Rows[i + 2]["Image"].ToString(), dt.Rows[i + 3]["ProductCategoryId"].ToString(), dt.Rows[i + 3]["id"].ToString(), dt.Rows[i + 3]["SubCategoryName"].ToString(), dt.Rows[i + 3]["Image"].ToString(), dt.Rows[i + 4]["ProductCategoryId"].ToString(), dt.Rows[i + 4]["id"].ToString(), dt.Rows[i + 4]["SubCategoryName"].ToString(), dt.Rows[i + 4]["Image"].ToString(), dt.Rows[i + 5]["ProductCategoryId"].ToString(), dt.Rows[i + 5]["id"].ToString(), dt.Rows[i + 5]["SubCategoryName"].ToString(), dt.Rows[i + 5]["Image"].ToString());
}
else
{
dt1.Rows.Add(dt.Rows[i]["ProductCategoryId"].ToString(), dt.Rows[i]["id"].ToString(), dt.Rows[i]["SubCategoryName"].ToString(), dt.Rows[i]["Image"].ToString(), dt.Rows[i + 1]["ProductCategoryId"].ToString(), dt.Rows[i + 1]["id"].ToString(), dt.Rows[i + 1]["SubCategoryName"].ToString(), dt.Rows[i + 1]["Image"].ToString(), dt.Rows[i + 2]["ProductCategoryId"].ToString(), dt.Rows[i + 2]["id"].ToString(), dt.Rows[i + 2]["SubCategoryName"].ToString(), dt.Rows[i + 2]["Image"].ToString(), dt.Rows[i + 3]["ProductCategoryId"].ToString(), dt.Rows[i + 3]["id"].ToString(), dt.Rows[i + 3]["SubCategoryName"].ToString(), dt.Rows[i + 3]["Image"].ToString(), dt.Rows[i + 4]["ProductCategoryId"].ToString(), dt.Rows[i + 4]["id"].ToString(), dt.Rows[i + 4]["SubCategoryName"].ToString(), dt.Rows[i + 4]["Image"].ToString(), "", "", "", "");
}
}
else
{
dt1.Rows.Add(dt.Rows[i]["ProductCategoryId"].ToString(), dt.Rows[i]["id"].ToString(), dt.Rows[i]["SubCategoryName"].ToString(), dt.Rows[i]["Image"].ToString(), dt.Rows[i + 1]["ProductCategoryId"].ToString(), dt.Rows[i + 1]["id"].ToString(), dt.Rows[i + 1]["SubCategoryName"].ToString(), dt.Rows[i + 1]["Image"].ToString(), dt.Rows[i + 2]["ProductCategoryId"].ToString(), dt.Rows[i + 2]["id"].ToString(), dt.Rows[i + 2]["SubCategoryName"].ToString(), dt.Rows[i + 2]["Image"].ToString(), dt.Rows[i + 3]["ProductCategoryId"].ToString(), dt.Rows[i + 3]["id"].ToString(), dt.Rows[i + 3]["SubCategoryName"].ToString(), dt.Rows[i + 3]["Image"].ToString(), "", "", "", "", "", "", "", "");
}
}
else
{
dt1.Rows.Add(dt.Rows[i]["ProductCategoryId"].ToString(), dt.Rows[i]["id"].ToString(), dt.Rows[i]["SubCategoryName"].ToString(), dt.Rows[i]["Image"].ToString(), dt.Rows[i + 1]["ProductCategoryId"].ToString(), dt.Rows[i + 1]["id"].ToString(), dt.Rows[i + 1]["SubCategoryName"].ToString(), dt.Rows[i + 1]["Image"].ToString(), dt.Rows[i + 2]["ProductCategoryId"].ToString(), dt.Rows[i + 2]["id"].ToString(), dt.Rows[i + 2]["SubCategoryName"].ToString(), dt.Rows[i + 2]["Image"].ToString(), "", "", "", "", "", "", "", "", "", "", "", "");
}
}
else
{
dt1.Rows.Add(dt.Rows[i]["ProductCategoryId"].ToString(), dt.Rows[i]["id"].ToString(), dt.Rows[i]["SubCategoryName"].ToString(), dt.Rows[i]["Image"].ToString(), dt.Rows[i + 1]["ProductCategoryId"].ToString(), dt.Rows[i + 1]["id"].ToString(), dt.Rows[i + 1]["SubCategoryName"].ToString(), dt.Rows[i + 1]["Image"].ToString(), "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "");
}
}
else
{
dt1.Rows.Add(dt.Rows[i]["ProductCategoryId"].ToString(), dt.Rows[i]["id"].ToString(), dt.Rows[i]["SubCategoryName"].ToString(), dt.Rows[i]["Image"].ToString(), "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "");
}
}
rptrSubCategory.DataSource = dt1;
rptrSubCategory.DataBind();
}
else
{
Response.Redirect("Default.aspx");
}
}
protected void BindOrderDetails()
{
dt = cls.ReturnDataTable("Select_OrdersDetailsFromOrderId", new SqlParameter("@InvoiceId", invoiceid));
rptOrder.DataSource = dt;
rptOrder.DataBind();
}
/// <summary>
/// Build DataTable to bind Main Items List
/// </summary>
/// <returns>DataTable</returns>
private DataTable GetDataTable()
{
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
//for sorting if value =1 then sort price from low to high
// if value =2 sort price from high to low
//if value =3 sort name a to z asc
//if value =4 sort name z to a desc
dt = cls.ReturnDataTable("Select_SearchResult", new SqlParameter("@searchtext", srchtext), new SqlParameter("@Flag", Convert.ToInt32(drpSort.SelectedValue.ToString())));
if (ViewState["Display"].ToString() == "Grid")
{
dt1.Columns.Add("id1", Type.GetType("System.String"));
dt1.Columns.Add("ProductName1", Type.GetType("System.String"));
dt1.Columns.Add("ProductName11", Type.GetType("System.String"));
dt1.Columns.Add("Image1", Type.GetType("System.String"));
dt1.Columns.Add("ProductCode1", Type.GetType("System.String"));
dt1.Columns.Add("FinalSellingPrice1", Type.GetType("System.Double"));
dt1.Columns.Add("id2", Type.GetType("System.String"));
dt1.Columns.Add("ProductName2", Type.GetType("System.String"));
dt1.Columns.Add("ProductName22", Type.GetType("System.String"));
dt1.Columns.Add("Image2", Type.GetType("System.String"));
dt1.Columns.Add("ProductCode2", Type.GetType("System.String"));
dt1.Columns.Add("FinalSellingPrice2", Type.GetType("System.Double"));
dt1.Columns.Add("id3", Type.GetType("System.String"));
dt1.Columns.Add("ProductName3", Type.GetType("System.String"));
dt1.Columns.Add("ProductName33", Type.GetType("System.String"));
dt1.Columns.Add("Image3", Type.GetType("System.String"));
dt1.Columns.Add("ProductCode3", Type.GetType("System.String"));
dt1.Columns.Add("FinalSellingPrice3", Type.GetType("System.Double"));
dt1.Columns.Add("id4", Type.GetType("System.String"));
dt1.Columns.Add("ProductName4", Type.GetType("System.String"));
dt1.Columns.Add("ProductName44", Type.GetType("System.String"));
dt1.Columns.Add("Image4", Type.GetType("System.String"));
dt1.Columns.Add("ProductCode4", Type.GetType("System.String"));
dt1.Columns.Add("FinalSellingPrice4", Type.GetType("System.Double"));
dt1.Columns.Add("id5", Type.GetType("System.String"));
dt1.Columns.Add("ProductName5", Type.GetType("System.String"));
dt1.Columns.Add("ProductName55", Type.GetType("System.String"));
dt1.Columns.Add("Image5", Type.GetType("System.String"));
dt1.Columns.Add("ProductCode5", Type.GetType("System.String"));
dt1.Columns.Add("FinalSellingPrice5", Type.GetType("System.Double"));
dt1.Columns.Add("id6", Type.GetType("System.String"));
dt1.Columns.Add("ProductName6", Type.GetType("System.String"));
dt1.Columns.Add("ProductName66", Type.GetType("System.String"));
dt1.Columns.Add("Image6", Type.GetType("System.String"));
dt1.Columns.Add("ProductCode6", Type.GetType("System.String"));
dt1.Columns.Add("FinalSellingPrice6", Type.GetType("System.Double"));
if (dt.Rows.Count > 0)
{
//binding breadcrumb
//DataTable dttile = new DataTable();
//dttile = dt.DefaultView.ToTable(true, "ProductCategoryId", "ProductSubCategoryId", "SubCategoryName", "CategoryName");
//rptrBreadCrumb.DataSource = dttile;
//rptrBreadCrumb.DataBind();
for (int i = 0; i < dt.Rows.Count; i = i + 6)
{
if (i + 1 < dt.Rows.Count)
{
if (i + 2 < dt.Rows.Count)
{
if (i + 3 < dt.Rows.Count)
{
if (i + 4 < dt.Rows.Count)
{
if (i + 5 < dt.Rows.Count)
{
dt1.Rows.Add(dt.Rows[i]["id"].ToString(), dt.Rows[i]["pname"].ToString(), dt.Rows[i]["ProductName"].ToString(), dt.Rows[i]["Image"].ToString(), dt.Rows[i]["ProductCode"].ToString(), dt.Rows[i]["FinalSellingPrice"].ToString(), dt.Rows[i + 1]["id"].ToString(), dt.Rows[i + 1]["pname"].ToString(), dt.Rows[i + 1]["ProductName"].ToString(), dt.Rows[i + 1]["Image"].ToString(), dt.Rows[i + 1]["ProductCode"].ToString(), dt.Rows[i + 1]["FinalSellingPrice"].ToString(), dt.Rows[i + 2]["id"].ToString(), dt.Rows[i + 2]["pname"].ToString(), dt.Rows[i + 2]["ProductName"].ToString(), dt.Rows[i + 2]["Image"].ToString(), dt.Rows[i + 2]["ProductCode"].ToString(), dt.Rows[i + 2]["FinalSellingPrice"].ToString(), dt.Rows[i + 3]["id"].ToString(), dt.Rows[i + 3]["pname"].ToString(), dt.Rows[i + 3]["ProductName"].ToString(), dt.Rows[i + 3]["Image"].ToString(), dt.Rows[i + 3]["ProductCode"].ToString(), dt.Rows[i + 3]["FinalSellingPrice"].ToString(), dt.Rows[i + 4]["id"].ToString(), dt.Rows[i + 4]["pname"].ToString(), dt.Rows[i + 4]["ProductName"].ToString(), dt.Rows[i + 4]["Image"].ToString(), dt.Rows[i + 4]["ProductCode"].ToString(), dt.Rows[i + 4]["FinalSellingPrice"].ToString(), dt.Rows[i + 5]["id"].ToString(), dt.Rows[i + 5]["pname"].ToString(), dt.Rows[i + 5]["ProductName"].ToString(), dt.Rows[i + 5]["Image"].ToString(), dt.Rows[i + 5]["ProductCode"].ToString(), dt.Rows[i + 5]["FinalSellingPrice"].ToString());
}
else
{
dt1.Rows.Add(dt.Rows[i]["id"].ToString(), dt.Rows[i]["pname"].ToString(), dt.Rows[i]["ProductName"].ToString(), dt.Rows[i]["Image"].ToString(), dt.Rows[i]["ProductCode"].ToString(), dt.Rows[i]["FinalSellingPrice"].ToString(), dt.Rows[i + 1]["id"].ToString(), dt.Rows[i + 1]["pname"].ToString(), dt.Rows[i + 1]["ProductName"].ToString(), dt.Rows[i + 1]["Image"].ToString(), dt.Rows[i + 1]["ProductCode"].ToString(), dt.Rows[i + 1]["FinalSellingPrice"].ToString(), dt.Rows[i + 2]["id"].ToString(), dt.Rows[i + 2]["pname"].ToString(), dt.Rows[i + 2]["ProductName"].ToString(), dt.Rows[i + 2]["Image"].ToString(), dt.Rows[i + 2]["ProductCode"].ToString(), dt.Rows[i + 2]["FinalSellingPrice"].ToString(), dt.Rows[i + 3]["id"].ToString(), dt.Rows[i + 3]["pname"].ToString(), dt.Rows[i + 3]["ProductName"].ToString(), dt.Rows[i + 3]["Image"].ToString(), dt.Rows[i + 3]["ProductCode"].ToString(), dt.Rows[i + 3]["FinalSellingPrice"].ToString(), dt.Rows[i + 4]["id"].ToString(), dt.Rows[i + 4]["pname"].ToString(), dt.Rows[i + 4]["ProductName"].ToString(), dt.Rows[i + 4]["Image"].ToString(), dt.Rows[i + 4]["ProductCode"].ToString(), dt.Rows[i + 4]["FinalSellingPrice"].ToString(), "", "", "", "", "", 0);
// dt1.Rows.Add(dt.Rows[i]["id"].ToString(), dt.Rows[i]["pname"].ToString(), dt.Rows[i]["Image"].ToString(), dt.Rows[i]["ProductCode"].ToString(), dt.Rows[i]["FinalSellingPrice"].ToString(), dt.Rows[i + 1]["id"].ToString(), dt.Rows[i + 1]["pname"].ToString(), dt.Rows[i + 1]["Image"].ToString(), dt.Rows[i + 1]["ProductCode"].ToString(), dt.Rows[i + 1]["FinalSellingPrice"].ToString(), dt.Rows[i + 2]["id"].ToString(), dt.Rows[i + 2]["pname"].ToString(), dt.Rows[i + 2]["Image"].ToString(), dt.Rows[i + 2]["ProductCode"].ToString(), dt.Rows[i + 2]["FinalSellingPrice"].ToString(), dt.Rows[i + 3]["id"].ToString(), dt.Rows[i + 3]["pname"].ToString(), dt.Rows[i + 3]["Image"].ToString(), dt.Rows[i + 3]["ProductCode"].ToString(), dt.Rows[i + 3]["FinalSellingPrice"].ToString(), dt.Rows[i + 4]["id"].ToString(), dt.Rows[i + 4]["pname"].ToString(), dt.Rows[i + 4]["Image"].ToString(), dt.Rows[i + 4]["ProductCode"].ToString(), dt.Rows[i + 4]["FinalSellingPrice"].ToString(), "","", "", "", "", 0);
}
}
else
{
// dt1.Rows.Add(dt.Rows[i]["id"].ToString(), dt.Rows[i]["pname"].ToString(), dt.Rows[i]["Image"].ToString(), dt.Rows[i]["ProductCode"].ToString(), dt.Rows[i]["FinalSellingPrice"].ToString(), dt.Rows[i + 1]["id"].ToString(), dt.Rows[i + 1]["pname"].ToString(), dt.Rows[i + 1]["Image"].ToString(), dt.Rows[i + 1]["ProductCode"].ToString(), dt.Rows[i + 1]["FinalSellingPrice"].ToString(), dt.Rows[i + 2]["id"].ToString(), dt.Rows[i + 2]["pname"].ToString(), dt.Rows[i + 2]["Image"].ToString(), dt.Rows[i + 2]["ProductCode"].ToString(), dt.Rows[i + 2]["FinalSellingPrice"].ToString(), dt.Rows[i + 3]["id"].ToString(), dt.Rows[i + 3]["pname"].ToString(), dt.Rows[i + 3]["Image"].ToString(), dt.Rows[i + 3]["ProductCode"].ToString(), dt.Rows[i + 3]["FinalSellingPrice"].ToString(), "", "", "", "", 0, "", "", "", "", 0);
dt1.Rows.Add(dt.Rows[i]["id"].ToString(), dt.Rows[i]["pname"].ToString(), dt.Rows[i]["ProductName"].ToString(), dt.Rows[i]["Image"].ToString(), dt.Rows[i]["ProductCode"].ToString(), dt.Rows[i]["FinalSellingPrice"].ToString(), dt.Rows[i + 1]["id"].ToString(), dt.Rows[i + 1]["pname"].ToString(), dt.Rows[i + 1]["ProductName"].ToString(), dt.Rows[i + 1]["Image"].ToString(), dt.Rows[i + 1]["ProductCode"].ToString(), dt.Rows[i + 1]["FinalSellingPrice"].ToString(), dt.Rows[i + 2]["id"].ToString(), dt.Rows[i + 2]["pname"].ToString(), dt.Rows[i + 2]["ProductName"].ToString(), dt.Rows[i + 2]["Image"].ToString(), dt.Rows[i + 2]["ProductCode"].ToString(), dt.Rows[i + 2]["FinalSellingPrice"].ToString(), dt.Rows[i + 3]["id"].ToString(), dt.Rows[i + 3]["pname"].ToString(), dt.Rows[i + 3]["ProductName"].ToString(), dt.Rows[i + 3]["Image"].ToString(), dt.Rows[i + 3]["ProductCode"].ToString(), dt.Rows[i + 3]["FinalSellingPrice"].ToString(), "", "", "", "", "", 0, "", "", "", "", "", 0);
}
}
else
{
// dt1.Rows.Add(dt.Rows[i]["id"].ToString(), dt.Rows[i]["pname"].ToString(), dt.Rows[i]["Image"].ToString(), dt.Rows[i]["ProductCode"].ToString(), dt.Rows[i]["FinalSellingPrice"].ToString(), dt.Rows[i + 1]["id"].ToString(), dt.Rows[i + 1]["pname"].ToString(), dt.Rows[i + 1]["Image"].ToString(), dt.Rows[i + 1]["ProductCode"].ToString(), dt.Rows[i + 1]["FinalSellingPrice"].ToString(), dt.Rows[i + 2]["id"].ToString(), dt.Rows[i + 2]["pname"].ToString(), dt.Rows[i + 2]["Image"].ToString(), dt.Rows[i + 2]["ProductCode"].ToString(), dt.Rows[i + 2]["FinalSellingPrice"].ToString(), "", "", "", "", 0, "", "", "", "", 0, "", "", "", "", 0);
dt1.Rows.Add(dt.Rows[i]["id"].ToString(), dt.Rows[i]["pname"].ToString(), dt.Rows[i]["ProductName"].ToString(), dt.Rows[i]["Image"].ToString(), dt.Rows[i]["ProductCode"].ToString(), dt.Rows[i]["FinalSellingPrice"].ToString(), dt.Rows[i + 1]["id"].ToString(), dt.Rows[i + 1]["pname"].ToString(), dt.Rows[i + 1]["ProductName"].ToString(), dt.Rows[i + 1]["Image"].ToString(), dt.Rows[i + 1]["ProductCode"].ToString(), dt.Rows[i + 1]["FinalSellingPrice"].ToString(), dt.Rows[i + 2]["id"].ToString(), dt.Rows[i + 2]["pname"].ToString(), dt.Rows[i + 2]["ProductName"].ToString(), dt.Rows[i + 2]["Image"].ToString(), dt.Rows[i + 2]["ProductCode"].ToString(), dt.Rows[i + 2]["FinalSellingPrice"].ToString(), "", "", "", "", "", 0, "", "", "", "", "", 0, "", "", "", "", "", 0);
}
}
else
{
dt1.Rows.Add(dt.Rows[i]["id"].ToString(), dt.Rows[i]["pname"].ToString(), dt.Rows[i]["ProductName"].ToString(), dt.Rows[i]["Image"].ToString(), dt.Rows[i]["ProductCode"].ToString(), dt.Rows[i]["FinalSellingPrice"].ToString(), dt.Rows[i + 1]["id"].ToString(), dt.Rows[i + 1]["pname"].ToString(), dt.Rows[i + 1]["ProductName"].ToString(), dt.Rows[i + 1]["Image"].ToString(), dt.Rows[i + 1]["ProductCode"].ToString(), dt.Rows[i + 1]["FinalSellingPrice"].ToString(), "", "", "", "", "", 0, "", "", "", "", "", 0, "", "", "", "", "", 0, "", "", "", "", "", 0);
}
}
else
{
dt1.Rows.Add(dt.Rows[i]["id"].ToString(), dt.Rows[i]["pname"].ToString(), dt.Rows[i]["ProductName"].ToString(), dt.Rows[i]["Image"].ToString(), dt.Rows[i]["ProductCode"].ToString(), dt.Rows[i]["FinalSellingPrice"].ToString(), "", "", "", "", "", 0, "", "", "", "", "", 0, "", "", "", "", "", 0, "", "", "", "", "", 0, "", "", "", "", "", 0);
}
}
}
}
else
{
dt1 = dt;
}
return(dt1);
}