//To insert Product To MY Bill
public void InsertProdToMyBill()
{
int OrderID = ExecuteQuant.GiveMeNotCompletedOrderID();
if (OrderID != 0)
{
string constr = System.Configuration.ConfigurationManager.ConnectionStrings["test1ConStr"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "insert into OrderDetails(OrderID,ProdID,Quantity,Price) values(@OrderID,@ProdID,@Quantity,@Price)";
cmd.Parameters.Add("@OrderID", SqlDbType.Int, 4).Value = OrderID;
cmd.Parameters.Add("@ProdID", SqlDbType.Int, 4).Value = ProdID;
cmd.Parameters.Add("@Quantity", SqlDbType.Int, 4).Value = 1;
cmd.Parameters.Add("@Price", SqlDbType.Int, 4).Value = GiveMeSellPrice();
con.Open();
int ar = cmd.ExecuteNonQuery();
if (ar == 1)
{
Response.Write("Done....,Man");
}
else
{
Response.Write("Sorry Man You Have error, Check Please,");
}
}
}
public bool CheckOrderISComplete()
{
int currentID;
int.TryParse(HttpContext.Current.User.Identity.Name, out currentID);
bool TestISComp = true;
string constr = System.Configuration.ConfigurationManager.ConnectionStrings["test1ConStr"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "Select IsCompleted from Orders where Cust_ID=@Cust_ID and OrderID=@OrderID";
cmd.Parameters.Add("@Cust_ID", SqlDbType.Int, 4).Value = currentID;
cmd.Parameters.Add("@OrderID", SqlDbType.Int, 4).Value = ExecuteQuant.GiveMeNotCompletedOrderID();
con.Open();
Object ISCompletedOBJ = cmd.ExecuteScalar();
if (ISCompletedOBJ != null)
{
if (!(ISCompletedOBJ is DBNull))
{
TestISComp = (bool)ISCompletedOBJ;
}
}
con.Close();
return(TestISComp);
}
protected void PaycartAndEnd_BUT_Click(object sender, EventArgs e)
{
int Cust_ID;
int.TryParse(HttpContext.Current.User.Identity.Name, out Cust_ID);
float TotalPrice;
float.TryParse(SumOfBill_Lit.Text, out TotalPrice);
string constr = System.Configuration.ConfigurationManager.ConnectionStrings["test1ConStr"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "update Orders set IsCompleted=@IsCompleted,TotalPrice=@TotalPrice Where OrderID=@OrderID and Cust_ID=@Cust_ID";
cmd.Parameters.Add("@OrderID", SqlDbType.Int, 4).Value = ExecuteQuant.GiveMeNotCompletedOrderID();
cmd.Parameters.Add("@Cust_ID", SqlDbType.Int, 4).Value = Cust_ID;
cmd.Parameters.Add("@TotalPrice", SqlDbType.Money, 8).Value = TotalPrice;
cmd.Parameters.Add("@IsCompleted", SqlDbType.Bit, 1).Value = true;
con.Open();
//int ar =
cmd.ExecuteNonQuery();
con.Close();
//if (ar == 1)
//{
// SumOfBill_Lit.Text = "<script type='javascript/text'>window.alert('Thanks For Pay.') </script>";
// Response.Redirect("~/MY_Cart.aspx");
//}
Response.Redirect("~/MY_Cart.aspx?done=true");
}
protected void AddToCart_Click(object sender, EventArgs e)
{
int NQ = ExecuteOrder.GiveMEQuantity(ExecuteQuant.GiveMeNotCompletedOrderID(), ExecuteOrder.ROWID(ExecuteQuant.GiveMeNotCompletedOrderID(), ProdID));
if (HttpContext.Current.User.Identity.Name != string.Empty)
{
if (CheckOrderISComplete() == false)
{
CreationBill();
InsertProdToMyBill();
Response.Write("First Once...,");
}
else if (CheckOrderISComplete() == true)
{
// t/f---> chech if this product added to this cart before
if (!ExecuteOrder.CheckThisProduct(ExecuteQuant.GiveMeNotCompletedOrderID(), ExecuteOrder.ROWID(ExecuteQuant.GiveMeNotCompletedOrderID(), ProdID), ProdID))
{
//f..................
InsertProdToMyBill();
Response.Write("From first Check on Bill");
}
else if (ExecuteOrder.CheckThisProduct(ExecuteQuant.GiveMeNotCompletedOrderID(), ExecuteOrder.ROWID(ExecuteQuant.GiveMeNotCompletedOrderID(), ProdID), ProdID) == true)
{
//t.................
Response.Write(ExecuteOrder.ROWID(ExecuteQuant.GiveMeNotCompletedOrderID(), ProdID).ToString());
ExecuteOrder.UPdateProdeInMYOrder(ExecuteQuant.GiveMeNotCompletedOrderID(), ExecuteOrder.ROWID(ExecuteQuant.GiveMeNotCompletedOrderID(), ProdID), ProdID, NQ);
}
}
}
}
private void AddToCart()
{
if (HttpContext.Current.User.Identity.Name == string.Empty)
{
Response.Redirect("~/Login.aspx");
}
//int NQ = ExecuteOrder.GiveMEQuantity( ExecuteQuant.GiveMeNotCompletedOrderID(), ExecuteOrder.ROWID( ExecuteQuant.GiveMeNotCompletedOrderID(), ProdID));
//NQ++;
int OrderID = ExecuteQuant.GiveMeNotCompletedOrderID();
if (CheckOrderISComplete() == true)
{
CreationBill();
InsertProdToMyBill();
Response.Write("First Once...,");
}
else
{
int pc = ExecuteQuant.GetCountOFProductFromOrder(OrderID, ProdID);
if (pc == 0)
{
InsertProdToMyBill();
}
else
{
ExecuteQuant.UPdateQuantityOFProdeInMYOrder(OrderID, ProdID, pc + 1);
}
//// t/f---> chech if this product added to this cart before
//if (!ExecuteOrder.CheckThisProduct( ExecuteQuant.GiveMeNotCompletedOrderID(), ExecuteOrder.ROWID( ExecuteQuant.GiveMeNotCompletedOrderID(), ProdID), ProdID))
//{
// //f..................
// InsertProdToMyBill();
// Response.Write("From first Check on Bill");
//}
//else if (ExecuteOrder.CheckThisProduct( ExecuteQuant.GiveMeNotCompletedOrderID(), ExecuteOrder.ROWID( ExecuteQuant.GiveMeNotCompletedOrderID(), ProdID), ProdID) == true)
//{
// //t.................
// ExecuteOrder.UPdateProdeInMYOrder( ExecuteQuant.GiveMeNotCompletedOrderID(), ExecuteOrder.ROWID( ExecuteQuant.GiveMeNotCompletedOrderID(), ProdID), ProdID, NQ);
// Response.Write("from second check......");
//}
}
}
public void ShowMycartProd()
{
Label_Price.Text = GetNewSellPrice(GetPriceFromProd()).ToString();
string constr = System.Configuration.ConfigurationManager.ConnectionStrings["test1ConStr"].ConnectionString;
SqlConnection con1 = new SqlConnection(constr);
SqlCommand cmd1 = new SqlCommand();
cmd1.Connection = con1;
cmd1.Connection = con1;
cmd1.CommandText = "Select Product.ProdName,OrderDetails.Price,OrderDetails.Quantity,OrderDetails.SubTotalPrice from Product inner join OrderDetails on Product.ProdID=orderDetails.ProdID Where Product.ProdID=@ProdID and OrderDetails.OrderID=@OrderID";
cmd1.Parameters.Add("ProdID", SqlDbType.Int, 4).Value = ProdID;
cmd1.Parameters.Add("OrderID", SqlDbType.Int, 4).Value = ExecuteQuant.GiveMeNotCompletedOrderID();
con1.Open();
SqlDataReader reader = cmd1.ExecuteReader();
if (reader.Read())
{
if (!reader.IsDBNull(0))
{
Label_ProductName.Text = reader.GetString(0);
}
if (!(reader.IsDBNull(1)))
{
Label_Price.Text = reader.GetDecimal(1).ToString();
}
if (!(reader.IsDBNull(2)))
{
int PQ = reader.GetInt32(2);
QuantityProdTB.Text = PQ.ToString();
}
if (!reader.IsDBNull(3))
{
Label_TotalPrice.Text = reader.GetDecimal(3).ToString();
}
}
reader.Close();
con1.Close();
}
public int GiveMeProductID()
{
int ProdID = 0;
string constr = System.Configuration.ConfigurationManager.ConnectionStrings["test1ConStr"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "Select ProdID from OrderDetails Where OrderID=@OrderID";
cmd.Parameters.Add("@OrderID", SqlDbType.Int, 4).Value = ExecuteQuant.GiveMeNotCompletedOrderID();
con.Open();
object ProdOBJ = cmd.ExecuteScalar();
if (ProdOBJ != null)
{
if (!(ProdOBJ is DBNull))
{
ProdID = (int)ProdOBJ;
}
}
con.Close();
return(ProdID);
}
protected void Page_Load(object sender, EventArgs e)
{
SumOfBill_Lit.Text = "Sub Total Price , ";
if (HttpContext.Current.User.Identity.Name == string.Empty)
{
Response.Redirect("~/");
}
ViewBayerProduct.Controls.Clear();
int OrderId = GiveMeNotCompletedOrderID();
if (OrderId == 0)
{
//Label MsgLab = new Label();
string xx = Request.QueryString["done"];
if (xx == "true")
{
MsgLab.Text = "Congratulation, Thank You for Your Visitor...,";
}
else
{
MsgLab.Text = "your cart is empty";
}
ViewBayerProduct.Controls.Add(MsgLab);
return;
}
string constr = System.Configuration.ConfigurationManager.ConnectionStrings["test1ConStr"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "Select ProdID,OrderDetailsID from OrderDetails where OrderID=@OrderID";
cmd.Parameters.Add("@OrderId", SqlDbType.Int, 4).Value = OrderId;
// IsCompleted=@IsCompleted
con.Open();
SqlDataReader Reader = cmd.ExecuteReader();
while (Reader.Read())
{
if (!Reader.IsDBNull(0))
{
MyCartUserControl ShowBuyerProd = (ASP.mycartusercontrol_ascx)Page.LoadControl("~/MyCartUserControl.ascx");
ShowBuyerProd.ID = "ShowBuyerProd" + Reader.GetInt32(1).ToString();
ShowBuyerProd.ProdID = Reader.GetInt32(0);
ShowBuyerProd.ShowMycartProd();
ViewBayerProduct.Controls.Add(ShowBuyerProd);
}
}
Reader.Close();
con.Close();
SumOfBill_Lit.Text += ExecuteOrder.TotalOfBill(ExecuteQuant.GiveMeNotCompletedOrderID()).ToString();
}
