<?xml version="1.0" encoding="utf-8"?> <xs:schema id="payroll_dbDataSet" targetNamespace="http://tempuri.org/payroll_dbDataSet.xsd" xmlns:mstns="http://tempuri.org/payroll_dbDataSet.xsd" xmlns="http://tempuri.org/payroll_dbDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified"> <xs:annotation> <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource"> <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <Connections> <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="payroll_dbConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="payroll_dbConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Payroll.Properties.Settings.GlobalReference.Default.payroll_dbConnectionString" Provider="System.Data.SqlClient" /> </Connections> <Tables> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Current_EmployeesTableAdapter" GeneratorDataComponentClassName="Current_EmployeesTableAdapter" Name="Current_Employees" UserDataComponentName="Current_EmployeesTableAdapter"> <MainSource> <DbSource ConnectionRef="payroll_dbConnectionString (Settings)" DbObjectName="dbo.Current_Employees" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill"> <DeleteCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>DELETE FROM [dbo].[Current_Employees] WHERE (([Employee ID] = @Original_Employee_ID) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_Date_of_Birth = 1 AND [Date of Birth] IS NULL) OR ([Date of Birth] = @Original_Date_of_Birth)) AND ((@IsNull_Age = 1 AND [Age] IS NULL) OR ([Age] = @Original_Age)) AND ((@IsNull_Phone_Number = 1 AND [Phone Number] IS NULL) OR ([Phone Number] = @Original_Phone_Number)) AND ((@IsNull_State = 1 AND [State] IS NULL) OR ([State] = @Original_State)) AND ((@IsNull_Gender = 1 AND [Gender] IS NULL) OR ([Gender] = @Original_Gender)) AND ((@IsNull_Dependents = 1 AND [Dependents] IS NULL) OR ([Dependents] = @Original_Dependents)) AND ((@IsNull_Job_Title = 1 AND [Job Title] IS NULL) OR ([Job Title] = @Original_Job_Title)) AND ((@IsNull_Hourly_Rate = 1 AND [Hourly Rate] IS NULL) OR ([Hourly Rate] = @Original_Hourly_Rate)) AND ((@IsNull_Salary = 1 AND [Salary] IS NULL) OR ([Salary] = @Original_Salary)) AND ((@IsNull_Net_income = 1 AND [Net income] IS NULL) OR ([Net income] = @Original_Net_income)) AND ((@IsNull_Gross_income = 1 AND [Gross income] IS NULL) OR ([Gross income] = @Original_Gross_income)) AND ((@p3 = 1 AND [401K] IS NULL) OR ([401K] = @p2)))</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Employee_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Employee ID" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Date_of_Birth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Date of Birth" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Date_of_Birth" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date of Birth" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Age" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Age" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Age" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Age" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone_Number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone Number" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone_Number" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone Number" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_State" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_State" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Gender" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Gender" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Dependents" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dependents" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Dependents" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dependents" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Job_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Job_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hourly_Rate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hourly Rate" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hourly_Rate" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Hourly Rate" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Salary" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Salary" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Salary" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Salary" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Net_income" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Net income" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Net_income" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Net income" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Gross_income" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Gross income" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Gross_income" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Gross income" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="401K" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="401K" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </DeleteCommand> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>INSERT INTO [dbo].[Current_Employees] ([Employee ID], [Password], [Name], [Date of Birth], [Age], [Phone Number], [Address], [State], [Gender], [Benefits], [Dependents], [Job Title], [Hourly Rate], [Salary], [Net income], [Gross income], [401K]) VALUES (@Employee_ID, @Password, @Name, @Date_of_Birth, @Age, @Phone_Number, @Address, @State, @Gender, @Benefits, @Dependents, @Job_Title, @Hourly_Rate, @Salary, @Net_income, @Gross_income, @p1); SELECT [Employee ID], Password, Name, [Date of Birth], Age, [Phone Number], Address, State, Gender, Benefits, Dependents, [Job Title], [Hourly Rate], Salary, [Net income], [Gross income], [401K] FROM Current_Employees WHERE ([Employee ID] = @Employee_ID)</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Employee_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Employee ID" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Date_of_Birth" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date of Birth" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Age" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Age" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone_Number" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone Number" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@State" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Gender" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Benefits" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Benefits" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Dependents" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dependents" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Job_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hourly_Rate" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Hourly Rate" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Salary" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Salary" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Net_income" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Net income" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Gross_income" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Gross income" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="401K" SourceColumnNullMapping="false" SourceVersion="Current" /> </Parameters> </DbCommand> </InsertCommand> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>SELECT [Employee ID], Password, Name, [Date of Birth], Age, [Phone Number], Address, State, Gender, Benefits, Dependents, [Job Title], [Hourly Rate], Salary, [Net income], [Gross income], [401K] FROM dbo.Current_Employees</CommandText> <Parameters /> </DbCommand> </SelectCommand> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>UPDATE [dbo].[Current_Employees] SET [Employee ID] = @Employee_ID, [Password] = @Password, [Name] = @Name, [Date of Birth] = @Date_of_Birth, [Age] = @Age, [Phone Number] = @Phone_Number, [Address] = @Address, [State] = @State, [Gender] = @Gender, [Benefits] = @Benefits, [Dependents] = @Dependents, [Job Title] = @Job_Title, [Hourly Rate] = @Hourly_Rate, [Salary] = @Salary, [Net income] = @Net_income, [Gross income] = @Gross_income, [401K] = @p1 WHERE (([Employee ID] = @Original_Employee_ID) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_Date_of_Birth = 1 AND [Date of Birth] IS NULL) OR ([Date of Birth] = @Original_Date_of_Birth)) AND ((@IsNull_Age = 1 AND [Age] IS NULL) OR ([Age] = @Original_Age)) AND ((@IsNull_Phone_Number = 1 AND [Phone Number] IS NULL) OR ([Phone Number] = @Original_Phone_Number)) AND ((@IsNull_State = 1 AND [State] IS NULL) OR ([State] = @Original_State)) AND ((@IsNull_Gender = 1 AND [Gender] IS NULL) OR ([Gender] = @Original_Gender)) AND ((@IsNull_Dependents = 1 AND [Dependents] IS NULL) OR ([Dependents] = @Original_Dependents)) AND ((@IsNull_Job_Title = 1 AND [Job Title] IS NULL) OR ([Job Title] = @Original_Job_Title)) AND ((@IsNull_Hourly_Rate = 1 AND [Hourly Rate] IS NULL) OR ([Hourly Rate] = @Original_Hourly_Rate)) AND ((@IsNull_Salary = 1 AND [Salary] IS NULL) OR ([Salary] = @Original_Salary)) AND ((@IsNull_Net_income = 1 AND [Net income] IS NULL) OR ([Net income] = @Original_Net_income)) AND ((@IsNull_Gross_income = 1 AND [Gross income] IS NULL) OR ([Gross income] = @Original_Gross_income)) AND ((@p3 = 1 AND [401K] IS NULL) OR ([401K] = @p2))); SELECT [Employee ID], Password, Name, [Date of Birth], Age, [Phone Number], Address, State, Gender, Benefits, Dependents, [Job Title], [Hourly Rate], Salary, [Net income], [Gross income], [401K] FROM Current_Employees WHERE ([Employee ID] = @Employee_ID)</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Employee_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Employee ID" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Date_of_Birth" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date of Birth" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Age" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Age" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone_Number" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone Number" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@State" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Gender" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Benefits" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Benefits" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Dependents" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dependents" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Job_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hourly_Rate" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Hourly Rate" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Salary" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Salary" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Net_income" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Net income" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Gross_income" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Gross income" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="401K" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Employee_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Employee ID" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Date_of_Birth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Date of Birth" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Date_of_Birth" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date of Birth" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Age" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Age" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Age" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Age" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone_Number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone Number" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone_Number" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone Number" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_State" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_State" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Gender" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Gender" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Dependents" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dependents" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Dependents" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dependents" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Job_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Job_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hourly_Rate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hourly Rate" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hourly_Rate" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Hourly Rate" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Salary" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Salary" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Salary" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Salary" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Net_income" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Net income" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Net_income" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Net income" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Gross_income" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Gross income" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Gross_income" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Gross income" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="401K" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="401K" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </UpdateCommand> </DbSource> </MainSource> <Mappings> <Mapping SourceColumn="Employee ID" DataSetColumn="Employee ID" /> <Mapping SourceColumn="Password" DataSetColumn="Password" /> <Mapping SourceColumn="Name" DataSetColumn="Name" /> <Mapping SourceColumn="Date of Birth" DataSetColumn="Date of Birth" /> <Mapping SourceColumn="Age" DataSetColumn="Age" /> <Mapping SourceColumn="Phone Number" DataSetColumn="Phone Number" /> <Mapping SourceColumn="Address" DataSetColumn="Address" /> <Mapping SourceColumn="State" DataSetColumn="State" /> <Mapping SourceColumn="Gender" DataSetColumn="Gender" /> <Mapping SourceColumn="Benefits" DataSetColumn="Benefits" /> <Mapping SourceColumn="Dependents" DataSetColumn="Dependents" /> <Mapping SourceColumn="Job Title" DataSetColumn="Job Title" /> <Mapping SourceColumn="Hourly Rate" DataSetColumn="Hourly Rate" /> <Mapping SourceColumn="Salary" DataSetColumn="Salary" /> <Mapping SourceColumn="Net income" DataSetColumn="Net income" /> <Mapping SourceColumn="Gross income" DataSetColumn="Gross income" /> <Mapping SourceColumn="401K" DataSetColumn="401K" /> </Mappings> <Sources /> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PaycheckTableAdapter" GeneratorDataComponentClassName="PaycheckTableAdapter" Name="Paycheck" UserDataComponentName="PaycheckTableAdapter"> <MainSource> <DbSource ConnectionRef="payroll_dbConnectionString (Settings)" DbObjectName="dbo.Paycheck" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill"> <DeleteCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>DELETE FROM [dbo].[Paycheck] WHERE (([Employee ID] = @Original_Employee_ID) AND ((@IsNull_Hours = 1 AND [Hours] IS NULL) OR ([Hours] = @Original_Hours)) AND ((@IsNull_Paid_Hours = 1 AND [Paid Hours] IS NULL) OR ([Paid Hours] = @Original_Paid_Hours)) AND ((@IsNull_Tax_Deductions = 1 AND [Tax Deductions] IS NULL) OR ([Tax Deductions] = @Original_Tax_Deductions)) AND ((@IsNull_Benefit_Deductions = 1 AND [Benefit Deductions] IS NULL) OR ([Benefit Deductions] = @Original_Benefit_Deductions)))</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Employee_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Employee ID" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hours" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hours" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hours" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Hours" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Paid_Hours" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Paid Hours" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Paid_Hours" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Paid Hours" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tax_Deductions" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tax Deductions" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Tax_Deductions" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Tax Deductions" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Benefit_Deductions" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Benefit Deductions" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Benefit_Deductions" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Benefit Deductions" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </DeleteCommand> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>INSERT INTO [dbo].[Paycheck] ([Employee ID], [Hours], [Paid Hours], [Tax Deductions], [Benefit Deductions]) VALUES (@Employee_ID, @Hours, @Paid_Hours, @Tax_Deductions, @Benefit_Deductions); SELECT [Employee ID], Hours, [Paid Hours], [Tax Deductions], [Benefit Deductions] FROM Paycheck WHERE ([Employee ID] = @Employee_ID)</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Employee_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Employee ID" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hours" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Hours" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Paid_Hours" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Paid Hours" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Tax_Deductions" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Tax Deductions" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Benefit_Deductions" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Benefit Deductions" SourceColumnNullMapping="false" SourceVersion="Current" /> </Parameters> </DbCommand> </InsertCommand> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>SELECT [Employee ID], Hours, [Paid Hours], [Tax Deductions], [Benefit Deductions] FROM dbo.Paycheck</CommandText> <Parameters /> </DbCommand> </SelectCommand> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>UPDATE [dbo].[Paycheck] SET [Employee ID] = @Employee_ID, [Hours] = @Hours, [Paid Hours] = @Paid_Hours, [Tax Deductions] = @Tax_Deductions, [Benefit Deductions] = @Benefit_Deductions WHERE (([Employee ID] = @Original_Employee_ID) AND ((@IsNull_Hours = 1 AND [Hours] IS NULL) OR ([Hours] = @Original_Hours)) AND ((@IsNull_Paid_Hours = 1 AND [Paid Hours] IS NULL) OR ([Paid Hours] = @Original_Paid_Hours)) AND ((@IsNull_Tax_Deductions = 1 AND [Tax Deductions] IS NULL) OR ([Tax Deductions] = @Original_Tax_Deductions)) AND ((@IsNull_Benefit_Deductions = 1 AND [Benefit Deductions] IS NULL) OR ([Benefit Deductions] = @Original_Benefit_Deductions))); SELECT [Employee ID], Hours, [Paid Hours], [Tax Deductions], [Benefit Deductions] FROM Paycheck WHERE ([Employee ID] = @Employee_ID)</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Employee_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Employee ID" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hours" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Hours" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Paid_Hours" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Paid Hours" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Tax_Deductions" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Tax Deductions" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Benefit_Deductions" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Benefit Deductions" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Employee_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Employee ID" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hours" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hours" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hours" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Hours" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Paid_Hours" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Paid Hours" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Paid_Hours" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Paid Hours" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tax_Deductions" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tax Deductions" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Tax_Deductions" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Tax Deductions" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Benefit_Deductions" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Benefit Deductions" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Benefit_Deductions" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Benefit Deductions" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </UpdateCommand> </DbSource> </MainSource> <Mappings> <Mapping SourceColumn="Employee ID" DataSetColumn="Employee ID" /> <Mapping SourceColumn="Hours" DataSetColumn="Hours" /> <Mapping SourceColumn="Paid Hours" DataSetColumn="Paid Hours" /> <Mapping SourceColumn="Tax Deductions" DataSetColumn="Tax Deductions" /> <Mapping SourceColumn="Benefit Deductions" DataSetColumn="Benefit Deductions" /> </Mappings> <Sources /> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RequestsTableAdapter" GeneratorDataComponentClassName="RequestsTableAdapter" Name="Requests" UserDataComponentName="RequestsTableAdapter"> <MainSource> <DbSource ConnectionRef="payroll_dbConnectionString (Settings)" DbObjectName="dbo.Requests" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill"> <DeleteCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>DELETE FROM [dbo].[Requests] WHERE (([Employee ID] = @Original_Employee_ID) AND ((@IsNull_Solved = 1 AND [Solved] IS NULL) OR ([Solved] = @Original_Solved)))</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Employee_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Employee ID" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Solved" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Solved" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Solved" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Solved" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </DeleteCommand> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>INSERT INTO [dbo].[Requests] ([Employee ID], [Issue], [Solved]) VALUES (@Employee_ID, @Issue, @Solved); SELECT [Employee ID], Issue, Solved FROM Requests WHERE ([Employee ID] = @Employee_ID)</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Employee_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Employee ID" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Issue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Issue" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Solved" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Solved" SourceColumnNullMapping="false" SourceVersion="Current" /> </Parameters> </DbCommand> </InsertCommand> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>SELECT [Employee ID], Issue, Solved FROM dbo.Requests</CommandText> <Parameters /> </DbCommand> </SelectCommand> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>UPDATE [dbo].[Requests] SET [Employee ID] = @Employee_ID, [Issue] = @Issue, [Solved] = @Solved WHERE (([Employee ID] = @Original_Employee_ID) AND ((@IsNull_Solved = 1 AND [Solved] IS NULL) OR ([Solved] = @Original_Solved))); SELECT [Employee ID], Issue, Solved FROM Requests WHERE ([Employee ID] = @Employee_ID)</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Employee_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Employee ID" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Issue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Issue" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Solved" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Solved" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Employee_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Employee ID" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Solved" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Solved" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Solved" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Solved" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </UpdateCommand> </DbSource> </MainSource> <Mappings> <Mapping SourceColumn="Employee ID" DataSetColumn="Employee ID" /> <Mapping SourceColumn="Issue" DataSetColumn="Issue" /> <Mapping SourceColumn="Solved" DataSetColumn="Solved" /> </Mappings> <Sources /> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Retired_EmployeesTableAdapter" GeneratorDataComponentClassName="Retired_EmployeesTableAdapter" Name="Retired_Employees" UserDataComponentName="Retired_EmployeesTableAdapter"> <MainSource> <DbSource ConnectionRef="payroll_dbConnectionString (Settings)" DbObjectName="dbo.Retired_Employees" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill"> <DeleteCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>DELETE FROM [dbo].[Retired_Employees] WHERE (([Employee ID] = @Original_Employee_ID) AND ((@IsNull_Date_of_Birth = 1 AND [Date of Birth] IS NULL) OR ([Date of Birth] = @Original_Date_of_Birth)) AND ((@IsNull_Age = 1 AND [Age] IS NULL) OR ([Age] = @Original_Age)) AND ((@IsNull_Phone_Nunber = 1 AND [Phone Nunber] IS NULL) OR ([Phone Nunber] = @Original_Phone_Nunber)) AND ((@IsNull_State = 1 AND [State] IS NULL) OR ([State] = @Original_State)) AND ((@IsNull_Gender = 1 AND [Gender] IS NULL) OR ([Gender] = @Original_Gender)) AND ((@IsNull_Dependents = 1 AND [Dependents] IS NULL) OR ([Dependents] = @Original_Dependents)) AND ((@IsNull_Job_Title = 1 AND [Job Title] IS NULL) OR ([Job Title] = @Original_Job_Title)) AND ((@IsNull_Net_Income = 1 AND [Net Income] IS NULL) OR ([Net Income] = @Original_Net_Income)) AND ((@IsNull_Gross_Income = 1 AND [Gross Income] IS NULL) OR ([Gross Income] = @Original_Gross_Income)) AND ((@p3 = 1 AND [401K] IS NULL) OR ([401K] = @p2)) AND ((@IsNull_Pension = 1 AND [Pension] IS NULL) OR ([Pension] = @Original_Pension)))</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Employee_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Employee ID" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Date_of_Birth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Date of Birth" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Date_of_Birth" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Date of Birth" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Age" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Age" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Age" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Age" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone_Nunber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone Nunber" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone_Nunber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone Nunber" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_State" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_State" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Gender" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Gender" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Dependents" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dependents" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Dependents" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dependents" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Job_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Job_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Net_Income" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Net Income" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Net_Income" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Net Income" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Gross_Income" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Gross Income" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Gross_Income" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Gross Income" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="401K" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="401K" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Pension" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pension" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Pension" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Pension" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </DeleteCommand> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>INSERT INTO [dbo].[Retired_Employees] ([Employee ID], [Date of Birth], [Age], [Phone Nunber], [Address], [State], [Gender], [Benefits], [Dependents], [Job Title], [Net Income], [Gross Income], [401K], [Pension]) VALUES (@Employee_ID, @Date_of_Birth, @Age, @Phone_Nunber, @Address, @State, @Gender, @Benefits, @Dependents, @Job_Title, @Net_Income, @Gross_Income, @p1, @Pension); SELECT [Employee ID], [Date of Birth], Age, [Phone Nunber], Address, State, Gender, Benefits, Dependents, [Job Title], [Net Income], [Gross Income], [401K], Pension FROM Retired_Employees WHERE ([Employee ID] = @Employee_ID)</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Employee_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Employee ID" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Date_of_Birth" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Date of Birth" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Age" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Age" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone_Nunber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone Nunber" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@State" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Gender" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Benefits" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Benefits" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Dependents" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dependents" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Job_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Net_Income" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Net Income" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Gross_Income" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Gross Income" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="401K" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Pension" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Pension" SourceColumnNullMapping="false" SourceVersion="Current" /> </Parameters> </DbCommand> </InsertCommand> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>SELECT [Employee ID], [Date of Birth], Age, [Phone Nunber], Address, State, Gender, Benefits, Dependents, [Job Title], [Net Income], [Gross Income], [401K], Pension FROM dbo.Retired_Employees</CommandText> <Parameters /> </DbCommand> </SelectCommand> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>UPDATE [dbo].[Retired_Employees] SET [Employee ID] = @Employee_ID, [Date of Birth] = @Date_of_Birth, [Age] = @Age, [Phone Nunber] = @Phone_Nunber, [Address] = @Address, [State] = @State, [Gender] = @Gender, [Benefits] = @Benefits, [Dependents] = @Dependents, [Job Title] = @Job_Title, [Net Income] = @Net_Income, [Gross Income] = @Gross_Income, [401K] = @p1, [Pension] = @Pension WHERE (([Employee ID] = @Original_Employee_ID) AND ((@IsNull_Date_of_Birth = 1 AND [Date of Birth] IS NULL) OR ([Date of Birth] = @Original_Date_of_Birth)) AND ((@IsNull_Age = 1 AND [Age] IS NULL) OR ([Age] = @Original_Age)) AND ((@IsNull_Phone_Nunber = 1 AND [Phone Nunber] IS NULL) OR ([Phone Nunber] = @Original_Phone_Nunber)) AND ((@IsNull_State = 1 AND [State] IS NULL) OR ([State] = @Original_State)) AND ((@IsNull_Gender = 1 AND [Gender] IS NULL) OR ([Gender] = @Original_Gender)) AND ((@IsNull_Dependents = 1 AND [Dependents] IS NULL) OR ([Dependents] = @Original_Dependents)) AND ((@IsNull_Job_Title = 1 AND [Job Title] IS NULL) OR ([Job Title] = @Original_Job_Title)) AND ((@IsNull_Net_Income = 1 AND [Net Income] IS NULL) OR ([Net Income] = @Original_Net_Income)) AND ((@IsNull_Gross_Income = 1 AND [Gross Income] IS NULL) OR ([Gross Income] = @Original_Gross_Income)) AND ((@p3 = 1 AND [401K] IS NULL) OR ([401K] = @p2)) AND ((@IsNull_Pension = 1 AND [Pension] IS NULL) OR ([Pension] = @Original_Pension))); SELECT [Employee ID], [Date of Birth], Age, [Phone Nunber], Address, State, Gender, Benefits, Dependents, [Job Title], [Net Income], [Gross Income], [401K], Pension FROM Retired_Employees WHERE ([Employee ID] = @Employee_ID)</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Employee_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Employee ID" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Date_of_Birth" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Date of Birth" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Age" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Age" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone_Nunber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone Nunber" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@State" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Gender" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Benefits" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Benefits" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Dependents" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dependents" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Job_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Net_Income" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Net Income" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Gross_Income" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Gross Income" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="401K" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Pension" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Pension" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Employee_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Employee ID" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Date_of_Birth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Date of Birth" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Date_of_Birth" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Date of Birth" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Age" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Age" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Age" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Age" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone_Nunber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone Nunber" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone_Nunber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone Nunber" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_State" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_State" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Gender" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Gender" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Dependents" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dependents" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Dependents" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dependents" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Job_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Job_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Net_Income" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Net Income" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Net_Income" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Net Income" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Gross_Income" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Gross Income" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Gross_Income" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Gross Income" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="401K" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="401K" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Pension" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pension" SourceColumnNullMapping="true" SourceVersion="Original" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Pension" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Pension" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </UpdateCommand> </DbSource> </MainSource> <Mappings> <Mapping SourceColumn="Employee ID" DataSetColumn="Employee ID" /> <Mapping SourceColumn="Date of Birth" DataSetColumn="Date of Birth" /> <Mapping SourceColumn="Age" DataSetColumn="Age" /> <Mapping SourceColumn="Phone Nunber" DataSetColumn="Phone Nunber" /> <Mapping SourceColumn="Address" DataSetColumn="Address" /> <Mapping SourceColumn="State" DataSetColumn="State" /> <Mapping SourceColumn="Gender" DataSetColumn="Gender" /> <Mapping SourceColumn="Benefits" DataSetColumn="Benefits" /> <Mapping SourceColumn="Dependents" DataSetColumn="Dependents" /> <Mapping SourceColumn="Job Title" DataSetColumn="Job Title" /> <Mapping SourceColumn="Net Income" DataSetColumn="Net Income" /> <Mapping SourceColumn="Gross Income" DataSetColumn="Gross Income" /> <Mapping SourceColumn="401K" DataSetColumn="401K" /> <Mapping SourceColumn="Pension" DataSetColumn="Pension" /> </Mappings> <Sources /> </TableAdapter> </Tables> <Sources /> </DataSource> </xs:appinfo> </xs:annotation> <xs:element name="payroll_dbDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="payroll_dbDataSet" msprop:Generator_UserDSName="payroll_dbDataSet"> <xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="Current_Employees" msprop:Generator_TableClassName="Current_EmployeesDataTable" msprop:Generator_TableVarName="tableCurrent_Employees" msprop:Generator_TablePropName="Current_Employees" msprop:Generator_RowDeletingName="Current_EmployeesRowDeleting" msprop:Generator_RowChangingName="Current_EmployeesRowChanging" msprop:Generator_RowEvHandlerName="Current_EmployeesRowChangeEventHandler" msprop:Generator_RowDeletedName="Current_EmployeesRowDeleted" msprop:Generator_UserTableName="Current_Employees" msprop:Generator_RowChangedName="Current_EmployeesRowChanged" msprop:Generator_RowEvArgName="Current_EmployeesRowChangeEvent" msprop:Generator_RowClassName="Current_EmployeesRow"> <xs:complexType> <xs:sequence> <xs:element name="Employee_x0020_ID" msprop:Generator_ColumnVarNameInTable="columnEmployee_ID" msprop:Generator_ColumnPropNameInRow="Employee_ID" msprop:Generator_ColumnPropNameInTable="Employee_IDColumn" msprop:Generator_UserColumnName="Employee ID" type="xs:int" /> <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password" type="xs:int" minOccurs="0" /> <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Date_x0020_of_x0020_Birth" msprop:Generator_ColumnVarNameInTable="columnDate_of_Birth" msprop:Generator_ColumnPropNameInRow="Date_of_Birth" msprop:Generator_ColumnPropNameInTable="Date_of_BirthColumn" msprop:Generator_UserColumnName="Date of Birth" type="xs:dateTime" minOccurs="0" /> <xs:element name="Age" msprop:Generator_ColumnVarNameInTable="columnAge" msprop:Generator_ColumnPropNameInRow="Age" msprop:Generator_ColumnPropNameInTable="AgeColumn" msprop:Generator_UserColumnName="Age" type="xs:int" minOccurs="0" /> <xs:element name="Phone_x0020_Number" msprop:Generator_ColumnVarNameInTable="columnPhone_Number" msprop:Generator_ColumnPropNameInRow="Phone_Number" msprop:Generator_ColumnPropNameInTable="Phone_NumberColumn" msprop:Generator_UserColumnName="Phone Number" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="State" msprop:Generator_ColumnVarNameInTable="columnState" msprop:Generator_ColumnPropNameInRow="State" msprop:Generator_ColumnPropNameInTable="StateColumn" msprop:Generator_UserColumnName="State" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Gender" msprop:Generator_ColumnVarNameInTable="columnGender" msprop:Generator_ColumnPropNameInRow="Gender" msprop:Generator_ColumnPropNameInTable="GenderColumn" msprop:Generator_UserColumnName="Gender" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Benefits" msprop:Generator_ColumnVarNameInTable="columnBenefits" msprop:Generator_ColumnPropNameInRow="Benefits" msprop:Generator_ColumnPropNameInTable="BenefitsColumn" msprop:Generator_UserColumnName="Benefits" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Dependents" msprop:Generator_ColumnVarNameInTable="columnDependents" msprop:Generator_ColumnPropNameInRow="Dependents" msprop:Generator_ColumnPropNameInTable="DependentsColumn" msprop:Generator_UserColumnName="Dependents" type="xs:int" minOccurs="0" /> <xs:element name="Job_x0020_Title" msprop:Generator_ColumnVarNameInTable="columnJob_Title" msprop:Generator_ColumnPropNameInRow="Job_Title" msprop:Generator_ColumnPropNameInTable="Job_TitleColumn" msprop:Generator_UserColumnName="Job Title" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Hourly_x0020_Rate" msprop:Generator_ColumnVarNameInTable="columnHourly_Rate" msprop:Generator_ColumnPropNameInRow="Hourly_Rate" msprop:Generator_ColumnPropNameInTable="Hourly_RateColumn" msprop:Generator_UserColumnName="Hourly Rate" type="xs:decimal" minOccurs="0" /> <xs:element name="Salary" msprop:Generator_ColumnVarNameInTable="columnSalary" msprop:Generator_ColumnPropNameInRow="Salary" msprop:Generator_ColumnPropNameInTable="SalaryColumn" msprop:Generator_UserColumnName="Salary" type="xs:decimal" minOccurs="0" /> <xs:element name="Net_x0020_income" msprop:Generator_ColumnVarNameInTable="columnNet_income" msprop:Generator_ColumnPropNameInRow="Net_income" msprop:Generator_ColumnPropNameInTable="Net_incomeColumn" msprop:Generator_UserColumnName="Net income" type="xs:decimal" minOccurs="0" /> <xs:element name="Gross_x0020_income" msprop:Generator_ColumnVarNameInTable="columnGross_income" msprop:Generator_ColumnPropNameInRow="Gross_income" msprop:Generator_ColumnPropNameInTable="Gross_incomeColumn" msprop:Generator_UserColumnName="Gross income" type="xs:decimal" minOccurs="0" /> <xs:element name="_x0034_01K" msprop:Generator_ColumnVarNameInTable="column401K" msprop:Generator_ColumnPropNameInRow="_401K" msprop:Generator_ColumnPropNameInTable="_401KColumn" msprop:Generator_UserColumnName="401K" type="xs:boolean" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Paycheck" msprop:Generator_TableClassName="PaycheckDataTable" msprop:Generator_TableVarName="tablePaycheck" msprop:Generator_TablePropName="Paycheck" msprop:Generator_RowDeletingName="PaycheckRowDeleting" msprop:Generator_RowChangingName="PaycheckRowChanging" msprop:Generator_RowEvHandlerName="PaycheckRowChangeEventHandler" msprop:Generator_RowDeletedName="PaycheckRowDeleted" msprop:Generator_UserTableName="Paycheck" msprop:Generator_RowChangedName="PaycheckRowChanged" msprop:Generator_RowEvArgName="PaycheckRowChangeEvent" msprop:Generator_RowClassName="PaycheckRow"> <xs:complexType> <xs:sequence> <xs:element name="Employee_x0020_ID" msprop:Generator_ColumnVarNameInTable="columnEmployee_ID" msprop:Generator_ColumnPropNameInRow="Employee_ID" msprop:Generator_ColumnPropNameInTable="Employee_IDColumn" msprop:Generator_UserColumnName="Employee ID"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Hours" msprop:Generator_ColumnVarNameInTable="columnHours" msprop:Generator_ColumnPropNameInRow="Hours" msprop:Generator_ColumnPropNameInTable="HoursColumn" msprop:Generator_UserColumnName="Hours" type="xs:decimal" minOccurs="0" /> <xs:element name="Paid_x0020_Hours" msprop:Generator_ColumnVarNameInTable="columnPaid_Hours" msprop:Generator_ColumnPropNameInRow="Paid_Hours" msprop:Generator_ColumnPropNameInTable="Paid_HoursColumn" msprop:Generator_UserColumnName="Paid Hours" type="xs:decimal" minOccurs="0" /> <xs:element name="Tax_x0020_Deductions" msprop:Generator_ColumnVarNameInTable="columnTax_Deductions" msprop:Generator_ColumnPropNameInRow="Tax_Deductions" msprop:Generator_ColumnPropNameInTable="Tax_DeductionsColumn" msprop:Generator_UserColumnName="Tax Deductions" type="xs:decimal" minOccurs="0" /> <xs:element name="Benefit_x0020_Deductions" msprop:Generator_ColumnVarNameInTable="columnBenefit_Deductions" msprop:Generator_ColumnPropNameInRow="Benefit_Deductions" msprop:Generator_ColumnPropNameInTable="Benefit_DeductionsColumn" msprop:Generator_UserColumnName="Benefit Deductions" type="xs:decimal" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Requests" msprop:Generator_TableClassName="RequestsDataTable" msprop:Generator_TableVarName="tableRequests" msprop:Generator_TablePropName="Requests" msprop:Generator_RowDeletingName="RequestsRowDeleting" msprop:Generator_RowChangingName="RequestsRowChanging" msprop:Generator_RowEvHandlerName="RequestsRowChangeEventHandler" msprop:Generator_RowDeletedName="RequestsRowDeleted" msprop:Generator_UserTableName="Requests" msprop:Generator_RowChangedName="RequestsRowChanged" msprop:Generator_RowEvArgName="RequestsRowChangeEvent" msprop:Generator_RowClassName="RequestsRow"> <xs:complexType> <xs:sequence> <xs:element name="Employee_x0020_ID" msprop:Generator_ColumnVarNameInTable="columnEmployee_ID" msprop:Generator_ColumnPropNameInRow="Employee_ID" msprop:Generator_ColumnPropNameInTable="Employee_IDColumn" msprop:Generator_UserColumnName="Employee ID"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Issue" msprop:Generator_ColumnVarNameInTable="columnIssue" msprop:Generator_ColumnPropNameInRow="Issue" msprop:Generator_ColumnPropNameInTable="IssueColumn" msprop:Generator_UserColumnName="Issue" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Solved" msprop:Generator_ColumnVarNameInTable="columnSolved" msprop:Generator_ColumnPropNameInRow="Solved" msprop:Generator_ColumnPropNameInTable="SolvedColumn" msprop:Generator_UserColumnName="Solved" type="xs:boolean" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Retired_Employees" msprop:Generator_TableClassName="Retired_EmployeesDataTable" msprop:Generator_TableVarName="tableRetired_Employees" msprop:Generator_TablePropName="Retired_Employees" msprop:Generator_RowDeletingName="Retired_EmployeesRowDeleting" msprop:Generator_RowChangingName="Retired_EmployeesRowChanging" msprop:Generator_RowEvHandlerName="Retired_EmployeesRowChangeEventHandler" msprop:Generator_RowDeletedName="Retired_EmployeesRowDeleted" msprop:Generator_UserTableName="Retired_Employees" msprop:Generator_RowChangedName="Retired_EmployeesRowChanged" msprop:Generator_RowEvArgName="Retired_EmployeesRowChangeEvent" msprop:Generator_RowClassName="Retired_EmployeesRow"> <xs:complexType> <xs:sequence> <xs:element name="Employee_x0020_ID" msprop:Generator_ColumnVarNameInTable="columnEmployee_ID" msprop:Generator_ColumnPropNameInRow="Employee_ID" msprop:Generator_ColumnPropNameInTable="Employee_IDColumn" msprop:Generator_UserColumnName="Employee ID" type="xs:int" /> <xs:element name="Date_x0020_of_x0020_Birth" msprop:Generator_ColumnVarNameInTable="columnDate_of_Birth" msprop:Generator_ColumnPropNameInRow="Date_of_Birth" msprop:Generator_ColumnPropNameInTable="Date_of_BirthColumn" msprop:Generator_UserColumnName="Date of Birth" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Age" msprop:Generator_ColumnVarNameInTable="columnAge" msprop:Generator_ColumnPropNameInRow="Age" msprop:Generator_ColumnPropNameInTable="AgeColumn" msprop:Generator_UserColumnName="Age" type="xs:int" minOccurs="0" /> <xs:element name="Phone_x0020_Nunber" msprop:Generator_ColumnVarNameInTable="columnPhone_Nunber" msprop:Generator_ColumnPropNameInRow="Phone_Nunber" msprop:Generator_ColumnPropNameInTable="Phone_NunberColumn" msprop:Generator_UserColumnName="Phone Nunber" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="State" msprop:Generator_ColumnVarNameInTable="columnState" msprop:Generator_ColumnPropNameInRow="State" msprop:Generator_ColumnPropNameInTable="StateColumn" msprop:Generator_UserColumnName="State" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Gender" msprop:Generator_ColumnVarNameInTable="columnGender" msprop:Generator_ColumnPropNameInRow="Gender" msprop:Generator_ColumnPropNameInTable="GenderColumn" msprop:Generator_UserColumnName="Gender" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Benefits" msprop:Generator_ColumnVarNameInTable="columnBenefits" msprop:Generator_ColumnPropNameInRow="Benefits" msprop:Generator_ColumnPropNameInTable="BenefitsColumn" msprop:Generator_UserColumnName="Benefits" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Dependents" msprop:Generator_ColumnVarNameInTable="columnDependents" msprop:Generator_ColumnPropNameInRow="Dependents" msprop:Generator_ColumnPropNameInTable="DependentsColumn" msprop:Generator_UserColumnName="Dependents" type="xs:int" minOccurs="0" /> <xs:element name="Job_x0020_Title" msprop:Generator_ColumnVarNameInTable="columnJob_Title" msprop:Generator_ColumnPropNameInRow="Job_Title" msprop:Generator_ColumnPropNameInTable="Job_TitleColumn" msprop:Generator_UserColumnName="Job Title" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Net_x0020_Income" msprop:Generator_ColumnVarNameInTable="columnNet_Income" msprop:Generator_ColumnPropNameInRow="Net_Income" msprop:Generator_ColumnPropNameInTable="Net_IncomeColumn" msprop:Generator_UserColumnName="Net Income" type="xs:decimal" minOccurs="0" /> <xs:element name="Gross_x0020_Income" msprop:Generator_ColumnVarNameInTable="columnGross_Income" msprop:Generator_ColumnPropNameInRow="Gross_Income" msprop:Generator_ColumnPropNameInTable="Gross_IncomeColumn" msprop:Generator_UserColumnName="Gross Income" type="xs:decimal" minOccurs="0" /> <xs:element name="_x0034_01K" msprop:Generator_ColumnVarNameInTable="column401K" msprop:Generator_ColumnPropNameInRow="_401K" msprop:Generator_ColumnPropNameInTable="_401KColumn" msprop:Generator_UserColumnName="401K" type="xs:boolean" minOccurs="0" /> <xs:element name="Pension" msprop:Generator_ColumnVarNameInTable="columnPension" msprop:Generator_ColumnPropNameInRow="Pension" msprop:Generator_ColumnPropNameInTable="PensionColumn" msprop:Generator_UserColumnName="Pension" type="xs:decimal" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> <xs:unique name="Constraint1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Current_Employees" /> <xs:field xpath="mstns:Employee_x0020_ID" /> </xs:unique> <xs:unique name="Paycheck_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Paycheck" /> <xs:field xpath="mstns:Employee_x0020_ID" /> </xs:unique> <xs:unique name="Requests_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Requests" /> <xs:field xpath="mstns:Employee_x0020_ID" /> </xs:unique> <xs:unique name="Retired_Employees_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Retired_Employees" /> <xs:field xpath="mstns:Employee_x0020_ID" /> </xs:unique> </xs:element> </xs:schema>