public void Delete()
{
ClsDataConnection DB = new ClsDataConnection();
DB.AddParameter("@ShoeID", mThisStock.ShoeID);
DB.Execute("sproc_tblStock_Update");
}
public void Delete()
{
ClsDataConnection DB = new ClsDataConnection();
DB.AddParameter("@OLineNumber", mThisOrderline.OLineNumber);
DB.Execute("sproc_tblOrderline_Delete");
}
public clsOrderlineCollection()
{
ClsDataConnection DB = new ClsDataConnection();
DB.Execute("sproc_tblOrderline_SelectAll");
PopulateArray(DB);
}
public void FilterByONum(int ONumber)
{
ClsDataConnection DB = new ClsDataConnection();
DB.AddParameter("@ONumber", ONumber);
DB.Execute("sproc_tblOrderline_FilterByONumber");
PopulateArray(DB);
}
public int Add()
{
ClsDataConnection DB = new ClsDataConnection();
DB.AddParameter("@ONumber", mThisOrderline.ONumber);
DB.AddParameter("@Quantity", mThisOrderline.Quantity);
DB.AddParameter("@ShoeID", mThisOrderline.ShoeID);
return(DB.Execute("sproc_tblOrderline_Insert"));
}
public void Update()
{
ClsDataConnection DB = new ClsDataConnection();
DB.AddParameter("@OLineNumber", mThisOrderline.OLineNumber);
DB.AddParameter("@ONumber", mThisOrderline.ONumber);
DB.AddParameter("@Quantity", mThisOrderline.Quantity);
DB.AddParameter("@ShoeID", mThisOrderline.ShoeID);
DB.Execute("sproc_tblOrderline_Update");
}
public void Update()
{
ClsDataConnection DB = new ClsDataConnection();
DB.AddParameter("@ONumber", mThisOrder.ONumber);
DB.AddParameter("@AdditionalNotes", mThisOrder.Notes);
DB.AddParameter("@CustomerID", mThisOrder.CustomerID);
DB.AddParameter("@OrderComplete", mThisOrder.Complete);
DB.AddParameter("@DateOfEntry", mThisOrder.Date);
DB.Execute("sproc_tblOrder_Update");
}
public int Add()
{
ClsDataConnection DB = new ClsDataConnection();
DB.AddParameter("@ONumber", mThisOrder.ONumber);
DB.AddParameter("@AdditionalNotes", mThisOrder.Notes);
DB.AddParameter("@CustomerID", mThisOrder.CustomerID);
DB.AddParameter("@OrderComplete", mThisOrder.Complete);
DB.AddParameter("@DateOfEntry", mThisOrder.Date);
return(DB.Execute("sproc_tblOrder_Insert"));
}
public void Update()
{
ClsDataConnection DB = new ClsDataConnection();
DB.AddParameter("@ShoeID", mThisStock.ShoeID);
DB.AddParameter("@Name", mThisStock.Name);
DB.AddParameter("@Release", mThisStock.Release);
DB.AddParameter("@Quantity", mThisStock.QuantityStock);
DB.AddParameter("@Price", mThisStock.PriceStock);
DB.AddParameter("@Size", mThisStock.Size);
DB.Execute("sproc_tblStock_Update");
}
void PopulateArray(ClsDataConnection DB)
{
Int32 Index = 0;
Int32 RecordCount;
RecordCount = DB.Count;
mOrderlineList = new List <clsOrderline>();
while (Index < RecordCount)
{
clsOrderline AnOrderline = new clsOrderline();
AnOrderline.OLineNumber = Convert.ToInt32(DB.DataTable.Rows[Index]["OLineNumber"]);
AnOrderline.OLineNumber = Convert.ToInt32(DB.DataTable.Rows[Index]["ONumber"]);
AnOrderline.OLineNumber = Convert.ToInt32(DB.DataTable.Rows[Index]["Quantity"]);
AnOrderline.OLineNumber = Convert.ToInt32(DB.DataTable.Rows[Index]["ShoeID"]);
mOrderlineList.Add(AnOrderline);
Index++;
}
}
public bool Find(int OLineNumber)
{
ClsDataConnection DB = new ClsDataConnection();
DB.AddParameter("@OLineNumber", OLineNumber);
DB.Execute("sproc_tblOrderLine_FilterByOLineNumber");
if (DB.Count == 1)
{
mOLineNumber = Convert.ToInt32(DB.DataTable.Rows[0]["OLineNumber"]);
mQuantity = Convert.ToInt32(DB.DataTable.Rows[0]["Quantity"]);
mONumber = Convert.ToInt32(DB.DataTable.Rows[0]["ONumber"]);
mShoeID = Convert.ToInt32(DB.DataTable.Rows[0]["ShoeID"]);
return(true);
}
else
{
return(false);
}
}
public bool Find(int ONumber)
{
ClsDataConnection DB = new ClsDataConnection();
DB.AddParameter("@ONumber", ONumber);
DB.Execute("sproc_tblOrder_FilterByONumber");
if (DB.Count == 1)
{
mONumber = Convert.ToInt32(DB.DataTable.Rows[0]["ONumber"]);
mCustomerID = Convert.ToInt32(DB.DataTable.Rows[0]["CustomerID"]);
mComplete = Convert.ToBoolean(DB.DataTable.Rows[0]["OrderComplete"]);
mNotes = Convert.ToString(DB.DataTable.Rows[0]["AdditionalNotes"]);
mDate = Convert.ToDateTime(DB.DataTable.Rows[0]["DateofEntry"]);
return(true);
}
else
{
return(false);
}
}
public clsOrderCollection()
{
Int32 Index = 0;
Int32 RecordCount = 0;
ClsDataConnection DB = new ClsDataConnection();
DB.Execute("sproc_tblOrder_SelectAll");
RecordCount = DB.Count;
while (Index < RecordCount)
{
ClsOrder AnOrder = new ClsOrder();
AnOrder.ONumber = Convert.ToInt32(DB.DataTable.Rows[Index]["ONumber"]);
AnOrder.CustomerID = Convert.ToInt32(DB.DataTable.Rows[Index]["CustomerID"]);
AnOrder.Complete = Convert.ToBoolean(DB.DataTable.Rows[Index]["OrderComplete"]);
AnOrder.Notes = Convert.ToString(DB.DataTable.Rows[Index]["AdditionalNotes"]);
AnOrder.Date = Convert.ToDateTime(DB.DataTable.Rows[Index]["DateOfEntry"]);
mOrderList.Add(AnOrder);
Index++;
}
}
public bool Find(int shoeId)
{
//try
//{
ClsDataConnection DB = new ClsDataConnection();
DB.AddParameter("@ShoeID", shoeId); //Another mistake here ShoeID spelling...
DB.Execute("sproc_tblStock_FilterByShoeID"); //This store procedure is not created... thats why sql connection error given.... wait..
if (DB.Count == 1)
{
MShoeID = Convert.ToInt32(DB.DataTable.Rows[0]["ShoeID"]);
MName = Convert.ToString(DB.DataTable.Rows[0]["Name"]);
MRelease = Convert.ToDateTime(DB.DataTable.Rows[0]["Release"]);
MQuantityStock = Convert.ToInt32(DB.DataTable.Rows[0]["Quantity"]);
MPriceStock = Convert.ToInt32(DB.DataTable.Rows[0]["Price"]);
MSize = Convert.ToInt32(DB.DataTable.Rows[0]["Size"]);
/**ShoeID = 2;
* MName = "A";
* MRelease = Convert.ToDateTime("16/9/2015");
* MQuantityStock = 3;
* MPriceStock = 4;
* MSize = 5;**/
return(true);
}
else
{
return(false);
}
//}
//catch (Exception)
//{
// throw;
//}
}
