public void InsertToKart(LineSale lineSale)
{
bool existProduct = false;
List <LineSale> listLS = new List <LineSale>();
if (Session["ListLineSale"] != null)
{
listLS = (List <LineSale>)Session["ListLineSale"];
}
if (listLS.Count > 0)
{
foreach (LineSale oneLS in listLS)
{
if (lineSale.LineSaleProductId == oneLS.LineSaleProductId)
{
oneLS.LineSaleProductQuantity += lineSale.LineSaleProductQuantity;
Session["ListLineSale"] = listLS;
existProduct = true;
break;
}
}
}
if (!existProduct)
{
listLS.Add(lineSale);
Session["ListLineSale"] = listLS;
}
}
public List <LineSale> GetDepartaments(bool isTypeShoes)
{
List <LineSale> lines = new List <LineSale>();
string strSQL = "SELECT * FROM LineSale WHERE DepartamentIsDeleted = 0 AND DepartamentIsTypeShoes = '" + isTypeShoes + "'"; //ToDO
DataSet data = ExecuteWithResultSQL(strSQL);
if (data.Tables[0].Rows.Count > 0)
{
foreach (DataRow Row in data.Tables[0].Rows)
{
LineSale oneLS = new LineSale();
oneLS.LineSaleId = Convert.ToInt32(Row.ItemArray[0].ToString());
oneLS.LineSaleProductPrice = Convert.ToDecimal(Row.ItemArray[1].ToString());
lines.Add(oneLS);
}
}
return(lines);
}
public List <LineSale> GetListLineSalesBySaleId(int saleId)
{
List <LineSale> lineSales = new List <LineSale>();
string strSQL = "SELECT P.[ProductId], P.ProductCode, P.ProductName, P.ProductDescription, LS.[LineSaleId],LS.[LineSaleProductQuantity],LS.[LineSaleProductPrice] FROM LineSale LS INNER JOIN Product P ON LS.ProductId = P.ProductId WHERE LS.SaleId = '" + saleId + "'";
DataSet data = ExecuteWithResultSQL(strSQL);
if (data.Tables[0].Rows.Count > 0)
{
foreach (DataRow Row in data.Tables[0].Rows)
{
LineSale oneLS = new LineSale();
oneLS.ProductId = Convert.ToInt32(Row.ItemArray[0].ToString());
oneLS.ProductCode = Row.ItemArray[1].ToString();
oneLS.ProductName = Row.ItemArray[2].ToString();
oneLS.ProductDescription = Row.ItemArray[3].ToString();
oneLS.LineSaleId = Convert.ToInt32(Row.ItemArray[4].ToString());
oneLS.LineSaleProductQuantity = Convert.ToInt32(Row.ItemArray[5].ToString());
oneLS.ProductPrice = Convert.ToDecimal(Row.ItemArray[6].ToString());
lineSales.Add(oneLS);
}
}
return(lineSales);
}
protected void btnBuy_Click(object sender, EventArgs e)
{
Button btnBuy = (Button)sender;
string[] commandArgs = btnBuy.CommandArgument.ToString().Split(new char[] { ',' });
RepeaterItem item = (sender as Button).NamingContainer as RepeaterItem;
(item.FindControl("lblMessageProduct") as Label).Text = "";
if ((item.FindControl("ddlProductSizeGeneric") as DropDownList).SelectedIndex > 0)
{
if (Convert.ToInt32((item.FindControl("txtProductQuantity") as TextBox).Text) > 0 && (item.FindControl("txtProductQuantity") as TextBox).Text != "")
{
bool isTypeShoes = false;
if ((item.FindControl("ddlProductSizeGeneric") as DropDownList).SelectedItem.Text.Length > 1)
{
isTypeShoes = (item.FindControl("ddlProductSizeGeneric") as DropDownList).SelectedItem.Text.Substring(0, 2) == "EU";
}
int size = (item.FindControl("ddlProductSizeGeneric") as DropDownList).SelectedIndex;
int productId = Convert.ToInt32(commandArgs[0]);
if (this.ThereIsStock(productId, size, isTypeShoes))
{
decimal productPrice = Convert.ToInt32(commandArgs[1]);
int productQuantity = Convert.ToInt32((item.FindControl("txtProductQuantity") as TextBox).Text);
LineSale oneLS = new LineSale
{
LineSaleId = -1,
LineSaleProductQuantity = productQuantity,
LineSaleProductPrice = productPrice,
ListLineSale = new List <LineSale>(),
LineSaleProductId = productId
};
if (isTypeShoes)
{
oneLS.ProductStockSizeShoes = new int[17];
oneLS.ProductStockSizeShoes[size] = productQuantity;
}
else
{
oneLS.ProductStockSize = new int[8];
oneLS.ProductStockSize[size] = productQuantity;
}
shoppingOnline.InsertToKart(oneLS);
(this.Master.FindControl("lblCartNumber") as Label).Text = this.shoppingOnline.GetListLineSale().Count.ToString();
}
else
{
(item.FindControl("lblMessageProduct") as Label).Text = "Lo sentimos, no hay stock.";
}
}
else
{
(item.FindControl("lblMessageProduct") as Label).Text = "Por favor, ingrese una cantidad mayor a cero.";
}
}
else
{
(item.FindControl("lblMessageProduct") as Label).Text = "Por favor, seleccione un talle.";
}
}
