public class BudgetItemConfigurations : EntityTypeConfiguration<BudgetItem>
    {
        public BudgetItemConfigurations()
        {
            this.HasOptional(x => x.BudgetItemParent).
                WithMany().HasForeignKey(x => x.ParentID);

            this.HasOptional(x => x.Responsible_Employee).
                WithMany().HasForeignKey(x => x.Responsible_EmployeeConstID);


            this.MapToStoredProcedures(
                bi => bi
                .Insert(sp => sp.HasName("EditFin_DirBudgetItems").//Parameter(p => p.ID, "ID").
                    Parameter(p => p.ParentID, "ParentID").
                    Parameter(p => p.Code, "Code").
                    Parameter(p => p.Description, "Description").
                    Parameter(p => p.IsIncome, "isIncome").
                    Parameter(p => p.Responsible_EmployeeConstID, "Responsible_EmployeeConstID").
                    Parameter(p => p.SessionsID, "SessionsID").
                    Parameter(p => p.RowDate, "RowDate").
                    Parameter(p => p.RowStatus, "RowStatus").Result(rs => rs.ID, "ID"))
                .Update(sp => sp.HasName("EditFin_DirBudgetItems").Parameter(p => p.ID, "ID").
                    Parameter(p => p.ParentID, "ParentID").
                    Parameter(p => p.Code, "Code").
                    Parameter(p => p.Description, "Description").
                    Parameter(p => p.IsIncome, "isIncome").
                    Parameter(p => p.Responsible_EmployeeConstID, "Responsible_EmployeeConstID").
                    Parameter(p => p.SessionsID, "SessionsID").
                    Parameter(p => p.RowDate, "RowDate").
                    Parameter(p => p.RowStatus, "RowStatus"))
                .Delete(sp => sp.HasName("EditFin_DirBudgetItems").Parameter(p => p.ID, "ID").
                    Parameter(p => p.ParentID, "ParentID").
                    Parameter(p => p.Code, "Code").
                    Parameter(p => p.Description, "Description").
                    Parameter(p => p.IsIncome, "isIncome").
                    Parameter(p => p.Responsible_EmployeeConstID, "Responsible_EmployeeConstID").
                    Parameter(p => p.SessionsID, "SessionsID").
                    Parameter(p => p.RowDate, "RowDate").
                    Parameter(p => p.RowStatus, "RowStatus"))
                );
        }
    }