protected void getImage()
{
int x = 0;
string strId = Request.QueryString["Id"].ToString();
if (strId.Length > 0)
{
DataTable dt = MDC.getDataTable("select * from MainImage where MemberId=" + Convert.ToInt32(strId));
if (dt.Rows.Count > 0)
{
gvMenuTiming.DataSource = dt;
gvMenuTiming.DataBind();
foreach (GridViewRow gv in gvMenuTiming.Rows)
{
Label lblMemberId = (Label)gv.FindControl("lblMemberId");
Image Img = (Image)gv.FindControl("Img");
if (lblMemberId.Text.Length > 0)
{
Img.ImageUrl = "~/neuroimg/" + dt.Rows[x]["ImageName"].ToString();
}
x = x + 1;
}
}
}
}
protected void FillItem()
{
Int32 k = 0;
string strUser = Session["user"].ToString();
DataTable dt = MDC.getDataTable("select * from ItemMaster order by ItemName");
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
drpItemName.Items.Add(dt.Rows[k]["ItemName"].ToString());
k = k + 1;
}
}
}
protected void getImage()
{
int x = 0;
string strId = Request.QueryString["Id"].ToString();
try
{
if (strId.Length > 0)
{
DataTable dt = MDC.getDataTable("select * from ItemMaster where PK_ItemId=" + Convert.ToInt32(strId));
if (dt.Rows.Count > 0)
{
gvMenuTiming.DataSource = dt;
gvMenuTiming.DataBind();
foreach (GridViewRow gv in gvMenuTiming.Rows)
{
Label lblMemberId = (Label)gv.FindControl("txtOrderId");
Image Img = (Image)gv.FindControl("Img");
//if (Convert.ToInt32(lblMemberId.Text) > 0)
//{
Img.ImageUrl = "~/ProductImage/" + strId + "_" + dt.Rows[x]["ImageName"].ToString();
// }
x = x + 1;
}
}
}
}
catch (Exception ex)
{
}
}
protected void GetState()
{
DataTable dt = MDC.getDataTable("select distinct State from RTO");
if (dt.Rows.Count > 0)
{
DrpState.DataSource = dt;
DrpState.DataTextField = "State";
DrpState.DataValueField = "State";
DrpState.DataBind();
}
}
protected void FillCategory()
{
string strUser = Session["UserName"].ToString();
Int32 k = 0;
DataTable dt = MDC.getDataTable("select * from CategoryMaster where UserName='******' order by CategoryName");
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
drpCategory.Items.Add(dt.Rows[k]["CategoryName"].ToString());
k = k + 1;
}
}
}
public string GetOrder()
{
string htmlStr = "";
string strEmail = Session["email"].ToString();
htmlStr = "<table style='width:700px;' border='1'>";
htmlStr += "<tr><td><b>Image</b></td><td><b>Date</b></td><td><b>Order Id</b></td><td><b>Name</b></td><td><b>Qty</b></td><td><b>Amount</b></td></tr>";
DataTable dt = MDC.getDataTable("select * from OrderDetail where EmailId='" + strEmail + "'");
foreach (DataRow dr in dt.Rows)
{
htmlStr += "<tr><td><a href='Receipt.aspx?Id=" + dr["FK_OrderId"].ToString() + "'><img src='ProductImage/" + dr["ImageName"].ToString() + "' height='165' width='115'></a></td><td>" + Convert.ToDateTime(dr["OrderDate"].ToString()).ToString("dd/MM/yyyy") + "</td><td>" + dr["FK_OrderId"].ToString() + "</td>";
htmlStr += "<td>" + dr["ItemName"] + "</td>";
htmlStr += "<td>" + dr["Qty"].ToString() + "</td>";
htmlStr += "<td>" + dr["Amount"].ToString() + "</td></tr>";
}
return(htmlStr);
}
//protected void btnSubmit_Click2(object sender, EventArgs e)
//{
// DataTable dt = MDC.getDataTable("select * from UserMaster where UserName='******' and Password='******' and UserType='admin'");
// if (dt.Rows.Count > 0)
// {
// Response.Redirect("AdminPanel.aspx");
// }
// else
// {
// Response.Redirect("Dashboard.aspx");
// }
//}
public string MainMenu()
{
int i = 1;
string strHtml = "";
DataTable dt = MDC.getDataTable("select * from SubCategoryMaster where CategoryName='KITCHEN'");
if (dt.Rows.Count > 0)
{
strHtml += "<li class='dropdown'>";
strHtml += "<a href = '#' class='dropdown-toggle nav-stylehead' data-toggle='dropdown' role='button' aria-haspopup='true' aria-expanded='false'>KITCHEN";
strHtml += "<span class='caret'></span></a>";
strHtml += "<ul class='dropdown-menu multi-column columns-3'>";
strHtml += "<div class='agile_inner_drop_nav_info'>";
// < div class="col-sm-6 multi-gd-img">
// <ul class="multi-column-dropdown">
strHtml += "<div class='col-sm-4 multi-gd-img'>";
strHtml += "<ul class='multi-column-dropdown'>";
int k = 1;
foreach (DataRow dr in dt.Rows)
{
strHtml += "<li>" +
"<a href = 'Product.aspx?txt=" + dr["SubCategoryName"].ToString() + "'>" + dr["SubCategoryName"].ToString() + "</a>";
strHtml += "</li>";
//strHtml += "<li>";
//strHtml += "<a href='Product.aspx'>Baking Supplies</a>";
//strHtml += "</li>";
//strHtml += "<li>";
//strHtml += "<a href = 'Product.aspx'> Coffee, Tea & Beverages</a>";
//strHtml += "</li>";
//strHtml += "<li>";
//strHtml += "<a href = 'Product.aspx'> Dried Fruits, Nuts</a>";
//strHtml += "</li>";
//strHtml += "<li>";
//strHtml += "<a href = 'Product.aspx'> Sweets, Chocolate</a>";
//strHtml += "</li>";
//strHtml += "<li>";
//strHtml += "<a href = 'Product.aspx'>Spices & Masalas</a>";
//strHtml += "</li>";
//strHtml += "<li>";
//strHtml += "<a href= 'Product.aspx'>Jams, Honey & Spreads</a>";
//strHtml += "</li>";
////if (i == 11)
//{
// strHtml += "</ul>";
// strHtml += "</div>";
// strHtml += "<div class='col-sm-4 multi-gd-img'>";
// strHtml += "<ul class='multi-column-dropdown'>";
//}
//strHtml += "<li>";
//strHtml += "<a href = 'Product.aspx'>Pickles</a>";
//strHtml += "</li>";
//strHtml += "<li>";
//strHtml += "<a href='Product.aspx'>Pasta & Noodles</a>";
//strHtml += "</li>";
//strHtml += "<li>";
//strHtml += "<a href = 'Product.aspx'>Rice, Flour & Pulses</a>";
//strHtml += "</li>";
//strHtml += "<li>";
//strHtml += "<a href = 'Product.aspx'>Sauces & Cooking Pastes</a>";
//strHtml += "</li>";
//strHtml += "<li>";
//strHtml += "<a href = 'Product.aspx'>Snack Foods</a>";
//strHtml += "</li>";
//strHtml += "<li>";
//strHtml += "<a href = 'Product.aspx'>Oils, Vinegars</a>";
//strHtml += "</li>";
//strHtml += "<li>";
//strHtml += "<a href = 'Product.aspx'>Meat, Poultry & Seafood</a>";
//strHtml += "</li>";
k = k + 1;
if (k == 11)
{
strHtml += "</ul>";
strHtml += "</div>";
strHtml += "<div class='col-sm-4 multi-gd-img'>";
strHtml += "<ul class='multi-column-dropdown'>";
}
}
}
strHtml += "</ul>";
strHtml += "</div>";
strHtml += "<div class='col-sm-4 multi-gd-img'>";
strHtml += "<img src = 'images/nav.png' alt=''>";
strHtml += "</div>";
strHtml += "<div class='clearfix'></div>";
strHtml += "</div>";
strHtml += "</ul>";
strHtml += "</li>";
return(strHtml);
}
public string GetTops()
{
string strHtml = "";
int k = 1;
string txt = Request.QueryString["txt"].ToString();
//DataTable dt = MDC.getDataTable("Select * from ProductList where Category='KITCHEN'");
//DataTable dt = MDC.getDataTable("Select * from ItemMaster where SubCategoryName='"+txt+ "' and IsActive=1 and ShowTop3=1 and Position>0");
DataTable dt = MDC.getDataTable("Select * from ItemMaster where SubCategoryName='" + txt + "' and IsActive=1 and ShowTop3=1");
//DataTable dt = MDC.getDataTable("select* from ItemMaster where ShowSlider9 = 1 and Position> 0 and SubCategoryName='" + txt + "' and IsActive=1"
// DataTable dt = MDC.getDataTable("Select * from ItemMaster where SubCategoryName='" + txt + "'");
// strHtml = "<div class='wrapper'>";
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
if (Convert.ToBoolean(dr["ShowTop3"]) == true)
{
//
// strHtml = "<div class='agileinfo-ads-display col-md-9 w3l-rightpro'>";
// strHtml += "<div class='wrapper'>";
// <!-- first section -->
// if (k == 1 || k == 4 || k == 8 || k == 12 || k == 16 || k == 20 || k == 24 || k == 28 || k == 32 || k == 36 || k == 40 || k == 44 || k == 48 || k == 52)
if (k == 1 || k == 4 || k == 7 || k == 10 || k == 13 || k == 16 || k == 19 || k == 22 || k == 25 || k == 28 || k == 31 || k == 34 || k == 37 || k == 40 || k == 43 || k == 46 || k == 49 || k == 52 || k == 55 || k == 58 || k == 61 || k == 64 || k == 67 || k == 70 || k == 73 || k == 76 || k == 79 || k == 82 || k == 85 || k == 88 || k == 91 || k == 94 || k == 97 || k == 100 ||
k == 103 || k == 106 || k == 109 || k == 112)
{
strHtml += "<div class='product-sec1'>";
}
strHtml += "<div class='col-xs-4 product-men'>";
strHtml += "<div class='men-pro-item simpleCart_shelfItem'>";
strHtml += "<div class='men-thumb-item'>";
//strHtml += "<img src = 'images/k" + k + ".jpg' alt=''>";
if (dr["ImageName"].ToString().Length > 0)
{
strHtml += "<img src = 'ProductImage/" + dr["ImageName"].ToString().Trim() + "' alt='' height='166' width='150'>";
}
strHtml += "<div class='men-cart-pro'>";
strHtml += "<div class='inner-men-cart-pro'>";
//strHtml += "<a href = 'Single.aspx?Id=" + dr["PK_ImageId"].ToString() + "' class='link-product-add-cart'>Quick View</a>";
strHtml += "<a href = 'Single.aspx?Id=" + dr["PK_ItemId"].ToString() + "' class='link-product-add-cart'>Quick View</a>";
//strHtml += "<a href = 'Single.aspx?Id=" + dt.Rows[0]["PK_ImageId"].ToString() + "' class='link-product-add-cart'>Quick View</a>";
strHtml += "</div>";
strHtml += "</div>";
strHtml += "<span class='product-new-top'>" + dr["Discount"].ToString() + "%</span>";
strHtml += "</div>";
strHtml += "<div class='item-info-product'>";
strHtml += "<h4>";
strHtml += "<a href = 'Single.aspx?Id=" + dr["PK_ItemId"].ToString() + "'>" + dr["ItemName"].ToString() + "</a>";
// strHtml += "<a href = 'single.html'>" + dt.Rows[0]["ImageHeading"].ToString() + "</a>";
strHtml += "</h4>";
strHtml += "<div class='info-product-price'>";
strHtml += "<span class='item_price'><i style='padding-left:20px;' class='fa fa-inr'></i> " + dr["OfferRate"].ToString() + "</span>";
// strHtml += "<span class='item_price'>" + dt.Rows[0]["Rate"].ToString() + "</span>";
//strHtml += "<del>" + dr["SaveRate"].ToString() + "</del>";
strHtml += "<i style='padding-left:20px;' class='fa fa-inr'></i><del>" + dr["Rate"].ToString() + "</del>";
strHtml += "</div>";
strHtml += "<div class='snipcart-details top_brand_home_details item_add single-item hvr-outline-out'>";
strHtml += "<form action = '#' method='post'>";
strHtml += "<fieldset>";
strHtml += "<input type = 'hidden' name='cmd' value='_cart' />";
strHtml += "<input type = 'hidden' name='add' value='1' />";
strHtml += "<input type = 'hidden' name='business' value=''/>";
//strHtml += "<input type = 'hidden' name='item_name' value='" + dr["ImageHeading"].ToString() + "' />";
strHtml += "<input type = 'hidden' name='item_name' value='" + dr["ItemName"].ToString() + "' />";
//strHtml += "<input type = 'hidden' name='item_name' value='" + dt.Rows[0]["ImageHeading"].ToString() + "' />";
strHtml += "<input type = 'hidden' name='amount' value='" + dr["OfferRate"].ToString() + "' />";
// strHtml += "<input type = 'hidden' name='amount' value='" + dt.Rows[0]["Rate"].ToString() + "' />";
//strHtml += "<input type = 'hidden' name='discount_amount' value='" + dr["Discount"].ToString() + "' />";
strHtml += "<input type = 'hidden' name='discount_amount' value='0' />";
//strHtml += "<input type = 'hidden' name='discount_amount' value='" + dt.Rows[0]["Discount"].ToString() + "' />";
strHtml += "<input type = 'hidden' name='currency_code' value='INR' />";
strHtml += "<input type = 'hidden' name='return' value=' ' />";
strHtml += "<input type = 'hidden' name='cancel_return' value=' '/>";
// strHtml += "<input type = 'submit' name='submit' value='Add to cart' onclick='getData("+dr["PK_ItemId"] + ",'" + dr["ItemName"].ToString() + "','Top','" + dr["Rate"].ToString() + "','" + dr["OfferRate"].ToString() + "','" + dr["SubCategoryName"].ToString() + "')' class='button'/>";
strHtml += "<input type = 'submit' name='submit' value='Add to cart' onclick='PelData(" + dr["PK_ItemId"] + ");' class='button'/>";
strHtml += "</fieldset>";
strHtml += "</form>";
strHtml += "</div>";
strHtml += "</div>";
strHtml += "</div>";
strHtml += "</div>";
if (k == 3 || k == 6 || k == 9 || k == 12 || k == 15 || k == 18 || k == 21 || k == 24 || k == 27 || k == 30 || k == 33 || k == 36 || k == 39 || k == 42 || k == 45 || k == 48 || k == 51 ||
k == 54 || k == 57 || k == 60 || k == 63 || k == 66 || k == 69 || k == 72 || k == 75 || k == 78 ||
k == 81 || k == 84 || k == 87 || k == 90 || k == 93 || k == 96 || k == 99 || k == 102 || k == 105 || k == 108 || k == 111 || k == 114
)
{
strHtml += "<div class='clearfix'></div>";
strHtml += "</div>";
}
//if (k == 12)
//{
// break;
//}
}
k = k + 1;
}
//if (k%5==0)
//{
// strHtml += "<div class=''>";
//}
//
}
//<!-- //4th section -->
// strHtml += "</div>";
//strHtml += "</div>";
return(strHtml);
}