C# Class CinderellaLauncher.SQL_Queries

Show file Open project: ThomasMoreCollege/CinderellaMGS Class Usage Examples

Public Methods

Method	Description
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

Private Methods

Method	Description
MasterCheckOutSearchBox ( string item ) : string
MasterSearchBox ( string item ) : string

Method Details

AddGodmotherShift() public method

Adds a godmother to a shift.

public AddGodmotherShift ( string fairyGodmotherID, string shiftID, string roleID ) : void
fairyGodmotherID	string
shiftID	string
roleID	string
return	void

AllSeamstresses() public method

Retrieves all FG's that are seamstresses

public AllSeamstresses ( ) : string
return	string

CheckInSearch() public method

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
return	string

CheckOutSearch() public method

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)
return	string

CinderellaCurrentStatus() public method

Gives a cinderella's current status

public CinderellaCurrentStatus ( int id ) : int
id	int	Cinderella's current ID#
return	int

CinderellaHistory() public method

public CinderellaHistory ( int cinID ) : string
cinID	int
return	string

Cinderellas() public method

Finds cinderellas with a certain status

public Cinderellas ( int currentStatus ) : string
currentStatus	int	cinderella's current statud desired
return	string

Cinderellas() public method

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 #
return	string

CinderellasInAlteration() public method

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
return	string

CinderellasList() public method

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
return	string

CinderellasUndoList() public method

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
return	string

CindyBracelet() public method

public CindyBracelet ( int fgID ) : string
fgID	int
return	string

CindyDressColor() public method

public CindyDressColor ( int fgID ) : string
fgID	int
return	string

CindyDressSize() public method

public CindyDressSize ( int fgID ) : int
fgID	int
return	int

CindyEarrings() public method

public CindyEarrings ( int fgID ) : string
fgID	int
return	string

CindyHeadpiece() public method

public CindyHeadpiece ( int fgID ) : string
fgID	int
return	string

CindyNecklace() public method

public CindyNecklace ( int fgID ) : string
fgID	int
return	string

CindyRing() public method

public CindyRing ( int fgID ) : string
fgID	int
return	string

CindyShoeColor() public method

public CindyShoeColor ( int fgID ) : string
fgID	int
return	string

CindyShoeSize() public method

public CindyShoeSize ( int fgID ) : string
fgID	int
return	string

DressesNotFinished() public method

public DressesNotFinished ( ) : string
return	string

EndShift() public method

public EndShift ( ) : void
return	void

FGCurrentStatus() public method

Gives a FG's current status

public FGCurrentStatus ( int id ) : int
id	int	FG ID#
return	int

FGLeavesCinderella() public method

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
return	void

FGMaxID() public method

public FGMaxID ( ) : string
return	string

FGQuickSearch() public method

public FGQuickSearch ( int fgID ) : string
fgID	int
return	string

FGcount() public method

public FGcount ( ) : string
return	string

FairyGodmotherHistory() public method

public FairyGodmotherHistory ( int fgID ) : string
fgID	int
return	string

MasterSearch() public method

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)
return	string

MaxID() public method

public MaxID ( ) : string
return	string

NewCinderella() public method

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
return	string

NewGodMother() public method

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
return	string

NumberOfCinderellasHelped() public method

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

public NumberOfCinderellasHelped ( ) : int
return	int

NumberOfCinderellasHelpedByFG() public method

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

public NumberOfCinderellasHelpedByFG ( ) : string
return	string

NumberOfDressesAlteredByFG() public method

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

public NumberOfDressesAlteredByFG ( ) : string
return	string

NumberOfDressesTakenByColor() public method

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
return	int

NumberOfDressesTakenByColorAndSize() public method

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
return	int

NumberOfDressesTakenBySize() public method

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
return	int

NumberOfFGsByShift() public method

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

public NumberOfFGsByShift ( int shift ) : int
shift	int	the shift #
return	int

NumberOfFGsByShiftAndRole() public method

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
return	int

PackageBracelet() public method

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#
return	bool

PackageCheckOutNotes() public method

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#
return	string

PackageEarrings() public method

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#
return	bool

PackageHeadpiece() public method

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#
return	bool

PackageNecklace() public method

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#
return	bool

PackageOther() public method

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#
return	string

PackageRing() public method

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#
return	bool

PackageShoeColor() public method

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#
return	string

PackageShoeSize() public method

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#
return	double

PairedPersonalShoppers() public method

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

public PairedPersonalShoppers ( int cinderellaID ) : string
cinderellaID	int	cinderellas ID#
return	string

PersonalShoppers() public method

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

public PersonalShoppers ( int currentStatus ) : string
currentStatus	int	status #
return	string

PersonalShoppers() public method

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 #
return	string

PersonalShoppersList() public method

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 #
return	string

PrintCinderellaName() public method

public PrintCinderellaName ( string ID ) : string
ID	string
return	string

PrintFGIDGrid() public method

public PrintFGIDGrid ( ) : string
return	string

PrintFGName() public method

public PrintFGName ( string ID ) : string
ID	string
return	string

PrintFirstCinderellaName() public method

public PrintFirstCinderellaName ( string ID ) : string
ID	string
return	string

PrintFirstFGName() public method

public PrintFirstFGName ( string ID ) : string
ID	string
return	string

PrintIDGrid() public method

public PrintIDGrid ( ) : string
return	string

PrintLastCinderellaName() public method

public PrintLastCinderellaName ( string ID ) : string
ID	string
return	string

PrintLastFGName() public method

public PrintLastFGName ( string ID ) : string
ID	string
return	string

RetrievedDress() public method

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

public RetrievedDress ( int cinID ) : void
cinID	int	Cinderella's ID#
return	void

SQL_Queries() public method

public SQL_Queries ( ) : System
return	System

ShiftWorkerRole() public method

public ShiftWorkerRole ( int fgID, int shiftID ) : int
fgID	int
shiftID	int
return	int

addAlterations() public method

Adds a Cinderella into Alterations

public addAlterations ( string cindID ) : void
cindID	string	Cinderella's ID#
return	void

addCinderellaAndReferral() public method

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
return	void

addUser() public method

public addUser ( string loginName, string password, string firstName, string lastName, int roleID ) : void
loginName	string
password	string
firstName	string
lastName	string
roleID	int
return	void

alterationCompleted() public method

Views cinderellas that have been completely through alterations

public alterationCompleted ( ) : string
return	string

checkAlterations() public method

USed to check if a Cinderella is in Alterations

public checkAlterations ( string id ) : string
id	string	Cinderella's ID
return	string

checkInList() public method

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
return	string

checkOutList() public method

public checkOutList ( ) : string
return	string

checkOutList() public method

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.
return	string

checkOutUpdate() public method

public checkOutUpdate ( int cinderellaID, int dressSize, string dressColor ) : void
cinderellaID	int
dressSize	int
dressColor	string
return	void

checkOutUpdate() public method

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)
return	void

checkedOutCinderellas() public method

public checkedOutCinderellas ( ) : string
return	string

cinderellaCheckIn() public method

public cinderellaCheckIn ( ) : DataSet
return	System.Data.DataSet

clearCinderellaFairyGodmotherID() public method

public clearCinderellaFairyGodmotherID ( int id ) : void
id	int
return	void

count() public method

public count ( ) : string
return	string

deleteCinderellas() public method

Deletes everything from Cinderellas table

public deleteCinderellas ( ) : void
return	void

deleteFGs() public method

Deletes everything from FG table

public deleteFGs ( ) : void
return	void

dressColor() public method

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#
return	string

dressSize() public method

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#
return	int

dressesDone() public method

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

public dressesDone ( ) : string
return	string

fairyGodmotherCheckIn() public method

public fairyGodmotherCheckIn ( ) : string
return	string

fgList() public method

USed to find all info on FG's

public fgList ( ) : string
return	string

fgListCheckedIn() public method

USed to find FG's that are checked in

public fgListCheckedIn ( ) : string
return	string

fgListRole() public method

Used to find FG's with a certain role

public fgListRole ( string roleID ) : string
roleID	string	Role ID
return	string

fgListRoleCheckedIn() public method

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

public fgListRoleCheckedIn ( string roleID ) : string
roleID	string	Role ID#
return	string

fgListRoleManagement() public method

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
return	string

fgListRoleManagement() public method

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

public fgListRoleManagement ( string roleID ) : string
roleID	string	Role ID#
return	string

fgListRoleManagement() public method

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
return	string

fgListShort() public method

Used tp find basic FG info

public fgListShort ( ) : string
return	string

fgListStatus() public method

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

public fgListStatus ( string status ) : string
status	string	status name
return	string

fgListStatus() public method

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
return	string

fglistSearch() public method

public fglistSearch ( string fname, string lname ) : string
fname	string
lname	string
return	string

fglistSearch() public method

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
return	string

getCinderellaPaired() public method

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

public getCinderellaPaired ( int id ) : string
id	int	FG's ID#
return	string

getCinderellaStatus() public method

public getCinderellaStatus ( int id ) : string
id	int
return	string

getCindyIDFomFG() public method

public getCindyIDFomFG ( int idFG ) : int
idFG	int
return	int

getCurrentlyShopping() public method

Retrieves a dataset of those who are currently shopping.

public getCurrentlyShopping ( ) : DataSet
return	System.Data.DataSet

getDate() public method

Retrieves the current date and time from the database server.

public getDate ( ) : string
return	string

getDressInfo() public method

public getDressInfo ( string id ) : string
id	string
return	string

getFGShiftInfo() public method

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

public getFGShiftInfo ( string fgID ) : string
fgID	string	FG ID#
return	string

getFGStatus() public method

public getFGStatus ( string fgID ) : string
fgID	string
return	string

getFgPaired() public method

Used to find the FG that is paired with a Cinderella

public getFgPaired ( int id ) : string
id	int	Cinderella's ID
return	string

getMaxCinderellaID() public method

public getMaxCinderellaID ( ) : string
return	string

getPackageInfo() public method

Returns all data from Package table for a certain Cinderella

public getPackageInfo ( string id ) : string
id	string	Cinderella ID
return	string

getReferrals() public method

Used to retrieve the list of referrals

public getReferrals ( ) : string
return	string

getSetting() public method

public getSetting ( string settingName ) : string
settingName	string
return	string

getTime() public method

public getTime ( int id ) : string
id	int
return	string

newFGShiftWorker() public method

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#
return	void

pairCinderella() public method

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#
return	void

resetDB() public method

Soft reset of the Database

public resetDB ( ) : void
return	void

setCinderellaStatus() public method

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.
return	void

setDefaultSetting() public method

public setDefaultSetting ( string settingName, string defaultValue ) : void
settingName	string
defaultValue	string
return	void

setFGStatus() public method

public setFGStatus ( string ID, int status ) : void
ID	string
status	int
return	void

setFGStatusScan() public method

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
return	void

setSettingValue() public method

public setSettingValue ( string settingName, string settingValue ) : void
settingName	string
settingValue	string
return	void

showFairyGodmothers() public method

public showFairyGodmothers ( int shift, int status ) : string
shift	int
status	int
return	string

sqlSelect() public method

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

public sqlSelect ( string keyword ) : DataSet
keyword	string	Keyword identifying the select statment in the switch.
return	System.Data.DataSet

sqlStatment() public method

Will execute a non-query sql statment.

public sqlStatment ( string mysql ) : int
mysql	string	SQL statement to be executed.
return	int

statusList() public method

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

public statusList ( int statusID ) : string
statusID	int
return	string

undoCinderellaPairFromFGID() public method

Used to undo a FG's pairing with a cinderella

public undoCinderellaPairFromFGID ( int fgID ) : void
fgID	int	Fairy Godmother's ID
return	void

undoCinderellaStatus() public method

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
return	void

undoCinderellaUntilThisStatus() public method

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
return	void

undoFGPairFromCinderellaID() public method

Used to undo a Cinderella's pairing with a FG

public undoFGPairFromCinderellaID ( int cinID ) : void
cinID	int	Cinderella's ID
return	void

undoFGStatus() public method

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
return	void

undoFGUntilThisStatus() public method

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
return	void

updateAlterations() public method

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#
return	void

updateAlterationsNotFinished() public method

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#
return	void

updateCinderella() public method

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
return	string

updateCinderellaAppt() public method

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#
return	void

updateCinderellaAppt() public method

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
return	void

updateFairyGodmother() public method

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
return	string

validateLogin() public method

Used to validate the login of a user

public validateLogin ( string username, string password ) : int
username	string	Username
password	string	Password
return	int