public void checkmobile()
{
Object MobileDuplicate = new Object();
MobileDuplicate.Mobile = TxtPhone.Text;
DataTable dt = BSLAYER.DuplicateMobile(MobileDuplicate);
int r = dt.Rows.Count;
if (r < 1)
{
Panelmsg.Visible = false;
Txtotp.Visible = true;
generateotp();
SendOtpSms();
Btnotp.Text = "Resend";
Btnverify.Visible = true;
//Response.AddHeader("Refresh", "5");
}
else
{
Panelmsg.Visible = true;
Txtotp.Visible = false;
TxtPhone.Text = "";
TxtPhone.BorderColor = System.Drawing.Color.Red;
Btnotp.Enabled = true;
}
}
public void Login()
{
string encryp = FormsAuthentication.HashPasswordForStoringInConfigFile(TxtPassword.Text, "SHA1");
Object UserLogin = new Object();
UserLogin.Mobile = TxtMobile.Text;
UserLogin.Password = encryp;
DataTable dt = BSLAYER.LoginUser(UserLogin);
int r = dt.Rows.Count;
if (r < 1)
{
Lbllogmsg.Visible = true;
TxtMobile.Text = "";
TxtPassword.Text = "";
TxtMobile.Focus();
TxtMobile.BorderColor = System.Drawing.Color.Red;
}
else
{
Lbllogmsg.Visible = false;
Session["Loggedin"] = "1";
Session["Name"] = dt.Rows[0]["Name"].ToString();
Session["Mail"] = dt.Rows[0]["Email"].ToString();
Session["Mobile"] = dt.Rows[0]["Mobile"].ToString();
Session["Address"] = dt.Rows[0]["Address"].ToString();
Session["Pin"] = dt.Rows[0]["Pincode"].ToString();
Response.Redirect("account");
}
}
public void Login()
{
Object UserLogin = new Object();
UserLogin.Mobile = TxtMobile.Text;
UserLogin.Password = TxtPassword.Text;
DataTable dt = BSLAYER.LoginUser(UserLogin);
int r = dt.Rows.Count;
if (r < 1)
{
PanelAlert.Visible = true;
TxtMobile.Text = "";
TxtPassword.Text = "";
//Response.Redirect("User-Login.aspx");
}
else
{
Session["Loggedin"] = "1";
Session["Name"] = dt.Rows[0]["Name"].ToString();
Session["Mail"] = dt.Rows[0]["Email"].ToString();
Session["Mobile"] = dt.Rows[0]["Mobile"].ToString();
Session["Address"] = dt.Rows[0]["Address"].ToString();
Session["Pin"] = dt.Rows[0]["Pincode"].ToString();
Response.Redirect("account");
}
}
public void FillOrderList()
{
/*Insert into Order list*/
foreach (GridViewRow gr in GridView1.Rows)
{
TextBox txtprice = (TextBox)gr.FindControl("TxtPrice");
TextBox txtquan = (TextBox)gr.FindControl("TxtQuantity");
TextBox txttot = (TextBox)gr.FindControl("TxtTotal");
Object OrderItemInsert = new Object();
OrderItemInsert.Order_Id = LblOrderid.Text;
//OrderItemInsert.Email = TxteMail.Text;
//OrderItemInsert.Mobile = TxtPhone.Text;
//OrderItemInsert.Product_Name = gr.Cells[1].Text;
//OrderItemInsert.Product_Quantity = gr.Cells[2].Text;
//OrderItemInsert.Product_Brand = gr.Cells[3].Text;
//OrderItemInsert.Product_Description = gr.Cells[4].Text;
//OrderItemInsert.Product_Offer = gr.Cells[5].Text;
OrderItemInsert.Product_Id = int.Parse(gr.Cells[6].Text);
//OrderItemInsert.Product_Price = int.Parse(txtprice.Text);
OrderItemInsert.Product_Unit = int.Parse(txtquan.Text);
OrderItemInsert.Total_Price = int.Parse(txttot.Text);
OrderItemInsert.Year = HiddenYear.Value;
OrderItemInsert.Month = HiddenMonth.Value;
OrderItemInsert.Created_Date = HiddenDate.Value;
BSLAYER.InsertOrderItem(OrderItemInsert);
}
}
public void Login()
{
Object UserLogin = new Object();
UserLogin.Mobile = TxtMobile.Text;
UserLogin.Password = TxtPassword.Text;
DataTable dt = BSLAYER.LoginUser(UserLogin);
int r = dt.Rows.Count;
if (r < 1)
{
// PanelAlert.Visible = true;
TxtMobile.Text = "";
TxtPassword.Text = "";
}
else
{
//PanelAlert.Visible = false;
Session["OrderNo"] = LblOrderid.Text;
Session["Total"] = LblAmount.Text;
Session["Name"] = dt.Rows[0]["Name"].ToString();
Session["Mail"] = dt.Rows[0]["Email"].ToString();
Session["Mobile"] = dt.Rows[0]["Mobile"].ToString();
Session["Address"] = dt.Rows[0]["Address"].ToString();
Session["Pin"] = dt.Rows[0]["Pincode"].ToString();
Response.Redirect("transaction");
}
}
public void GetProductList()
{
Object ProductIndividual = new Object();
ProductIndividual.Product_Name = HiddenProductName.Value;
ProductIndividual.Product_Brand = HiddenBrandName.Value;
ProductIndividual.Category_Name = HiddenCatagoryName.Value;
DataTable dt = BSLAYER.IndividualProduct(ProductIndividual);
int r = dt.Rows.Count;
if (r < 1)
{
DdlBrand.Visible = false;
DdlPacket.Visible = false;
DdlSort.Visible = false;
PanelAlert.Visible = true;
lbtcart.Visible = false;
}
else
{
DdlBrand.Visible = true;
DdlPacket.Visible = true;
DdlSort.Visible = true;
PanelAlert.Visible = false;
lbtcart.Visible = true;
DataList1.DataSource = dt;
DataList1.DataBind();
}
}
public void StatusUpdate()
{
Object UpdateStatus = new Object();
UpdateStatus.Order_Id = DdlOrder.SelectedValue;
BSLAYER.StatusUpdate(UpdateStatus);
}
public void DeleteOrderList()
{
Object OrderListDelete = new Object();
OrderListDelete.Order_Id = DdlOrder.SelectedValue;
BSLAYER.DeleteOrderList(OrderListDelete);
}
public void DeleteOrderDetails()
{
Object OrderDetailsDelete = new Object();
OrderDetailsDelete.Order_Id = DdlOrder.SelectedValue;
BSLAYER.DeleteOrderDetails(OrderDetailsDelete);
}
public void DeleteTransaction()
{
Object TransactionOrderDelete = new Object();
TransactionOrderDelete.Order_Id = DdlOrder.SelectedValue;
BSLAYER.DeleteTransactionOrder(TransactionOrderDelete);
}
public void GetSaleDetails()
{
Object SaleView = new Object();
DataTable dt = BSLAYER.ViewSale(SaleView);
GridView1.DataSource = dt;
GridView1.DataBind();
}
public void GetProductDetails()
{
Object InfoProduct = new Object();
DataTable dt = BSLAYER.ProductInfo(InfoProduct);
GridView4.DataSource = dt;
GridView4.DataBind();
}
public void PasswordChange()
{
Object PasswordUpdate = new Object();
PasswordUpdate.Email = HiddenMail.Value;
PasswordUpdate.Password = TxtPwd.Text;
BSLAYER.UpdatePassword(PasswordUpdate);
}
public void OrderDetails()
{
Object OrdersAll = new Object();
DataTable dt = BSLAYER.AllOrders(OrdersAll);
GridView1.DataSource = dt;
GridView1.DataBind();
}
public void GetOrderDetails()
{
Object orderselect = new Object();
orderselect.Mobile = HiddenMobile.Value;
DataTable dt = BSLAYER.selectorder(orderselect);
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void Ddlbrand_SelectedIndexChanged(object sender, EventArgs e)
{
Object BrandByCategory = new Object();
BrandByCategory.Product_Brand = Ddlbrand.SelectedValue;
DataTable dt = BSLAYER.CategoryByBrand(BrandByCategory);
DataList1.DataSource = dt;
DataList1.DataBind();
}
public void GetTransactionDetails()
{
Object transactionselect = new Object();
transactionselect.Email = HiddenMail.Value;
DataTable dt = BSLAYER.selecttransaction(transactionselect);
GridView1.DataSource = dt;
GridView1.DataBind();
}
public void ShowCategory()
{
Object fillcategory = new Object();
DataTable dt = BSLAYER.categoryfill(fillcategory);
ddlcategory.DataSource = dt;
ddlcategory.DataTextField = "Category_Name";
ddlcategory.DataValueField = "Category_Id";
ddlcategory.DataBind();
ddlcategory.Items.Insert(0, "Select Category");
}
public void ShowPendingOrder()
{
Object OrderPending = new Object();
DataTable dt = BSLAYER.PendingOrder(OrderPending);
DdlOrder.DataSource = dt;
DdlOrder.DataTextField = "Order_Id";
DdlOrder.DataValueField = "Order_Id";
DdlOrder.DataBind();
DdlOrder.Items.Insert(0, "Select Pending Orders");
}
public void Contact()
{
Object contactuser = new Object();
contactuser.Name = TxtName.Text;
contactuser.Email = TxtMail.Text;
contactuser.Mobile = TxtPhone.Text;
contactuser.Query = TxtQuery.Text;
contactuser.Created_Date = HiddenDate.Value;
BSLAYER.usercontact(contactuser);
}
public void UpdateProfile()
{
Object ProfileUpdate = new Object();
ProfileUpdate.Name = TxtName.Text;
ProfileUpdate.Email = TxtMail.Text;
ProfileUpdate.Address = TxtAddress.Text;
ProfileUpdate.Pincode = int.Parse(TxtPin.Text);
ProfileUpdate.Mobile = TxtPhone.Text;
BSLAYER.UpdateProfile(ProfileUpdate);
}
public void GetOrderDetails()
{
Object Orderview = new Object();
Orderview.Order_Id = Txtsearch.Text;
DataTable dt = BSLAYER.ViewOrder(Orderview);
GridView1.DataSource = dt;
GridView1.DataBind();
Lbldate.Text = "Date Of Order:" + dt.Rows[0]["Created_Date"].ToString();
}
public void TransactionDetails()
{
//here we fill transaction details according to order id
Object TransactionSelect = new Object();
TransactionSelect.Order_Id = DdlOrderId.SelectedValue;
DataTable dt = BSLAYER.SelectTransaction(TransactionSelect);
TxtDate.Text = dt.Rows[0]["Transaction_Date"].ToString();
TxtSale.Text = dt.Rows[0]["Transaction_Amount"].ToString();
}
protected void DdlProduct_SelectedIndexChanged(object sender, EventArgs e)
{
Object DetailProduct = new Object();
DetailProduct.Product_Brand = Ddlbrand.SelectedValue;
DetailProduct.Product_Name = DdlProduct.SelectedValue;
DataTable dt = BSLAYER.ProductDetail(DetailProduct);
GridView4.DataSource = dt;
GridView4.DataBind();
}
public void GetProducts()
{
Object ProductIndividual = new Object();
ProductIndividual.Product_Name = DdlProduct.SelectedValue;
DataTable dt = BSLAYER.IndividualProduct(ProductIndividual);
int r = dt.Rows.Count;
DataList1.DataSource = dt;
DataList1.DataBind();
}
public void GetBrand()
{
Object NameBrand = new Object();
DataTable dt = BSLAYER.BrandName(NameBrand);
Ddlbrand.DataSource = dt;
Ddlbrand.DataTextField = "Product_Brand";
Ddlbrand.DataValueField = "Product_Brand";
Ddlbrand.DataBind();
Ddlbrand.Items.Insert(0, "--Filter By Brand--");
}
public void ShowProduct()
{
Object fillproduct = new Object();
DataTable dt = BSLAYER.productfill(fillproduct);
DdlProduct.DataSource = dt;
DdlProduct.DataTextField = "Product_Name";
DdlProduct.DataValueField = "Product_ID";
DdlProduct.DataBind();
DdlProduct.Items.Insert(0, "Select Product");
}
protected void DdlYear_SelectedIndexChanged(object sender, EventArgs e)
{
Object SaleYear = new Object();
SaleYear.Year = DdlYear.SelectedValue;
DataTable dt = BSLAYER.YearSale(SaleYear);
GridView1.DataSource = dt;
GridView1.DataBind();
DdlYear.ClearSelection();
}
public void ShowDetail()
{
Object OrderIdWiseProduct = new Object();
OrderIdWiseProduct.Order_Id = HiddenId.Value;
DataTable dt = BSLAYER.ProductByOrderId(OrderIdWiseProduct);
GridView1.Visible = true;
GridView1.DataSource = dt;
GridView1.DataBind();
Session["FillCart"] = dt;
}
public void Register()
{
Object usersignup = new Object();
usersignup.Email = TxtMail.Text;
usersignup.Name = TxtName.Text;
usersignup.Mobile = TxtPhone.Text;
usersignup.Address = TxtAddress.Text;
usersignup.Password = TxtPwd.Text;
usersignup.Pincode = int.Parse(TxtPin.Text);
BSLAYER.signupuser(usersignup);
}
