public bool Find(int staffID) { clsDataConnection DB = new clsDataConnection(); DB.AddParameter("@StaffID", StaffID); DB.Execute("sproc_tblStaffData_FilterByStaffID"); if (DB.Count == 1) { mStaffID = Convert.ToString(DB.DataTable.Rows[0]["StaffID"]); mFirstName = Convert.ToString(DB.DataTable.Rows[0]["FirstName"]); mLastName = Convert.ToString(DB.DataTable.Rows[0]["LastName"]); mDepartment = Convert.ToString(DB.DataTable.Rows[0]["Department"]); mJoinDate = Convert.ToDateTime(DB.DataTable.Rows[0]["JoinDate"]); mActive = Convert.ToBoolean(DB.DataTable.Rows[0]["Active"]); } else { return(false); } //always return true return(true); }
public bool Find(int SupplierID) { clsDataConnection DB = new clsDataConnection(); DB.AddParameter("@SupplierID", SupplierID); DB.Execute("sproc_tblSupplier_FilterBySupplierID"); if (DB.Count == 1) { mSupplierID = Convert.ToInt32(DB.DataTable.Rows[0]["SupplierID"]); mCompanyName = Convert.ToString(DB.DataTable.Rows[0]["CompanyName"]); mProduct = Convert.ToString(DB.DataTable.Rows[0]["Product"]); mPhoneNumber = Convert.ToString(DB.DataTable.Rows[0]["PhoneNumber"]); mEmailAddress = Convert.ToString(DB.DataTable.Rows[0]["EmailAddress"]); mAddress = Convert.ToString(DB.DataTable.Rows[0]["Address"]); mPostCode = Convert.ToString(DB.DataTable.Rows[0]["PostCode"]); return(true); } else { return(false); } }
public bool Find(int orderID) { clsDataConnection DB = new clsDataConnection(); DB.AddParameter("OrderID", orderID); DB.Execute("sproc_tblOrder_FilterByOrderId"); //filter ID to find what we need if (DB.Count == 1) //if its found then get all other variables converted { mOrderID = Convert.ToInt32(DB.DataTable.Rows[0]["orderID"]); mGameTitle = Convert.ToString(DB.DataTable.Rows[0]["gameTitle"]); mTotalPrice = Convert.ToDecimal(DB.DataTable.Rows[0]["totalPrice"]); mDeliveryDate = Convert.ToDateTime(DB.DataTable.Rows[0]["deliveryDate"]); mShipment = Convert.ToBoolean(DB.DataTable.Rows[0]["shipment"]); return(true); } else //else return that ID was not found { return(false); } }
public bool Find(Int32 productNo) { //create instance of class clsDataConnection DB = new clsDataConnection(); DB.AddParameter("@ProductNo", ProductNo); DB.Execute("sproc_tblStock_FilterByProductNo"); if (DB.Count == 1) { mProductNo = Convert.ToInt32(DB.DataTable.Rows[0]["ProductNo"]); mQuantityOrdered = Convert.ToInt32(DB.DataTable.Rows[0]["QuantityOrdered"]); mQuantityInStock = Convert.ToInt32(DB.DataTable.Rows[0]["QuantityInStock"]); mPrice = Convert.ToDouble(DB.DataTable.Rows[0]["Price"]); mDate = Convert.ToDateTime(DB.DataTable.Rows[0]["Date"]); mProductName = Convert.ToString(DB.DataTable.Rows[0]["ProductName"]); //always return true return(true); } else { return(false); } }
// public find method public bool Find(int CustomerID) { clsDataConnection DB = new clsDataConnection(); DB.AddParameter("@CustomerID", CustomerID); DB.Execute("sproc_tblCustomer_FilterByCustomerID"); if (DB.Count == 1) { // copy data mCustomerID = Convert.ToInt32(DB.DataTable.Rows[0]["CustomerID"]); mName = Convert.ToString(DB.DataTable.Rows[0]["Name"]); mPhoneNo = Convert.ToString(DB.DataTable.Rows[0]["PhoneNo"]); mAddress = Convert.ToString(DB.DataTable.Rows[0]["Address"]); mTown = Convert.ToString(DB.DataTable.Rows[0]["Town"]); mPostCode = Convert.ToString(DB.DataTable.Rows[0]["PostCode"]); mEmailAddress = Convert.ToString(DB.DataTable.Rows[0]["EmailAddress"]); return(true); } else { return(false); } }
public bool Find(int ProductId) { clsDataConnection DB = new clsDataConnection(); DB.AddParameter("@ProductId", ProductId); DB.Execute("sproc_tblStocks_FilterByProductId"); if (DB.Count == 1) { mProductId = Convert.ToInt32(DB.DataTable.Rows[0]["ProductId"]); mProductName = Convert.ToString(DB.DataTable.Rows[0]["ProductName"]); mProductDescription = Convert.ToString(DB.DataTable.Rows[0]["ProductDescription"]); mInStock = Convert.ToInt32(DB.DataTable.Rows[0]["InStock"]); mLastRestockDate = Convert.ToDateTime(DB.DataTable.Rows[0]["LastRestockDate"]); mStockVariants = Convert.ToInt32(DB.DataTable.Rows[0]["StockVariants"]); mPrice = Convert.ToDecimal(DB.DataTable.Rows[0]["Price"]); return(true); } else { return(false); } }
public bool Find(int customerID) { clsDataConnection DB = new clsDataConnection(); DB.AddParameter("@CustomerID", CustomerID); DB.Execute("sproc_tblCustomer_FilterByCustomerID"); if (DB.Count == 1) { mCustomerID = Convert.ToInt32(DB.DataTable.Rows[0]["CustomerID"]); mCustomerDOB = Convert.ToDateTime(DB.DataTable.Rows[0]["CustomerDOB"]); mCustomerPhoneNumber = Convert.ToInt32(DB.DataTable.Rows[0]["CustomerPhoneNo"]); mCustomerFullName = Convert.ToString(DB.DataTable.Rows[0]["CustomerFullName"]); mEmailSubscription = Convert.ToBoolean(DB.DataTable.Rows[0]["EmailSubscription"]); return(true); } else { return(false); } }
public bool Find(Int32 CalcID) { clsDataConnection DB = new clsDataConnection(); DB.AddParameter("@CalcID", CalcID); DB.Execute("sproc_tblCalorieCalc_FilterByCalcID"); if (DB.Count == 1) { //copy the data from the db to the private data members mCalcID = Convert.ToInt32(DB.DataTable.Rows[0]["CalcID"]); mWeight = Convert.ToString(DB.DataTable.Rows[0]["Weight"]); mExLvl = Convert.ToString(DB.DataTable.Rows[0]["ExLvl"]); mGoalType = Convert.ToString(DB.DataTable.Rows[0]["GoalType"]); return(true); } //if no record was found else { //indicate a problem by returning false return(false); } }
//find method public bool Find(Int32 ReviewerID) { clsDataConnection DB = new clsDataConnection(); DB.AddParameter("@ReviewerID", mReviewID); DB.Execute("sproc_tblReview_FilterByReviewID"); if (DB.Count == 1) { //copy the data from the db to the private data members mReviewID = Convert.ToInt32(DB.DataTable.Rows[0]["ReviewID"]); mUsername = Convert.ToString(DB.DataTable.Rows[0]["Username"]); mDescription = Convert.ToString(DB.DataTable.Rows[0]["Description"]); mRating = Convert.ToInt32(DB.DataTable.Rows[0]["Rating"]); mRevDate = Convert.ToString(DB.DataTable.Rows[0]["RevDate"]); mSystemName = Convert.ToString(DB.DataTable.Rows[0]["SystemName"]); return(true); } //if no record found else { return(false); } }
//public property for find the Customer ID public bool find(int CustomerID) { //create an instance of the data connection clsDataConnection DB = new clsDataConnection(); //add the parameter for the customer ID to search for DB.AddParameter("@CustomerID", CustomerID); //execute the stored procedure DB.Execute("sproc_tblOrder_FilterByCustomerID"); //if one record if dound (there should be either one or zero!) if (DB.Count == 1) { //copy the data from the database to the private data members mCustomerID = Convert.ToInt32(DB.DataTable.Rows[0]["CustomerID"]); mOrderID = Convert.ToString(DB.DataTable.Rows[0]["OrderID"]); mDateAdded = Convert.ToDateTime(DB.DataTable.Rows[0]["DateAdded"]); mOrderTotalPrice = Convert.ToString(DB.DataTable.Rows[0]["OrderTotalPrice"]); mActive = Convert.ToBoolean(DB.DataTable.Rows[0]["Active"]); mSearchProduct = Convert.ToString(DB.DataTable.Rows[0]["SearchProduct"]); mCardName = Convert.ToString(DB.DataTable.Rows[0]["CardName"]); mCardNumber = Convert.ToString(DB.DataTable.Rows[0]["CardNumber"]); mSecurityCode = Convert.ToString(DB.DataTable.Rows[0]["SecurityCode"]); mExpirationDate = Convert.ToDateTime(DB.DataTable.Rows[0]["ExpirationDate"]); mAddress = Convert.ToString(DB.DataTable.Rows[0]["Address"]); mCity = Convert.ToString(DB.DataTable.Rows[0]["City"]); mPostCode = Convert.ToString(DB.DataTable.Rows[0]["PostCode"]); //return that everything worked OK return(true); } //if no record found else { //return false indicating a problem return(false); } }
public void Update() { //adds a new record in to the database depending on the values of mThisBooking //connect to the database clsDataConnection DB = new clsDataConnection(); //set the parameters for the stored procedure //set the parameters for the stored procedure DB.AddParameter("@ContractNo", mThisContract.ContractNo); DB.AddParameter("@CustomerNo", mThisContract.CustomerNo); DB.AddParameter("@PhoneID", mThisContract.PhoneID); DB.AddParameter("@ContractType", mThisContract.ContractType); DB.AddParameter("@StartDateOfContract", mThisContract.StartDateOfContract); DB.AddParameter("@EndDateOfContract", mThisContract.EndDateOfContract); //execute the query returning primary key of new record DB.Execute("sproc_tblContract_Insert"); }
public int Add(string someEmail, string someFirstName, string someLastName, string somePostcode, string someTelephone, string someTitle) { //adds a new record to the database based on the values of thisTutor //connect to the database clsDataConnection DB = new clsDataConnection(); //set the parameters for the stored procedure //DB.AddParameter("@OrderNo", mThisOrder.OrderNo); DB.AddParameter("@Email", someEmail); DB.AddParameter("@FirstName", someFirstName); DB.AddParameter("@LastName", someLastName); DB.AddParameter("@Postcode", somePostcode); DB.AddParameter("@Telephone", someTelephone); DB.AddParameter("@Title", someTitle); //DB.AddParameter("@AccountNo", someAccountNo); //execute the query returning the primary key value return(DB.Execute("sproc_tblCustomer_Insert")); }
public int Add() { //adds a new record to the database based on the values of mThisAddress //connect to the database clsDataConnection DB = new clsDataConnection(); //set the parameters for the stored procedure DB.AddParameter("@CustomerName", mThisCustomer.CustomerName); DB.AddParameter("@CustomerEmail", mThisCustomer.CustomerEmail); DB.AddParameter("@CustomerPassword", mThisCustomer.CustomerPassword); DB.AddParameter("@CustomerCardNumber", mThisCustomer.CustomerCardNumber); DB.AddParameter("@CustomerCreationDate", mThisCustomer.CustomerCreationDate); DB.AddParameter("@CustomerAccountStatus", mThisCustomer.CustomerAccountStatus); //execute the query returning the primary key value return(DB.Execute("sproc_tblCustomer_Insert")); }
public bool Find(Int32 ProductID) { clsDataConnection DB = new clsDataConnection(); DB.AddParameter("@ProductID", ProductID); DB.Execute("sproc_tblPCProducts_FilterByProductID"); if (DB.Count == 1) { mProductID = Convert.ToInt32(DB.DataTable.Rows[0]["ProductID"]); mName = Convert.ToString(DB.DataTable.Rows[0]["Name"]); mCategory = Convert.ToString(DB.DataTable.Rows[0]["Category"]); mPrice = Convert.ToInt32(DB.DataTable.Rows[0]["Price"]); mSupplier = Convert.ToString(DB.DataTable.Rows[0]["Supplier"]); return(true); } else { return(false); } }
public bool Find(int StaffID) { clsDataConnection DB = new clsDataConnection(); DB.AddParameter("@StaffID", StaffID); DB.Execute("sproc_tblStaff_FilterByStaffID"); //if a record is found if (DB.Count == 1) { mStaffID = Convert.ToInt32(DB.DataTable.Rows[0]["StaffID"]); mStaffName = Convert.ToString(DB.DataTable.Rows[0]["StaffName"]); mStaffAddress = Convert.ToString(DB.DataTable.Rows[0]["StaffAddress"]); mStartDate = Convert.ToDateTime(DB.DataTable.Rows[0]["StaffStartDate"]); mSalary = Convert.ToDouble(DB.DataTable.Rows[0]["StaffSalary"]); mManager = Convert.ToBoolean(DB.DataTable.Rows[0]["StaffManager"]); return(true); } //if no record is found else { return(false); } }
public bool Find(int ProductID) { clsDataConnection DB = new clsDataConnection(); DB.AddParameter("@ProductID", ProductID); DB.Execute("sproc_tblSupply_FilterByProductID"); if (DB.Count == 1) { mProductID = Convert.ToInt32(DB.DataTable.Rows[0]["ProductID"]); mDeliveryDate = Convert.ToDateTime(DB.DataTable.Rows[0]["DeliveryDate"]); mPrice = Convert.ToDouble(DB.DataTable.Rows[0]["Price"]); mName = Convert.ToString(DB.DataTable.Rows[0]["Name"]); mInStock = Convert.ToBoolean(DB.DataTable.Rows[0]["InStock"]); mQuantity = Convert.ToInt32(DB.DataTable.Rows[0]["Quantity"]); return(true); } else { return(false); } }
public bool Find(int OrderNum) { clsDataConnection DB = new clsDataConnection(); DB.AddParameter("@OrderNum", OrderNum); DB.Execute("sproc_tblOrder_FilterByOrderNum"); if (DB.Count == 1) { mOrderNum = Convert.ToInt32(DB.DataTable.Rows[0]["OrderNum"]); mCustomerNum = Convert.ToInt32(DB.DataTable.Rows[0]["CustomerNum"]); mItemNum = Convert.ToInt32(DB.DataTable.Rows[0]["ItemNum"]); mDateFinalised = Convert.ToDateTime(DB.DataTable.Rows[0]["DateFinalised"]); mStandaloneOrSet = Convert.ToString(DB.DataTable.Rows[0]["StandaloneOrSet"]); mQuantity = Convert.ToInt32(DB.DataTable.Rows[0]["Quantity"]); mTotalPrice = Convert.ToDouble(DB.DataTable.Rows[0]["TotalPrice"]); mReadyForShipping = Convert.ToBoolean(DB.DataTable.Rows[0]["ReadyForShipping"]); return(true); } else { return(false); } }
public Boolean Find(Int32 CompanyID) { //re-set the connection to the database MyDB = new clsDataConnection(); //pass the parameter to the stored procedure MyDB.AddParameter("@CompanyID", CompanyID); //execute the stored procedure MyDB.Execute("Sproc_tblCompany_FilterByCompanyID"); //check to see if we found anything if (MyDB.Count == 1) { //set the private data members with the data from the database //private Int32 CompanyID companyID = Convert.ToInt32(MyDB.DataTable.Rows[0]["CompanyID"]); //private string CompanyName companyName = Convert.ToString(MyDB.DataTable.Rows[0]["CompanyName"]); //private string Address address = Convert.ToString(MyDB.DataTable.Rows[0]["Address"]); //private string PostCode postcode = Convert.ToString(MyDB.DataTable.Rows[0]["PostCode"]); //private Int32 TeleNum teleNum = Convert.ToDouble(MyDB.DataTable.Rows[0]["TeleNum"]); //private string Email email = Convert.ToString(MyDB.DataTable.Rows[0]["Email"]); //private string Desc desc = Convert.ToString(MyDB.DataTable.Rows[0]["Desc"]); //return success return true; } else //CompanyID was invalid { //return that there was a problem return false; } }
public bool Find(int StockNo) { clsDataConnection DB = new clsDataConnection(); DB.AddParameter("@StockNo", StockNo); DB.Execute("sproc_tblStock_FilterByStockNo"); if (DB.Count == 1) { mStockNo = Convert.ToInt32(DB.DataTable.Rows[0]["StockNo"]); mOrderNo = Convert.ToInt32(DB.DataTable.Rows[0]["OrderNo"]); mStockDescription = Convert.ToString(DB.DataTable.Rows[0]["StockDescription"]); mDatePurchased = Convert.ToDateTime(DB.DataTable.Rows[0]["DatePurchased"]); mAvailability = Convert.ToBoolean(DB.DataTable.Rows[0]["Availability"]); mQuantity = Convert.ToInt32(DB.DataTable.Rows[0]["Quantity"]); return(true); } else { return(false); } }
public bool Find(int productNo) { //create instance of class clsDataConnection DB = new clsDataConnection(); DB.AddParameter("@ProductNo", ProductNo); DB.Execute("sproc_tblQuality_FilterByProductNo"); if (DB.Count == 1) { mProductNo = Convert.ToInt32(DB.DataTable.Rows[0]["ProductNo"]); mDate = Convert.ToDateTime(DB.DataTable.Rows[0]["Date"]); mStaffID = Convert.ToInt32(DB.DataTable.Rows[0]["StaffID"]); mBatchNo = Convert.ToInt32(DB.DataTable.Rows[0]["BatchNo"]); mGrade = Convert.ToChar(DB.DataTable.Rows[0]["Grade"]); mDefective = Convert.ToBoolean(DB.DataTable.Rows[0]["Defective"]); mProductName = Convert.ToString(DB.DataTable.Rows[0]["ProductName"]); //always return true return(true); } else { return(false); } }
void PopulateArray(clsDataConnection DB) { Int32 Index = 0; Int32 RecordCount = 0; Int32 SearchOrderId = 0; RecordCount = DB.Count; mOrdersList = new List <clsOrders>(); //While there are records while (Index < RecordCount) { //Create a blank order clsOrders Orders = new clsOrders(); //Read in fields from current record and assign to tblOrder object attributes Orders.OrderId = Convert.ToInt32(DB.DataTable.Rows[Index]["OrderId"]); SearchOrderId = Convert.ToInt32(DB.DataTable.Rows[Index]["OrderId"]); Orders.DispatchedStatus = Convert.ToBoolean(DB.DataTable.Rows[Index]["DispatchedStatus"]); Orders.DeliveryAddress = Convert.ToString(DB.DataTable.Rows[Index]["DeliveryAddress"]); Orders.OrderDate = Convert.ToDateTime(DB.DataTable.Rows[Index]["OrderDate"]); clsDataConnection DBO = new clsDataConnection(); DBO.AddParameter("@OrderId", SearchOrderId); DBO.Execute("sproc_tblOrderline_Filter_By_OrderId"); Orders.ItemId = Convert.ToInt32(DBO.DataTable.Rows[0]["ItemId"]); Orders.Quantity = Convert.ToInt32(DBO.DataTable.Rows[0]["Quantity"]); Orders.ProductCode = Convert.ToString(DBO.DataTable.Rows[0]["ProductCode"]); Orders.UnitPrice = Convert.ToDouble(DBO.DataTable.Rows[0]["UnitPrice"]); mOrdersList.Add(Orders); Index++; } }
public bool Find(int ProductID) { clsDataConnection DB = new clsDataConnection(); DB.AddParameter("@ProductID", ProductID); DB.Execute("sproc_tblStockManagement_FilterByProductID"); if (DB.Count == 1) { //set the private data members to the test data value mProductID = Convert.ToInt32(DB.DataTable.Rows[0]["ProductID"]); mBookName = Convert.ToString(DB.DataTable.Rows[0]["BookName"]); mAuthorName = Convert.ToString(DB.DataTable.Rows[0]["AuthorName"]); mAvailable = Convert.ToBoolean(DB.DataTable.Rows[0]["Available"]); mPrice = Convert.ToDouble(DB.DataTable.Rows[0]["Price"]); mPublishDate = Convert.ToDateTime(DB.DataTable.Rows[0]["PublishDate"]); //always return true return(true); //throw new NotImplementedException(); } else { return(false); } }
public int Add() { //add new record basedon values of mThisItem //connect to database clsDataConnection DB = new clsDataConnection(); //set parameters for the stored procedure DB.AddParameter("@ItemName", mThisItem.ItemName); DB.AddParameter("@Price", mThisItem.Price); DB.AddParameter("@Material", mThisItem.Material); if (mThisItem.LastPurchased == null) { DB.AddParameter("@LastPurchased", DBNull.Value); } else { DB.AddParameter("@LastPurchased", mThisItem.LastPurchased); } DB.AddParameter("@Quantity", mThisItem.Quantity); DB.AddParameter("@InStock", mThisItem.InStock); //execute query returning primary key return(DB.Execute("sproc_tblStock_Insert")); }
public void Update() { //connect to database clsDataConnection DB = new clsDataConnection(); //set parameters DB.AddParameter("@ShippingId", mThisShipment.ShippingId); DB.AddParameter("@ShippingType", mThisShipment.ShippingType); DB.AddParameter("@Price", mThisShipment.Price); if (mThisShipment.DateOfDispatch == null) { DB.AddParameter("@DateOfDispatch", DBNull.Value); } else { DB.AddParameter("@DateOfDispatch", mThisShipment.DateOfDispatch); } DB.AddParameter("@Dispatched", mThisShipment.Dispatched); //execute stored procedure DB.Execute("sproc_tblShipping_Update"); }
void PopulateArray(clsDataConnection DB) { int Index = 0; int RecordCount = 0; RecordCount = DB.Count; mProductsList = new List <clsStock>(); while (Index < RecordCount) { clsStock AProduct = new clsStock(); DB.AddParameter("@ProductId", mThisProduct.ProductId); DB.AddParameter("@ProductName", mThisProduct.ProductName); DB.AddParameter("@ReleaseDate", mThisProduct.ReleaseDate); DB.AddParameter("@Price", mThisProduct.Price); DB.AddParameter("@InStock", mThisProduct.InStock); DB.AddParameter("@ProductDescription", mThisProduct.ProductDescription); mProductsList.Add(AProduct); Index++; } }
public void Update() { //update an existing record based on the values of thisAddress //connect to the database clsDataConnection DB = new clsDataConnection(); //set the parameters for the stored procedure DB.AddParameter("StaffNo", mThisStaff.StaffNo); DB.AddParameter("FirstName", mThisStaff.FirstName); DB.AddParameter("Surname", mThisStaff.Surname); DB.AddParameter("Sex", mThisStaff.Sex); DB.AddParameter("DOB", mThisStaff.DOB); DB.AddParameter("Address1", mThisStaff.Address1); DB.AddParameter("Address2", mThisStaff.Address2); DB.AddParameter("Address3", mThisStaff.Address3); DB.AddParameter("PostCode", mThisStaff.PostCode); DB.AddParameter("Email", mThisStaff.Email); DB.AddParameter("Phone", mThisStaff.Phone); //execute the stored procedure DB.Execute("sproc_tblStaff_Update"); }
public void Update() { //update an existing record based on the values of thisPerson //connect to the database clsDataConnection DB = new clsDataConnection(); //set the parameters for the stored procedure DB.AddParameter("PersonID", mThisPerson.PersonID); DB.AddParameter("FirstName", mThisPerson.FirstName); DB.AddParameter("LastName", mThisPerson.LastName); DB.AddParameter("Address", mThisPerson.Address); DB.AddParameter("TeleNo", mThisPerson.TeleNo); DB.AddParameter("Email", mThisPerson.Email); DB.AddParameter("DoB", mThisPerson.DoB); DB.AddParameter("Postcode", mThisPerson.Postcode); DB.AddParameter("Town", mThisPerson.Town); DB.AddParameter("Country", mThisPerson.Country); DB.AddParameter("Username", mThisPerson.Username); //execute the stored procedure DB.Execute("sproc_tblPerson_Update"); }
public void Update() { //update an existing record based on the values of thiscustomer //connect to the database clsDataConnection DB = new clsDataConnection(); //set the parameters for the stored procedure DB.AddParameter("@CustomerId", mThisCustomer.customerid); DB.AddParameter("@UserName", mThisCustomer.username); DB.AddParameter("@Password", mThisCustomer.password); DB.AddParameter("@AddressCityName", mThisCustomer.cityname); DB.AddParameter("@AddressName", mThisCustomer.addressName); DB.AddParameter("@AddressPostCode", mThisCustomer.postcode); DB.AddParameter("@AddressStreetName", mThisCustomer.streetname); DB.AddParameter("@CardNumber", mThisCustomer.cardnumber); DB.AddParameter("@EmailAddress", mThisCustomer.emailaddress); DB.AddParameter("@ExpiryDate", mThisCustomer.expirydate); DB.AddParameter("@FirstName", mThisCustomer.firstname); DB.AddParameter("@LastName", mThisCustomer.lastname); DB.AddParameter("@MobileNumber", mThisCustomer.mobilenumber); DB.AddParameter("@SecurityCode", mThisCustomer.secruitycode); //execute the stored procedure DB.Execute("sproc_Customer_Update"); }
//{ // //var for the index // Int32 Index = 0; // //var to store the record count // Int32 RecordCount = 0; // //object for data connection // clsDataConnection DB = new clsDataConnection(); // //executre the stored procedure // DB.Execute("sproc_Customer_SelectAll"); // //get the count of the records // RecordCount = DB.Count; // //while there are records to process // while (Index < RecordCount) // { // //create a blank address // clsCustomerDetails AnCustomer = new clsCustomerDetails(); // //read in the fields from the current record // AnCustomer.customerid = Convert.ToInt32(DB.DataTable.Rows[Index]["CustomerId"]); // AnCustomer.username = Convert.ToString(DB.DataTable.Rows[Index]["UserName"]); // AnCustomer.password = Convert.ToString(DB.DataTable.Rows[Index]["Password"]); // AnCustomer.firstname = Convert.ToString(DB.DataTable.Rows[Index]["FirstName"]); // AnCustomer.lastname = Convert.ToString(DB.DataTable.Rows[Index]["LastName"]); // AnCustomer.emailaddress = Convert.ToString(DB.DataTable.Rows[Index]["EmailAddress"]); // AnCustomer.mobilenumber = Convert.ToString(DB.DataTable.Rows[Index]["MobileNumber"]); // AnCustomer.cardnumber = Convert.ToString(DB.DataTable.Rows[Index]["CardNumber"]); // AnCustomer.secruitycode = Convert.ToString(DB.DataTable.Rows[Index]["SecurityCode"]); // AnCustomer.expirydate = Convert.ToDateTime(DB.DataTable.Rows[Index]["ExpiryDate"]); // AnCustomer.addressName = Convert.ToString(DB.DataTable.Rows[Index]["AddressName"]); // AnCustomer.streetname = Convert.ToString(DB.DataTable.Rows[Index]["AddressStreetName"]); // AnCustomer.cityname = Convert.ToString(DB.DataTable.Rows[Index]["AddressCityName"]); // AnCustomer.postcode = Convert.ToString(DB.DataTable.Rows[Index]["AddressPostCode"]); // //add the record to the provate data member // mCustomerList.Add(AnCustomer); // //point at the next record // Index++; // } //} public int Add() { clsDataConnection DB = new clsDataConnection(); { DB.AddParameter("@UserName", mThisCustomer.username); DB.AddParameter("@Password", mThisCustomer.password); DB.AddParameter("@AddressCityName", mThisCustomer.cityname); DB.AddParameter("@AddressName", mThisCustomer.addressName); DB.AddParameter("@AddressPostCode", mThisCustomer.postcode); DB.AddParameter("@AddressStreetName", mThisCustomer.streetname); DB.AddParameter("@CardNumber", mThisCustomer.cardnumber); DB.AddParameter("@EmailAddress", mThisCustomer.emailaddress); DB.AddParameter("@ExpiryDate", mThisCustomer.expirydate); DB.AddParameter("@FirstName", mThisCustomer.firstname); DB.AddParameter("@LastName", mThisCustomer.lastname); DB.AddParameter("@MobileNumber", mThisCustomer.mobilenumber); DB.AddParameter("@SecurityCode", mThisCustomer.secruitycode); return(DB.Execute("sproc_Customer_Add")); } }
// this method is to test any staff login credentials off the database of every user public Boolean TestLogin(string UserName, string Password) { // add the parameters to use for this function MyDatabase.AddParameter("@UserName", UserName); MyDatabase.AddParameter("@Password", Password); // execute the stsored procedure MyDatabase.Execute("sproc_tblStaff_Login"); // if a record is found if (MyDatabase.Count == 1) { return(true); } else { return(false); } }