public EL.Transactions.productsintransactions Select(EL.Transactions.productsintransactions productsintransactionEL)
{
var dt = Helper.executeQuery("select * from productsintransactions where productintransactionid = '" + productsintransactionEL.Productintransactionid + "'");
if (dt.Rows.Count > 0)
{
productsintransactionEL.Productintransactionid = Convert.ToInt32(dt.Rows[0]["productintransactionid"].ToString());
productsintransactionEL.Transactionid = Convert.ToInt32(dt.Rows[0]["transactionid"].ToString());
productsintransactionEL.Productid = Convert.ToInt32(dt.Rows[0]["productid"].ToString());
productsintransactionEL.Soldprice = Convert.ToSingle(dt.Rows[0]["soldprice"].ToString());
productsintransactionEL.Quantity = Convert.ToInt32(dt.Rows[0]["quantity"].ToString());
productsintransactionEL.Amount = Convert.ToSingle(dt.Rows[0]["amount"].ToString());
return(productsintransactionEL);
}
else
{
return(null);
}
}
private void ResetForm()
{
lblTotalItems.ResetText();
lblTotalAmount.ResetText();
dgvCart.Rows.Clear();
lblNameAndNumber.ResetText();
CalculateCart();
txtSearchCustomers.ResetText();
txtSearchProducts.ResetText();
PopulateDGVCustomers();
PopulateDGVProducts();
customerEL = new EL.Registrations.customers();
productEL = new EL.Registrations.products();
transactionEL = new EL.Transactions.transactions();
productsintransactionEL = new EL.Transactions.productsintransactions();
}
public bool Delete(EL.Transactions.productsintransactions productsintransactionEL)
{
return(Helper.executeNonQueryBool("delete from productsintransactions where productintransactionid = '" + productsintransactionEL.Productintransactionid + "'"));
}
public bool Update(EL.Transactions.productsintransactions productsintransactionEL)
{
return(Helper.executeNonQueryBool("update productsintransactions set transactionid = '" + productsintransactionEL.Transactionid + "', productid = '" + productsintransactionEL.Productid + "', soldprice = '" + productsintransactionEL.Soldprice + "', quantity = '" + productsintransactionEL.Quantity + "', amount = '" + productsintransactionEL.Amount + "' where productintransactionid = '" + productsintransactionEL.Productintransactionid + "'"));
}
public long Insert(EL.Transactions.productsintransactions productsintransactionEL)
{
Console.WriteLine("insert into productsintransactions (transactionid, productid, soldprice, quantity, amount) values ('" + productsintransactionEL.Transactionid + "', '" + productsintransactionEL.Productid + "', '" + productsintransactionEL.Soldprice + "', '" + productsintransactionEL.Quantity + "', '" + productsintransactionEL.Amount + "')");
return(Helper.executeNonQueryLong("insert into productsintransactions (transactionid, productid, soldprice, quantity, amount) values ('" + productsintransactionEL.Transactionid + "', '" + productsintransactionEL.Productid + "', '" + productsintransactionEL.Soldprice + "', '" + productsintransactionEL.Quantity + "', '" + productsintransactionEL.Amount + "')"));
}
public bool Delete(EL.Transactions.productsintransactions productsintransactionEL)
{
return(productsintransactionDL.Delete(productsintransactionEL));
}
public bool Update(EL.Transactions.productsintransactions productsintransactionEL)
{
return(productsintransactionDL.Update(productsintransactionEL));
}
public long Insert(EL.Transactions.productsintransactions productsintransactionEL)
{
return(productsintransactionDL.Insert(productsintransactionEL));
}
public EL.Transactions.productsintransactions Select(EL.Transactions.productsintransactions productsintransactionEL)
{
return(productsintransactionDL.Select(productsintransactionEL));
}
