public static GetSqlConnect getUser()
{
if (connectuser == null)
{
connectuser = new GetSqlConnect();
}
return(connectuser);
}
public void RemoveProductToShoppingCart(ItemToPurchase product)
{
int miktar = 0;
conn = GetSqlConnect.getUser();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select ProductQuantity From ShoppingCart Where CustomerID=@custom and ProductID=@prod";
cmd.Connection = conn.DatabaseConnectionOpen();
cmd.Parameters.AddWithValue("@custom", m_customerID);
cmd.Parameters.AddWithValue("@prod", product.Product.ProductID);
//her @'li parametre farklı olmalı
using (SqlDataReader read = cmd.ExecuteReader())
{
if (read.Read())
{
miktar = int.Parse(read["ProductQuantity"].ToString());
}
}
if (miktar > 1)
{
cmd.CommandText = "Update ShoppingCart Set ProductQuantity=@quant Where CustomerID = @custome and ProductID = @product";
cmd.Parameters.AddWithValue("@product", product.Product.ProductID);
cmd.Parameters.AddWithValue("@custome", m_customerID);
cmd.Parameters.AddWithValue("@quant", miktar - product.ProductQuantity);
using (SqlDataReader read = cmd.ExecuteReader())
{
if (read.Read())
{
price = int.Parse(read["Price"].ToString());
}
_PaymentAmount = _PaymentAmount - price * miktar;
}
}
else
{
cmd.CommandText = "Delete From ShoppingCart Where CustomerID = @customer and ProductID = @productid";
cmd.Parameters.AddWithValue("@productid", product.Product.ProductID);
cmd.Parameters.AddWithValue("@customer", m_customerID);
using (SqlDataReader read = cmd.ExecuteReader())
{
if (read.Read())
{
price = int.Parse(read["Price"].ToString());
}
_PaymentAmount = _PaymentAmount - price * 1;
}
}
cmd.ExecuteNonQuery();
}
public void AddProductToShoppingCart(ItemToPurchase product)
{
int miktar = 0;
conn = GetSqlConnect.getUser();
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select ProductQuantity From ShoppingCart Where CustomerID = @cid and ProductID = @pid";
cmd.Connection = conn.DatabaseConnectionOpen();
cmd.Parameters.AddWithValue("@cid", m_customerID);
cmd.Parameters.AddWithValue("@pid", product.Product.ProductID);
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
miktar = int.Parse(reader["ProductQuantity"].ToString());
}
}
if (miktar > 0)
{
cmd.CommandText = "Update ShoppingCart Set ProductQuantity=@quant Where CustomerID = @cuid and ProductID = @puid";
cmd.Parameters.AddWithValue("@puid", product.Product.ProductID);
cmd.Parameters.AddWithValue("@cuid", m_customerID);
cmd.Parameters.AddWithValue("@quant", miktar + product.ProductQuantity);
}
else
{
cmd.CommandText = "Insert Into ShoppingCart(CustomerID, ProductID, ProductQuantity) Values (@cuid, @puid, @quantity)";
cmd.Parameters.AddWithValue("@cuid", m_customerID);
cmd.Parameters.AddWithValue("@puid", product.Product.ProductID);
cmd.Parameters.AddWithValue("@quantity", product.ProductQuantity);
}
cmd.ExecuteNonQuery();
ShoppingCartError = true;
}
catch (Exception f)
{
ShoppingCartError = false;
UrunDurumu = f.ToString();
}
}
public DataTable PrintShoppingCartProducts()
{
DataTable dt = new DataTable();
conn = GetSqlConnect.getUser();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select ShoppingCart.ProductID AS ÜrünID, Products.Name AS ÜrünAdı, ShoppingCart.ProductQuantity AS ÜrünMiktarı, Products.Price AS ÜrünFiyatı,Products.Type From ShoppingCart Inner Join Products On ShoppingCart.ProductID = Products.ProductID Where ShoppingCart.CustomerID = @cid";
cmd.Connection = conn.DatabaseConnectionOpen();
cmd.Parameters.AddWithValue("@cid", m_customerID);
using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
{
adapter.Fill(dt);
}
return(dt);
}
private void btnsign_Click(object sender, EventArgs e)
{
GetSqlConnect user = GetSqlConnect.getUser();
if (txtUserName.Text == "" || txtUserPassword.Text == "")
{
MessageBox.Show("Please Fill in the Fields!", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
if (user.Login(txtUserName.Text, txtUserPassword.Text) == true)
{
MessageBox.Show("Access Succeed!");
this.Hide();
FormUser2 form = new FormUser2();
form.ShowDialog();
}
else
{
MessageBox.Show("User Not Found !", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
