C# Class VolTeer.DataAccessLayer.VT.VolTeerEntities

Inheritance: System.Data.DbContext
显示文件 Open project: CISC181/VolTeerNET

Public Methods

Method Description
VolTeerEntities ( ) : System
sp_Availability_Select ( Nullable volID, Nullable addrID ) : ObjectResult
sp_ContactEmail_Delete ( Nullable contactID, Nullable emailID ) : int
sp_ContactEmail_Insert ( Nullable contactID, Nullable emailID, Nullable primaryEmail ) : int
sp_ContactEmail_Select ( Nullable contactID, Nullable emailID ) : ObjectResult
sp_ContactEmail_Update ( Nullable contactID, Nullable emailID, Nullable primaryEmail ) : int
sp_Contact_Delete ( Nullable contactID ) : int
sp_Contact_Insert ( string contactFirstName, string contactMiddleName, string contactLastName ) : ObjectResult>
sp_Contact_MassUpdate ( string xML_IN ) : int
sp_Contact_Select ( Nullable contactID ) : ObjectResult
sp_Contact_Update ( Nullable contactID, string contactFirstName, string contactMiddleName, string contactLastName, Nullable activeFlg ) : int
sp_EventRating_Delete ( Nullable ratingID, Nullable eventID ) : int
sp_EventRating_Insert ( Nullable eventID, Nullable volID, Nullable ratingValue, Nullable activeFlg ) : ObjectResult>
sp_EventRating_MassUpdate ( string xML_IN ) : int
sp_EventRating_Select ( Nullable ratingID, Nullable eventID ) : ObjectResult
sp_EventRating_Update ( Nullable ratingID, Nullable eventID, Nullable volID, Nullable ratingValue, Nullable activeFlg ) : int
sp_GroupAddr_Delete ( Nullable groupID, Nullable addrID ) : int
sp_GroupAddr_Insert ( Nullable groupID, Nullable addrID, Nullable primaryAddrID, Nullable activeFlg ) : ObjectResult>
sp_GroupAddr_Select ( Nullable groupID, Nullable addrID ) : ObjectResult
sp_GroupAddr_Update ( Nullable groupID, Nullable addrID, Nullable primaryAddrID, Nullable activeFlg ) : int
sp_GroupVol_Delete ( Nullable groupID, Nullable volID ) : int
sp_GroupVol_Insert ( Nullable groupID, Nullable volID, Nullable primaryVolID, Nullable admin ) : ObjectResult>
sp_GroupVol_Select ( Nullable groupID, Nullable volID ) : ObjectResult
sp_GroupVol_Select_FindNewVols ( Nullable groupID ) : ObjectResult
sp_GroupVol_Update ( Nullable groupID, Nullable volID, Nullable primaryVolID, Nullable admin ) : int
sp_Group_Delete ( Nullable groupID ) : int
sp_Group_Insert ( string groupName, Nullable participationLevelID, Nullable activeFlg, string shortDesc, string longDesc ) : ObjectResult>
sp_Group_Search ( string xML_IN ) : ObjectResult
sp_Group_Select ( Nullable groupID ) : ObjectResult
sp_Group_Update ( Nullable groupID, string groupName, Nullable participationLevelID, Nullable activeFlg, string shortDesc, string longDesc ) : int
sp_ProjectEventContact_Delete ( Nullable eventID, Nullable contactID ) : int
sp_ProjectEventContact_Insert ( Nullable eventID, Nullable contactID, Nullable primaryContact ) : int
sp_ProjectEventContact_Select ( Nullable eventID, Nullable contactID ) : ObjectResult
sp_ProjectEventContact_Update ( Nullable eventID, Nullable contactID, Nullable primaryContact ) : int
sp_ProjectEvent_Delete ( Nullable eventID ) : int
sp_ProjectEvent_Insert ( Nullable projectID, Nullable startDateTime, Nullable endDateTime, Nullable addrID ) : int
sp_ProjectEvent_Select ( Nullable eventID ) : ObjectResult
sp_ProjectEvent_Update ( Nullable eventID, Nullable projectID, Nullable startDateTime, Nullable endDateTime, Nullable addrID ) : int
sp_Project_Delete ( Nullable projectID ) : int
sp_Project_Insert ( string projectName, string projectDesc, Nullable addrID, Nullable activeFlg ) : ObjectResult>
sp_Project_Select ( Nullable projectID ) : ObjectResult
sp_Project_Update ( Nullable projectID, string projectName, string projectDesc, Nullable addrID, Nullable activeFlg ) : int
sp_Sample_Address_Delete ( Nullable addrID ) : int
sp_Sample_Address_Insert ( string addrLine1, string addrLine2, string addrLine3, string city, string st, Nullable zip, Nullable zip4, Nullable activeFlg ) : int
sp_Sample_Address_Select ( ) : ObjectResult
sp_Sample_Address_Update ( Nullable addrID, string addrLine1, string addrLine2, string addrLine3, string city, string st, Nullable zip, Nullable zip4, Nullable activeFlg ) : int
sp_Skill_Delete ( Nullable skillID ) : int
sp_Skill_Insert ( string skillName, Nullable mstrSkillID, Nullable reqCert ) : ObjectResult>
sp_Skill_Select ( Nullable skillID ) : ObjectResult
sp_Skill_Select_Manage ( Nullable showNullMstrSkillItems ) : ObjectResult
sp_Skill_Update ( Nullable skillID, string skillName, Nullable mstrSkillID, Nullable reqCert ) : int
sp_Vend_Address_Delete ( Nullable addrID ) : int
sp_Vend_Address_Insert ( string addrLine1, string addrLine2, string addrLine3, string city, string st, Nullable zip, Nullable zip4, string geoCodeGetSet, Nullable activeFlg ) : ObjectResult>
sp_Vend_Address_MassUpdate ( string xML_IN ) : int
sp_Vend_Address_Select ( Nullable addrID ) : ObjectResult
sp_Vend_Address_Update ( Nullable addrId, Nullable activeFlg, string addrLine1, string addrLine2, string addrLine3, string city, string st, Nullable zip, Nullable zip4, string geoCodeGetSet ) : int
sp_Vend_Contact_Delete ( Nullable vendorID, Nullable contactID ) : int
sp_Vend_Contact_Insert ( Nullable vendorID, Nullable contactID, Nullable primaryContact ) : ObjectResult>
sp_Vend_Contact_Select ( Nullable vendorID, Nullable contactID ) : ObjectResult
sp_Vend_Contact_Update ( Nullable vendorID, Nullable contactID, Nullable primaryContact ) : int
sp_Vend_Email_Delete ( Nullable emailID ) : int
sp_Vend_Email_Insert ( Nullable emailID, string emailAddr, Nullable activeFlg ) : int
sp_Vend_Email_MassUpdate ( string xML_IN ) : int
sp_Vend_Email_Select ( Nullable emailID, Nullable activeFlg ) : ObjectResult
sp_Vend_Email_Update ( Nullable emailID, string emailAddr, Nullable activeFlg ) : int
sp_VendorAddr_Delete ( Nullable vendorID ) : int
sp_VendorAddr_Insert ( Nullable addrID, Nullable hQ ) : ObjectResult>
sp_VendorAddr_Select ( Nullable vendorID ) : ObjectResult
sp_VendorAddr_Update ( Nullable vendorID, Nullable addrID, Nullable hQ ) : int
sp_VendorProjContact_Delete ( Nullable vendorID, Nullable projectID, Nullable contactID ) : int
sp_VendorProjContact_Insert ( Nullable vendorID, Nullable projectID, Nullable contactID, Nullable primaryContact ) : int
sp_VendorProjContact_Select ( Nullable vendorID, Nullable projectID, Nullable contactID ) : ObjectResult
sp_VendorProjContact_Update ( Nullable vendorID, Nullable projectID, Nullable contactID, Nullable primaryContact ) : int
sp_Vendor_Delete ( Nullable vendorID ) : int
sp_Vendor_Insert ( Nullable vendorID, string vendorName ) : ObjectResult>
sp_Vendor_Select ( Nullable vendorID ) : ObjectResult
sp_VolSkill_DeleteAll ( Nullable volID ) : int
sp_VolSkill_Insert ( Nullable volID, Nullable skillID ) : int
sp_VolSkill_Select ( Nullable volID ) : ObjectResult
sp_Vol_Addr_Delete ( Nullable volID, Nullable addrID ) : int
sp_Vol_Addr_Insert ( Nullable volID, Nullable addrID, Nullable primaryAddr ) : int
sp_Vol_Addr_Update ( Nullable volID, Nullable addrID, Nullable primaryAddr ) : int
sp_Vol_Address_Delete ( Nullable addrID ) : int
sp_Vol_Address_MassUpdate ( string xML_IN ) : int
sp_Vol_Address_Select ( Nullable volID, Nullable addrID, Nullable primaryAddr ) : ObjectResult
sp_Vol_Address_Update ( Nullable addrId, Nullable activeFlg, string addrLine1, string addrLine2, string addrLine3, string city, string st, Nullable zip, Nullable zip4, string geoCodeGetSet ) : int
sp_Vol_Email_Delete ( Nullable emailID, Nullable volID, string emailAddr, Nullable activeFlg, Nullable primaryFlg ) : int
sp_Vol_Email_Insert ( Nullable volID, string emailAddr, Nullable activeFlg, Nullable primaryFlg ) : ObjectResult>
sp_Vol_Email_Select ( Nullable volID, Nullable emailID, Nullable primaryFlg ) : ObjectResult
sp_Vol_Email_Update ( Nullable emailID, Nullable volID, string emailAddr, Nullable activeFlg, Nullable primaryFlg ) : int
sp_Vol_Phone_Delete ( Nullable phoneID, string phoneNbr, Nullable activeFlg ) : int
sp_Vol_Phone_Insert ( Nullable volID, string phoneNbr, Nullable activeFlg, Nullable primaryFlg ) : ObjectResult
sp_Vol_Phone_Select ( Nullable volID, Nullable phoneID, Nullable primaryFlg ) : ObjectResult
sp_Vol_Phone_Update ( Nullable phoneID, Nullable volID, string phoneNbr, Nullable activeFlg, Nullable primaryFlg ) : int
sp_Vol_State_Select ( ) : ObjectResult
sp_Volunteer_Delete ( Nullable volID ) : int
sp_Volunteer_Insert ( Nullable volID, string volFirstName, string volMiddleName, string volLastName ) : ObjectResult>
sp_Volunteer_Select ( Nullable volID ) : ObjectResult
sp_Volunteer_Update ( Nullable volID, Nullable activeFlg, string volFirstName, string volMiddleName, string volLastName ) : int
sp_alterdiagram ( string diagramname, Nullable owner_id, Nullable version, byte definition ) : int
sp_creatediagram ( string diagramname, Nullable owner_id, Nullable version, byte definition ) : int
sp_dropdiagram ( string diagramname, Nullable owner_id ) : int
sp_helpdiagramdefinition ( string diagramname, Nullable owner_id ) : ObjectResult
sp_helpdiagrams ( string diagramname, Nullable owner_id ) : ObjectResult
sp_renamediagram ( string diagramname, Nullable owner_id, string new_diagramname ) : int
sp_upgraddiagrams ( ) : int

Protected Methods

Method Description
OnModelCreating ( DbModelBuilder modelBuilder ) : void

Method Details

OnModelCreating() protected method

protected OnModelCreating ( DbModelBuilder modelBuilder ) : void
modelBuilder DbModelBuilder
return void

VolTeerEntities() public method

public VolTeerEntities ( ) : System
return System

sp_Availability_Select() public method

public sp_Availability_Select ( Nullable volID, Nullable addrID ) : ObjectResult
volID Nullable
addrID Nullable
return ObjectResult

sp_ContactEmail_Delete() public method

public sp_ContactEmail_Delete ( Nullable contactID, Nullable emailID ) : int
contactID Nullable
emailID Nullable
return int

sp_ContactEmail_Insert() public method

public sp_ContactEmail_Insert ( Nullable contactID, Nullable emailID, Nullable primaryEmail ) : int
contactID Nullable
emailID Nullable
primaryEmail Nullable
return int

sp_ContactEmail_Select() public method

public sp_ContactEmail_Select ( Nullable contactID, Nullable emailID ) : ObjectResult
contactID Nullable
emailID Nullable
return ObjectResult

sp_ContactEmail_Update() public method

public sp_ContactEmail_Update ( Nullable contactID, Nullable emailID, Nullable primaryEmail ) : int
contactID Nullable
emailID Nullable
primaryEmail Nullable
return int

sp_Contact_Delete() public method

public sp_Contact_Delete ( Nullable contactID ) : int
contactID Nullable
return int

sp_Contact_Insert() public method

public sp_Contact_Insert ( string contactFirstName, string contactMiddleName, string contactLastName ) : ObjectResult>
contactFirstName string
contactMiddleName string
contactLastName string
return ObjectResult>

sp_Contact_MassUpdate() public method

public sp_Contact_MassUpdate ( string xML_IN ) : int
xML_IN string
return int

sp_Contact_Select() public method

public sp_Contact_Select ( Nullable contactID ) : ObjectResult
contactID Nullable
return ObjectResult

sp_Contact_Update() public method

public sp_Contact_Update ( Nullable contactID, string contactFirstName, string contactMiddleName, string contactLastName, Nullable activeFlg ) : int
contactID Nullable
contactFirstName string
contactMiddleName string
contactLastName string
activeFlg Nullable
return int

sp_EventRating_Delete() public method

public sp_EventRating_Delete ( Nullable ratingID, Nullable eventID ) : int
ratingID Nullable
eventID Nullable
return int

sp_EventRating_Insert() public method

public sp_EventRating_Insert ( Nullable eventID, Nullable volID, Nullable ratingValue, Nullable activeFlg ) : ObjectResult>
eventID Nullable
volID Nullable
ratingValue Nullable
activeFlg Nullable
return ObjectResult>

sp_EventRating_MassUpdate() public method

public sp_EventRating_MassUpdate ( string xML_IN ) : int
xML_IN string
return int

sp_EventRating_Select() public method

public sp_EventRating_Select ( Nullable ratingID, Nullable eventID ) : ObjectResult
ratingID Nullable
eventID Nullable
return ObjectResult

sp_EventRating_Update() public method

public sp_EventRating_Update ( Nullable ratingID, Nullable eventID, Nullable volID, Nullable ratingValue, Nullable activeFlg ) : int
ratingID Nullable
eventID Nullable
volID Nullable
ratingValue Nullable
activeFlg Nullable
return int

sp_GroupAddr_Delete() public method

public sp_GroupAddr_Delete ( Nullable groupID, Nullable addrID ) : int
groupID Nullable
addrID Nullable
return int

sp_GroupAddr_Insert() public method

public sp_GroupAddr_Insert ( Nullable groupID, Nullable addrID, Nullable primaryAddrID, Nullable activeFlg ) : ObjectResult>
groupID Nullable
addrID Nullable
primaryAddrID Nullable
activeFlg Nullable
return ObjectResult>

sp_GroupAddr_Select() public method

public sp_GroupAddr_Select ( Nullable groupID, Nullable addrID ) : ObjectResult
groupID Nullable
addrID Nullable
return ObjectResult

sp_GroupAddr_Update() public method

public sp_GroupAddr_Update ( Nullable groupID, Nullable addrID, Nullable primaryAddrID, Nullable activeFlg ) : int
groupID Nullable
addrID Nullable
primaryAddrID Nullable
activeFlg Nullable
return int

sp_GroupVol_Delete() public method

public sp_GroupVol_Delete ( Nullable groupID, Nullable volID ) : int
groupID Nullable
volID Nullable
return int

sp_GroupVol_Insert() public method

public sp_GroupVol_Insert ( Nullable groupID, Nullable volID, Nullable primaryVolID, Nullable admin ) : ObjectResult>
groupID Nullable
volID Nullable
primaryVolID Nullable
admin Nullable
return ObjectResult>

sp_GroupVol_Select() public method

public sp_GroupVol_Select ( Nullable groupID, Nullable volID ) : ObjectResult
groupID Nullable
volID Nullable
return ObjectResult

sp_GroupVol_Select_FindNewVols() public method

public sp_GroupVol_Select_FindNewVols ( Nullable groupID ) : ObjectResult
groupID Nullable
return ObjectResult

sp_GroupVol_Update() public method

public sp_GroupVol_Update ( Nullable groupID, Nullable volID, Nullable primaryVolID, Nullable admin ) : int
groupID Nullable
volID Nullable
primaryVolID Nullable
admin Nullable
return int

sp_Group_Delete() public method

public sp_Group_Delete ( Nullable groupID ) : int
groupID Nullable
return int

sp_Group_Insert() public method

public sp_Group_Insert ( string groupName, Nullable participationLevelID, Nullable activeFlg, string shortDesc, string longDesc ) : ObjectResult>
groupName string
participationLevelID Nullable
activeFlg Nullable
shortDesc string
longDesc string
return ObjectResult>

sp_Group_Search() public method

public sp_Group_Search ( string xML_IN ) : ObjectResult
xML_IN string
return ObjectResult

sp_Group_Select() public method

public sp_Group_Select ( Nullable groupID ) : ObjectResult
groupID Nullable
return ObjectResult

sp_Group_Update() public method

public sp_Group_Update ( Nullable groupID, string groupName, Nullable participationLevelID, Nullable activeFlg, string shortDesc, string longDesc ) : int
groupID Nullable
groupName string
participationLevelID Nullable
activeFlg Nullable
shortDesc string
longDesc string
return int

sp_ProjectEventContact_Delete() public method

public sp_ProjectEventContact_Delete ( Nullable eventID, Nullable contactID ) : int
eventID Nullable
contactID Nullable
return int

sp_ProjectEventContact_Insert() public method

public sp_ProjectEventContact_Insert ( Nullable eventID, Nullable contactID, Nullable primaryContact ) : int
eventID Nullable
contactID Nullable
primaryContact Nullable
return int

sp_ProjectEventContact_Select() public method

public sp_ProjectEventContact_Select ( Nullable eventID, Nullable contactID ) : ObjectResult
eventID Nullable
contactID Nullable
return ObjectResult

sp_ProjectEventContact_Update() public method

public sp_ProjectEventContact_Update ( Nullable eventID, Nullable contactID, Nullable primaryContact ) : int
eventID Nullable
contactID Nullable
primaryContact Nullable
return int

sp_ProjectEvent_Delete() public method

public sp_ProjectEvent_Delete ( Nullable eventID ) : int
eventID Nullable
return int

sp_ProjectEvent_Insert() public method

public sp_ProjectEvent_Insert ( Nullable projectID, Nullable startDateTime, Nullable endDateTime, Nullable addrID ) : int
projectID Nullable
startDateTime Nullable
endDateTime Nullable
addrID Nullable
return int

sp_ProjectEvent_Select() public method

public sp_ProjectEvent_Select ( Nullable eventID ) : ObjectResult
eventID Nullable
return ObjectResult

sp_ProjectEvent_Update() public method

public sp_ProjectEvent_Update ( Nullable eventID, Nullable projectID, Nullable startDateTime, Nullable endDateTime, Nullable addrID ) : int
eventID Nullable
projectID Nullable
startDateTime Nullable
endDateTime Nullable
addrID Nullable
return int

sp_Project_Delete() public method

public sp_Project_Delete ( Nullable projectID ) : int
projectID Nullable
return int

sp_Project_Insert() public method

public sp_Project_Insert ( string projectName, string projectDesc, Nullable addrID, Nullable activeFlg ) : ObjectResult>
projectName string
projectDesc string
addrID Nullable
activeFlg Nullable
return ObjectResult>

sp_Project_Select() public method

public sp_Project_Select ( Nullable projectID ) : ObjectResult
projectID Nullable
return ObjectResult

sp_Project_Update() public method

public sp_Project_Update ( Nullable projectID, string projectName, string projectDesc, Nullable addrID, Nullable activeFlg ) : int
projectID Nullable
projectName string
projectDesc string
addrID Nullable
activeFlg Nullable
return int

sp_Sample_Address_Delete() public method

public sp_Sample_Address_Delete ( Nullable addrID ) : int
addrID Nullable
return int

sp_Sample_Address_Insert() public method

public sp_Sample_Address_Insert ( string addrLine1, string addrLine2, string addrLine3, string city, string st, Nullable zip, Nullable zip4, Nullable activeFlg ) : int
addrLine1 string
addrLine2 string
addrLine3 string
city string
st string
zip Nullable
zip4 Nullable
activeFlg Nullable
return int

sp_Sample_Address_Select() public method

public sp_Sample_Address_Select ( ) : ObjectResult
return ObjectResult

sp_Sample_Address_Update() public method

public sp_Sample_Address_Update ( Nullable addrID, string addrLine1, string addrLine2, string addrLine3, string city, string st, Nullable zip, Nullable zip4, Nullable activeFlg ) : int
addrID Nullable
addrLine1 string
addrLine2 string
addrLine3 string
city string
st string
zip Nullable
zip4 Nullable
activeFlg Nullable
return int

sp_Skill_Delete() public method

public sp_Skill_Delete ( Nullable skillID ) : int
skillID Nullable
return int

sp_Skill_Insert() public method

public sp_Skill_Insert ( string skillName, Nullable mstrSkillID, Nullable reqCert ) : ObjectResult>
skillName string
mstrSkillID Nullable
reqCert Nullable
return ObjectResult>

sp_Skill_Select() public method

public sp_Skill_Select ( Nullable skillID ) : ObjectResult
skillID Nullable
return ObjectResult

sp_Skill_Select_Manage() public method

public sp_Skill_Select_Manage ( Nullable showNullMstrSkillItems ) : ObjectResult
showNullMstrSkillItems Nullable
return ObjectResult

sp_Skill_Update() public method

public sp_Skill_Update ( Nullable skillID, string skillName, Nullable mstrSkillID, Nullable reqCert ) : int
skillID Nullable
skillName string
mstrSkillID Nullable
reqCert Nullable
return int

sp_Vend_Address_Delete() public method

public sp_Vend_Address_Delete ( Nullable addrID ) : int
addrID Nullable
return int

sp_Vend_Address_Insert() public method

public sp_Vend_Address_Insert ( string addrLine1, string addrLine2, string addrLine3, string city, string st, Nullable zip, Nullable zip4, string geoCodeGetSet, Nullable activeFlg ) : ObjectResult>
addrLine1 string
addrLine2 string
addrLine3 string
city string
st string
zip Nullable
zip4 Nullable
geoCodeGetSet string
activeFlg Nullable
return ObjectResult>

sp_Vend_Address_MassUpdate() public method

public sp_Vend_Address_MassUpdate ( string xML_IN ) : int
xML_IN string
return int

sp_Vend_Address_Select() public method

public sp_Vend_Address_Select ( Nullable addrID ) : ObjectResult
addrID Nullable
return ObjectResult

sp_Vend_Address_Update() public method

public sp_Vend_Address_Update ( Nullable addrId, Nullable activeFlg, string addrLine1, string addrLine2, string addrLine3, string city, string st, Nullable zip, Nullable zip4, string geoCodeGetSet ) : int
addrId Nullable
activeFlg Nullable
addrLine1 string
addrLine2 string
addrLine3 string
city string
st string
zip Nullable
zip4 Nullable
geoCodeGetSet string
return int

sp_Vend_Contact_Delete() public method

public sp_Vend_Contact_Delete ( Nullable vendorID, Nullable contactID ) : int
vendorID Nullable
contactID Nullable
return int

sp_Vend_Contact_Insert() public method

public sp_Vend_Contact_Insert ( Nullable vendorID, Nullable contactID, Nullable primaryContact ) : ObjectResult>
vendorID Nullable
contactID Nullable
primaryContact Nullable
return ObjectResult>

sp_Vend_Contact_Select() public method

public sp_Vend_Contact_Select ( Nullable vendorID, Nullable contactID ) : ObjectResult
vendorID Nullable
contactID Nullable
return ObjectResult

sp_Vend_Contact_Update() public method

public sp_Vend_Contact_Update ( Nullable vendorID, Nullable contactID, Nullable primaryContact ) : int
vendorID Nullable
contactID Nullable
primaryContact Nullable
return int

sp_Vend_Email_Delete() public method

public sp_Vend_Email_Delete ( Nullable emailID ) : int
emailID Nullable
return int

sp_Vend_Email_Insert() public method

public sp_Vend_Email_Insert ( Nullable emailID, string emailAddr, Nullable activeFlg ) : int
emailID Nullable
emailAddr string
activeFlg Nullable
return int

sp_Vend_Email_MassUpdate() public method

public sp_Vend_Email_MassUpdate ( string xML_IN ) : int
xML_IN string
return int

sp_Vend_Email_Select() public method

public sp_Vend_Email_Select ( Nullable emailID, Nullable activeFlg ) : ObjectResult
emailID Nullable
activeFlg Nullable
return ObjectResult

sp_Vend_Email_Update() public method

public sp_Vend_Email_Update ( Nullable emailID, string emailAddr, Nullable activeFlg ) : int
emailID Nullable
emailAddr string
activeFlg Nullable
return int

sp_VendorAddr_Delete() public method

public sp_VendorAddr_Delete ( Nullable vendorID ) : int
vendorID Nullable
return int

sp_VendorAddr_Insert() public method

public sp_VendorAddr_Insert ( Nullable addrID, Nullable hQ ) : ObjectResult>
addrID Nullable
hQ Nullable
return ObjectResult>

sp_VendorAddr_Select() public method

public sp_VendorAddr_Select ( Nullable vendorID ) : ObjectResult
vendorID Nullable
return ObjectResult

sp_VendorAddr_Update() public method

public sp_VendorAddr_Update ( Nullable vendorID, Nullable addrID, Nullable hQ ) : int
vendorID Nullable
addrID Nullable
hQ Nullable
return int

sp_VendorProjContact_Delete() public method

public sp_VendorProjContact_Delete ( Nullable vendorID, Nullable projectID, Nullable contactID ) : int
vendorID Nullable
projectID Nullable
contactID Nullable
return int

sp_VendorProjContact_Insert() public method

public sp_VendorProjContact_Insert ( Nullable vendorID, Nullable projectID, Nullable contactID, Nullable primaryContact ) : int
vendorID Nullable
projectID Nullable
contactID Nullable
primaryContact Nullable
return int

sp_VendorProjContact_Select() public method

public sp_VendorProjContact_Select ( Nullable vendorID, Nullable projectID, Nullable contactID ) : ObjectResult
vendorID Nullable
projectID Nullable
contactID Nullable
return ObjectResult

sp_VendorProjContact_Update() public method

public sp_VendorProjContact_Update ( Nullable vendorID, Nullable projectID, Nullable contactID, Nullable primaryContact ) : int
vendorID Nullable
projectID Nullable
contactID Nullable
primaryContact Nullable
return int

sp_Vendor_Delete() public method

public sp_Vendor_Delete ( Nullable vendorID ) : int
vendorID Nullable
return int

sp_Vendor_Insert() public method

public sp_Vendor_Insert ( Nullable vendorID, string vendorName ) : ObjectResult>
vendorID Nullable
vendorName string
return ObjectResult>

sp_Vendor_Select() public method

public sp_Vendor_Select ( Nullable vendorID ) : ObjectResult
vendorID Nullable
return ObjectResult

sp_VolSkill_DeleteAll() public method

public sp_VolSkill_DeleteAll ( Nullable volID ) : int
volID Nullable
return int

sp_VolSkill_Insert() public method

public sp_VolSkill_Insert ( Nullable volID, Nullable skillID ) : int
volID Nullable
skillID Nullable
return int

sp_VolSkill_Select() public method

public sp_VolSkill_Select ( Nullable volID ) : ObjectResult
volID Nullable
return ObjectResult

sp_Vol_Addr_Delete() public method

public sp_Vol_Addr_Delete ( Nullable volID, Nullable addrID ) : int
volID Nullable
addrID Nullable
return int

sp_Vol_Addr_Insert() public method

public sp_Vol_Addr_Insert ( Nullable volID, Nullable addrID, Nullable primaryAddr ) : int
volID Nullable
addrID Nullable
primaryAddr Nullable
return int

sp_Vol_Addr_Update() public method

public sp_Vol_Addr_Update ( Nullable volID, Nullable addrID, Nullable primaryAddr ) : int
volID Nullable
addrID Nullable
primaryAddr Nullable
return int

sp_Vol_Address_Delete() public method

public sp_Vol_Address_Delete ( Nullable addrID ) : int
addrID Nullable
return int

sp_Vol_Address_MassUpdate() public method

public sp_Vol_Address_MassUpdate ( string xML_IN ) : int
xML_IN string
return int

sp_Vol_Address_Select() public method

public sp_Vol_Address_Select ( Nullable volID, Nullable addrID, Nullable primaryAddr ) : ObjectResult
volID Nullable
addrID Nullable
primaryAddr Nullable
return ObjectResult

sp_Vol_Address_Update() public method

public sp_Vol_Address_Update ( Nullable addrId, Nullable activeFlg, string addrLine1, string addrLine2, string addrLine3, string city, string st, Nullable zip, Nullable zip4, string geoCodeGetSet ) : int
addrId Nullable
activeFlg Nullable
addrLine1 string
addrLine2 string
addrLine3 string
city string
st string
zip Nullable
zip4 Nullable
geoCodeGetSet string
return int

sp_Vol_Email_Delete() public method

public sp_Vol_Email_Delete ( Nullable emailID, Nullable volID, string emailAddr, Nullable activeFlg, Nullable primaryFlg ) : int
emailID Nullable
volID Nullable
emailAddr string
activeFlg Nullable
primaryFlg Nullable
return int

sp_Vol_Email_Insert() public method

public sp_Vol_Email_Insert ( Nullable volID, string emailAddr, Nullable activeFlg, Nullable primaryFlg ) : ObjectResult>
volID Nullable
emailAddr string
activeFlg Nullable
primaryFlg Nullable
return ObjectResult>

sp_Vol_Email_Select() public method

public sp_Vol_Email_Select ( Nullable volID, Nullable emailID, Nullable primaryFlg ) : ObjectResult
volID Nullable
emailID Nullable
primaryFlg Nullable
return ObjectResult

sp_Vol_Email_Update() public method

public sp_Vol_Email_Update ( Nullable emailID, Nullable volID, string emailAddr, Nullable activeFlg, Nullable primaryFlg ) : int
emailID Nullable
volID Nullable
emailAddr string
activeFlg Nullable
primaryFlg Nullable
return int

sp_Vol_Phone_Delete() public method

public sp_Vol_Phone_Delete ( Nullable phoneID, string phoneNbr, Nullable activeFlg ) : int
phoneID Nullable
phoneNbr string
activeFlg Nullable
return int

sp_Vol_Phone_Insert() public method

public sp_Vol_Phone_Insert ( Nullable volID, string phoneNbr, Nullable activeFlg, Nullable primaryFlg ) : ObjectResult
volID Nullable
phoneNbr string
activeFlg Nullable
primaryFlg Nullable
return ObjectResult

sp_Vol_Phone_Select() public method

public sp_Vol_Phone_Select ( Nullable volID, Nullable phoneID, Nullable primaryFlg ) : ObjectResult
volID Nullable
phoneID Nullable
primaryFlg Nullable
return ObjectResult

sp_Vol_Phone_Update() public method

public sp_Vol_Phone_Update ( Nullable phoneID, Nullable volID, string phoneNbr, Nullable activeFlg, Nullable primaryFlg ) : int
phoneID Nullable
volID Nullable
phoneNbr string
activeFlg Nullable
primaryFlg Nullable
return int

sp_Vol_State_Select() public method

public sp_Vol_State_Select ( ) : ObjectResult
return ObjectResult

sp_Volunteer_Delete() public method

public sp_Volunteer_Delete ( Nullable volID ) : int
volID Nullable
return int

sp_Volunteer_Insert() public method

public sp_Volunteer_Insert ( Nullable volID, string volFirstName, string volMiddleName, string volLastName ) : ObjectResult>
volID Nullable
volFirstName string
volMiddleName string
volLastName string
return ObjectResult>

sp_Volunteer_Select() public method

public sp_Volunteer_Select ( Nullable volID ) : ObjectResult
volID Nullable
return ObjectResult

sp_Volunteer_Update() public method

public sp_Volunteer_Update ( Nullable volID, Nullable activeFlg, string volFirstName, string volMiddleName, string volLastName ) : int
volID Nullable
activeFlg Nullable
volFirstName string
volMiddleName string
volLastName string
return int

sp_alterdiagram() public method

public sp_alterdiagram ( string diagramname, Nullable owner_id, Nullable version, byte definition ) : int
diagramname string
owner_id Nullable
version Nullable
definition byte
return int

sp_creatediagram() public method

public sp_creatediagram ( string diagramname, Nullable owner_id, Nullable version, byte definition ) : int
diagramname string
owner_id Nullable
version Nullable
definition byte
return int

sp_dropdiagram() public method

public sp_dropdiagram ( string diagramname, Nullable owner_id ) : int
diagramname string
owner_id Nullable
return int

sp_helpdiagramdefinition() public method

public sp_helpdiagramdefinition ( string diagramname, Nullable owner_id ) : ObjectResult
diagramname string
owner_id Nullable
return ObjectResult

sp_helpdiagrams() public method

public sp_helpdiagrams ( string diagramname, Nullable owner_id ) : ObjectResult
diagramname string
owner_id Nullable
return ObjectResult

sp_renamediagram() public method

public sp_renamediagram ( string diagramname, Nullable owner_id, string new_diagramname ) : int
diagramname string
owner_id Nullable
new_diagramname string
return int

sp_upgraddiagrams() public method

public sp_upgraddiagrams ( ) : int
return int