protected void BtnAdd_Click(object sender, EventArgs e)
{
try
{
ProductsDataSource.InsertParameters["Designation"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("TxtDesignation")).Text;
ProductsDataSource.InsertParameters["Pu"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("TxtPrixU")).Text;
FileUpload fileUpload = ((FileUpload)GridView1.FooterRow.FindControl("FileUpload1"));
if (fileUpload.HasFile)
{
string extension = Path.GetExtension(fileUpload.PostedFile.FileName);
string fileName = DateTime.Now.ToString("_MMddyyyy_HHmmss") + extension;
//string fileName = Path.GetFileName(fileUpload.PostedFile.FileName);
fileUpload.SaveAs(Server.MapPath("ImagesData/" + fileName));
ProductsDataSource.InsertParameters["URLImage"].DefaultValue = "ImagesData/" + fileName;
LblMsg.Text = "Success";
LblMsg.ForeColor = System.Drawing.Color.Green;
}
ProductsDataSource.Insert();
GridView1.PageIndex = GridView1.PageCount;
}
catch (Exception Err)
{
LblMsg.Text = Err.Message;
LblMsg.ForeColor = System.Drawing.Color.Red;
}
}
public Example()
{
InitializeComponent();
this.orders.ItemsSource = OrdersDataSource.GetOrders();
this.company.ItemsSource = CompaniesDataSource.GetCompanies();
this.Category1.ItemsSource = ProductsDataSource.GetProductsByCategory("1");
}
public override void ViewDidLoad()
{
base.ViewDidLoad();
var products = JsonConvert.DeserializeObject <List <Product> >(Settings.Products);
var datasource = new ProductsDataSource(products);
this.TableView.Source = datasource;
}
private void MainPageLoaded(object sender, RoutedEventArgs e)
{
data = new ProductsDataSource();
this.productList.DataContext = data.Products;
this.order = new Order {
Date = DateTime.Now, Items = new List <OrderItem>(), OrderID = Guid.NewGuid(), TotalValue = 0
};
}
private void MainWindowLoaded(object sender, RoutedEventArgs e)
{
_data = new ProductsDataSource();
productList.DataContext = _data.Products;
_order = new Order {
Date = DateTime.Now, Items = new List <OrderItem>(), OrderId = Guid.NewGuid(), TotalValue = 0
};
}
private async void refreshData()
{
UIApplication.SharedApplication.NetworkActivityIndicatorVisible = true;
_products = await ServiceClient.GetProductsAsync();
TableView.Source = _productsDataSource = new ProductsDataSource(this, _products);
TableView.ReloadData();
UIApplication.SharedApplication.NetworkActivityIndicatorVisible = false;
}
protected void lvw_items_ItemCommand(object sender, ListViewCommandEventArgs e)
{
string[] productDetails = ((String)e.CommandArgument).Split(',');
try
{
_cart.RemoveItem(productDetails[0].Trim(), Convert.ToDecimal(productDetails[1].Trim()), Convert.ToInt32(productDetails[2].Trim()));
cartDatasource.Update();
_itemSKU = productDetails[0].Trim();
_itemQuant = DBOps.GetProductQuantity(_itemSKU) + Convert.ToInt32(productDetails[2].Trim());
ProductsDataSource.Update();
}
catch (Exception)
{
// ignored
}
Button button = (Button)UpdatePanel1.FindControl("btn_checkout");
if (DBOps.BuildUserCart(_userCartId).Rows.Count < 1)
{
if (_user != "-")
{
//cartDatasource.Delete();
//DataOps.reassignUserCart(user);
}
button.Enabled = false;
button.CssClass = "btn btn-outline-secondary btn-block";
}
DataPager dp = (DataPager)lvw_items.FindControl("DataPager1");
if (lvw_items.Items.Count <= 1)
{
dp.SetPageProperties(0, dp.MaximumRows, false);
}
lvw_items.DataSource = DBOps.BuildUserCart(_userCartId);
lvw_totals.DataSource = DBOps.BuildUserCartTotals(_userCartId);
lvw_items.DataBind();
lvw_totals.DataBind();
SiteMaster master = Page.Master as SiteMaster;
master.UpdateTotalCounters();
}
// Handles image src logic
protected string RenderImage(object sku)
{
ProductsDataSource.SelectParameters[0].DefaultValue = sku.ToString();
var result = ProductsDataSource.Select(DataSourceSelectArguments.Empty) as DataView;
Debug.Assert(result != null, nameof(result) + " != null");
string path = result[0]["img_url"].ToString();
// Get all png and jpg files in current dir only
var images = Directory.GetFiles(Server.MapPath(path) ?? throw new InvalidOperationException(), "*", SearchOption.TopDirectoryOnly)
.Where(file => file.EndsWith(".png") || file.EndsWith(".jpg") || file.EndsWith(".jpeg"));
// Resolve physical paths to server-relative paths
List <string> files = images.Select(img => path + "/" + Path.GetFileName(img)).ToList();
return(files[0]);
}
void Products_SelectionChanged(object sender, System.Windows.RoutedEventArgs e)
{
RadTabItem item = Products.SelectedItem as RadTabItem;
if (item == null)
{
return;
}
if (item.Tag.Equals("0"))
{
this.Category1.ItemsSource = ProductsDataSource.GetProductsByCategory("1");
}
else if (item.Tag.Equals("1"))
{
this.Category2.ItemsSource = ProductsDataSource.GetProductsByCategory("2");
}
else if (item.Tag.Equals("2"))
{
this.Category3.ItemsSource = ProductsDataSource.GetProductsByCategory("3");
}
}
protected void ProductList_ItemCommand(object sender, ListViewCommandEventArgs e)
{
if (_currUser != "-" && _tempId != 0)
{
_cart.cartID = _userCartId;
_cart.cartOwner = _currUser;
string[] items = DBOps.GetCartItems(_userCartId);
_cart.lastInsertedItem = items[0];
_cart.lastInsertedPrice = items[1];
_cart.lastInsertedQuant = items[2];
_cart.totalItemQuantity = Convert.ToInt32(items[3]);
_cart.totalCartPrice = Convert.ToDecimal(items[4]);
}
else if (_currUser != "-" && _tempId == 0)
{
_cart.cartID = _userCartId;
userInfoDataSource.Update();
}
else
{
_cart.cartID = _userCartId;
}
string[] productDetails = ((String)e.CommandArgument).Split(',');
_cart.AddItem(productDetails[0].Trim(), Convert.ToDecimal(productDetails[1].Trim()), 1);
_itemSku = productDetails[0].Trim();
bool CanBeAdded = _cart.ItemCanBeAdded(_itemSku, 1, _userCartId);
int productQuant = DBOps.GetProductQuantity(_itemSku);
if (Session[_itemSku] == null)
{
Session[_itemSku] = productQuant;
}
if (!DBOps.RecordExists(_userCartId))
{
if (CanBeAdded)
{
CartDataSource.Insert();
_itemQuant = productQuant - 1;
ProductsDataSource.Update();
}
}
else
{
if (CanBeAdded && productQuant > 0)
{
_itemQuant = productQuant - 1;
CartDataSource.Update();
ProductsDataSource.Update();
}
else if (productQuant == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "notif",
"alert('ITEM NOT ADDED. This product is currently out of stock. Try again later.')", true);
}
else if (!CanBeAdded)
{
ScriptManager.RegisterStartupScript(this, GetType(), "notif",
$"alert('ITEM NOT ADDED. You either have the maximum number of it in your cart or adding the specified amount of {1} will exceed the limit of 99.')", true);
}
}
SiteMaster master = Page.Master as SiteMaster;
master.UpdateTotalCounters();
}
protected void BtnSearch_Click(object sender, EventArgs e)
{
ProductsDataSource.Select(DataSourceSelectArguments.Empty);
}
protected void tbx_qty_TextChanged(object sender, EventArgs e)
{
TextBox textBox1 = (TextBox)sender;
ListViewDataItem item = (ListViewDataItem)textBox1.NamingContainer;
TextBox tb = (TextBox)item.FindControl("tbx_qty"); //get the textbox in the proper listview item
if (Convert.ToInt32(tb.Text) <= 0 || tb.Text == string.Empty || string.IsNullOrEmpty(tb.Text) || string.IsNullOrWhiteSpace(tb.Text) || (tb.Text == DBNull.Value.ToString(CultureInfo.InvariantCulture)))
{
tb.Text = "1";
}
else if (Convert.ToInt32(tb.Text) > 99)
{
tb.Text = "99";
}
Label lblSku = (Label)item.FindControl("lbl_sku");
Label lblPrice = (Label)item.FindControl("lbl_price");
//int t_itemStock = DBOps.GetProductQuantity(lblSku.Text);
int t_itemStock = Convert.ToInt32(Session[lblSku.Text]);
int t_cartQuantity = Convert.ToInt32(tb.Text);
int t_currCartQuantity = DBOps.GetItemQuantity(_userCartId, lblSku.Text);
#region Old validation code
//int t_sessionQuant = 0;
//if (Session[lblSku.Text] != null)
//{
// t_sessionQuant = Convert.ToInt32(Session[lblSku.Text]);
//}
////else
////{
//// Session[lblSku.Text] = t_currCartQuantity;
////}
#endregion
try
{
_itemSKU = lblSku.Text;
/// user adds a specified amount of the item to the cart
if (t_currCartQuantity - t_cartQuantity < 0)
{
if (t_itemStock >= t_cartQuantity /* || t_sessionQuant >= t_cartQuantity*/)
{
_cart.UpdateItem(lblSku.Text, Decimal.Parse(lblPrice.Text, NumberStyles.Currency), Convert.ToInt32(tb.Text));
cartDatasource.Update();
_itemQuant = DBOps.GetProductQuantity(_itemSKU) - Math.Abs(t_currCartQuantity - t_cartQuantity);
ProductsDataSource.Update();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "notif",
string.Format("alert('ITEM NOT ADDED. The specified quantity of {0} is more than the available stock of the item.')",
t_cartQuantity), true);
}
}
else
{
_cart.UpdateItem(lblSku.Text, Decimal.Parse(lblPrice.Text, NumberStyles.Currency), Convert.ToInt32(tb.Text));
cartDatasource.Update();
_itemQuant = DBOps.GetProductQuantity(_itemSKU) + Math.Abs(t_currCartQuantity - t_cartQuantity);
ProductsDataSource.Update();
}
}
catch (Exception)
{
// ignored
}
lvw_items.DataSource = DBOps.BuildUserCart(_userCartId);
lvw_totals.DataSource = DBOps.BuildUserCartTotals(_userCartId);
lvw_items.DataBind();
lvw_totals.DataBind();
SiteMaster master = Page.Master as SiteMaster;
master.UpdateTotalCounters();
}
