C# Класс CinderellaLauncher.SQL_Queries

Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод	Описание
AddGodmotherShift ( string fairyGodmotherID, string shiftID, string roleID ) : void	Adds a godmother to a shift.
AllSeamstresses ( ) : string	Retrieves all FG's that are seamstresses
CheckInSearch ( string fname, string lname, string organization ) : string	Used with text box inputs to parse the data, returning results for the check-in list.
CheckOutSearch ( string fname, string lname, string organization ) : string	Search for Check Out Form. Used in populating the DGV according to search parameters
CinderellaCurrentStatus ( int id ) : int	Gives a cinderella's current status
CinderellaHistory ( int cinID ) : string
Cinderellas ( int currentStatus ) : string	Finds cinderellas with a certain status
Cinderellas ( int currentStatus1, int currentStatus2 ) : string	Finds Cinderellas that have a currentStatus between two options
CinderellasInAlteration ( ) : string	displays the cinderellas that are currently in alterations (status of 6) and their end time of their alterations is null, indicating that the dress has not been completed in alterations. (currently being worked on or if more time is needed.)
CinderellasList ( int count, int currentStatus ) : string	Finds cinderellas with a certain status and displays the top number of them
CinderellasUndoList ( ) : string	Used to show cinderellas that are waiting or paired. Used for when we have to undo the Cinderella's check-in because of accidental check-in
CindyBracelet ( int fgID ) : string
CindyDressColor ( int fgID ) : string
CindyDressSize ( int fgID ) : int
CindyEarrings ( int fgID ) : string
CindyHeadpiece ( int fgID ) : string
CindyNecklace ( int fgID ) : string
CindyRing ( int fgID ) : string
CindyShoeColor ( int fgID ) : string
CindyShoeSize ( int fgID ) : string
DressesNotFinished ( ) : string
EndShift ( ) : void
FGCurrentStatus ( int id ) : int	Gives a FG's current status
FGLeavesCinderella ( int cinID ) : void	Sets the Cinderella's FairyGodmother to be unavailable if the Cinderella is the last known paired Cinderella for the FairyGodmother and the FairyGodmother is currently shopping
FGMaxID ( ) : string
FGQuickSearch ( int fgID ) : string
FGcount ( ) : string
FairyGodmotherHistory ( int fgID ) : string
MasterSearch ( string cinFirstName, string cinLastName, string cinOrganization, string FGFirstName, string FGLastName, int SeamstressID, int hadAlterations, string dressColor, int maxDressSize, int minDressSize, bool hasShoes, string shoeColor, double maxShoeSize, double minShoeSize, int ring, int headpiece, int bracelet, int earring, int necklace ) : string	Used to search for anything needed in the program.
MaxID ( ) : string
NewCinderella ( string fname, string lname, string date, string time, int referralID ) : string	Inserts into the Cinderella Table the new Cinderella to be added
NewGodMother ( string fname, string lname, string address, string city, string emailAddress, string phoneNumber, string state, string zip ) : string	Adds a new Godmother to the database. Since the godmother id's are automatically assigned this method will return their ID so that you can use that in the rest of the program logic like adding the godmother to shifts.
NumberOfCinderellasHelped ( ) : int	Used to find the number of cinderellas that have gone through. (based on the number that have been paired
NumberOfCinderellasHelpedByFG ( ) : string	USed to find the number of cinderellas that have been helped by a certain FG
NumberOfDressesAlteredByFG ( ) : string	Used to find the number of dresses a fairy godmother has altered
NumberOfDressesTakenByColor ( string color ) : int	USed to find the number of dresses that have been picked of a certain color
NumberOfDressesTakenByColorAndSize ( string color, int size ) : int	USed to find the number of dresses that have been picked of a certain color and size
NumberOfDressesTakenBySize ( int size ) : int	USed to find the number of dresses that have been picked of a certain size
NumberOfFGsByShift ( int shift ) : int	Used to find the number of FG's that worked a certain shift
NumberOfFGsByShiftAndRole ( int shift, int role ) : int	Used to find the number of FG's that worked a certain shift with a certain role
PackageBracelet ( int id ) : bool	Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'
PackageCheckOutNotes ( int id ) : string	Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'
PackageEarrings ( int id ) : bool	Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'
PackageHeadpiece ( int id ) : bool	Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'
PackageNecklace ( int id ) : bool	Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'
PackageOther ( int id ) : string	Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'
PackageRing ( int id ) : bool	Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'
PackageShoeColor ( int id ) : string	Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'
PackageShoeSize ( int id ) : double	Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'
PairedPersonalShoppers ( int cinderellaID ) : string	finds fairy godmother's ID# that are paired w/ a cinderella
PersonalShoppers ( int currentStatus ) : string	returns FG's that are personal shoppers and have the specified current status
PersonalShoppers ( int currentStatus1, int currentStatus2 ) : string	Finds Personal shoppers that have a currentStatus between two options
PersonalShoppersList ( int count, int currentStatus ) : string	Returns a certain number of Personal Shoppers w/ a specified status
PrintCinderellaName ( string ID ) : string
PrintFGIDGrid ( ) : string
PrintFGName ( string ID ) : string
PrintFirstCinderellaName ( string ID ) : string
PrintFirstFGName ( string ID ) : string
PrintIDGrid ( ) : string
PrintLastCinderellaName ( string ID ) : string
PrintLastFGName ( string ID ) : string
RetrievedDress ( int cinID ) : void	Tells the DB that the cinderella got the dress back from alterations
SQL_Queries ( ) : System
ShiftWorkerRole ( int fgID, int shiftID ) : int
addAlterations ( string cindID ) : void	Adds a Cinderella into Alterations
addCinderellaAndReferral ( string refName, string refOrg, string cindFirstName, string cindLastName, string apptDate, string apptTime, string notes ) : void	Adds a Cinderella and new referral to respective tables
addUser ( string loginName, string password, string firstName, string lastName, int roleID ) : void
alterationCompleted ( ) : string	Views cinderellas that have been completely through alterations
checkAlterations ( string id ) : string	USed to check if a Cinderella is in Alterations
checkInList ( ) : string	Query for retrieving Cinderella's with a status of 'Pending' (Approved to come to Cinderella's Closet but not yet checked in)
checkOutList ( ) : string
checkOutList ( int count ) : string	Displays the list of Cinderellas that are ready for checkout. (They are shopping or are in alterations).
checkOutUpdate ( int cinderellaID, int dressSize, string dressColor ) : void
checkOutUpdate ( int cinderellaID, int dressSize, string dressColor, double shoeSize, string shoeColor, string checkoutNotes, bool necklace, bool ring, bool bracelet, bool headpiece, bool earrings, string other ) : void	Updates a cinderella's package with all necesary information
checkedOutCinderellas ( ) : string
cinderellaCheckIn ( ) : DataSet
clearCinderellaFairyGodmotherID ( int id ) : void
count ( ) : string
deleteCinderellas ( ) : void	Deletes everything from Cinderellas table
deleteFGs ( ) : void	Deletes everything from FG table
dressColor ( int id ) : string	Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'
dressSize ( int id ) : int	Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'
dressesDone ( ) : string	Returns the data for the DGV for Cinderellas dresses that are done in Alterations.
fairyGodmotherCheckIn ( ) : string
fgList ( ) : string	USed to find all info on FG's
fgListCheckedIn ( ) : string	USed to find FG's that are checked in
fgListRole ( string roleID ) : string	Used to find FG's with a certain role
fgListRoleCheckedIn ( string roleID ) : string	Used to find FG's that have a certain role and are 'Available'
fgListRoleManagement ( int roleID ) : string	Used to find a FG that is paired with a Cinderella and has a certain role id
fgListRoleManagement ( string roleID ) : string	Used to find FG & Cinderella's first and last names that are paired.
fgListRoleManagement ( string roleID, int currentStatus ) : string	USed to find a FG that has a certain role and status
fgListShort ( ) : string	Used tp find basic FG info
fgListStatus ( string status ) : string	Used to find info on all FG's according to their status
fgListStatus ( string status, string shift ) : string	used to find all info on FG's according to their status and shift
fglistSearch ( string fname, string lname ) : string
fglistSearch ( string fname, string lname, int currentStatus ) : string	USed to search the FG list
getCinderellaPaired ( int id ) : string	Used to find a Cinderella's id that is paired with a certain FG
getCinderellaStatus ( int id ) : string
getCindyIDFomFG ( int idFG ) : int
getCurrentlyShopping ( ) : DataSet	Retrieves a dataset of those who are currently shopping.
getDate ( ) : string	Retrieves the current date and time from the database server.
getDressInfo ( string id ) : string
getFGShiftInfo ( string fgID ) : string	Used to find what shift and role a FG has when they work
getFGStatus ( string fgID ) : string
getFgPaired ( int id ) : string	Used to find the FG that is paired with a Cinderella
getMaxCinderellaID ( ) : string
getPackageInfo ( string id ) : string	Returns all data from Package table for a certain Cinderella
getReferrals ( ) : string	Used to retrieve the list of referrals
getSetting ( string settingName ) : string
getTime ( int id ) : string
newFGShiftWorker ( string firstName, string lastName, int shiftID, int roleID ) : void	Used to add a FG to a shift
pairCinderella ( int cinderellaID, int fg_id ) : void	Used to manually pair a cinderella
resetDB ( ) : void	Soft reset of the Database
setCinderellaStatus ( string ID, int status ) : void	Sets the status of a cinderella or godmother.
setDefaultSetting ( string settingName, string defaultValue ) : void
setFGStatus ( string ID, int status ) : void
setFGStatusScan ( string ID, int status, int shift ) : void	Used to set a FG to a certain status (Available, Unavailable, Paired, Shopping)
setSettingValue ( string settingName, string settingValue ) : void
showFairyGodmothers ( int shift, int status ) : string
sqlSelect ( string keyword ) : DataSet	This method houses all of the basic "Select" statements.
sqlStatment ( string mysql ) : int	Will execute a non-query sql statment.
statusList ( int statusID ) : string	Used to get a cinderella's status, along with their name and their FG's name
undoCinderellaPairFromFGID ( int fgID ) : void	Used to undo a FG's pairing with a cinderella
undoCinderellaStatus ( int id, int status ) : void	Undos the status change of the given status for the Cinderella if that status is the last known status The CinDeleteStatusTrigger will update to the correct currentStatus
undoCinderellaUntilThisStatus ( int cinID, int status ) : void	Undos the status changes until the given status for the Cinderella The CinDeleteStatusTrigger will update to the correct currentStatus
undoFGPairFromCinderellaID ( int cinID ) : void	Used to undo a Cinderella's pairing with a FG
undoFGStatus ( int id, int status ) : void	Undos the status changes of the given status for the FairyGodmother fi that status is the last known status The FGDeleteStatusTrigger will update to the correct currentStatus
undoFGUntilThisStatus ( int fgID, int status ) : void	Undos the status changes until the given status for the FairyGodmother The FGDeleteStatusTrigger will update to the correct currentStatus
updateAlterations ( string cindID, string notes, int straps, int darts, int zipper, int mending, int takeIn, int bust, int hem, string fgID ) : void	Used to give alterations to a Cinderella
updateAlterationsNotFinished ( string cindID, string notes, int straps, int darts, int zipper, int mending, int takeIn, int bust, int hem, string fgID ) : void	used to give alterations to a Cinderella (This is used when their alterations will not be completed onsite)
updateCinderella ( int id, string firstName, string lastName, string date, string time ) : string	Used to update a cinderella's information. This is used if the Cinderella's information was incorrect and needed to be fixed, or if the appointment time and date needs to be changed
updateCinderellaAppt ( int id ) : void	Used to change a cinderella's appointment time when the current date and time button is clicked
updateCinderellaAppt ( int id, string date, string time ) : void	Used to change a cinderella's appointment time when a manually entered date and time are needed
updateFairyGodmother ( string fgID, string firstName, string lastName, string emailAddress, string phoneNumber, string city, string state, string zip, string address ) : string	Updates FG's info
validateLogin ( string username, string password ) : int	Used to validate the login of a user

Приватные методы

Метод	Описание
MasterCheckOutSearchBox ( string item ) : string
MasterSearchBox ( string item ) : string

Описание методов

AddGodmotherShift() публичный Метод

Adds a godmother to a shift.

public AddGodmotherShift ( string fairyGodmotherID, string shiftID, string roleID ) : void
fairyGodmotherID	string
shiftID	string
roleID	string
Результат	void

AllSeamstresses() публичный Метод

Retrieves all FG's that are seamstresses

public AllSeamstresses ( ) : string
Результат	string

CheckInSearch() публичный Метод

Used with text box inputs to parse the data, returning results for the check-in list.

public CheckInSearch ( string fname, string lname, string organization ) : string
fname	string	Cinderella's First Name
lname	string	Cinderella's Last Name
organization	string	Cinderella's Referrat Organization
Результат	string

CheckOutSearch() публичный Метод

Search for Check Out Form. Used in populating the DGV according to search parameters

public CheckOutSearch ( string fname, string lname, string organization ) : string
fname	string	Cinderella First Name
lname	string	Cinderella Last Name
organization	string	Cinderella's Organization (pulled from Referral table in DB according to a Cinderella's referralID)
Результат	string

CinderellaCurrentStatus() публичный Метод

Gives a cinderella's current status

public CinderellaCurrentStatus ( int id ) : int
id	int	Cinderella's current ID#
Результат	int

CinderellaHistory() публичный Метод

public CinderellaHistory ( int cinID ) : string
cinID	int
Результат	string

Cinderellas() публичный Метод

Finds cinderellas with a certain status

public Cinderellas ( int currentStatus ) : string
currentStatus	int	cinderella's current statud desired
Результат	string

Cinderellas() публичный Метод

Finds Cinderellas that have a currentStatus between two options

public Cinderellas ( int currentStatus1, int currentStatus2 ) : string
currentStatus1	int	one status #
currentStatus2	int	the other status #
Результат	string

CinderellasInAlteration() публичный Метод

displays the cinderellas that are currently in alterations (status of 6) and their end time of their alterations is null, indicating that the dress has not been completed in alterations. (currently being worked on or if more time is needed.)

public CinderellasInAlteration ( ) : string
Результат	string

CinderellasList() публичный Метод

Finds cinderellas with a certain status and displays the top number of them

public CinderellasList ( int count, int currentStatus ) : string
count	int	number of cinderellas to display
currentStatus	int	cinderella's current status desired
Результат	string

CinderellasUndoList() публичный Метод

Used to show cinderellas that are waiting or paired. Used for when we have to undo the Cinderella's check-in because of accidental check-in

public CinderellasUndoList ( ) : string
Результат	string

CindyBracelet() публичный Метод

public CindyBracelet ( int fgID ) : string
fgID	int
Результат	string

CindyDressColor() публичный Метод

public CindyDressColor ( int fgID ) : string
fgID	int
Результат	string

CindyDressSize() публичный Метод

public CindyDressSize ( int fgID ) : int
fgID	int
Результат	int

CindyEarrings() публичный Метод

public CindyEarrings ( int fgID ) : string
fgID	int
Результат	string

CindyHeadpiece() публичный Метод

public CindyHeadpiece ( int fgID ) : string
fgID	int
Результат	string

CindyNecklace() публичный Метод

public CindyNecklace ( int fgID ) : string
fgID	int
Результат	string

CindyRing() публичный Метод

public CindyRing ( int fgID ) : string
fgID	int
Результат	string

CindyShoeColor() публичный Метод

public CindyShoeColor ( int fgID ) : string
fgID	int
Результат	string

CindyShoeSize() публичный Метод

public CindyShoeSize ( int fgID ) : string
fgID	int
Результат	string

DressesNotFinished() публичный Метод

public DressesNotFinished ( ) : string
Результат	string

EndShift() публичный Метод

public EndShift ( ) : void
Результат	void

FGCurrentStatus() публичный Метод

Gives a FG's current status

public FGCurrentStatus ( int id ) : int
id	int	FG ID#
Результат	int

FGLeavesCinderella() публичный Метод

Sets the Cinderella's FairyGodmother to be unavailable if the Cinderella is the last known paired Cinderella for the FairyGodmother and the FairyGodmother is currently shopping

public FGLeavesCinderella ( int cinID ) : void
cinID	int	Cinderellas given id
Результат	void

FGMaxID() публичный Метод

public FGMaxID ( ) : string
Результат	string

FGQuickSearch() публичный Метод

public FGQuickSearch ( int fgID ) : string
fgID	int
Результат	string

FGcount() публичный Метод

public FGcount ( ) : string
Результат	string

FairyGodmotherHistory() публичный Метод

public FairyGodmotherHistory ( int fgID ) : string
fgID	int
Результат	string

MasterSearch() публичный Метод

Used to search for anything needed in the program.

public MasterSearch ( string cinFirstName, string cinLastName, string cinOrganization, string FGFirstName, string FGLastName, int SeamstressID, int hadAlterations, string dressColor, int maxDressSize, int minDressSize, bool hasShoes, string shoeColor, double maxShoeSize, double minShoeSize, int ring, int headpiece, int bracelet, int earring, int necklace ) : string
cinFirstName	string	Cinderellas First Name
cinLastName	string	Cinderella's Last Name
cinOrganization	string	Cinderella's Organization
FGFirstName	string	FG's First Name
FGLastName	string	FG's last name
SeamstressID	int	ID# of a seamstress
hadAlterations	int	int for if a cinderella has had alterations
dressColor	string	Dress Color
maxDressSize	int	Maximum Dress Size (int)
minDressSize	int	minimum Dress Size (int)
hasShoes	bool	If the cinderella wanted shoes or not
shoeColor	string	shoe color
maxShoeSize	double	Maximum Shoe Size (int)
minShoeSize	double	minimum Shoe Size (int)
ring	int	Ring int (for bool)
headpiece	int	headpiece int (for bool)
bracelet	int	bracelet int (for bool)
earring	int	earring int (for bool)
necklace	int	necklace int (for bool)
Результат	string

MaxID() публичный Метод

public MaxID ( ) : string
Результат	string

NewCinderella() публичный Метод

Inserts into the Cinderella Table the new Cinderella to be added

public NewCinderella ( string fname, string lname, string date, string time, int referralID ) : string
fname	string	Cinderellas First Name
lname	string	Cinderellas Last Name
date	string	Cinderellas Appt Date
time	string	Cinderellas Appt Time
referralID	int
Результат	string

NewGodMother() публичный Метод

Adds a new Godmother to the database. Since the godmother id's are automatically assigned this method will return their ID so that you can use that in the rest of the program logic like adding the godmother to shifts.

public NewGodMother ( string fname, string lname, string address, string city, string emailAddress, string phoneNumber, string state, string zip ) : string
fname	string	Godmothers First Name
lname	string	Godmothers Last Name
address	string
city	string
emailAddress	string
phoneNumber	string
state	string
zip	string
Результат	string

NumberOfCinderellasHelped() публичный Метод

Used to find the number of cinderellas that have gone through. (based on the number that have been paired

public NumberOfCinderellasHelped ( ) : int
Результат	int

NumberOfCinderellasHelpedByFG() публичный Метод

USed to find the number of cinderellas that have been helped by a certain FG

public NumberOfCinderellasHelpedByFG ( ) : string
Результат	string

NumberOfDressesAlteredByFG() публичный Метод

Used to find the number of dresses a fairy godmother has altered

public NumberOfDressesAlteredByFG ( ) : string
Результат	string

NumberOfDressesTakenByColor() публичный Метод

USed to find the number of dresses that have been picked of a certain color

public NumberOfDressesTakenByColor ( string color ) : int
color	string	The dress color
Результат	int

NumberOfDressesTakenByColorAndSize() публичный Метод

USed to find the number of dresses that have been picked of a certain color and size

public NumberOfDressesTakenByColorAndSize ( string color, int size ) : int
color	string	The dress color
size	int	The dress size
Результат	int

NumberOfDressesTakenBySize() публичный Метод

USed to find the number of dresses that have been picked of a certain size

public NumberOfDressesTakenBySize ( int size ) : int
size	int	The dress size
Результат	int

NumberOfFGsByShift() публичный Метод

Used to find the number of FG's that worked a certain shift

public NumberOfFGsByShift ( int shift ) : int
shift	int	the shift #
Результат	int

NumberOfFGsByShiftAndRole() публичный Метод

Used to find the number of FG's that worked a certain shift with a certain role

public NumberOfFGsByShiftAndRole ( int shift, int role ) : int
shift	int	the shift #
role	int	the role number
Результат	int

PackageBracelet() публичный Метод

Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'

public PackageBracelet ( int id ) : bool
id	int	Cinderella's ID#
Результат	bool

PackageCheckOutNotes() публичный Метод

Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'

public PackageCheckOutNotes ( int id ) : string
id	int	Cinderella's ID#
Результат	string

PackageEarrings() публичный Метод

Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'

public PackageEarrings ( int id ) : bool
id	int	Cinderella's ID#
Результат	bool

PackageHeadpiece() публичный Метод

Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'

public PackageHeadpiece ( int id ) : bool
id	int	Cinderella's ID#
Результат	bool

PackageNecklace() публичный Метод

Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'

public PackageNecklace ( int id ) : bool
id	int	Cinderella's ID#
Результат	bool

PackageOther() публичный Метод

Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'

public PackageOther ( int id ) : string
id	int	Cinderella's ID#
Результат	string

PackageRing() публичный Метод

Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'

public PackageRing ( int id ) : bool
id	int	Cinderella's ID#
Результат	bool

PackageShoeColor() публичный Метод

Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'

public PackageShoeColor ( int id ) : string
id	int	Cinderella's ID#
Результат	string

PackageShoeSize() публичный Метод

Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'

public PackageShoeSize ( int id ) : double
id	int	Cinderella's ID#
Результат	double

PairedPersonalShoppers() публичный Метод

finds fairy godmother's ID# that are paired w/ a cinderella

public PairedPersonalShoppers ( int cinderellaID ) : string
cinderellaID	int	cinderellas ID#
Результат	string

PersonalShoppers() публичный Метод

returns FG's that are personal shoppers and have the specified current status

public PersonalShoppers ( int currentStatus ) : string
currentStatus	int	status #
Результат	string

PersonalShoppers() публичный Метод

Finds Personal shoppers that have a currentStatus between two options

public PersonalShoppers ( int currentStatus1, int currentStatus2 ) : string
currentStatus1	int	one status #
currentStatus2	int	the other status #
Результат	string

PersonalShoppersList() публичный Метод

Returns a certain number of Personal Shoppers w/ a specified status

public PersonalShoppersList ( int count, int currentStatus ) : string
count	int	number of Fg's to be shown
currentStatus	int	the desired status #
Результат	string

PrintCinderellaName() публичный Метод

public PrintCinderellaName ( string ID ) : string
ID	string
Результат	string

PrintFGIDGrid() публичный Метод

public PrintFGIDGrid ( ) : string
Результат	string

PrintFGName() публичный Метод

public PrintFGName ( string ID ) : string
ID	string
Результат	string

PrintFirstCinderellaName() публичный Метод

public PrintFirstCinderellaName ( string ID ) : string
ID	string
Результат	string

PrintFirstFGName() публичный Метод

public PrintFirstFGName ( string ID ) : string
ID	string
Результат	string

PrintIDGrid() публичный Метод

public PrintIDGrid ( ) : string
Результат	string

PrintLastCinderellaName() публичный Метод

public PrintLastCinderellaName ( string ID ) : string
ID	string
Результат	string

PrintLastFGName() публичный Метод

public PrintLastFGName ( string ID ) : string
ID	string
Результат	string

RetrievedDress() публичный Метод

Tells the DB that the cinderella got the dress back from alterations

public RetrievedDress ( int cinID ) : void
cinID	int	Cinderella's ID#
Результат	void

SQL_Queries() публичный Метод

public SQL_Queries ( ) : System
Результат	System

ShiftWorkerRole() публичный Метод

public ShiftWorkerRole ( int fgID, int shiftID ) : int
fgID	int
shiftID	int
Результат	int

addAlterations() публичный Метод

Adds a Cinderella into Alterations

public addAlterations ( string cindID ) : void
cindID	string	Cinderella's ID#
Результат	void

addCinderellaAndReferral() публичный Метод

Adds a Cinderella and new referral to respective tables

public addCinderellaAndReferral ( string refName, string refOrg, string cindFirstName, string cindLastName, string apptDate, string apptTime, string notes ) : void
refName	string	Referral Name
refOrg	string	Referral Organization
cindFirstName	string	Cinderella's First Name
cindLastName	string	Cinderella's Last Name
apptDate	string	Appointment Date
apptTime	string	Appointment Time
notes	string	any notes
Результат	void

addUser() публичный Метод

public addUser ( string loginName, string password, string firstName, string lastName, int roleID ) : void
loginName	string
password	string
firstName	string
lastName	string
roleID	int
Результат	void

alterationCompleted() публичный Метод

Views cinderellas that have been completely through alterations

public alterationCompleted ( ) : string
Результат	string

checkAlterations() публичный Метод

USed to check if a Cinderella is in Alterations

public checkAlterations ( string id ) : string
id	string	Cinderella's ID
Результат	string

checkInList() публичный Метод

Query for retrieving Cinderella's with a status of 'Pending' (Approved to come to Cinderella's Closet but not yet checked in)

public checkInList ( ) : string
Результат	string

checkOutList() публичный Метод

public checkOutList ( ) : string
Результат	string

checkOutList() публичный Метод

Displays the list of Cinderellas that are ready for checkout. (They are shopping or are in alterations).

public checkOutList ( int count ) : string
count	int	Specifies the number of cinderellas to be displayed.
Результат	string

checkOutUpdate() публичный Метод

public checkOutUpdate ( int cinderellaID, int dressSize, string dressColor ) : void
cinderellaID	int
dressSize	int
dressColor	string
Результат	void

checkOutUpdate() публичный Метод

Updates a cinderella's package with all necesary information

public checkOutUpdate ( int cinderellaID, int dressSize, string dressColor, double shoeSize, string shoeColor, string checkoutNotes, bool necklace, bool ring, bool bracelet, bool headpiece, bool earrings, string other ) : void
cinderellaID	int	Cinderella's ID
dressSize	int	Dress Size
dressColor	string	Dress Color
shoeSize	double	Shoe Size
shoeColor	string	Shoe Color
checkoutNotes	string	Checkout Notes (Can Be Null)
necklace	bool	Necklace Bool
ring	bool	Ring Bool
bracelet	bool	Bracelet Bool
headpiece	bool	Headpiece Bool
earrings	bool	Earrings Bool
other	string	Other accessories (Can Be Null)
Результат	void

checkedOutCinderellas() публичный Метод

public checkedOutCinderellas ( ) : string
Результат	string

cinderellaCheckIn() публичный Метод

public cinderellaCheckIn ( ) : DataSet
Результат	System.Data.DataSet

clearCinderellaFairyGodmotherID() публичный Метод

public clearCinderellaFairyGodmotherID ( int id ) : void
id	int
Результат	void

count() публичный Метод

public count ( ) : string
Результат	string

deleteCinderellas() публичный Метод

Deletes everything from Cinderellas table

public deleteCinderellas ( ) : void
Результат	void

deleteFGs() публичный Метод

Deletes everything from FG table

public deleteFGs ( ) : void
Результат	void

dressColor() публичный Метод

Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'

public dressColor ( int id ) : string
id	int	Cinderella's ID#
Результат	string

dressSize() публичный Метод

Used when a Cinderella's checkout information is saved, but she is not set as 'Checked Out'

public dressSize ( int id ) : int
id	int	Cinderella's ID#
Результат	int

dressesDone() публичный Метод

Returns the data for the DGV for Cinderellas dresses that are done in Alterations.

public dressesDone ( ) : string
Результат	string

fairyGodmotherCheckIn() публичный Метод

public fairyGodmotherCheckIn ( ) : string
Результат	string

fgList() публичный Метод

USed to find all info on FG's

public fgList ( ) : string
Результат	string

fgListCheckedIn() публичный Метод

USed to find FG's that are checked in

public fgListCheckedIn ( ) : string
Результат	string

fgListRole() публичный Метод

Used to find FG's with a certain role

public fgListRole ( string roleID ) : string
roleID	string	Role ID
Результат	string

fgListRoleCheckedIn() публичный Метод

Used to find FG's that have a certain role and are 'Available'

public fgListRoleCheckedIn ( string roleID ) : string
roleID	string	Role ID#
Результат	string

fgListRoleManagement() публичный Метод

Used to find a FG that is paired with a Cinderella and has a certain role id

public fgListRoleManagement ( int roleID ) : string
roleID	int	Role id
Результат	string

fgListRoleManagement() публичный Метод

Used to find FG & Cinderella's first and last names that are paired.

public fgListRoleManagement ( string roleID ) : string
roleID	string	Role ID#
Результат	string

fgListRoleManagement() публичный Метод

USed to find a FG that has a certain role and status

public fgListRoleManagement ( string roleID, int currentStatus ) : string
roleID	string	Role ID
currentStatus	int	Current Status
Результат	string

fgListShort() публичный Метод

Used tp find basic FG info

public fgListShort ( ) : string
Результат	string

fgListStatus() публичный Метод

Used to find info on all FG's according to their status

public fgListStatus ( string status ) : string
status	string	status name
Результат	string

fgListStatus() публичный Метод

used to find all info on FG's according to their status and shift

public fgListStatus ( string status, string shift ) : string
status	string	status name
shift	string	shift name
Результат	string

fglistSearch() публичный Метод

public fglistSearch ( string fname, string lname ) : string
fname	string
lname	string
Результат	string

fglistSearch() публичный Метод

USed to search the FG list

public fglistSearch ( string fname, string lname, int currentStatus ) : string
fname	string	FG's first name
lname	string	FG's last name
currentStatus	int	FG's current status
Результат	string

getCinderellaPaired() публичный Метод

Used to find a Cinderella's id that is paired with a certain FG

public getCinderellaPaired ( int id ) : string
id	int	FG's ID#
Результат	string

getCinderellaStatus() публичный Метод

public getCinderellaStatus ( int id ) : string
id	int
Результат	string

getCindyIDFomFG() публичный Метод

public getCindyIDFomFG ( int idFG ) : int
idFG	int
Результат	int

getCurrentlyShopping() публичный Метод

Retrieves a dataset of those who are currently shopping.

public getCurrentlyShopping ( ) : DataSet
Результат	System.Data.DataSet

getDate() публичный Метод

Retrieves the current date and time from the database server.

public getDate ( ) : string
Результат	string

getDressInfo() публичный Метод

public getDressInfo ( string id ) : string
id	string
Результат	string

getFGShiftInfo() публичный Метод

Used to find what shift and role a FG has when they work

public getFGShiftInfo ( string fgID ) : string
fgID	string	FG ID#
Результат	string

getFGStatus() публичный Метод

public getFGStatus ( string fgID ) : string
fgID	string
Результат	string

getFgPaired() публичный Метод

Used to find the FG that is paired with a Cinderella

public getFgPaired ( int id ) : string
id	int	Cinderella's ID
Результат	string

getMaxCinderellaID() публичный Метод

public getMaxCinderellaID ( ) : string
Результат	string

getPackageInfo() публичный Метод

Returns all data from Package table for a certain Cinderella

public getPackageInfo ( string id ) : string
id	string	Cinderella ID
Результат	string

getReferrals() публичный Метод

Used to retrieve the list of referrals

public getReferrals ( ) : string
Результат	string

getSetting() публичный Метод

public getSetting ( string settingName ) : string
settingName	string
Результат	string

getTime() публичный Метод

public getTime ( int id ) : string
id	int
Результат	string

newFGShiftWorker() публичный Метод

Used to add a FG to a shift

public newFGShiftWorker ( string firstName, string lastName, int shiftID, int roleID ) : void
firstName	string	FG first name
lastName	string	FG last name
shiftID	int	fg shift ID#
roleID	int	FG role ID#
Результат	void

pairCinderella() публичный Метод

Used to manually pair a cinderella

public pairCinderella ( int cinderellaID, int fg_id ) : void
cinderellaID	int	Cinderella's ID#
fg_id	int	FG's ID#
Результат	void

resetDB() публичный Метод

Soft reset of the Database

public resetDB ( ) : void
Результат	void

setCinderellaStatus() публичный Метод

Sets the status of a cinderella or godmother.

public setCinderellaStatus ( string ID, int status ) : void
ID	string	Id of the Cinderella or Godmother
status	int	Status that you would like to set.
Результат	void

setDefaultSetting() публичный Метод

public setDefaultSetting ( string settingName, string defaultValue ) : void
settingName	string
defaultValue	string
Результат	void

setFGStatus() публичный Метод

public setFGStatus ( string ID, int status ) : void
ID	string
status	int
Результат	void

setFGStatusScan() публичный Метод

Used to set a FG to a certain status (Available, Unavailable, Paired, Shopping)

public setFGStatusScan ( string ID, int status, int shift ) : void
ID	string
status	int
shift	int
Результат	void

setSettingValue() публичный Метод

public setSettingValue ( string settingName, string settingValue ) : void
settingName	string
settingValue	string
Результат	void

showFairyGodmothers() публичный Метод

public showFairyGodmothers ( int shift, int status ) : string
shift	int
status	int
Результат	string

sqlSelect() публичный Метод

This method houses all of the basic "Select" statements.

public sqlSelect ( string keyword ) : DataSet
keyword	string	Keyword identifying the select statment in the switch.
Результат	System.Data.DataSet

sqlStatment() публичный Метод

Will execute a non-query sql statment.

public sqlStatment ( string mysql ) : int
mysql	string	SQL statement to be executed.
Результат	int

statusList() публичный Метод

Used to get a cinderella's status, along with their name and their FG's name

public statusList ( int statusID ) : string
statusID	int
Результат	string

undoCinderellaPairFromFGID() публичный Метод

Used to undo a FG's pairing with a cinderella

public undoCinderellaPairFromFGID ( int fgID ) : void
fgID	int	Fairy Godmother's ID
Результат	void

undoCinderellaStatus() публичный Метод

Undos the status change of the given status for the Cinderella if that status is the last known status

The CinDeleteStatusTrigger will update to the correct currentStatus

public undoCinderellaStatus ( int id, int status ) : void
id	int
status	int	status to delete
Результат	void

undoCinderellaUntilThisStatus() публичный Метод

Undos the status changes until the given status for the Cinderella

The CinDeleteStatusTrigger will update to the correct currentStatus

public undoCinderellaUntilThisStatus ( int cinID, int status ) : void
cinID	int	Cinderellas given id
status	int	status to undo to
Результат	void

undoFGPairFromCinderellaID() публичный Метод

Used to undo a Cinderella's pairing with a FG

public undoFGPairFromCinderellaID ( int cinID ) : void
cinID	int	Cinderella's ID
Результат	void

undoFGStatus() публичный Метод

Undos the status changes of the given status for the FairyGodmother fi that status is the last known status

The FGDeleteStatusTrigger will update to the correct currentStatus

public undoFGStatus ( int id, int status ) : void
id	int
status	int	status to delete
Результат	void

undoFGUntilThisStatus() публичный Метод

Undos the status changes until the given status for the FairyGodmother

The FGDeleteStatusTrigger will update to the correct currentStatus

public undoFGUntilThisStatus ( int fgID, int status ) : void
fgID	int	FairyGodmother given id
status	int	status to undo to
Результат	void

updateAlterations() публичный Метод

Used to give alterations to a Cinderella

public updateAlterations ( string cindID, string notes, int straps, int darts, int zipper, int mending, int takeIn, int bust, int hem, string fgID ) : void
cindID	string	Cinderella's ID
notes	string	notes
straps	int	Straps (Int used for bool value in DB)
darts	int	darts (Int used for bool value in DB)
zipper	int	zipper (Int used for bool value in DB)
mending	int	mending (Int used for bool value in DB)
takeIn	int	takeIn (Int used for bool value in DB)
bust	int	bust (Int used for bool value in DB)
hem	int	hem (Int used for bool value in DB)
fgID	string	Seamstress ID#
Результат	void

updateAlterationsNotFinished() публичный Метод

used to give alterations to a Cinderella (This is used when their alterations will not be completed onsite)

public updateAlterationsNotFinished ( string cindID, string notes, int straps, int darts, int zipper, int mending, int takeIn, int bust, int hem, string fgID ) : void
cindID	string	Cinderella's ID
notes	string	notes
straps	int	Straps (Int used for bool value in DB)
darts	int	darts (Int used for bool value in DB)
zipper	int	zipper (Int used for bool value in DB)
mending	int	mending (Int used for bool value in DB)
takeIn	int	takeIn (Int used for bool value in DB)
bust	int	bust (Int used for bool value in DB)
hem	int	hem (Int used for bool value in DB)
fgID	string	Seamstress ID#
Результат	void

updateCinderella() публичный Метод

Used to update a cinderella's information. This is used if the Cinderella's information was incorrect and needed to be fixed, or if the appointment time and date needs to be changed

public updateCinderella ( int id, string firstName, string lastName, string date, string time ) : string
id	int	Cinderella's ID#
firstName	string	Cinderella's First Name
lastName	string	Cinderella's Last Name
date	string	Cinderella's appointment date
time	string	Cinderella's appointment time
Результат	string

updateCinderellaAppt() публичный Метод

Used to change a cinderella's appointment time when the current date and time button is clicked

public updateCinderellaAppt ( int id ) : void
id	int	Cinderella's ID#
Результат	void

updateCinderellaAppt() публичный Метод

Used to change a cinderella's appointment time when a manually entered date and time are needed

public updateCinderellaAppt ( int id, string date, string time ) : void
id	int	Cinderella's ID#
date	string	Cinderella's new appt date
time	string	Cinderella's new appt time
Результат	void

updateFairyGodmother() публичный Метод

Updates FG's info

public updateFairyGodmother ( string fgID, string firstName, string lastName, string emailAddress, string phoneNumber, string city, string state, string zip, string address ) : string
fgID	string	FG ID#
firstName	string	FG First Name
lastName	string	FG Last Name
emailAddress	string	FG Email
phoneNumber	string	FG Phone#
city	string	FG's city
state	string	FG's state
zip	string	FG's zip
address	string	FG's Address
Результат	string

validateLogin() публичный Метод

Used to validate the login of a user

public validateLogin ( string username, string password ) : int
username	string	Username
password	string	Password
Результат	int